PREVIEW / stock_30min / 2010-05-21
file: by_date/stock_30min/2010/2010-05-21.parquet size: 1.4 MB rows: 76,710 symbols: 3,492
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 |
|---|---|---|---|---|---|---|---|
| 2010-05-21 04:00:00 | AAPL | Stock | 8.4182 | 8.4336 | 8.4182 | 8.4304 | 42644.0 |
| 2010-05-21 04:30:00 | AAPL | Stock | 8.4593 | 8.4993 | 8.4593 | 8.4993 | 14000.0 |
| 2010-05-21 05:00:00 | AAPL | Stock | 8.4993 | 8.5136 | 8.4893 | 8.5136 | 22400.0 |
| 2010-05-21 05:30:00 | AAPL | Stock | 8.4607 | 8.4607 | 8.4607 | 8.4607 | 2800.0 |
| 2010-05-21 06:00:00 | AAPL | Stock | 8.4571 | 8.4571 | 8.4571 | 8.4571 | 2800.0 |
| 2010-05-21 06:30:00 | AAPL | Stock | 8.4182 | 8.4286 | 8.4182 | 8.4286 | 19600.0 |
| 2010-05-21 07:00:00 | AAPL | Stock | 8.4179 | 8.4289 | 8.3268 | 8.3286 | 664692.0 |
| 2010-05-21 07:30:00 | AAPL | Stock | 8.3268 | 8.3643 | 8.2504 | 8.3479 | 1851668.0 |
| 2010-05-21 08:00:00 | AAPL | Stock | 8.3671 | 8.3746 | 8.3279 | 8.335 | 3390352.0 |
| 2010-05-21 08:30:00 | AAPL | Stock | 8.3371 | 8.4182 | 8.3304 | 8.4143 | 5509252.0 |
| 2010-05-21 09:00:00 | AAPL | Stock | 8.4111 | 8.4111 | 8.2982 | 8.3036 | 6716304.0 |
| 2010-05-21 09:30:00 | AAPL | Stock | 8.315 | 8.5493 | 8.2625 | 8.4775 | 287168896.0 |
| 2010-05-21 10:00:00 | AAPL | Stock | 8.4743 | 8.5614 | 8.4521 | 8.4925 | 122255392.0 |
| 2010-05-21 10:30:00 | AAPL | Stock | 8.4936 | 8.5996 | 8.4732 | 8.5804 | 106475348.0 |
| 2010-05-21 11:00:00 | AAPL | Stock | 8.5789 | 8.6607 | 8.4676 | 8.6543 | 89909288.0 |
| 2010-05-21 11:30:00 | AAPL | Stock | 8.6536 | 8.7321 | 8.6368 | 8.6732 | 84337960.0 |
| 2010-05-21 12:00:00 | AAPL | Stock | 8.6746 | 8.7204 | 8.6482 | 8.6857 | 52519600.0 |
| 2010-05-21 12:30:00 | AAPL | Stock | 8.6871 | 8.7032 | 8.6339 | 8.6464 | 46086040.0 |
| 2010-05-21 13:00:00 | AAPL | Stock | 8.6464 | 8.665 | 8.5964 | 8.6146 | 52200904.0 |
| 2010-05-21 13:30:00 | AAPL | Stock | 8.615 | 8.6571 | 8.6054 | 8.6303 | 37159276.0 |
| 2010-05-21 14:00:00 | AAPL | Stock | 8.6299 | 8.6518 | 8.5714 | 8.5899 | 58883300.0 |
| 2010-05-21 14:30:00 | AAPL | Stock | 8.5886 | 8.6068 | 8.5232 | 8.5461 | 62106044.0 |
| 2010-05-21 15:00:00 | AAPL | Stock | 8.5461 | 8.5875 | 8.515 | 8.5621 | 73143728.0 |
| 2010-05-21 15:30:00 | AAPL | Stock | 8.5621 | 8.6557 | 8.5436 | 8.6546 | 107374932.0 |
| 2010-05-21 16:00:00 | AAPL | Stock | 8.6554 | 8.6561 | 8.544 | 8.6071 | 18546444.0 |
| 2010-05-21 16:30:00 | AAPL | Stock | 8.6064 | 8.6518 | 8.568 | 8.6329 | 667856.0 |
| 2010-05-21 17:00:00 | AAPL | Stock | 8.6232 | 8.6493 | 8.6161 | 8.6432 | 430052.0 |
| 2010-05-21 17:30:00 | AAPL | Stock | 8.6489 | 8.6514 | 8.6429 | 8.6507 | 214340.0 |
| 2010-05-21 18:00:00 | AAPL | Stock | 8.6511 | 8.6514 | 8.6452 | 8.6514 | 129220.0 |
| 2010-05-21 18:30:00 | AAPL | Stock | 8.65 | 8.66 | 8.6464 | 8.6571 | 136640.0 |
| 2010-05-21 19:00:00 | AAPL | Stock | 8.6571 | 8.66 | 8.6511 | 8.6511 | 118664.0 |
| 2010-05-21 19:30:00 | AAPL | Stock | 8.6521 | 8.6686 | 8.6482 | 8.6686 | 242928.0 |
| 2010-05-21 05:00:00 | MSFT | Stock | 27.15 | 27.2 | 27.09 | 27.09 | 4500.0 |
| 2010-05-21 05:30:00 | MSFT | Stock | 27.08 | 27.08 | 27.08 | 27.08 | 500.0 |
| 2010-05-21 06:00:00 | MSFT | Stock | 27.1 | 27.16 | 27.1 | 27.16 | 3940.0 |
| 2010-05-21 07:00:00 | MSFT | Stock | 26.97 | 26.97 | 26.74 | 26.75 | 4300.0 |
| 2010-05-21 07:30:00 | MSFT | Stock | 26.78 | 26.89 | 26.61 | 26.8 | 8773.0 |
| 2010-05-21 08:00:00 | MSFT | Stock | 26.8 | 26.96 | 26.8 | 26.8 | 32063.0 |
| 2010-05-21 08:30:00 | MSFT | Stock | 26.8 | 26.95 | 26.8 | 26.9 | 43800.0 |
| 2010-05-21 09:00:00 | MSFT | Stock | 26.88 | 27.0 | 26.61 | 26.61 | 321875.0 |
| 2010-05-21 09:30:00 | MSFT | Stock | 26.61 | 26.9 | 26.52 | 26.74 | 14708899.0 |
| 2010-05-21 10:00:00 | MSFT | Stock | 26.737 | 26.97 | 26.66 | 26.76 | 12184070.0 |
| 2010-05-21 10:30:00 | MSFT | Stock | 26.76 | 26.98 | 26.712 | 26.858 | 6326071.0 |
| 2010-05-21 11:00:00 | MSFT | Stock | 26.86 | 27.0 | 26.85 | 26.95 | 7717499.0 |
| 2010-05-21 11:30:00 | MSFT | Stock | 26.945 | 27.11 | 26.9 | 27.035 | 7229242.0 |
| 2010-05-21 12:00:00 | MSFT | Stock | 27.04 | 27.05 | 26.86 | 26.9 | 5838397.0 |
| 2010-05-21 12:30:00 | MSFT | Stock | 26.905 | 26.94 | 26.76 | 26.82 | 6144682.0 |
| 2010-05-21 13:00:00 | MSFT | Stock | 26.82 | 26.845 | 26.66 | 26.7 | 3642844.0 |
| 2010-05-21 13:30:00 | MSFT | Stock | 26.7 | 26.93 | 26.69 | 26.9 | 3914686.0 |
| 2010-05-21 14:00:00 | MSFT | Stock | 26.9 | 26.93 | 26.63 | 26.69 | 4428918.0 |
> showing 50 of 76,710 rows — these rows as CSV