PREVIEW / etf_30min / 2000-07-06
file: by_date/etf_30min/2000/2000-07-06.parquet size: 11 KB rows: 266
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-07-06 09:30:00 | SPY | ETF | 144.9375 | 145.3438 | 144.8125 | 144.9375 | 596600.0 |
| 2000-07-06 10:00:00 | SPY | ETF | 145.1562 | 145.1562 | 144.375 | 144.5625 | 782600.0 |
| 2000-07-06 10:30:00 | SPY | ETF | 144.3438 | 144.6562 | 144.2188 | 144.375 | 657000.0 |
| 2000-07-06 11:00:00 | SPY | ETF | 144.375 | 144.75 | 144.3125 | 144.625 | 404200.0 |
| 2000-07-06 11:30:00 | SPY | ETF | 144.5 | 145.1562 | 144.5 | 144.9062 | 354900.0 |
| 2000-07-06 12:00:00 | SPY | ETF | 144.75 | 145.1875 | 144.75 | 145.1875 | 69600.0 |
| 2000-07-06 12:30:00 | SPY | ETF | 145.1875 | 145.25 | 144.8438 | 145.25 | 172200.0 |
| 2000-07-06 13:00:00 | SPY | ETF | 145.1562 | 145.5625 | 145.125 | 145.3125 | 326200.0 |
| 2000-07-06 13:30:00 | SPY | ETF | 145.3125 | 145.5312 | 145.2188 | 145.2188 | 415800.0 |
| 2000-07-06 14:00:00 | SPY | ETF | 145.25 | 145.9375 | 145.1875 | 145.9375 | 139500.0 |
| 2000-07-06 14:30:00 | SPY | ETF | 145.9375 | 146.25 | 145.875 | 145.9688 | 539900.0 |
| 2000-07-06 15:00:00 | SPY | ETF | 145.875 | 146.375 | 145.8125 | 146.125 | 230800.0 |
| 2000-07-06 15:30:00 | SPY | ETF | 146.2188 | 146.4688 | 145.8125 | 145.875 | 467800.0 |
| 2000-07-06 16:00:00 | SPY | ETF | 145.875 | 145.9688 | 145.6562 | 145.75 | 792800.0 |
| 2000-07-06 09:30:00 | QQQ | ETF | 91.5625 | 92.0 | 91.0 | 91.5 | 2346100.0 |
| 2000-07-06 10:00:00 | QQQ | ETF | 91.5 | 91.75 | 90.625 | 90.8125 | 1865600.0 |
| 2000-07-06 10:30:00 | QQQ | ETF | 90.75 | 91.125 | 90.125 | 90.125 | 2273400.0 |
| 2000-07-06 11:00:00 | QQQ | ETF | 90.0625 | 91.0 | 90.0625 | 90.9375 | 1348000.0 |
| 2000-07-06 11:30:00 | QQQ | ETF | 90.9375 | 92.0 | 90.875 | 91.625 | 1714700.0 |
| 2000-07-06 12:00:00 | QQQ | ETF | 91.5312 | 92.5625 | 91.5312 | 92.5 | 1234900.0 |
| 2000-07-06 12:30:00 | QQQ | ETF | 92.5 | 92.625 | 92.0 | 92.4375 | 1053800.0 |
| 2000-07-06 13:00:00 | QQQ | ETF | 92.4375 | 92.9688 | 92.3125 | 92.5625 | 1030200.0 |
| 2000-07-06 13:30:00 | QQQ | ETF | 92.5 | 92.875 | 92.375 | 92.625 | 567400.0 |
| 2000-07-06 14:00:00 | QQQ | ETF | 92.5 | 93.375 | 92.2812 | 93.25 | 1315800.0 |
| 2000-07-06 14:30:00 | QQQ | ETF | 93.25 | 93.8438 | 93.1875 | 93.5 | 2154300.0 |
| 2000-07-06 15:00:00 | QQQ | ETF | 93.625 | 94.375 | 93.3125 | 94.25 | 2182800.0 |
| 2000-07-06 15:30:00 | QQQ | ETF | 94.1875 | 94.75 | 94.0625 | 94.5 | 3288600.0 |
| 2000-07-06 16:00:00 | QQQ | ETF | 94.5 | 94.6875 | 94.4375 | 94.625 | 1051900.0 |
| 2000-07-06 16:30:00 | QQQ | ETF | 94.5 | 94.5 | 94.25 | 94.25 | 900.0 |
| 2000-07-06 17:30:00 | QQQ | ETF | 94.4375 | 94.4375 | 94.3125 | 94.3125 | 1400.0 |
| 2000-07-06 18:00:00 | QQQ | ETF | 94.0 | 94.0 | 94.0 | 94.0 | 100.0 |
| 2000-07-06 09:30:00 | IWM | ETF | 51.8281 | 51.8281 | 51.6875 | 51.75 | 7800.0 |
| 2000-07-06 10:00:00 | IWM | ETF | 51.625 | 51.6719 | 51.5 | 51.5625 | 32400.0 |
| 2000-07-06 10:30:00 | IWM | ETF | 51.4219 | 51.4219 | 51.375 | 51.375 | 13000.0 |
| 2000-07-06 11:00:00 | IWM | ETF | 51.3438 | 51.4219 | 51.3438 | 51.4219 | 8000.0 |
| 2000-07-06 11:30:00 | IWM | ETF | 51.6094 | 51.625 | 51.5938 | 51.5938 | 5000.0 |
| 2000-07-06 12:00:00 | IWM | ETF | 51.6875 | 51.7188 | 51.6875 | 51.7188 | 22400.0 |
| 2000-07-06 12:30:00 | IWM | ETF | 51.7188 | 51.7188 | 51.7188 | 51.7188 | 2000.0 |
| 2000-07-06 13:30:00 | IWM | ETF | 51.7969 | 51.7969 | 51.7969 | 51.7969 | 1000.0 |
| 2000-07-06 14:00:00 | IWM | ETF | 51.8125 | 51.8125 | 51.8125 | 51.8125 | 13800.0 |
| 2000-07-06 15:00:00 | IWM | ETF | 51.8125 | 51.9219 | 51.8125 | 51.9219 | 29400.0 |
| 2000-07-06 15:30:00 | IWM | ETF | 52.1562 | 52.3594 | 52.1562 | 52.3594 | 17800.0 |
| 2000-07-06 16:00:00 | IWM | ETF | 52.375 | 52.4219 | 52.3125 | 52.4219 | 2000.0 |
| 2000-07-06 09:30:00 | DIA | ETF | 105.3438 | 105.3438 | 104.5938 | 104.6562 | 35100.0 |
| 2000-07-06 10:00:00 | DIA | ETF | 104.5 | 104.5938 | 104.0625 | 104.4062 | 22200.0 |
| 2000-07-06 10:30:00 | DIA | ETF | 104.125 | 104.4375 | 104.0625 | 104.375 | 17900.0 |
| 2000-07-06 11:00:00 | DIA | ETF | 104.375 | 104.5625 | 104.3438 | 104.375 | 9400.0 |
| 2000-07-06 11:30:00 | DIA | ETF | 104.5 | 104.875 | 104.5 | 104.6562 | 23100.0 |
| 2000-07-06 12:00:00 | DIA | ETF | 104.5312 | 104.7188 | 104.4375 | 104.625 | 10600.0 |
| 2000-07-06 12:30:00 | DIA | ETF | 104.625 | 104.6875 | 104.5 | 104.625 | 7600.0 |
> showing 50 of 266 rows — these rows as CSV