PREVIEW / etf_30min / 2004-09-02
file: by_date/etf_30min/2004/2004-09-02.parquet size: 35 KB rows: 1,163
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 |
|---|---|---|---|---|---|---|---|
| 2004-09-02 08:00:00 | SPY | ETF | 111.25 | 111.32 | 111.25 | 111.32 | 16100.0 |
| 2004-09-02 08:30:00 | SPY | ETF | 111.28 | 111.28 | 111.16 | 111.2 | 105700.0 |
| 2004-09-02 09:00:00 | SPY | ETF | 111.25 | 111.29 | 111.22 | 111.29 | 10100.0 |
| 2004-09-02 09:30:00 | SPY | ETF | 111.24 | 111.46 | 111.24 | 111.36 | 2856300.0 |
| 2004-09-02 10:00:00 | SPY | ETF | 111.36 | 111.58 | 111.36 | 111.42 | 3180900.0 |
| 2004-09-02 10:30:00 | SPY | ETF | 111.45 | 111.55 | 111.39 | 111.55 | 2209000.0 |
| 2004-09-02 11:00:00 | SPY | ETF | 111.56 | 111.6 | 111.36 | 111.37 | 1813500.0 |
| 2004-09-02 11:30:00 | SPY | ETF | 111.37 | 111.44 | 111.32 | 111.41 | 1121100.0 |
| 2004-09-02 12:00:00 | SPY | ETF | 111.4 | 111.49 | 111.35 | 111.44 | 426000.0 |
| 2004-09-02 12:30:00 | SPY | ETF | 111.44 | 111.49 | 111.41 | 111.43 | 768400.0 |
| 2004-09-02 13:00:00 | SPY | ETF | 111.43 | 111.45 | 111.39 | 111.45 | 448700.0 |
| 2004-09-02 13:30:00 | SPY | ETF | 111.45 | 111.56 | 111.44 | 111.54 | 662600.0 |
| 2004-09-02 14:00:00 | SPY | ETF | 111.55 | 111.96 | 111.51 | 111.96 | 4552500.0 |
| 2004-09-02 14:30:00 | SPY | ETF | 111.96 | 112.26 | 111.89 | 112.25 | 5441600.0 |
| 2004-09-02 15:00:00 | SPY | ETF | 112.22 | 112.66 | 112.2 | 112.45 | 7741900.0 |
| 2004-09-02 15:30:00 | SPY | ETF | 112.44 | 112.59 | 112.37 | 112.55 | 5797500.0 |
| 2004-09-02 16:00:00 | SPY | ETF | 112.52 | 112.68 | 112.05 | 112.2 | 2943400.0 |
| 2004-09-02 16:30:00 | SPY | ETF | 112.2 | 112.3 | 112.15 | 112.28 | 793800.0 |
| 2004-09-02 17:00:00 | SPY | ETF | 112.28 | 112.3 | 112.26 | 112.27 | 146300.0 |
| 2004-09-02 17:30:00 | SPY | ETF | 112.28 | 112.35 | 112.24 | 112.24 | 27900.0 |
| 2004-09-02 18:00:00 | SPY | ETF | 112.28 | 112.33 | 112.28 | 112.31 | 4700.0 |
| 2004-09-02 18:30:00 | SPY | ETF | 112.31 | 112.31 | 112.3 | 112.3 | 900.0 |
| 2004-09-02 19:00:00 | SPY | ETF | 112.27 | 112.27 | 112.27 | 112.27 | 100.0 |
| 2004-09-02 19:30:00 | SPY | ETF | 112.29 | 112.31 | 112.27 | 112.31 | 5600.0 |
| 2004-09-02 08:00:00 | QQQ | ETF | 34.25 | 34.25 | 34.2 | 34.2 | 2100.0 |
| 2004-09-02 08:30:00 | QQQ | ETF | 34.19 | 34.2 | 34.17 | 34.19 | 104600.0 |
| 2004-09-02 09:00:00 | QQQ | ETF | 34.2 | 34.21 | 34.18 | 34.19 | 114300.0 |
| 2004-09-02 09:30:00 | QQQ | ETF | 34.18 | 34.31 | 34.16 | 34.28 | 9832300.0 |
| 2004-09-02 10:00:00 | QQQ | ETF | 34.279 | 34.44 | 34.27 | 34.39 | 7993400.0 |
| 2004-09-02 10:30:00 | QQQ | ETF | 34.39 | 34.45 | 34.36 | 34.448 | 3833400.0 |
| 2004-09-02 11:00:00 | QQQ | ETF | 34.449 | 34.48 | 34.37 | 34.377 | 5986000.0 |
| 2004-09-02 11:30:00 | QQQ | ETF | 34.38 | 34.42 | 34.36 | 34.41 | 1796900.0 |
| 2004-09-02 12:00:00 | QQQ | ETF | 34.42 | 34.43 | 34.38 | 34.421 | 2012700.0 |
| 2004-09-02 12:30:00 | QQQ | ETF | 34.421 | 34.45 | 34.402 | 34.41 | 1895800.0 |
| 2004-09-02 13:00:00 | QQQ | ETF | 34.41 | 34.42 | 34.37 | 34.41 | 1334700.0 |
| 2004-09-02 13:30:00 | QQQ | ETF | 34.41 | 34.44 | 34.4 | 34.42 | 1651400.0 |
| 2004-09-02 14:00:00 | QQQ | ETF | 34.412 | 34.59 | 34.41 | 34.589 | 7418000.0 |
| 2004-09-02 14:30:00 | QQQ | ETF | 34.59 | 34.71 | 34.549 | 34.71 | 7615300.0 |
| 2004-09-02 15:00:00 | QQQ | ETF | 34.71 | 34.88 | 34.69 | 34.78 | 11366100.0 |
| 2004-09-02 15:30:00 | QQQ | ETF | 34.77 | 34.83 | 34.73 | 34.75 | 8005900.0 |
| 2004-09-02 16:00:00 | QQQ | ETF | 34.76 | 34.83 | 34.33 | 34.35 | 6332700.0 |
| 2004-09-02 16:30:00 | QQQ | ETF | 34.35 | 34.5 | 34.3 | 34.45 | 2314400.0 |
| 2004-09-02 17:00:00 | QQQ | ETF | 34.452 | 34.462 | 34.43 | 34.45 | 111300.0 |
| 2004-09-02 17:30:00 | QQQ | ETF | 34.46 | 34.47 | 34.41 | 34.42 | 72400.0 |
| 2004-09-02 18:00:00 | QQQ | ETF | 34.42 | 34.48 | 34.42 | 34.48 | 119700.0 |
| 2004-09-02 18:30:00 | QQQ | ETF | 34.48 | 34.48 | 34.46 | 34.46 | 7300.0 |
| 2004-09-02 19:00:00 | QQQ | ETF | 34.46 | 34.47 | 34.46 | 34.46 | 1800.0 |
| 2004-09-02 19:30:00 | QQQ | ETF | 34.47 | 34.49 | 34.47 | 34.49 | 12600.0 |
| 2004-09-02 08:30:00 | IWM | ETF | 55.005 | 55.005 | 55.005 | 55.005 | 1000.0 |
| 2004-09-02 09:00:00 | IWM | ETF | 55.07 | 55.08 | 55.005 | 55.02 | 6600.0 |
> showing 50 of 1,163 rows — these rows as CSV