PREVIEW / etf_30min / 2004-04-01
file: by_date/etf_30min/2004/2004-04-01.parquet size: 35 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-04-01 08:00:00 | SPY | ETF | 112.87 | 112.95 | 112.87 | 112.95 | 10100.0 |
| 2004-04-01 08:30:00 | SPY | ETF | 112.91 | 113.15 | 112.91 | 113.13 | 74600.0 |
| 2004-04-01 09:00:00 | SPY | ETF | 113.11 | 113.12 | 113.05 | 113.07 | 28500.0 |
| 2004-04-01 09:30:00 | SPY | ETF | 113.07 | 113.32 | 113.05 | 113.17 | 5122600.0 |
| 2004-04-01 10:00:00 | SPY | ETF | 113.17 | 113.68 | 113.16 | 113.66 | 8706700.0 |
| 2004-04-01 10:30:00 | SPY | ETF | 113.66 | 113.87 | 113.55 | 113.76 | 5106100.0 |
| 2004-04-01 11:00:00 | SPY | ETF | 113.76 | 113.84 | 113.58 | 113.67 | 2660100.0 |
| 2004-04-01 11:30:00 | SPY | ETF | 113.67 | 113.7 | 113.57 | 113.6 | 1709700.0 |
| 2004-04-01 12:00:00 | SPY | ETF | 113.62 | 113.68 | 113.45 | 113.54 | 1656300.0 |
| 2004-04-01 12:30:00 | SPY | ETF | 113.53 | 113.54 | 113.26 | 113.34 | 2351200.0 |
| 2004-04-01 13:00:00 | SPY | ETF | 113.36 | 113.56 | 113.34 | 113.52 | 1218800.0 |
| 2004-04-01 13:30:00 | SPY | ETF | 113.54 | 113.7 | 113.5 | 113.61 | 891800.0 |
| 2004-04-01 14:00:00 | SPY | ETF | 113.62 | 113.73 | 113.53 | 113.67 | 1245100.0 |
| 2004-04-01 14:30:00 | SPY | ETF | 113.67 | 113.71 | 113.4 | 113.43 | 1903400.0 |
| 2004-04-01 15:00:00 | SPY | ETF | 113.43 | 113.6 | 113.21 | 113.32 | 2349500.0 |
| 2004-04-01 15:30:00 | SPY | ETF | 113.32 | 113.56 | 113.25 | 113.49 | 5236200.0 |
| 2004-04-01 16:00:00 | SPY | ETF | 113.5 | 113.78 | 113.47 | 113.76 | 2287200.0 |
| 2004-04-01 16:30:00 | SPY | ETF | 113.72 | 113.74 | 113.4605 | 113.7 | 117300.0 |
| 2004-04-01 17:00:00 | SPY | ETF | 113.69 | 113.72 | 113.66 | 113.72 | 28400.0 |
| 2004-04-01 17:30:00 | SPY | ETF | 113.71 | 113.71 | 113.65 | 113.65 | 600.0 |
| 2004-04-01 18:00:00 | SPY | ETF | 113.73 | 113.75 | 113.72 | 113.74 | 9200.0 |
| 2004-04-01 18:30:00 | SPY | ETF | 113.74 | 113.74 | 113.69 | 113.72 | 1300.0 |
| 2004-04-01 19:00:00 | SPY | ETF | 113.72 | 113.72 | 113.72 | 113.72 | 100.0 |
| 2004-04-01 19:30:00 | SPY | ETF | 113.73 | 113.78 | 113.73 | 113.78 | 24900.0 |
| 2004-04-01 08:00:00 | QQQ | ETF | 35.74 | 35.76 | 35.72 | 35.74 | 57200.0 |
| 2004-04-01 08:30:00 | QQQ | ETF | 35.76 | 35.85 | 35.76 | 35.85 | 133900.0 |
| 2004-04-01 09:00:00 | QQQ | ETF | 35.85 | 35.85 | 35.81 | 35.81 | 61000.0 |
| 2004-04-01 09:30:00 | QQQ | ETF | 35.81 | 35.94 | 35.78 | 35.821 | 9857400.0 |
| 2004-04-01 10:00:00 | QQQ | ETF | 35.824 | 36.097 | 35.824 | 36.09 | 14139900.0 |
| 2004-04-01 10:30:00 | QQQ | ETF | 36.09 | 36.25 | 36.07 | 36.17 | 15217000.0 |
| 2004-04-01 11:00:00 | QQQ | ETF | 36.18 | 36.23 | 36.053 | 36.11 | 5953300.0 |
| 2004-04-01 11:30:00 | QQQ | ETF | 36.109 | 36.13 | 36.02 | 36.04 | 3863300.0 |
| 2004-04-01 12:00:00 | QQQ | ETF | 36.04 | 36.08 | 35.97 | 36.05 | 4932900.0 |
| 2004-04-01 12:30:00 | QQQ | ETF | 36.049 | 36.05 | 35.92 | 35.95 | 3801900.0 |
| 2004-04-01 13:00:00 | QQQ | ETF | 35.95 | 36.051 | 35.95 | 36.048 | 2990000.0 |
| 2004-04-01 13:30:00 | QQQ | ETF | 36.05 | 36.09 | 35.996 | 36.06 | 2417800.0 |
| 2004-04-01 14:00:00 | QQQ | ETF | 36.06 | 36.15 | 35.97 | 36.13 | 3986000.0 |
| 2004-04-01 14:30:00 | QQQ | ETF | 36.12 | 36.16 | 36.0 | 36.032 | 3838900.0 |
| 2004-04-01 15:00:00 | QQQ | ETF | 36.032 | 36.1 | 35.96 | 35.981 | 4673200.0 |
| 2004-04-01 15:30:00 | QQQ | ETF | 35.98 | 36.113 | 35.96 | 36.08 | 9788400.0 |
| 2004-04-01 16:00:00 | QQQ | ETF | 36.1 | 36.2 | 36.08 | 36.16 | 3489800.0 |
| 2004-04-01 16:30:00 | QQQ | ETF | 36.17 | 36.2 | 36.12 | 36.19 | 321300.0 |
| 2004-04-01 17:00:00 | QQQ | ETF | 36.18 | 36.2 | 36.18 | 36.19 | 93100.0 |
| 2004-04-01 17:30:00 | QQQ | ETF | 36.19 | 36.191 | 36.15 | 36.15 | 19300.0 |
| 2004-04-01 18:00:00 | QQQ | ETF | 36.19 | 36.2 | 36.17 | 36.2 | 32500.0 |
| 2004-04-01 18:30:00 | QQQ | ETF | 36.18 | 36.21 | 36.18 | 36.2 | 10000.0 |
| 2004-04-01 19:00:00 | QQQ | ETF | 36.2 | 36.21 | 36.2 | 36.21 | 3900.0 |
| 2004-04-01 19:30:00 | QQQ | ETF | 36.21 | 36.21 | 36.2 | 36.2 | 1700.0 |
| 2004-04-01 08:30:00 | IWM | ETF | 58.745 | 58.79 | 58.745 | 58.745 | 9400.0 |
| 2004-04-01 09:00:00 | IWM | ETF | 58.88 | 58.88 | 58.88 | 58.88 | 5000.0 |
> showing 50 of 1,188 rows — these rows as CSV