PREVIEW / etf_30min / 2004-06-30
file: by_date/etf_30min/2004/2004-06-30.parquet size: 36 KB rows: 1,188
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-06-30 08:00:00 | SPY | ETF | 114.04 | 114.06 | 114.01 | 114.01 | 11000.0 |
| 2004-06-30 08:30:00 | SPY | ETF | 114.06 | 114.1 | 114.06 | 114.07 | 54500.0 |
| 2004-06-30 09:00:00 | SPY | ETF | 114.02 | 114.11 | 114.01 | 114.11 | 75800.0 |
| 2004-06-30 09:30:00 | SPY | ETF | 114.07 | 114.2 | 113.93 | 114.11 | 3290700.0 |
| 2004-06-30 10:00:00 | SPY | ETF | 114.12 | 114.12 | 113.84 | 113.99 | 3791600.0 |
| 2004-06-30 10:30:00 | SPY | ETF | 113.99 | 114.08 | 113.92 | 114.01 | 1676200.0 |
| 2004-06-30 11:00:00 | SPY | ETF | 114.01 | 114.03 | 113.86 | 113.86 | 1541400.0 |
| 2004-06-30 11:30:00 | SPY | ETF | 113.85 | 113.86 | 113.65 | 113.78 | 1793500.0 |
| 2004-06-30 12:00:00 | SPY | ETF | 113.77 | 113.83 | 113.7 | 113.83 | 1005000.0 |
| 2004-06-30 12:30:00 | SPY | ETF | 113.83 | 113.88 | 113.79 | 113.83 | 961300.0 |
| 2004-06-30 13:00:00 | SPY | ETF | 113.82 | 113.93 | 113.78 | 113.85 | 1226600.0 |
| 2004-06-30 13:30:00 | SPY | ETF | 113.86 | 113.9 | 113.7 | 113.75 | 3073800.0 |
| 2004-06-30 14:00:00 | SPY | ETF | 113.74 | 114.34 | 113.72 | 114.0715 | 7721700.0 |
| 2004-06-30 14:30:00 | SPY | ETF | 114.05 | 114.34 | 113.97 | 114.27 | 4705600.0 |
| 2004-06-30 15:00:00 | SPY | ETF | 114.27 | 114.55 | 114.13 | 114.44 | 4807300.0 |
| 2004-06-30 15:30:00 | SPY | ETF | 114.51 | 114.79 | 114.4 | 114.45 | 5601300.0 |
| 2004-06-30 16:00:00 | SPY | ETF | 114.42 | 114.59 | 114.39 | 114.48 | 5872700.0 |
| 2004-06-30 16:30:00 | SPY | ETF | 114.5 | 114.5 | 114.35 | 114.39 | 199400.0 |
| 2004-06-30 17:00:00 | SPY | ETF | 114.39 | 114.43 | 114.37 | 114.43 | 120400.0 |
| 2004-06-30 17:30:00 | SPY | ETF | 114.4 | 114.43 | 114.39 | 114.39 | 71900.0 |
| 2004-06-30 18:00:00 | SPY | ETF | 114.43 | 114.45 | 114.39 | 114.39 | 307100.0 |
| 2004-06-30 18:30:00 | SPY | ETF | 114.4 | 114.45 | 114.4 | 114.45 | 500.0 |
| 2004-06-30 08:00:00 | QQQ | ETF | 37.47 | 37.47 | 37.45 | 37.46 | 7300.0 |
| 2004-06-30 08:30:00 | QQQ | ETF | 37.45 | 37.45 | 37.45 | 37.45 | 50400.0 |
| 2004-06-30 09:00:00 | QQQ | ETF | 37.44 | 37.46 | 37.43 | 37.46 | 82400.0 |
| 2004-06-30 09:30:00 | QQQ | ETF | 37.45 | 37.56 | 37.403 | 37.5 | 11614000.0 |
| 2004-06-30 10:00:00 | QQQ | ETF | 37.512 | 37.515 | 37.37 | 37.459 | 7258000.0 |
| 2004-06-30 10:30:00 | QQQ | ETF | 37.459 | 37.49 | 37.41 | 37.45 | 4249800.0 |
| 2004-06-30 11:00:00 | QQQ | ETF | 37.45 | 37.47 | 37.4 | 37.413 | 2976900.0 |
| 2004-06-30 11:30:00 | QQQ | ETF | 37.42 | 37.42 | 37.35 | 37.4 | 4509300.0 |
| 2004-06-30 12:00:00 | QQQ | ETF | 37.41 | 37.43 | 37.3715 | 37.43 | 1023300.0 |
| 2004-06-30 12:30:00 | QQQ | ETF | 37.43 | 37.44 | 37.38 | 37.41 | 1706500.0 |
| 2004-06-30 13:00:00 | QQQ | ETF | 37.41 | 37.48 | 37.39 | 37.473 | 2186400.0 |
| 2004-06-30 13:30:00 | QQQ | ETF | 37.48 | 37.49 | 37.43 | 37.46 | 2318200.0 |
| 2004-06-30 14:00:00 | QQQ | ETF | 37.44 | 37.65 | 37.44 | 37.486 | 14527400.0 |
| 2004-06-30 14:30:00 | QQQ | ETF | 37.487 | 37.63 | 37.45 | 37.571 | 10785600.0 |
| 2004-06-30 15:00:00 | QQQ | ETF | 37.58 | 37.77 | 37.5 | 37.758 | 13120400.0 |
| 2004-06-30 15:30:00 | QQQ | ETF | 37.759 | 37.9 | 37.719 | 37.74 | 15056200.0 |
| 2004-06-30 16:00:00 | QQQ | ETF | 37.725 | 37.78 | 37.68 | 37.741 | 3310500.0 |
| 2004-06-30 16:30:00 | QQQ | ETF | 37.74 | 37.74 | 37.705 | 37.73 | 180300.0 |
| 2004-06-30 17:00:00 | QQQ | ETF | 37.72 | 37.73 | 37.692 | 37.71 | 92800.0 |
| 2004-06-30 17:30:00 | QQQ | ETF | 37.71 | 37.74 | 37.71 | 37.73 | 56300.0 |
| 2004-06-30 18:00:00 | QQQ | ETF | 37.73 | 37.76 | 37.71 | 37.76 | 17800.0 |
| 2004-06-30 18:30:00 | QQQ | ETF | 37.75 | 37.76 | 37.74 | 37.74 | 6100.0 |
| 2004-06-30 19:00:00 | QQQ | ETF | 37.74 | 37.74 | 37.72 | 37.72 | 10100.0 |
| 2004-06-30 19:30:00 | QQQ | ETF | 37.73 | 37.77 | 37.73 | 37.74 | 10600.0 |
| 2004-06-30 08:30:00 | IWM | ETF | 58.71 | 58.72 | 58.71 | 58.72 | 7000.0 |
| 2004-06-30 09:00:00 | IWM | ETF | 58.66 | 58.66 | 58.66 | 58.66 | 1000.0 |
| 2004-06-30 09:30:00 | IWM | ETF | 58.72 | 58.96 | 58.7 | 58.765 | 316200.0 |
| 2004-06-30 10:00:00 | IWM | ETF | 58.765 | 58.765 | 58.52 | 58.7 | 634000.0 |
> showing 50 of 1,188 rows — these rows as CSV