PREVIEW / stock_5min / 2003-04-24
file: by_date/stock_5min/2003/2003-04-24.parquet size: 1.9 MB rows: 137,815 symbols: 1,559
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-04-24 08:30:00 | AAPL | Stock | 0.2423 | 0.2423 | 0.2423 | 0.2423 | 28000.0 |
| 2003-04-24 08:45:00 | AAPL | Stock | 0.2411 | 0.2411 | 0.2411 | 0.2411 | 5600.0 |
| 2003-04-24 09:05:00 | AAPL | Stock | 0.2427 | 0.2427 | 0.2411 | 0.2411 | 1556800.0 |
| 2003-04-24 09:25:00 | AAPL | Stock | 0.242 | 0.2425 | 0.2414 | 0.2423 | 778400.0 |
| 2003-04-24 09:30:00 | AAPL | Stock | 0.2414 | 0.2427 | 0.2404 | 0.2414 | 6211240.0 |
| 2003-04-24 09:35:00 | AAPL | Stock | 0.2414 | 0.242 | 0.2412 | 0.2416 | 5485816.0 |
| 2003-04-24 09:40:00 | AAPL | Stock | 0.2418 | 0.243 | 0.2414 | 0.2416 | 5569928.0 |
| 2003-04-24 09:45:00 | AAPL | Stock | 0.2416 | 0.2427 | 0.2405 | 0.2411 | 5941096.0 |
| 2003-04-24 09:50:00 | AAPL | Stock | 0.2411 | 0.2422 | 0.2409 | 0.2413 | 3189200.0 |
| 2003-04-24 09:55:00 | AAPL | Stock | 0.2414 | 0.2414 | 0.2402 | 0.2404 | 3048080.0 |
| 2003-04-24 10:00:00 | AAPL | Stock | 0.2405 | 0.2409 | 0.2402 | 0.2404 | 3533264.0 |
| 2003-04-24 10:05:00 | AAPL | Stock | 0.2404 | 0.2405 | 0.2402 | 0.2405 | 3730552.0 |
| 2003-04-24 10:10:00 | AAPL | Stock | 0.2405 | 0.2409 | 0.2398 | 0.24 | 5569368.0 |
| 2003-04-24 10:15:00 | AAPL | Stock | 0.24 | 0.2407 | 0.2391 | 0.2405 | 8410976.0 |
| 2003-04-24 10:20:00 | AAPL | Stock | 0.2404 | 0.2407 | 0.2393 | 0.2393 | 2382800.0 |
| 2003-04-24 10:25:00 | AAPL | Stock | 0.2391 | 0.2398 | 0.2391 | 0.2395 | 1971144.0 |
| 2003-04-24 10:30:00 | AAPL | Stock | 0.2396 | 0.2398 | 0.2391 | 0.2393 | 2896096.0 |
| 2003-04-24 10:35:00 | AAPL | Stock | 0.2391 | 0.2396 | 0.2389 | 0.2393 | 5420800.0 |
| 2003-04-24 10:40:00 | AAPL | Stock | 0.2393 | 0.2393 | 0.2384 | 0.2388 | 4814320.0 |
| 2003-04-24 10:45:00 | AAPL | Stock | 0.2389 | 0.2391 | 0.238 | 0.238 | 2987600.0 |
| 2003-04-24 10:50:00 | AAPL | Stock | 0.238 | 0.2384 | 0.2366 | 0.2366 | 5165944.0 |
| 2003-04-24 10:55:00 | AAPL | Stock | 0.2368 | 0.2379 | 0.2368 | 0.2375 | 1913744.0 |
| 2003-04-24 11:00:00 | AAPL | Stock | 0.2377 | 0.238 | 0.2375 | 0.2379 | 1786400.0 |
| 2003-04-24 11:05:00 | AAPL | Stock | 0.2382 | 0.2388 | 0.2377 | 0.2384 | 2288216.0 |
| 2003-04-24 11:10:00 | AAPL | Stock | 0.2386 | 0.2389 | 0.2375 | 0.2379 | 2670080.0 |
| 2003-04-24 11:15:00 | AAPL | Stock | 0.2377 | 0.238 | 0.2373 | 0.2373 | 2218832.0 |
| 2003-04-24 11:20:00 | AAPL | Stock | 0.2373 | 0.2375 | 0.237 | 0.2373 | 2136904.0 |
| 2003-04-24 11:25:00 | AAPL | Stock | 0.2373 | 0.2375 | 0.2366 | 0.2368 | 2088800.0 |
| 2003-04-24 11:30:00 | AAPL | Stock | 0.2368 | 0.2373 | 0.2366 | 0.2373 | 1151976.0 |
| 2003-04-24 11:35:00 | AAPL | Stock | 0.2373 | 0.2375 | 0.2366 | 0.2368 | 3231872.0 |
| 2003-04-24 11:40:00 | AAPL | Stock | 0.2368 | 0.237 | 0.2364 | 0.2368 | 3957520.0 |
| 2003-04-24 11:45:00 | AAPL | Stock | 0.2368 | 0.237 | 0.2366 | 0.237 | 1344000.0 |
| 2003-04-24 11:50:00 | AAPL | Stock | 0.237 | 0.2375 | 0.2369 | 0.2374 | 930440.0 |
| 2003-04-24 11:55:00 | AAPL | Stock | 0.2371 | 0.2375 | 0.237 | 0.2371 | 1781920.0 |
| 2003-04-24 12:00:00 | AAPL | Stock | 0.2371 | 0.2373 | 0.2371 | 0.2373 | 660800.0 |
| 2003-04-24 12:05:00 | AAPL | Stock | 0.2371 | 0.2375 | 0.2371 | 0.2375 | 789600.0 |
| 2003-04-24 12:10:00 | AAPL | Stock | 0.2371 | 0.2373 | 0.237 | 0.237 | 841120.0 |
| 2003-04-24 12:15:00 | AAPL | Stock | 0.2368 | 0.237 | 0.2366 | 0.2368 | 1056944.0 |
| 2003-04-24 12:20:00 | AAPL | Stock | 0.237 | 0.237 | 0.2366 | 0.2366 | 262752.0 |
| 2003-04-24 12:25:00 | AAPL | Stock | 0.2368 | 0.2373 | 0.2367 | 0.2372 | 769104.0 |
| 2003-04-24 12:30:00 | AAPL | Stock | 0.2373 | 0.2373 | 0.2371 | 0.2373 | 246400.0 |
| 2003-04-24 12:35:00 | AAPL | Stock | 0.2373 | 0.2375 | 0.2373 | 0.2375 | 560000.0 |
| 2003-04-24 12:40:00 | AAPL | Stock | 0.2375 | 0.2379 | 0.2375 | 0.2378 | 789600.0 |
| 2003-04-24 12:45:00 | AAPL | Stock | 0.2378 | 0.2384 | 0.2377 | 0.2384 | 1470560.0 |
| 2003-04-24 12:50:00 | AAPL | Stock | 0.2384 | 0.2384 | 0.2379 | 0.2379 | 3147200.0 |
| 2003-04-24 12:55:00 | AAPL | Stock | 0.2379 | 0.238 | 0.2377 | 0.2378 | 751632.0 |
| 2003-04-24 13:00:00 | AAPL | Stock | 0.2379 | 0.2384 | 0.2377 | 0.2384 | 1188824.0 |
| 2003-04-24 13:05:00 | AAPL | Stock | 0.2379 | 0.2384 | 0.2373 | 0.2375 | 3799824.0 |
| 2003-04-24 13:10:00 | AAPL | Stock | 0.2375 | 0.2377 | 0.237 | 0.2377 | 2349480.0 |
| 2003-04-24 13:15:00 | AAPL | Stock | 0.2379 | 0.2382 | 0.2377 | 0.2379 | 1696240.0 |
> showing 50 of 137,815 rows — these rows as CSV