PREVIEW / etf_30min / 2004-06-25
file: by_date/etf_30min/2004/2004-06-25.parquet size: 35 KB rows: 1,145
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-06-25 08:00:00 | SPY | ETF | 114.52 | 114.53 | 114.45 | 114.47 | 11100.0 |
| 2004-06-25 08:30:00 | SPY | ETF | 114.48 | 114.48 | 114.36 | 114.39 | 221200.0 |
| 2004-06-25 09:00:00 | SPY | ETF | 114.39 | 114.4 | 114.35 | 114.38 | 48600.0 |
| 2004-06-25 09:30:00 | SPY | ETF | 114.41 | 114.7 | 114.32 | 114.65 | 4845900.0 |
| 2004-06-25 10:00:00 | SPY | ETF | 114.66 | 114.8 | 114.5 | 114.74 | 3200100.0 |
| 2004-06-25 10:30:00 | SPY | ETF | 114.74 | 114.94 | 114.7 | 114.74 | 2439200.0 |
| 2004-06-25 11:00:00 | SPY | ETF | 114.74 | 114.78 | 114.65 | 114.74 | 1772700.0 |
| 2004-06-25 11:30:00 | SPY | ETF | 114.76 | 114.82 | 114.5 | 114.54 | 1061700.0 |
| 2004-06-25 12:00:00 | SPY | ETF | 114.55 | 114.58 | 114.33 | 114.37 | 1398400.0 |
| 2004-06-25 12:30:00 | SPY | ETF | 114.38 | 114.53 | 114.35 | 114.48 | 1185100.0 |
| 2004-06-25 13:00:00 | SPY | ETF | 114.47 | 114.58 | 114.36 | 114.44 | 1146000.0 |
| 2004-06-25 13:30:00 | SPY | ETF | 114.43 | 114.55 | 114.36 | 114.4 | 823800.0 |
| 2004-06-25 14:00:00 | SPY | ETF | 114.39 | 114.42 | 113.95 | 114.05 | 3550600.0 |
| 2004-06-25 14:30:00 | SPY | ETF | 114.05 | 114.18 | 113.95 | 114.02 | 2138800.0 |
| 2004-06-25 15:00:00 | SPY | ETF | 114.02 | 114.23 | 113.97 | 114.06 | 1477300.0 |
| 2004-06-25 15:30:00 | SPY | ETF | 114.06 | 114.22 | 114.04 | 114.13 | 1913400.0 |
| 2004-06-25 16:00:00 | SPY | ETF | 114.13 | 114.14 | 113.68 | 113.89 | 3021700.0 |
| 2004-06-25 16:30:00 | SPY | ETF | 113.88 | 114.178 | 113.86 | 114.01 | 1453900.0 |
| 2004-06-25 17:00:00 | SPY | ETF | 113.95 | 114.02 | 113.9 | 113.97 | 120400.0 |
| 2004-06-25 17:30:00 | SPY | ETF | 113.98 | 114.0 | 113.97 | 114.0 | 31500.0 |
| 2004-06-25 18:00:00 | SPY | ETF | 114.0 | 114.03 | 113.97 | 113.97 | 1900.0 |
| 2004-06-25 18:30:00 | SPY | ETF | 113.96 | 113.96 | 113.96 | 113.96 | 1100.0 |
| 2004-06-25 19:00:00 | SPY | ETF | 113.96 | 113.99 | 113.96 | 113.99 | 300.0 |
| 2004-06-25 19:30:00 | SPY | ETF | 113.96 | 113.96 | 113.96 | 113.96 | 400.0 |
| 2004-06-25 08:00:00 | QQQ | ETF | 37.12 | 37.12 | 37.1 | 37.11 | 42800.0 |
| 2004-06-25 08:30:00 | QQQ | ETF | 37.1 | 37.1 | 37.0 | 37.0 | 124800.0 |
| 2004-06-25 09:00:00 | QQQ | ETF | 37.02 | 37.02 | 36.99 | 36.99 | 74500.0 |
| 2004-06-25 09:30:00 | QQQ | ETF | 37.0 | 37.25 | 36.98 | 37.22 | 10411100.0 |
| 2004-06-25 10:00:00 | QQQ | ETF | 37.2 | 37.32 | 37.15 | 37.28 | 8291800.0 |
| 2004-06-25 10:30:00 | QQQ | ETF | 37.28 | 37.39 | 37.28 | 37.31 | 7311600.0 |
| 2004-06-25 11:00:00 | QQQ | ETF | 37.32 | 37.373 | 37.27 | 37.35 | 4531200.0 |
| 2004-06-25 11:30:00 | QQQ | ETF | 37.35 | 37.39 | 37.21 | 37.26 | 4870100.0 |
| 2004-06-25 12:00:00 | QQQ | ETF | 37.26 | 37.28 | 37.18 | 37.21 | 4812700.0 |
| 2004-06-25 12:30:00 | QQQ | ETF | 37.201 | 37.28 | 37.18 | 37.244 | 2116000.0 |
| 2004-06-25 13:00:00 | QQQ | ETF | 37.25 | 37.3 | 37.21 | 37.251 | 2212600.0 |
| 2004-06-25 13:30:00 | QQQ | ETF | 37.25 | 37.3 | 37.2 | 37.209 | 2140100.0 |
| 2004-06-25 14:00:00 | QQQ | ETF | 37.2 | 37.21 | 37.0 | 37.06 | 10147000.0 |
| 2004-06-25 14:30:00 | QQQ | ETF | 37.06 | 37.112 | 36.98 | 37.065 | 6515300.0 |
| 2004-06-25 15:00:00 | QQQ | ETF | 37.07 | 37.16 | 37.05 | 37.13 | 3499900.0 |
| 2004-06-25 15:30:00 | QQQ | ETF | 37.12 | 37.28 | 37.12 | 37.24 | 6870500.0 |
| 2004-06-25 16:00:00 | QQQ | ETF | 37.24 | 37.342 | 37.21 | 37.25 | 4393200.0 |
| 2004-06-25 16:30:00 | QQQ | ETF | 37.26 | 37.28 | 37.19 | 37.25 | 1215400.0 |
| 2004-06-25 17:00:00 | QQQ | ETF | 37.25 | 37.3 | 37.22 | 37.3 | 131800.0 |
| 2004-06-25 17:30:00 | QQQ | ETF | 37.3 | 37.31 | 37.26 | 37.26 | 19800.0 |
| 2004-06-25 18:00:00 | QQQ | ETF | 37.29 | 37.29 | 37.26 | 37.28 | 5600.0 |
| 2004-06-25 18:30:00 | QQQ | ETF | 37.28 | 37.28 | 37.28 | 37.28 | 300.0 |
| 2004-06-25 19:00:00 | QQQ | ETF | 37.28 | 37.28 | 37.28 | 37.28 | 400.0 |
| 2004-06-25 19:30:00 | QQQ | ETF | 37.3 | 37.3 | 37.3 | 37.3 | 1000.0 |
| 2004-06-25 09:00:00 | IWM | ETF | 57.59 | 57.59 | 57.59 | 57.59 | 400.0 |
| 2004-06-25 09:30:00 | IWM | ETF | 57.365 | 58.05 | 57.365 | 57.975 | 1210000.0 |
> showing 50 of 1,145 rows — these rows as CSV