PREVIEW / etf_30min / 2004-10-20
file: by_date/etf_30min/2004/2004-10-20.parquet size: 37 KB rows: 1,220
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-20 08:00:00 | SPY | ETF | 110.26 | 110.35 | 110.2 | 110.34 | 34500.0 |
| 2004-10-20 08:30:00 | SPY | ETF | 110.34 | 110.4 | 110.31 | 110.31 | 57200.0 |
| 2004-10-20 09:00:00 | SPY | ETF | 110.3 | 110.39 | 110.3 | 110.38 | 94500.0 |
| 2004-10-20 09:30:00 | SPY | ETF | 110.38 | 110.52 | 110.25 | 110.4 | 5652000.0 |
| 2004-10-20 10:00:00 | SPY | ETF | 110.42 | 110.43 | 110.1 | 110.11 | 6133600.0 |
| 2004-10-20 10:30:00 | SPY | ETF | 110.12 | 110.15 | 109.75 | 110.1 | 6889000.0 |
| 2004-10-20 11:00:00 | SPY | ETF | 110.09 | 110.47 | 110.07 | 110.28 | 5580500.0 |
| 2004-10-20 11:30:00 | SPY | ETF | 110.28 | 110.44 | 110.15 | 110.26 | 3933000.0 |
| 2004-10-20 12:00:00 | SPY | ETF | 110.25 | 110.6 | 110.15 | 110.57 | 3309400.0 |
| 2004-10-20 12:30:00 | SPY | ETF | 110.57 | 110.82 | 110.53 | 110.64 | 5268500.0 |
| 2004-10-20 13:00:00 | SPY | ETF | 110.6416 | 110.71 | 110.55 | 110.64 | 906500.0 |
| 2004-10-20 13:30:00 | SPY | ETF | 110.64 | 110.65 | 110.36 | 110.36 | 1783800.0 |
| 2004-10-20 14:00:00 | SPY | ETF | 110.35 | 110.6 | 110.3 | 110.38 | 2725400.0 |
| 2004-10-20 14:30:00 | SPY | ETF | 110.38 | 110.67 | 110.23 | 110.6 | 3126000.0 |
| 2004-10-20 15:00:00 | SPY | ETF | 110.61 | 110.72 | 110.32 | 110.52 | 2614300.0 |
| 2004-10-20 15:30:00 | SPY | ETF | 110.53 | 110.81 | 110.49 | 110.72 | 2680000.0 |
| 2004-10-20 16:00:00 | SPY | ETF | 110.72 | 110.77 | 110.52 | 110.57 | 1867700.0 |
| 2004-10-20 16:30:00 | SPY | ETF | 110.57 | 110.66 | 110.52 | 110.59 | 2252100.0 |
| 2004-10-20 17:00:00 | SPY | ETF | 110.61 | 110.7 | 110.61 | 110.69 | 69100.0 |
| 2004-10-20 17:30:00 | SPY | ETF | 110.65 | 110.68 | 110.63 | 110.66 | 3300.0 |
| 2004-10-20 18:00:00 | SPY | ETF | 110.66 | 110.72 | 110.63 | 110.72 | 13200.0 |
| 2004-10-20 18:30:00 | SPY | ETF | 110.71 | 110.71 | 110.7 | 110.7 | 2100.0 |
| 2004-10-20 19:00:00 | SPY | ETF | 110.7 | 110.7 | 110.69 | 110.69 | 1000.0 |
| 2004-10-20 19:30:00 | SPY | ETF | 110.73 | 110.73 | 110.71 | 110.71 | 600.0 |
| 2004-10-20 08:00:00 | QQQ | ETF | 35.72 | 35.77 | 35.71 | 35.77 | 23300.0 |
| 2004-10-20 08:30:00 | QQQ | ETF | 35.78 | 35.81 | 35.77 | 35.8 | 141000.0 |
| 2004-10-20 09:00:00 | QQQ | ETF | 35.79 | 35.83 | 35.78 | 35.82 | 105800.0 |
| 2004-10-20 09:30:00 | QQQ | ETF | 35.83 | 35.94 | 35.75 | 35.91 | 12506400.0 |
| 2004-10-20 10:00:00 | QQQ | ETF | 35.91 | 35.99 | 35.813 | 35.865 | 8779000.0 |
| 2004-10-20 10:30:00 | QQQ | ETF | 35.86 | 35.9 | 35.65 | 35.88 | 13197300.0 |
| 2004-10-20 11:00:00 | QQQ | ETF | 35.882 | 36.08 | 35.86 | 36.0 | 12400600.0 |
| 2004-10-20 11:30:00 | QQQ | ETF | 36.009 | 36.081 | 35.93 | 35.98 | 6604800.0 |
| 2004-10-20 12:00:00 | QQQ | ETF | 35.971 | 36.13 | 35.94 | 36.1 | 5152300.0 |
| 2004-10-20 12:30:00 | QQQ | ETF | 36.1 | 36.23 | 36.098 | 36.14 | 6625300.0 |
| 2004-10-20 13:00:00 | QQQ | ETF | 36.14 | 36.19 | 36.04 | 36.04 | 2925900.0 |
| 2004-10-20 13:30:00 | QQQ | ETF | 36.046 | 36.06 | 35.96 | 35.97 | 5565600.0 |
| 2004-10-20 14:00:00 | QQQ | ETF | 35.98 | 36.121 | 35.96 | 36.009 | 5742500.0 |
| 2004-10-20 14:30:00 | QQQ | ETF | 36.01 | 36.08 | 35.93 | 36.042 | 6173600.0 |
| 2004-10-20 15:00:00 | QQQ | ETF | 36.05 | 36.09 | 35.91 | 36.02 | 5922400.0 |
| 2004-10-20 15:30:00 | QQQ | ETF | 36.01 | 36.12 | 36.0 | 36.093 | 9259600.0 |
| 2004-10-20 16:00:00 | QQQ | ETF | 36.1 | 36.14 | 36.03 | 36.04 | 2285800.0 |
| 2004-10-20 16:30:00 | QQQ | ETF | 36.03 | 36.13 | 36.02 | 36.11 | 665700.0 |
| 2004-10-20 17:00:00 | QQQ | ETF | 36.108 | 36.16 | 36.108 | 36.15 | 216800.0 |
| 2004-10-20 17:30:00 | QQQ | ETF | 36.16 | 36.24 | 36.15 | 36.2 | 83300.0 |
| 2004-10-20 18:00:00 | QQQ | ETF | 36.19 | 36.23 | 36.17 | 36.2 | 108700.0 |
| 2004-10-20 18:30:00 | QQQ | ETF | 36.2 | 36.2 | 36.17 | 36.19 | 43600.0 |
| 2004-10-20 19:00:00 | QQQ | ETF | 36.18 | 36.18 | 36.15 | 36.15 | 5100.0 |
| 2004-10-20 19:30:00 | QQQ | ETF | 36.16 | 36.16 | 36.16 | 36.16 | 11400.0 |
| 2004-10-20 08:30:00 | IWM | ETF | 56.24 | 56.24 | 56.165 | 56.18 | 43800.0 |
| 2004-10-20 09:00:00 | IWM | ETF | 56.165 | 56.295 | 56.165 | 56.26 | 22800.0 |
> showing 50 of 1,220 rows — these rows as CSV