PREVIEW / stock_5min / 2008-11-26
file: by_date/stock_5min/2008/2008-11-26.parquet size: 4.4 MB rows: 315,544 symbols: 3,351
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-11-26 07:20:00 | AAPL | Stock | 3.225 | 3.225 | 3.225 | 3.225 | 2800.0 |
| 2008-11-26 07:45:00 | AAPL | Stock | 3.2071 | 3.2071 | 3.2071 | 3.2071 | 75600.0 |
| 2008-11-26 08:00:00 | AAPL | Stock | 3.1964 | 3.2054 | 3.1836 | 3.1964 | 148848.0 |
| 2008-11-26 08:05:00 | AAPL | Stock | 3.1879 | 3.2018 | 3.1839 | 3.1964 | 102900.0 |
| 2008-11-26 08:10:00 | AAPL | Stock | 3.1939 | 3.2071 | 3.1939 | 3.2018 | 97552.0 |
| 2008-11-26 08:15:00 | AAPL | Stock | 3.2039 | 3.2071 | 3.1946 | 3.1946 | 716240.0 |
| 2008-11-26 08:20:00 | AAPL | Stock | 3.1946 | 3.1946 | 3.1914 | 3.1929 | 16800.0 |
| 2008-11-26 08:25:00 | AAPL | Stock | 3.1904 | 3.195 | 3.1904 | 3.1929 | 53900.0 |
| 2008-11-26 08:30:00 | AAPL | Stock | 3.1929 | 3.1929 | 3.1821 | 3.1857 | 236964.0 |
| 2008-11-26 08:35:00 | AAPL | Stock | 3.1857 | 3.1939 | 3.1857 | 3.1875 | 47320.0 |
| 2008-11-26 08:40:00 | AAPL | Stock | 3.1936 | 3.2232 | 3.1936 | 3.2218 | 344624.0 |
| 2008-11-26 08:45:00 | AAPL | Stock | 3.2225 | 3.2304 | 3.2218 | 3.2229 | 301476.0 |
| 2008-11-26 08:50:00 | AAPL | Stock | 3.2221 | 3.2236 | 3.2143 | 3.215 | 66948.0 |
| 2008-11-26 08:55:00 | AAPL | Stock | 3.2082 | 3.2082 | 3.2046 | 3.2046 | 75180.0 |
| 2008-11-26 09:00:00 | AAPL | Stock | 3.2071 | 3.2107 | 3.2071 | 3.2107 | 65520.0 |
| 2008-11-26 09:05:00 | AAPL | Stock | 3.2104 | 3.215 | 3.21 | 3.215 | 78680.0 |
| 2008-11-26 09:10:00 | AAPL | Stock | 3.2139 | 3.2229 | 3.2136 | 3.2229 | 73500.0 |
| 2008-11-26 09:15:00 | AAPL | Stock | 3.2146 | 3.2146 | 3.2114 | 3.2114 | 14000.0 |
| 2008-11-26 09:20:00 | AAPL | Stock | 3.2125 | 3.2196 | 3.2089 | 3.2089 | 79100.0 |
| 2008-11-26 09:25:00 | AAPL | Stock | 3.21 | 3.2225 | 3.2036 | 3.215 | 109676.0 |
| 2008-11-26 09:30:00 | AAPL | Stock | 3.2175 | 3.2661 | 3.2082 | 3.2557 | 18450740.0 |
| 2008-11-26 09:35:00 | AAPL | Stock | 3.2554 | 3.2714 | 3.2411 | 3.2564 | 18389896.0 |
| 2008-11-26 09:40:00 | AAPL | Stock | 3.2561 | 3.2836 | 3.2514 | 3.2596 | 16154208.0 |
| 2008-11-26 09:45:00 | AAPL | Stock | 3.2589 | 3.2907 | 3.2568 | 3.2818 | 18409832.0 |
| 2008-11-26 09:50:00 | AAPL | Stock | 3.2811 | 3.3118 | 3.2811 | 3.3046 | 21660660.0 |
| 2008-11-26 09:55:00 | AAPL | Stock | 3.3036 | 3.3204 | 3.2975 | 3.3046 | 17907204.0 |
| 2008-11-26 10:00:00 | AAPL | Stock | 3.3046 | 3.3314 | 3.3007 | 3.3214 | 18909940.0 |
| 2008-11-26 10:05:00 | AAPL | Stock | 3.3225 | 3.3246 | 3.3071 | 3.3111 | 13916140.0 |
| 2008-11-26 10:10:00 | AAPL | Stock | 3.3114 | 3.3332 | 3.3 | 3.3279 | 19424580.0 |
| 2008-11-26 10:15:00 | AAPL | Stock | 3.3286 | 3.3489 | 3.3232 | 3.3414 | 16179324.0 |
| 2008-11-26 10:20:00 | AAPL | Stock | 3.3421 | 3.3571 | 3.3339 | 3.3539 | 15681428.0 |
| 2008-11-26 10:25:00 | AAPL | Stock | 3.3536 | 3.3664 | 3.3425 | 3.3486 | 17437980.0 |
| 2008-11-26 10:30:00 | AAPL | Stock | 3.3489 | 3.3561 | 3.34 | 3.3429 | 10542532.0 |
| 2008-11-26 10:35:00 | AAPL | Stock | 3.3432 | 3.3539 | 3.3339 | 3.3354 | 13569276.0 |
| 2008-11-26 10:40:00 | AAPL | Stock | 3.3414 | 3.3504 | 3.3321 | 3.3496 | 10223836.0 |
| 2008-11-26 10:45:00 | AAPL | Stock | 3.35 | 3.3625 | 3.3364 | 3.3386 | 9743076.0 |
| 2008-11-26 10:50:00 | AAPL | Stock | 3.3386 | 3.3643 | 3.3357 | 3.3575 | 10974404.0 |
| 2008-11-26 10:55:00 | AAPL | Stock | 3.3575 | 3.375 | 3.3504 | 3.3561 | 12838952.0 |
| 2008-11-26 11:00:00 | AAPL | Stock | 3.3571 | 3.3611 | 3.3396 | 3.3414 | 8083964.0 |
| 2008-11-26 11:05:00 | AAPL | Stock | 3.3418 | 3.3611 | 3.3386 | 3.3482 | 9763740.0 |
| 2008-11-26 11:10:00 | AAPL | Stock | 3.3475 | 3.3607 | 3.3475 | 3.3541 | 7533988.0 |
| 2008-11-26 11:15:00 | AAPL | Stock | 3.3539 | 3.375 | 3.3446 | 3.375 | 8003184.0 |
| 2008-11-26 11:20:00 | AAPL | Stock | 3.3732 | 3.3857 | 3.3689 | 3.3739 | 12877872.0 |
| 2008-11-26 11:25:00 | AAPL | Stock | 3.3743 | 3.3886 | 3.3554 | 3.3571 | 10032176.0 |
| 2008-11-26 11:30:00 | AAPL | Stock | 3.3557 | 3.3718 | 3.3536 | 3.3654 | 10306940.0 |
| 2008-11-26 11:35:00 | AAPL | Stock | 3.3657 | 3.3857 | 3.3639 | 3.3768 | 11216016.0 |
| 2008-11-26 11:40:00 | AAPL | Stock | 3.3771 | 3.385 | 3.3679 | 3.3789 | 7833112.0 |
| 2008-11-26 11:45:00 | AAPL | Stock | 3.3789 | 3.3929 | 3.3714 | 3.3896 | 11129916.0 |
| 2008-11-26 11:50:00 | AAPL | Stock | 3.3914 | 3.3914 | 3.3718 | 3.3832 | 9943612.0 |
| 2008-11-26 11:55:00 | AAPL | Stock | 3.3829 | 3.3857 | 3.3643 | 3.3686 | 8595104.0 |
> showing 50 of 315,544 rows — these rows as CSV