PREVIEW / etf_30min / 2004-01-16
file: by_date/etf_30min/2004/2004-01-16.parquet size: 34 KB rows: 1,160
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-01-16 08:00:00 | SPY | ETF | 113.97 | 113.97 | 113.91 | 113.96 | 7300.0 |
| 2004-01-16 08:30:00 | SPY | ETF | 114.0 | 114.17 | 114.0 | 114.14 | 15200.0 |
| 2004-01-16 09:00:00 | SPY | ETF | 114.12 | 114.16 | 114.03 | 114.04 | 48700.0 |
| 2004-01-16 09:30:00 | SPY | ETF | 114.02 | 114.19 | 113.78 | 113.8 | 5193400.0 |
| 2004-01-16 10:00:00 | SPY | ETF | 113.8 | 113.98 | 113.66 | 113.97 | 3397400.0 |
| 2004-01-16 10:30:00 | SPY | ETF | 113.98 | 114.12 | 113.63 | 113.75 | 3742200.0 |
| 2004-01-16 11:00:00 | SPY | ETF | 113.76 | 113.96 | 113.75 | 113.9 | 813400.0 |
| 2004-01-16 11:30:00 | SPY | ETF | 113.9 | 113.96 | 113.66 | 113.93 | 2651100.0 |
| 2004-01-16 12:00:00 | SPY | ETF | 113.93 | 113.98 | 113.83 | 113.96 | 843600.0 |
| 2004-01-16 12:30:00 | SPY | ETF | 113.95 | 114.04 | 113.9 | 114.01 | 662300.0 |
| 2004-01-16 13:00:00 | SPY | ETF | 113.99 | 114.11 | 113.93 | 113.95 | 1394700.0 |
| 2004-01-16 13:30:00 | SPY | ETF | 113.97 | 114.1 | 113.91 | 114.01 | 870600.0 |
| 2004-01-16 14:00:00 | SPY | ETF | 114.01 | 114.31 | 114.0 | 114.25 | 1521000.0 |
| 2004-01-16 14:30:00 | SPY | ETF | 114.26 | 114.28 | 113.87 | 114.04 | 1611300.0 |
| 2004-01-16 15:00:00 | SPY | ETF | 114.04 | 114.25 | 114.01 | 114.15 | 1237000.0 |
| 2004-01-16 15:30:00 | SPY | ETF | 114.14 | 114.27 | 114.07 | 114.25 | 1936700.0 |
| 2004-01-16 16:00:00 | SPY | ETF | 114.24 | 114.31 | 114.18 | 114.3 | 1046800.0 |
| 2004-01-16 16:30:00 | SPY | ETF | 114.23 | 114.28 | 114.04 | 114.04 | 1115100.0 |
| 2004-01-16 17:00:00 | SPY | ETF | 114.05 | 114.16 | 113.92 | 114.16 | 16300.0 |
| 2004-01-16 17:30:00 | SPY | ETF | 114.14 | 114.15 | 114.14 | 114.15 | 1000.0 |
| 2004-01-16 18:00:00 | SPY | ETF | 114.14 | 114.14 | 114.14 | 114.14 | 2100.0 |
| 2004-01-16 18:30:00 | SPY | ETF | 114.16 | 114.16 | 114.16 | 114.16 | 100.0 |
| 2004-01-16 19:00:00 | SPY | ETF | 114.11 | 114.11 | 114.11 | 114.11 | 100.0 |
| 2004-01-16 19:30:00 | SPY | ETF | 114.17 | 114.17 | 114.17 | 114.17 | 100.0 |
| 2004-01-16 08:00:00 | QQQ | ETF | 38.38 | 38.39 | 38.34 | 38.39 | 14100.0 |
| 2004-01-16 08:30:00 | QQQ | ETF | 38.38 | 38.42 | 38.38 | 38.39 | 46900.0 |
| 2004-01-16 09:00:00 | QQQ | ETF | 38.38 | 38.42 | 38.36 | 38.38 | 136500.0 |
| 2004-01-16 09:30:00 | QQQ | ETF | 38.38 | 38.47 | 38.24 | 38.24 | 12100300.0 |
| 2004-01-16 10:00:00 | QQQ | ETF | 38.24 | 38.36 | 38.18 | 38.353 | 7683800.0 |
| 2004-01-16 10:30:00 | QQQ | ETF | 38.355 | 38.446 | 38.19 | 38.27 | 6922400.0 |
| 2004-01-16 11:00:00 | QQQ | ETF | 38.28 | 38.4 | 38.26 | 38.356 | 3075200.0 |
| 2004-01-16 11:30:00 | QQQ | ETF | 38.35 | 38.39 | 38.23 | 38.36 | 3213200.0 |
| 2004-01-16 12:00:00 | QQQ | ETF | 38.35 | 38.4 | 38.307 | 38.391 | 2434100.0 |
| 2004-01-16 12:30:00 | QQQ | ETF | 38.37 | 38.44 | 38.35 | 38.4 | 2821200.0 |
| 2004-01-16 13:00:00 | QQQ | ETF | 38.39 | 38.48 | 38.35 | 38.38 | 3766400.0 |
| 2004-01-16 13:30:00 | QQQ | ETF | 38.37 | 38.44 | 38.36 | 38.42 | 2699600.0 |
| 2004-01-16 14:00:00 | QQQ | ETF | 38.43 | 38.57 | 38.42 | 38.56 | 5686800.0 |
| 2004-01-16 14:30:00 | QQQ | ETF | 38.55 | 38.56 | 38.37 | 38.45 | 6730200.0 |
| 2004-01-16 15:00:00 | QQQ | ETF | 38.45 | 38.54 | 38.41 | 38.53 | 4025100.0 |
| 2004-01-16 15:30:00 | QQQ | ETF | 38.53 | 38.63 | 38.5 | 38.57 | 8532100.0 |
| 2004-01-16 16:00:00 | QQQ | ETF | 38.57 | 38.62 | 38.523 | 38.58 | 3589100.0 |
| 2004-01-16 16:30:00 | QQQ | ETF | 38.57 | 38.64 | 38.54 | 38.56 | 1245800.0 |
| 2004-01-16 17:00:00 | QQQ | ETF | 38.56 | 38.61 | 38.55 | 38.599 | 76700.0 |
| 2004-01-16 17:30:00 | QQQ | ETF | 38.61 | 38.64 | 38.52 | 38.54 | 36600.0 |
| 2004-01-16 18:00:00 | QQQ | ETF | 38.539 | 38.59 | 38.539 | 38.56 | 7200.0 |
| 2004-01-16 18:30:00 | QQQ | ETF | 38.57 | 38.6 | 38.57 | 38.59 | 2100.0 |
| 2004-01-16 19:00:00 | QQQ | ETF | 38.59 | 38.6 | 38.53 | 38.53 | 13300.0 |
| 2004-01-16 19:30:00 | QQQ | ETF | 38.59 | 38.59 | 38.59 | 38.59 | 2600.0 |
| 2004-01-16 09:00:00 | IWM | ETF | 58.835 | 58.835 | 58.805 | 58.805 | 7200.0 |
| 2004-01-16 09:30:00 | IWM | ETF | 58.85 | 58.935 | 58.605 | 58.705 | 932200.0 |
> showing 50 of 1,160 rows — these rows as CSV