PREVIEW / stock_30min / 2006-02-23
file: by_date/stock_30min/2006/2006-02-23.parquet size: 891 KB rows: 48,282 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-02-23 05:30:00 | AAPL | Stock | 2.5661 | 2.5661 | 2.5625 | 2.5625 | 30240.0 |
| 2006-02-23 06:00:00 | AAPL | Stock | 2.5625 | 2.5625 | 2.5625 | 2.5625 | 3360.0 |
| 2006-02-23 06:30:00 | AAPL | Stock | 2.5625 | 2.5625 | 2.5625 | 2.5625 | 11200.0 |
| 2006-02-23 07:00:00 | AAPL | Stock | 2.5607 | 2.5607 | 2.5464 | 2.5554 | 19600.0 |
| 2006-02-23 07:30:00 | AAPL | Stock | 2.5557 | 2.5564 | 2.5518 | 2.5518 | 126000.0 |
| 2006-02-23 08:00:00 | AAPL | Stock | 2.5536 | 2.5575 | 2.55 | 2.5554 | 1321740.0 |
| 2006-02-23 08:30:00 | AAPL | Stock | 2.5554 | 2.5568 | 2.5489 | 2.5532 | 1028132.0 |
| 2006-02-23 09:00:00 | AAPL | Stock | 2.5532 | 2.5643 | 2.5532 | 2.5636 | 2894248.0 |
| 2006-02-23 09:30:00 | AAPL | Stock | 2.5639 | 2.585 | 2.5511 | 2.5761 | 157578400.0 |
| 2006-02-23 10:00:00 | AAPL | Stock | 2.5764 | 2.5907 | 2.565 | 2.5889 | 108637704.0 |
| 2006-02-23 10:30:00 | AAPL | Stock | 2.5889 | 2.6036 | 2.5832 | 2.6004 | 91335384.0 |
| 2006-02-23 11:00:00 | AAPL | Stock | 2.6004 | 2.6071 | 2.5893 | 2.6057 | 62256292.0 |
| 2006-02-23 11:30:00 | AAPL | Stock | 2.6057 | 2.6061 | 2.5871 | 2.5882 | 45317272.0 |
| 2006-02-23 12:00:00 | AAPL | Stock | 2.5879 | 2.595 | 2.5811 | 2.5825 | 46025000.0 |
| 2006-02-23 12:30:00 | AAPL | Stock | 2.5825 | 2.6021 | 2.5818 | 2.6004 | 41589436.0 |
| 2006-02-23 13:00:00 | AAPL | Stock | 2.6006 | 2.6036 | 2.5904 | 2.6011 | 25638620.0 |
| 2006-02-23 13:30:00 | AAPL | Stock | 2.6011 | 2.6032 | 2.5893 | 2.5976 | 27938596.0 |
| 2006-02-23 14:00:00 | AAPL | Stock | 2.5975 | 2.5993 | 2.5829 | 2.5886 | 34256096.0 |
| 2006-02-23 14:30:00 | AAPL | Stock | 2.5882 | 2.5889 | 2.5718 | 2.5739 | 46715676.0 |
| 2006-02-23 15:00:00 | AAPL | Stock | 2.5743 | 2.5829 | 2.5643 | 2.5743 | 60295564.0 |
| 2006-02-23 15:30:00 | AAPL | Stock | 2.5746 | 2.5771 | 2.5571 | 2.5618 | 80590244.0 |
| 2006-02-23 16:00:00 | AAPL | Stock | 2.5621 | 2.5996 | 2.5536 | 2.5593 | 2828924.0 |
| 2006-02-23 16:30:00 | AAPL | Stock | 2.5589 | 2.5625 | 2.5557 | 2.5575 | 594104.0 |
| 2006-02-23 17:00:00 | AAPL | Stock | 2.5579 | 2.5607 | 2.5561 | 2.5589 | 402416.0 |
| 2006-02-23 17:30:00 | AAPL | Stock | 2.5589 | 2.5632 | 2.5589 | 2.5604 | 283304.0 |
| 2006-02-23 18:00:00 | AAPL | Stock | 2.5593 | 2.5625 | 2.5589 | 2.5625 | 284788.0 |
| 2006-02-23 07:00:00 | MSFT | Stock | 26.64 | 26.64 | 26.64 | 26.64 | 300.0 |
| 2006-02-23 07:30:00 | MSFT | Stock | 26.74 | 26.75 | 26.73 | 26.73 | 1518.0 |
| 2006-02-23 08:00:00 | MSFT | Stock | 26.74 | 26.74 | 26.71 | 26.71 | 2600.0 |
| 2006-02-23 08:30:00 | MSFT | Stock | 26.72 | 26.72 | 26.7 | 26.71 | 3096.0 |
| 2006-02-23 09:00:00 | MSFT | Stock | 26.7 | 26.74 | 26.6 | 26.73 | 133453.0 |
| 2006-02-23 09:30:00 | MSFT | Stock | 26.73 | 26.75 | 26.58 | 26.61 | 4129606.0 |
| 2006-02-23 10:00:00 | MSFT | Stock | 26.61 | 26.62 | 26.54 | 26.59 | 2837481.0 |
| 2006-02-23 10:30:00 | MSFT | Stock | 26.592 | 26.67 | 26.59 | 26.62 | 2889563.0 |
| 2006-02-23 11:00:00 | MSFT | Stock | 26.62 | 26.69 | 26.6 | 26.69 | 2315807.0 |
| 2006-02-23 11:30:00 | MSFT | Stock | 26.68 | 26.71 | 26.61 | 26.648 | 1436669.0 |
| 2006-02-23 12:00:00 | MSFT | Stock | 26.65 | 26.655 | 26.59 | 26.62 | 1660927.0 |
| 2006-02-23 12:30:00 | MSFT | Stock | 26.63 | 26.72 | 26.6 | 26.71 | 2024247.0 |
| 2006-02-23 13:00:00 | MSFT | Stock | 26.71 | 26.8 | 26.6 | 26.78 | 2678683.0 |
| 2006-02-23 13:30:00 | MSFT | Stock | 26.78 | 26.83 | 26.75 | 26.81 | 3922416.0 |
| 2006-02-23 14:00:00 | MSFT | Stock | 26.802 | 26.87 | 26.75 | 26.84 | 4096852.0 |
| 2006-02-23 14:30:00 | MSFT | Stock | 26.84 | 26.851 | 26.8 | 26.8 | 3029162.0 |
| 2006-02-23 15:00:00 | MSFT | Stock | 26.801 | 26.89 | 26.79 | 26.8 | 3732205.0 |
| 2006-02-23 15:30:00 | MSFT | Stock | 26.8 | 26.81 | 26.63 | 26.66 | 7663854.0 |
| 2006-02-23 16:00:00 | MSFT | Stock | 26.66 | 26.756 | 26.63 | 26.66 | 287063.0 |
| 2006-02-23 16:30:00 | MSFT | Stock | 26.66 | 26.66 | 26.65 | 26.66 | 22740.0 |
| 2006-02-23 17:00:00 | MSFT | Stock | 26.66 | 26.67 | 26.66 | 26.67 | 670517.0 |
| 2006-02-23 17:30:00 | MSFT | Stock | 26.66 | 26.67 | 26.64 | 26.64 | 4650.0 |
| 2006-02-23 18:00:00 | MSFT | Stock | 26.67 | 26.67 | 26.67 | 26.67 | 700.0 |
| 2006-02-23 08:30:00 | NVDA | Stock | 0.3858 | 0.3858 | 0.3858 | 0.3858 | 60000.0 |
> showing 50 of 48,282 rows — these rows as CSV