PREVIEW / stock_5min / 2008-10-09
file: by_date/stock_5min/2008/2008-10-09.parquet size: 4.8 MB rows: 340,066 symbols: 3,366
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-10-09 04:15:00 | AAPL | Stock | 3.3014 | 3.3064 | 3.3014 | 3.3064 | 25200.0 |
| 2008-10-09 05:30:00 | AAPL | Stock | 3.3364 | 3.3364 | 3.3364 | 3.3364 | 2800.0 |
| 2008-10-09 06:25:00 | AAPL | Stock | 3.305 | 3.305 | 3.305 | 3.305 | 2800.0 |
| 2008-10-09 07:05:00 | AAPL | Stock | 3.3107 | 3.3107 | 3.3107 | 3.3107 | 27300.0 |
| 2008-10-09 07:10:00 | AAPL | Stock | 3.3375 | 3.3571 | 3.3214 | 3.3571 | 33600.0 |
| 2008-10-09 07:15:00 | AAPL | Stock | 3.3214 | 3.3214 | 3.3036 | 3.3036 | 72800.0 |
| 2008-10-09 07:20:00 | AAPL | Stock | 3.3036 | 3.3036 | 3.3036 | 3.3036 | 36400.0 |
| 2008-10-09 07:25:00 | AAPL | Stock | 3.3036 | 3.3036 | 3.3036 | 3.3036 | 70000.0 |
| 2008-10-09 07:30:00 | AAPL | Stock | 3.3036 | 3.3107 | 3.3036 | 3.3107 | 5600.0 |
| 2008-10-09 07:35:00 | AAPL | Stock | 3.3107 | 3.3107 | 3.3107 | 3.3107 | 106400.0 |
| 2008-10-09 07:40:00 | AAPL | Stock | 3.3107 | 3.3107 | 3.3036 | 3.3036 | 64400.0 |
| 2008-10-09 07:45:00 | AAPL | Stock | 3.3036 | 3.3036 | 3.2879 | 3.2879 | 47320.0 |
| 2008-10-09 07:50:00 | AAPL | Stock | 3.2875 | 3.2875 | 3.2857 | 3.2857 | 5600.0 |
| 2008-10-09 07:55:00 | AAPL | Stock | 3.2875 | 3.2875 | 3.2857 | 3.2857 | 5600.0 |
| 2008-10-09 08:00:00 | AAPL | Stock | 3.2964 | 3.3007 | 3.2718 | 3.2857 | 439572.0 |
| 2008-10-09 08:05:00 | AAPL | Stock | 3.2864 | 3.2886 | 3.2761 | 3.2846 | 364364.0 |
| 2008-10-09 08:10:00 | AAPL | Stock | 3.2832 | 3.2854 | 3.275 | 3.275 | 236600.0 |
| 2008-10-09 08:15:00 | AAPL | Stock | 3.275 | 3.2764 | 3.2654 | 3.2725 | 423472.0 |
| 2008-10-09 08:20:00 | AAPL | Stock | 3.2714 | 3.2982 | 3.2714 | 3.2982 | 378616.0 |
| 2008-10-09 08:25:00 | AAPL | Stock | 3.295 | 3.3071 | 3.2936 | 3.2957 | 592760.0 |
| 2008-10-09 08:30:00 | AAPL | Stock | 3.2982 | 3.3107 | 3.2982 | 3.31 | 763896.0 |
| 2008-10-09 08:35:00 | AAPL | Stock | 3.3089 | 3.3107 | 3.3 | 3.3064 | 599760.0 |
| 2008-10-09 08:40:00 | AAPL | Stock | 3.3054 | 3.3143 | 3.3 | 3.3054 | 864444.0 |
| 2008-10-09 08:45:00 | AAPL | Stock | 3.3054 | 3.3071 | 3.2936 | 3.2964 | 647920.0 |
| 2008-10-09 08:50:00 | AAPL | Stock | 3.2964 | 3.3018 | 3.2929 | 3.2961 | 409360.0 |
| 2008-10-09 08:55:00 | AAPL | Stock | 3.2964 | 3.2964 | 3.2768 | 3.2854 | 652400.0 |
| 2008-10-09 09:00:00 | AAPL | Stock | 3.2857 | 3.2911 | 3.2836 | 3.2875 | 425992.0 |
| 2008-10-09 09:05:00 | AAPL | Stock | 3.2875 | 3.2893 | 3.2839 | 3.2843 | 1259860.0 |
| 2008-10-09 09:10:00 | AAPL | Stock | 3.2857 | 3.2893 | 3.2857 | 3.2875 | 623364.0 |
| 2008-10-09 09:15:00 | AAPL | Stock | 3.2893 | 3.2946 | 3.2893 | 3.2929 | 460572.0 |
| 2008-10-09 09:20:00 | AAPL | Stock | 3.2946 | 3.2946 | 3.2911 | 3.2918 | 466676.0 |
| 2008-10-09 09:25:00 | AAPL | Stock | 3.2918 | 3.335 | 3.2918 | 3.3304 | 2752540.0 |
| 2008-10-09 09:30:00 | AAPL | Stock | 3.3329 | 3.3971 | 3.3232 | 3.3775 | 51529156.0 |
| 2008-10-09 09:35:00 | AAPL | Stock | 3.3775 | 3.3911 | 3.3339 | 3.3568 | 34913060.0 |
| 2008-10-09 09:40:00 | AAPL | Stock | 3.3557 | 3.4214 | 3.3536 | 3.3961 | 34594784.0 |
| 2008-10-09 09:45:00 | AAPL | Stock | 3.3967 | 3.4061 | 3.3468 | 3.3511 | 33055624.0 |
| 2008-10-09 09:50:00 | AAPL | Stock | 3.3543 | 3.3889 | 3.3486 | 3.3596 | 21691096.0 |
| 2008-10-09 09:55:00 | AAPL | Stock | 3.359 | 3.3661 | 3.3214 | 3.3271 | 26954116.0 |
| 2008-10-09 10:00:00 | AAPL | Stock | 3.3267 | 3.3354 | 3.295 | 3.3075 | 29302840.0 |
| 2008-10-09 10:05:00 | AAPL | Stock | 3.3075 | 3.3507 | 3.2986 | 3.3507 | 23024932.0 |
| 2008-10-09 10:10:00 | AAPL | Stock | 3.3518 | 3.3696 | 3.3232 | 3.3257 | 21751996.0 |
| 2008-10-09 10:15:00 | AAPL | Stock | 3.325 | 3.3601 | 3.325 | 3.3489 | 20649580.0 |
| 2008-10-09 10:20:00 | AAPL | Stock | 3.3471 | 3.3636 | 3.3214 | 3.3225 | 23644264.0 |
| 2008-10-09 10:25:00 | AAPL | Stock | 3.3221 | 3.3261 | 3.2793 | 3.2807 | 25831092.0 |
| 2008-10-09 10:30:00 | AAPL | Stock | 3.2818 | 3.2875 | 3.2468 | 3.2761 | 31415300.0 |
| 2008-10-09 10:35:00 | AAPL | Stock | 3.2768 | 3.3061 | 3.2629 | 3.265 | 22823220.0 |
| 2008-10-09 10:40:00 | AAPL | Stock | 3.265 | 3.2914 | 3.2246 | 3.2393 | 24067764.0 |
| 2008-10-09 10:45:00 | AAPL | Stock | 3.2393 | 3.2943 | 3.2307 | 3.2764 | 25796708.0 |
| 2008-10-09 10:50:00 | AAPL | Stock | 3.2768 | 3.2829 | 3.25 | 3.2596 | 17417008.0 |
| 2008-10-09 10:55:00 | AAPL | Stock | 3.2625 | 3.2729 | 3.2371 | 3.2546 | 17401916.0 |
> showing 50 of 340,066 rows — these rows as CSV