PREVIEW / etf_30min / 2004-09-22
file: by_date/etf_30min/2004/2004-09-22.parquet size: 36 KB rows: 1,189
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-09-22 08:00:00 | SPY | ETF | 112.73 | 112.75 | 112.58 | 112.65 | 157500.0 |
| 2004-09-22 08:30:00 | SPY | ETF | 112.67 | 112.68 | 112.48 | 112.5 | 88600.0 |
| 2004-09-22 09:00:00 | SPY | ETF | 112.49 | 112.53 | 112.47 | 112.48 | 25700.0 |
| 2004-09-22 09:30:00 | SPY | ETF | 112.5 | 112.52 | 112.18 | 112.31 | 8091700.0 |
| 2004-09-22 10:00:00 | SPY | ETF | 112.33 | 112.33 | 111.88 | 112.02 | 6614200.0 |
| 2004-09-22 10:30:00 | SPY | ETF | 112.02 | 112.11 | 111.86 | 111.89 | 3886600.0 |
| 2004-09-22 11:00:00 | SPY | ETF | 111.88 | 111.95 | 111.78 | 111.91 | 2830800.0 |
| 2004-09-22 11:30:00 | SPY | ETF | 111.9 | 111.95 | 111.71 | 111.76 | 2131900.0 |
| 2004-09-22 12:00:00 | SPY | ETF | 111.74 | 111.94 | 111.73 | 111.91 | 2694300.0 |
| 2004-09-22 12:30:00 | SPY | ETF | 111.91 | 111.97 | 111.86 | 111.88 | 1641200.0 |
| 2004-09-22 13:00:00 | SPY | ETF | 111.88 | 112.02 | 111.85 | 111.9 | 957700.0 |
| 2004-09-22 13:30:00 | SPY | ETF | 111.89 | 111.97 | 111.69 | 111.71 | 1966500.0 |
| 2004-09-22 14:00:00 | SPY | ETF | 111.72 | 111.85 | 111.58 | 111.8 | 3396300.0 |
| 2004-09-22 14:30:00 | SPY | ETF | 111.8 | 111.88 | 111.65 | 111.73 | 1776700.0 |
| 2004-09-22 15:00:00 | SPY | ETF | 111.74 | 111.78 | 111.53 | 111.59 | 3399300.0 |
| 2004-09-22 15:30:00 | SPY | ETF | 111.64 | 111.72 | 111.5 | 111.63 | 5298500.0 |
| 2004-09-22 16:00:00 | SPY | ETF | 111.63 | 111.63 | 111.48 | 111.48 | 2030300.0 |
| 2004-09-22 16:30:00 | SPY | ETF | 111.52 | 111.62 | 111.49 | 111.55 | 234300.0 |
| 2004-09-22 17:00:00 | SPY | ETF | 111.55 | 111.62 | 111.51 | 111.62 | 138000.0 |
| 2004-09-22 17:30:00 | SPY | ETF | 111.5 | 111.55 | 111.5 | 111.55 | 4200.0 |
| 2004-09-22 18:00:00 | SPY | ETF | 111.53 | 111.53 | 111.52 | 111.52 | 7200.0 |
| 2004-09-22 19:30:00 | SPY | ETF | 111.51 | 111.51 | 111.51 | 111.51 | 800.0 |
| 2004-09-22 08:00:00 | QQQ | ETF | 35.51 | 35.52 | 35.44 | 35.47 | 98700.0 |
| 2004-09-22 08:30:00 | QQQ | ETF | 35.47 | 35.49 | 35.4 | 35.4 | 183300.0 |
| 2004-09-22 09:00:00 | QQQ | ETF | 35.4 | 35.45 | 35.39 | 35.44 | 140400.0 |
| 2004-09-22 09:30:00 | QQQ | ETF | 35.44 | 35.46 | 35.27 | 35.38 | 14610800.0 |
| 2004-09-22 10:00:00 | QQQ | ETF | 35.369 | 35.38 | 35.13 | 35.201 | 13773600.0 |
| 2004-09-22 10:30:00 | QQQ | ETF | 35.201 | 35.23 | 35.04 | 35.07 | 12092800.0 |
| 2004-09-22 11:00:00 | QQQ | ETF | 35.07 | 35.12 | 35.03 | 35.11 | 6559000.0 |
| 2004-09-22 11:30:00 | QQQ | ETF | 35.1 | 35.11 | 35.015 | 35.03 | 4269100.0 |
| 2004-09-22 12:00:00 | QQQ | ETF | 35.03 | 35.11 | 35.03 | 35.1 | 3563400.0 |
| 2004-09-22 12:30:00 | QQQ | ETF | 35.09 | 35.1 | 35.05 | 35.052 | 2461700.0 |
| 2004-09-22 13:00:00 | QQQ | ETF | 35.05 | 35.16 | 35.05 | 35.09 | 4008600.0 |
| 2004-09-22 13:30:00 | QQQ | ETF | 35.09 | 35.14 | 35.01 | 35.02 | 4682000.0 |
| 2004-09-22 14:00:00 | QQQ | ETF | 35.02 | 35.02 | 34.92 | 34.979 | 9198400.0 |
| 2004-09-22 14:30:00 | QQQ | ETF | 34.98 | 35.05 | 34.96 | 35.0 | 3825900.0 |
| 2004-09-22 15:00:00 | QQQ | ETF | 35.0 | 35.03 | 34.91 | 34.93 | 5349600.0 |
| 2004-09-22 15:30:00 | QQQ | ETF | 34.925 | 34.98 | 34.87 | 34.95 | 10822900.0 |
| 2004-09-22 16:00:00 | QQQ | ETF | 34.941 | 34.98 | 34.93 | 34.95 | 3590300.0 |
| 2004-09-22 16:30:00 | QQQ | ETF | 34.93 | 34.98 | 34.92 | 34.97 | 365400.0 |
| 2004-09-22 17:00:00 | QQQ | ETF | 34.96 | 34.98 | 34.95 | 34.98 | 53900.0 |
| 2004-09-22 17:30:00 | QQQ | ETF | 34.97 | 34.98 | 34.95 | 34.98 | 55400.0 |
| 2004-09-22 18:00:00 | QQQ | ETF | 34.97 | 34.97 | 34.93 | 34.96 | 25100.0 |
| 2004-09-22 18:30:00 | QQQ | ETF | 34.95 | 34.95 | 34.93 | 34.94 | 13300.0 |
| 2004-09-22 19:00:00 | QQQ | ETF | 34.94 | 34.96 | 34.94 | 34.95 | 16800.0 |
| 2004-09-22 19:30:00 | QQQ | ETF | 34.95 | 34.95 | 34.93 | 34.94 | 24200.0 |
| 2004-09-22 08:30:00 | IWM | ETF | 57.06 | 57.06 | 57.06 | 57.06 | 1000.0 |
| 2004-09-22 09:00:00 | IWM | ETF | 57.12 | 57.12 | 57.12 | 57.12 | 400.0 |
| 2004-09-22 09:30:00 | IWM | ETF | 57.015 | 57.055 | 56.77 | 56.895 | 2422200.0 |
| 2004-09-22 10:00:00 | IWM | ETF | 56.92 | 56.925 | 56.57 | 56.69 | 1859800.0 |
> showing 50 of 1,189 rows — these rows as CSV