PREVIEW / stock_30min / 2008-11-05
file: by_date/stock_30min/2008/2008-11-05.parquet size: 1.2 MB rows: 69,275 symbols: 3,280
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-11-05 04:00:00 | AAPL | Stock | 3.9529 | 3.9529 | 3.9529 | 3.9529 | 8400.0 |
| 2008-11-05 06:30:00 | AAPL | Stock | 3.9425 | 3.9425 | 3.9282 | 3.9282 | 14000.0 |
| 2008-11-05 07:00:00 | AAPL | Stock | 3.9282 | 3.9289 | 3.9039 | 3.9118 | 280000.0 |
| 2008-11-05 07:30:00 | AAPL | Stock | 3.9207 | 3.9207 | 3.8929 | 3.8929 | 397600.0 |
| 2008-11-05 08:00:00 | AAPL | Stock | 3.8954 | 3.9161 | 3.8857 | 3.8968 | 2373924.0 |
| 2008-11-05 08:30:00 | AAPL | Stock | 3.8929 | 3.9064 | 3.8875 | 3.9039 | 1083964.0 |
| 2008-11-05 09:00:00 | AAPL | Stock | 3.9036 | 3.9046 | 3.8693 | 3.8925 | 2626064.0 |
| 2008-11-05 09:30:00 | AAPL | Stock | 3.8929 | 3.9011 | 3.8304 | 3.8757 | 167358464.0 |
| 2008-11-05 10:00:00 | AAPL | Stock | 3.8761 | 3.9164 | 3.8671 | 3.9061 | 113736084.0 |
| 2008-11-05 10:30:00 | AAPL | Stock | 3.9064 | 3.9186 | 3.8625 | 3.8689 | 82885628.0 |
| 2008-11-05 11:00:00 | AAPL | Stock | 3.8696 | 3.8832 | 3.8625 | 3.8711 | 59669708.0 |
| 2008-11-05 11:30:00 | AAPL | Stock | 3.8707 | 3.8732 | 3.8429 | 3.8504 | 62671196.0 |
| 2008-11-05 12:00:00 | AAPL | Stock | 3.8507 | 3.8557 | 3.8021 | 3.8054 | 76692056.0 |
| 2008-11-05 12:30:00 | AAPL | Stock | 3.8057 | 3.8275 | 3.7796 | 3.8268 | 95689496.0 |
| 2008-11-05 13:00:00 | AAPL | Stock | 3.8268 | 3.8314 | 3.7918 | 3.8111 | 55253660.0 |
| 2008-11-05 13:30:00 | AAPL | Stock | 3.8111 | 3.8111 | 3.7704 | 3.7754 | 70702212.0 |
| 2008-11-05 14:00:00 | AAPL | Stock | 3.775 | 3.7857 | 3.7539 | 3.7707 | 84782068.0 |
| 2008-11-05 14:30:00 | AAPL | Stock | 3.7714 | 3.7971 | 3.7589 | 3.7618 | 85849960.0 |
| 2008-11-05 15:00:00 | AAPL | Stock | 3.7628 | 3.7832 | 3.7275 | 3.7389 | 100600696.0 |
| 2008-11-05 15:30:00 | AAPL | Stock | 3.7393 | 3.7407 | 3.6782 | 3.6879 | 164958780.0 |
| 2008-11-05 16:00:00 | AAPL | Stock | 3.6875 | 3.8136 | 3.6871 | 3.6982 | 18620476.0 |
| 2008-11-05 16:30:00 | AAPL | Stock | 3.6986 | 3.8119 | 3.65 | 3.65 | 1826188.0 |
| 2008-11-05 17:00:00 | AAPL | Stock | 3.6536 | 3.6536 | 3.6143 | 3.6382 | 1574076.0 |
| 2008-11-05 17:30:00 | AAPL | Stock | 3.6321 | 3.6893 | 3.6268 | 3.6346 | 502264.0 |
| 2008-11-05 18:00:00 | AAPL | Stock | 3.6346 | 3.6368 | 3.6282 | 3.63 | 266280.0 |
| 2008-11-05 18:30:00 | AAPL | Stock | 3.6339 | 3.6346 | 3.6286 | 3.6339 | 251412.0 |
| 2008-11-05 19:00:00 | AAPL | Stock | 3.6321 | 3.6375 | 3.6304 | 3.6321 | 130816.0 |
| 2008-11-05 19:30:00 | AAPL | Stock | 3.6321 | 3.6393 | 3.6286 | 3.6321 | 334488.0 |
| 2008-11-05 06:00:00 | MSFT | Stock | 23.75 | 23.75 | 23.75 | 23.75 | 100.0 |
| 2008-11-05 07:00:00 | MSFT | Stock | 23.5 | 23.5 | 23.49 | 23.49 | 2100.0 |
| 2008-11-05 07:30:00 | MSFT | Stock | 23.17 | 23.29 | 23.15 | 23.29 | 1600.0 |
| 2008-11-05 08:00:00 | MSFT | Stock | 23.29 | 23.35 | 23.25 | 23.27 | 17698.0 |
| 2008-11-05 08:30:00 | MSFT | Stock | 23.25 | 23.3 | 23.11 | 23.24 | 18088.0 |
| 2008-11-05 09:00:00 | MSFT | Stock | 23.25 | 23.27 | 23.2 | 23.26 | 12405.0 |
| 2008-11-05 09:30:00 | MSFT | Stock | 23.27 | 23.34 | 23.11 | 23.175 | 5143088.0 |
| 2008-11-05 10:00:00 | MSFT | Stock | 23.18 | 23.34 | 23.15 | 23.31 | 5551917.0 |
| 2008-11-05 10:30:00 | MSFT | Stock | 23.308 | 23.34 | 23.2 | 23.25 | 3279737.0 |
| 2008-11-05 11:00:00 | MSFT | Stock | 23.25 | 23.3 | 23.08 | 23.12 | 3136786.0 |
| 2008-11-05 11:30:00 | MSFT | Stock | 23.12 | 23.12 | 22.74 | 22.91 | 7212560.0 |
| 2008-11-05 12:00:00 | MSFT | Stock | 22.91 | 22.93 | 22.7 | 22.71 | 4673546.0 |
| 2008-11-05 12:30:00 | MSFT | Stock | 22.71 | 22.78 | 22.57 | 22.77 | 3961447.0 |
| 2008-11-05 13:00:00 | MSFT | Stock | 22.77 | 22.8 | 22.65 | 22.76 | 4043201.0 |
| 2008-11-05 13:30:00 | MSFT | Stock | 22.76 | 22.85 | 22.64 | 22.69 | 4173022.0 |
| 2008-11-05 14:00:00 | MSFT | Stock | 22.69 | 22.74 | 22.53 | 22.62 | 4560557.0 |
| 2008-11-05 14:30:00 | MSFT | Stock | 22.62 | 22.8 | 22.6 | 22.688 | 4506335.0 |
| 2008-11-05 15:00:00 | MSFT | Stock | 22.68 | 22.8 | 22.52 | 22.57 | 6217493.0 |
| 2008-11-05 15:30:00 | MSFT | Stock | 22.57 | 22.58 | 22.05 | 22.08 | 15526195.0 |
| 2008-11-05 16:00:00 | MSFT | Stock | 22.08 | 23.206 | 22.07 | 22.19 | 5752945.0 |
| 2008-11-05 16:30:00 | MSFT | Stock | 22.19 | 22.715 | 21.89 | 22.0 | 95315.0 |
| 2008-11-05 17:00:00 | MSFT | Stock | 22.0 | 22.1 | 21.93 | 21.95 | 50870.0 |
> showing 50 of 69,275 rows — these rows as CSV