PREVIEW / etf_30min / 2005-10-12
file: by_date/etf_30min/2005/2005-10-12.parquet size: 53 KB rows: 1,794
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-10-12 06:30:00 | SPY | ETF | 118.31 | 118.31 | 118.31 | 118.31 | 25000.0 |
| 2005-10-12 07:00:00 | SPY | ETF | 118.31 | 118.34 | 118.31 | 118.34 | 1600.0 |
| 2005-10-12 07:30:00 | SPY | ETF | 118.3 | 118.32 | 118.24 | 118.25 | 78800.0 |
| 2005-10-12 08:00:00 | SPY | ETF | 118.26 | 118.35 | 118.14 | 118.18 | 915500.0 |
| 2005-10-12 08:30:00 | SPY | ETF | 118.18 | 118.31 | 118.18 | 118.3 | 199500.0 |
| 2005-10-12 09:00:00 | SPY | ETF | 118.3 | 118.48 | 118.16 | 118.4 | 901100.0 |
| 2005-10-12 09:30:00 | SPY | ETF | 118.39 | 119.13 | 118.37 | 119.08 | 9058400.0 |
| 2005-10-12 10:00:00 | SPY | ETF | 119.08 | 119.1 | 118.39 | 118.58 | 6965200.0 |
| 2005-10-12 10:30:00 | SPY | ETF | 118.58 | 118.69 | 118.15 | 118.25 | 7948200.0 |
| 2005-10-12 11:00:00 | SPY | ETF | 118.25 | 118.52 | 118.11 | 118.45 | 8164600.0 |
| 2005-10-12 11:30:00 | SPY | ETF | 118.45 | 118.49 | 117.78 | 117.78 | 7181200.0 |
| 2005-10-12 12:00:00 | SPY | ETF | 117.8 | 118.11 | 117.56 | 118.0 | 8045600.0 |
| 2005-10-12 12:30:00 | SPY | ETF | 118.0 | 118.13 | 117.77 | 117.93 | 4282400.0 |
| 2005-10-12 13:00:00 | SPY | ETF | 117.94 | 118.32 | 117.87 | 118.06 | 7293600.0 |
| 2005-10-12 13:30:00 | SPY | ETF | 118.05 | 118.12 | 117.77 | 117.89 | 4864600.0 |
| 2005-10-12 14:00:00 | SPY | ETF | 117.8715 | 118.03 | 117.42 | 117.72 | 9881200.0 |
| 2005-10-12 14:30:00 | SPY | ETF | 117.71 | 117.8 | 117.49 | 117.56 | 4200800.0 |
| 2005-10-12 15:00:00 | SPY | ETF | 117.57 | 118.0 | 117.41 | 117.86 | 6448200.0 |
| 2005-10-12 15:30:00 | SPY | ETF | 117.86 | 118.12 | 117.7 | 117.84 | 10469300.0 |
| 2005-10-12 16:00:00 | SPY | ETF | 117.83 | 117.84 | 117.5 | 117.61 | 567100.0 |
| 2005-10-12 16:30:00 | SPY | ETF | 117.58 | 117.68 | 117.55 | 117.64 | 527800.0 |
| 2005-10-12 17:00:00 | SPY | ETF | 117.65 | 117.71 | 117.64 | 117.71 | 74400.0 |
| 2005-10-12 17:30:00 | SPY | ETF | 117.72 | 117.73 | 117.72 | 117.73 | 3900.0 |
| 2005-10-12 18:00:00 | SPY | ETF | 117.71 | 117.71 | 117.64 | 117.71 | 11900.0 |
| 2005-10-12 18:30:00 | SPY | ETF | 117.69 | 117.7 | 117.69 | 117.7 | 300.0 |
| 2005-10-12 19:00:00 | SPY | ETF | 117.7 | 117.71 | 117.69 | 117.7 | 3000.0 |
| 2005-10-12 19:30:00 | SPY | ETF | 117.72 | 117.72 | 117.71 | 117.71 | 200.0 |
| 2005-10-12 09:30:00 | QQQ | ETF | 37.77 | 38.06 | 37.75 | 37.97 | 20881800.0 |
| 2005-10-12 10:00:00 | QQQ | ETF | 37.98 | 37.99 | 37.68 | 37.78 | 15670200.0 |
| 2005-10-12 10:30:00 | QQQ | ETF | 37.78 | 37.81 | 37.61 | 37.68 | 10898500.0 |
| 2005-10-12 11:00:00 | QQQ | ETF | 37.68 | 37.81 | 37.63 | 37.8 | 10528000.0 |
| 2005-10-12 11:30:00 | QQQ | ETF | 37.81 | 37.83 | 37.54 | 37.55 | 12544000.0 |
| 2005-10-12 12:00:00 | QQQ | ETF | 37.54 | 37.79 | 37.49 | 37.62 | 8053400.0 |
| 2005-10-12 12:30:00 | QQQ | ETF | 37.63 | 37.67 | 37.54 | 37.6 | 5277800.0 |
| 2005-10-12 13:00:00 | QQQ | ETF | 37.59 | 37.76 | 37.58 | 37.68 | 7477100.0 |
| 2005-10-12 13:30:00 | QQQ | ETF | 37.68 | 37.7 | 37.58 | 37.61 | 4378000.0 |
| 2005-10-12 14:00:00 | QQQ | ETF | 37.61 | 37.68 | 37.44 | 37.55 | 10744000.0 |
| 2005-10-12 14:30:00 | QQQ | ETF | 37.55 | 37.57 | 37.45 | 37.5 | 7172100.0 |
| 2005-10-12 15:00:00 | QQQ | ETF | 37.49 | 37.62 | 37.43 | 37.58 | 7986000.0 |
| 2005-10-12 15:30:00 | QQQ | ETF | 37.58 | 37.63 | 37.47 | 37.48 | 14152800.0 |
| 2005-10-12 08:00:00 | IWM | ETF | 62.36 | 62.43 | 62.33 | 62.33 | 89800.0 |
| 2005-10-12 08:30:00 | IWM | ETF | 62.33 | 62.39 | 62.33 | 62.35 | 8200.0 |
| 2005-10-12 09:00:00 | IWM | ETF | 62.38 | 62.51 | 62.38 | 62.44 | 80400.0 |
| 2005-10-12 09:30:00 | IWM | ETF | 62.44 | 62.8 | 62.28 | 62.59 | 9991100.0 |
| 2005-10-12 10:00:00 | IWM | ETF | 62.59 | 62.63 | 61.94 | 62.05 | 9147300.0 |
| 2005-10-12 10:30:00 | IWM | ETF | 62.08 | 62.13 | 61.72 | 61.83 | 4484800.0 |
| 2005-10-12 11:00:00 | IWM | ETF | 61.84 | 62.08 | 61.74 | 62.04 | 5935300.0 |
| 2005-10-12 11:30:00 | IWM | ETF | 62.07 | 62.07 | 61.28 | 61.35 | 3891600.0 |
| 2005-10-12 12:00:00 | IWM | ETF | 61.33 | 61.72 | 61.25 | 61.71 | 3340900.0 |
| 2005-10-12 12:30:00 | IWM | ETF | 61.71 | 61.8 | 61.58 | 61.67 | 1471200.0 |
> showing 50 of 1,794 rows — these rows as CSV