PREVIEW / etf_30min / 2004-08-05
file: by_date/etf_30min/2004/2004-08-05.parquet size: 36 KB rows: 1,162
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-08-05 08:00:00 | SPY | ETF | 110.31 | 110.33 | 110.27 | 110.27 | 6600.0 |
| 2004-08-05 08:30:00 | SPY | ETF | 110.32 | 110.41 | 110.32 | 110.39 | 44900.0 |
| 2004-08-05 09:00:00 | SPY | ETF | 110.38 | 110.42 | 110.33 | 110.33 | 31800.0 |
| 2004-08-05 09:30:00 | SPY | ETF | 110.29 | 110.38 | 110.18 | 110.29 | 2744000.0 |
| 2004-08-05 10:00:00 | SPY | ETF | 110.29 | 110.3 | 109.9 | 110.02 | 3465800.0 |
| 2004-08-05 10:30:00 | SPY | ETF | 110.01 | 110.19 | 109.9 | 110.03 | 2288900.0 |
| 2004-08-05 11:00:00 | SPY | ETF | 110.02 | 110.11 | 109.78 | 109.81 | 2353000.0 |
| 2004-08-05 11:30:00 | SPY | ETF | 109.8 | 109.82 | 109.51 | 109.55 | 3120600.0 |
| 2004-08-05 12:00:00 | SPY | ETF | 109.56 | 109.56 | 109.16 | 109.35 | 4237400.0 |
| 2004-08-05 12:30:00 | SPY | ETF | 109.35 | 109.35 | 109.07 | 109.3 | 2469800.0 |
| 2004-08-05 13:00:00 | SPY | ETF | 109.29 | 109.43 | 109.14 | 109.2 | 2434400.0 |
| 2004-08-05 13:30:00 | SPY | ETF | 109.17 | 109.42 | 109.12 | 109.38 | 2534000.0 |
| 2004-08-05 14:00:00 | SPY | ETF | 109.38 | 109.4 | 109.13 | 109.33 | 2133800.0 |
| 2004-08-05 14:30:00 | SPY | ETF | 109.32 | 109.49 | 108.76 | 108.84 | 5615400.0 |
| 2004-08-05 15:00:00 | SPY | ETF | 108.87 | 109.19 | 108.83 | 108.93 | 4349600.0 |
| 2004-08-05 15:30:00 | SPY | ETF | 108.92 | 109.04 | 108.37 | 108.52 | 8285100.0 |
| 2004-08-05 16:00:00 | SPY | ETF | 108.51 | 108.54 | 108.27 | 108.36 | 2080200.0 |
| 2004-08-05 16:30:00 | SPY | ETF | 108.4 | 108.48 | 108.37 | 108.4 | 232500.0 |
| 2004-08-05 17:00:00 | SPY | ETF | 108.4 | 108.45 | 108.35 | 108.4 | 13600.0 |
| 2004-08-05 18:00:00 | SPY | ETF | 108.4 | 108.45 | 108.4 | 108.45 | 32300.0 |
| 2004-08-05 18:30:00 | SPY | ETF | 108.41 | 108.41 | 108.38 | 108.38 | 14400.0 |
| 2004-08-05 19:30:00 | SPY | ETF | 108.42 | 108.43 | 108.39 | 108.43 | 3000.0 |
| 2004-08-05 08:00:00 | QQQ | ETF | 34.36 | 34.39 | 34.35 | 34.35 | 50700.0 |
| 2004-08-05 08:30:00 | QQQ | ETF | 34.35 | 34.43 | 34.35 | 34.42 | 113100.0 |
| 2004-08-05 09:00:00 | QQQ | ETF | 34.41 | 34.41 | 34.36 | 34.36 | 102000.0 |
| 2004-08-05 09:30:00 | QQQ | ETF | 34.35 | 34.4 | 34.3 | 34.37 | 8099100.0 |
| 2004-08-05 10:00:00 | QQQ | ETF | 34.37 | 34.38 | 34.188 | 34.251 | 7888900.0 |
| 2004-08-05 10:30:00 | QQQ | ETF | 34.247 | 34.39 | 34.19 | 34.28 | 5424000.0 |
| 2004-08-05 11:00:00 | QQQ | ETF | 34.282 | 34.3 | 34.18 | 34.2 | 3909400.0 |
| 2004-08-05 11:30:00 | QQQ | ETF | 34.19 | 34.191 | 34.02 | 34.061 | 8443700.0 |
| 2004-08-05 12:00:00 | QQQ | ETF | 34.061 | 34.07 | 33.88 | 33.96 | 10909200.0 |
| 2004-08-05 12:30:00 | QQQ | ETF | 33.96 | 33.97 | 33.8 | 33.94 | 6479600.0 |
| 2004-08-05 13:00:00 | QQQ | ETF | 33.94 | 34.0 | 33.86 | 33.86 | 5393600.0 |
| 2004-08-05 13:30:00 | QQQ | ETF | 33.86 | 33.99 | 33.859 | 33.95 | 3942600.0 |
| 2004-08-05 14:00:00 | QQQ | ETF | 33.95 | 33.97 | 33.83 | 33.94 | 5065200.0 |
| 2004-08-05 14:30:00 | QQQ | ETF | 33.94 | 33.99 | 33.73 | 33.75 | 10354900.0 |
| 2004-08-05 15:00:00 | QQQ | ETF | 33.75 | 33.88 | 33.74 | 33.76 | 10686600.0 |
| 2004-08-05 15:30:00 | QQQ | ETF | 33.77 | 33.84 | 33.61 | 33.64 | 14613400.0 |
| 2004-08-05 16:00:00 | QQQ | ETF | 33.65 | 33.65 | 33.56 | 33.56 | 5584000.0 |
| 2004-08-05 16:30:00 | QQQ | ETF | 33.56 | 33.65 | 33.56 | 33.59 | 1021000.0 |
| 2004-08-05 17:00:00 | QQQ | ETF | 33.59 | 33.61 | 33.55 | 33.58 | 263800.0 |
| 2004-08-05 17:30:00 | QQQ | ETF | 33.57 | 33.58 | 33.57 | 33.58 | 3400.0 |
| 2004-08-05 18:00:00 | QQQ | ETF | 33.57 | 33.602 | 33.57 | 33.6 | 64600.0 |
| 2004-08-05 18:30:00 | QQQ | ETF | 33.6 | 33.62 | 33.59 | 33.6 | 26500.0 |
| 2004-08-05 19:00:00 | QQQ | ETF | 33.6 | 33.62 | 33.6 | 33.62 | 4700.0 |
| 2004-08-05 19:30:00 | QQQ | ETF | 33.61 | 33.61 | 33.6 | 33.6 | 2500.0 |
| 2004-08-05 08:30:00 | IWM | ETF | 54.15 | 54.155 | 54.125 | 54.125 | 25600.0 |
| 2004-08-05 09:00:00 | IWM | ETF | 54.125 | 54.13 | 54.055 | 54.075 | 127800.0 |
| 2004-08-05 09:30:00 | IWM | ETF | 53.99 | 54.06 | 53.8 | 53.955 | 1279800.0 |
| 2004-08-05 10:00:00 | IWM | ETF | 53.965 | 53.965 | 53.65 | 53.76 | 1413200.0 |
> showing 50 of 1,162 rows — these rows as CSV