PREVIEW / etf_30min / 2004-01-05
file: by_date/etf_30min/2004/2004-01-05.parquet size: 35 KB rows: 1,178
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-05 08:00:00 | SPY | ETF | 111.61 | 111.72 | 111.6 | 111.72 | 60200.0 |
| 2004-01-05 08:30:00 | SPY | ETF | 111.74 | 111.75 | 111.67 | 111.67 | 11000.0 |
| 2004-01-05 09:00:00 | SPY | ETF | 111.71 | 111.73 | 111.65 | 111.72 | 96700.0 |
| 2004-01-05 09:30:00 | SPY | ETF | 111.69 | 112.13 | 111.67 | 112.08 | 4380700.0 |
| 2004-01-05 10:00:00 | SPY | ETF | 112.08 | 112.16 | 111.88 | 111.97 | 2131200.0 |
| 2004-01-05 10:30:00 | SPY | ETF | 111.96 | 112.06 | 111.8 | 111.95 | 3723100.0 |
| 2004-01-05 11:00:00 | SPY | ETF | 111.94 | 112.0 | 111.66 | 111.77 | 1843700.0 |
| 2004-01-05 11:30:00 | SPY | ETF | 111.76 | 111.88 | 111.73 | 111.83 | 874200.0 |
| 2004-01-05 12:00:00 | SPY | ETF | 111.84 | 111.91 | 111.77 | 111.83 | 808100.0 |
| 2004-01-05 12:30:00 | SPY | ETF | 111.77 | 111.86 | 111.59 | 111.8 | 1357800.0 |
| 2004-01-05 13:00:00 | SPY | ETF | 111.8 | 112.04 | 111.77 | 111.92 | 1016300.0 |
| 2004-01-05 13:30:00 | SPY | ETF | 111.92 | 112.05 | 111.87 | 112.01 | 753100.0 |
| 2004-01-05 14:00:00 | SPY | ETF | 111.98 | 112.15 | 111.95 | 112.09 | 1280000.0 |
| 2004-01-05 14:30:00 | SPY | ETF | 112.07 | 112.09 | 111.93 | 112.01 | 1271500.0 |
| 2004-01-05 15:00:00 | SPY | ETF | 111.97 | 112.38 | 111.97 | 112.35 | 2567800.0 |
| 2004-01-05 15:30:00 | SPY | ETF | 112.36 | 112.45 | 112.29 | 112.37 | 2757500.0 |
| 2004-01-05 16:00:00 | SPY | ETF | 112.37 | 112.52 | 112.36 | 112.37 | 1724400.0 |
| 2004-01-05 16:30:00 | SPY | ETF | 112.36 | 112.4 | 112.35 | 112.36 | 18400.0 |
| 2004-01-05 17:00:00 | SPY | ETF | 112.37 | 112.37 | 112.32 | 112.35 | 4100.0 |
| 2004-01-05 17:30:00 | SPY | ETF | 112.34 | 112.36 | 112.32 | 112.36 | 3900.0 |
| 2004-01-05 18:00:00 | SPY | ETF | 112.38 | 112.42 | 112.36 | 112.36 | 3400.0 |
| 2004-01-05 18:30:00 | SPY | ETF | 112.38 | 112.38 | 112.38 | 112.38 | 100.0 |
| 2004-01-05 19:00:00 | SPY | ETF | 112.38 | 112.39 | 112.38 | 112.39 | 2300.0 |
| 2004-01-05 19:30:00 | SPY | ETF | 112.39 | 112.39 | 112.39 | 112.39 | 1000.0 |
| 2004-01-05 08:00:00 | QQQ | ETF | 36.59 | 36.64 | 36.55 | 36.6 | 51400.0 |
| 2004-01-05 08:30:00 | QQQ | ETF | 36.6 | 36.62 | 36.6 | 36.6 | 22000.0 |
| 2004-01-05 09:00:00 | QQQ | ETF | 36.6 | 36.62 | 36.57 | 36.6 | 107200.0 |
| 2004-01-05 09:30:00 | QQQ | ETF | 36.593 | 36.87 | 36.588 | 36.81 | 13489000.0 |
| 2004-01-05 10:00:00 | QQQ | ETF | 36.809 | 36.88 | 36.74 | 36.831 | 7063500.0 |
| 2004-01-05 10:30:00 | QQQ | ETF | 36.831 | 36.95 | 36.757 | 36.899 | 5445700.0 |
| 2004-01-05 11:00:00 | QQQ | ETF | 36.907 | 36.92 | 36.77 | 36.8 | 4309100.0 |
| 2004-01-05 11:30:00 | QQQ | ETF | 36.811 | 36.89 | 36.8 | 36.85 | 2514500.0 |
| 2004-01-05 12:00:00 | QQQ | ETF | 36.856 | 36.95 | 36.84 | 36.9 | 2889700.0 |
| 2004-01-05 12:30:00 | QQQ | ETF | 36.9 | 36.94 | 36.81 | 36.892 | 3083500.0 |
| 2004-01-05 13:00:00 | QQQ | ETF | 36.9 | 36.99 | 36.88 | 36.94 | 3258700.0 |
| 2004-01-05 13:30:00 | QQQ | ETF | 36.933 | 37.04 | 36.92 | 36.96 | 3208600.0 |
| 2004-01-05 14:00:00 | QQQ | ETF | 36.969 | 37.09 | 36.948 | 37.05 | 3958800.0 |
| 2004-01-05 14:30:00 | QQQ | ETF | 37.05 | 37.08 | 36.98 | 37.0 | 2687700.0 |
| 2004-01-05 15:00:00 | QQQ | ETF | 37.0 | 37.158 | 36.99 | 37.15 | 4543300.0 |
| 2004-01-05 15:30:00 | QQQ | ETF | 37.15 | 37.152 | 37.08 | 37.13 | 5388700.0 |
| 2004-01-05 16:00:00 | QQQ | ETF | 37.13 | 37.21 | 37.08 | 37.12 | 2180600.0 |
| 2004-01-05 16:30:00 | QQQ | ETF | 37.112 | 37.21 | 37.08 | 37.105 | 2200600.0 |
| 2004-01-05 17:00:00 | QQQ | ETF | 37.11 | 37.12 | 37.09 | 37.1 | 72600.0 |
| 2004-01-05 17:30:00 | QQQ | ETF | 37.09 | 37.12 | 37.09 | 37.12 | 21800.0 |
| 2004-01-05 18:00:00 | QQQ | ETF | 37.12 | 37.12 | 37.1 | 37.11 | 11200.0 |
| 2004-01-05 18:30:00 | QQQ | ETF | 37.09 | 37.09 | 37.09 | 37.09 | 1800.0 |
| 2004-01-05 19:00:00 | QQQ | ETF | 37.1 | 37.12 | 37.1 | 37.12 | 400.0 |
| 2004-01-05 19:30:00 | QQQ | ETF | 37.12 | 37.14 | 37.12 | 37.13 | 7600.0 |
| 2004-01-05 08:30:00 | IWM | ETF | 56.285 | 56.29 | 56.265 | 56.29 | 28000.0 |
| 2004-01-05 09:00:00 | IWM | ETF | 56.3 | 56.3 | 56.3 | 56.3 | 20000.0 |
> showing 50 of 1,178 rows — these rows as CSV