PREVIEW / etf_30min / 2004-01-06
file: by_date/etf_30min/2004/2004-01-06.parquet size: 34 KB rows: 1,158
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-01-06 08:00:00 | SPY | ETF | 112.25 | 112.29 | 112.22 | 112.26 | 9800.0 |
| 2004-01-06 08:30:00 | SPY | ETF | 112.24 | 112.24 | 112.15 | 112.17 | 18200.0 |
| 2004-01-06 09:00:00 | SPY | ETF | 112.22 | 112.22 | 112.16 | 112.19 | 34300.0 |
| 2004-01-06 09:30:00 | SPY | ETF | 112.16 | 112.33 | 112.1 | 112.33 | 2628500.0 |
| 2004-01-06 10:00:00 | SPY | ETF | 112.31 | 112.35 | 112.1 | 112.26 | 3468200.0 |
| 2004-01-06 10:30:00 | SPY | ETF | 112.22 | 112.43 | 112.19 | 112.4 | 1531000.0 |
| 2004-01-06 11:00:00 | SPY | ETF | 112.4 | 112.46 | 112.23 | 112.27 | 1102800.0 |
| 2004-01-06 11:30:00 | SPY | ETF | 112.27 | 112.34 | 112.23 | 112.26 | 552600.0 |
| 2004-01-06 12:00:00 | SPY | ETF | 112.25 | 112.33 | 112.17 | 112.26 | 741600.0 |
| 2004-01-06 12:30:00 | SPY | ETF | 112.26 | 112.49 | 112.25 | 112.34 | 668300.0 |
| 2004-01-06 13:00:00 | SPY | ETF | 112.34 | 112.49 | 112.22 | 112.22 | 1013700.0 |
| 2004-01-06 13:30:00 | SPY | ETF | 112.23 | 112.4 | 112.22 | 112.37 | 490600.0 |
| 2004-01-06 14:00:00 | SPY | ETF | 112.38 | 112.52 | 112.28 | 112.35 | 1513800.0 |
| 2004-01-06 14:30:00 | SPY | ETF | 112.35 | 112.6 | 112.28 | 112.51 | 1218000.0 |
| 2004-01-06 15:00:00 | SPY | ETF | 112.52 | 112.67 | 112.5 | 112.6 | 1060800.0 |
| 2004-01-06 15:30:00 | SPY | ETF | 112.59 | 112.73 | 112.56 | 112.62 | 2080700.0 |
| 2004-01-06 16:00:00 | SPY | ETF | 112.63 | 112.66 | 112.3637 | 112.6 | 1786200.0 |
| 2004-01-06 16:30:00 | SPY | ETF | 112.57 | 112.6 | 112.362 | 112.6 | 96100.0 |
| 2004-01-06 17:00:00 | SPY | ETF | 112.6 | 112.6 | 112.57 | 112.58 | 7300.0 |
| 2004-01-06 17:30:00 | SPY | ETF | 112.58 | 112.62 | 112.58 | 112.62 | 10100.0 |
| 2004-01-06 18:00:00 | SPY | ETF | 112.59 | 112.59 | 112.59 | 112.59 | 16000.0 |
| 2004-01-06 18:30:00 | SPY | ETF | 112.61 | 112.61 | 112.55 | 112.55 | 2800.0 |
| 2004-01-06 19:00:00 | SPY | ETF | 112.55 | 112.6 | 112.54 | 112.6 | 2200.0 |
| 2004-01-06 19:30:00 | SPY | ETF | 112.55 | 112.55 | 112.55 | 112.55 | 200.0 |
| 2004-01-06 08:00:00 | QQQ | ETF | 37.11 | 37.13 | 37.08 | 37.08 | 30100.0 |
| 2004-01-06 08:30:00 | QQQ | ETF | 37.07 | 37.08 | 37.06 | 37.08 | 13600.0 |
| 2004-01-06 09:00:00 | QQQ | ETF | 37.08 | 37.1 | 37.05 | 37.08 | 89400.0 |
| 2004-01-06 09:30:00 | QQQ | ETF | 37.08 | 37.16 | 37.05 | 37.104 | 5595800.0 |
| 2004-01-06 10:00:00 | QQQ | ETF | 37.11 | 37.12 | 36.95 | 36.999 | 5707400.0 |
| 2004-01-06 10:30:00 | QQQ | ETF | 37.02 | 37.19 | 36.99 | 37.18 | 4118300.0 |
| 2004-01-06 11:00:00 | QQQ | ETF | 37.18 | 37.21 | 37.07 | 37.094 | 3744100.0 |
| 2004-01-06 11:30:00 | QQQ | ETF | 37.095 | 37.17 | 37.09 | 37.104 | 2437300.0 |
| 2004-01-06 12:00:00 | QQQ | ETF | 37.106 | 37.15 | 37.07 | 37.12 | 2354800.0 |
| 2004-01-06 12:30:00 | QQQ | ETF | 37.123 | 37.25 | 37.119 | 37.15 | 6271600.0 |
| 2004-01-06 13:00:00 | QQQ | ETF | 37.151 | 37.242 | 37.11 | 37.12 | 4624900.0 |
| 2004-01-06 13:30:00 | QQQ | ETF | 37.12 | 37.239 | 37.08 | 37.235 | 1931300.0 |
| 2004-01-06 14:00:00 | QQQ | ETF | 37.24 | 37.28 | 37.16 | 37.2 | 4941800.0 |
| 2004-01-06 14:30:00 | QQQ | ETF | 37.19 | 37.32 | 37.18 | 37.28 | 3494900.0 |
| 2004-01-06 15:00:00 | QQQ | ETF | 37.28 | 37.402 | 37.27 | 37.37 | 4054400.0 |
| 2004-01-06 15:30:00 | QQQ | ETF | 37.38 | 37.42 | 37.31 | 37.33 | 6162200.0 |
| 2004-01-06 16:00:00 | QQQ | ETF | 37.32 | 37.35 | 37.295 | 37.32 | 1968400.0 |
| 2004-01-06 16:30:00 | QQQ | ETF | 37.31 | 37.33 | 37.3 | 37.33 | 85000.0 |
| 2004-01-06 17:00:00 | QQQ | ETF | 37.333 | 37.333 | 37.31 | 37.31 | 20900.0 |
| 2004-01-06 17:30:00 | QQQ | ETF | 37.32 | 37.34 | 37.32 | 37.34 | 6800.0 |
| 2004-01-06 18:00:00 | QQQ | ETF | 37.34 | 37.34 | 37.33 | 37.34 | 31700.0 |
| 2004-01-06 19:00:00 | QQQ | ETF | 37.32 | 37.32 | 37.32 | 37.32 | 2800.0 |
| 2004-01-06 19:30:00 | QQQ | ETF | 37.33 | 37.34 | 37.33 | 37.34 | 3700.0 |
| 2004-01-06 09:30:00 | IWM | ETF | 56.685 | 56.8 | 56.56 | 56.71 | 797200.0 |
| 2004-01-06 10:00:00 | IWM | ETF | 56.71 | 56.715 | 56.5 | 56.68 | 518400.0 |
| 2004-01-06 10:30:00 | IWM | ETF | 56.68 | 56.95 | 56.62 | 56.95 | 950400.0 |
> showing 50 of 1,158 rows — these rows as CSV