PREVIEW / stock_5min / 2000-03-27
file: by_date/stock_5min/2000/2000-03-27.parquet size: 1.1 MB rows: 86,113 symbols: 1,147
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 |
|---|---|---|---|---|---|---|---|
| 2000-03-27 09:30:00 | AAPL | Stock | 1.2288 | 1.2355 | 1.2221 | 1.2355 | 7246400.0 |
| 2000-03-27 09:35:00 | AAPL | Stock | 1.2349 | 1.2506 | 1.2238 | 1.2422 | 6787200.0 |
| 2000-03-27 09:40:00 | AAPL | Stock | 1.2439 | 1.2511 | 1.2277 | 1.2277 | 9072000.0 |
| 2000-03-27 09:45:00 | AAPL | Stock | 1.2282 | 1.2433 | 1.2277 | 1.2416 | 5096000.0 |
| 2000-03-27 09:50:00 | AAPL | Stock | 1.2422 | 1.2422 | 1.2277 | 1.2282 | 5936000.0 |
| 2000-03-27 09:55:00 | AAPL | Stock | 1.2282 | 1.2405 | 1.2277 | 1.2402 | 2195200.0 |
| 2000-03-27 10:00:00 | AAPL | Stock | 1.2416 | 1.245 | 1.2338 | 1.245 | 3696000.0 |
| 2000-03-27 10:05:00 | AAPL | Stock | 1.245 | 1.25 | 1.2433 | 1.25 | 5196800.0 |
| 2000-03-27 10:10:00 | AAPL | Stock | 1.25 | 1.2545 | 1.25 | 1.25 | 9016000.0 |
| 2000-03-27 10:15:00 | AAPL | Stock | 1.2517 | 1.2634 | 1.25 | 1.2617 | 5756800.0 |
| 2000-03-27 10:20:00 | AAPL | Stock | 1.2628 | 1.2634 | 1.2522 | 1.2634 | 3113600.0 |
| 2000-03-27 10:25:00 | AAPL | Stock | 1.2634 | 1.2684 | 1.2589 | 1.2623 | 3752000.0 |
| 2000-03-27 10:30:00 | AAPL | Stock | 1.2623 | 1.2656 | 1.2511 | 1.2533 | 5454400.0 |
| 2000-03-27 10:35:00 | AAPL | Stock | 1.2531 | 1.2567 | 1.2506 | 1.2528 | 2116800.0 |
| 2000-03-27 10:40:00 | AAPL | Stock | 1.2533 | 1.2545 | 1.2489 | 1.2545 | 3707200.0 |
| 2000-03-27 10:45:00 | AAPL | Stock | 1.2545 | 1.2545 | 1.2478 | 1.2506 | 2497600.0 |
| 2000-03-27 10:50:00 | AAPL | Stock | 1.2489 | 1.25 | 1.2433 | 1.2478 | 4558400.0 |
| 2000-03-27 10:55:00 | AAPL | Stock | 1.2489 | 1.2489 | 1.2422 | 1.2444 | 1456000.0 |
| 2000-03-27 11:00:00 | AAPL | Stock | 1.2444 | 1.2511 | 1.2439 | 1.2455 | 2598400.0 |
| 2000-03-27 11:05:00 | AAPL | Stock | 1.2433 | 1.2511 | 1.2433 | 1.2511 | 896000.0 |
| 2000-03-27 11:10:00 | AAPL | Stock | 1.2511 | 1.2679 | 1.25 | 1.2676 | 3841600.0 |
| 2000-03-27 11:15:00 | AAPL | Stock | 1.2679 | 1.2723 | 1.2612 | 1.2718 | 5790400.0 |
| 2000-03-27 11:20:00 | AAPL | Stock | 1.2718 | 1.2768 | 1.2667 | 1.2768 | 4412800.0 |
| 2000-03-27 11:25:00 | AAPL | Stock | 1.2757 | 1.2768 | 1.2734 | 1.2768 | 5051200.0 |
| 2000-03-27 11:30:00 | AAPL | Stock | 1.2757 | 1.2768 | 1.2612 | 1.2673 | 3304000.0 |
| 2000-03-27 11:35:00 | AAPL | Stock | 1.2656 | 1.2679 | 1.2589 | 1.2589 | 3091200.0 |
| 2000-03-27 11:40:00 | AAPL | Stock | 1.2589 | 1.2634 | 1.2567 | 1.2634 | 3046400.0 |
| 2000-03-27 11:45:00 | AAPL | Stock | 1.2623 | 1.2701 | 1.2589 | 1.2634 | 4256000.0 |
| 2000-03-27 11:50:00 | AAPL | Stock | 1.2634 | 1.2656 | 1.2617 | 1.2656 | 3763200.0 |
| 2000-03-27 11:55:00 | AAPL | Stock | 1.2679 | 1.2701 | 1.2665 | 1.2667 | 1512000.0 |
| 2000-03-27 12:00:00 | AAPL | Stock | 1.2673 | 1.269 | 1.2662 | 1.2667 | 1814400.0 |
| 2000-03-27 12:05:00 | AAPL | Stock | 1.2673 | 1.2712 | 1.2667 | 1.2712 | 1299200.0 |
| 2000-03-27 12:10:00 | AAPL | Stock | 1.2712 | 1.279 | 1.2706 | 1.279 | 2900800.0 |
| 2000-03-27 12:15:00 | AAPL | Stock | 1.279 | 1.2807 | 1.2746 | 1.2757 | 1265600.0 |
| 2000-03-27 12:20:00 | AAPL | Stock | 1.2773 | 1.2824 | 1.2757 | 1.2768 | 2318400.0 |
| 2000-03-27 12:25:00 | AAPL | Stock | 1.2785 | 1.2813 | 1.2679 | 1.2813 | 3248000.0 |
| 2000-03-27 12:30:00 | AAPL | Stock | 1.2807 | 1.2807 | 1.2779 | 1.2785 | 1086400.0 |
| 2000-03-27 12:35:00 | AAPL | Stock | 1.2785 | 1.279 | 1.2773 | 1.279 | 1164800.0 |
| 2000-03-27 12:40:00 | AAPL | Stock | 1.279 | 1.2813 | 1.2785 | 1.281 | 2128000.0 |
| 2000-03-27 12:45:00 | AAPL | Stock | 1.2813 | 1.2824 | 1.2807 | 1.2818 | 1534400.0 |
| 2000-03-27 12:50:00 | AAPL | Stock | 1.2824 | 1.2824 | 1.2807 | 1.2813 | 1500800.0 |
| 2000-03-27 12:55:00 | AAPL | Stock | 1.2813 | 1.2818 | 1.2796 | 1.2796 | 2363200.0 |
| 2000-03-27 13:00:00 | AAPL | Stock | 1.2796 | 1.2813 | 1.2768 | 1.2779 | 3304000.0 |
| 2000-03-27 13:05:00 | AAPL | Stock | 1.279 | 1.2857 | 1.2779 | 1.2857 | 3808000.0 |
| 2000-03-27 13:10:00 | AAPL | Stock | 1.2868 | 1.2893 | 1.2846 | 1.2857 | 3113600.0 |
| 2000-03-27 13:15:00 | AAPL | Stock | 1.284 | 1.2852 | 1.2818 | 1.2846 | 772800.0 |
| 2000-03-27 13:20:00 | AAPL | Stock | 1.2835 | 1.2835 | 1.279 | 1.279 | 1243200.0 |
| 2000-03-27 13:25:00 | AAPL | Stock | 1.279 | 1.2824 | 1.2768 | 1.2818 | 907200.0 |
| 2000-03-27 13:30:00 | AAPL | Stock | 1.2826 | 1.2891 | 1.2826 | 1.2868 | 1982400.0 |
| 2000-03-27 13:35:00 | AAPL | Stock | 1.2868 | 1.2891 | 1.2813 | 1.2835 | 1691200.0 |
> showing 50 of 86,113 rows — these rows as CSV