PREVIEW / etf_30min / 2000-09-19
file: by_date/etf_30min/2000/2000-09-19.parquet size: 11 KB rows: 261
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-09-19 09:30:00 | SPY | ETF | 145.125 | 145.625 | 144.6875 | 145.125 | 833800.0 |
| 2000-09-19 10:00:00 | SPY | ETF | 145.125 | 145.4688 | 144.9062 | 145.4375 | 384500.0 |
| 2000-09-19 10:30:00 | SPY | ETF | 145.25 | 145.5 | 144.75 | 144.9375 | 284800.0 |
| 2000-09-19 11:00:00 | SPY | ETF | 144.9688 | 145.8438 | 144.875 | 145.625 | 488900.0 |
| 2000-09-19 11:30:00 | SPY | ETF | 145.625 | 145.9375 | 145.25 | 145.3438 | 516100.0 |
| 2000-09-19 12:00:00 | SPY | ETF | 145.3125 | 145.5 | 145.125 | 145.2188 | 117700.0 |
| 2000-09-19 12:30:00 | SPY | ETF | 145.2188 | 145.3125 | 144.9688 | 145.125 | 123300.0 |
| 2000-09-19 13:00:00 | SPY | ETF | 145.2188 | 145.5 | 145.1875 | 145.3125 | 253100.0 |
| 2000-09-19 13:30:00 | SPY | ETF | 145.3438 | 145.7188 | 145.25 | 145.4375 | 265800.0 |
| 2000-09-19 14:00:00 | SPY | ETF | 145.25 | 145.6875 | 145.25 | 145.5938 | 221800.0 |
| 2000-09-19 14:30:00 | SPY | ETF | 145.625 | 145.75 | 145.25 | 145.75 | 529600.0 |
| 2000-09-19 15:00:00 | SPY | ETF | 145.6562 | 146.0312 | 145.5938 | 146.0 | 1106900.0 |
| 2000-09-19 15:30:00 | SPY | ETF | 145.9688 | 146.3125 | 145.9062 | 146.0625 | 975600.0 |
| 2000-09-19 16:00:00 | SPY | ETF | 146.2188 | 146.3125 | 145.75 | 146.3125 | 419500.0 |
| 2000-09-19 09:30:00 | QQQ | ETF | 90.75 | 92.0625 | 89.875 | 91.5312 | 4949100.0 |
| 2000-09-19 10:00:00 | QQQ | ETF | 91.4688 | 92.0 | 90.875 | 91.4375 | 3033600.0 |
| 2000-09-19 10:30:00 | QQQ | ETF | 91.4375 | 91.625 | 90.5 | 90.9688 | 2051600.0 |
| 2000-09-19 11:00:00 | QQQ | ETF | 90.875 | 92.0 | 90.6875 | 91.8438 | 2273500.0 |
| 2000-09-19 11:30:00 | QQQ | ETF | 91.875 | 92.25 | 91.5625 | 91.7188 | 1073000.0 |
| 2000-09-19 12:00:00 | QQQ | ETF | 91.6875 | 91.9688 | 91.375 | 91.625 | 651900.0 |
| 2000-09-19 12:30:00 | QQQ | ETF | 91.5938 | 91.6875 | 91.375 | 91.625 | 778900.0 |
| 2000-09-19 13:00:00 | QQQ | ETF | 91.6562 | 92.1875 | 91.625 | 92.0 | 1142200.0 |
| 2000-09-19 13:30:00 | QQQ | ETF | 92.0 | 92.7812 | 91.9062 | 92.375 | 2032700.0 |
| 2000-09-19 14:00:00 | QQQ | ETF | 92.375 | 92.8438 | 92.1562 | 92.625 | 1520800.0 |
| 2000-09-19 14:30:00 | QQQ | ETF | 92.6875 | 93.0312 | 92.375 | 93.0 | 1583800.0 |
| 2000-09-19 15:00:00 | QQQ | ETF | 93.0312 | 93.6875 | 92.75 | 93.5938 | 2815800.0 |
| 2000-09-19 15:30:00 | QQQ | ETF | 93.5 | 93.7188 | 93.0312 | 93.5625 | 3151200.0 |
| 2000-09-19 16:00:00 | QQQ | ETF | 93.5 | 93.6875 | 93.375 | 93.5 | 417000.0 |
| 2000-09-19 16:30:00 | QQQ | ETF | 93.625 | 93.625 | 93.2188 | 93.5 | 4200.0 |
| 2000-09-19 17:00:00 | QQQ | ETF | 93.3125 | 93.3125 | 93.25 | 93.3125 | 6400.0 |
| 2000-09-19 17:30:00 | QQQ | ETF | 93.3125 | 93.375 | 93.1875 | 93.1875 | 8200.0 |
| 2000-09-19 18:00:00 | QQQ | ETF | 93.1875 | 93.1875 | 93.1875 | 93.1875 | 100.0 |
| 2000-09-19 09:30:00 | IWM | ETF | 51.9844 | 51.9844 | 51.9375 | 51.9375 | 800.0 |
| 2000-09-19 10:00:00 | IWM | ETF | 51.8125 | 51.875 | 51.8125 | 51.875 | 800.0 |
| 2000-09-19 11:00:00 | IWM | ETF | 51.75 | 51.8125 | 51.7344 | 51.75 | 7200.0 |
| 2000-09-19 11:30:00 | IWM | ETF | 51.7344 | 51.7812 | 51.625 | 51.6875 | 5800.0 |
| 2000-09-19 12:30:00 | IWM | ETF | 51.7188 | 51.7188 | 51.7188 | 51.7188 | 1000.0 |
| 2000-09-19 13:00:00 | IWM | ETF | 51.75 | 51.75 | 51.75 | 51.75 | 400.0 |
| 2000-09-19 13:30:00 | IWM | ETF | 51.75 | 51.7812 | 51.75 | 51.7812 | 3000.0 |
| 2000-09-19 14:00:00 | IWM | ETF | 51.6562 | 51.6562 | 51.6562 | 51.6562 | 200.0 |
| 2000-09-19 14:30:00 | IWM | ETF | 51.7188 | 51.7188 | 51.7188 | 51.7188 | 200.0 |
| 2000-09-19 15:00:00 | IWM | ETF | 51.875 | 52.0625 | 51.875 | 52.0625 | 3800.0 |
| 2000-09-19 15:30:00 | IWM | ETF | 52.25 | 52.375 | 52.2188 | 52.25 | 25600.0 |
| 2000-09-19 16:00:00 | IWM | ETF | 52.7188 | 52.7188 | 52.5 | 52.5 | 3800.0 |
| 2000-09-19 09:30:00 | DIA | ETF | 108.4375 | 108.4375 | 108.0625 | 108.0625 | 65900.0 |
| 2000-09-19 10:00:00 | DIA | ETF | 108.125 | 108.1875 | 107.7188 | 108.0312 | 91200.0 |
| 2000-09-19 10:30:00 | DIA | ETF | 108.0312 | 108.0938 | 107.625 | 107.7188 | 33700.0 |
| 2000-09-19 11:00:00 | DIA | ETF | 107.75 | 108.125 | 107.6875 | 108.0 | 56300.0 |
| 2000-09-19 11:30:00 | DIA | ETF | 108.0312 | 108.2812 | 107.875 | 107.9062 | 43300.0 |
| 2000-09-19 12:00:00 | DIA | ETF | 107.9062 | 108.0625 | 107.75 | 107.7812 | 20500.0 |
> showing 50 of 261 rows — these rows as CSV