PREVIEW / etf_30min / 2001-06-22
file: by_date/etf_30min/2001/2001-06-22.parquet size: 15 KB rows: 368
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 |
|---|---|---|---|---|---|---|---|
| 2001-06-22 09:30:00 | SPY | ETF | 123.49 | 123.59 | 123.21 | 123.3 | 1902000.0 |
| 2001-06-22 10:00:00 | SPY | ETF | 123.28 | 123.44 | 122.93 | 123.37 | 941200.0 |
| 2001-06-22 10:30:00 | SPY | ETF | 123.33 | 123.58 | 123.17 | 123.22 | 761600.0 |
| 2001-06-22 11:00:00 | SPY | ETF | 123.24 | 123.3 | 122.95 | 122.96 | 948100.0 |
| 2001-06-22 11:30:00 | SPY | ETF | 122.95 | 123.04 | 122.65 | 122.7 | 734100.0 |
| 2001-06-22 12:00:00 | SPY | ETF | 122.73 | 122.88 | 122.5 | 122.6 | 391900.0 |
| 2001-06-22 12:30:00 | SPY | ETF | 122.6 | 122.95 | 122.55 | 122.75 | 530800.0 |
| 2001-06-22 13:00:00 | SPY | ETF | 122.77 | 123.04 | 122.75 | 122.91 | 354000.0 |
| 2001-06-22 13:30:00 | SPY | ETF | 122.85 | 122.94 | 122.68 | 122.85 | 622000.0 |
| 2001-06-22 14:00:00 | SPY | ETF | 122.84 | 123.22 | 122.81 | 122.95 | 344600.0 |
| 2001-06-22 14:30:00 | SPY | ETF | 122.95 | 123.38 | 122.95 | 123.2 | 898000.0 |
| 2001-06-22 15:00:00 | SPY | ETF | 123.12 | 123.19 | 122.16 | 122.5 | 1560700.0 |
| 2001-06-22 15:30:00 | SPY | ETF | 122.52 | 122.99 | 122.52 | 122.75 | 1226500.0 |
| 2001-06-22 16:00:00 | SPY | ETF | 122.69 | 123.34 | 122.65 | 123.34 | 447400.0 |
| 2001-06-22 16:30:00 | SPY | ETF | 122.9 | 122.9 | 122.73 | 122.85 | 14500.0 |
| 2001-06-22 17:00:00 | SPY | ETF | 122.95 | 123.34 | 122.95 | 123.34 | 30200.0 |
| 2001-06-22 09:30:00 | QQQ | ETF | 43.62 | 43.92 | 43.15 | 43.75 | 9396600.0 |
| 2001-06-22 10:00:00 | QQQ | ETF | 43.76 | 44.0 | 43.35 | 43.91 | 4718500.0 |
| 2001-06-22 10:30:00 | QQQ | ETF | 43.94 | 44.2 | 43.85 | 43.86 | 6445700.0 |
| 2001-06-22 11:00:00 | QQQ | ETF | 43.84 | 44.0 | 43.59 | 43.66 | 2794700.0 |
| 2001-06-22 11:30:00 | QQQ | ETF | 43.65 | 43.75 | 43.4 | 43.54 | 3299700.0 |
| 2001-06-22 12:00:00 | QQQ | ETF | 43.55 | 43.64 | 43.28 | 43.34 | 2784900.0 |
| 2001-06-22 12:30:00 | QQQ | ETF | 43.36 | 43.62 | 43.3 | 43.59 | 1592800.0 |
| 2001-06-22 13:00:00 | QQQ | ETF | 43.55 | 43.72 | 43.49 | 43.53 | 1671100.0 |
| 2001-06-22 13:30:00 | QQQ | ETF | 43.49 | 43.55 | 43.27 | 43.38 | 2227100.0 |
| 2001-06-22 14:00:00 | QQQ | ETF | 43.35 | 43.7 | 43.31 | 43.31 | 1617600.0 |
| 2001-06-22 14:30:00 | QQQ | ETF | 43.35 | 43.77 | 43.31 | 43.5 | 1964400.0 |
| 2001-06-22 15:00:00 | QQQ | ETF | 43.5 | 43.53 | 42.59 | 43.02 | 5438600.0 |
| 2001-06-22 15:30:00 | QQQ | ETF | 43.03 | 43.39 | 42.97 | 43.1 | 3199100.0 |
| 2001-06-22 16:00:00 | QQQ | ETF | 43.1 | 43.35 | 43.05 | 43.24 | 890200.0 |
| 2001-06-22 16:30:00 | QQQ | ETF | 43.25 | 43.25 | 43.16 | 43.25 | 18500.0 |
| 2001-06-22 17:00:00 | QQQ | ETF | 43.25 | 43.3 | 43.11 | 43.24 | 26000.0 |
| 2001-06-22 17:30:00 | QQQ | ETF | 43.17 | 43.18 | 43.02 | 43.09 | 27400.0 |
| 2001-06-22 18:00:00 | QQQ | ETF | 43.09 | 43.13 | 43.01 | 43.1 | 3700.0 |
| 2001-06-22 09:30:00 | IWM | ETF | 49.625 | 49.625 | 49.425 | 49.425 | 40400.0 |
| 2001-06-22 10:00:00 | IWM | ETF | 49.425 | 49.425 | 49.205 | 49.205 | 118800.0 |
| 2001-06-22 10:30:00 | IWM | ETF | 49.245 | 49.335 | 49.21 | 49.33 | 7800.0 |
| 2001-06-22 11:00:00 | IWM | ETF | 49.24 | 49.24 | 49.005 | 49.005 | 34600.0 |
| 2001-06-22 11:30:00 | IWM | ETF | 48.955 | 48.985 | 48.705 | 48.705 | 75000.0 |
| 2001-06-22 12:00:00 | IWM | ETF | 48.705 | 48.87 | 48.705 | 48.84 | 19600.0 |
| 2001-06-22 12:30:00 | IWM | ETF | 48.845 | 48.845 | 48.845 | 48.845 | 600.0 |
| 2001-06-22 13:00:00 | IWM | ETF | 48.84 | 49.05 | 48.84 | 48.995 | 44800.0 |
| 2001-06-22 13:30:00 | IWM | ETF | 49.02 | 49.02 | 48.845 | 48.845 | 2800.0 |
| 2001-06-22 14:00:00 | IWM | ETF | 49.1 | 49.1 | 49.095 | 49.095 | 3200.0 |
| 2001-06-22 14:30:00 | IWM | ETF | 49.1 | 49.1 | 49.07 | 49.1 | 2200.0 |
| 2001-06-22 15:00:00 | IWM | ETF | 49.095 | 49.095 | 48.5 | 48.565 | 72200.0 |
| 2001-06-22 15:30:00 | IWM | ETF | 48.565 | 48.76 | 48.55 | 48.6 | 243400.0 |
| 2001-06-22 16:00:00 | IWM | ETF | 48.565 | 48.65 | 48.565 | 48.6 | 5800.0 |
| 2001-06-22 09:30:00 | DIA | ETF | 106.95 | 106.95 | 106.48 | 106.72 | 291500.0 |
| 2001-06-22 10:00:00 | DIA | ETF | 106.75 | 106.8 | 106.48 | 106.73 | 136500.0 |
> showing 50 of 368 rows — these rows as CSV