PREVIEW / etf_30min / 2004-10-28
file: by_date/etf_30min/2004/2004-10-28.parquet size: 38 KB rows: 1,273
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-10-28 08:00:00 | SPY | ETF | 112.63 | 112.66 | 112.58 | 112.6 | 199700.0 |
| 2004-10-28 08:30:00 | SPY | ETF | 112.57 | 112.77 | 112.52 | 112.75 | 303100.0 |
| 2004-10-28 09:00:00 | SPY | ETF | 112.72 | 112.75 | 112.69 | 112.75 | 124600.0 |
| 2004-10-28 09:30:00 | SPY | ETF | 112.78 | 112.9 | 112.52 | 112.81 | 6312100.0 |
| 2004-10-28 10:00:00 | SPY | ETF | 112.8 | 112.93 | 112.5 | 112.62 | 6812900.0 |
| 2004-10-28 10:30:00 | SPY | ETF | 112.62 | 112.88 | 112.49 | 112.86 | 3173000.0 |
| 2004-10-28 11:00:00 | SPY | ETF | 112.86 | 113.18 | 112.67 | 113.08 | 6698100.0 |
| 2004-10-28 11:30:00 | SPY | ETF | 113.08 | 113.15 | 112.83 | 112.97 | 2784400.0 |
| 2004-10-28 12:00:00 | SPY | ETF | 112.99 | 113.04 | 112.8 | 112.9 | 1650000.0 |
| 2004-10-28 12:30:00 | SPY | ETF | 112.88 | 113.1 | 112.88 | 113.07 | 1920800.0 |
| 2004-10-28 13:00:00 | SPY | ETF | 113.07 | 113.22 | 112.96 | 113.22 | 1932600.0 |
| 2004-10-28 13:30:00 | SPY | ETF | 113.22 | 113.3 | 113.17 | 113.24 | 2587300.0 |
| 2004-10-28 14:00:00 | SPY | ETF | 113.25 | 113.55 | 113.18 | 113.53 | 3710200.0 |
| 2004-10-28 14:30:00 | SPY | ETF | 113.51 | 113.56 | 113.25 | 113.26 | 3758900.0 |
| 2004-10-28 15:00:00 | SPY | ETF | 113.26 | 113.33 | 112.95 | 113.02 | 4794600.0 |
| 2004-10-28 15:30:00 | SPY | ETF | 113.01 | 113.19 | 112.91 | 113.17 | 4142200.0 |
| 2004-10-28 16:00:00 | SPY | ETF | 113.17 | 113.25 | 113.16 | 113.21 | 1775800.0 |
| 2004-10-28 16:30:00 | SPY | ETF | 113.21 | 113.23 | 113.15 | 113.22 | 135700.0 |
| 2004-10-28 17:00:00 | SPY | ETF | 113.22 | 113.22 | 113.15 | 113.21 | 34800.0 |
| 2004-10-28 17:30:00 | SPY | ETF | 113.16 | 113.16 | 113.16 | 113.16 | 700.0 |
| 2004-10-28 18:00:00 | SPY | ETF | 113.2 | 113.21 | 113.2 | 113.2 | 12500.0 |
| 2004-10-28 19:30:00 | SPY | ETF | 113.18 | 113.18 | 113.18 | 113.18 | 1000.0 |
| 2004-10-28 08:00:00 | QQQ | ETF | 36.6 | 36.64 | 36.6 | 36.63 | 190200.0 |
| 2004-10-28 08:30:00 | QQQ | ETF | 36.63 | 36.71 | 36.6 | 36.69 | 375300.0 |
| 2004-10-28 09:00:00 | QQQ | ETF | 36.69 | 36.69 | 36.67 | 36.68 | 192900.0 |
| 2004-10-28 09:30:00 | QQQ | ETF | 36.68 | 36.83 | 36.57 | 36.807 | 17409400.0 |
| 2004-10-28 10:00:00 | QQQ | ETF | 36.8 | 36.83 | 36.6 | 36.67 | 9252100.0 |
| 2004-10-28 10:30:00 | QQQ | ETF | 36.668 | 36.84 | 36.6 | 36.84 | 7419500.0 |
| 2004-10-28 11:00:00 | QQQ | ETF | 36.835 | 36.94 | 36.7 | 36.89 | 9951500.0 |
| 2004-10-28 11:30:00 | QQQ | ETF | 36.89 | 36.92 | 36.72 | 36.76 | 5882400.0 |
| 2004-10-28 12:00:00 | QQQ | ETF | 36.76 | 36.79 | 36.63 | 36.66 | 4123900.0 |
| 2004-10-28 12:30:00 | QQQ | ETF | 36.66 | 36.82 | 36.657 | 36.808 | 3781000.0 |
| 2004-10-28 13:00:00 | QQQ | ETF | 36.808 | 36.88 | 36.74 | 36.86 | 3629200.0 |
| 2004-10-28 13:30:00 | QQQ | ETF | 36.86 | 36.92 | 36.8 | 36.89 | 6994000.0 |
| 2004-10-28 14:00:00 | QQQ | ETF | 36.9 | 37.12 | 36.87 | 37.06 | 10677500.0 |
| 2004-10-28 14:30:00 | QQQ | ETF | 37.061 | 37.09 | 36.96 | 36.971 | 5464800.0 |
| 2004-10-28 15:00:00 | QQQ | ETF | 36.97 | 37.0 | 36.8 | 36.85 | 10736900.0 |
| 2004-10-28 15:30:00 | QQQ | ETF | 36.85 | 36.94 | 36.78 | 36.93 | 9297700.0 |
| 2004-10-28 16:00:00 | QQQ | ETF | 36.93 | 36.98 | 36.89 | 36.97 | 2640100.0 |
| 2004-10-28 16:30:00 | QQQ | ETF | 36.97 | 36.98 | 36.95 | 36.96 | 50400.0 |
| 2004-10-28 17:00:00 | QQQ | ETF | 36.97 | 36.97 | 36.95 | 36.95 | 21900.0 |
| 2004-10-28 17:30:00 | QQQ | ETF | 36.96 | 36.98 | 36.96 | 36.98 | 8900.0 |
| 2004-10-28 18:00:00 | QQQ | ETF | 36.98 | 36.98 | 36.96 | 36.96 | 28400.0 |
| 2004-10-28 18:30:00 | QQQ | ETF | 36.98 | 36.98 | 36.97 | 36.97 | 1900.0 |
| 2004-10-28 19:00:00 | QQQ | ETF | 36.97 | 36.98 | 36.96 | 36.98 | 10600.0 |
| 2004-10-28 19:30:00 | QQQ | ETF | 36.97 | 36.97 | 36.96 | 36.96 | 1500.0 |
| 2004-10-28 08:00:00 | IWM | ETF | 58.21 | 58.21 | 58.2 | 58.2 | 2800.0 |
| 2004-10-28 09:00:00 | IWM | ETF | 58.25 | 58.25 | 58.24 | 58.24 | 2400.0 |
| 2004-10-28 09:30:00 | IWM | ETF | 58.475 | 58.485 | 58.22 | 58.275 | 1949600.0 |
| 2004-10-28 10:00:00 | IWM | ETF | 58.26 | 58.375 | 57.97 | 58.1 | 1110800.0 |
> showing 50 of 1,273 rows — these rows as CSV