PREVIEW / etf_30min / 2004-01-22
file: by_date/etf_30min/2004/2004-01-22.parquet size: 33 KB rows: 1,146
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-01-22 08:00:00 | SPY | ETF | 114.95 | 114.99 | 114.93 | 114.93 | 14500.0 |
| 2004-01-22 08:30:00 | SPY | ETF | 114.99 | 115.12 | 114.95 | 115.1 | 9000.0 |
| 2004-01-22 09:00:00 | SPY | ETF | 115.1 | 115.16 | 115.09 | 115.15 | 10600.0 |
| 2004-01-22 09:30:00 | SPY | ETF | 115.14 | 115.38 | 115.08 | 115.32 | 4761900.0 |
| 2004-01-22 10:00:00 | SPY | ETF | 115.34 | 115.35 | 114.93 | 115.0 | 2999700.0 |
| 2004-01-22 10:30:00 | SPY | ETF | 115.0 | 115.24 | 114.85 | 114.93 | 2457200.0 |
| 2004-01-22 11:00:00 | SPY | ETF | 114.92 | 114.97 | 114.67 | 114.74 | 3066400.0 |
| 2004-01-22 11:30:00 | SPY | ETF | 114.74 | 114.9 | 114.7 | 114.84 | 1592200.0 |
| 2004-01-22 12:00:00 | SPY | ETF | 114.83 | 115.12 | 114.81 | 115.0 | 1608000.0 |
| 2004-01-22 12:30:00 | SPY | ETF | 115.03 | 115.18 | 114.98 | 115.03 | 1518800.0 |
| 2004-01-22 13:00:00 | SPY | ETF | 115.03 | 115.05 | 114.76 | 114.85 | 764300.0 |
| 2004-01-22 13:30:00 | SPY | ETF | 114.85 | 114.99 | 114.76 | 114.88 | 659600.0 |
| 2004-01-22 14:00:00 | SPY | ETF | 114.9 | 115.06 | 114.76 | 115.01 | 711300.0 |
| 2004-01-22 14:30:00 | SPY | ETF | 115.01 | 115.04 | 114.58 | 114.65 | 2224200.0 |
| 2004-01-22 15:00:00 | SPY | ETF | 114.65 | 115.02 | 114.63 | 115.01 | 1532900.0 |
| 2004-01-22 15:30:00 | SPY | ETF | 114.99 | 115.01 | 114.64 | 114.73 | 1834700.0 |
| 2004-01-22 16:00:00 | SPY | ETF | 114.73 | 114.94 | 114.55 | 114.6 | 1282200.0 |
| 2004-01-22 16:30:00 | SPY | ETF | 114.6 | 114.6 | 114.45 | 114.6 | 302800.0 |
| 2004-01-22 17:00:00 | SPY | ETF | 114.56 | 114.61 | 114.5 | 114.58 | 13000.0 |
| 2004-01-22 17:30:00 | SPY | ETF | 114.52 | 114.54 | 114.51 | 114.51 | 7700.0 |
| 2004-01-22 18:00:00 | SPY | ETF | 114.54 | 114.6 | 114.51 | 114.6 | 9200.0 |
| 2004-01-22 18:30:00 | SPY | ETF | 114.54 | 114.6 | 114.54 | 114.6 | 1200.0 |
| 2004-01-22 19:30:00 | SPY | ETF | 114.62 | 114.62 | 114.62 | 114.62 | 100.0 |
| 2004-01-22 08:00:00 | QQQ | ETF | 38.45 | 38.48 | 38.44 | 38.44 | 24400.0 |
| 2004-01-22 08:30:00 | QQQ | ETF | 38.44 | 38.54 | 38.44 | 38.52 | 119100.0 |
| 2004-01-22 09:00:00 | QQQ | ETF | 38.52 | 38.58 | 38.51 | 38.55 | 53500.0 |
| 2004-01-22 09:30:00 | QQQ | ETF | 38.55 | 38.69 | 38.52 | 38.6 | 10096100.0 |
| 2004-01-22 10:00:00 | QQQ | ETF | 38.6 | 38.611 | 38.35 | 38.37 | 7939700.0 |
| 2004-01-22 10:30:00 | QQQ | ETF | 38.37 | 38.518 | 38.24 | 38.28 | 8569000.0 |
| 2004-01-22 11:00:00 | QQQ | ETF | 38.277 | 38.33 | 38.09 | 38.134 | 8188100.0 |
| 2004-01-22 11:30:00 | QQQ | ETF | 38.141 | 38.27 | 38.11 | 38.25 | 5056200.0 |
| 2004-01-22 12:00:00 | QQQ | ETF | 38.24 | 38.39 | 38.24 | 38.32 | 5820100.0 |
| 2004-01-22 12:30:00 | QQQ | ETF | 38.32 | 38.52 | 38.319 | 38.4 | 6616800.0 |
| 2004-01-22 13:00:00 | QQQ | ETF | 38.4 | 38.4 | 38.18 | 38.257 | 4839100.0 |
| 2004-01-22 13:30:00 | QQQ | ETF | 38.25 | 38.3 | 38.17 | 38.26 | 2649900.0 |
| 2004-01-22 14:00:00 | QQQ | ETF | 38.26 | 38.35 | 38.189 | 38.34 | 2953900.0 |
| 2004-01-22 14:30:00 | QQQ | ETF | 38.34 | 38.34 | 38.1 | 38.16 | 5552600.0 |
| 2004-01-22 15:00:00 | QQQ | ETF | 38.15 | 38.35 | 38.13 | 38.33 | 3922400.0 |
| 2004-01-22 15:30:00 | QQQ | ETF | 38.33 | 38.34 | 38.07 | 38.083 | 7923900.0 |
| 2004-01-22 16:00:00 | QQQ | ETF | 38.09 | 38.35 | 37.861 | 37.861 | 4339400.0 |
| 2004-01-22 16:30:00 | QQQ | ETF | 37.93 | 37.98 | 37.822 | 37.919 | 1345400.0 |
| 2004-01-22 17:00:00 | QQQ | ETF | 37.92 | 37.96 | 37.89 | 37.91 | 268000.0 |
| 2004-01-22 17:30:00 | QQQ | ETF | 37.92 | 37.96 | 37.9 | 37.95 | 516100.0 |
| 2004-01-22 18:00:00 | QQQ | ETF | 37.96 | 37.97 | 37.91 | 37.95 | 320600.0 |
| 2004-01-22 18:30:00 | QQQ | ETF | 37.94 | 37.95 | 37.94 | 37.95 | 42000.0 |
| 2004-01-22 19:00:00 | QQQ | ETF | 37.97 | 37.97 | 37.96 | 37.97 | 6400.0 |
| 2004-01-22 19:30:00 | QQQ | ETF | 37.97 | 38.0 | 37.97 | 37.97 | 11400.0 |
| 2004-01-22 09:00:00 | IWM | ETF | 59.66 | 59.66 | 59.66 | 59.66 | 3000.0 |
| 2004-01-22 09:30:00 | IWM | ETF | 59.755 | 59.865 | 59.68 | 59.795 | 1142800.0 |
| 2004-01-22 10:00:00 | IWM | ETF | 59.835 | 59.835 | 59.35 | 59.39 | 1219800.0 |
> showing 50 of 1,146 rows — these rows as CSV