PREVIEW / stock_30min / 2008-12-16
file: by_date/stock_30min/2008/2008-12-16.parquet size: 1.2 MB rows: 70,833 symbols: 3,382
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-12-16 06:30:00 | AAPL | Stock | 3.3643 | 3.3643 | 3.3643 | 3.3643 | 5600.0 |
| 2008-12-16 07:00:00 | AAPL | Stock | 3.3643 | 3.3643 | 3.3214 | 3.3568 | 64428.0 |
| 2008-12-16 07:30:00 | AAPL | Stock | 3.3414 | 3.4004 | 3.3411 | 3.375 | 72100.0 |
| 2008-12-16 08:00:00 | AAPL | Stock | 3.3786 | 3.4025 | 3.3786 | 3.3961 | 2353540.0 |
| 2008-12-16 08:30:00 | AAPL | Stock | 3.3961 | 3.3993 | 3.3629 | 3.375 | 1374744.0 |
| 2008-12-16 09:00:00 | AAPL | Stock | 3.3743 | 3.3786 | 3.3536 | 3.3571 | 1954148.0 |
| 2008-12-16 09:30:00 | AAPL | Stock | 3.3564 | 3.3739 | 3.3125 | 3.3661 | 144673816.0 |
| 2008-12-16 10:00:00 | AAPL | Stock | 3.3668 | 3.3693 | 3.325 | 3.3393 | 82210576.0 |
| 2008-12-16 10:30:00 | AAPL | Stock | 3.3382 | 3.3554 | 3.3214 | 3.3496 | 58958452.0 |
| 2008-12-16 11:00:00 | AAPL | Stock | 3.3489 | 3.3582 | 3.3414 | 3.3571 | 33373732.0 |
| 2008-12-16 11:30:00 | AAPL | Stock | 3.3571 | 3.3929 | 3.3561 | 3.3807 | 55053096.0 |
| 2008-12-16 12:00:00 | AAPL | Stock | 3.3807 | 3.3893 | 3.375 | 3.3807 | 29591996.0 |
| 2008-12-16 12:30:00 | AAPL | Stock | 3.3811 | 3.4011 | 3.3725 | 3.3832 | 45551716.0 |
| 2008-12-16 13:00:00 | AAPL | Stock | 3.3839 | 3.39 | 3.3732 | 3.3875 | 32542580.0 |
| 2008-12-16 13:30:00 | AAPL | Stock | 3.3882 | 3.3918 | 3.3764 | 3.3829 | 24912188.0 |
| 2008-12-16 14:00:00 | AAPL | Stock | 3.3829 | 3.4129 | 3.3643 | 3.3964 | 47070100.0 |
| 2008-12-16 14:30:00 | AAPL | Stock | 3.3961 | 3.4457 | 3.3893 | 3.4029 | 132339424.0 |
| 2008-12-16 15:00:00 | AAPL | Stock | 3.4021 | 3.425 | 3.3857 | 3.4 | 117125568.0 |
| 2008-12-16 15:30:00 | AAPL | Stock | 3.4004 | 3.4096 | 3.365 | 3.39 | 130582116.0 |
| 2008-12-16 16:00:00 | AAPL | Stock | 3.39 | 3.4104 | 3.3785 | 3.3943 | 82049184.0 |
| 2008-12-16 16:30:00 | AAPL | Stock | 3.3946 | 3.4082 | 3.2954 | 3.3011 | 4085844.0 |
| 2008-12-16 17:00:00 | AAPL | Stock | 3.3011 | 3.408 | 3.2071 | 3.2332 | 41402088.0 |
| 2008-12-16 17:30:00 | AAPL | Stock | 3.2332 | 3.4084 | 3.2 | 3.3171 | 31964100.0 |
| 2008-12-16 18:00:00 | AAPL | Stock | 3.3168 | 3.3357 | 3.3111 | 3.3211 | 3333876.0 |
| 2008-12-16 18:30:00 | AAPL | Stock | 3.3204 | 3.3243 | 3.3007 | 3.3161 | 2745316.0 |
| 2008-12-16 19:00:00 | AAPL | Stock | 3.3179 | 3.3214 | 3.3039 | 3.3125 | 1114204.0 |
| 2008-12-16 19:30:00 | AAPL | Stock | 3.3129 | 3.3268 | 3.3129 | 3.3193 | 779212.0 |
| 2008-12-16 05:30:00 | MSFT | Stock | 19.15 | 19.24 | 19.15 | 19.24 | 300.0 |
| 2008-12-16 06:00:00 | MSFT | Stock | 19.29 | 19.29 | 19.29 | 19.29 | 155.0 |
| 2008-12-16 06:30:00 | MSFT | Stock | 19.29 | 19.29 | 19.29 | 19.29 | 200.0 |
| 2008-12-16 07:00:00 | MSFT | Stock | 19.3 | 19.34 | 19.19 | 19.33 | 855.0 |
| 2008-12-16 08:00:00 | MSFT | Stock | 19.29 | 19.29 | 19.29 | 19.29 | 5195.0 |
| 2008-12-16 08:30:00 | MSFT | Stock | 19.25 | 19.29 | 19.24 | 19.25 | 4595.0 |
| 2008-12-16 09:00:00 | MSFT | Stock | 19.25 | 19.29 | 19.19 | 19.19 | 46732.0 |
| 2008-12-16 09:30:00 | MSFT | Stock | 19.2 | 19.42 | 19.0 | 19.13 | 8197518.0 |
| 2008-12-16 10:00:00 | MSFT | Stock | 19.14 | 19.27 | 19.1 | 19.22 | 7322101.0 |
| 2008-12-16 10:30:00 | MSFT | Stock | 19.228 | 19.44 | 19.2 | 19.44 | 4431639.0 |
| 2008-12-16 11:00:00 | MSFT | Stock | 19.43 | 19.46 | 19.32 | 19.39 | 4548114.0 |
| 2008-12-16 11:30:00 | MSFT | Stock | 19.38 | 19.53 | 19.38 | 19.46 | 3624959.0 |
| 2008-12-16 12:00:00 | MSFT | Stock | 19.46 | 19.47 | 19.37 | 19.39 | 2452895.0 |
| 2008-12-16 12:30:00 | MSFT | Stock | 19.4 | 19.44 | 19.36 | 19.405 | 1741371.0 |
| 2008-12-16 13:00:00 | MSFT | Stock | 19.41 | 19.42 | 19.35 | 19.41 | 1661924.0 |
| 2008-12-16 13:30:00 | MSFT | Stock | 19.41 | 19.42 | 19.32 | 19.36 | 3636839.0 |
| 2008-12-16 14:00:00 | MSFT | Stock | 19.351 | 19.66 | 19.35 | 19.55 | 4982939.0 |
| 2008-12-16 14:30:00 | MSFT | Stock | 19.55 | 19.88 | 19.52 | 19.78 | 13565610.0 |
| 2008-12-16 15:00:00 | MSFT | Stock | 19.78 | 20.18 | 19.6 | 20.1 | 13345946.0 |
| 2008-12-16 15:30:00 | MSFT | Stock | 20.099 | 20.15 | 19.9 | 20.1 | 15778178.0 |
| 2008-12-16 16:00:00 | MSFT | Stock | 20.1 | 20.15 | 19.611 | 20.12 | 9806622.0 |
| 2008-12-16 16:30:00 | MSFT | Stock | 20.12 | 20.13 | 19.23 | 20.13 | 152823.0 |
| 2008-12-16 17:00:00 | MSFT | Stock | 20.12 | 20.13 | 20.07 | 20.13 | 12050.0 |
> showing 50 of 70,833 rows — these rows as CSV