PREVIEW / stock_30min / 2006-01-27
file: by_date/stock_30min/2006/2006-01-27.parquet size: 918 KB rows: 49,072 symbols: 2,189
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-01-27 04:30:00 | AAPL | Stock | 2.6304 | 2.6304 | 2.6304 | 2.6304 | 2800.0 |
| 2006-01-27 07:00:00 | AAPL | Stock | 2.6268 | 2.6321 | 2.625 | 2.6321 | 70000.0 |
| 2006-01-27 07:30:00 | AAPL | Stock | 2.625 | 2.6286 | 2.6179 | 2.6179 | 229600.0 |
| 2006-01-27 08:00:00 | AAPL | Stock | 2.6179 | 2.6261 | 2.6107 | 2.6196 | 1692040.0 |
| 2006-01-27 08:30:00 | AAPL | Stock | 2.6196 | 2.6214 | 2.6071 | 2.6082 | 3065720.0 |
| 2006-01-27 09:00:00 | AAPL | Stock | 2.6086 | 2.6125 | 2.5911 | 2.6036 | 4464572.0 |
| 2006-01-27 09:30:00 | AAPL | Stock | 2.6054 | 2.6054 | 2.5393 | 2.5882 | 177926364.0 |
| 2006-01-27 10:00:00 | AAPL | Stock | 2.5839 | 2.6286 | 2.5689 | 2.5854 | 177659972.0 |
| 2006-01-27 10:30:00 | AAPL | Stock | 2.5854 | 2.5882 | 2.5661 | 2.5832 | 73219468.0 |
| 2006-01-27 11:00:00 | AAPL | Stock | 2.5832 | 2.5857 | 2.5625 | 2.5746 | 69793556.0 |
| 2006-01-27 11:30:00 | AAPL | Stock | 2.5746 | 2.5804 | 2.5625 | 2.5732 | 46258800.0 |
| 2006-01-27 12:00:00 | AAPL | Stock | 2.5729 | 2.6 | 2.5711 | 2.5882 | 63936600.0 |
| 2006-01-27 12:30:00 | AAPL | Stock | 2.5882 | 2.5939 | 2.5743 | 2.5796 | 35085316.0 |
| 2006-01-27 13:00:00 | AAPL | Stock | 2.5793 | 2.5796 | 2.5629 | 2.5657 | 31652264.0 |
| 2006-01-27 13:30:00 | AAPL | Stock | 2.5657 | 2.5689 | 2.5536 | 2.5609 | 42507836.0 |
| 2006-01-27 14:00:00 | AAPL | Stock | 2.5618 | 2.5771 | 2.5607 | 2.5736 | 42125132.0 |
| 2006-01-27 14:30:00 | AAPL | Stock | 2.5732 | 2.5743 | 2.5554 | 2.5646 | 32201652.0 |
| 2006-01-27 15:00:00 | AAPL | Stock | 2.565 | 2.5661 | 2.5575 | 2.5615 | 33436004.0 |
| 2006-01-27 15:30:00 | AAPL | Stock | 2.5614 | 2.5725 | 2.5454 | 2.5711 | 95314688.0 |
| 2006-01-27 16:00:00 | AAPL | Stock | 2.5711 | 2.5768 | 2.5625 | 2.5721 | 4088000.0 |
| 2006-01-27 16:30:00 | AAPL | Stock | 2.5714 | 2.5754 | 2.5589 | 2.5732 | 1053836.0 |
| 2006-01-27 17:00:00 | AAPL | Stock | 2.5732 | 2.5782 | 2.5671 | 2.575 | 504196.0 |
| 2006-01-27 17:30:00 | AAPL | Stock | 2.575 | 2.5779 | 2.5632 | 2.5725 | 417200.0 |
| 2006-01-27 18:00:00 | AAPL | Stock | 2.5771 | 2.5786 | 2.5732 | 2.575 | 581896.0 |
| 2006-01-27 04:30:00 | MSFT | Stock | 27.2 | 27.2 | 27.2 | 27.2 | 200.0 |
| 2006-01-27 07:00:00 | MSFT | Stock | 27.25 | 27.37 | 27.25 | 27.37 | 1300.0 |
| 2006-01-27 07:30:00 | MSFT | Stock | 27.2 | 27.4 | 27.2 | 27.4 | 23800.0 |
| 2006-01-27 08:00:00 | MSFT | Stock | 27.4 | 27.42 | 27.21 | 27.35 | 1305378.0 |
| 2006-01-27 08:30:00 | MSFT | Stock | 27.34 | 27.35 | 27.23 | 27.28 | 684628.0 |
| 2006-01-27 09:00:00 | MSFT | Stock | 27.28 | 27.34 | 27.23 | 27.23 | 719666.0 |
| 2006-01-27 09:30:00 | MSFT | Stock | 27.23 | 27.36 | 27.19 | 27.32 | 22537648.0 |
| 2006-01-27 10:00:00 | MSFT | Stock | 27.33 | 27.5 | 27.31 | 27.43 | 12012948.0 |
| 2006-01-27 10:30:00 | MSFT | Stock | 27.43 | 27.49 | 27.37 | 27.44 | 10219893.0 |
| 2006-01-27 11:00:00 | MSFT | Stock | 27.45 | 27.53 | 27.42 | 27.49 | 13174439.0 |
| 2006-01-27 11:30:00 | MSFT | Stock | 27.5 | 27.66 | 27.48 | 27.66 | 9197905.0 |
| 2006-01-27 12:00:00 | MSFT | Stock | 27.66 | 27.86 | 27.65 | 27.79 | 9271604.0 |
| 2006-01-27 12:30:00 | MSFT | Stock | 27.79 | 27.81 | 27.4 | 27.8 | 5232420.0 |
| 2006-01-27 13:00:00 | MSFT | Stock | 27.82 | 27.82 | 27.67 | 27.73 | 5285856.0 |
| 2006-01-27 13:30:00 | MSFT | Stock | 27.73 | 27.75 | 27.6 | 27.708 | 6340806.0 |
| 2006-01-27 14:00:00 | MSFT | Stock | 27.71 | 27.84 | 27.66 | 27.76 | 4584184.0 |
| 2006-01-27 14:30:00 | MSFT | Stock | 27.752 | 27.86 | 27.66 | 27.85 | 5347649.0 |
| 2006-01-27 15:00:00 | MSFT | Stock | 27.85 | 27.95 | 27.83 | 27.89 | 8804915.0 |
| 2006-01-27 15:30:00 | MSFT | Stock | 27.89 | 27.95 | 27.72 | 27.8 | 15210317.0 |
| 2006-01-27 16:00:00 | MSFT | Stock | 27.81 | 27.83 | 27.67 | 27.75 | 937941.0 |
| 2006-01-27 16:30:00 | MSFT | Stock | 27.75 | 27.79 | 27.73 | 27.79 | 35663.0 |
| 2006-01-27 17:00:00 | MSFT | Stock | 27.77 | 27.78 | 27.75 | 27.76 | 1630.0 |
| 2006-01-27 17:30:00 | MSFT | Stock | 27.76 | 27.76 | 27.75 | 27.75 | 3648.0 |
| 2006-01-27 18:00:00 | MSFT | Stock | 27.76 | 27.78 | 27.75 | 27.78 | 4520.0 |
| 2006-01-27 08:00:00 | NVDA | Stock | 0.3852 | 0.3877 | 0.3846 | 0.3877 | 1002000.0 |
| 2006-01-27 08:30:00 | NVDA | Stock | 0.3877 | 0.3877 | 0.3833 | 0.3833 | 915600.0 |
> showing 50 of 49,072 rows — these rows as CSV