PREVIEW / stock_30min / 2009-01-29
file: by_date/stock_30min/2009/2009-01-29.parquet size: 1.2 MB rows: 68,278 symbols: 3,291
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 |
|---|---|---|---|---|---|---|---|
| 2009-01-29 05:30:00 | AAPL | Stock | 3.3096 | 3.3096 | 3.3096 | 3.3096 | 6132.0 |
| 2009-01-29 08:00:00 | AAPL | Stock | 3.3214 | 3.3371 | 3.3214 | 3.3339 | 294196.0 |
| 2009-01-29 08:30:00 | AAPL | Stock | 3.3339 | 3.3346 | 3.3225 | 3.325 | 459284.0 |
| 2009-01-29 09:00:00 | AAPL | Stock | 3.3268 | 3.3282 | 3.3214 | 3.3239 | 586796.0 |
| 2009-01-29 09:30:00 | AAPL | Stock | 3.3246 | 3.3454 | 3.3146 | 3.3275 | 83791316.0 |
| 2009-01-29 10:00:00 | AAPL | Stock | 3.3275 | 3.3489 | 3.3196 | 3.3304 | 59809288.0 |
| 2009-01-29 10:30:00 | AAPL | Stock | 3.33 | 3.3575 | 3.3168 | 3.3504 | 52567116.0 |
| 2009-01-29 11:00:00 | AAPL | Stock | 3.3504 | 3.3693 | 3.3439 | 3.3521 | 43968092.0 |
| 2009-01-29 11:30:00 | AAPL | Stock | 3.3518 | 3.3639 | 3.3489 | 3.3518 | 29816724.0 |
| 2009-01-29 12:00:00 | AAPL | Stock | 3.3514 | 3.3539 | 3.3325 | 3.3536 | 33943056.0 |
| 2009-01-29 12:30:00 | AAPL | Stock | 3.3539 | 3.3564 | 3.325 | 3.3271 | 29491224.0 |
| 2009-01-29 13:00:00 | AAPL | Stock | 3.3271 | 3.3304 | 3.315 | 3.3296 | 36665636.0 |
| 2009-01-29 13:30:00 | AAPL | Stock | 3.3293 | 3.3304 | 3.3111 | 3.3232 | 27857536.0 |
| 2009-01-29 14:00:00 | AAPL | Stock | 3.3225 | 3.3293 | 3.3146 | 3.3279 | 27933276.0 |
| 2009-01-29 14:30:00 | AAPL | Stock | 3.3279 | 3.3368 | 3.3214 | 3.3293 | 31665256.0 |
| 2009-01-29 15:00:00 | AAPL | Stock | 3.3289 | 3.3414 | 3.3204 | 3.3282 | 41515964.0 |
| 2009-01-29 15:30:00 | AAPL | Stock | 3.3282 | 3.3282 | 3.3071 | 3.3214 | 76500396.0 |
| 2009-01-29 16:00:00 | AAPL | Stock | 3.3189 | 3.3332 | 3.3082 | 3.325 | 4399052.0 |
| 2009-01-29 16:30:00 | AAPL | Stock | 3.3246 | 3.3286 | 3.3214 | 3.3282 | 146440.0 |
| 2009-01-29 17:00:00 | AAPL | Stock | 3.3243 | 3.325 | 3.3214 | 3.3214 | 409164.0 |
| 2009-01-29 17:30:00 | AAPL | Stock | 3.3439 | 3.3439 | 3.3214 | 3.325 | 5576676.0 |
| 2009-01-29 18:00:00 | AAPL | Stock | 3.3214 | 3.325 | 3.32 | 3.325 | 139860.0 |
| 2009-01-29 18:30:00 | AAPL | Stock | 3.3214 | 3.3232 | 3.3214 | 3.3221 | 29260.0 |
| 2009-01-29 19:00:00 | AAPL | Stock | 3.3232 | 3.3232 | 3.3107 | 3.3107 | 127960.0 |
| 2009-01-29 19:30:00 | AAPL | Stock | 3.3107 | 3.3179 | 3.3082 | 3.3179 | 53900.0 |
| 2009-01-29 20:00:00 | AAPL | Stock | 3.3539 | 3.3539 | 3.3539 | 3.3539 | 231868.0 |
| 2009-01-29 07:00:00 | MSFT | Stock | 18.0 | 18.0 | 18.0 | 18.0 | 1150.0 |
| 2009-01-29 07:30:00 | MSFT | Stock | 18.02 | 18.02 | 17.75 | 17.99 | 2190.0 |
| 2009-01-29 08:00:00 | MSFT | Stock | 17.99 | 17.99 | 17.82 | 17.9 | 6100.0 |
| 2009-01-29 08:30:00 | MSFT | Stock | 17.84 | 17.85 | 17.83 | 17.84 | 8360.0 |
| 2009-01-29 09:00:00 | MSFT | Stock | 17.82 | 17.85 | 17.78 | 17.78 | 18380.0 |
| 2009-01-29 09:30:00 | MSFT | Stock | 17.79 | 17.93 | 17.7 | 17.81 | 5418879.0 |
| 2009-01-29 10:00:00 | MSFT | Stock | 17.8 | 17.88 | 17.75 | 17.85 | 3048831.0 |
| 2009-01-29 10:30:00 | MSFT | Stock | 17.85 | 17.93 | 17.78 | 17.91 | 2577399.0 |
| 2009-01-29 11:00:00 | MSFT | Stock | 17.91 | 17.96 | 17.84 | 17.848 | 2712322.0 |
| 2009-01-29 11:30:00 | MSFT | Stock | 17.84 | 17.87 | 17.77 | 17.812 | 1778159.0 |
| 2009-01-29 12:00:00 | MSFT | Stock | 17.81 | 17.83 | 17.75 | 17.78 | 2079975.0 |
| 2009-01-29 12:30:00 | MSFT | Stock | 17.78 | 17.8 | 17.68 | 17.69 | 2609040.0 |
| 2009-01-29 13:00:00 | MSFT | Stock | 17.69 | 17.7 | 17.56 | 17.669 | 2429084.0 |
| 2009-01-29 13:30:00 | MSFT | Stock | 17.67 | 17.7 | 17.6 | 17.66 | 1890563.0 |
| 2009-01-29 14:00:00 | MSFT | Stock | 17.66 | 17.74 | 17.64 | 17.73 | 1487671.0 |
| 2009-01-29 14:30:00 | MSFT | Stock | 17.72 | 17.87 | 17.69 | 17.785 | 5507482.0 |
| 2009-01-29 15:00:00 | MSFT | Stock | 17.79 | 17.89 | 17.76 | 17.81 | 4496381.0 |
| 2009-01-29 15:30:00 | MSFT | Stock | 17.81 | 17.82 | 17.58 | 17.6 | 8621517.0 |
| 2009-01-29 16:00:00 | MSFT | Stock | 17.6 | 17.93 | 17.59 | 17.59 | 3445532.0 |
| 2009-01-29 16:30:00 | MSFT | Stock | 17.8 | 17.8 | 17.63 | 17.63 | 32100.0 |
| 2009-01-29 17:00:00 | MSFT | Stock | 17.68 | 17.68 | 17.59 | 17.64 | 94996.0 |
| 2009-01-29 17:30:00 | MSFT | Stock | 17.792 | 17.792 | 17.59 | 17.64 | 581403.0 |
| 2009-01-29 18:00:00 | MSFT | Stock | 17.69 | 17.69 | 17.64 | 17.64 | 700.0 |
| 2009-01-29 18:30:00 | MSFT | Stock | 17.69 | 17.69 | 17.64 | 17.64 | 900.0 |
> showing 50 of 68,278 rows — these rows as CSV