PREVIEW / etf_30min / 2004-04-19
file: by_date/etf_30min/2004/2004-04-19.parquet size: 34 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-04-19 08:00:00 | SPY | ETF | 113.63 | 113.63 | 113.43 | 113.46 | 42900.0 |
| 2004-04-19 08:30:00 | SPY | ETF | 113.5 | 113.58 | 113.5 | 113.58 | 41100.0 |
| 2004-04-19 09:00:00 | SPY | ETF | 113.6 | 113.69 | 113.54 | 113.55 | 38300.0 |
| 2004-04-19 09:30:00 | SPY | ETF | 113.55 | 113.84 | 113.4 | 113.55 | 4155500.0 |
| 2004-04-19 10:00:00 | SPY | ETF | 113.53 | 113.63 | 113.27 | 113.51 | 2852800.0 |
| 2004-04-19 10:30:00 | SPY | ETF | 113.52 | 113.56 | 113.32 | 113.48 | 1336200.0 |
| 2004-04-19 11:00:00 | SPY | ETF | 113.48 | 113.72 | 113.38 | 113.68 | 1913100.0 |
| 2004-04-19 11:30:00 | SPY | ETF | 113.67 | 113.78 | 113.55 | 113.73 | 1511700.0 |
| 2004-04-19 12:00:00 | SPY | ETF | 113.72 | 113.79 | 113.61 | 113.7 | 2935700.0 |
| 2004-04-19 12:30:00 | SPY | ETF | 113.69 | 113.77 | 113.65 | 113.7 | 595700.0 |
| 2004-04-19 13:00:00 | SPY | ETF | 113.7 | 113.73 | 113.45 | 113.54 | 1866400.0 |
| 2004-04-19 13:30:00 | SPY | ETF | 113.54 | 113.67 | 113.49 | 113.59 | 1012600.0 |
| 2004-04-19 14:00:00 | SPY | ETF | 113.6 | 113.63 | 113.43 | 113.51 | 1166300.0 |
| 2004-04-19 14:30:00 | SPY | ETF | 113.51 | 113.73 | 113.44 | 113.69 | 1202700.0 |
| 2004-04-19 15:00:00 | SPY | ETF | 113.7 | 113.95 | 113.66 | 113.93 | 2186400.0 |
| 2004-04-19 15:30:00 | SPY | ETF | 113.89 | 113.99 | 113.77 | 113.88 | 1652500.0 |
| 2004-04-19 16:00:00 | SPY | ETF | 113.88 | 113.9 | 113.75 | 113.8 | 968100.0 |
| 2004-04-19 16:30:00 | SPY | ETF | 113.92 | 113.92 | 113.74 | 113.77 | 55000.0 |
| 2004-04-19 17:00:00 | SPY | ETF | 113.77 | 113.77 | 113.72 | 113.73 | 1100.0 |
| 2004-04-19 18:00:00 | SPY | ETF | 113.74 | 113.74 | 113.74 | 113.74 | 200.0 |
| 2004-04-19 18:30:00 | SPY | ETF | 113.71 | 113.71 | 113.71 | 113.71 | 200.0 |
| 2004-04-19 08:00:00 | QQQ | ETF | 36.05 | 36.05 | 35.93 | 35.94 | 76700.0 |
| 2004-04-19 08:30:00 | QQQ | ETF | 35.95 | 36.01 | 35.95 | 36.0 | 186500.0 |
| 2004-04-19 09:00:00 | QQQ | ETF | 36.0 | 36.05 | 35.99 | 36.02 | 56300.0 |
| 2004-04-19 09:30:00 | QQQ | ETF | 36.01 | 36.19 | 35.99 | 36.1 | 10657000.0 |
| 2004-04-19 10:00:00 | QQQ | ETF | 36.1 | 36.18 | 35.98 | 36.11 | 9796000.0 |
| 2004-04-19 10:30:00 | QQQ | ETF | 36.12 | 36.16 | 36.04 | 36.121 | 3659000.0 |
| 2004-04-19 11:00:00 | QQQ | ETF | 36.121 | 36.29 | 36.1 | 36.26 | 6629200.0 |
| 2004-04-19 11:30:00 | QQQ | ETF | 36.27 | 36.341 | 36.2 | 36.341 | 4960700.0 |
| 2004-04-19 12:00:00 | QQQ | ETF | 36.34 | 36.391 | 36.284 | 36.31 | 5816200.0 |
| 2004-04-19 12:30:00 | QQQ | ETF | 36.314 | 36.38 | 36.3 | 36.34 | 2473900.0 |
| 2004-04-19 13:00:00 | QQQ | ETF | 36.33 | 36.36 | 36.26 | 36.295 | 2734300.0 |
| 2004-04-19 13:30:00 | QQQ | ETF | 36.293 | 36.35 | 36.26 | 36.33 | 2741300.0 |
| 2004-04-19 14:00:00 | QQQ | ETF | 36.328 | 36.36 | 36.23 | 36.29 | 3878100.0 |
| 2004-04-19 14:30:00 | QQQ | ETF | 36.29 | 36.43 | 36.27 | 36.41 | 4496900.0 |
| 2004-04-19 15:00:00 | QQQ | ETF | 36.4 | 36.52 | 36.39 | 36.51 | 8024000.0 |
| 2004-04-19 15:30:00 | QQQ | ETF | 36.5 | 36.58 | 36.48 | 36.57 | 11273700.0 |
| 2004-04-19 16:00:00 | QQQ | ETF | 36.564 | 36.59 | 36.51 | 36.56 | 2813800.0 |
| 2004-04-19 16:30:00 | QQQ | ETF | 36.54 | 36.62 | 36.52 | 36.534 | 1097000.0 |
| 2004-04-19 17:00:00 | QQQ | ETF | 36.534 | 36.54 | 36.5 | 36.5 | 349800.0 |
| 2004-04-19 17:30:00 | QQQ | ETF | 36.5 | 36.51 | 36.49 | 36.5 | 27100.0 |
| 2004-04-19 18:00:00 | QQQ | ETF | 36.51 | 36.52 | 36.49 | 36.52 | 37800.0 |
| 2004-04-19 18:30:00 | QQQ | ETF | 36.52 | 36.53 | 36.51 | 36.51 | 4100.0 |
| 2004-04-19 19:00:00 | QQQ | ETF | 36.51 | 36.52 | 36.5 | 36.52 | 1000.0 |
| 2004-04-19 19:30:00 | QQQ | ETF | 36.5 | 36.53 | 36.5 | 36.53 | 4000.0 |
| 2004-04-19 08:00:00 | IWM | ETF | 57.99 | 57.99 | 57.99 | 57.99 | 2000.0 |
| 2004-04-19 09:00:00 | IWM | ETF | 58.05 | 58.05 | 58.05 | 58.05 | 2000.0 |
| 2004-04-19 09:30:00 | IWM | ETF | 58.015 | 58.24 | 57.75 | 57.92 | 859600.0 |
| 2004-04-19 10:00:00 | IWM | ETF | 57.91 | 57.91 | 57.585 | 57.755 | 1815800.0 |
| 2004-04-19 10:30:00 | IWM | ETF | 57.755 | 57.805 | 57.625 | 57.775 | 345800.0 |
> showing 50 of 1,145 rows — these rows as CSV