PREVIEW / stock_30min / 2008-01-15
file: by_date/stock_30min/2008/2008-01-15.parquet size: 1.2 MB rows: 70,382 symbols: 3,244
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-01-15 04:30:00 | AAPL | Stock | 6.4107 | 6.4143 | 6.4107 | 6.4143 | 11200.0 |
| 2008-01-15 05:00:00 | AAPL | Stock | 6.3929 | 6.405 | 6.3854 | 6.3857 | 87640.0 |
| 2008-01-15 05:30:00 | AAPL | Stock | 6.3739 | 6.375 | 6.3739 | 6.375 | 51940.0 |
| 2008-01-15 06:00:00 | AAPL | Stock | 6.3779 | 6.3843 | 6.3779 | 6.3818 | 78400.0 |
| 2008-01-15 06:30:00 | AAPL | Stock | 6.3818 | 6.4143 | 6.3818 | 6.4143 | 87080.0 |
| 2008-01-15 07:00:00 | AAPL | Stock | 6.3982 | 6.4107 | 6.375 | 6.375 | 269248.0 |
| 2008-01-15 07:30:00 | AAPL | Stock | 6.3714 | 6.3814 | 6.3396 | 6.3632 | 448672.0 |
| 2008-01-15 08:00:00 | AAPL | Stock | 6.3568 | 6.3786 | 6.3482 | 6.3646 | 2766288.0 |
| 2008-01-15 08:30:00 | AAPL | Stock | 6.3646 | 6.3893 | 6.3475 | 6.3614 | 6579468.0 |
| 2008-01-15 09:00:00 | AAPL | Stock | 6.3611 | 6.385 | 6.3279 | 6.3432 | 4626636.0 |
| 2008-01-15 09:30:00 | AAPL | Stock | 6.3446 | 6.3546 | 6.2893 | 6.3471 | 130816364.0 |
| 2008-01-15 10:00:00 | AAPL | Stock | 6.3464 | 6.4007 | 6.2975 | 6.3257 | 160978104.0 |
| 2008-01-15 10:30:00 | AAPL | Stock | 6.3239 | 6.3375 | 6.2332 | 6.2825 | 141152256.0 |
| 2008-01-15 11:00:00 | AAPL | Stock | 6.2825 | 6.31 | 6.2561 | 6.2671 | 73634652.0 |
| 2008-01-15 11:30:00 | AAPL | Stock | 6.2675 | 6.2696 | 6.1782 | 6.2364 | 113338288.0 |
| 2008-01-15 12:00:00 | AAPL | Stock | 6.2361 | 6.2743 | 6.175 | 6.2207 | 133429464.0 |
| 2008-01-15 12:30:00 | AAPL | Stock | 6.2189 | 6.2379 | 6.0204 | 6.0554 | 287271880.0 |
| 2008-01-15 13:00:00 | AAPL | Stock | 6.0554 | 6.1743 | 6.0093 | 6.0832 | 198180164.0 |
| 2008-01-15 13:30:00 | AAPL | Stock | 6.0829 | 6.0857 | 5.9075 | 5.9518 | 271675404.0 |
| 2008-01-15 14:00:00 | AAPL | Stock | 5.9518 | 6.0393 | 5.93 | 5.9721 | 161246764.0 |
| 2008-01-15 14:30:00 | AAPL | Stock | 5.9719 | 6.0 | 5.93 | 5.9625 | 141444912.0 |
| 2008-01-15 15:00:00 | AAPL | Stock | 5.9621 | 5.9711 | 5.8807 | 5.9564 | 188261836.0 |
| 2008-01-15 15:30:00 | AAPL | Stock | 5.9561 | 6.0546 | 5.9286 | 6.0357 | 270594436.0 |
| 2008-01-15 16:00:00 | AAPL | Stock | 6.0361 | 6.3859 | 5.8475 | 5.8821 | 42632520.0 |
| 2008-01-15 16:30:00 | AAPL | Stock | 5.8821 | 6.0371 | 5.8357 | 5.85 | 5762932.0 |
| 2008-01-15 17:00:00 | AAPL | Stock | 5.8529 | 5.8639 | 5.8268 | 5.8482 | 3256036.0 |
| 2008-01-15 17:30:00 | AAPL | Stock | 5.85 | 6.385 | 5.8232 | 5.8286 | 5405764.0 |
| 2008-01-15 18:00:00 | AAPL | Stock | 5.8286 | 6.2884 | 5.8196 | 5.8393 | 1385636.0 |
| 2008-01-15 18:30:00 | AAPL | Stock | 5.8329 | 5.8393 | 5.8214 | 5.8214 | 3006724.0 |
| 2008-01-15 19:00:00 | AAPL | Stock | 5.8264 | 5.8264 | 5.8036 | 5.8161 | 865144.0 |
| 2008-01-15 19:30:00 | AAPL | Stock | 5.8136 | 5.825 | 5.8107 | 5.8218 | 1193668.0 |
| 2008-01-15 07:00:00 | MSFT | Stock | 34.19 | 34.19 | 34.19 | 34.19 | 330.0 |
| 2008-01-15 07:30:00 | MSFT | Stock | 34.2 | 34.2 | 34.2 | 34.2 | 1700.0 |
| 2008-01-15 08:00:00 | MSFT | Stock | 34.2 | 34.29 | 34.2 | 34.29 | 5101.0 |
| 2008-01-15 08:30:00 | MSFT | Stock | 34.29 | 34.35 | 34.14 | 34.14 | 7820.0 |
| 2008-01-15 09:00:00 | MSFT | Stock | 34.1 | 34.22 | 34.0 | 34.0 | 151364.0 |
| 2008-01-15 09:30:00 | MSFT | Stock | 34.0 | 34.35 | 34.0 | 34.32 | 4916282.0 |
| 2008-01-15 10:00:00 | MSFT | Stock | 34.31 | 34.36 | 34.18 | 34.24 | 5675234.0 |
| 2008-01-15 10:30:00 | MSFT | Stock | 34.24 | 34.29 | 34.08 | 34.14 | 5108811.0 |
| 2008-01-15 11:00:00 | MSFT | Stock | 34.15 | 34.2 | 34.09 | 34.1 | 2686049.0 |
| 2008-01-15 11:30:00 | MSFT | Stock | 34.1 | 34.19 | 34.04 | 34.19 | 3278455.0 |
| 2008-01-15 12:00:00 | MSFT | Stock | 34.19 | 34.21 | 34.095 | 34.2 | 2972010.0 |
| 2008-01-15 12:30:00 | MSFT | Stock | 34.2 | 34.23 | 34.1 | 34.22 | 2955895.0 |
| 2008-01-15 13:00:00 | MSFT | Stock | 34.22 | 34.32 | 34.19 | 34.22 | 3230097.0 |
| 2008-01-15 13:30:00 | MSFT | Stock | 34.23 | 34.32 | 34.17 | 34.17 | 2949165.0 |
| 2008-01-15 14:00:00 | MSFT | Stock | 34.18 | 34.23 | 34.0 | 34.05 | 4333518.0 |
| 2008-01-15 14:30:00 | MSFT | Stock | 34.05 | 34.12 | 34.02 | 34.072 | 3599387.0 |
| 2008-01-15 15:00:00 | MSFT | Stock | 34.08 | 34.34 | 34.0 | 34.3 | 5644850.0 |
| 2008-01-15 15:30:00 | MSFT | Stock | 34.31 | 34.38 | 34.0 | 34.0 | 9418081.0 |
| 2008-01-15 16:00:00 | MSFT | Stock | 34.0 | 34.176 | 32.6 | 32.8 | 4152196.0 |
> showing 50 of 70,382 rows — these rows as CSV