PREVIEW / stock_30min / 2005-07-22
file: by_date/stock_30min/2005/2005-07-22.parquet size: 866 KB rows: 46,452 symbols: 2,028
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-07-22 08:00:00 | AAPL | Stock | 1.5454 | 1.5454 | 1.5425 | 1.5429 | 53200.0 |
| 2005-07-22 08:30:00 | AAPL | Stock | 1.5429 | 1.5536 | 1.5429 | 1.5536 | 166600.0 |
| 2005-07-22 09:00:00 | AAPL | Stock | 1.5536 | 1.5543 | 1.55 | 1.5518 | 1110200.0 |
| 2005-07-22 09:30:00 | AAPL | Stock | 1.5514 | 1.565 | 1.5496 | 1.5639 | 44510928.0 |
| 2005-07-22 10:00:00 | AAPL | Stock | 1.5636 | 1.5714 | 1.5607 | 1.5682 | 34664168.0 |
| 2005-07-22 10:30:00 | AAPL | Stock | 1.5686 | 1.5696 | 1.5571 | 1.5621 | 35863828.0 |
| 2005-07-22 11:00:00 | AAPL | Stock | 1.5621 | 1.5657 | 1.5596 | 1.5614 | 20380220.0 |
| 2005-07-22 11:30:00 | AAPL | Stock | 1.5614 | 1.565 | 1.5592 | 1.5646 | 12065452.0 |
| 2005-07-22 12:00:00 | AAPL | Stock | 1.5643 | 1.5679 | 1.5621 | 1.5625 | 11461044.0 |
| 2005-07-22 12:30:00 | AAPL | Stock | 1.5629 | 1.5629 | 1.5553 | 1.5589 | 18441080.0 |
| 2005-07-22 13:00:00 | AAPL | Stock | 1.5596 | 1.5639 | 1.5589 | 1.5625 | 7291424.0 |
| 2005-07-22 13:30:00 | AAPL | Stock | 1.5625 | 1.5629 | 1.5596 | 1.5618 | 7169400.0 |
| 2005-07-22 14:00:00 | AAPL | Stock | 1.5618 | 1.565 | 1.5611 | 1.5639 | 13680072.0 |
| 2005-07-22 14:30:00 | AAPL | Stock | 1.5643 | 1.5711 | 1.56 | 1.5679 | 28594020.0 |
| 2005-07-22 15:00:00 | AAPL | Stock | 1.5675 | 1.5714 | 1.5674 | 1.5711 | 22837584.0 |
| 2005-07-22 15:30:00 | AAPL | Stock | 1.5711 | 1.5714 | 1.5682 | 1.57 | 32864608.0 |
| 2005-07-22 16:00:00 | AAPL | Stock | 1.5714 | 1.5746 | 1.57 | 1.5714 | 2215052.0 |
| 2005-07-22 16:30:00 | AAPL | Stock | 1.5714 | 1.5732 | 1.5696 | 1.5714 | 1269464.0 |
| 2005-07-22 17:00:00 | AAPL | Stock | 1.57 | 1.5732 | 1.5686 | 1.5714 | 486640.0 |
| 2005-07-22 17:30:00 | AAPL | Stock | 1.5721 | 1.5732 | 1.5704 | 1.5704 | 110600.0 |
| 2005-07-22 18:00:00 | AAPL | Stock | 1.5714 | 1.5714 | 1.5714 | 1.5714 | 3500.0 |
| 2005-07-22 07:00:00 | MSFT | Stock | 25.99 | 25.99 | 25.99 | 25.99 | 900.0 |
| 2005-07-22 07:30:00 | MSFT | Stock | 25.87 | 25.87 | 25.87 | 25.87 | 6541.0 |
| 2005-07-22 08:00:00 | MSFT | Stock | 25.85 | 25.99 | 25.82 | 25.95 | 225228.0 |
| 2005-07-22 08:30:00 | MSFT | Stock | 25.95 | 26.15 | 25.95 | 26.12 | 626106.0 |
| 2005-07-22 09:00:00 | MSFT | Stock | 26.13 | 26.13 | 25.92 | 25.98 | 937421.0 |
| 2005-07-22 09:30:00 | MSFT | Stock | 25.99 | 26.34 | 25.98 | 26.02 | 17003160.0 |
| 2005-07-22 10:00:00 | MSFT | Stock | 26.02 | 26.02 | 25.86 | 25.9 | 13139107.0 |
| 2005-07-22 10:30:00 | MSFT | Stock | 25.9 | 25.92 | 25.78 | 25.79 | 7071431.0 |
| 2005-07-22 11:00:00 | MSFT | Stock | 25.8 | 25.81 | 25.73 | 25.8 | 7129625.0 |
| 2005-07-22 11:30:00 | MSFT | Stock | 25.8 | 25.81 | 25.75 | 25.8 | 4225617.0 |
| 2005-07-22 12:00:00 | MSFT | Stock | 25.8 | 25.859 | 25.77 | 25.8 | 2428451.0 |
| 2005-07-22 12:30:00 | MSFT | Stock | 25.8 | 26.0 | 25.7 | 25.72 | 6320461.0 |
| 2005-07-22 13:00:00 | MSFT | Stock | 25.721 | 26.12 | 25.72 | 25.77 | 3778632.0 |
| 2005-07-22 13:30:00 | MSFT | Stock | 25.77 | 25.81 | 25.74 | 25.78 | 3388818.0 |
| 2005-07-22 14:00:00 | MSFT | Stock | 25.78 | 25.78 | 25.65 | 25.68 | 4178300.0 |
| 2005-07-22 14:30:00 | MSFT | Stock | 25.68 | 25.8 | 25.64 | 25.78 | 7378880.0 |
| 2005-07-22 15:00:00 | MSFT | Stock | 25.79 | 25.8 | 25.74 | 25.76 | 4470262.0 |
| 2005-07-22 15:30:00 | MSFT | Stock | 25.75 | 25.865 | 25.63 | 25.64 | 7964111.0 |
| 2005-07-22 16:00:00 | MSFT | Stock | 25.63 | 26.06 | 25.62 | 25.66 | 1055433.0 |
| 2005-07-22 16:30:00 | MSFT | Stock | 25.65 | 25.68 | 25.63 | 25.64 | 472929.0 |
| 2005-07-22 17:00:00 | MSFT | Stock | 25.68 | 25.7 | 25.64 | 25.66 | 2313417.0 |
| 2005-07-22 17:30:00 | MSFT | Stock | 25.66 | 25.68 | 25.65 | 25.67 | 3495.0 |
| 2005-07-22 18:00:00 | MSFT | Stock | 25.67 | 25.67 | 25.65 | 25.67 | 12275.0 |
| 2005-07-22 08:30:00 | NVDA | Stock | 0.2237 | 0.2237 | 0.2237 | 0.2237 | 24000.0 |
| 2005-07-22 09:00:00 | NVDA | Stock | 0.2217 | 0.2222 | 0.2217 | 0.2221 | 132000.0 |
| 2005-07-22 09:30:00 | NVDA | Stock | 0.2221 | 0.2252 | 0.2183 | 0.2185 | 78887640.0 |
| 2005-07-22 10:00:00 | NVDA | Stock | 0.2185 | 0.2185 | 0.2156 | 0.2158 | 81065160.0 |
| 2005-07-22 10:30:00 | NVDA | Stock | 0.2157 | 0.219 | 0.2152 | 0.2166 | 54683160.0 |
| 2005-07-22 11:00:00 | NVDA | Stock | 0.2166 | 0.2184 | 0.2162 | 0.217 | 54796680.0 |
> showing 50 of 46,452 rows — these rows as CSV