PREVIEW / etf_30min / 2005-01-19
file: by_date/etf_30min/2005/2005-01-19.parquet size: 42 KB rows: 1,447
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-01-19 08:00:00 | SPY | ETF | 119.28 | 119.29 | 119.21 | 119.29 | 20200.0 |
| 2005-01-19 08:30:00 | SPY | ETF | 119.27 | 119.55 | 119.27 | 119.5 | 236400.0 |
| 2005-01-19 09:00:00 | SPY | ETF | 119.52 | 119.52 | 119.42 | 119.42 | 93400.0 |
| 2005-01-19 09:30:00 | SPY | ETF | 119.43 | 119.52 | 119.3 | 119.39 | 5736100.0 |
| 2005-01-19 10:00:00 | SPY | ETF | 119.39 | 119.5 | 119.19 | 119.24 | 4158100.0 |
| 2005-01-19 10:30:00 | SPY | ETF | 119.24 | 119.27 | 119.02 | 119.12 | 4985000.0 |
| 2005-01-19 11:00:00 | SPY | ETF | 119.12 | 119.22 | 119.06 | 119.15 | 2876400.0 |
| 2005-01-19 11:30:00 | SPY | ETF | 119.15 | 119.27 | 119.02 | 119.04 | 2288500.0 |
| 2005-01-19 12:00:00 | SPY | ETF | 119.05 | 119.13 | 118.89 | 119.01 | 2813200.0 |
| 2005-01-19 12:30:00 | SPY | ETF | 119.0 | 119.2 | 118.96 | 119.19 | 2794100.0 |
| 2005-01-19 13:00:00 | SPY | ETF | 119.19 | 119.24 | 119.05 | 119.14 | 1930800.0 |
| 2005-01-19 13:30:00 | SPY | ETF | 119.14 | 119.17 | 119.0 | 119.04 | 1745000.0 |
| 2005-01-19 14:00:00 | SPY | ETF | 119.04 | 119.19 | 118.94 | 119.19 | 3083300.0 |
| 2005-01-19 14:30:00 | SPY | ETF | 119.2 | 119.22 | 119.02 | 119.091 | 1766000.0 |
| 2005-01-19 15:00:00 | SPY | ETF | 119.1 | 119.13 | 118.53 | 118.54 | 6700400.0 |
| 2005-01-19 15:30:00 | SPY | ETF | 118.54 | 118.67 | 118.39 | 118.39 | 7710600.0 |
| 2005-01-19 16:00:00 | SPY | ETF | 118.41 | 118.44 | 117.86 | 117.98 | 871300.0 |
| 2005-01-19 16:30:00 | SPY | ETF | 117.98 | 118.23 | 117.78 | 117.84 | 1170500.0 |
| 2005-01-19 17:00:00 | SPY | ETF | 117.84 | 117.9 | 117.56 | 117.62 | 1304300.0 |
| 2005-01-19 17:30:00 | SPY | ETF | 117.63 | 117.7 | 117.62 | 117.64 | 133200.0 |
| 2005-01-19 18:00:00 | SPY | ETF | 117.63 | 117.78 | 117.62 | 117.75 | 148600.0 |
| 2005-01-19 18:30:00 | SPY | ETF | 117.77 | 117.84 | 117.77 | 117.83 | 10100.0 |
| 2005-01-19 19:00:00 | SPY | ETF | 117.78 | 117.83 | 117.78 | 117.78 | 1500.0 |
| 2005-01-19 19:30:00 | SPY | ETF | 117.79 | 117.81 | 117.78 | 117.81 | 4400.0 |
| 2005-01-19 09:30:00 | QQQ | ETF | 38.75 | 38.75 | 38.56 | 38.61 | 12960000.0 |
| 2005-01-19 10:00:00 | QQQ | ETF | 38.61 | 38.66 | 38.51 | 38.53 | 8365800.0 |
| 2005-01-19 10:30:00 | QQQ | ETF | 38.53 | 38.54 | 38.4 | 38.44 | 10202800.0 |
| 2005-01-19 11:00:00 | QQQ | ETF | 38.44 | 38.51 | 38.42 | 38.48 | 5224000.0 |
| 2005-01-19 11:30:00 | QQQ | ETF | 38.48 | 38.55 | 38.39 | 38.42 | 4950900.0 |
| 2005-01-19 12:00:00 | QQQ | ETF | 38.42 | 38.45 | 38.33 | 38.4 | 4946000.0 |
| 2005-01-19 12:30:00 | QQQ | ETF | 38.4 | 38.46 | 38.37 | 38.45 | 2991800.0 |
| 2005-01-19 13:00:00 | QQQ | ETF | 38.44 | 38.53 | 38.4 | 38.47 | 3090500.0 |
| 2005-01-19 13:30:00 | QQQ | ETF | 38.47 | 38.47 | 38.4 | 38.42 | 2525300.0 |
| 2005-01-19 14:00:00 | QQQ | ETF | 38.42 | 38.48 | 38.37 | 38.47 | 3802900.0 |
| 2005-01-19 14:30:00 | QQQ | ETF | 38.47 | 38.5 | 38.4 | 38.42 | 4347800.0 |
| 2005-01-19 15:00:00 | QQQ | ETF | 38.42 | 38.46 | 38.12 | 38.13 | 10675900.0 |
| 2005-01-19 15:30:00 | QQQ | ETF | 38.13 | 38.17 | 38.06 | 38.08 | 14069200.0 |
| 2005-01-19 08:00:00 | IWM | ETF | 62.105 | 62.105 | 62.105 | 62.105 | 600.0 |
| 2005-01-19 08:30:00 | IWM | ETF | 62.205 | 62.205 | 62.185 | 62.185 | 4000.0 |
| 2005-01-19 09:00:00 | IWM | ETF | 62.15 | 62.185 | 62.15 | 62.185 | 10200.0 |
| 2005-01-19 09:30:00 | IWM | ETF | 62.145 | 62.375 | 62.02 | 62.19 | 1959400.0 |
| 2005-01-19 10:00:00 | IWM | ETF | 62.19 | 62.305 | 62.085 | 62.135 | 3033800.0 |
| 2005-01-19 10:30:00 | IWM | ETF | 62.14 | 62.16 | 62.0 | 62.015 | 2605400.0 |
| 2005-01-19 11:00:00 | IWM | ETF | 62.025 | 62.095 | 61.855 | 61.975 | 1915200.0 |
| 2005-01-19 11:30:00 | IWM | ETF | 61.99 | 62.075 | 61.95 | 61.96 | 514800.0 |
| 2005-01-19 12:00:00 | IWM | ETF | 61.97 | 62.01 | 61.875 | 61.995 | 781000.0 |
| 2005-01-19 12:30:00 | IWM | ETF | 61.985 | 62.125 | 61.965 | 62.125 | 273200.0 |
| 2005-01-19 13:00:00 | IWM | ETF | 62.125 | 62.225 | 62.06 | 62.135 | 391000.0 |
| 2005-01-19 13:30:00 | IWM | ETF | 62.13 | 62.14 | 61.965 | 62.0 | 562200.0 |
| 2005-01-19 14:00:00 | IWM | ETF | 62.005 | 62.1 | 61.96 | 62.1 | 1008000.0 |
> showing 50 of 1,447 rows — these rows as CSV