PREVIEW / etf_30min / 2000-06-12
file: by_date/etf_30min/2000/2000-06-12.parquet size: 10 KB rows: 250
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-06-12 09:30:00 | SPY | ETF | 146.9688 | 146.9688 | 146.5 | 146.6562 | 234100.0 |
| 2000-06-12 10:00:00 | SPY | ETF | 146.5312 | 146.6875 | 145.8125 | 145.9062 | 126500.0 |
| 2000-06-12 10:30:00 | SPY | ETF | 146.125 | 146.25 | 145.9375 | 146.1562 | 316400.0 |
| 2000-06-12 11:00:00 | SPY | ETF | 146.1875 | 146.1875 | 145.8125 | 146.1875 | 79400.0 |
| 2000-06-12 11:30:00 | SPY | ETF | 146.125 | 146.125 | 145.5625 | 145.5625 | 98700.0 |
| 2000-06-12 12:00:00 | SPY | ETF | 145.5312 | 145.6875 | 145.3125 | 145.6875 | 288900.0 |
| 2000-06-12 12:30:00 | SPY | ETF | 145.6875 | 145.875 | 145.625 | 145.875 | 68100.0 |
| 2000-06-12 13:00:00 | SPY | ETF | 145.9375 | 145.9688 | 145.75 | 145.8125 | 45400.0 |
| 2000-06-12 13:30:00 | SPY | ETF | 145.8438 | 145.8438 | 145.4062 | 145.625 | 193800.0 |
| 2000-06-12 14:00:00 | SPY | ETF | 145.625 | 145.875 | 145.5 | 145.5625 | 81600.0 |
| 2000-06-12 14:30:00 | SPY | ETF | 145.5 | 145.75 | 145.25 | 145.75 | 114100.0 |
| 2000-06-12 15:00:00 | SPY | ETF | 145.7812 | 146.0625 | 145.6875 | 145.6875 | 312200.0 |
| 2000-06-12 15:30:00 | SPY | ETF | 145.875 | 145.9688 | 145.125 | 145.2812 | 1120200.0 |
| 2000-06-12 16:00:00 | SPY | ETF | 145.2812 | 145.2812 | 144.875 | 145.125 | 396900.0 |
| 2000-06-12 09:30:00 | QQQ | ETF | 94.3125 | 94.3125 | 93.0 | 93.4375 | 1923700.0 |
| 2000-06-12 10:00:00 | QQQ | ETF | 93.375 | 93.5625 | 91.875 | 92.375 | 1774000.0 |
| 2000-06-12 10:30:00 | QQQ | ETF | 92.375 | 92.625 | 92.0312 | 92.3438 | 1237800.0 |
| 2000-06-12 11:00:00 | QQQ | ETF | 92.25 | 92.4688 | 91.875 | 92.375 | 972600.0 |
| 2000-06-12 11:30:00 | QQQ | ETF | 92.375 | 92.4375 | 91.5625 | 91.8125 | 858900.0 |
| 2000-06-12 12:00:00 | QQQ | ETF | 91.75 | 91.875 | 91.25 | 91.8125 | 989700.0 |
| 2000-06-12 12:30:00 | QQQ | ETF | 91.8125 | 92.125 | 91.5 | 92.0625 | 908900.0 |
| 2000-06-12 13:00:00 | QQQ | ETF | 92.0938 | 92.3125 | 91.875 | 91.9375 | 678300.0 |
| 2000-06-12 13:30:00 | QQQ | ETF | 91.875 | 91.9688 | 91.375 | 91.5 | 989200.0 |
| 2000-06-12 14:00:00 | QQQ | ETF | 91.4375 | 92.0 | 91.4375 | 91.5625 | 907700.0 |
| 2000-06-12 14:30:00 | QQQ | ETF | 91.625 | 92.125 | 91.375 | 92.125 | 637300.0 |
| 2000-06-12 15:00:00 | QQQ | ETF | 92.1875 | 92.75 | 91.9375 | 92.25 | 1191300.0 |
| 2000-06-12 15:30:00 | QQQ | ETF | 92.25 | 92.3125 | 90.875 | 90.9688 | 2644900.0 |
| 2000-06-12 16:00:00 | QQQ | ETF | 91.0 | 91.0625 | 90.8125 | 91.0 | 681100.0 |
| 2000-06-12 16:30:00 | QQQ | ETF | 91.25 | 91.25 | 91.0 | 91.0 | 2700.0 |
| 2000-06-12 17:00:00 | QQQ | ETF | 90.875 | 90.875 | 90.875 | 90.875 | 200.0 |
| 2000-06-12 17:30:00 | QQQ | ETF | 90.875 | 90.875 | 90.75 | 90.75 | 1100.0 |
| 2000-06-12 18:00:00 | QQQ | ETF | 90.75 | 90.75 | 90.75 | 90.75 | 200.0 |
| 2000-06-12 09:30:00 | IWM | ETF | 52.5 | 52.5 | 52.25 | 52.25 | 13600.0 |
| 2000-06-12 10:00:00 | IWM | ETF | 52.1719 | 52.1875 | 52.0312 | 52.0312 | 1400.0 |
| 2000-06-12 10:30:00 | IWM | ETF | 51.7812 | 51.8438 | 51.7812 | 51.8438 | 1600.0 |
| 2000-06-12 12:00:00 | IWM | ETF | 51.1875 | 51.1875 | 51.0938 | 51.1094 | 13400.0 |
| 2000-06-12 13:00:00 | IWM | ETF | 51.2969 | 51.2969 | 51.2969 | 51.2969 | 200.0 |
| 2000-06-12 13:30:00 | IWM | ETF | 51.125 | 51.125 | 51.1094 | 51.1094 | 2600.0 |
| 2000-06-12 14:00:00 | IWM | ETF | 51.1719 | 51.2188 | 51.1719 | 51.2188 | 3000.0 |
| 2000-06-12 14:30:00 | IWM | ETF | 51.1406 | 51.1406 | 51.125 | 51.125 | 2000.0 |
| 2000-06-12 15:00:00 | IWM | ETF | 51.1875 | 51.2812 | 51.1875 | 51.2188 | 20400.0 |
| 2000-06-12 15:30:00 | IWM | ETF | 51.0625 | 51.0625 | 50.75 | 50.75 | 26800.0 |
| 2000-06-12 16:00:00 | IWM | ETF | 50.7812 | 50.7812 | 50.7812 | 50.7812 | 200.0 |
| 2000-06-12 09:30:00 | DIA | ETF | 106.625 | 106.6875 | 106.2812 | 106.375 | 34200.0 |
| 2000-06-12 10:00:00 | DIA | ETF | 106.3125 | 106.5 | 106.0 | 106.25 | 44700.0 |
| 2000-06-12 10:30:00 | DIA | ETF | 106.1562 | 106.4062 | 106.0625 | 106.2812 | 26900.0 |
| 2000-06-12 11:00:00 | DIA | ETF | 106.3125 | 106.4688 | 106.25 | 106.4688 | 4700.0 |
| 2000-06-12 11:30:00 | DIA | ETF | 106.3438 | 106.3438 | 105.8438 | 105.9688 | 50900.0 |
| 2000-06-12 12:00:00 | DIA | ETF | 105.9375 | 106.0938 | 105.7188 | 106.0938 | 114200.0 |
| 2000-06-12 12:30:00 | DIA | ETF | 106.0312 | 106.2188 | 106.0 | 106.125 | 31100.0 |
> showing 50 of 250 rows — these rows as CSV