PREVIEW / etf_30min / 2005-05-06
file: by_date/etf_30min/2005/2005-05-06.parquet size: 43 KB rows: 1,502
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 |
|---|---|---|---|---|---|---|---|
| 2005-05-06 06:00:00 | SPY | ETF | 117.6 | 117.6 | 117.6 | 117.6 | 9900.0 |
| 2005-05-06 06:30:00 | SPY | ETF | 117.59 | 117.59 | 117.59 | 117.59 | 900.0 |
| 2005-05-06 07:30:00 | SPY | ETF | 117.66 | 117.77 | 117.66 | 117.71 | 189200.0 |
| 2005-05-06 08:00:00 | SPY | ETF | 117.65 | 117.83 | 117.65 | 117.77 | 156100.0 |
| 2005-05-06 08:30:00 | SPY | ETF | 117.77 | 118.23 | 117.77 | 118.11 | 1811100.0 |
| 2005-05-06 09:00:00 | SPY | ETF | 118.12 | 118.14 | 117.93 | 117.93 | 284800.0 |
| 2005-05-06 09:30:00 | SPY | ETF | 117.93 | 117.99 | 117.62 | 117.84 | 10477500.0 |
| 2005-05-06 10:00:00 | SPY | ETF | 117.83 | 117.97 | 117.47 | 117.73 | 8580000.0 |
| 2005-05-06 10:30:00 | SPY | ETF | 117.72 | 117.87 | 117.47 | 117.72 | 4874600.0 |
| 2005-05-06 11:00:00 | SPY | ETF | 117.74 | 117.8 | 117.53 | 117.56 | 2079700.0 |
| 2005-05-06 11:30:00 | SPY | ETF | 117.53 | 117.76 | 117.37 | 117.43 | 3670000.0 |
| 2005-05-06 12:00:00 | SPY | ETF | 117.46 | 117.46 | 117.2 | 117.43 | 5624400.0 |
| 2005-05-06 12:30:00 | SPY | ETF | 117.42 | 117.43 | 117.23 | 117.36 | 2027700.0 |
| 2005-05-06 13:00:00 | SPY | ETF | 117.37 | 117.64 | 117.33 | 117.58 | 3136700.0 |
| 2005-05-06 13:30:00 | SPY | ETF | 117.58 | 117.65 | 117.43 | 117.46 | 1934600.0 |
| 2005-05-06 14:00:00 | SPY | ETF | 117.46 | 117.76 | 117.44 | 117.55 | 4084800.0 |
| 2005-05-06 14:30:00 | SPY | ETF | 117.55 | 117.71 | 117.47 | 117.54 | 1709500.0 |
| 2005-05-06 15:00:00 | SPY | ETF | 117.54 | 117.62 | 117.25 | 117.48 | 2282100.0 |
| 2005-05-06 15:30:00 | SPY | ETF | 117.48 | 117.56 | 117.12 | 117.2 | 6437500.0 |
| 2005-05-06 16:00:00 | SPY | ETF | 117.19 | 117.96 | 117.05 | 117.15 | 6343500.0 |
| 2005-05-06 16:30:00 | SPY | ETF | 117.17 | 117.3797 | 117.0 | 117.0 | 1263600.0 |
| 2005-05-06 17:00:00 | SPY | ETF | 117.01 | 117.12 | 117.01 | 117.09 | 9200.0 |
| 2005-05-06 17:30:00 | SPY | ETF | 117.09 | 117.1 | 116.95 | 116.95 | 6700.0 |
| 2005-05-06 18:00:00 | SPY | ETF | 116.98 | 117.06 | 116.93 | 117.06 | 4300.0 |
| 2005-05-06 19:30:00 | SPY | ETF | 117.03 | 117.08 | 117.03 | 117.08 | 800.0 |
| 2005-05-06 09:30:00 | QQQ | ETF | 35.97 | 36.02 | 35.88 | 35.93 | 13338000.0 |
| 2005-05-06 10:00:00 | QQQ | ETF | 35.93 | 35.99 | 35.84 | 35.94 | 11662100.0 |
| 2005-05-06 10:30:00 | QQQ | ETF | 35.94 | 35.98 | 35.83 | 35.9 | 5630000.0 |
| 2005-05-06 11:00:00 | QQQ | ETF | 35.9 | 35.92 | 35.84 | 35.84 | 3001400.0 |
| 2005-05-06 11:30:00 | QQQ | ETF | 35.84 | 35.91 | 35.79 | 35.83 | 3293000.0 |
| 2005-05-06 12:00:00 | QQQ | ETF | 35.82 | 35.83 | 35.72 | 35.8 | 4782900.0 |
| 2005-05-06 12:30:00 | QQQ | ETF | 35.8 | 35.81 | 35.75 | 35.77 | 1493600.0 |
| 2005-05-06 13:00:00 | QQQ | ETF | 35.78 | 35.86 | 35.77 | 35.85 | 2256700.0 |
| 2005-05-06 13:30:00 | QQQ | ETF | 35.85 | 35.86 | 35.82 | 35.82 | 1889200.0 |
| 2005-05-06 14:00:00 | QQQ | ETF | 35.82 | 35.93 | 35.82 | 35.86 | 8213800.0 |
| 2005-05-06 14:30:00 | QQQ | ETF | 35.85 | 35.9 | 35.83 | 35.89 | 2099100.0 |
| 2005-05-06 15:00:00 | QQQ | ETF | 35.89 | 35.93 | 35.85 | 35.88 | 4652600.0 |
| 2005-05-06 15:30:00 | QQQ | ETF | 35.88 | 35.92 | 35.81 | 35.85 | 5386100.0 |
| 2005-05-06 08:00:00 | IWM | ETF | 59.345 | 59.43 | 59.345 | 59.43 | 110800.0 |
| 2005-05-06 08:30:00 | IWM | ETF | 59.46 | 59.9 | 59.46 | 59.85 | 422600.0 |
| 2005-05-06 09:00:00 | IWM | ETF | 59.79 | 59.79 | 59.645 | 59.65 | 58400.0 |
| 2005-05-06 09:30:00 | IWM | ETF | 59.645 | 59.725 | 59.325 | 59.42 | 5910600.0 |
| 2005-05-06 10:00:00 | IWM | ETF | 59.425 | 59.57 | 59.25 | 59.365 | 3854400.0 |
| 2005-05-06 10:30:00 | IWM | ETF | 59.41 | 59.45 | 59.225 | 59.415 | 1424200.0 |
| 2005-05-06 11:00:00 | IWM | ETF | 59.43 | 59.435 | 59.285 | 59.3 | 636200.0 |
| 2005-05-06 11:30:00 | IWM | ETF | 59.285 | 59.375 | 59.125 | 59.225 | 609200.0 |
| 2005-05-06 12:00:00 | IWM | ETF | 59.21 | 59.245 | 59.08 | 59.24 | 1017200.0 |
| 2005-05-06 12:30:00 | IWM | ETF | 59.24 | 59.255 | 59.09 | 59.22 | 587600.0 |
| 2005-05-06 13:00:00 | IWM | ETF | 59.22 | 59.475 | 59.21 | 59.46 | 809200.0 |
| 2005-05-06 13:30:00 | IWM | ETF | 59.465 | 59.495 | 59.33 | 59.35 | 779000.0 |
> showing 50 of 1,502 rows — these rows as CSV