PREVIEW / stock_30min / 2006-09-11
file: by_date/stock_30min/2006/2006-09-11.parquet size: 909 KB rows: 49,234 symbols: 2,353
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-09-11 06:30:00 | AAPL | Stock | 2.5875 | 2.5875 | 2.5804 | 2.5804 | 81200.0 |
| 2006-09-11 07:00:00 | AAPL | Stock | 2.5807 | 2.5854 | 2.5804 | 2.5854 | 37800.0 |
| 2006-09-11 07:30:00 | AAPL | Stock | 2.59 | 2.5939 | 2.59 | 2.5939 | 72800.0 |
| 2006-09-11 08:00:00 | AAPL | Stock | 2.5896 | 2.595 | 2.5807 | 2.5811 | 1642088.0 |
| 2006-09-11 08:30:00 | AAPL | Stock | 2.5807 | 2.5936 | 2.5804 | 2.5925 | 1028832.0 |
| 2006-09-11 09:00:00 | AAPL | Stock | 2.5936 | 2.605 | 2.5864 | 2.5868 | 3109624.0 |
| 2006-09-11 09:30:00 | AAPL | Stock | 2.5868 | 2.6025 | 2.5714 | 2.5811 | 113258068.0 |
| 2006-09-11 10:00:00 | AAPL | Stock | 2.5807 | 2.5861 | 2.5589 | 2.5596 | 82701668.0 |
| 2006-09-11 10:30:00 | AAPL | Stock | 2.5593 | 2.5643 | 2.5507 | 2.5596 | 66188248.0 |
| 2006-09-11 11:00:00 | AAPL | Stock | 2.5593 | 2.5757 | 2.5554 | 2.5739 | 66583468.0 |
| 2006-09-11 11:30:00 | AAPL | Stock | 2.5739 | 2.5814 | 2.5707 | 2.5771 | 43790040.0 |
| 2006-09-11 12:00:00 | AAPL | Stock | 2.5768 | 2.6161 | 2.5761 | 2.615 | 103887980.0 |
| 2006-09-11 12:30:00 | AAPL | Stock | 2.6154 | 2.6196 | 2.6043 | 2.6175 | 59918628.0 |
| 2006-09-11 13:00:00 | AAPL | Stock | 2.6179 | 2.6332 | 2.6179 | 2.6211 | 80725232.0 |
| 2006-09-11 13:30:00 | AAPL | Stock | 2.6211 | 2.6296 | 2.6136 | 2.6146 | 45749564.0 |
| 2006-09-11 14:00:00 | AAPL | Stock | 2.6146 | 2.6168 | 2.5996 | 2.6029 | 52558660.0 |
| 2006-09-11 14:30:00 | AAPL | Stock | 2.6025 | 2.6121 | 2.5911 | 2.6093 | 66342388.0 |
| 2006-09-11 15:00:00 | AAPL | Stock | 2.6093 | 2.6121 | 2.5896 | 2.5996 | 64296512.0 |
| 2006-09-11 15:30:00 | AAPL | Stock | 2.599 | 2.6086 | 2.5829 | 2.5893 | 87559696.0 |
| 2006-09-11 16:00:00 | AAPL | Stock | 2.5893 | 2.5893 | 2.5779 | 2.5839 | 3673376.0 |
| 2006-09-11 16:30:00 | AAPL | Stock | 2.5839 | 2.5864 | 2.5839 | 2.5864 | 364560.0 |
| 2006-09-11 17:00:00 | AAPL | Stock | 2.5843 | 2.5893 | 2.5832 | 2.5882 | 281960.0 |
| 2006-09-11 17:30:00 | AAPL | Stock | 2.5875 | 2.5882 | 2.5857 | 2.5879 | 208292.0 |
| 2006-09-11 18:00:00 | AAPL | Stock | 2.5879 | 2.5893 | 2.5857 | 2.5861 | 169708.0 |
| 2006-09-11 07:00:00 | MSFT | Stock | 25.55 | 25.55 | 25.47 | 25.47 | 1150.0 |
| 2006-09-11 07:30:00 | MSFT | Stock | 25.52 | 25.52 | 25.52 | 25.52 | 500.0 |
| 2006-09-11 08:00:00 | MSFT | Stock | 25.5 | 25.5 | 25.46 | 25.47 | 27250.0 |
| 2006-09-11 08:30:00 | MSFT | Stock | 25.47 | 25.49 | 25.47 | 25.47 | 3569.0 |
| 2006-09-11 09:00:00 | MSFT | Stock | 25.48 | 25.53 | 25.42 | 25.42 | 156519.0 |
| 2006-09-11 09:30:00 | MSFT | Stock | 25.43 | 25.78 | 25.42 | 25.7 | 7287295.0 |
| 2006-09-11 10:00:00 | MSFT | Stock | 25.72 | 25.91 | 25.57 | 25.88 | 6600398.0 |
| 2006-09-11 10:30:00 | MSFT | Stock | 25.87 | 25.93 | 25.83 | 25.86 | 4854021.0 |
| 2006-09-11 11:00:00 | MSFT | Stock | 25.86 | 25.88 | 25.82 | 25.85 | 4073940.0 |
| 2006-09-11 11:30:00 | MSFT | Stock | 25.85 | 25.9 | 25.78 | 25.82 | 1862635.0 |
| 2006-09-11 12:00:00 | MSFT | Stock | 25.81 | 25.87 | 25.77 | 25.83 | 3170401.0 |
| 2006-09-11 12:30:00 | MSFT | Stock | 25.83 | 25.85 | 25.76 | 25.81 | 1830201.0 |
| 2006-09-11 13:00:00 | MSFT | Stock | 25.81 | 25.87 | 25.8 | 25.867 | 3842145.0 |
| 2006-09-11 13:30:00 | MSFT | Stock | 25.86 | 25.92 | 25.84 | 25.89 | 4351239.0 |
| 2006-09-11 14:00:00 | MSFT | Stock | 25.89 | 25.94 | 25.86 | 25.9 | 3305261.0 |
| 2006-09-11 14:30:00 | MSFT | Stock | 25.9 | 25.93 | 25.87 | 25.91 | 2317645.0 |
| 2006-09-11 15:00:00 | MSFT | Stock | 25.91 | 25.95 | 25.85 | 25.9 | 3828348.0 |
| 2006-09-11 15:30:00 | MSFT | Stock | 25.9 | 25.94 | 25.86 | 25.92 | 5778219.0 |
| 2006-09-11 16:00:00 | MSFT | Stock | 25.91 | 25.96 | 25.86 | 25.94 | 150763.0 |
| 2006-09-11 16:30:00 | MSFT | Stock | 25.94 | 25.94 | 25.94 | 25.94 | 2669.0 |
| 2006-09-11 17:00:00 | MSFT | Stock | 25.95 | 25.95 | 25.95 | 25.95 | 200.0 |
| 2006-09-11 17:30:00 | MSFT | Stock | 25.92 | 25.93 | 25.92 | 25.93 | 1825.0 |
| 2006-09-11 18:00:00 | MSFT | Stock | 25.95 | 25.95 | 25.95 | 25.95 | 3948.0 |
| 2006-09-11 08:00:00 | NVDA | Stock | 0.4622 | 0.4625 | 0.4567 | 0.4573 | 604980.0 |
| 2006-09-11 08:30:00 | NVDA | Stock | 0.4573 | 0.4573 | 0.4513 | 0.4525 | 1084800.0 |
| 2006-09-11 09:00:00 | NVDA | Stock | 0.452 | 0.4525 | 0.4483 | 0.4512 | 1926960.0 |
> showing 50 of 49,234 rows — these rows as CSV