PREVIEW / stock_30min / 2006-03-16
file: by_date/stock_30min/2006/2006-03-16.parquet size: 903 KB rows: 48,234 symbols: 2,218
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 |
|---|---|---|---|---|---|---|---|
| 2006-03-16 07:30:00 | AAPL | Stock | 2.3643 | 2.3686 | 2.3643 | 2.3686 | 31808.0 |
| 2006-03-16 08:00:00 | AAPL | Stock | 2.3679 | 2.3775 | 2.3611 | 2.3643 | 707812.0 |
| 2006-03-16 08:30:00 | AAPL | Stock | 2.3643 | 2.3786 | 2.3643 | 2.3786 | 2146060.0 |
| 2006-03-16 09:00:00 | AAPL | Stock | 2.3768 | 2.3889 | 2.375 | 2.3889 | 2112684.0 |
| 2006-03-16 09:30:00 | AAPL | Stock | 2.3875 | 2.3893 | 2.3482 | 2.3571 | 112813400.0 |
| 2006-03-16 10:00:00 | AAPL | Stock | 2.3579 | 2.3636 | 2.3446 | 2.3489 | 71710184.0 |
| 2006-03-16 10:30:00 | AAPL | Stock | 2.3489 | 2.3557 | 2.3343 | 2.335 | 62659772.0 |
| 2006-03-16 11:00:00 | AAPL | Stock | 2.3346 | 2.3879 | 2.3325 | 2.3493 | 43062152.0 |
| 2006-03-16 11:30:00 | AAPL | Stock | 2.3493 | 2.3532 | 2.3457 | 2.3493 | 32014948.0 |
| 2006-03-16 12:00:00 | AAPL | Stock | 2.3493 | 2.3568 | 2.3464 | 2.3568 | 33703348.0 |
| 2006-03-16 12:30:00 | AAPL | Stock | 2.3568 | 2.3571 | 2.3468 | 2.3468 | 26526220.0 |
| 2006-03-16 13:00:00 | AAPL | Stock | 2.3468 | 2.3479 | 2.3379 | 2.3386 | 34887216.0 |
| 2006-03-16 13:30:00 | AAPL | Stock | 2.3382 | 2.3414 | 2.3232 | 2.3254 | 53631872.0 |
| 2006-03-16 14:00:00 | AAPL | Stock | 2.3254 | 2.3321 | 2.3179 | 2.3275 | 57978256.0 |
| 2006-03-16 14:30:00 | AAPL | Stock | 2.3275 | 2.3275 | 2.3089 | 2.3093 | 47996088.0 |
| 2006-03-16 15:00:00 | AAPL | Stock | 2.3093 | 2.3193 | 2.3054 | 2.3186 | 52250380.0 |
| 2006-03-16 15:30:00 | AAPL | Stock | 2.3182 | 2.3214 | 2.2964 | 2.2968 | 102298616.0 |
| 2006-03-16 16:00:00 | AAPL | Stock | 2.2968 | 2.2993 | 2.295 | 2.2964 | 2292052.0 |
| 2006-03-16 16:30:00 | AAPL | Stock | 2.2979 | 2.3 | 2.2968 | 2.2982 | 582344.0 |
| 2006-03-16 17:00:00 | AAPL | Stock | 2.2982 | 2.3032 | 2.2971 | 2.2982 | 316484.0 |
| 2006-03-16 17:30:00 | AAPL | Stock | 2.2968 | 2.2996 | 2.2968 | 2.2975 | 455112.0 |
| 2006-03-16 18:00:00 | AAPL | Stock | 2.2979 | 2.3036 | 2.2964 | 2.3018 | 461888.0 |
| 2006-03-16 08:00:00 | MSFT | Stock | 27.34 | 27.4 | 27.32 | 27.36 | 1670.0 |
| 2006-03-16 08:30:00 | MSFT | Stock | 27.36 | 27.4 | 27.33 | 27.4 | 131567.0 |
| 2006-03-16 09:00:00 | MSFT | Stock | 27.4 | 27.43 | 27.27 | 27.29 | 148520.0 |
| 2006-03-16 09:30:00 | MSFT | Stock | 27.34 | 27.47 | 27.28 | 27.41 | 9641900.0 |
| 2006-03-16 10:00:00 | MSFT | Stock | 27.41 | 27.46 | 27.33 | 27.36 | 6785259.0 |
| 2006-03-16 10:30:00 | MSFT | Stock | 27.36 | 27.46 | 27.36 | 27.362 | 5581877.0 |
| 2006-03-16 11:00:00 | MSFT | Stock | 27.36 | 27.44 | 27.32 | 27.4 | 5515602.0 |
| 2006-03-16 11:30:00 | MSFT | Stock | 27.41 | 27.41 | 27.34 | 27.37 | 4207904.0 |
| 2006-03-16 12:00:00 | MSFT | Stock | 27.38 | 27.44 | 27.37 | 27.44 | 3497022.0 |
| 2006-03-16 12:30:00 | MSFT | Stock | 27.44 | 27.46 | 27.39 | 27.39 | 2854149.0 |
| 2006-03-16 13:00:00 | MSFT | Stock | 27.388 | 27.48 | 27.34 | 27.41 | 6257627.0 |
| 2006-03-16 13:30:00 | MSFT | Stock | 27.41 | 27.45 | 27.36 | 27.37 | 3536268.0 |
| 2006-03-16 14:00:00 | MSFT | Stock | 27.37 | 27.42 | 27.36 | 27.392 | 2897731.0 |
| 2006-03-16 14:30:00 | MSFT | Stock | 27.39 | 27.39 | 27.36 | 27.37 | 5618118.0 |
| 2006-03-16 15:00:00 | MSFT | Stock | 27.37 | 27.43 | 27.37 | 27.39 | 2982257.0 |
| 2006-03-16 15:30:00 | MSFT | Stock | 27.39 | 27.39 | 27.22 | 27.23 | 12258869.0 |
| 2006-03-16 16:00:00 | MSFT | Stock | 27.27 | 27.31 | 27.24 | 27.27 | 270480.0 |
| 2006-03-16 16:30:00 | MSFT | Stock | 27.29 | 27.29 | 27.27 | 27.27 | 20200.0 |
| 2006-03-16 17:00:00 | MSFT | Stock | 27.27 | 27.27 | 27.26 | 27.27 | 600.0 |
| 2006-03-16 17:30:00 | MSFT | Stock | 27.27 | 27.27 | 27.24 | 27.26 | 7935.0 |
| 2006-03-16 08:00:00 | NVDA | Stock | 0.4167 | 0.4167 | 0.4167 | 0.4167 | 84840.0 |
| 2006-03-16 08:30:00 | NVDA | Stock | 0.4167 | 0.419 | 0.4167 | 0.4187 | 240000.0 |
| 2006-03-16 09:00:00 | NVDA | Stock | 0.4187 | 0.4187 | 0.4171 | 0.4181 | 1376880.0 |
| 2006-03-16 09:30:00 | NVDA | Stock | 0.4181 | 0.4186 | 0.4125 | 0.4128 | 59536320.0 |
| 2006-03-16 10:00:00 | NVDA | Stock | 0.4128 | 0.415 | 0.4096 | 0.4117 | 50989080.0 |
| 2006-03-16 10:30:00 | NVDA | Stock | 0.4118 | 0.4121 | 0.4078 | 0.4106 | 41476200.0 |
| 2006-03-16 11:00:00 | NVDA | Stock | 0.4107 | 0.4127 | 0.4107 | 0.4119 | 46425000.0 |
| 2006-03-16 11:30:00 | NVDA | Stock | 0.4121 | 0.4132 | 0.4108 | 0.4119 | 17511360.0 |
> showing 50 of 48,234 rows — these rows as CSV