PREVIEW / stock_30min / 2008-01-10
file: by_date/stock_30min/2008/2008-01-10.parquet size: 1.2 MB rows: 69,419 symbols: 3,261
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-10 04:00:00 | AAPL | Stock | 6.4286 | 6.4286 | 6.4286 | 6.4286 | 2800.0 |
| 2008-01-10 04:30:00 | AAPL | Stock | 6.4018 | 6.4071 | 6.4018 | 6.4071 | 16800.0 |
| 2008-01-10 05:00:00 | AAPL | Stock | 6.4075 | 6.4075 | 6.4075 | 6.4075 | 2800.0 |
| 2008-01-10 05:30:00 | AAPL | Stock | 6.4175 | 6.4175 | 6.4175 | 6.4175 | 8400.0 |
| 2008-01-10 06:30:00 | AAPL | Stock | 6.3932 | 6.4214 | 6.3932 | 6.4214 | 56000.0 |
| 2008-01-10 07:00:00 | AAPL | Stock | 6.4004 | 6.4214 | 6.3929 | 6.4214 | 152600.0 |
| 2008-01-10 07:30:00 | AAPL | Stock | 6.4243 | 6.4304 | 6.3975 | 6.4086 | 558180.0 |
| 2008-01-10 08:00:00 | AAPL | Stock | 6.4171 | 6.4311 | 6.3482 | 6.3571 | 4893448.0 |
| 2008-01-10 08:30:00 | AAPL | Stock | 6.3611 | 6.3804 | 6.3214 | 6.3461 | 6548528.0 |
| 2008-01-10 09:00:00 | AAPL | Stock | 6.3454 | 6.3564 | 6.2857 | 6.3439 | 5338732.0 |
| 2008-01-10 09:30:00 | AAPL | Stock | 6.3443 | 6.3489 | 6.2646 | 6.2925 | 190249724.0 |
| 2008-01-10 10:00:00 | AAPL | Stock | 6.2921 | 6.3336 | 6.275 | 6.2893 | 147528192.0 |
| 2008-01-10 10:30:00 | AAPL | Stock | 6.2893 | 6.3196 | 6.2679 | 6.2907 | 94230584.0 |
| 2008-01-10 11:00:00 | AAPL | Stock | 6.2921 | 6.3168 | 6.2739 | 6.3054 | 61931380.0 |
| 2008-01-10 11:30:00 | AAPL | Stock | 6.3061 | 6.3121 | 6.2896 | 6.3082 | 40969880.0 |
| 2008-01-10 12:00:00 | AAPL | Stock | 6.3082 | 6.4643 | 6.3 | 6.3768 | 158354952.0 |
| 2008-01-10 12:30:00 | AAPL | Stock | 6.3764 | 6.4229 | 6.3236 | 6.405 | 153881616.0 |
| 2008-01-10 13:00:00 | AAPL | Stock | 6.4043 | 6.4221 | 6.3671 | 6.4089 | 98784588.0 |
| 2008-01-10 13:30:00 | AAPL | Stock | 6.4073 | 6.4254 | 6.2979 | 6.3364 | 122012044.0 |
| 2008-01-10 14:00:00 | AAPL | Stock | 6.335 | 6.3843 | 6.3132 | 6.3475 | 93168012.0 |
| 2008-01-10 14:30:00 | AAPL | Stock | 6.3475 | 6.4232 | 6.3461 | 6.4055 | 88952696.0 |
| 2008-01-10 15:00:00 | AAPL | Stock | 6.4046 | 6.4321 | 6.3786 | 6.4246 | 88995004.0 |
| 2008-01-10 15:30:00 | AAPL | Stock | 6.4225 | 6.4311 | 6.3314 | 6.3579 | 109181968.0 |
| 2008-01-10 16:00:00 | AAPL | Stock | 6.3579 | 6.3884 | 6.3214 | 6.3289 | 10954608.0 |
| 2008-01-10 16:30:00 | AAPL | Stock | 6.3579 | 6.4268 | 6.3214 | 6.3282 | 4048464.0 |
| 2008-01-10 17:00:00 | AAPL | Stock | 6.3225 | 6.3295 | 6.3107 | 6.325 | 414260.0 |
| 2008-01-10 17:30:00 | AAPL | Stock | 6.3264 | 6.3286 | 6.3225 | 6.325 | 238644.0 |
| 2008-01-10 18:00:00 | AAPL | Stock | 6.3225 | 6.3282 | 6.3125 | 6.3232 | 406952.0 |
| 2008-01-10 18:30:00 | AAPL | Stock | 6.3221 | 6.3257 | 6.3161 | 6.3243 | 597604.0 |
| 2008-01-10 19:00:00 | AAPL | Stock | 6.3204 | 6.3243 | 6.3171 | 6.3207 | 205576.0 |
| 2008-01-10 19:30:00 | AAPL | Stock | 6.3214 | 6.3371 | 6.3182 | 6.3311 | 274764.0 |
| 2008-01-10 08:00:00 | MSFT | Stock | 34.39 | 34.39 | 34.35 | 34.35 | 6050.0 |
| 2008-01-10 08:30:00 | MSFT | Stock | 34.39 | 34.4 | 34.25 | 34.25 | 18995.0 |
| 2008-01-10 09:00:00 | MSFT | Stock | 34.25 | 34.36 | 34.12 | 34.21 | 334113.0 |
| 2008-01-10 09:30:00 | MSFT | Stock | 34.35 | 34.37 | 34.05 | 34.305 | 6019838.0 |
| 2008-01-10 10:00:00 | MSFT | Stock | 34.3 | 34.312 | 34.03 | 34.032 | 4696767.0 |
| 2008-01-10 10:30:00 | MSFT | Stock | 34.03 | 34.15 | 33.9 | 33.95 | 4278280.0 |
| 2008-01-10 11:00:00 | MSFT | Stock | 33.94 | 34.03 | 33.85 | 33.99 | 3095230.0 |
| 2008-01-10 11:30:00 | MSFT | Stock | 34.0 | 34.07 | 33.94 | 33.989 | 3394332.0 |
| 2008-01-10 12:00:00 | MSFT | Stock | 33.98 | 34.5 | 33.97 | 34.11 | 7011397.0 |
| 2008-01-10 12:30:00 | MSFT | Stock | 34.11 | 34.25 | 33.96 | 34.13 | 7118806.0 |
| 2008-01-10 13:00:00 | MSFT | Stock | 34.129 | 34.17 | 33.96 | 34.06 | 4242966.0 |
| 2008-01-10 13:30:00 | MSFT | Stock | 34.07 | 34.1 | 33.78 | 33.95 | 4450344.0 |
| 2008-01-10 14:00:00 | MSFT | Stock | 33.95 | 34.39 | 33.94 | 34.23 | 5608571.0 |
| 2008-01-10 14:30:00 | MSFT | Stock | 34.22 | 34.4 | 34.19 | 34.2 | 5136985.0 |
| 2008-01-10 15:00:00 | MSFT | Stock | 34.21 | 34.44 | 34.17 | 34.27 | 5221719.0 |
| 2008-01-10 15:30:00 | MSFT | Stock | 34.275 | 34.36 | 34.14 | 34.32 | 7711753.0 |
| 2008-01-10 16:00:00 | MSFT | Stock | 34.33 | 34.33 | 33.99 | 34.22 | 3683148.0 |
| 2008-01-10 16:30:00 | MSFT | Stock | 34.33 | 34.44 | 34.153 | 34.19 | 411382.0 |
| 2008-01-10 17:00:00 | MSFT | Stock | 34.18 | 34.29 | 34.18 | 34.29 | 1800.0 |
> showing 50 of 69,419 rows — these rows as CSV