PREVIEW / etf_30min / 2004-09-13
file: by_date/etf_30min/2004/2004-09-13.parquet size: 35 KB rows: 1,213
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-09-13 08:00:00 | SPY | ETF | 113.3 | 113.37 | 113.22 | 113.35 | 19000.0 |
| 2004-09-13 08:30:00 | SPY | ETF | 113.35 | 113.39 | 113.3 | 113.37 | 95800.0 |
| 2004-09-13 09:00:00 | SPY | ETF | 113.35 | 113.35 | 113.29 | 113.29 | 13000.0 |
| 2004-09-13 09:30:00 | SPY | ETF | 113.28 | 113.32 | 113.09 | 113.23 | 3838600.0 |
| 2004-09-13 10:00:00 | SPY | ETF | 113.23 | 113.49 | 113.19 | 113.46 | 3800300.0 |
| 2004-09-13 10:30:00 | SPY | ETF | 113.45 | 113.49 | 113.305 | 113.47 | 5583400.0 |
| 2004-09-13 11:00:00 | SPY | ETF | 113.47 | 113.64 | 113.44 | 113.55 | 2130500.0 |
| 2004-09-13 11:30:00 | SPY | ETF | 113.55 | 113.62 | 113.49 | 113.5 | 1446400.0 |
| 2004-09-13 12:00:00 | SPY | ETF | 113.49 | 113.69 | 113.49 | 113.63 | 1931700.0 |
| 2004-09-13 12:30:00 | SPY | ETF | 113.6216 | 113.71 | 113.57 | 113.62 | 1363200.0 |
| 2004-09-13 13:00:00 | SPY | ETF | 113.61 | 113.74 | 113.54 | 113.58 | 1207300.0 |
| 2004-09-13 13:30:00 | SPY | ETF | 113.59 | 113.6 | 113.36 | 113.41 | 3151000.0 |
| 2004-09-13 14:00:00 | SPY | ETF | 113.41 | 113.56 | 113.35 | 113.44 | 1680300.0 |
| 2004-09-13 14:30:00 | SPY | ETF | 113.44 | 113.49 | 113.32 | 113.34 | 2955300.0 |
| 2004-09-13 15:00:00 | SPY | ETF | 113.34 | 113.45 | 113.16 | 113.27 | 4662100.0 |
| 2004-09-13 15:30:00 | SPY | ETF | 113.26 | 113.31 | 113.01 | 113.31 | 5016800.0 |
| 2004-09-13 16:00:00 | SPY | ETF | 113.3 | 113.5 | 113.27 | 113.43 | 3377500.0 |
| 2004-09-13 16:30:00 | SPY | ETF | 113.43 | 113.51 | 113.42 | 113.48 | 164300.0 |
| 2004-09-13 17:00:00 | SPY | ETF | 113.46 | 113.47 | 113.4008 | 113.4008 | 547200.0 |
| 2004-09-13 17:30:00 | SPY | ETF | 113.45 | 113.48 | 113.45 | 113.48 | 4600.0 |
| 2004-09-13 18:00:00 | SPY | ETF | 113.42 | 113.42 | 113.42 | 113.42 | 100.0 |
| 2004-09-13 18:30:00 | SPY | ETF | 113.42 | 113.42 | 113.42 | 113.42 | 200.0 |
| 2004-09-13 19:00:00 | SPY | ETF | 113.43 | 113.43 | 113.43 | 113.43 | 100.0 |
| 2004-09-13 19:30:00 | SPY | ETF | 113.48 | 113.48 | 113.4 | 113.4 | 1100.0 |
| 2004-09-13 08:00:00 | QQQ | ETF | 35.26 | 35.27 | 35.22 | 35.26 | 178400.0 |
| 2004-09-13 08:30:00 | QQQ | ETF | 35.26 | 35.29 | 35.25 | 35.26 | 74300.0 |
| 2004-09-13 09:00:00 | QQQ | ETF | 35.27 | 35.28 | 35.22 | 35.24 | 330800.0 |
| 2004-09-13 09:30:00 | QQQ | ETF | 35.24 | 35.33 | 35.151 | 35.281 | 13772200.0 |
| 2004-09-13 10:00:00 | QQQ | ETF | 35.281 | 35.47 | 35.23 | 35.432 | 13784000.0 |
| 2004-09-13 10:30:00 | QQQ | ETF | 35.43 | 35.54 | 35.37 | 35.52 | 8420800.0 |
| 2004-09-13 11:00:00 | QQQ | ETF | 35.51 | 35.68 | 35.51 | 35.636 | 9103700.0 |
| 2004-09-13 11:30:00 | QQQ | ETF | 35.632 | 35.68 | 35.56 | 35.576 | 4870800.0 |
| 2004-09-13 12:00:00 | QQQ | ETF | 35.576 | 35.671 | 35.57 | 35.63 | 5102600.0 |
| 2004-09-13 12:30:00 | QQQ | ETF | 35.65 | 35.7 | 35.59 | 35.68 | 3760200.0 |
| 2004-09-13 13:00:00 | QQQ | ETF | 35.67 | 35.72 | 35.6 | 35.64 | 4347500.0 |
| 2004-09-13 13:30:00 | QQQ | ETF | 35.64 | 35.65 | 35.53 | 35.535 | 7465500.0 |
| 2004-09-13 14:00:00 | QQQ | ETF | 35.53 | 35.634 | 35.52 | 35.57 | 5892800.0 |
| 2004-09-13 14:30:00 | QQQ | ETF | 35.56 | 35.59 | 35.51 | 35.51 | 5103600.0 |
| 2004-09-13 15:00:00 | QQQ | ETF | 35.51 | 35.57 | 35.4 | 35.45 | 9351700.0 |
| 2004-09-13 15:30:00 | QQQ | ETF | 35.451 | 35.46 | 35.35 | 35.44 | 10786700.0 |
| 2004-09-13 16:00:00 | QQQ | ETF | 35.44 | 35.591 | 35.4 | 35.56 | 3895000.0 |
| 2004-09-13 16:30:00 | QQQ | ETF | 35.56 | 35.59 | 35.55 | 35.57 | 156500.0 |
| 2004-09-13 17:00:00 | QQQ | ETF | 35.57 | 35.58 | 35.55 | 35.55 | 25700.0 |
| 2004-09-13 17:30:00 | QQQ | ETF | 35.56 | 35.57 | 35.55 | 35.56 | 51900.0 |
| 2004-09-13 18:00:00 | QQQ | ETF | 35.56 | 35.56 | 35.55 | 35.56 | 22700.0 |
| 2004-09-13 18:30:00 | QQQ | ETF | 35.55 | 35.55 | 35.55 | 35.55 | 500.0 |
| 2004-09-13 19:00:00 | QQQ | ETF | 35.56 | 35.56 | 35.56 | 35.56 | 5700.0 |
| 2004-09-13 19:30:00 | QQQ | ETF | 35.57 | 35.57 | 35.57 | 35.57 | 800.0 |
| 2004-09-13 08:00:00 | IWM | ETF | 56.905 | 57.0 | 56.9 | 56.98 | 14400.0 |
| 2004-09-13 08:30:00 | IWM | ETF | 56.98 | 57.025 | 56.98 | 57.025 | 5800.0 |
> showing 50 of 1,213 rows — these rows as CSV