PREVIEW / etf_30min / 2004-03-16
file: by_date/etf_30min/2004/2004-03-16.parquet size: 37 KB rows: 1,211
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-03-16 08:00:00 | SPY | ETF | 111.62 | 111.89 | 111.62 | 111.83 | 71100.0 |
| 2004-03-16 08:30:00 | SPY | ETF | 111.82 | 111.85 | 111.75 | 111.79 | 63500.0 |
| 2004-03-16 09:00:00 | SPY | ETF | 111.79 | 111.86 | 111.78 | 111.8 | 96800.0 |
| 2004-03-16 09:30:00 | SPY | ETF | 111.78 | 112.06 | 111.73 | 111.85 | 5993900.0 |
| 2004-03-16 10:00:00 | SPY | ETF | 111.85 | 111.98 | 111.67 | 111.8 | 4623200.0 |
| 2004-03-16 10:30:00 | SPY | ETF | 111.79 | 111.98 | 111.68 | 111.78 | 2340700.0 |
| 2004-03-16 11:00:00 | SPY | ETF | 111.78 | 111.89 | 111.69 | 111.79 | 1768600.0 |
| 2004-03-16 11:30:00 | SPY | ETF | 111.79 | 111.83 | 111.54 | 111.67 | 3623800.0 |
| 2004-03-16 12:00:00 | SPY | ETF | 111.68 | 111.68 | 111.3 | 111.44 | 3866200.0 |
| 2004-03-16 12:30:00 | SPY | ETF | 111.44 | 111.48 | 111.29 | 111.36 | 1668200.0 |
| 2004-03-16 13:00:00 | SPY | ETF | 111.37 | 111.69 | 111.31 | 111.61 | 2221300.0 |
| 2004-03-16 13:30:00 | SPY | ETF | 111.61 | 111.62 | 111.49 | 111.53 | 744900.0 |
| 2004-03-16 14:00:00 | SPY | ETF | 111.54 | 112.0 | 111.33 | 111.64 | 7095700.0 |
| 2004-03-16 14:30:00 | SPY | ETF | 111.62 | 111.73 | 110.87 | 110.99 | 8338100.0 |
| 2004-03-16 15:00:00 | SPY | ETF | 110.96 | 111.56 | 110.84 | 111.42 | 5147100.0 |
| 2004-03-16 15:30:00 | SPY | ETF | 111.45 | 111.95 | 111.42 | 111.73 | 5462000.0 |
| 2004-03-16 16:00:00 | SPY | ETF | 111.72 | 111.87 | 111.64 | 111.78 | 2131300.0 |
| 2004-03-16 16:30:00 | SPY | ETF | 111.77 | 111.82 | 111.71 | 111.74 | 286400.0 |
| 2004-03-16 17:00:00 | SPY | ETF | 111.7 | 111.77 | 111.7 | 111.77 | 1799000.0 |
| 2004-03-16 17:30:00 | SPY | ETF | 111.71 | 111.79 | 111.71 | 111.79 | 2400.0 |
| 2004-03-16 18:00:00 | SPY | ETF | 111.76 | 111.76 | 111.76 | 111.76 | 500.0 |
| 2004-03-16 18:30:00 | SPY | ETF | 111.72 | 111.72 | 111.71 | 111.71 | 500.0 |
| 2004-03-16 19:00:00 | SPY | ETF | 111.77 | 111.77 | 111.77 | 111.77 | 500.0 |
| 2004-03-16 19:30:00 | SPY | ETF | 111.77 | 111.78 | 111.75 | 111.75 | 4900.0 |
| 2004-03-16 08:00:00 | QQQ | ETF | 35.04 | 35.18 | 35.04 | 35.13 | 177300.0 |
| 2004-03-16 08:30:00 | QQQ | ETF | 35.13 | 35.15 | 35.1 | 35.12 | 159700.0 |
| 2004-03-16 09:00:00 | QQQ | ETF | 35.12 | 35.15 | 35.1 | 35.11 | 190100.0 |
| 2004-03-16 09:30:00 | QQQ | ETF | 35.11 | 35.25 | 35.1 | 35.16 | 17211400.0 |
| 2004-03-16 10:00:00 | QQQ | ETF | 35.17 | 35.22 | 35.039 | 35.145 | 7759800.0 |
| 2004-03-16 10:30:00 | QQQ | ETF | 35.14 | 35.21 | 35.06 | 35.089 | 6530000.0 |
| 2004-03-16 11:00:00 | QQQ | ETF | 35.087 | 35.15 | 35.05 | 35.08 | 5213400.0 |
| 2004-03-16 11:30:00 | QQQ | ETF | 35.09 | 35.09 | 34.948 | 35.01 | 6066900.0 |
| 2004-03-16 12:00:00 | QQQ | ETF | 35.01 | 35.03 | 34.85 | 34.9 | 6581800.0 |
| 2004-03-16 12:30:00 | QQQ | ETF | 34.903 | 34.94 | 34.83 | 34.85 | 4797300.0 |
| 2004-03-16 13:00:00 | QQQ | ETF | 34.85 | 35.03 | 34.84 | 34.99 | 7127600.0 |
| 2004-03-16 13:30:00 | QQQ | ETF | 34.98 | 35.0 | 34.92 | 34.969 | 1993200.0 |
| 2004-03-16 14:00:00 | QQQ | ETF | 34.969 | 35.11 | 34.9 | 34.925 | 8962100.0 |
| 2004-03-16 14:30:00 | QQQ | ETF | 34.95 | 35.04 | 34.68 | 34.7 | 11889300.0 |
| 2004-03-16 15:00:00 | QQQ | ETF | 34.7 | 34.932 | 34.63 | 34.85 | 10463700.0 |
| 2004-03-16 15:30:00 | QQQ | ETF | 34.858 | 35.109 | 34.85 | 35.004 | 16361300.0 |
| 2004-03-16 16:00:00 | QQQ | ETF | 35.005 | 35.01 | 34.92 | 34.94 | 2720900.0 |
| 2004-03-16 16:30:00 | QQQ | ETF | 34.95 | 34.98 | 34.95 | 34.965 | 208400.0 |
| 2004-03-16 17:00:00 | QQQ | ETF | 34.96 | 34.983 | 34.952 | 34.97 | 5756800.0 |
| 2004-03-16 17:30:00 | QQQ | ETF | 34.99 | 34.99 | 34.98 | 34.98 | 9900.0 |
| 2004-03-16 18:00:00 | QQQ | ETF | 34.98 | 34.98 | 34.96 | 34.97 | 54300.0 |
| 2004-03-16 18:30:00 | QQQ | ETF | 34.98 | 34.98 | 34.98 | 34.98 | 5600.0 |
| 2004-03-16 19:00:00 | QQQ | ETF | 34.98 | 35.0 | 34.98 | 35.0 | 8100.0 |
| 2004-03-16 19:30:00 | QQQ | ETF | 34.99 | 35.02 | 34.99 | 35.01 | 20500.0 |
| 2004-03-16 08:00:00 | IWM | ETF | 57.055 | 57.055 | 57.055 | 57.055 | 20000.0 |
| 2004-03-16 08:30:00 | IWM | ETF | 57.055 | 57.055 | 56.99 | 57.0 | 30000.0 |
> showing 50 of 1,211 rows — these rows as CSV