PREVIEW / etf_30min / 2005-03-21
file: by_date/etf_30min/2005/2005-03-21.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-03-21 08:00:00 | SPY | ETF | 118.61 | 118.71 | 118.61 | 118.71 | 50900.0 |
| 2005-03-21 08:30:00 | SPY | ETF | 118.7 | 118.72 | 118.62 | 118.63 | 52700.0 |
| 2005-03-21 09:00:00 | SPY | ETF | 118.64 | 118.75 | 118.62 | 118.73 | 140600.0 |
| 2005-03-21 09:30:00 | SPY | ETF | 118.71 | 118.78 | 118.56 | 118.66 | 5036700.0 |
| 2005-03-21 10:00:00 | SPY | ETF | 118.65 | 118.69 | 118.23 | 118.29 | 6635600.0 |
| 2005-03-21 10:30:00 | SPY | ETF | 118.28 | 118.31 | 117.85 | 118.03 | 6606800.0 |
| 2005-03-21 11:00:00 | SPY | ETF | 118.02 | 118.12 | 117.76 | 117.9 | 5883600.0 |
| 2005-03-21 11:30:00 | SPY | ETF | 117.89 | 118.15 | 117.78 | 118.12 | 4426600.0 |
| 2005-03-21 12:00:00 | SPY | ETF | 118.08 | 118.57 | 118.07 | 118.44 | 6580700.0 |
| 2005-03-21 12:30:00 | SPY | ETF | 118.44 | 118.49 | 118.3 | 118.32 | 1443800.0 |
| 2005-03-21 13:00:00 | SPY | ETF | 118.32 | 118.38 | 118.2 | 118.23 | 3262600.0 |
| 2005-03-21 13:30:00 | SPY | ETF | 118.24 | 118.43 | 118.2 | 118.31 | 3142000.0 |
| 2005-03-21 14:00:00 | SPY | ETF | 118.31 | 118.31 | 118.05 | 118.17 | 2977800.0 |
| 2005-03-21 14:30:00 | SPY | ETF | 118.17 | 118.46 | 118.16 | 118.4 | 5198500.0 |
| 2005-03-21 15:00:00 | SPY | ETF | 118.4 | 118.64 | 118.33 | 118.58 | 4328400.0 |
| 2005-03-21 15:30:00 | SPY | ETF | 118.59 | 118.59 | 118.25 | 118.26 | 3477300.0 |
| 2005-03-21 16:00:00 | SPY | ETF | 118.23 | 118.3 | 118.04 | 118.07 | 686900.0 |
| 2005-03-21 16:30:00 | SPY | ETF | 118.1 | 118.12 | 118.07 | 118.1 | 123600.0 |
| 2005-03-21 17:00:00 | SPY | ETF | 118.08 | 118.3 | 118.06 | 118.17 | 62500.0 |
| 2005-03-21 17:30:00 | SPY | ETF | 118.17 | 118.17 | 118.08 | 118.09 | 1600.0 |
| 2005-03-21 18:00:00 | SPY | ETF | 118.15 | 118.15 | 118.11 | 118.11 | 3500.0 |
| 2005-03-21 09:30:00 | QQQ | ETF | 36.59 | 36.65 | 36.53 | 36.58 | 9494900.0 |
| 2005-03-21 10:00:00 | QQQ | ETF | 36.58 | 36.59 | 36.35 | 36.37 | 7901100.0 |
| 2005-03-21 10:30:00 | QQQ | ETF | 36.37 | 36.38 | 36.26 | 36.35 | 11114800.0 |
| 2005-03-21 11:00:00 | QQQ | ETF | 36.36 | 36.39 | 36.25 | 36.36 | 6177200.0 |
| 2005-03-21 11:30:00 | QQQ | ETF | 36.36 | 36.5 | 36.34 | 36.5 | 6870900.0 |
| 2005-03-21 12:00:00 | QQQ | ETF | 36.5 | 37.67 | 36.47 | 36.7 | 11687700.0 |
| 2005-03-21 12:30:00 | QQQ | ETF | 36.7 | 36.71 | 36.61 | 36.61 | 4242800.0 |
| 2005-03-21 13:00:00 | QQQ | ETF | 36.61 | 38.58 | 36.55 | 36.56 | 3668300.0 |
| 2005-03-21 13:30:00 | QQQ | ETF | 36.56 | 36.62 | 36.55 | 36.56 | 3855600.0 |
| 2005-03-21 14:00:00 | QQQ | ETF | 36.56 | 36.56 | 36.47 | 36.49 | 6086700.0 |
| 2005-03-21 14:30:00 | QQQ | ETF | 36.49 | 36.63 | 36.48 | 36.6 | 4441900.0 |
| 2005-03-21 15:00:00 | QQQ | ETF | 36.62 | 36.72 | 36.58 | 36.7 | 5117300.0 |
| 2005-03-21 15:30:00 | QQQ | ETF | 36.71 | 36.71 | 36.56 | 36.57 | 7777200.0 |
| 2005-03-21 09:00:00 | IWM | ETF | 62.06 | 62.06 | 62.05 | 62.05 | 2400.0 |
| 2005-03-21 09:30:00 | IWM | ETF | 62.04 | 62.135 | 62.0 | 62.015 | 1575400.0 |
| 2005-03-21 10:00:00 | IWM | ETF | 62.015 | 62.02 | 61.795 | 61.825 | 1154600.0 |
| 2005-03-21 10:30:00 | IWM | ETF | 61.805 | 61.835 | 61.67 | 61.79 | 1727200.0 |
| 2005-03-21 11:00:00 | IWM | ETF | 61.78 | 61.795 | 61.575 | 61.705 | 1294800.0 |
| 2005-03-21 11:30:00 | IWM | ETF | 61.695 | 61.815 | 61.685 | 61.785 | 378200.0 |
| 2005-03-21 12:00:00 | IWM | ETF | 61.78 | 61.95 | 61.755 | 61.935 | 1849600.0 |
| 2005-03-21 12:30:00 | IWM | ETF | 61.935 | 61.955 | 61.85 | 61.86 | 586200.0 |
| 2005-03-21 13:00:00 | IWM | ETF | 61.86 | 61.895 | 61.825 | 61.845 | 1157600.0 |
| 2005-03-21 13:30:00 | IWM | ETF | 61.845 | 61.95 | 61.835 | 61.8708 | 591600.0 |
| 2005-03-21 14:00:00 | IWM | ETF | 61.855 | 61.86 | 61.73 | 61.78 | 488400.0 |
| 2005-03-21 14:30:00 | IWM | ETF | 61.78 | 61.94 | 61.78 | 61.94 | 764600.0 |
| 2005-03-21 15:00:00 | IWM | ETF | 61.935 | 62.1 | 61.92 | 62.085 | 2581000.0 |
| 2005-03-21 15:30:00 | IWM | ETF | 62.085 | 62.09 | 61.92 | 61.95 | 1414000.0 |
| 2005-03-21 16:00:00 | IWM | ETF | 61.96 | 61.995 | 61.9 | 61.9 | 696600.0 |
| 2005-03-21 16:30:00 | IWM | ETF | 61.94 | 61.98 | 61.94 | 61.98 | 9200.0 |
> showing 50 of 1,502 rows — these rows as CSV