PREVIEW / etf_30min / 2000-01-10
file: by_date/etf_30min/2000/2000-01-10.parquet size: 10 KB rows: 239
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-01-10 09:30:00 | SPY | ETF | 146.25 | 146.9062 | 146.125 | 146.5 | 1935600.0 |
| 2000-01-10 10:00:00 | SPY | ETF | 146.625 | 146.75 | 146.0 | 146.125 | 387800.0 |
| 2000-01-10 10:30:00 | SPY | ETF | 146.25 | 146.3438 | 145.3125 | 145.375 | 416600.0 |
| 2000-01-10 11:00:00 | SPY | ETF | 145.4062 | 145.625 | 145.0312 | 145.3438 | 332200.0 |
| 2000-01-10 11:30:00 | SPY | ETF | 145.375 | 145.9375 | 145.3125 | 145.9375 | 205300.0 |
| 2000-01-10 12:00:00 | SPY | ETF | 145.9375 | 145.9375 | 145.5312 | 145.75 | 153900.0 |
| 2000-01-10 12:30:00 | SPY | ETF | 145.875 | 146.0625 | 145.75 | 145.8125 | 64000.0 |
| 2000-01-10 13:00:00 | SPY | ETF | 145.9375 | 145.9688 | 145.4062 | 145.625 | 255800.0 |
| 2000-01-10 13:30:00 | SPY | ETF | 145.7188 | 146.0 | 145.4062 | 145.4688 | 259500.0 |
| 2000-01-10 14:00:00 | SPY | ETF | 145.4375 | 146.0 | 145.4062 | 145.75 | 214000.0 |
| 2000-01-10 14:30:00 | SPY | ETF | 145.75 | 146.3125 | 145.625 | 146.2188 | 190100.0 |
| 2000-01-10 15:00:00 | SPY | ETF | 146.3125 | 146.7812 | 145.875 | 146.5 | 439600.0 |
| 2000-01-10 15:30:00 | SPY | ETF | 146.5 | 146.625 | 145.5312 | 145.8125 | 523600.0 |
| 2000-01-10 16:00:00 | SPY | ETF | 145.8125 | 146.375 | 145.6562 | 146.375 | 324800.0 |
| 2000-01-10 17:00:00 | SPY | ETF | 146.25 | 146.25 | 146.25 | 146.25 | 500.0 |
| 2000-01-10 09:30:00 | QQQ | ETF | 91.0 | 92.0 | 90.75 | 91.5 | 6010000.0 |
| 2000-01-10 10:00:00 | QQQ | ETF | 91.5156 | 91.75 | 91.0 | 91.0938 | 2359800.0 |
| 2000-01-10 10:30:00 | QQQ | ETF | 91.0625 | 91.4688 | 90.75 | 90.8281 | 1656200.0 |
| 2000-01-10 11:00:00 | QQQ | ETF | 90.6875 | 90.9375 | 89.9375 | 90.5 | 2269000.0 |
| 2000-01-10 11:30:00 | QQQ | ETF | 90.5 | 91.4844 | 90.4375 | 91.4375 | 845200.0 |
| 2000-01-10 12:00:00 | QQQ | ETF | 91.4375 | 91.5 | 91.1094 | 91.3438 | 598000.0 |
| 2000-01-10 12:30:00 | QQQ | ETF | 91.4062 | 91.9375 | 91.375 | 91.6875 | 1610400.0 |
| 2000-01-10 13:00:00 | QQQ | ETF | 91.6875 | 91.8438 | 91.25 | 91.5 | 1393800.0 |
| 2000-01-10 13:30:00 | QQQ | ETF | 91.5 | 92.125 | 91.4688 | 91.75 | 1509600.0 |
| 2000-01-10 14:00:00 | QQQ | ETF | 91.8438 | 92.6562 | 91.7812 | 92.5938 | 1086800.0 |
| 2000-01-10 14:30:00 | QQQ | ETF | 92.5938 | 93.0 | 92.25 | 92.9688 | 1944800.0 |
| 2000-01-10 15:00:00 | QQQ | ETF | 92.9688 | 93.75 | 92.7812 | 93.6406 | 2839200.0 |
| 2000-01-10 15:30:00 | QQQ | ETF | 93.625 | 93.9375 | 92.25 | 92.4688 | 4742600.0 |
| 2000-01-10 16:00:00 | QQQ | ETF | 92.6875 | 93.125 | 92.375 | 93.0625 | 405200.0 |
| 2000-01-10 16:30:00 | QQQ | ETF | 92.9844 | 93.2812 | 92.9844 | 93.125 | 5000.0 |
| 2000-01-10 17:00:00 | QQQ | ETF | 92.375 | 92.5 | 92.25 | 92.5 | 3400.0 |
| 2000-01-10 17:30:00 | QQQ | ETF | 92.5 | 92.6875 | 91.5 | 92.6875 | 1400.0 |
| 2000-01-10 18:00:00 | QQQ | ETF | 92.75 | 92.75 | 92.5 | 92.5 | 400.0 |
| 2000-01-10 09:30:00 | DIA | ETF | 116.8125 | 116.8125 | 116.3125 | 116.4062 | 317200.0 |
| 2000-01-10 10:00:00 | DIA | ETF | 116.25 | 116.5625 | 115.9375 | 116.1562 | 100600.0 |
| 2000-01-10 10:30:00 | DIA | ETF | 116.0625 | 116.2812 | 115.6562 | 115.8438 | 52600.0 |
| 2000-01-10 11:00:00 | DIA | ETF | 115.6875 | 116.0625 | 115.5625 | 115.9062 | 78500.0 |
| 2000-01-10 11:30:00 | DIA | ETF | 115.9062 | 116.1562 | 115.8125 | 115.9375 | 25100.0 |
| 2000-01-10 12:00:00 | DIA | ETF | 116.125 | 116.1562 | 115.875 | 116.0938 | 16100.0 |
| 2000-01-10 12:30:00 | DIA | ETF | 116.0938 | 116.2188 | 115.9062 | 116.0312 | 16100.0 |
| 2000-01-10 13:00:00 | DIA | ETF | 116.125 | 116.125 | 115.625 | 115.875 | 9100.0 |
| 2000-01-10 13:30:00 | DIA | ETF | 115.7188 | 116.0 | 115.4375 | 115.5625 | 35700.0 |
| 2000-01-10 14:00:00 | DIA | ETF | 115.4375 | 115.875 | 115.4375 | 115.6875 | 26200.0 |
| 2000-01-10 14:30:00 | DIA | ETF | 115.75 | 116.0 | 115.5938 | 116.0 | 6200.0 |
| 2000-01-10 15:00:00 | DIA | ETF | 116.2188 | 116.375 | 115.7812 | 116.375 | 29600.0 |
| 2000-01-10 15:30:00 | DIA | ETF | 116.25 | 116.3125 | 115.75 | 115.9375 | 28400.0 |
| 2000-01-10 16:00:00 | DIA | ETF | 115.75 | 116.0 | 115.75 | 116.0 | 15800.0 |
> showing 47 of 239 rows — these rows as CSV