PREVIEW / stock_30min / 2010-12-30
file: by_date/stock_30min/2010/2010-12-30.parquet size: 1.4 MB rows: 73,812 symbols: 3,532
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-12-30 04:00:00 | AAPL | Stock | 11.6286 | 11.6425 | 11.6286 | 11.6425 | 5600.0 |
| 2010-12-30 04:30:00 | AAPL | Stock | 11.6425 | 11.6425 | 11.6425 | 11.6425 | 5600.0 |
| 2010-12-30 05:00:00 | AAPL | Stock | 11.6239 | 11.6239 | 11.6239 | 11.6239 | 2800.0 |
| 2010-12-30 06:00:00 | AAPL | Stock | 11.6239 | 11.6239 | 11.6239 | 11.6239 | 8400.0 |
| 2010-12-30 06:30:00 | AAPL | Stock | 11.6239 | 11.6239 | 11.6136 | 11.6136 | 5600.0 |
| 2010-12-30 07:00:00 | AAPL | Stock | 11.6139 | 11.6139 | 11.6139 | 11.6139 | 11200.0 |
| 2010-12-30 07:30:00 | AAPL | Stock | 11.6175 | 11.6175 | 11.6075 | 11.6075 | 11200.0 |
| 2010-12-30 08:00:00 | AAPL | Stock | 11.6114 | 11.6311 | 11.6107 | 11.6211 | 750708.0 |
| 2010-12-30 08:30:00 | AAPL | Stock | 11.6214 | 11.6318 | 11.6214 | 11.625 | 351092.0 |
| 2010-12-30 09:00:00 | AAPL | Stock | 11.6246 | 11.6318 | 11.6214 | 11.6214 | 272552.0 |
| 2010-12-30 09:30:00 | AAPL | Stock | 11.6207 | 11.6254 | 11.5757 | 11.5796 | 22002288.0 |
| 2010-12-30 10:00:00 | AAPL | Stock | 11.5779 | 11.5821 | 11.554 | 11.5782 | 26117308.0 |
| 2010-12-30 10:30:00 | AAPL | Stock | 11.5779 | 11.5821 | 11.5686 | 11.5696 | 9669660.0 |
| 2010-12-30 11:00:00 | AAPL | Stock | 11.5696 | 11.5739 | 11.5564 | 11.5571 | 8982428.0 |
| 2010-12-30 11:30:00 | AAPL | Stock | 11.5571 | 11.5654 | 11.5461 | 11.5511 | 9563232.0 |
| 2010-12-30 12:00:00 | AAPL | Stock | 11.5507 | 11.5604 | 11.5489 | 11.5546 | 5359340.0 |
| 2010-12-30 12:30:00 | AAPL | Stock | 11.555 | 11.5568 | 11.5429 | 11.5432 | 6411244.0 |
| 2010-12-30 13:00:00 | AAPL | Stock | 11.5439 | 11.5507 | 11.5375 | 11.5489 | 8215032.0 |
| 2010-12-30 13:30:00 | AAPL | Stock | 11.5493 | 11.5561 | 11.5464 | 11.5532 | 4784668.0 |
| 2010-12-30 14:00:00 | AAPL | Stock | 11.5535 | 11.5568 | 11.5464 | 11.5545 | 5583984.0 |
| 2010-12-30 14:30:00 | AAPL | Stock | 11.5543 | 11.5721 | 11.5536 | 11.5693 | 8901116.0 |
| 2010-12-30 15:00:00 | AAPL | Stock | 11.57 | 11.5796 | 11.5657 | 11.5764 | 10457552.0 |
| 2010-12-30 15:30:00 | AAPL | Stock | 11.5779 | 11.58 | 11.5514 | 11.5593 | 21103152.0 |
| 2010-12-30 16:00:00 | AAPL | Stock | 11.5593 | 11.5681 | 11.5525 | 11.5561 | 6494768.0 |
| 2010-12-30 16:30:00 | AAPL | Stock | 11.5561 | 11.6293 | 11.5536 | 11.6293 | 267820.0 |
| 2010-12-30 17:00:00 | AAPL | Stock | 11.5561 | 11.5589 | 11.5561 | 11.5589 | 18620.0 |
| 2010-12-30 17:30:00 | AAPL | Stock | 11.5586 | 11.5586 | 11.5586 | 11.5586 | 2800.0 |
| 2010-12-30 18:00:00 | AAPL | Stock | 11.5571 | 11.5593 | 11.5571 | 11.5571 | 106092.0 |
| 2010-12-30 18:30:00 | AAPL | Stock | 11.5571 | 11.5589 | 11.5571 | 11.5589 | 38640.0 |
| 2010-12-30 19:00:00 | AAPL | Stock | 11.5586 | 11.5589 | 11.5586 | 11.5589 | 13272.0 |
| 2010-12-30 19:30:00 | AAPL | Stock | 11.5593 | 11.5593 | 11.5571 | 11.5571 | 82796.0 |
| 2010-12-30 07:00:00 | MSFT | Stock | 27.98 | 27.98 | 27.95 | 27.95 | 1200.0 |
| 2010-12-30 07:30:00 | MSFT | Stock | 28.01 | 28.09 | 27.95 | 28.09 | 500.0 |
| 2010-12-30 08:30:00 | MSFT | Stock | 28.04 | 28.04 | 28.04 | 28.04 | 2124.0 |
| 2010-12-30 09:00:00 | MSFT | Stock | 28.0 | 28.0 | 27.92 | 27.93 | 101456.0 |
| 2010-12-30 09:30:00 | MSFT | Stock | 27.93 | 28.0 | 27.9 | 27.925 | 2082702.0 |
| 2010-12-30 10:00:00 | MSFT | Stock | 27.93 | 27.94 | 27.86 | 27.92 | 2204843.0 |
| 2010-12-30 10:30:00 | MSFT | Stock | 27.93 | 27.94 | 27.86 | 27.86 | 1557716.0 |
| 2010-12-30 11:00:00 | MSFT | Stock | 27.86 | 27.88 | 27.78 | 27.805 | 1384459.0 |
| 2010-12-30 11:30:00 | MSFT | Stock | 27.8 | 27.83 | 27.79 | 27.81 | 1162685.0 |
| 2010-12-30 12:00:00 | MSFT | Stock | 27.815 | 27.83 | 27.775 | 27.805 | 1529138.0 |
| 2010-12-30 12:30:00 | MSFT | Stock | 27.8 | 27.83 | 27.8 | 27.802 | 806287.0 |
| 2010-12-30 13:00:00 | MSFT | Stock | 27.8 | 27.82 | 27.8 | 27.8 | 734586.0 |
| 2010-12-30 13:30:00 | MSFT | Stock | 27.8 | 27.83 | 27.785 | 27.82 | 1324684.0 |
| 2010-12-30 14:00:00 | MSFT | Stock | 27.825 | 27.87 | 27.82 | 27.85 | 1409596.0 |
| 2010-12-30 14:30:00 | MSFT | Stock | 27.85 | 27.86 | 27.83 | 27.86 | 913261.0 |
| 2010-12-30 15:00:00 | MSFT | Stock | 27.86 | 27.905 | 27.845 | 27.9 | 1202219.0 |
| 2010-12-30 15:30:00 | MSFT | Stock | 27.9 | 27.91 | 27.85 | 27.865 | 2903188.0 |
| 2010-12-30 16:00:00 | MSFT | Stock | 27.85 | 27.91 | 27.85 | 27.85 | 879687.0 |
| 2010-12-30 16:30:00 | MSFT | Stock | 27.89 | 27.89 | 27.84 | 27.855 | 24933.0 |
> showing 50 of 73,812 rows — these rows as CSV