PREVIEW / etf_30min / 2004-10-22
file: by_date/etf_30min/2004/2004-10-22.parquet size: 39 KB rows: 1,260
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-10-22 08:00:00 | SPY | ETF | 111.12 | 111.19 | 111.1 | 111.19 | 43600.0 |
| 2004-10-22 08:30:00 | SPY | ETF | 111.16 | 111.36 | 111.15 | 111.35 | 39600.0 |
| 2004-10-22 09:00:00 | SPY | ETF | 111.3 | 111.31 | 111.15 | 111.15 | 86200.0 |
| 2004-10-22 09:30:00 | SPY | ETF | 111.19 | 111.24 | 110.96 | 111.14 | 4011300.0 |
| 2004-10-22 10:00:00 | SPY | ETF | 111.15 | 111.25 | 110.81 | 110.94 | 3679600.0 |
| 2004-10-22 10:30:00 | SPY | ETF | 110.93 | 111.0 | 110.69 | 110.86 | 3818600.0 |
| 2004-10-22 11:00:00 | SPY | ETF | 110.85 | 110.93 | 110.65 | 110.67 | 1870000.0 |
| 2004-10-22 11:30:00 | SPY | ETF | 110.68 | 110.88 | 110.65 | 110.75 | 1914600.0 |
| 2004-10-22 12:00:00 | SPY | ETF | 110.75 | 111.01 | 110.72 | 110.97 | 2091600.0 |
| 2004-10-22 12:30:00 | SPY | ETF | 110.96 | 111.01 | 110.78 | 110.79 | 1424000.0 |
| 2004-10-22 13:00:00 | SPY | ETF | 110.79 | 110.85 | 110.45 | 110.5284 | 2272300.0 |
| 2004-10-22 13:30:00 | SPY | ETF | 110.53 | 110.53 | 110.21 | 110.34 | 3259200.0 |
| 2004-10-22 14:00:00 | SPY | ETF | 110.33 | 110.52 | 110.24 | 110.5 | 2879200.0 |
| 2004-10-22 14:30:00 | SPY | ETF | 110.5 | 110.55 | 109.94 | 110.01 | 3944700.0 |
| 2004-10-22 15:00:00 | SPY | ETF | 110.0 | 110.14 | 109.9 | 110.08 | 4883800.0 |
| 2004-10-22 15:30:00 | SPY | ETF | 110.08 | 110.24 | 109.86 | 109.95 | 6076100.0 |
| 2004-10-22 16:00:00 | SPY | ETF | 109.93 | 110.03 | 109.88 | 109.9 | 3085200.0 |
| 2004-10-22 16:30:00 | SPY | ETF | 109.99 | 110.01 | 109.95 | 110.01 | 33400.0 |
| 2004-10-22 17:00:00 | SPY | ETF | 110.02 | 110.08 | 109.97 | 110.06 | 7600.0 |
| 2004-10-22 17:30:00 | SPY | ETF | 110.06 | 110.06 | 110.06 | 110.06 | 900.0 |
| 2004-10-22 18:00:00 | SPY | ETF | 110.08 | 110.1 | 110.08 | 110.1 | 1000.0 |
| 2004-10-22 19:00:00 | SPY | ETF | 110.1 | 110.15 | 110.1 | 110.15 | 600.0 |
| 2004-10-22 19:30:00 | SPY | ETF | 110.0 | 110.0 | 110.0 | 110.0 | 100.0 |
| 2004-10-22 08:00:00 | QQQ | ETF | 36.6 | 36.66 | 36.6 | 36.66 | 304600.0 |
| 2004-10-22 08:30:00 | QQQ | ETF | 36.66 | 36.76 | 36.65 | 36.72 | 343800.0 |
| 2004-10-22 09:00:00 | QQQ | ETF | 36.72 | 36.72 | 36.6 | 36.6 | 234600.0 |
| 2004-10-22 09:30:00 | QQQ | ETF | 36.61 | 36.65 | 36.42 | 36.501 | 14392500.0 |
| 2004-10-22 10:00:00 | QQQ | ETF | 36.51 | 36.55 | 36.34 | 36.362 | 10856300.0 |
| 2004-10-22 10:30:00 | QQQ | ETF | 36.37 | 36.39 | 36.301 | 36.34 | 6556000.0 |
| 2004-10-22 11:00:00 | QQQ | ETF | 36.346 | 36.38 | 36.21 | 36.23 | 5130900.0 |
| 2004-10-22 11:30:00 | QQQ | ETF | 36.22 | 36.3 | 36.22 | 36.25 | 3960200.0 |
| 2004-10-22 12:00:00 | QQQ | ETF | 36.25 | 36.33 | 36.225 | 36.3 | 3131000.0 |
| 2004-10-22 12:30:00 | QQQ | ETF | 36.3 | 36.36 | 36.229 | 36.23 | 4825800.0 |
| 2004-10-22 13:00:00 | QQQ | ETF | 36.23 | 36.25 | 36.07 | 36.12 | 6452700.0 |
| 2004-10-22 13:30:00 | QQQ | ETF | 36.12 | 36.13 | 36.0 | 36.047 | 9610900.0 |
| 2004-10-22 14:00:00 | QQQ | ETF | 36.047 | 36.07 | 35.91 | 36.01 | 8010700.0 |
| 2004-10-22 14:30:00 | QQQ | ETF | 36.011 | 36.03 | 35.792 | 35.82 | 10011300.0 |
| 2004-10-22 15:00:00 | QQQ | ETF | 35.82 | 35.89 | 35.76 | 35.82 | 11146200.0 |
| 2004-10-22 15:30:00 | QQQ | ETF | 35.82 | 35.9 | 35.74 | 35.79 | 12742600.0 |
| 2004-10-22 16:00:00 | QQQ | ETF | 35.78 | 35.83 | 35.75 | 35.75 | 3760900.0 |
| 2004-10-22 16:30:00 | QQQ | ETF | 35.77 | 35.8 | 35.75 | 35.76 | 1053400.0 |
| 2004-10-22 17:00:00 | QQQ | ETF | 35.76 | 35.76 | 35.73 | 35.76 | 35100.0 |
| 2004-10-22 17:30:00 | QQQ | ETF | 35.76 | 35.76 | 35.72 | 35.74 | 23400.0 |
| 2004-10-22 18:00:00 | QQQ | ETF | 35.77 | 35.79 | 35.76 | 35.79 | 13600.0 |
| 2004-10-22 18:30:00 | QQQ | ETF | 35.78 | 35.78 | 35.76 | 35.76 | 300.0 |
| 2004-10-22 19:00:00 | QQQ | ETF | 35.8 | 35.8 | 35.75 | 35.75 | 6900.0 |
| 2004-10-22 19:30:00 | QQQ | ETF | 35.79 | 35.79 | 35.79 | 35.79 | 2000.0 |
| 2004-10-22 08:00:00 | IWM | ETF | 57.6 | 57.61 | 57.6 | 57.61 | 4000.0 |
| 2004-10-22 09:30:00 | IWM | ETF | 57.475 | 57.645 | 57.35 | 57.56 | 1835600.0 |
| 2004-10-22 10:00:00 | IWM | ETF | 57.57 | 57.65 | 57.43 | 57.535 | 887600.0 |
> showing 50 of 1,260 rows — these rows as CSV