ATM Cash Withdrawal Patterns

This dataset provides detailed records of ATM cash withdrawal transactions, including transaction amounts, timestamps, ATM locations, card and account types, and ATM cash balances. It is ideal for analyzing cash demand patterns, optimizing ATM restocking schedules, and understanding customer withdrawal behaviors across different locations and time periods.

  • last updated 12 Jul 2025
  • by GoMask
The brief that made it

Analyzing cash demand trends to optimize ATM restocking schedules

Sample rows

preview · 8 of 100 rows · all 20 columns
transaction_idstringaccount_typestringwithdrawal_amountfloatis_foreign_cardbooleanatm_citystringatm_idstringatm_location_namestringatm_street_addressstringatm_statestringatm_postal_codestringatm_countrystringtransaction_datetimedatetimecurrency_codestringcard_typestringcustomer_idstringtransaction_statusstringatm_balance_afterfloatatm_capacityfloatfee_appliedfloatrestock_event_idstring
TXN100001checking80falseSpringfieldATM001Downtown Branch101 Main StIL62701USA2024-05-01T09:22:13USDdebitCUST1001successful4920100000RESTOCK20240425
TXN100002savings40falseMadisonATM002Mall Center2200 Southgate AveWI53713USA2024-05-01T10:35:46USDcreditCUST1002successful198050002RESTOCK20240427
TXN100003checking100trueAtlantaATM003Airport Terminal B300 Airport RdGA30337USA2024-05-01T11:07:51USDdebitCUST1003successful240060004RESTOCK20240428
TXN100004savings60falseSpringfieldATM001Downtown Branch101 Main StIL62701USA2024-05-01T13:41:10USDprepaidCUST1004successful4860100001RESTOCK20240425
TXN100005business200falseDenverATM004Westside Shop54 West StCO80219USA2024-05-01T15:18:34USDdebitCUST1005successful680080000RESTOCK20240430
TXN100006checking20falseNew YorkATM005Northside Plaza700 North AveNY10027USA2024-05-01T16:02:22USDdebitCUST1006successful9980120000RESTOCK20240429
TXN100007checking120trueSpringfieldATM001Downtown Branch101 Main StIL62701USA2024-05-01T17:48:15USDcreditCUST1007successful4740100003RESTOCK20240425
TXN100008checking60falseMadisonATM002Mall Center2200 Southgate AveWI53713USA2024-05-01T18:02:38USDdebitCUST1008failed198050000RESTOCK20240427

What the 100 rows show

from the 100-row sample

Business (account type) stands out: mean withdrawal_amount is 243.8, against 81.5 for the rest.

  • 26%is_foreign_card = true
  • 80median withdrawal_amount
  • 2atm countries
  • 2currency codes
  • 3transaction statuses
  • 4card types
Mean withdrawal_amount by account_type100 rows
020040086.0checking60 rows73.5savings20 rows243.8business13 rows65.7other7 rows
withdrawal_amount100 rows, in bands of 50
0204020382149330110250500withdrawal_amount →

Median 80, from 20 to 500.

atm_city100 rows · top 10 of 36 values
  1. Springfield8
  2. Madison8
  3. Atlanta8
  4. Toronto8
  5. Denver7
  6. New York7
  7. Los Angeles6
  8. Portland6
  9. Miami5
  10. Vancouver4
20 columns by typefrom the column list below
  • string 14
  • float 4
  • datetime 1
  • boolean 1

Columns

20 columns in four groups
blueprint · 20 columns
columntypedescriptionexample
Text 14 columns
transaction_idstringUnique identifier for each ATM withdrawal transactionuniqueTXN100001
atm_idstringUnique identifier for the ATM where the transaction occurredATM001
atm_location_namestringName or description of the ATM location (e.g., branch name, mall name)optionalDowntown Branch
atm_street_addressstringStreet address of the ATMoptional101 Main St
atm_citystringCity where the ATM is locatedoptionalSpringfield
atm_statestringState or province where the ATM is locatedoptionalIL
atm_postal_codestringPostal or ZIP code of the ATM locationoptional62701
atm_countrystringCountry where the ATM is located2 countries · optionalUSA
currency_codestringISO 4217 currency code for the withdrawal (e.g., USD, EUR)2 codesUSD
card_typestringType of card used for withdrawal (e.g., debit, credit, prepaid)debit · credit · prepaid · other · optionaldebit
customer_idstringUnique identifier for the customer making the withdrawal (anonymized)optionalCUST1001
account_typestringType of account from which cash was withdrawn (e.g., checking, savings, business)checking · savings · business · other · optionalchecking
transaction_statusstringStatus of the transaction (e.g., successful, failed, cancelled)successful · failed · cancelledsuccessful
restock_event_idstringIdentifier for the most recent ATM restocking event prior to this transactionoptionalRESTOCK20240425
Numbers 4 columns
withdrawal_amountfloatAmount of cash withdrawn in the transaction (in local currency)0.01 or more80
atm_balance_afterfloatAmount of cash remaining in the ATM immediately after the transaction0 or more · optional4920
atm_capacityfloatMaximum cash holding capacity of the ATM0 or more · optional10000
fee_appliedfloatFee charged to the customer for the withdrawal (if any)0 or more · optional0
Dates and times 1 column
transaction_datetimedatetimeDate and time when the withdrawal transaction occurred2024-05-01T09:22:13
True or false 1 column
is_foreign_cardbooleanIndicates if the card used is issued by a foreign bankoptionalfalse

Use it for

  • is foreign card26%26 of 100 rowsmean withdrawal amoun…86.0chec…73.5savi…243.8busi…65.7other

    A finance dashboard

    The is_foreign_card rate, withdrawal_amount by account_type and a breakdown of atm_city. Excel, Power BI or Tableau.

  • Why do the 13 business rows have a mean withdrawal_amount of 243.8?

    A root-cause class exercise

    Hand out the rows and one question. The answer is in the data, not in the brief.

  • A software demo

    Believable transactions with atm_id, atm_location_name and atm_street_address to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 20 columns, your size and your rules. See 20 rows before you pay.

Preview 20 rows free

1,000 rows: $1.99 · 10,000: $12.99One-time. No subscription. All prices

This dataset100 rows20 columns
Yours1,000 rows20 columnsatm_location_name: UK only

blueprint · atm-cash-withdrawal-patterns

Behind this dataset

Same schema. As many rows as you need.

These 100 rows came out of a blueprint — 20 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.

Rules it was built with
  • Record transaction amount and timestamp
  • Log location and ATM ID
  • Flag withdrawals exceeding daily limits
  • Summarize daily cash outflows
  • Identify peak transaction hours
Rows
Open the blueprint in Data Factory

1 credit per row. New accounts start with 25 free credits.

Exports
CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
Licence
yours to use, including commercially
API slug
atm-cash-withdrawal-patterns

More in Finance

Browse all
Also in FinanceATM Usage and Failure EventsPersonal Finance Budgeting RecordsFinance Expense Categorization DatasetAll 1,954 datasets

What should your data show?

Preview 20 rows free
No signup. No card.