PREVIEW / stock_30min / 2009-08-07
file: by_date/stock_30min/2009/2009-08-07.parquet size: 1.3 MB rows: 71,514 symbols: 3,371
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-07 05:00:00 | AAPL | Stock | 5.8393 | 5.8393 | 5.8393 | 5.8393 | 2800.0 |
| 2009-08-07 05:30:00 | AAPL | Stock | 5.8232 | 5.8232 | 5.7993 | 5.7993 | 25200.0 |
| 2009-08-07 06:30:00 | AAPL | Stock | 5.8304 | 5.8304 | 5.8304 | 5.8304 | 5600.0 |
| 2009-08-07 07:30:00 | AAPL | Stock | 5.8304 | 5.8536 | 5.8286 | 5.8536 | 59780.0 |
| 2009-08-07 08:00:00 | AAPL | Stock | 5.8525 | 5.875 | 5.8436 | 5.8696 | 674548.0 |
| 2009-08-07 08:30:00 | AAPL | Stock | 5.8746 | 5.9214 | 5.8746 | 5.9143 | 2612036.0 |
| 2009-08-07 09:00:00 | AAPL | Stock | 5.9136 | 5.9246 | 5.9018 | 5.9075 | 1260644.0 |
| 2009-08-07 09:30:00 | AAPL | Stock | 5.9079 | 5.9304 | 5.8864 | 5.9036 | 58165800.0 |
| 2009-08-07 10:00:00 | AAPL | Stock | 5.9036 | 5.9161 | 5.8857 | 5.9089 | 36961764.0 |
| 2009-08-07 10:30:00 | AAPL | Stock | 5.9096 | 5.9368 | 5.9089 | 5.9311 | 34790028.0 |
| 2009-08-07 11:00:00 | AAPL | Stock | 5.9318 | 5.9357 | 5.9175 | 5.9307 | 23813888.0 |
| 2009-08-07 11:30:00 | AAPL | Stock | 5.9307 | 5.9425 | 5.92 | 5.9318 | 30033332.0 |
| 2009-08-07 12:00:00 | AAPL | Stock | 5.9321 | 5.9454 | 5.9314 | 5.9396 | 19493320.0 |
| 2009-08-07 12:30:00 | AAPL | Stock | 5.9404 | 5.95 | 5.9386 | 5.94 | 20457332.0 |
| 2009-08-07 13:00:00 | AAPL | Stock | 5.9407 | 5.9496 | 5.9296 | 5.9436 | 21184968.0 |
| 2009-08-07 13:30:00 | AAPL | Stock | 5.9439 | 5.9468 | 5.9339 | 5.9375 | 12790400.0 |
| 2009-08-07 14:00:00 | AAPL | Stock | 5.9382 | 5.9439 | 5.9286 | 5.934 | 14220388.0 |
| 2009-08-07 14:30:00 | AAPL | Stock | 5.9339 | 5.9393 | 5.9296 | 5.9318 | 15843436.0 |
| 2009-08-07 15:00:00 | AAPL | Stock | 5.9321 | 5.9332 | 5.9139 | 5.9268 | 29746864.0 |
| 2009-08-07 15:30:00 | AAPL | Stock | 5.9275 | 5.9325 | 5.9107 | 5.9136 | 47792192.0 |
| 2009-08-07 16:00:00 | AAPL | Stock | 5.9125 | 5.9367 | 5.9093 | 5.9146 | 13999916.0 |
| 2009-08-07 16:30:00 | AAPL | Stock | 5.9136 | 5.9154 | 5.9125 | 5.9125 | 152516.0 |
| 2009-08-07 17:00:00 | AAPL | Stock | 5.9154 | 5.9154 | 5.9114 | 5.9143 | 68460.0 |
| 2009-08-07 17:30:00 | AAPL | Stock | 5.9143 | 5.9143 | 5.91 | 5.9125 | 80192.0 |
| 2009-08-07 18:00:00 | AAPL | Stock | 5.9154 | 5.9154 | 5.9146 | 5.9154 | 372176.0 |
| 2009-08-07 18:30:00 | AAPL | Stock | 5.9193 | 5.9193 | 5.9193 | 5.9193 | 2800.0 |
| 2009-08-07 19:00:00 | AAPL | Stock | 5.9179 | 5.9286 | 5.9179 | 5.9254 | 116620.0 |
| 2009-08-07 19:30:00 | AAPL | Stock | 5.9171 | 5.9171 | 5.9171 | 5.9171 | 3220.0 |
| 2009-08-07 07:00:00 | MSFT | Stock | 23.46 | 23.46 | 23.46 | 23.46 | 500.0 |
| 2009-08-07 08:00:00 | MSFT | Stock | 23.4 | 23.48 | 23.4 | 23.48 | 6158.0 |
| 2009-08-07 08:30:00 | MSFT | Stock | 23.48 | 23.82 | 23.48 | 23.64 | 75787.0 |
| 2009-08-07 09:00:00 | MSFT | Stock | 23.64 | 23.77 | 23.61 | 23.75 | 38704.0 |
| 2009-08-07 09:30:00 | MSFT | Stock | 23.75 | 23.82 | 23.68 | 23.7 | 5575571.0 |
| 2009-08-07 10:00:00 | MSFT | Stock | 23.69 | 23.71 | 23.5 | 23.65 | 5187977.0 |
| 2009-08-07 10:30:00 | MSFT | Stock | 23.65 | 23.76 | 23.63 | 23.75 | 3302366.0 |
| 2009-08-07 11:00:00 | MSFT | Stock | 23.743 | 23.77 | 23.69 | 23.73 | 2602829.0 |
| 2009-08-07 11:30:00 | MSFT | Stock | 23.73 | 23.8 | 23.68 | 23.76 | 2157098.0 |
| 2009-08-07 12:00:00 | MSFT | Stock | 23.75 | 23.78 | 23.66 | 23.66 | 2065209.0 |
| 2009-08-07 12:30:00 | MSFT | Stock | 23.66 | 23.76 | 23.65 | 23.74 | 2828584.0 |
| 2009-08-07 13:00:00 | MSFT | Stock | 23.75 | 23.78 | 23.7 | 23.76 | 2000509.0 |
| 2009-08-07 13:30:00 | MSFT | Stock | 23.76 | 23.77 | 23.66 | 23.67 | 1847847.0 |
| 2009-08-07 14:00:00 | MSFT | Stock | 23.67 | 23.71 | 23.58 | 23.587 | 2888276.0 |
| 2009-08-07 14:30:00 | MSFT | Stock | 23.59 | 23.63 | 23.57 | 23.59 | 2156104.0 |
| 2009-08-07 15:00:00 | MSFT | Stock | 23.6 | 23.63 | 23.56 | 23.63 | 3674576.0 |
| 2009-08-07 15:30:00 | MSFT | Stock | 23.63 | 23.68 | 23.56 | 23.57 | 6453134.0 |
| 2009-08-07 16:00:00 | MSFT | Stock | 23.59 | 23.676 | 23.55 | 23.57 | 2725703.0 |
| 2009-08-07 16:30:00 | MSFT | Stock | 23.56 | 23.56 | 23.55 | 23.55 | 1498.0 |
| 2009-08-07 17:00:00 | MSFT | Stock | 23.55 | 23.55 | 23.54 | 23.54 | 757.0 |
| 2009-08-07 17:30:00 | MSFT | Stock | 23.56 | 23.59 | 23.56 | 23.59 | 3920.0 |
| 2009-08-07 18:00:00 | MSFT | Stock | 23.58 | 23.59 | 23.58 | 23.58 | 1720.0 |
> showing 50 of 71,514 rows — these rows as CSV