PREVIEW / etf_30min / 2000-09-21
file: by_date/etf_30min/2000/2000-09-21.parquet size: 11 KB rows: 286
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-21 09:30:00 | SPY | ETF | 144.4688 | 145.125 | 144.25 | 144.625 | 1085000.0 |
| 2000-09-21 10:00:00 | SPY | ETF | 144.4688 | 144.8125 | 144.0625 | 144.5625 | 566400.0 |
| 2000-09-21 10:30:00 | SPY | ETF | 144.6562 | 145.0 | 144.5 | 144.5312 | 263000.0 |
| 2000-09-21 11:00:00 | SPY | ETF | 144.625 | 144.6562 | 144.1562 | 144.4062 | 207800.0 |
| 2000-09-21 11:30:00 | SPY | ETF | 144.125 | 144.3438 | 143.75 | 144.0938 | 464100.0 |
| 2000-09-21 12:00:00 | SPY | ETF | 144.0625 | 144.75 | 144.0625 | 144.75 | 245100.0 |
| 2000-09-21 12:30:00 | SPY | ETF | 144.8125 | 144.8125 | 144.4375 | 144.5 | 109400.0 |
| 2000-09-21 13:00:00 | SPY | ETF | 144.5625 | 145.1875 | 144.5 | 144.9062 | 147300.0 |
| 2000-09-21 13:30:00 | SPY | ETF | 144.8438 | 144.8438 | 144.4375 | 144.625 | 220900.0 |
| 2000-09-21 14:00:00 | SPY | ETF | 144.8438 | 144.8438 | 143.875 | 144.125 | 349300.0 |
| 2000-09-21 14:30:00 | SPY | ETF | 144.0625 | 144.5312 | 143.9062 | 144.25 | 273600.0 |
| 2000-09-21 15:00:00 | SPY | ETF | 144.3438 | 144.5625 | 143.9062 | 144.5 | 204800.0 |
| 2000-09-21 15:30:00 | SPY | ETF | 144.5 | 145.5625 | 144.4375 | 145.0312 | 607400.0 |
| 2000-09-21 16:00:00 | SPY | ETF | 145.0 | 145.1875 | 143.375 | 143.375 | 1130600.0 |
| 2000-09-21 16:30:00 | SPY | ETF | 143.0 | 143.0 | 143.0 | 143.0 | 300.0 |
| 2000-09-21 17:00:00 | SPY | ETF | 143.0 | 143.0 | 143.0 | 143.0 | 500.0 |
| 2000-09-21 17:30:00 | SPY | ETF | 142.75 | 142.75 | 142.75 | 142.75 | 500.0 |
| 2000-09-21 18:00:00 | SPY | ETF | 142.625 | 142.6875 | 142.625 | 142.6875 | 700.0 |
| 2000-09-21 09:30:00 | QQQ | ETF | 93.75 | 94.4688 | 93.25 | 93.7188 | 3503600.0 |
| 2000-09-21 10:00:00 | QQQ | ETF | 93.6875 | 93.9375 | 93.0 | 93.5 | 2589600.0 |
| 2000-09-21 10:30:00 | QQQ | ETF | 93.5 | 93.875 | 93.125 | 93.2812 | 1284400.0 |
| 2000-09-21 11:00:00 | QQQ | ETF | 93.4375 | 93.4688 | 92.5625 | 92.7188 | 2767200.0 |
| 2000-09-21 11:30:00 | QQQ | ETF | 92.6875 | 93.25 | 92.125 | 92.875 | 2364000.0 |
| 2000-09-21 12:00:00 | QQQ | ETF | 92.875 | 93.6875 | 92.875 | 93.625 | 1381600.0 |
| 2000-09-21 12:30:00 | QQQ | ETF | 93.5625 | 93.6875 | 92.875 | 93.0 | 984900.0 |
| 2000-09-21 13:00:00 | QQQ | ETF | 93.0 | 93.6875 | 93.0 | 93.4375 | 1251100.0 |
| 2000-09-21 13:30:00 | QQQ | ETF | 93.5 | 93.5 | 92.8125 | 93.25 | 805800.0 |
| 2000-09-21 14:00:00 | QQQ | ETF | 93.25 | 93.3438 | 92.1562 | 92.4375 | 1366800.0 |
| 2000-09-21 14:30:00 | QQQ | ETF | 92.4688 | 92.9375 | 92.3125 | 92.6875 | 1697600.0 |
| 2000-09-21 15:00:00 | QQQ | ETF | 92.6562 | 92.6875 | 92.0625 | 92.5625 | 1627400.0 |
| 2000-09-21 15:30:00 | QQQ | ETF | 92.5938 | 93.5938 | 92.4375 | 92.625 | 2045200.0 |
| 2000-09-21 16:00:00 | QQQ | ETF | 92.75 | 92.875 | 89.0 | 89.0 | 522500.0 |
| 2000-09-21 16:30:00 | QQQ | ETF | 89.125 | 92.5625 | 88.0 | 88.375 | 493100.0 |
| 2000-09-21 17:00:00 | QQQ | ETF | 88.375 | 89.25 | 87.5 | 88.625 | 111300.0 |
| 2000-09-21 17:30:00 | QQQ | ETF | 88.5 | 88.75 | 87.0 | 87.875 | 28800.0 |
| 2000-09-21 18:00:00 | QQQ | ETF | 87.9375 | 88.0625 | 87.5 | 87.75 | 39300.0 |
| 2000-09-21 09:30:00 | IWM | ETF | 52.0 | 52.0 | 51.8125 | 51.8125 | 22800.0 |
| 2000-09-21 10:00:00 | IWM | ETF | 52.0 | 52.0 | 52.0 | 52.0 | 400.0 |
| 2000-09-21 10:30:00 | IWM | ETF | 51.9219 | 51.9219 | 51.7344 | 51.9219 | 1600.0 |
| 2000-09-21 11:00:00 | IWM | ETF | 51.8125 | 51.8125 | 51.8125 | 51.8125 | 600.0 |
| 2000-09-21 11:30:00 | IWM | ETF | 51.6875 | 51.6875 | 51.6875 | 51.6875 | 2400.0 |
| 2000-09-21 12:00:00 | IWM | ETF | 51.6562 | 51.7188 | 51.6562 | 51.7188 | 3400.0 |
| 2000-09-21 12:30:00 | IWM | ETF | 51.625 | 51.625 | 51.625 | 51.625 | 1400.0 |
| 2000-09-21 13:30:00 | IWM | ETF | 51.5938 | 51.625 | 51.5938 | 51.625 | 1000.0 |
| 2000-09-21 14:00:00 | IWM | ETF | 51.6406 | 51.6406 | 51.4375 | 51.4375 | 5800.0 |
| 2000-09-21 14:30:00 | IWM | ETF | 51.5625 | 51.5625 | 51.5625 | 51.5625 | 61000.0 |
| 2000-09-21 15:00:00 | IWM | ETF | 51.4219 | 51.5 | 51.4219 | 51.5 | 600.0 |
| 2000-09-21 15:30:00 | IWM | ETF | 51.4375 | 51.4375 | 51.3125 | 51.3125 | 103200.0 |
| 2000-09-21 16:00:00 | IWM | ETF | 51.125 | 51.1562 | 50.9375 | 50.9375 | 3200.0 |
| 2000-09-21 09:30:00 | DIA | ETF | 106.5625 | 107.625 | 106.5625 | 107.125 | 311800.0 |
> showing 50 of 286 rows — these rows as CSV