PREVIEW / etf_30min / 2000-03-24
file: by_date/etf_30min/2000/2000-03-24.parquet size: 10 KB rows: 213
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 |
|---|---|---|---|---|---|---|---|
| 2000-03-24 09:30:00 | SPY | ETF | 152.875 | 153.5938 | 152.5625 | 153.25 | 964800.0 |
| 2000-03-24 10:00:00 | SPY | ETF | 153.4375 | 154.5 | 153.25 | 154.2812 | 1888800.0 |
| 2000-03-24 10:30:00 | SPY | ETF | 154.4688 | 155.75 | 154.0938 | 155.5312 | 1180200.0 |
| 2000-03-24 11:00:00 | SPY | ETF | 155.375 | 155.5312 | 154.4688 | 155.0 | 874900.0 |
| 2000-03-24 11:30:00 | SPY | ETF | 155.125 | 155.125 | 154.375 | 154.75 | 531100.0 |
| 2000-03-24 12:00:00 | SPY | ETF | 154.75 | 154.75 | 154.2188 | 154.5 | 176500.0 |
| 2000-03-24 12:30:00 | SPY | ETF | 154.7188 | 154.9062 | 153.9688 | 154.2188 | 754400.0 |
| 2000-03-24 13:00:00 | SPY | ETF | 154.25 | 154.4062 | 153.9062 | 153.9062 | 655500.0 |
| 2000-03-24 13:30:00 | SPY | ETF | 154.0 | 154.0625 | 153.0625 | 153.1875 | 452300.0 |
| 2000-03-24 14:00:00 | SPY | ETF | 153.1875 | 153.7188 | 152.5 | 152.875 | 516200.0 |
| 2000-03-24 14:30:00 | SPY | ETF | 152.875 | 153.2812 | 152.3438 | 152.4375 | 256500.0 |
| 2000-03-24 15:00:00 | SPY | ETF | 152.5 | 152.8125 | 151.7188 | 152.8125 | 1144400.0 |
| 2000-03-24 15:30:00 | SPY | ETF | 152.8125 | 153.4688 | 152.5 | 153.2812 | 1738900.0 |
| 2000-03-24 16:00:00 | SPY | ETF | 153.0625 | 153.625 | 153.0625 | 153.5625 | 256400.0 |
| 2000-03-24 09:30:00 | QQQ | ETF | 117.4688 | 118.4688 | 116.875 | 118.375 | 2606700.0 |
| 2000-03-24 10:00:00 | QQQ | ETF | 118.375 | 119.75 | 118.0312 | 119.5 | 2575900.0 |
| 2000-03-24 10:30:00 | QQQ | ETF | 119.5938 | 120.5 | 119.0625 | 120.25 | 1755100.0 |
| 2000-03-24 11:00:00 | QQQ | ETF | 120.125 | 120.3125 | 119.25 | 119.625 | 1438200.0 |
| 2000-03-24 11:30:00 | QQQ | ETF | 119.6875 | 119.875 | 119.125 | 119.625 | 639400.0 |
| 2000-03-24 12:00:00 | QQQ | ETF | 119.5625 | 119.625 | 118.8125 | 119.375 | 514500.0 |
| 2000-03-24 12:30:00 | QQQ | ETF | 119.375 | 119.75 | 118.75 | 119.0 | 1048500.0 |
| 2000-03-24 13:00:00 | QQQ | ETF | 119.0 | 119.5 | 118.75 | 118.8125 | 799200.0 |
| 2000-03-24 13:30:00 | QQQ | ETF | 118.8125 | 118.875 | 117.0 | 117.0 | 1787300.0 |
| 2000-03-24 14:00:00 | QQQ | ETF | 117.0 | 117.8125 | 116.0 | 116.625 | 2843100.0 |
| 2000-03-24 14:30:00 | QQQ | ETF | 116.625 | 117.25 | 115.6875 | 116.3125 | 1553000.0 |
| 2000-03-24 15:00:00 | QQQ | ETF | 116.3125 | 116.6875 | 115.0312 | 116.5 | 2127700.0 |
| 2000-03-24 15:30:00 | QQQ | ETF | 116.75 | 117.7188 | 116.375 | 117.25 | 1908600.0 |
| 2000-03-24 16:00:00 | QQQ | ETF | 117.25 | 118.0312 | 117.0 | 118.0 | 353200.0 |
| 2000-03-24 16:30:00 | QQQ | ETF | 117.75 | 118.0 | 117.75 | 118.0 | 1000.0 |
| 2000-03-24 17:00:00 | QQQ | ETF | 117.75 | 117.875 | 117.75 | 117.875 | 1600.0 |
| 2000-03-24 17:30:00 | QQQ | ETF | 117.5625 | 118.0 | 117.5625 | 118.0 | 200.0 |
| 2000-03-24 18:00:00 | QQQ | ETF | 117.6875 | 117.6875 | 117.5625 | 117.5625 | 400.0 |
| 2000-03-24 09:30:00 | DIA | ETF | 110.5312 | 111.0 | 110.2812 | 110.6562 | 239300.0 |
| 2000-03-24 10:00:00 | DIA | ETF | 110.5 | 111.625 | 110.5 | 111.625 | 255300.0 |
| 2000-03-24 10:30:00 | DIA | ETF | 111.5938 | 112.4688 | 111.3125 | 112.375 | 202400.0 |
| 2000-03-24 11:00:00 | DIA | ETF | 112.3438 | 112.3438 | 111.5 | 111.8125 | 116100.0 |
| 2000-03-24 11:30:00 | DIA | ETF | 111.8438 | 112.0 | 111.5 | 111.8438 | 114500.0 |
| 2000-03-24 12:00:00 | DIA | ETF | 111.8125 | 111.8125 | 111.5 | 111.75 | 30100.0 |
| 2000-03-24 12:30:00 | DIA | ETF | 111.8125 | 111.9062 | 111.1875 | 111.2812 | 79700.0 |
| 2000-03-24 13:00:00 | DIA | ETF | 111.2812 | 111.5938 | 111.25 | 111.3125 | 48600.0 |
| 2000-03-24 13:30:00 | DIA | ETF | 111.25 | 111.3125 | 110.8125 | 111.0 | 159800.0 |
| 2000-03-24 14:00:00 | DIA | ETF | 110.8438 | 111.4688 | 110.5 | 110.9375 | 109500.0 |
| 2000-03-24 14:30:00 | DIA | ETF | 110.8125 | 111.2188 | 110.625 | 110.75 | 56700.0 |
| 2000-03-24 15:00:00 | DIA | ETF | 110.875 | 110.9375 | 110.2812 | 110.9375 | 178300.0 |
| 2000-03-24 15:30:00 | DIA | ETF | 111.0 | 111.4688 | 110.7188 | 111.1562 | 267800.0 |
| 2000-03-24 16:00:00 | DIA | ETF | 111.375 | 111.75 | 111.1875 | 111.75 | 23700.0 |
| 2000-03-24 16:30:00 | DIA | ETF | 111.125 | 111.125 | 111.125 | 111.125 | 1600.0 |
> showing 47 of 213 rows — these rows as CSV