PREVIEW / etf_30min / 2004-04-23
file: by_date/etf_30min/2004/2004-04-23.parquet size: 35 KB rows: 1,167
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-04-23 08:00:00 | SPY | ETF | 114.5 | 114.63 | 114.5 | 114.55 | 12100.0 |
| 2004-04-23 08:30:00 | SPY | ETF | 114.63 | 114.63 | 114.3 | 114.38 | 80900.0 |
| 2004-04-23 09:00:00 | SPY | ETF | 114.39 | 114.48 | 114.36 | 114.42 | 30900.0 |
| 2004-04-23 09:30:00 | SPY | ETF | 114.41 | 114.44 | 114.0 | 114.22 | 4296100.0 |
| 2004-04-23 10:00:00 | SPY | ETF | 114.22 | 114.26 | 113.99 | 114.1 | 1967800.0 |
| 2004-04-23 10:30:00 | SPY | ETF | 114.09 | 114.16 | 113.95 | 114.16 | 2591500.0 |
| 2004-04-23 11:00:00 | SPY | ETF | 114.13 | 114.21 | 113.93 | 113.93 | 1256300.0 |
| 2004-04-23 11:30:00 | SPY | ETF | 113.95 | 113.99 | 113.83 | 113.94 | 1972200.0 |
| 2004-04-23 12:00:00 | SPY | ETF | 113.94 | 114.14 | 113.79 | 114.06 | 1307200.0 |
| 2004-04-23 12:30:00 | SPY | ETF | 114.05 | 114.266 | 113.99 | 114.21 | 1365500.0 |
| 2004-04-23 13:00:00 | SPY | ETF | 114.21 | 114.24 | 114.01 | 114.24 | 1395100.0 |
| 2004-04-23 13:30:00 | SPY | ETF | 114.24 | 114.38 | 114.17 | 114.28 | 833700.0 |
| 2004-04-23 14:00:00 | SPY | ETF | 114.27 | 114.5 | 114.07 | 114.5 | 1015300.0 |
| 2004-04-23 14:30:00 | SPY | ETF | 114.47 | 114.57 | 114.33 | 114.5 | 2618700.0 |
| 2004-04-23 15:00:00 | SPY | ETF | 114.5 | 114.52 | 114.28 | 114.48 | 1904900.0 |
| 2004-04-23 15:30:00 | SPY | ETF | 114.47 | 114.55 | 114.3 | 114.44 | 2359000.0 |
| 2004-04-23 16:00:00 | SPY | ETF | 114.39 | 114.53 | 114.33 | 114.35 | 1508000.0 |
| 2004-04-23 16:30:00 | SPY | ETF | 114.38 | 114.42 | 114.38 | 114.38 | 28000.0 |
| 2004-04-23 17:00:00 | SPY | ETF | 114.33 | 114.34 | 114.3 | 114.3 | 4200.0 |
| 2004-04-23 17:30:00 | SPY | ETF | 114.42 | 114.42 | 114.3 | 114.3 | 24700.0 |
| 2004-04-23 18:30:00 | SPY | ETF | 114.31 | 114.4 | 114.3 | 114.4 | 2100.0 |
| 2004-04-23 08:00:00 | QQQ | ETF | 37.15 | 37.19 | 37.14 | 37.17 | 126700.0 |
| 2004-04-23 08:30:00 | QQQ | ETF | 37.18 | 37.19 | 37.05 | 37.1 | 251400.0 |
| 2004-04-23 09:00:00 | QQQ | ETF | 37.09 | 37.11 | 37.07 | 37.09 | 185300.0 |
| 2004-04-23 09:30:00 | QQQ | ETF | 37.08 | 37.21 | 36.95 | 37.17 | 18781800.0 |
| 2004-04-23 10:00:00 | QQQ | ETF | 37.164 | 37.23 | 37.059 | 37.09 | 11567800.0 |
| 2004-04-23 10:30:00 | QQQ | ETF | 37.09 | 37.1 | 36.95 | 37.05 | 7601100.0 |
| 2004-04-23 11:00:00 | QQQ | ETF | 37.049 | 37.1 | 36.95 | 36.96 | 5270100.0 |
| 2004-04-23 11:30:00 | QQQ | ETF | 36.95 | 36.97 | 36.9 | 36.96 | 6174100.0 |
| 2004-04-23 12:00:00 | QQQ | ETF | 36.95 | 37.06 | 36.91 | 37.023 | 3774600.0 |
| 2004-04-23 12:30:00 | QQQ | ETF | 37.03 | 37.12 | 37.0 | 37.086 | 2868700.0 |
| 2004-04-23 13:00:00 | QQQ | ETF | 37.088 | 37.1 | 37.0 | 37.09 | 3009600.0 |
| 2004-04-23 13:30:00 | QQQ | ETF | 37.083 | 37.144 | 37.04 | 37.1 | 3542900.0 |
| 2004-04-23 14:00:00 | QQQ | ETF | 37.1 | 37.18 | 37.01 | 37.17 | 5273900.0 |
| 2004-04-23 14:30:00 | QQQ | ETF | 37.17 | 37.2 | 37.11 | 37.17 | 4556900.0 |
| 2004-04-23 15:00:00 | QQQ | ETF | 37.172 | 37.18 | 37.08 | 37.16 | 4476800.0 |
| 2004-04-23 15:30:00 | QQQ | ETF | 37.15 | 37.22 | 37.08 | 37.205 | 8903700.0 |
| 2004-04-23 16:00:00 | QQQ | ETF | 37.2 | 37.26 | 37.15 | 37.22 | 2730700.0 |
| 2004-04-23 16:30:00 | QQQ | ETF | 37.23 | 37.24 | 37.19 | 37.19 | 202000.0 |
| 2004-04-23 17:00:00 | QQQ | ETF | 37.1 | 37.21 | 37.1 | 37.2 | 61700.0 |
| 2004-04-23 17:30:00 | QQQ | ETF | 37.2 | 37.21 | 37.13 | 37.17 | 152100.0 |
| 2004-04-23 18:00:00 | QQQ | ETF | 37.17 | 37.21 | 37.13 | 37.16 | 80200.0 |
| 2004-04-23 18:30:00 | QQQ | ETF | 37.16 | 37.19 | 37.16 | 37.19 | 2400.0 |
| 2004-04-23 19:00:00 | QQQ | ETF | 37.18 | 37.18 | 37.17 | 37.18 | 8500.0 |
| 2004-04-23 19:30:00 | QQQ | ETF | 37.18 | 37.2 | 37.18 | 37.19 | 19700.0 |
| 2004-04-23 08:30:00 | IWM | ETF | 59.2 | 59.2 | 59.13 | 59.13 | 4000.0 |
| 2004-04-23 09:30:00 | IWM | ETF | 59.245 | 59.28 | 58.915 | 59.06 | 1216000.0 |
| 2004-04-23 10:00:00 | IWM | ETF | 59.05 | 59.075 | 58.675 | 58.765 | 1352200.0 |
| 2004-04-23 10:30:00 | IWM | ETF | 58.77 | 58.82 | 58.67 | 58.75 | 568600.0 |
| 2004-04-23 11:00:00 | IWM | ETF | 58.77 | 58.835 | 58.455 | 58.47 | 569600.0 |
> showing 50 of 1,167 rows — these rows as CSV