PREVIEW / stock_5min / 2002-09-03
file: by_date/stock_5min/2002/2002-09-03.parquet size: 1.8 MB rows: 127,726 symbols: 1,470
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-03 08:00:00 | AAPL | Stock | 0.2633 | 0.2633 | 0.2633 | 0.2633 | 56000.0 |
| 2002-09-03 08:15:00 | AAPL | Stock | 0.2616 | 0.2616 | 0.2616 | 0.2616 | 67200.0 |
| 2002-09-03 08:40:00 | AAPL | Stock | 0.2634 | 0.2634 | 0.2634 | 0.2634 | 1741600.0 |
| 2002-09-03 09:00:00 | AAPL | Stock | 0.2605 | 0.2607 | 0.2605 | 0.2607 | 207200.0 |
| 2002-09-03 09:15:00 | AAPL | Stock | 0.2604 | 0.2634 | 0.2604 | 0.2634 | 1310400.0 |
| 2002-09-03 09:20:00 | AAPL | Stock | 0.2607 | 0.2607 | 0.2605 | 0.2605 | 84000.0 |
| 2002-09-03 09:25:00 | AAPL | Stock | 0.2591 | 0.26 | 0.258 | 0.2586 | 1198400.0 |
| 2002-09-03 09:30:00 | AAPL | Stock | 0.2588 | 0.2598 | 0.2571 | 0.2593 | 5196296.0 |
| 2002-09-03 09:35:00 | AAPL | Stock | 0.2593 | 0.2598 | 0.257 | 0.2584 | 12941264.0 |
| 2002-09-03 09:40:00 | AAPL | Stock | 0.2588 | 0.2598 | 0.258 | 0.2591 | 7222040.0 |
| 2002-09-03 09:45:00 | AAPL | Stock | 0.2589 | 0.2591 | 0.257 | 0.257 | 3340400.0 |
| 2002-09-03 09:50:00 | AAPL | Stock | 0.257 | 0.2577 | 0.257 | 0.2573 | 3925600.0 |
| 2002-09-03 09:55:00 | AAPL | Stock | 0.2577 | 0.258 | 0.257 | 0.2571 | 1746472.0 |
| 2002-09-03 10:00:00 | AAPL | Stock | 0.257 | 0.2575 | 0.2563 | 0.2566 | 5661600.0 |
| 2002-09-03 10:05:00 | AAPL | Stock | 0.2566 | 0.2566 | 0.2554 | 0.2555 | 7916608.0 |
| 2002-09-03 10:10:00 | AAPL | Stock | 0.2554 | 0.2561 | 0.2545 | 0.2545 | 3004400.0 |
| 2002-09-03 10:15:00 | AAPL | Stock | 0.2546 | 0.2552 | 0.2539 | 0.2545 | 5762848.0 |
| 2002-09-03 10:20:00 | AAPL | Stock | 0.2546 | 0.2555 | 0.2546 | 0.2552 | 3892896.0 |
| 2002-09-03 10:25:00 | AAPL | Stock | 0.2554 | 0.2559 | 0.2546 | 0.255 | 3864000.0 |
| 2002-09-03 10:30:00 | AAPL | Stock | 0.2548 | 0.2554 | 0.2546 | 0.255 | 2632000.0 |
| 2002-09-03 10:35:00 | AAPL | Stock | 0.2554 | 0.2554 | 0.2546 | 0.2548 | 1534400.0 |
| 2002-09-03 10:40:00 | AAPL | Stock | 0.2546 | 0.2559 | 0.2546 | 0.2552 | 2733920.0 |
| 2002-09-03 10:45:00 | AAPL | Stock | 0.2552 | 0.2563 | 0.2546 | 0.2561 | 4299120.0 |
| 2002-09-03 10:50:00 | AAPL | Stock | 0.2557 | 0.2557 | 0.2546 | 0.2546 | 3085600.0 |
| 2002-09-03 10:55:00 | AAPL | Stock | 0.2546 | 0.2552 | 0.2546 | 0.2552 | 2031904.0 |
| 2002-09-03 11:00:00 | AAPL | Stock | 0.2548 | 0.2548 | 0.2545 | 0.2546 | 2134104.0 |
| 2002-09-03 11:05:00 | AAPL | Stock | 0.2546 | 0.2552 | 0.2545 | 0.2548 | 2212000.0 |
| 2002-09-03 11:10:00 | AAPL | Stock | 0.2548 | 0.2554 | 0.2546 | 0.2554 | 2189600.0 |
| 2002-09-03 11:15:00 | AAPL | Stock | 0.2554 | 0.2554 | 0.255 | 0.255 | 1676248.0 |
| 2002-09-03 11:20:00 | AAPL | Stock | 0.2548 | 0.2552 | 0.2545 | 0.2545 | 1512000.0 |
| 2002-09-03 11:25:00 | AAPL | Stock | 0.2545 | 0.2552 | 0.2545 | 0.2552 | 1400000.0 |
| 2002-09-03 11:30:00 | AAPL | Stock | 0.2552 | 0.2554 | 0.2545 | 0.2546 | 1624560.0 |
| 2002-09-03 11:35:00 | AAPL | Stock | 0.2545 | 0.255 | 0.2545 | 0.2545 | 694400.0 |
| 2002-09-03 11:40:00 | AAPL | Stock | 0.2546 | 0.255 | 0.2545 | 0.2545 | 1545600.0 |
| 2002-09-03 11:45:00 | AAPL | Stock | 0.2545 | 0.2546 | 0.2536 | 0.2536 | 3826928.0 |
| 2002-09-03 11:50:00 | AAPL | Stock | 0.2538 | 0.2538 | 0.2521 | 0.2525 | 3618216.0 |
| 2002-09-03 11:55:00 | AAPL | Stock | 0.2525 | 0.253 | 0.2525 | 0.253 | 5020064.0 |
| 2002-09-03 12:00:00 | AAPL | Stock | 0.2529 | 0.253 | 0.252 | 0.2525 | 2388400.0 |
| 2002-09-03 12:05:00 | AAPL | Stock | 0.2525 | 0.253 | 0.2523 | 0.2529 | 2273600.0 |
| 2002-09-03 12:10:00 | AAPL | Stock | 0.2527 | 0.2527 | 0.252 | 0.2527 | 879200.0 |
| 2002-09-03 12:15:00 | AAPL | Stock | 0.2527 | 0.2527 | 0.2513 | 0.2523 | 4173568.0 |
| 2002-09-03 12:20:00 | AAPL | Stock | 0.2523 | 0.2523 | 0.2518 | 0.2518 | 2368800.0 |
| 2002-09-03 12:25:00 | AAPL | Stock | 0.2521 | 0.2529 | 0.252 | 0.2529 | 1596000.0 |
| 2002-09-03 12:30:00 | AAPL | Stock | 0.253 | 0.2532 | 0.2523 | 0.2527 | 1243200.0 |
| 2002-09-03 12:35:00 | AAPL | Stock | 0.2527 | 0.2534 | 0.2525 | 0.2532 | 598080.0 |
| 2002-09-03 12:40:00 | AAPL | Stock | 0.2532 | 0.2536 | 0.2532 | 0.2534 | 1573600.0 |
| 2002-09-03 12:45:00 | AAPL | Stock | 0.2534 | 0.2536 | 0.2525 | 0.2532 | 899304.0 |
| 2002-09-03 12:50:00 | AAPL | Stock | 0.2532 | 0.2543 | 0.2532 | 0.2538 | 2419200.0 |
| 2002-09-03 12:55:00 | AAPL | Stock | 0.2536 | 0.2543 | 0.2536 | 0.2538 | 3046400.0 |
| 2002-09-03 13:00:00 | AAPL | Stock | 0.2539 | 0.2543 | 0.2536 | 0.2536 | 6092800.0 |
> showing 50 of 127,726 rows — these rows as CSV