PREVIEW / etf_30min / 2004-12-13
file: by_date/etf_30min/2004/2004-12-13.parquet size: 41 KB rows: 1,358
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-12-13 08:00:00 | SPY | ETF | 119.45 | 119.51 | 119.43 | 119.5 | 157100.0 |
| 2004-12-13 08:30:00 | SPY | ETF | 119.59 | 119.74 | 119.54 | 119.72 | 207600.0 |
| 2004-12-13 09:00:00 | SPY | ETF | 119.75 | 119.8 | 119.72 | 119.77 | 189700.0 |
| 2004-12-13 09:30:00 | SPY | ETF | 119.76 | 119.95 | 119.62 | 119.68 | 4862600.0 |
| 2004-12-13 10:00:00 | SPY | ETF | 119.66 | 119.84 | 119.6 | 119.6 | 2918100.0 |
| 2004-12-13 10:30:00 | SPY | ETF | 119.61 | 119.62 | 119.35 | 119.55 | 4104000.0 |
| 2004-12-13 11:00:00 | SPY | ETF | 119.55 | 119.57 | 119.38 | 119.41 | 1617500.0 |
| 2004-12-13 11:30:00 | SPY | ETF | 119.43 | 119.68 | 119.41 | 119.64 | 1119900.0 |
| 2004-12-13 12:00:00 | SPY | ETF | 119.67 | 119.73 | 119.59 | 119.66 | 989500.0 |
| 2004-12-13 12:30:00 | SPY | ETF | 119.65 | 119.68 | 119.56 | 119.66 | 609500.0 |
| 2004-12-13 13:00:00 | SPY | ETF | 119.66 | 119.83 | 119.62 | 119.8 | 842700.0 |
| 2004-12-13 13:30:00 | SPY | ETF | 119.8 | 120.13 | 119.74 | 120.03 | 4527600.0 |
| 2004-12-13 14:00:00 | SPY | ETF | 120.04 | 120.09 | 119.85 | 120.01 | 2871700.0 |
| 2004-12-13 14:30:00 | SPY | ETF | 120.02 | 120.22 | 119.99 | 120.17 | 2942100.0 |
| 2004-12-13 15:00:00 | SPY | ETF | 120.17 | 120.23 | 120.05 | 120.1 | 2849800.0 |
| 2004-12-13 15:30:00 | SPY | ETF | 120.1 | 120.31 | 120.06 | 120.29 | 4486100.0 |
| 2004-12-13 16:00:00 | SPY | ETF | 120.3 | 120.4 | 120.24 | 120.37 | 2732200.0 |
| 2004-12-13 16:30:00 | SPY | ETF | 120.35 | 120.38 | 120.32 | 120.33 | 53800.0 |
| 2004-12-13 17:00:00 | SPY | ETF | 120.32 | 120.35 | 120.3 | 120.35 | 11900.0 |
| 2004-12-13 17:30:00 | SPY | ETF | 120.35 | 120.36 | 120.34 | 120.36 | 151000.0 |
| 2004-12-13 18:00:00 | SPY | ETF | 120.35 | 120.35 | 120.33 | 120.33 | 2900.0 |
| 2004-12-13 18:30:00 | SPY | ETF | 120.33 | 120.33 | 120.32 | 120.32 | 2400.0 |
| 2004-12-13 19:00:00 | SPY | ETF | 120.32 | 120.33 | 120.31 | 120.33 | 7400.0 |
| 2004-12-13 19:30:00 | SPY | ETF | 120.32 | 120.32 | 120.31 | 120.31 | 1300.0 |
| 2004-12-13 08:00:00 | QQQ | ETF | 40.13 | 40.15 | 40.1 | 40.14 | 376164.0 |
| 2004-12-13 08:30:00 | QQQ | ETF | 40.15 | 40.21 | 40.148 | 40.21 | 769374.0 |
| 2004-12-13 09:00:00 | QQQ | ETF | 40.21 | 40.25 | 40.07 | 40.23 | 959223.0 |
| 2004-12-13 09:30:00 | QQQ | ETF | 40.232 | 40.34 | 40.15 | 40.2 | 9416000.0 |
| 2004-12-13 10:00:00 | QQQ | ETF | 40.201 | 40.31 | 40.153 | 40.179 | 7882700.0 |
| 2004-12-13 10:30:00 | QQQ | ETF | 40.18 | 40.1897 | 40.03 | 40.147 | 6293868.0 |
| 2004-12-13 11:00:00 | QQQ | ETF | 40.137 | 40.15 | 39.98 | 40.016 | 5404976.0 |
| 2004-12-13 11:30:00 | QQQ | ETF | 40.017 | 40.1 | 40.01 | 40.097 | 2934065.0 |
| 2004-12-13 12:00:00 | QQQ | ETF | 40.1 | 40.13 | 40.05 | 40.07 | 2553420.0 |
| 2004-12-13 12:30:00 | QQQ | ETF | 40.076 | 40.11 | 40.038 | 40.1 | 2056720.0 |
| 2004-12-13 13:00:00 | QQQ | ETF | 40.1 | 40.13 | 40.06 | 40.13 | 2031011.0 |
| 2004-12-13 13:30:00 | QQQ | ETF | 40.122 | 40.201 | 40.069 | 40.176 | 9729885.0 |
| 2004-12-13 14:00:00 | QQQ | ETF | 40.179 | 40.2 | 40.11 | 40.169 | 2973659.0 |
| 2004-12-13 14:30:00 | QQQ | ETF | 40.169 | 40.31 | 40.16 | 40.29 | 5375309.0 |
| 2004-12-13 15:00:00 | QQQ | ETF | 40.29 | 40.31 | 40.2 | 40.23 | 5738027.0 |
| 2004-12-13 15:30:00 | QQQ | ETF | 40.24 | 40.2801 | 40.22 | 40.2801 | 6103377.0 |
| 2004-12-13 16:00:00 | QQQ | ETF | 40.2801 | 40.358 | 40.245 | 40.35 | 3087959.0 |
| 2004-12-13 16:30:00 | QQQ | ETF | 40.34 | 40.346 | 40.31 | 40.333 | 420757.0 |
| 2004-12-13 17:00:00 | QQQ | ETF | 40.34 | 40.346 | 40.33 | 40.34 | 27860.0 |
| 2004-12-13 17:30:00 | QQQ | ETF | 40.349 | 40.349 | 40.321 | 40.339 | 12135.0 |
| 2004-12-13 18:00:00 | QQQ | ETF | 40.33 | 40.346 | 40.33 | 40.34 | 12790.0 |
| 2004-12-13 08:00:00 | IWM | ETF | 63.25 | 63.25 | 63.25 | 63.25 | 2400.0 |
| 2004-12-13 08:30:00 | IWM | ETF | 63.35 | 63.35 | 63.35 | 63.35 | 1800.0 |
| 2004-12-13 09:00:00 | IWM | ETF | 63.49 | 63.55 | 63.425 | 63.425 | 116000.0 |
| 2004-12-13 09:30:00 | IWM | ETF | 63.425 | 63.45 | 63.13 | 63.225 | 2374600.0 |
| 2004-12-13 10:00:00 | IWM | ETF | 63.215 | 63.335 | 63.105 | 63.235 | 864600.0 |
> showing 50 of 1,358 rows — these rows as CSV