PREVIEW / etf_30min / 2004-05-17
file: by_date/etf_30min/2004/2004-05-17.parquet size: 36 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-05-17 08:00:00 | SPY | ETF | 108.9 | 109.01 | 108.9 | 108.99 | 27800.0 |
| 2004-05-17 08:30:00 | SPY | ETF | 108.94 | 108.94 | 108.76 | 108.76 | 85600.0 |
| 2004-05-17 09:00:00 | SPY | ETF | 108.78 | 108.9 | 108.7 | 108.89 | 152400.0 |
| 2004-05-17 09:30:00 | SPY | ETF | 108.89 | 109.12 | 108.72 | 108.88 | 7243200.0 |
| 2004-05-17 10:00:00 | SPY | ETF | 108.87 | 109.11 | 108.41 | 109.1 | 8380300.0 |
| 2004-05-17 10:30:00 | SPY | ETF | 109.05 | 109.25 | 108.89 | 108.95 | 6762600.0 |
| 2004-05-17 11:00:00 | SPY | ETF | 108.97 | 109.5 | 108.8 | 109.29 | 4094100.0 |
| 2004-05-17 11:30:00 | SPY | ETF | 109.29 | 109.45 | 109.12 | 109.38 | 1939700.0 |
| 2004-05-17 12:00:00 | SPY | ETF | 109.37 | 109.48 | 109.0 | 109.14 | 2343000.0 |
| 2004-05-17 12:30:00 | SPY | ETF | 109.17 | 109.24 | 108.83 | 109.08 | 1309300.0 |
| 2004-05-17 13:00:00 | SPY | ETF | 109.07 | 109.165 | 108.92 | 108.92 | 1088700.0 |
| 2004-05-17 13:30:00 | SPY | ETF | 108.93 | 109.09 | 108.71 | 108.93 | 2621200.0 |
| 2004-05-17 14:00:00 | SPY | ETF | 108.94 | 109.31 | 108.87 | 109.26 | 2726700.0 |
| 2004-05-17 14:30:00 | SPY | ETF | 109.26 | 109.3 | 108.91 | 109.08 | 1773500.0 |
| 2004-05-17 15:00:00 | SPY | ETF | 109.08 | 109.42 | 109.03 | 109.07 | 2681100.0 |
| 2004-05-17 15:30:00 | SPY | ETF | 109.07 | 109.09 | 108.66 | 108.861 | 3766000.0 |
| 2004-05-17 16:00:00 | SPY | ETF | 108.84 | 109.15 | 108.81 | 109.11 | 2077200.0 |
| 2004-05-17 16:30:00 | SPY | ETF | 109.07 | 109.12 | 109.07 | 109.07 | 1603200.0 |
| 2004-05-17 17:00:00 | SPY | ETF | 109.08 | 109.08 | 109.05 | 109.05 | 53000.0 |
| 2004-05-17 17:30:00 | SPY | ETF | 109.05 | 109.05 | 109.05 | 109.05 | 29500.0 |
| 2004-05-17 18:00:00 | SPY | ETF | 109.07 | 109.18 | 109.06 | 109.16 | 19100.0 |
| 2004-05-17 18:30:00 | SPY | ETF | 109.2 | 109.26 | 109.2 | 109.23 | 5200.0 |
| 2004-05-17 19:00:00 | SPY | ETF | 109.13 | 109.13 | 109.12 | 109.12 | 1900.0 |
| 2004-05-17 19:30:00 | SPY | ETF | 109.12 | 109.13 | 109.11 | 109.13 | 4900.0 |
| 2004-05-17 08:00:00 | QQQ | ETF | 34.3 | 34.37 | 34.27 | 34.37 | 162700.0 |
| 2004-05-17 08:30:00 | QQQ | ETF | 34.37 | 34.38 | 34.32 | 34.35 | 623500.0 |
| 2004-05-17 09:00:00 | QQQ | ETF | 34.34 | 34.39 | 34.31 | 34.39 | 185600.0 |
| 2004-05-17 09:30:00 | QQQ | ETF | 34.38 | 34.45 | 34.24 | 34.3 | 16543100.0 |
| 2004-05-17 10:00:00 | QQQ | ETF | 34.3 | 34.4 | 34.11 | 34.38 | 27614300.0 |
| 2004-05-17 10:30:00 | QQQ | ETF | 34.385 | 34.43 | 34.23 | 34.321 | 9433800.0 |
| 2004-05-17 11:00:00 | QQQ | ETF | 34.321 | 34.615 | 34.225 | 34.54 | 13536100.0 |
| 2004-05-17 11:30:00 | QQQ | ETF | 34.54 | 34.55 | 34.41 | 34.508 | 4147300.0 |
| 2004-05-17 12:00:00 | QQQ | ETF | 34.52 | 34.564 | 34.35 | 34.39 | 7441700.0 |
| 2004-05-17 12:30:00 | QQQ | ETF | 34.39 | 34.41 | 34.28 | 34.37 | 3130500.0 |
| 2004-05-17 13:00:00 | QQQ | ETF | 34.35 | 34.43 | 34.27 | 34.27 | 3965000.0 |
| 2004-05-17 13:30:00 | QQQ | ETF | 34.27 | 34.36 | 34.19 | 34.28 | 9837400.0 |
| 2004-05-17 14:00:00 | QQQ | ETF | 34.28 | 34.5 | 34.26 | 34.47 | 12630400.0 |
| 2004-05-17 14:30:00 | QQQ | ETF | 34.477 | 34.49 | 34.31 | 34.417 | 7969800.0 |
| 2004-05-17 15:00:00 | QQQ | ETF | 34.418 | 34.54 | 34.37 | 34.41 | 7081500.0 |
| 2004-05-17 15:30:00 | QQQ | ETF | 34.41 | 34.42 | 34.25 | 34.33 | 13833500.0 |
| 2004-05-17 16:00:00 | QQQ | ETF | 34.33 | 34.46 | 34.28 | 34.41 | 3063500.0 |
| 2004-05-17 16:30:00 | QQQ | ETF | 34.43 | 34.45 | 34.412 | 34.44 | 159700.0 |
| 2004-05-17 17:00:00 | QQQ | ETF | 34.44 | 34.45 | 34.43 | 34.44 | 27400.0 |
| 2004-05-17 17:30:00 | QQQ | ETF | 34.45 | 34.47 | 34.44 | 34.45 | 17000.0 |
| 2004-05-17 18:00:00 | QQQ | ETF | 34.45 | 34.47 | 34.44 | 34.47 | 35200.0 |
| 2004-05-17 18:30:00 | QQQ | ETF | 34.47 | 34.49 | 34.47 | 34.49 | 4200.0 |
| 2004-05-17 19:00:00 | QQQ | ETF | 34.49 | 34.49 | 34.47 | 34.49 | 4200.0 |
| 2004-05-17 19:30:00 | QQQ | ETF | 34.47 | 34.48 | 34.44 | 34.48 | 9000.0 |
| 2004-05-17 08:00:00 | IWM | ETF | 53.425 | 53.425 | 53.4 | 53.42 | 10000.0 |
| 2004-05-17 08:30:00 | IWM | ETF | 53.3 | 53.3 | 53.3 | 53.3 | 1000.0 |
> showing 50 of 1,213 rows — these rows as CSV