PREVIEW / stock_30min / 2005-12-20
file: by_date/stock_30min/2005/2005-12-20.parquet size: 868 KB rows: 47,164 symbols: 2,152
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 |
|---|---|---|---|---|---|---|---|
| 2005-12-20 07:30:00 | AAPL | Stock | 2.5621 | 2.5625 | 2.5621 | 2.5625 | 36400.0 |
| 2005-12-20 08:00:00 | AAPL | Stock | 2.5625 | 2.5639 | 2.5557 | 2.5596 | 371168.0 |
| 2005-12-20 08:30:00 | AAPL | Stock | 2.5625 | 2.5643 | 2.5568 | 2.5579 | 1042272.0 |
| 2005-12-20 09:00:00 | AAPL | Stock | 2.5589 | 2.5639 | 2.5564 | 2.5564 | 1328852.0 |
| 2005-12-20 09:30:00 | AAPL | Stock | 2.558 | 2.5707 | 2.5421 | 2.5461 | 66520692.0 |
| 2005-12-20 10:00:00 | AAPL | Stock | 2.5464 | 2.5625 | 2.54 | 2.5582 | 47075140.0 |
| 2005-12-20 10:30:00 | AAPL | Stock | 2.5582 | 2.5754 | 2.5582 | 2.57 | 44245544.0 |
| 2005-12-20 11:00:00 | AAPL | Stock | 2.57 | 2.5775 | 2.5632 | 2.5664 | 20618556.0 |
| 2005-12-20 11:30:00 | AAPL | Stock | 2.5664 | 2.575 | 2.5614 | 2.5639 | 31376492.0 |
| 2005-12-20 12:00:00 | AAPL | Stock | 2.5643 | 2.585 | 2.5636 | 2.5761 | 42926968.0 |
| 2005-12-20 12:30:00 | AAPL | Stock | 2.5761 | 2.5779 | 2.5718 | 2.5768 | 16631552.0 |
| 2005-12-20 13:00:00 | AAPL | Stock | 2.5775 | 2.5839 | 2.575 | 2.5829 | 18828796.0 |
| 2005-12-20 13:30:00 | AAPL | Stock | 2.5825 | 2.5839 | 2.5696 | 2.5696 | 26557048.0 |
| 2005-12-20 14:00:00 | AAPL | Stock | 2.5696 | 2.5732 | 2.5625 | 2.5661 | 39811100.0 |
| 2005-12-20 14:30:00 | AAPL | Stock | 2.5661 | 2.5679 | 2.5543 | 2.5614 | 29241016.0 |
| 2005-12-20 15:00:00 | AAPL | Stock | 2.5611 | 2.5689 | 2.5546 | 2.5621 | 29635004.0 |
| 2005-12-20 15:30:00 | AAPL | Stock | 2.5625 | 2.5779 | 2.5596 | 2.5764 | 45290588.0 |
| 2005-12-20 16:00:00 | AAPL | Stock | 2.5754 | 2.5796 | 2.575 | 2.5757 | 1040760.0 |
| 2005-12-20 16:30:00 | AAPL | Stock | 2.5768 | 2.58 | 2.575 | 2.5786 | 555072.0 |
| 2005-12-20 17:00:00 | AAPL | Stock | 2.5789 | 2.5789 | 2.5714 | 2.5714 | 114520.0 |
| 2005-12-20 17:30:00 | AAPL | Stock | 2.5768 | 2.5768 | 2.5689 | 2.5757 | 67144.0 |
| 2005-12-20 18:00:00 | AAPL | Stock | 2.5693 | 2.5739 | 2.565 | 2.5679 | 124544.0 |
| 2005-12-20 07:00:00 | MSFT | Stock | 26.86 | 26.86 | 26.86 | 26.86 | 2000.0 |
| 2005-12-20 08:00:00 | MSFT | Stock | 26.85 | 26.85 | 26.82 | 26.82 | 3100.0 |
| 2005-12-20 08:30:00 | MSFT | Stock | 26.82 | 26.84 | 26.82 | 26.83 | 7947.0 |
| 2005-12-20 09:00:00 | MSFT | Stock | 26.84 | 26.84 | 26.75 | 26.77 | 95746.0 |
| 2005-12-20 09:30:00 | MSFT | Stock | 26.76 | 26.81 | 26.67 | 26.76 | 5589136.0 |
| 2005-12-20 10:00:00 | MSFT | Stock | 26.76 | 26.78 | 26.71 | 26.75 | 5028274.0 |
| 2005-12-20 10:30:00 | MSFT | Stock | 26.75 | 26.85 | 26.74 | 26.82 | 4805494.0 |
| 2005-12-20 11:00:00 | MSFT | Stock | 26.83 | 26.84 | 26.735 | 26.76 | 3514552.0 |
| 2005-12-20 11:30:00 | MSFT | Stock | 26.76 | 26.78 | 26.74 | 26.75 | 3324551.0 |
| 2005-12-20 12:00:00 | MSFT | Stock | 26.76 | 26.78 | 26.715 | 26.75 | 3877919.0 |
| 2005-12-20 12:30:00 | MSFT | Stock | 26.75 | 26.79 | 26.749 | 26.79 | 2716290.0 |
| 2005-12-20 13:00:00 | MSFT | Stock | 26.79 | 26.8 | 26.75 | 26.78 | 2477059.0 |
| 2005-12-20 13:30:00 | MSFT | Stock | 26.79 | 26.82 | 26.76 | 26.8 | 5096944.0 |
| 2005-12-20 14:00:00 | MSFT | Stock | 26.8 | 26.82 | 26.76 | 26.8 | 2942884.0 |
| 2005-12-20 14:30:00 | MSFT | Stock | 26.8 | 26.84 | 26.78 | 26.83 | 5292633.0 |
| 2005-12-20 15:00:00 | MSFT | Stock | 26.82 | 26.86 | 26.8 | 26.85 | 6814598.0 |
| 2005-12-20 15:30:00 | MSFT | Stock | 26.84 | 26.88 | 26.82 | 26.87 | 8676524.0 |
| 2005-12-20 16:00:00 | MSFT | Stock | 26.86 | 26.89 | 26.782 | 26.83 | 658517.0 |
| 2005-12-20 16:30:00 | MSFT | Stock | 26.84 | 26.89 | 26.84 | 26.86 | 36200.0 |
| 2005-12-20 17:00:00 | MSFT | Stock | 26.86 | 26.86 | 26.85 | 26.85 | 230980.0 |
| 2005-12-20 18:00:00 | MSFT | Stock | 26.86 | 26.86 | 26.85 | 26.85 | 380.0 |
| 2005-12-20 08:30:00 | NVDA | Stock | 0.3017 | 0.3017 | 0.3017 | 0.3017 | 180000.0 |
| 2005-12-20 09:00:00 | NVDA | Stock | 0.3017 | 0.3017 | 0.3017 | 0.3017 | 132000.0 |
| 2005-12-20 09:30:00 | NVDA | Stock | 0.3017 | 0.3037 | 0.3001 | 0.3036 | 25527240.0 |
| 2005-12-20 10:00:00 | NVDA | Stock | 0.3035 | 0.3035 | 0.2978 | 0.2982 | 38323920.0 |
| 2005-12-20 10:30:00 | NVDA | Stock | 0.2983 | 0.3019 | 0.2979 | 0.3012 | 22519440.0 |
| 2005-12-20 11:00:00 | NVDA | Stock | 0.3012 | 0.3034 | 0.3012 | 0.3034 | 16460160.0 |
| 2005-12-20 11:30:00 | NVDA | Stock | 0.3034 | 0.3057 | 0.3034 | 0.304 | 20192040.0 |
> showing 50 of 47,164 rows — these rows as CSV