PREVIEW / stock_5min / 2002-09-13
file: by_date/stock_5min/2002/2002-09-13.parquet size: 1.7 MB rows: 120,137 symbols: 1,464
schema
timestamp TIMESTAMP symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| timestamp | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2002-09-13 08:35:00 | AAPL | Stock | 0.2525 | 0.2527 | 0.2525 | 0.2527 | 352800.0 |
| 2002-09-13 08:45:00 | AAPL | Stock | 0.2527 | 0.2527 | 0.2527 | 0.2527 | 28000.0 |
| 2002-09-13 08:55:00 | AAPL | Stock | 0.2527 | 0.2527 | 0.2527 | 0.2527 | 106400.0 |
| 2002-09-13 09:00:00 | AAPL | Stock | 0.2532 | 0.2532 | 0.2532 | 0.2532 | 33600.0 |
| 2002-09-13 09:10:00 | AAPL | Stock | 0.2532 | 0.2532 | 0.2532 | 0.2532 | 50400.0 |
| 2002-09-13 09:20:00 | AAPL | Stock | 0.2521 | 0.2521 | 0.2521 | 0.2521 | 168000.0 |
| 2002-09-13 09:25:00 | AAPL | Stock | 0.2525 | 0.2525 | 0.2521 | 0.2521 | 235200.0 |
| 2002-09-13 09:30:00 | AAPL | Stock | 0.2523 | 0.254 | 0.2523 | 0.253 | 6518400.0 |
| 2002-09-13 09:35:00 | AAPL | Stock | 0.2534 | 0.255 | 0.253 | 0.2548 | 9335200.0 |
| 2002-09-13 09:40:00 | AAPL | Stock | 0.2548 | 0.2559 | 0.2543 | 0.2552 | 11682384.0 |
| 2002-09-13 09:45:00 | AAPL | Stock | 0.255 | 0.2554 | 0.2545 | 0.2545 | 4900000.0 |
| 2002-09-13 09:50:00 | AAPL | Stock | 0.2545 | 0.2552 | 0.2536 | 0.2541 | 7036680.0 |
| 2002-09-13 09:55:00 | AAPL | Stock | 0.2541 | 0.255 | 0.2539 | 0.2546 | 4226432.0 |
| 2002-09-13 10:00:00 | AAPL | Stock | 0.2546 | 0.255 | 0.2545 | 0.2545 | 5292000.0 |
| 2002-09-13 10:05:00 | AAPL | Stock | 0.2546 | 0.2554 | 0.2541 | 0.2552 | 6938400.0 |
| 2002-09-13 10:10:00 | AAPL | Stock | 0.2552 | 0.2561 | 0.2548 | 0.2548 | 2604000.0 |
| 2002-09-13 10:15:00 | AAPL | Stock | 0.2548 | 0.255 | 0.2545 | 0.2548 | 6645912.0 |
| 2002-09-13 10:20:00 | AAPL | Stock | 0.2546 | 0.2548 | 0.2545 | 0.2548 | 2270744.0 |
| 2002-09-13 10:25:00 | AAPL | Stock | 0.2548 | 0.2548 | 0.2543 | 0.2543 | 2509192.0 |
| 2002-09-13 10:30:00 | AAPL | Stock | 0.2543 | 0.2548 | 0.2539 | 0.2539 | 5056352.0 |
| 2002-09-13 10:35:00 | AAPL | Stock | 0.2538 | 0.2545 | 0.2536 | 0.2543 | 3819200.0 |
| 2002-09-13 10:40:00 | AAPL | Stock | 0.2543 | 0.2543 | 0.2534 | 0.2539 | 1310400.0 |
| 2002-09-13 10:45:00 | AAPL | Stock | 0.2538 | 0.2538 | 0.2523 | 0.2527 | 9834720.0 |
| 2002-09-13 10:50:00 | AAPL | Stock | 0.2527 | 0.2532 | 0.2525 | 0.2527 | 3673600.0 |
| 2002-09-13 10:55:00 | AAPL | Stock | 0.2527 | 0.2534 | 0.2525 | 0.253 | 2610720.0 |
| 2002-09-13 11:00:00 | AAPL | Stock | 0.2529 | 0.2532 | 0.2529 | 0.2532 | 2167200.0 |
| 2002-09-13 11:05:00 | AAPL | Stock | 0.2532 | 0.2536 | 0.253 | 0.2532 | 732200.0 |
| 2002-09-13 11:10:00 | AAPL | Stock | 0.2532 | 0.2534 | 0.253 | 0.253 | 3460800.0 |
| 2002-09-13 11:15:00 | AAPL | Stock | 0.2529 | 0.2532 | 0.2518 | 0.2518 | 7336000.0 |
| 2002-09-13 11:20:00 | AAPL | Stock | 0.2525 | 0.2527 | 0.2513 | 0.252 | 9145416.0 |
| 2002-09-13 11:25:00 | AAPL | Stock | 0.2521 | 0.2534 | 0.252 | 0.2529 | 5863200.0 |
| 2002-09-13 11:30:00 | AAPL | Stock | 0.2532 | 0.2532 | 0.2529 | 0.2532 | 1517600.0 |
| 2002-09-13 11:35:00 | AAPL | Stock | 0.253 | 0.2541 | 0.253 | 0.2538 | 8522976.0 |
| 2002-09-13 11:40:00 | AAPL | Stock | 0.2538 | 0.2541 | 0.2532 | 0.2538 | 1702400.0 |
| 2002-09-13 11:45:00 | AAPL | Stock | 0.2539 | 0.2552 | 0.2539 | 0.2548 | 4227776.0 |
| 2002-09-13 11:50:00 | AAPL | Stock | 0.2548 | 0.255 | 0.2536 | 0.2536 | 4883200.0 |
| 2002-09-13 11:55:00 | AAPL | Stock | 0.2538 | 0.2545 | 0.2536 | 0.2539 | 2592800.0 |
| 2002-09-13 12:00:00 | AAPL | Stock | 0.2538 | 0.2543 | 0.2536 | 0.2541 | 1909600.0 |
| 2002-09-13 12:05:00 | AAPL | Stock | 0.2541 | 0.2543 | 0.2536 | 0.2536 | 353136.0 |
| 2002-09-13 12:10:00 | AAPL | Stock | 0.2538 | 0.2538 | 0.253 | 0.2532 | 2857680.0 |
| 2002-09-13 12:15:00 | AAPL | Stock | 0.253 | 0.2532 | 0.2523 | 0.2525 | 5034400.0 |
| 2002-09-13 12:20:00 | AAPL | Stock | 0.2529 | 0.2529 | 0.2521 | 0.2527 | 7151200.0 |
| 2002-09-13 12:25:00 | AAPL | Stock | 0.2527 | 0.2532 | 0.2518 | 0.2527 | 6267520.0 |
| 2002-09-13 12:30:00 | AAPL | Stock | 0.2527 | 0.2527 | 0.2523 | 0.2525 | 627200.0 |
| 2002-09-13 12:35:00 | AAPL | Stock | 0.2525 | 0.2525 | 0.2518 | 0.2521 | 5747784.0 |
| 2002-09-13 12:40:00 | AAPL | Stock | 0.2521 | 0.2527 | 0.2518 | 0.2523 | 2128000.0 |
| 2002-09-13 12:45:00 | AAPL | Stock | 0.2525 | 0.2529 | 0.2525 | 0.2525 | 2458400.0 |
| 2002-09-13 12:50:00 | AAPL | Stock | 0.2527 | 0.2529 | 0.2523 | 0.2523 | 1079232.0 |
| 2002-09-13 12:55:00 | AAPL | Stock | 0.2527 | 0.2527 | 0.2523 | 0.2525 | 823200.0 |
| 2002-09-13 13:00:00 | AAPL | Stock | 0.2525 | 0.2529 | 0.2521 | 0.2527 | 2102632.0 |
> showing 50 of 120,137 rows — these rows as CSV