PREVIEW / stock_30min / 2006-05-08
file: by_date/stock_30min/2006/2006-05-08.parquet size: 927 KB rows: 49,934 symbols: 2,266
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-08 05:30:00 | AAPL | Stock | 2.575 | 2.575 | 2.575 | 2.575 | 8400.0 |
| 2006-05-08 06:00:00 | AAPL | Stock | 2.5786 | 2.5839 | 2.5786 | 2.5839 | 22400.0 |
| 2006-05-08 07:00:00 | AAPL | Stock | 2.5893 | 2.5893 | 2.5893 | 2.5893 | 2800.0 |
| 2006-05-08 08:00:00 | AAPL | Stock | 2.5893 | 2.6161 | 2.5839 | 2.6064 | 5663028.0 |
| 2006-05-08 08:30:00 | AAPL | Stock | 2.6064 | 2.6186 | 2.6064 | 2.6111 | 4853184.0 |
| 2006-05-08 09:00:00 | AAPL | Stock | 2.61 | 2.6157 | 2.5993 | 2.605 | 4659788.0 |
| 2006-05-08 09:30:00 | AAPL | Stock | 2.6068 | 2.6357 | 2.5829 | 2.5975 | 147459844.0 |
| 2006-05-08 10:00:00 | AAPL | Stock | 2.5979 | 2.6054 | 2.5896 | 2.6036 | 47898536.0 |
| 2006-05-08 10:30:00 | AAPL | Stock | 2.6036 | 2.6046 | 2.5889 | 2.5896 | 38681132.0 |
| 2006-05-08 11:00:00 | AAPL | Stock | 2.5893 | 2.5929 | 2.5682 | 2.5768 | 64095108.0 |
| 2006-05-08 11:30:00 | AAPL | Stock | 2.5771 | 2.5891 | 2.5743 | 2.5778 | 27528956.0 |
| 2006-05-08 12:00:00 | AAPL | Stock | 2.5771 | 2.5811 | 2.5714 | 2.5771 | 19325320.0 |
| 2006-05-08 12:30:00 | AAPL | Stock | 2.5771 | 2.595 | 2.5764 | 2.5925 | 35715820.0 |
| 2006-05-08 13:00:00 | AAPL | Stock | 2.5925 | 2.5928 | 2.5782 | 2.5846 | 20659436.0 |
| 2006-05-08 13:30:00 | AAPL | Stock | 2.585 | 2.5907 | 2.5829 | 2.5857 | 17677212.0 |
| 2006-05-08 14:00:00 | AAPL | Stock | 2.5857 | 2.5929 | 2.5839 | 2.5914 | 17040660.0 |
| 2006-05-08 14:30:00 | AAPL | Stock | 2.5911 | 2.5914 | 2.5725 | 2.5775 | 34681360.0 |
| 2006-05-08 15:00:00 | AAPL | Stock | 2.5776 | 2.5793 | 2.5639 | 2.5678 | 50877960.0 |
| 2006-05-08 15:30:00 | AAPL | Stock | 2.5679 | 2.5711 | 2.5614 | 2.5661 | 47222168.0 |
| 2006-05-08 16:00:00 | AAPL | Stock | 2.5664 | 2.57 | 2.5507 | 2.5536 | 2354100.0 |
| 2006-05-08 16:30:00 | AAPL | Stock | 2.5518 | 2.5536 | 2.5489 | 2.55 | 1503180.0 |
| 2006-05-08 17:00:00 | AAPL | Stock | 2.55 | 2.5604 | 2.5489 | 2.5571 | 173796.0 |
| 2006-05-08 17:30:00 | AAPL | Stock | 2.5568 | 2.5568 | 2.5536 | 2.5536 | 28000.0 |
| 2006-05-08 18:00:00 | AAPL | Stock | 2.5543 | 2.5561 | 2.5543 | 2.5554 | 70700.0 |
| 2006-05-08 07:00:00 | MSFT | Stock | 23.95 | 23.95 | 23.9 | 23.9 | 8400.0 |
| 2006-05-08 07:30:00 | MSFT | Stock | 23.91 | 23.93 | 23.91 | 23.91 | 6400.0 |
| 2006-05-08 08:00:00 | MSFT | Stock | 23.93 | 23.94 | 23.87 | 23.87 | 781277.0 |
| 2006-05-08 08:30:00 | MSFT | Stock | 23.87 | 23.89 | 23.85 | 23.85 | 33175.0 |
| 2006-05-08 09:00:00 | MSFT | Stock | 23.88 | 23.89 | 23.81 | 23.85 | 140841.0 |
| 2006-05-08 09:30:00 | MSFT | Stock | 23.85 | 25.0 | 23.7 | 23.72 | 9267941.0 |
| 2006-05-08 10:00:00 | MSFT | Stock | 23.72 | 23.75 | 23.63 | 23.66 | 5906030.0 |
| 2006-05-08 10:30:00 | MSFT | Stock | 23.65 | 23.68 | 23.58 | 23.61 | 5335423.0 |
| 2006-05-08 11:00:00 | MSFT | Stock | 23.61 | 23.721 | 23.51 | 23.53 | 7984019.0 |
| 2006-05-08 11:30:00 | MSFT | Stock | 23.52 | 23.71 | 23.52 | 23.6 | 5203773.0 |
| 2006-05-08 12:00:00 | MSFT | Stock | 23.599 | 23.86 | 23.57 | 23.61 | 3106763.0 |
| 2006-05-08 12:30:00 | MSFT | Stock | 23.61 | 23.65 | 23.6 | 23.65 | 3730470.0 |
| 2006-05-08 13:00:00 | MSFT | Stock | 23.65 | 23.71 | 23.64 | 23.67 | 3200655.0 |
| 2006-05-08 13:30:00 | MSFT | Stock | 23.66 | 23.67 | 23.59 | 23.59 | 2693020.0 |
| 2006-05-08 14:00:00 | MSFT | Stock | 23.6 | 23.65 | 23.59 | 23.6 | 2712466.0 |
| 2006-05-08 14:30:00 | MSFT | Stock | 23.64 | 23.64 | 23.55 | 23.58 | 3690501.0 |
| 2006-05-08 15:00:00 | MSFT | Stock | 23.59 | 23.64 | 23.57 | 23.61 | 5363153.0 |
| 2006-05-08 15:30:00 | MSFT | Stock | 23.61 | 23.76 | 23.58 | 23.73 | 15613819.0 |
| 2006-05-08 16:00:00 | MSFT | Stock | 23.73 | 23.79 | 23.6 | 23.68 | 2669630.0 |
| 2006-05-08 16:30:00 | MSFT | Stock | 23.68 | 23.71 | 23.66 | 23.68 | 15400.0 |
| 2006-05-08 17:00:00 | MSFT | Stock | 23.68 | 23.74 | 23.67 | 23.7 | 20582.0 |
| 2006-05-08 17:30:00 | MSFT | Stock | 23.7 | 23.7 | 23.66 | 23.68 | 1829.0 |
| 2006-05-08 18:00:00 | MSFT | Stock | 23.7 | 23.7 | 23.68 | 23.68 | 3745.0 |
| 2006-05-08 08:00:00 | NVDA | Stock | 0.5213 | 0.523 | 0.52 | 0.52 | 106800.0 |
| 2006-05-08 08:30:00 | NVDA | Stock | 0.52 | 0.52 | 0.52 | 0.52 | 24300.0 |
| 2006-05-08 09:00:00 | NVDA | Stock | 0.52 | 0.521 | 0.5192 | 0.52 | 540000.0 |
> showing 50 of 49,934 rows — these rows as CSV