PREVIEW / stock_30min / 2007-05-16
file: by_date/stock_30min/2007/2007-05-16.parquet size: 1.1 MB rows: 63,174 symbols: 3,015
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 |
|---|---|---|---|---|---|---|---|
| 2007-05-16 09:30:00 | AAPL | Stock | 3.8761 | 3.9518 | 3.8479 | 3.8539 | 140375340.0 |
| 2007-05-16 10:00:00 | AAPL | Stock | 3.8539 | 3.8661 | 3.8418 | 3.8579 | 71748012.0 |
| 2007-05-16 10:30:00 | AAPL | Stock | 3.8582 | 3.8636 | 3.8307 | 3.8393 | 71786092.0 |
| 2007-05-16 11:00:00 | AAPL | Stock | 3.8389 | 3.8446 | 3.8143 | 3.8229 | 62842108.0 |
| 2007-05-16 11:30:00 | AAPL | Stock | 3.8229 | 3.8554 | 3.7946 | 3.8125 | 102828124.0 |
| 2007-05-16 12:00:00 | AAPL | Stock | 3.8125 | 3.8425 | 3.6936 | 3.82 | 368264008.0 |
| 2007-05-16 12:30:00 | AAPL | Stock | 3.82 | 3.835 | 3.81 | 3.8296 | 54613272.0 |
| 2007-05-16 13:00:00 | AAPL | Stock | 3.8293 | 3.8304 | 3.8157 | 3.82 | 22228136.0 |
| 2007-05-16 13:30:00 | AAPL | Stock | 3.8207 | 3.8289 | 3.8068 | 3.8139 | 31716748.0 |
| 2007-05-16 14:00:00 | AAPL | Stock | 3.8136 | 3.8286 | 3.8118 | 3.8164 | 33264868.0 |
| 2007-05-16 14:30:00 | AAPL | Stock | 3.8161 | 3.8204 | 3.8071 | 3.8182 | 28871052.0 |
| 2007-05-16 15:00:00 | AAPL | Stock | 3.8186 | 3.8264 | 3.815 | 3.8196 | 34113240.0 |
| 2007-05-16 15:30:00 | AAPL | Stock | 3.8196 | 3.8361 | 3.8193 | 3.8325 | 58244060.0 |
| 2007-05-16 16:00:00 | AAPL | Stock | 3.8332 | 3.8336 | 3.8332 | 3.8336 | 9329628.0 |
| 2007-05-16 09:30:00 | MSFT | Stock | 31.0 | 31.06 | 30.93 | 30.98 | 3752532.0 |
| 2007-05-16 10:00:00 | MSFT | Stock | 30.98 | 31.03 | 30.95 | 30.95 | 3623498.0 |
| 2007-05-16 10:30:00 | MSFT | Stock | 30.95 | 30.99 | 30.94 | 30.97 | 2722820.0 |
| 2007-05-16 11:00:00 | MSFT | Stock | 30.97 | 30.98 | 30.81 | 30.85 | 5726635.0 |
| 2007-05-16 11:30:00 | MSFT | Stock | 30.86 | 31.05 | 30.85 | 31.03 | 2923993.0 |
| 2007-05-16 12:00:00 | MSFT | Stock | 31.03 | 31.07 | 30.98 | 30.98 | 1843069.0 |
| 2007-05-16 12:30:00 | MSFT | Stock | 30.98 | 31.05 | 30.95 | 31.05 | 1670795.0 |
| 2007-05-16 13:00:00 | MSFT | Stock | 31.04 | 31.05 | 30.95 | 30.96 | 1423156.0 |
| 2007-05-16 13:30:00 | MSFT | Stock | 30.965 | 30.99 | 30.94 | 30.97 | 3222249.0 |
| 2007-05-16 14:00:00 | MSFT | Stock | 30.96 | 31.04 | 30.95 | 30.961 | 1516667.0 |
| 2007-05-16 14:30:00 | MSFT | Stock | 30.96 | 31.01 | 30.94 | 30.96 | 1999843.0 |
| 2007-05-16 15:00:00 | MSFT | Stock | 30.96 | 31.01 | 30.95 | 30.99 | 1980596.0 |
| 2007-05-16 15:30:00 | MSFT | Stock | 31.0 | 31.09 | 30.99 | 31.08 | 5372520.0 |
| 2007-05-16 16:00:00 | MSFT | Stock | 31.07 | 31.07 | 31.07 | 31.07 | 1595524.0 |
| 2007-05-16 08:00:00 | NVDA | Stock | 0.5817 | 0.5817 | 0.5783 | 0.5817 | 94500.0 |
| 2007-05-16 09:00:00 | NVDA | Stock | 0.5793 | 0.5793 | 0.5752 | 0.5753 | 162000.0 |
| 2007-05-16 09:30:00 | NVDA | Stock | 0.5752 | 0.577 | 0.5733 | 0.575 | 43862460.0 |
| 2007-05-16 10:00:00 | NVDA | Stock | 0.575 | 0.5758 | 0.5705 | 0.573 | 54531300.0 |
| 2007-05-16 10:30:00 | NVDA | Stock | 0.5728 | 0.5733 | 0.5658 | 0.5672 | 51883800.0 |
| 2007-05-16 11:00:00 | NVDA | Stock | 0.5673 | 0.5685 | 0.5642 | 0.5677 | 43477020.0 |
| 2007-05-16 11:30:00 | NVDA | Stock | 0.5677 | 0.5722 | 0.5675 | 0.5715 | 30344160.0 |
| 2007-05-16 12:00:00 | NVDA | Stock | 0.5717 | 0.573 | 0.5702 | 0.5708 | 28340280.0 |
| 2007-05-16 12:30:00 | NVDA | Stock | 0.5708 | 0.573 | 0.5687 | 0.573 | 21380280.0 |
| 2007-05-16 13:00:00 | NVDA | Stock | 0.573 | 0.5738 | 0.5707 | 0.5725 | 23099460.0 |
| 2007-05-16 13:30:00 | NVDA | Stock | 0.5725 | 0.5757 | 0.5722 | 0.5748 | 22235520.0 |
| 2007-05-16 14:00:00 | NVDA | Stock | 0.5748 | 0.5785 | 0.5748 | 0.5763 | 31835100.0 |
| 2007-05-16 14:30:00 | NVDA | Stock | 0.5762 | 0.581 | 0.5755 | 0.5802 | 36821580.0 |
| 2007-05-16 15:00:00 | NVDA | Stock | 0.5802 | 0.5802 | 0.5782 | 0.5795 | 41384760.0 |
| 2007-05-16 15:30:00 | NVDA | Stock | 0.5797 | 0.582 | 0.5792 | 0.582 | 56609760.0 |
| 2007-05-16 16:00:00 | NVDA | Stock | 0.582 | 0.582 | 0.5773 | 0.5773 | 9123180.0 |
| 2007-05-16 05:00:00 | AMZN | Stock | 3.035 | 3.035 | 3.0325 | 3.0325 | 4000.0 |
| 2007-05-16 07:00:00 | AMZN | Stock | 3.03 | 3.03 | 3.027 | 3.027 | 6000.0 |
| 2007-05-16 07:30:00 | AMZN | Stock | 3.0255 | 3.0255 | 3.0255 | 3.0255 | 5800.0 |
| 2007-05-16 08:00:00 | AMZN | Stock | 3.0335 | 3.035 | 3.03 | 3.03 | 15000.0 |
| 2007-05-16 08:30:00 | AMZN | Stock | 3.0325 | 3.0385 | 3.0325 | 3.0385 | 45500.0 |
| 2007-05-16 09:00:00 | AMZN | Stock | 3.0375 | 3.0525 | 3.037 | 3.0485 | 874000.0 |
> showing 50 of 63,174 rows — these rows as CSV