PREVIEW / stock_5min / 2003-01-21
file: by_date/stock_5min/2003/2003-01-21.parquet size: 1.9 MB rows: 135,079 symbols: 1,536
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 |
|---|---|---|---|---|---|---|---|
| 2003-01-21 08:20:00 | AAPL | Stock | 0.2527 | 0.2527 | 0.2527 | 0.2527 | 33600.0 |
| 2003-01-21 08:40:00 | AAPL | Stock | 0.2527 | 0.2527 | 0.2527 | 0.2527 | 56000.0 |
| 2003-01-21 08:55:00 | AAPL | Stock | 0.2527 | 0.2527 | 0.2527 | 0.2527 | 56000.0 |
| 2003-01-21 09:05:00 | AAPL | Stock | 0.2536 | 0.2536 | 0.2536 | 0.2536 | 16800.0 |
| 2003-01-21 09:25:00 | AAPL | Stock | 0.2536 | 0.2536 | 0.2536 | 0.2536 | 431200.0 |
| 2003-01-21 09:30:00 | AAPL | Stock | 0.2538 | 0.2571 | 0.2532 | 0.2563 | 14517776.0 |
| 2003-01-21 09:35:00 | AAPL | Stock | 0.257 | 0.2573 | 0.2557 | 0.2566 | 8836800.0 |
| 2003-01-21 09:40:00 | AAPL | Stock | 0.2566 | 0.2568 | 0.2554 | 0.2557 | 5252800.0 |
| 2003-01-21 09:45:00 | AAPL | Stock | 0.2555 | 0.2561 | 0.2552 | 0.2557 | 2753968.0 |
| 2003-01-21 09:50:00 | AAPL | Stock | 0.2561 | 0.2563 | 0.2548 | 0.2548 | 3286528.0 |
| 2003-01-21 09:55:00 | AAPL | Stock | 0.2548 | 0.2554 | 0.2546 | 0.2552 | 2384312.0 |
| 2003-01-21 10:00:00 | AAPL | Stock | 0.2548 | 0.2548 | 0.2539 | 0.2543 | 2816800.0 |
| 2003-01-21 10:05:00 | AAPL | Stock | 0.2543 | 0.2545 | 0.2541 | 0.2543 | 4058544.0 |
| 2003-01-21 10:10:00 | AAPL | Stock | 0.2543 | 0.255 | 0.2543 | 0.255 | 3878000.0 |
| 2003-01-21 10:15:00 | AAPL | Stock | 0.2547 | 0.2552 | 0.2541 | 0.2548 | 1937600.0 |
| 2003-01-21 10:20:00 | AAPL | Stock | 0.2548 | 0.2555 | 0.2548 | 0.2552 | 2314592.0 |
| 2003-01-21 10:25:00 | AAPL | Stock | 0.2552 | 0.2556 | 0.255 | 0.2552 | 1506400.0 |
| 2003-01-21 10:30:00 | AAPL | Stock | 0.2552 | 0.2552 | 0.2543 | 0.2546 | 3183040.0 |
| 2003-01-21 10:35:00 | AAPL | Stock | 0.2548 | 0.2548 | 0.2545 | 0.2545 | 1696744.0 |
| 2003-01-21 10:40:00 | AAPL | Stock | 0.2543 | 0.2546 | 0.2527 | 0.2529 | 3421600.0 |
| 2003-01-21 10:45:00 | AAPL | Stock | 0.2529 | 0.253 | 0.2527 | 0.2529 | 2457728.0 |
| 2003-01-21 10:50:00 | AAPL | Stock | 0.2529 | 0.2538 | 0.2529 | 0.253 | 1976464.0 |
| 2003-01-21 10:55:00 | AAPL | Stock | 0.253 | 0.2536 | 0.253 | 0.2536 | 1161048.0 |
| 2003-01-21 11:00:00 | AAPL | Stock | 0.2538 | 0.2541 | 0.2536 | 0.2541 | 873600.0 |
| 2003-01-21 11:05:00 | AAPL | Stock | 0.2539 | 0.2541 | 0.2532 | 0.2532 | 2080344.0 |
| 2003-01-21 11:10:00 | AAPL | Stock | 0.2532 | 0.2534 | 0.253 | 0.2534 | 1850016.0 |
| 2003-01-21 11:15:00 | AAPL | Stock | 0.2536 | 0.2536 | 0.253 | 0.2532 | 1562400.0 |
| 2003-01-21 11:20:00 | AAPL | Stock | 0.2532 | 0.2536 | 0.253 | 0.2532 | 1996680.0 |
| 2003-01-21 11:25:00 | AAPL | Stock | 0.2532 | 0.2538 | 0.2532 | 0.2537 | 2094400.0 |
| 2003-01-21 11:30:00 | AAPL | Stock | 0.2536 | 0.2539 | 0.2534 | 0.2539 | 2356200.0 |
| 2003-01-21 11:35:00 | AAPL | Stock | 0.2538 | 0.2543 | 0.253 | 0.2536 | 4860800.0 |
| 2003-01-21 11:40:00 | AAPL | Stock | 0.2538 | 0.2539 | 0.2536 | 0.2536 | 1293600.0 |
| 2003-01-21 11:45:00 | AAPL | Stock | 0.2538 | 0.2539 | 0.2534 | 0.2536 | 1090992.0 |
| 2003-01-21 11:50:00 | AAPL | Stock | 0.2536 | 0.2541 | 0.2534 | 0.2538 | 1131200.0 |
| 2003-01-21 11:55:00 | AAPL | Stock | 0.2539 | 0.2541 | 0.2536 | 0.2538 | 3316320.0 |
| 2003-01-21 12:00:00 | AAPL | Stock | 0.2541 | 0.2543 | 0.2538 | 0.2541 | 1814400.0 |
| 2003-01-21 12:05:00 | AAPL | Stock | 0.2539 | 0.2546 | 0.2538 | 0.2543 | 2049600.0 |
| 2003-01-21 12:10:00 | AAPL | Stock | 0.2545 | 0.2546 | 0.2541 | 0.2546 | 2484664.0 |
| 2003-01-21 12:15:00 | AAPL | Stock | 0.2545 | 0.255 | 0.2539 | 0.2546 | 1237264.0 |
| 2003-01-21 12:20:00 | AAPL | Stock | 0.2546 | 0.255 | 0.2545 | 0.2546 | 3069192.0 |
| 2003-01-21 12:25:00 | AAPL | Stock | 0.2545 | 0.2546 | 0.2536 | 0.2539 | 1410528.0 |
| 2003-01-21 12:30:00 | AAPL | Stock | 0.2541 | 0.2541 | 0.2536 | 0.2538 | 1310400.0 |
| 2003-01-21 12:35:00 | AAPL | Stock | 0.2538 | 0.2543 | 0.2536 | 0.2543 | 1089648.0 |
| 2003-01-21 12:40:00 | AAPL | Stock | 0.2541 | 0.2543 | 0.2539 | 0.2539 | 592200.0 |
| 2003-01-21 12:45:00 | AAPL | Stock | 0.2539 | 0.2541 | 0.2536 | 0.2538 | 1120112.0 |
| 2003-01-21 12:50:00 | AAPL | Stock | 0.2536 | 0.2543 | 0.2536 | 0.2541 | 1506400.0 |
| 2003-01-21 12:55:00 | AAPL | Stock | 0.2541 | 0.255 | 0.2541 | 0.255 | 2402400.0 |
| 2003-01-21 13:00:00 | AAPL | Stock | 0.255 | 0.2561 | 0.255 | 0.2557 | 1298472.0 |
| 2003-01-21 13:05:00 | AAPL | Stock | 0.2557 | 0.2557 | 0.2546 | 0.2546 | 2008048.0 |
| 2003-01-21 13:10:00 | AAPL | Stock | 0.2548 | 0.2555 | 0.2548 | 0.2555 | 1064000.0 |
> showing 50 of 135,079 rows — these rows as CSV