PREVIEW / etf_30min / 2004-06-21
file: by_date/etf_30min/2004/2004-06-21.parquet size: 34 KB rows: 1,153
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-21 08:00:00 | SPY | ETF | 113.9 | 113.94 | 113.85 | 113.85 | 11600.0 |
| 2004-06-21 08:30:00 | SPY | ETF | 113.88 | 113.92 | 113.86 | 113.9 | 183400.0 |
| 2004-06-21 09:00:00 | SPY | ETF | 113.85 | 113.91 | 113.78 | 113.8 | 99200.0 |
| 2004-06-21 09:30:00 | SPY | ETF | 113.75 | 113.95 | 113.6 | 113.94 | 3378900.0 |
| 2004-06-21 10:00:00 | SPY | ETF | 113.92 | 114.14 | 113.92 | 113.96 | 3059100.0 |
| 2004-06-21 10:30:00 | SPY | ETF | 113.96 | 113.98 | 113.78 | 113.91 | 1144300.0 |
| 2004-06-21 11:00:00 | SPY | ETF | 113.9 | 113.94 | 113.74 | 113.89 | 1084300.0 |
| 2004-06-21 11:30:00 | SPY | ETF | 113.89 | 114.0 | 113.86 | 113.94 | 788000.0 |
| 2004-06-21 12:00:00 | SPY | ETF | 113.95 | 113.97 | 113.86 | 113.96 | 531000.0 |
| 2004-06-21 12:30:00 | SPY | ETF | 113.94 | 113.95 | 113.83 | 113.85 | 632700.0 |
| 2004-06-21 13:00:00 | SPY | ETF | 113.85 | 113.94 | 113.78 | 113.9 | 659000.0 |
| 2004-06-21 13:30:00 | SPY | ETF | 113.9 | 114.01 | 113.89 | 113.99 | 685300.0 |
| 2004-06-21 14:00:00 | SPY | ETF | 113.99 | 114.02 | 113.88 | 113.99 | 532900.0 |
| 2004-06-21 14:30:00 | SPY | ETF | 114.0 | 114.01 | 113.66 | 113.75 | 1095800.0 |
| 2004-06-21 15:00:00 | SPY | ETF | 113.75 | 113.84 | 113.43 | 113.46 | 2073500.0 |
| 2004-06-21 15:30:00 | SPY | ETF | 113.46 | 113.49 | 113.18 | 113.31 | 5724800.0 |
| 2004-06-21 16:00:00 | SPY | ETF | 113.31 | 113.33 | 113.12 | 113.16 | 1795200.0 |
| 2004-06-21 16:30:00 | SPY | ETF | 113.18 | 113.28 | 113.16 | 113.28 | 27500.0 |
| 2004-06-21 17:00:00 | SPY | ETF | 113.27 | 113.28 | 113.24 | 113.24 | 575900.0 |
| 2004-06-21 17:30:00 | SPY | ETF | 113.24 | 113.24 | 113.2 | 113.23 | 27800.0 |
| 2004-06-21 18:00:00 | SPY | ETF | 113.25 | 113.3 | 113.25 | 113.3 | 3200.0 |
| 2004-06-21 18:30:00 | SPY | ETF | 113.3 | 113.3 | 113.3 | 113.3 | 500.0 |
| 2004-06-21 19:00:00 | SPY | ETF | 113.3 | 113.3 | 113.2 | 113.2 | 2300.0 |
| 2004-06-21 19:30:00 | SPY | ETF | 113.29 | 113.29 | 113.29 | 113.29 | 300.0 |
| 2004-06-21 08:00:00 | QQQ | ETF | 36.56 | 36.58 | 36.53 | 36.54 | 86300.0 |
| 2004-06-21 08:30:00 | QQQ | ETF | 36.54 | 36.56 | 36.53 | 36.54 | 63700.0 |
| 2004-06-21 09:00:00 | QQQ | ETF | 36.55 | 36.55 | 36.5 | 36.5 | 155100.0 |
| 2004-06-21 09:30:00 | QQQ | ETF | 36.52 | 36.57 | 36.41 | 36.55 | 12103400.0 |
| 2004-06-21 10:00:00 | QQQ | ETF | 36.55 | 36.63 | 36.52 | 36.53 | 5676800.0 |
| 2004-06-21 10:30:00 | QQQ | ETF | 36.529 | 36.56 | 36.45 | 36.522 | 3852000.0 |
| 2004-06-21 11:00:00 | QQQ | ETF | 36.521 | 36.53 | 36.45 | 36.512 | 3304000.0 |
| 2004-06-21 11:30:00 | QQQ | ETF | 36.52 | 36.57 | 36.5 | 36.535 | 2361200.0 |
| 2004-06-21 12:00:00 | QQQ | ETF | 36.53 | 36.541 | 36.48 | 36.52 | 2199600.0 |
| 2004-06-21 12:30:00 | QQQ | ETF | 36.53 | 36.53 | 36.48 | 36.49 | 2033300.0 |
| 2004-06-21 13:00:00 | QQQ | ETF | 36.484 | 36.52 | 36.46 | 36.517 | 2030400.0 |
| 2004-06-21 13:30:00 | QQQ | ETF | 36.51 | 36.55 | 36.49 | 36.53 | 1680500.0 |
| 2004-06-21 14:00:00 | QQQ | ETF | 36.54 | 36.55 | 36.48 | 36.515 | 2220600.0 |
| 2004-06-21 14:30:00 | QQQ | ETF | 36.52 | 36.52 | 36.36 | 36.38 | 3687500.0 |
| 2004-06-21 15:00:00 | QQQ | ETF | 36.38 | 36.44 | 36.21 | 36.212 | 7079600.0 |
| 2004-06-21 15:30:00 | QQQ | ETF | 36.21 | 36.24 | 36.06 | 36.15 | 12654800.0 |
| 2004-06-21 16:00:00 | QQQ | ETF | 36.142 | 36.18 | 36.1 | 36.17 | 1330500.0 |
| 2004-06-21 16:30:00 | QQQ | ETF | 36.17 | 36.18 | 36.12 | 36.18 | 164300.0 |
| 2004-06-21 17:00:00 | QQQ | ETF | 36.18 | 36.19 | 36.15 | 36.15 | 34400.0 |
| 2004-06-21 17:30:00 | QQQ | ETF | 36.15 | 36.19 | 36.14 | 36.19 | 27800.0 |
| 2004-06-21 18:00:00 | QQQ | ETF | 36.18 | 36.19 | 36.17 | 36.17 | 43200.0 |
| 2004-06-21 19:00:00 | QQQ | ETF | 36.17 | 36.2 | 36.17 | 36.18 | 7100.0 |
| 2004-06-21 19:30:00 | QQQ | ETF | 36.19 | 36.2 | 36.18 | 36.2 | 6900.0 |
| 2004-06-21 08:00:00 | IWM | ETF | 57.05 | 57.055 | 57.05 | 57.055 | 3000.0 |
| 2004-06-21 09:30:00 | IWM | ETF | 56.93 | 57.015 | 56.65 | 56.9 | 929600.0 |
| 2004-06-21 10:00:00 | IWM | ETF | 56.895 | 57.02 | 56.86 | 56.935 | 1184800.0 |
> showing 50 of 1,153 rows — these rows as CSV