PREVIEW / stock_30min / 2006-05-05
file: by_date/stock_30min/2006/2006-05-05.parquet size: 917 KB rows: 49,351 symbols: 2,260
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 |
|---|---|---|---|---|---|---|---|
| 2006-05-05 08:00:00 | AAPL | Stock | 2.5496 | 2.55 | 2.5443 | 2.5464 | 78736.0 |
| 2006-05-05 08:30:00 | AAPL | Stock | 2.5464 | 2.5643 | 2.5439 | 2.5621 | 1743056.0 |
| 2006-05-05 09:00:00 | AAPL | Stock | 2.56 | 2.5679 | 2.5582 | 2.5679 | 1445080.0 |
| 2006-05-05 09:30:00 | AAPL | Stock | 2.5664 | 2.5804 | 2.5411 | 2.5668 | 130176340.0 |
| 2006-05-05 10:00:00 | AAPL | Stock | 2.5671 | 2.5693 | 2.5529 | 2.5564 | 64256808.0 |
| 2006-05-05 10:30:00 | AAPL | Stock | 2.5564 | 2.5618 | 2.5432 | 2.5618 | 58967916.0 |
| 2006-05-05 11:00:00 | AAPL | Stock | 2.5614 | 2.5625 | 2.5518 | 2.5546 | 29404060.0 |
| 2006-05-05 11:30:00 | AAPL | Stock | 2.555 | 2.5596 | 2.5518 | 2.5536 | 25278736.0 |
| 2006-05-05 12:00:00 | AAPL | Stock | 2.5539 | 2.5682 | 2.5529 | 2.5679 | 33662832.0 |
| 2006-05-05 12:30:00 | AAPL | Stock | 2.5675 | 2.5711 | 2.56 | 2.56 | 29050588.0 |
| 2006-05-05 13:00:00 | AAPL | Stock | 2.56 | 2.5654 | 2.5546 | 2.5611 | 21296940.0 |
| 2006-05-05 13:30:00 | AAPL | Stock | 2.5607 | 2.5679 | 2.5586 | 2.5625 | 23379132.0 |
| 2006-05-05 14:00:00 | AAPL | Stock | 2.5625 | 2.5714 | 2.5604 | 2.57 | 30829232.0 |
| 2006-05-05 14:30:00 | AAPL | Stock | 2.57 | 2.5746 | 2.5607 | 2.5607 | 34713532.0 |
| 2006-05-05 15:00:00 | AAPL | Stock | 2.5608 | 2.5671 | 2.5582 | 2.5621 | 26788832.0 |
| 2006-05-05 15:30:00 | AAPL | Stock | 2.5621 | 2.5679 | 2.5586 | 2.5661 | 37889740.0 |
| 2006-05-05 16:00:00 | AAPL | Stock | 2.5657 | 2.5679 | 2.5639 | 2.5675 | 1427972.0 |
| 2006-05-05 16:30:00 | AAPL | Stock | 2.565 | 2.5675 | 2.5646 | 2.5657 | 1924216.0 |
| 2006-05-05 17:00:00 | AAPL | Stock | 2.5668 | 2.5682 | 2.5668 | 2.5682 | 48076.0 |
| 2006-05-05 17:30:00 | AAPL | Stock | 2.5679 | 2.5679 | 2.5657 | 2.5657 | 1034236.0 |
| 2006-05-05 18:00:00 | AAPL | Stock | 2.5679 | 2.5696 | 2.5679 | 2.5682 | 53844.0 |
| 2006-05-05 07:30:00 | MSFT | Stock | 23.52 | 23.52 | 23.52 | 23.52 | 1000.0 |
| 2006-05-05 08:00:00 | MSFT | Stock | 23.52 | 23.59 | 23.47 | 23.54 | 57438.0 |
| 2006-05-05 08:30:00 | MSFT | Stock | 23.54 | 23.63 | 23.44 | 23.6 | 199732.0 |
| 2006-05-05 09:00:00 | MSFT | Stock | 23.6 | 23.66 | 23.57 | 23.66 | 245664.0 |
| 2006-05-05 09:30:00 | MSFT | Stock | 23.66 | 23.78 | 23.52 | 23.77 | 14955844.0 |
| 2006-05-05 10:00:00 | MSFT | Stock | 23.76 | 23.88 | 23.7 | 23.71 | 17053019.0 |
| 2006-05-05 10:30:00 | MSFT | Stock | 23.71 | 23.79 | 23.71 | 23.76 | 9923883.0 |
| 2006-05-05 11:00:00 | MSFT | Stock | 23.75 | 23.8 | 23.7 | 23.75 | 7766422.0 |
| 2006-05-05 11:30:00 | MSFT | Stock | 23.74 | 23.89 | 23.74 | 23.81 | 11876354.0 |
| 2006-05-05 12:00:00 | MSFT | Stock | 23.815 | 23.85 | 23.79 | 23.84 | 5885193.0 |
| 2006-05-05 12:30:00 | MSFT | Stock | 23.837 | 23.841 | 23.75 | 23.77 | 5265686.0 |
| 2006-05-05 13:00:00 | MSFT | Stock | 23.77 | 23.81 | 23.74 | 23.77 | 6200785.0 |
| 2006-05-05 13:30:00 | MSFT | Stock | 23.77 | 23.84 | 23.77 | 23.79 | 4795769.0 |
| 2006-05-05 14:00:00 | MSFT | Stock | 23.78 | 23.8 | 23.76 | 23.79 | 3539442.0 |
| 2006-05-05 14:30:00 | MSFT | Stock | 23.79 | 23.84 | 23.77 | 23.78 | 6910606.0 |
| 2006-05-05 15:00:00 | MSFT | Stock | 23.78 | 23.79 | 23.74 | 23.78 | 7940182.0 |
| 2006-05-05 15:30:00 | MSFT | Stock | 23.78 | 23.95 | 23.78 | 23.93 | 18579115.0 |
| 2006-05-05 16:00:00 | MSFT | Stock | 23.94 | 23.95 | 23.8 | 23.85 | 4350242.0 |
| 2006-05-05 16:30:00 | MSFT | Stock | 23.85 | 23.926 | 23.81 | 23.87 | 788573.0 |
| 2006-05-05 17:00:00 | MSFT | Stock | 23.86 | 23.93 | 23.85 | 23.87 | 8130.0 |
| 2006-05-05 17:30:00 | MSFT | Stock | 23.86 | 23.87 | 23.86 | 23.86 | 4000.0 |
| 2006-05-05 18:00:00 | MSFT | Stock | 23.86 | 23.87 | 23.85 | 23.85 | 3636.0 |
| 2006-05-05 08:30:00 | NVDA | Stock | 0.5158 | 0.5168 | 0.5122 | 0.5168 | 25200.0 |
| 2006-05-05 09:00:00 | NVDA | Stock | 0.5208 | 0.5208 | 0.5175 | 0.52 | 96000.0 |
| 2006-05-05 09:30:00 | NVDA | Stock | 0.517 | 0.5232 | 0.5098 | 0.5188 | 50188320.0 |
| 2006-05-05 10:00:00 | NVDA | Stock | 0.519 | 0.5208 | 0.514 | 0.5163 | 30507600.0 |
| 2006-05-05 10:30:00 | NVDA | Stock | 0.5163 | 0.5195 | 0.5162 | 0.5192 | 18500820.0 |
| 2006-05-05 11:00:00 | NVDA | Stock | 0.5192 | 0.5205 | 0.5148 | 0.517 | 23803320.0 |
| 2006-05-05 11:30:00 | NVDA | Stock | 0.5172 | 0.5182 | 0.514 | 0.5143 | 17181720.0 |
> showing 50 of 49,351 rows — these rows as CSV