PREVIEW / etf_30min / 2003-01-08
file: by_date/etf_30min/2003/2003-01-08.parquet size: 21 KB rows: 626
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 |
|---|---|---|---|---|---|---|---|
| 2003-01-08 08:00:00 | SPY | ETF | 92.35 | 92.4 | 92.35 | 92.35 | 21000.0 |
| 2003-01-08 08:30:00 | SPY | ETF | 92.3 | 92.32 | 92.18 | 92.22 | 6400.0 |
| 2003-01-08 09:00:00 | SPY | ETF | 92.2 | 92.2 | 92.1 | 92.1 | 9800.0 |
| 2003-01-08 09:30:00 | SPY | ETF | 92.2 | 92.28 | 91.72 | 91.79 | 5007800.0 |
| 2003-01-08 10:00:00 | SPY | ETF | 91.8 | 92.12 | 91.7 | 92.1 | 2156200.0 |
| 2003-01-08 10:30:00 | SPY | ETF | 92.13 | 92.13 | 91.8 | 91.93 | 2305600.0 |
| 2003-01-08 11:00:00 | SPY | ETF | 91.94 | 92.34 | 91.87 | 92.25 | 1618700.0 |
| 2003-01-08 11:30:00 | SPY | ETF | 92.27 | 92.4 | 91.91 | 91.94 | 2217500.0 |
| 2003-01-08 12:00:00 | SPY | ETF | 91.93 | 91.97 | 91.71 | 91.74 | 2611500.0 |
| 2003-01-08 12:30:00 | SPY | ETF | 91.75 | 91.86 | 91.52 | 91.7 | 1656000.0 |
| 2003-01-08 13:00:00 | SPY | ETF | 91.7 | 91.81 | 91.52 | 91.71 | 1762500.0 |
| 2003-01-08 13:30:00 | SPY | ETF | 91.73 | 91.75 | 91.37 | 91.53 | 2174300.0 |
| 2003-01-08 14:00:00 | SPY | ETF | 91.54 | 91.64 | 91.3 | 91.53 | 2359400.0 |
| 2003-01-08 14:30:00 | SPY | ETF | 91.52 | 91.62 | 91.17 | 91.21 | 2682400.0 |
| 2003-01-08 15:00:00 | SPY | ETF | 91.2 | 91.43 | 91.1 | 91.29 | 3998600.0 |
| 2003-01-08 15:30:00 | SPY | ETF | 91.29 | 91.33 | 91.05 | 91.22 | 2894000.0 |
| 2003-01-08 16:00:00 | SPY | ETF | 91.17 | 91.42 | 91.16 | 91.39 | 1660800.0 |
| 2003-01-08 16:30:00 | SPY | ETF | 91.4 | 91.44 | 91.35 | 91.43 | 55100.0 |
| 2003-01-08 17:00:00 | SPY | ETF | 91.41 | 91.48 | 91.4 | 91.44 | 121200.0 |
| 2003-01-08 17:30:00 | SPY | ETF | 91.44 | 91.44 | 91.4 | 91.41 | 4300.0 |
| 2003-01-08 18:00:00 | SPY | ETF | 91.45 | 91.47 | 91.41 | 91.44 | 21200.0 |
| 2003-01-08 18:30:00 | SPY | ETF | 91.44 | 91.45 | 91.42 | 91.45 | 9100.0 |
| 2003-01-08 08:00:00 | QQQ | ETF | 26.51 | 26.52 | 26.46 | 26.46 | 25000.0 |
| 2003-01-08 08:30:00 | QQQ | ETF | 26.46 | 26.47 | 26.38 | 26.4 | 43900.0 |
| 2003-01-08 09:00:00 | QQQ | ETF | 26.41 | 26.41 | 26.37 | 26.39 | 23500.0 |
| 2003-01-08 09:30:00 | QQQ | ETF | 26.37 | 26.49 | 26.26 | 26.28 | 12838100.0 |
| 2003-01-08 10:00:00 | QQQ | ETF | 26.3 | 26.39 | 26.2 | 26.37 | 6226400.0 |
| 2003-01-08 10:30:00 | QQQ | ETF | 26.37 | 26.39 | 26.18 | 26.22 | 4194900.0 |
| 2003-01-08 11:00:00 | QQQ | ETF | 26.24 | 26.33 | 26.16 | 26.29 | 3377800.0 |
| 2003-01-08 11:30:00 | QQQ | ETF | 26.3 | 26.32 | 26.05 | 26.11 | 4820000.0 |
| 2003-01-08 12:00:00 | QQQ | ETF | 26.09 | 26.12 | 25.96 | 26.0 | 4986600.0 |
| 2003-01-08 12:30:00 | QQQ | ETF | 26.0 | 26.05 | 25.92 | 25.99 | 3161300.0 |
| 2003-01-08 13:00:00 | QQQ | ETF | 25.99 | 26.08 | 25.94 | 26.03 | 2971800.0 |
| 2003-01-08 13:30:00 | QQQ | ETF | 26.02 | 26.05 | 25.89 | 26.02 | 6090100.0 |
| 2003-01-08 14:00:00 | QQQ | ETF | 26.04 | 26.07 | 25.92 | 26.05 | 3454900.0 |
| 2003-01-08 14:30:00 | QQQ | ETF | 26.06 | 26.12 | 25.93 | 25.96 | 5077200.0 |
| 2003-01-08 15:00:00 | QQQ | ETF | 25.95 | 26.02 | 25.87 | 25.94 | 4663000.0 |
| 2003-01-08 15:30:00 | QQQ | ETF | 25.95 | 25.98 | 25.84 | 25.91 | 4592100.0 |
| 2003-01-08 16:00:00 | QQQ | ETF | 25.91 | 26.0 | 25.86 | 25.98 | 2589300.0 |
| 2003-01-08 16:30:00 | QQQ | ETF | 26.0 | 26.02 | 25.95 | 25.98 | 306600.0 |
| 2003-01-08 17:00:00 | QQQ | ETF | 26.0 | 26.03 | 25.98 | 26.03 | 159600.0 |
| 2003-01-08 17:30:00 | QQQ | ETF | 26.0 | 26.04 | 26.0 | 26.03 | 49900.0 |
| 2003-01-08 18:00:00 | QQQ | ETF | 26.01 | 26.03 | 25.98 | 26.02 | 40600.0 |
| 2003-01-08 18:30:00 | QQQ | ETF | 26.03 | 26.04 | 26.03 | 26.04 | 5300.0 |
| 2003-01-08 19:00:00 | QQQ | ETF | 26.05 | 26.05 | 26.03 | 26.03 | 3400.0 |
| 2003-01-08 19:30:00 | QQQ | ETF | 26.01 | 26.05 | 26.01 | 26.04 | 7200.0 |
| 2003-01-08 09:30:00 | IWM | ETF | 38.95 | 39.0 | 38.685 | 38.695 | 440600.0 |
| 2003-01-08 10:00:00 | IWM | ETF | 38.75 | 38.835 | 38.675 | 38.835 | 224000.0 |
| 2003-01-08 10:30:00 | IWM | ETF | 38.8 | 38.85 | 38.735 | 38.76 | 88600.0 |
| 2003-01-08 11:00:00 | IWM | ETF | 38.815 | 39.005 | 38.79 | 38.975 | 242400.0 |
> showing 50 of 626 rows — these rows as CSV