PREVIEW / etf_30min / 2004-01-26
file: by_date/etf_30min/2004/2004-01-26.parquet size: 35 KB rows: 1,145
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-26 08:00:00 | SPY | ETF | 114.31 | 114.35 | 114.31 | 114.33 | 12400.0 |
| 2004-01-26 08:30:00 | SPY | ETF | 114.33 | 114.33 | 114.27 | 114.29 | 10000.0 |
| 2004-01-26 09:00:00 | SPY | ETF | 114.31 | 114.39 | 114.31 | 114.39 | 23600.0 |
| 2004-01-26 09:30:00 | SPY | ETF | 114.39 | 114.78 | 114.39 | 114.67 | 4396200.0 |
| 2004-01-26 10:00:00 | SPY | ETF | 114.67 | 114.74 | 114.46 | 114.46 | 1576500.0 |
| 2004-01-26 10:30:00 | SPY | ETF | 114.47 | 114.8 | 114.43 | 114.7 | 2508700.0 |
| 2004-01-26 11:00:00 | SPY | ETF | 114.71 | 114.79 | 114.4 | 114.51 | 2863100.0 |
| 2004-01-26 11:30:00 | SPY | ETF | 114.52 | 114.63 | 114.44 | 114.61 | 1245500.0 |
| 2004-01-26 12:00:00 | SPY | ETF | 114.61 | 114.75 | 114.55 | 114.7 | 574000.0 |
| 2004-01-26 12:30:00 | SPY | ETF | 114.7 | 114.73 | 114.47 | 114.67 | 500500.0 |
| 2004-01-26 13:00:00 | SPY | ETF | 114.67 | 114.78 | 114.61 | 114.75 | 817500.0 |
| 2004-01-26 13:30:00 | SPY | ETF | 114.77 | 114.87 | 114.65 | 114.69 | 1113300.0 |
| 2004-01-26 14:00:00 | SPY | ETF | 114.69 | 115.14 | 114.68 | 115.1 | 1371800.0 |
| 2004-01-26 14:30:00 | SPY | ETF | 115.1 | 115.32 | 115.03 | 115.32 | 2358400.0 |
| 2004-01-26 15:00:00 | SPY | ETF | 115.32 | 115.7 | 115.28 | 115.65 | 3747900.0 |
| 2004-01-26 15:30:00 | SPY | ETF | 115.64 | 115.91 | 115.58 | 115.8 | 3491100.0 |
| 2004-01-26 16:00:00 | SPY | ETF | 115.81 | 115.94 | 115.78 | 115.85 | 1363800.0 |
| 2004-01-26 16:30:00 | SPY | ETF | 115.9 | 115.94 | 115.68 | 115.74 | 187900.0 |
| 2004-01-26 17:00:00 | SPY | ETF | 115.71 | 115.76 | 115.7 | 115.71 | 6700.0 |
| 2004-01-26 17:30:00 | SPY | ETF | 115.73 | 115.73 | 115.73 | 115.73 | 10200.0 |
| 2004-01-26 18:00:00 | SPY | ETF | 115.74 | 115.77 | 115.74 | 115.77 | 3500.0 |
| 2004-01-26 18:30:00 | SPY | ETF | 115.78 | 115.8 | 115.78 | 115.8 | 600.0 |
| 2004-01-26 08:00:00 | QQQ | ETF | 37.97 | 37.98 | 37.92 | 37.98 | 24700.0 |
| 2004-01-26 08:30:00 | QQQ | ETF | 37.95 | 37.95 | 37.91 | 37.94 | 74500.0 |
| 2004-01-26 09:00:00 | QQQ | ETF | 37.94 | 37.97 | 37.93 | 37.96 | 38500.0 |
| 2004-01-26 09:30:00 | QQQ | ETF | 37.98 | 38.14 | 37.94 | 38.05 | 12392400.0 |
| 2004-01-26 10:00:00 | QQQ | ETF | 38.05 | 38.08 | 37.87 | 37.892 | 9568700.0 |
| 2004-01-26 10:30:00 | QQQ | ETF | 37.892 | 38.03 | 37.84 | 37.99 | 4666500.0 |
| 2004-01-26 11:00:00 | QQQ | ETF | 37.99 | 38.051 | 37.9 | 37.95 | 4539500.0 |
| 2004-01-26 11:30:00 | QQQ | ETF | 37.95 | 37.98 | 37.91 | 37.97 | 2812200.0 |
| 2004-01-26 12:00:00 | QQQ | ETF | 37.96 | 38.04 | 37.94 | 37.998 | 2348400.0 |
| 2004-01-26 12:30:00 | QQQ | ETF | 37.998 | 38.03 | 37.9 | 37.989 | 2469800.0 |
| 2004-01-26 13:00:00 | QQQ | ETF | 38.0 | 38.05 | 37.96 | 38.03 | 2642800.0 |
| 2004-01-26 13:30:00 | QQQ | ETF | 38.035 | 38.1 | 38.01 | 38.04 | 4157800.0 |
| 2004-01-26 14:00:00 | QQQ | ETF | 38.04 | 38.25 | 38.04 | 38.22 | 5825300.0 |
| 2004-01-26 14:30:00 | QQQ | ETF | 38.216 | 38.36 | 38.2 | 38.34 | 7233100.0 |
| 2004-01-26 15:00:00 | QQQ | ETF | 38.35 | 38.56 | 38.34 | 38.54 | 7323700.0 |
| 2004-01-26 15:30:00 | QQQ | ETF | 38.54 | 38.61 | 38.46 | 38.57 | 8572700.0 |
| 2004-01-26 16:00:00 | QQQ | ETF | 38.56 | 38.65 | 38.55 | 38.6 | 2983800.0 |
| 2004-01-26 16:30:00 | QQQ | ETF | 38.6 | 38.66 | 38.4 | 38.435 | 2071400.0 |
| 2004-01-26 17:00:00 | QQQ | ETF | 38.43 | 38.435 | 38.388 | 38.42 | 662000.0 |
| 2004-01-26 17:30:00 | QQQ | ETF | 38.43 | 38.44 | 38.41 | 38.44 | 113100.0 |
| 2004-01-26 18:00:00 | QQQ | ETF | 38.44 | 38.47 | 38.43 | 38.46 | 38900.0 |
| 2004-01-26 18:30:00 | QQQ | ETF | 38.45 | 38.49 | 38.45 | 38.48 | 23800.0 |
| 2004-01-26 19:00:00 | QQQ | ETF | 38.48 | 38.49 | 38.48 | 38.49 | 10400.0 |
| 2004-01-26 19:30:00 | QQQ | ETF | 38.48 | 38.49 | 38.47 | 38.49 | 13100.0 |
| 2004-01-26 09:30:00 | IWM | ETF | 59.35 | 59.45 | 59.2175 | 59.275 | 445800.0 |
| 2004-01-26 10:00:00 | IWM | ETF | 59.3 | 59.33 | 58.965 | 58.965 | 613200.0 |
| 2004-01-26 10:30:00 | IWM | ETF | 58.96 | 59.175 | 58.955 | 59.15 | 204200.0 |
| 2004-01-26 11:00:00 | IWM | ETF | 59.125 | 59.175 | 59.015 | 59.07 | 513200.0 |
> showing 50 of 1,145 rows — these rows as CSV