PREVIEW / stock_5min / 2008-04-15
file: by_date/stock_5min/2008/2008-04-15.parquet size: 4.3 MB rows: 309,310 symbols: 3,292
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 |
|---|---|---|---|---|---|---|---|
| 2008-04-15 05:25:00 | AAPL | Stock | 5.2675 | 5.2675 | 5.2661 | 5.2661 | 10948.0 |
| 2008-04-15 06:10:00 | AAPL | Stock | 5.2693 | 5.2714 | 5.2693 | 5.2714 | 5600.0 |
| 2008-04-15 06:50:00 | AAPL | Stock | 5.2575 | 5.2575 | 5.2546 | 5.2546 | 47600.0 |
| 2008-04-15 07:05:00 | AAPL | Stock | 5.2671 | 5.2671 | 5.2671 | 5.2671 | 14000.0 |
| 2008-04-15 07:20:00 | AAPL | Stock | 5.2679 | 5.2679 | 5.2679 | 5.2679 | 2800.0 |
| 2008-04-15 07:25:00 | AAPL | Stock | 5.2611 | 5.2614 | 5.2607 | 5.2614 | 16436.0 |
| 2008-04-15 07:35:00 | AAPL | Stock | 5.2675 | 5.2679 | 5.2675 | 5.2679 | 71120.0 |
| 2008-04-15 07:45:00 | AAPL | Stock | 5.2686 | 5.2686 | 5.2671 | 5.2671 | 19600.0 |
| 2008-04-15 07:50:00 | AAPL | Stock | 5.2696 | 5.2754 | 5.2696 | 5.2754 | 35000.0 |
| 2008-04-15 07:55:00 | AAPL | Stock | 5.2771 | 5.2771 | 5.2771 | 5.2771 | 22400.0 |
| 2008-04-15 08:00:00 | AAPL | Stock | 5.2771 | 5.2939 | 5.2771 | 5.2939 | 189840.0 |
| 2008-04-15 08:05:00 | AAPL | Stock | 5.2825 | 5.2875 | 5.2814 | 5.2857 | 179200.0 |
| 2008-04-15 08:10:00 | AAPL | Stock | 5.2839 | 5.2857 | 5.2814 | 5.2814 | 184184.0 |
| 2008-04-15 08:15:00 | AAPL | Stock | 5.2814 | 5.2921 | 5.2786 | 5.2893 | 132776.0 |
| 2008-04-15 08:20:00 | AAPL | Stock | 5.2932 | 5.2946 | 5.2893 | 5.2946 | 158704.0 |
| 2008-04-15 08:25:00 | AAPL | Stock | 5.2918 | 5.2946 | 5.2914 | 5.2925 | 56812.0 |
| 2008-04-15 08:30:00 | AAPL | Stock | 5.2929 | 5.33 | 5.2757 | 5.325 | 1068172.0 |
| 2008-04-15 08:35:00 | AAPL | Stock | 5.3232 | 5.3286 | 5.3214 | 5.3286 | 544264.0 |
| 2008-04-15 08:40:00 | AAPL | Stock | 5.3318 | 5.3318 | 5.3254 | 5.33 | 511532.0 |
| 2008-04-15 08:45:00 | AAPL | Stock | 5.3286 | 5.3321 | 5.3268 | 5.3268 | 193228.0 |
| 2008-04-15 08:50:00 | AAPL | Stock | 5.3225 | 5.3482 | 5.3189 | 5.3407 | 803572.0 |
| 2008-04-15 08:55:00 | AAPL | Stock | 5.3368 | 5.3368 | 5.3321 | 5.3357 | 192920.0 |
| 2008-04-15 09:00:00 | AAPL | Stock | 5.3343 | 5.3496 | 5.3343 | 5.3425 | 545692.0 |
| 2008-04-15 09:05:00 | AAPL | Stock | 5.3429 | 5.3439 | 5.3364 | 5.3371 | 326620.0 |
| 2008-04-15 09:10:00 | AAPL | Stock | 5.3375 | 5.3514 | 5.3375 | 5.3514 | 762468.0 |
| 2008-04-15 09:15:00 | AAPL | Stock | 5.3507 | 5.3518 | 5.3464 | 5.3464 | 156240.0 |
| 2008-04-15 09:20:00 | AAPL | Stock | 5.3464 | 5.3479 | 5.3439 | 5.3446 | 109200.0 |
| 2008-04-15 09:25:00 | AAPL | Stock | 5.3432 | 5.3454 | 5.3304 | 5.3357 | 575708.0 |
| 2008-04-15 09:30:00 | AAPL | Stock | 5.3357 | 5.3446 | 5.3129 | 5.3429 | 24053176.0 |
| 2008-04-15 09:35:00 | AAPL | Stock | 5.3421 | 5.3471 | 5.3275 | 5.3379 | 14819084.0 |
| 2008-04-15 09:40:00 | AAPL | Stock | 5.3386 | 5.3386 | 5.3007 | 5.3064 | 19455632.0 |
| 2008-04-15 09:45:00 | AAPL | Stock | 5.3071 | 5.3096 | 5.2918 | 5.3032 | 14774648.0 |
| 2008-04-15 09:50:00 | AAPL | Stock | 5.3032 | 5.3121 | 5.2929 | 5.3032 | 10724868.0 |
| 2008-04-15 09:55:00 | AAPL | Stock | 5.3039 | 5.3093 | 5.2929 | 5.2929 | 9480660.0 |
| 2008-04-15 10:00:00 | AAPL | Stock | 5.2932 | 5.3164 | 5.2929 | 5.3146 | 12009816.0 |
| 2008-04-15 10:05:00 | AAPL | Stock | 5.3153 | 5.3168 | 5.2986 | 5.3018 | 9645244.0 |
| 2008-04-15 10:10:00 | AAPL | Stock | 5.3014 | 5.3057 | 5.28 | 5.2829 | 10276532.0 |
| 2008-04-15 10:15:00 | AAPL | Stock | 5.2829 | 5.2914 | 5.2779 | 5.2836 | 11049612.0 |
| 2008-04-15 10:20:00 | AAPL | Stock | 5.2832 | 5.2957 | 5.2796 | 5.2864 | 8863008.0 |
| 2008-04-15 10:25:00 | AAPL | Stock | 5.2868 | 5.2929 | 5.2741 | 5.2775 | 10192252.0 |
| 2008-04-15 10:30:00 | AAPL | Stock | 5.2771 | 5.2843 | 5.2643 | 5.2686 | 10024588.0 |
| 2008-04-15 10:35:00 | AAPL | Stock | 5.2682 | 5.2729 | 5.2529 | 5.2536 | 11939452.0 |
| 2008-04-15 10:40:00 | AAPL | Stock | 5.2536 | 5.2536 | 5.2304 | 5.2371 | 18163012.0 |
| 2008-04-15 10:45:00 | AAPL | Stock | 5.2371 | 5.2579 | 5.2346 | 5.2518 | 13816404.0 |
| 2008-04-15 10:50:00 | AAPL | Stock | 5.2518 | 5.2586 | 5.2368 | 5.2371 | 8740984.0 |
| 2008-04-15 10:55:00 | AAPL | Stock | 5.2371 | 5.2527 | 5.2321 | 5.25 | 5623072.0 |
| 2008-04-15 11:00:00 | AAPL | Stock | 5.2496 | 5.2632 | 5.2443 | 5.2632 | 7633752.0 |
| 2008-04-15 11:05:00 | AAPL | Stock | 5.2621 | 5.265 | 5.2439 | 5.2453 | 8922284.0 |
| 2008-04-15 11:10:00 | AAPL | Stock | 5.2446 | 5.25 | 5.2064 | 5.21 | 15044232.0 |
| 2008-04-15 11:15:00 | AAPL | Stock | 5.2118 | 5.2186 | 5.2043 | 5.2157 | 11795000.0 |
> showing 50 of 309,310 rows — these rows as CSV