PREVIEW / stock_30min / 2009-08-14
file: by_date/stock_30min/2009/2009-08-14.parquet size: 1.3 MB rows: 72,565 symbols: 3,355
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-08-14 05:00:00 | AAPL | Stock | 6.0268 | 6.0268 | 6.0268 | 6.0268 | 2800.0 |
| 2009-08-14 06:30:00 | AAPL | Stock | 6.0211 | 6.0268 | 6.0211 | 6.0211 | 16800.0 |
| 2009-08-14 07:30:00 | AAPL | Stock | 6.0179 | 6.0179 | 6.0089 | 6.0089 | 29400.0 |
| 2009-08-14 08:00:00 | AAPL | Stock | 6.0175 | 6.0179 | 6.0107 | 6.0107 | 292684.0 |
| 2009-08-14 08:30:00 | AAPL | Stock | 6.0136 | 6.0157 | 6.0011 | 6.0046 | 304864.0 |
| 2009-08-14 09:00:00 | AAPL | Stock | 6.0036 | 6.0054 | 5.9921 | 5.9936 | 297780.0 |
| 2009-08-14 09:30:00 | AAPL | Stock | 5.9968 | 6.0081 | 5.935 | 5.9554 | 57010660.0 |
| 2009-08-14 10:00:00 | AAPL | Stock | 5.9554 | 5.9568 | 5.9325 | 5.9414 | 36702064.0 |
| 2009-08-14 10:30:00 | AAPL | Stock | 5.9411 | 5.945 | 5.9146 | 5.9263 | 27361992.0 |
| 2009-08-14 11:00:00 | AAPL | Stock | 5.9257 | 5.9321 | 5.9175 | 5.9175 | 18022508.0 |
| 2009-08-14 11:30:00 | AAPL | Stock | 5.9171 | 5.9243 | 5.9118 | 5.9204 | 16946244.0 |
| 2009-08-14 12:00:00 | AAPL | Stock | 5.9204 | 5.9261 | 5.9146 | 5.9186 | 12038180.0 |
| 2009-08-14 12:30:00 | AAPL | Stock | 5.9186 | 5.9332 | 5.9144 | 5.9325 | 13012440.0 |
| 2009-08-14 13:00:00 | AAPL | Stock | 5.9329 | 5.9357 | 5.9229 | 5.9256 | 13059648.0 |
| 2009-08-14 13:30:00 | AAPL | Stock | 5.9254 | 5.9304 | 5.9152 | 5.9304 | 13477996.0 |
| 2009-08-14 14:00:00 | AAPL | Stock | 5.9304 | 5.9307 | 5.9189 | 5.9282 | 10973900.0 |
| 2009-08-14 14:30:00 | AAPL | Stock | 5.9282 | 5.9404 | 5.9254 | 5.9304 | 14407568.0 |
| 2009-08-14 15:00:00 | AAPL | Stock | 5.93 | 5.9421 | 5.9229 | 5.9232 | 16980992.0 |
| 2009-08-14 15:30:00 | AAPL | Stock | 5.9229 | 5.9575 | 5.9225 | 5.9571 | 38323264.0 |
| 2009-08-14 16:00:00 | AAPL | Stock | 5.9571 | 6.015 | 5.9378 | 5.96 | 11524408.0 |
| 2009-08-14 16:30:00 | AAPL | Stock | 5.96 | 5.9614 | 5.9564 | 5.9571 | 3371424.0 |
| 2009-08-14 17:00:00 | AAPL | Stock | 5.9539 | 5.9564 | 5.9536 | 5.9536 | 132664.0 |
| 2009-08-14 17:30:00 | AAPL | Stock | 5.9536 | 5.9536 | 5.9464 | 5.9468 | 251384.0 |
| 2009-08-14 18:00:00 | AAPL | Stock | 5.9468 | 5.9493 | 5.9446 | 5.9493 | 100800.0 |
| 2009-08-14 18:30:00 | AAPL | Stock | 5.9479 | 5.9489 | 5.9464 | 5.9489 | 28868.0 |
| 2009-08-14 19:00:00 | AAPL | Stock | 5.9493 | 5.9493 | 5.9471 | 5.9493 | 65912.0 |
| 2009-08-14 19:30:00 | AAPL | Stock | 5.9493 | 5.9493 | 5.9471 | 5.9471 | 43400.0 |
| 2009-08-14 07:30:00 | MSFT | Stock | 23.7 | 23.7 | 23.7 | 23.7 | 149.0 |
| 2009-08-14 08:00:00 | MSFT | Stock | 23.63 | 23.74 | 23.63 | 23.65 | 9300.0 |
| 2009-08-14 08:30:00 | MSFT | Stock | 23.65 | 23.69 | 23.6 | 23.65 | 7425.0 |
| 2009-08-14 09:00:00 | MSFT | Stock | 23.6 | 23.69 | 23.58 | 23.61 | 8413.0 |
| 2009-08-14 09:30:00 | MSFT | Stock | 23.62 | 23.8 | 23.52 | 23.68 | 8076323.0 |
| 2009-08-14 10:00:00 | MSFT | Stock | 23.68 | 23.77 | 23.55 | 23.66 | 7364587.0 |
| 2009-08-14 10:30:00 | MSFT | Stock | 23.66 | 23.75 | 23.61 | 23.71 | 4017323.0 |
| 2009-08-14 11:00:00 | MSFT | Stock | 23.7 | 23.74 | 23.57 | 23.57 | 2782484.0 |
| 2009-08-14 11:30:00 | MSFT | Stock | 23.57 | 23.63 | 23.55 | 23.59 | 2066660.0 |
| 2009-08-14 12:00:00 | MSFT | Stock | 23.592 | 23.62 | 23.57 | 23.59 | 1496059.0 |
| 2009-08-14 12:30:00 | MSFT | Stock | 23.58 | 23.61 | 23.56 | 23.61 | 2063293.0 |
| 2009-08-14 13:00:00 | MSFT | Stock | 23.61 | 23.61 | 23.56 | 23.588 | 1451704.0 |
| 2009-08-14 13:30:00 | MSFT | Stock | 23.58 | 23.59 | 23.55 | 23.58 | 1436010.0 |
| 2009-08-14 14:00:00 | MSFT | Stock | 23.58 | 23.59 | 23.54 | 23.55 | 1692009.0 |
| 2009-08-14 14:30:00 | MSFT | Stock | 23.55 | 23.59 | 23.54 | 23.55 | 1701878.0 |
| 2009-08-14 15:00:00 | MSFT | Stock | 23.545 | 23.57 | 23.51 | 23.53 | 1749240.0 |
| 2009-08-14 15:30:00 | MSFT | Stock | 23.525 | 23.71 | 23.52 | 23.71 | 5504665.0 |
| 2009-08-14 16:00:00 | MSFT | Stock | 23.69 | 24.32 | 23.599 | 23.7 | 2984324.0 |
| 2009-08-14 16:30:00 | MSFT | Stock | 23.7 | 23.7 | 23.65 | 23.7 | 509766.0 |
| 2009-08-14 17:00:00 | MSFT | Stock | 23.71 | 23.71 | 23.68 | 23.68 | 1400.0 |
| 2009-08-14 17:30:00 | MSFT | Stock | 23.65 | 23.7 | 23.65 | 23.7 | 600.0 |
| 2009-08-14 18:00:00 | MSFT | Stock | 23.65 | 23.7 | 23.65 | 23.7 | 1119.0 |
| 2009-08-14 18:30:00 | MSFT | Stock | 23.65 | 23.65 | 23.65 | 23.65 | 200.0 |
> showing 50 of 72,565 rows — these rows as CSV