PREVIEW / etf_30min / 2000-06-30
file: by_date/etf_30min/2000/2000-06-30.parquet size: 11 KB rows: 233
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-30 09:30:00 | SPY | ETF | 143.9375 | 144.4062 | 143.875 | 144.0312 | 530500.0 |
| 2000-06-30 10:00:00 | SPY | ETF | 144.0625 | 144.625 | 143.9062 | 144.625 | 438100.0 |
| 2000-06-30 10:30:00 | SPY | ETF | 144.6875 | 144.8438 | 144.5 | 144.625 | 492600.0 |
| 2000-06-30 11:00:00 | SPY | ETF | 144.625 | 145.2188 | 144.5312 | 145.0312 | 522300.0 |
| 2000-06-30 11:30:00 | SPY | ETF | 145.1875 | 145.1875 | 144.6875 | 144.6875 | 354200.0 |
| 2000-06-30 12:00:00 | SPY | ETF | 144.75 | 144.9688 | 144.625 | 144.9688 | 329500.0 |
| 2000-06-30 12:30:00 | SPY | ETF | 144.9375 | 145.0625 | 144.75 | 145.0312 | 492200.0 |
| 2000-06-30 13:00:00 | SPY | ETF | 145.0312 | 145.25 | 144.875 | 145.0 | 365200.0 |
| 2000-06-30 13:30:00 | SPY | ETF | 144.875 | 145.0 | 144.625 | 144.8125 | 617500.0 |
| 2000-06-30 14:00:00 | SPY | ETF | 144.9375 | 144.9375 | 144.1875 | 144.1875 | 637700.0 |
| 2000-06-30 14:30:00 | SPY | ETF | 144.3125 | 144.9062 | 144.2812 | 144.875 | 162200.0 |
| 2000-06-30 15:00:00 | SPY | ETF | 144.875 | 144.875 | 144.0312 | 144.5938 | 410300.0 |
| 2000-06-30 15:30:00 | SPY | ETF | 144.625 | 145.5312 | 144.625 | 145.375 | 1286600.0 |
| 2000-06-30 16:00:00 | SPY | ETF | 145.4062 | 145.5938 | 145.2812 | 145.5 | 752900.0 |
| 2000-06-30 16:30:00 | SPY | ETF | 145.375 | 145.375 | 145.2812 | 145.2812 | 600.0 |
| 2000-06-30 09:30:00 | QQQ | ETF | 91.8125 | 92.4688 | 91.75 | 92.125 | 2308600.0 |
| 2000-06-30 10:00:00 | QQQ | ETF | 92.1875 | 93.0 | 92.0625 | 93.0 | 1207700.0 |
| 2000-06-30 10:30:00 | QQQ | ETF | 92.9688 | 93.25 | 92.5 | 92.9375 | 884100.0 |
| 2000-06-30 11:00:00 | QQQ | ETF | 92.9375 | 93.4375 | 92.8125 | 93.3438 | 583500.0 |
| 2000-06-30 11:30:00 | QQQ | ETF | 93.375 | 93.5 | 92.875 | 92.9688 | 769500.0 |
| 2000-06-30 12:00:00 | QQQ | ETF | 92.9688 | 93.25 | 92.75 | 93.1875 | 339900.0 |
| 2000-06-30 12:30:00 | QQQ | ETF | 93.1875 | 93.25 | 92.875 | 93.0938 | 431700.0 |
| 2000-06-30 13:00:00 | QQQ | ETF | 93.0312 | 93.4375 | 93.0312 | 93.2188 | 518200.0 |
| 2000-06-30 13:30:00 | QQQ | ETF | 93.2188 | 93.25 | 92.875 | 93.0 | 893600.0 |
| 2000-06-30 14:00:00 | QQQ | ETF | 92.875 | 93.0625 | 92.3125 | 92.5 | 1305900.0 |
| 2000-06-30 14:30:00 | QQQ | ETF | 92.5 | 93.125 | 92.5 | 92.9375 | 973900.0 |
| 2000-06-30 15:00:00 | QQQ | ETF | 93.0 | 93.125 | 92.25 | 92.75 | 1525000.0 |
| 2000-06-30 15:30:00 | QQQ | ETF | 92.875 | 93.9375 | 92.875 | 93.75 | 2367600.0 |
| 2000-06-30 16:00:00 | QQQ | ETF | 93.6875 | 93.8125 | 92.75 | 93.0 | 958200.0 |
| 2000-06-30 16:30:00 | QQQ | ETF | 93.125 | 93.9375 | 93.0 | 93.3125 | 40900.0 |
| 2000-06-30 17:00:00 | QQQ | ETF | 93.4375 | 93.4375 | 93.4375 | 93.4375 | 8200.0 |
| 2000-06-30 09:30:00 | IWM | ETF | 51.2188 | 51.2188 | 50.9688 | 50.9688 | 50400.0 |
| 2000-06-30 10:00:00 | IWM | ETF | 51.25 | 51.25 | 51.25 | 51.25 | 11600.0 |
| 2000-06-30 10:30:00 | IWM | ETF | 51.3125 | 51.4062 | 51.3125 | 51.4062 | 102200.0 |
| 2000-06-30 11:00:00 | IWM | ETF | 51.4219 | 51.4219 | 51.2812 | 51.2812 | 51000.0 |
| 2000-06-30 11:30:00 | IWM | ETF | 51.3125 | 51.3125 | 51.1875 | 51.1875 | 53600.0 |
| 2000-06-30 12:00:00 | IWM | ETF | 51.2812 | 51.3125 | 51.2812 | 51.3125 | 101800.0 |
| 2000-06-30 12:30:00 | IWM | ETF | 51.1875 | 51.2969 | 51.1875 | 51.2969 | 4600.0 |
| 2000-06-30 13:00:00 | IWM | ETF | 51.2969 | 51.2969 | 51.2969 | 51.2969 | 200.0 |
| 2000-06-30 13:30:00 | IWM | ETF | 51.2188 | 51.2812 | 51.2188 | 51.2812 | 101200.0 |
| 2000-06-30 14:00:00 | IWM | ETF | 51.2344 | 51.2344 | 50.9375 | 50.9375 | 102600.0 |
| 2000-06-30 14:30:00 | IWM | ETF | 50.9688 | 50.9688 | 50.9688 | 50.9688 | 50000.0 |
| 2000-06-30 15:00:00 | IWM | ETF | 51.2188 | 51.2188 | 50.7969 | 50.8125 | 108600.0 |
| 2000-06-30 15:30:00 | IWM | ETF | 50.8125 | 51.6719 | 50.8125 | 51.625 | 270200.0 |
| 2000-06-30 16:00:00 | IWM | ETF | 51.6094 | 51.6719 | 51.6094 | 51.6719 | 163800.0 |
| 2000-06-30 09:30:00 | DIA | ETF | 103.5312 | 103.9062 | 103.5 | 103.6875 | 143800.0 |
| 2000-06-30 10:00:00 | DIA | ETF | 103.5 | 103.8125 | 103.3438 | 103.5625 | 67000.0 |
| 2000-06-30 10:30:00 | DIA | ETF | 103.8125 | 103.8125 | 103.4375 | 103.7188 | 39700.0 |
| 2000-06-30 11:00:00 | DIA | ETF | 103.75 | 104.125 | 103.7188 | 104.0 | 34700.0 |
| 2000-06-30 11:30:00 | DIA | ETF | 104.1875 | 104.1875 | 103.8125 | 103.8125 | 12100.0 |
> showing 50 of 233 rows — these rows as CSV