PREVIEW / etf_30min / 2003-05-21
file: by_date/etf_30min/2003/2003-05-21.parquet size: 22 KB rows: 637
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 |
|---|---|---|---|---|---|---|---|
| 2003-05-21 08:00:00 | SPY | ETF | 91.88 | 92.3 | 91.88 | 92.18 | 33000.0 |
| 2003-05-21 08:30:00 | SPY | ETF | 92.2 | 92.22 | 92.09 | 92.14 | 50200.0 |
| 2003-05-21 09:00:00 | SPY | ETF | 92.1 | 92.23 | 92.1 | 92.12 | 66300.0 |
| 2003-05-21 09:30:00 | SPY | ETF | 92.11 | 92.36 | 91.91 | 92.0 | 5344800.0 |
| 2003-05-21 10:00:00 | SPY | ETF | 92.0 | 92.7 | 91.96 | 92.23 | 5611800.0 |
| 2003-05-21 10:30:00 | SPY | ETF | 92.24 | 92.77 | 92.1 | 92.49 | 4807200.0 |
| 2003-05-21 11:00:00 | SPY | ETF | 92.49 | 92.51 | 92.0 | 92.22 | 1842300.0 |
| 2003-05-21 11:30:00 | SPY | ETF | 92.19 | 92.36 | 92.05 | 92.11 | 1034500.0 |
| 2003-05-21 12:00:00 | SPY | ETF | 92.11 | 92.46 | 92.05 | 92.45 | 1070900.0 |
| 2003-05-21 12:30:00 | SPY | ETF | 92.45 | 92.88 | 92.38 | 92.72 | 2930900.0 |
| 2003-05-21 13:00:00 | SPY | ETF | 92.72 | 92.82 | 92.47 | 92.69 | 1476600.0 |
| 2003-05-21 13:30:00 | SPY | ETF | 92.72 | 92.75 | 92.36 | 92.43 | 1167900.0 |
| 2003-05-21 14:00:00 | SPY | ETF | 92.43 | 92.82 | 92.33 | 92.8 | 2031400.0 |
| 2003-05-21 14:30:00 | SPY | ETF | 92.8 | 92.82 | 92.55 | 92.73 | 1758100.0 |
| 2003-05-21 15:00:00 | SPY | ETF | 92.71 | 92.81 | 92.49 | 92.67 | 2443500.0 |
| 2003-05-21 15:30:00 | SPY | ETF | 92.67 | 92.83 | 92.6 | 92.77 | 4661200.0 |
| 2003-05-21 16:00:00 | SPY | ETF | 92.78 | 92.81 | 92.61 | 92.7 | 1264700.0 |
| 2003-05-21 16:30:00 | SPY | ETF | 92.7 | 92.7 | 92.65 | 92.67 | 1160000.0 |
| 2003-05-21 17:00:00 | SPY | ETF | 92.67 | 92.7 | 92.58 | 92.62 | 101500.0 |
| 2003-05-21 17:30:00 | SPY | ETF | 92.62 | 92.71 | 92.48 | 92.51 | 335400.0 |
| 2003-05-21 18:00:00 | SPY | ETF | 92.53 | 92.58 | 92.48 | 92.54 | 19800.0 |
| 2003-05-21 18:30:00 | SPY | ETF | 92.55 | 92.6 | 92.53 | 92.53 | 3000.0 |
| 2003-05-21 19:00:00 | SPY | ETF | 92.48 | 92.53 | 92.48 | 92.53 | 4300.0 |
| 2003-05-21 19:30:00 | SPY | ETF | 92.52 | 92.56 | 92.52 | 92.56 | 2700.0 |
| 2003-05-21 08:00:00 | QQQ | ETF | 27.57 | 27.76 | 27.56 | 27.76 | 124300.0 |
| 2003-05-21 08:30:00 | QQQ | ETF | 27.7 | 27.71 | 27.66 | 27.69 | 20200.0 |
| 2003-05-21 09:00:00 | QQQ | ETF | 27.68 | 27.71 | 27.66 | 27.66 | 82400.0 |
| 2003-05-21 09:30:00 | QQQ | ETF | 27.65 | 27.74 | 27.46 | 27.47 | 8585000.0 |
| 2003-05-21 10:00:00 | QQQ | ETF | 27.48 | 27.75 | 27.45 | 27.59 | 6417800.0 |
| 2003-05-21 10:30:00 | QQQ | ETF | 27.59 | 27.7 | 27.51 | 27.57 | 5088200.0 |
| 2003-05-21 11:00:00 | QQQ | ETF | 27.57 | 27.59 | 27.45 | 27.51 | 4159500.0 |
| 2003-05-21 11:30:00 | QQQ | ETF | 27.51 | 27.58 | 27.48 | 27.5 | 2022300.0 |
| 2003-05-21 12:00:00 | QQQ | ETF | 27.5 | 27.56 | 27.44 | 27.55 | 1822800.0 |
| 2003-05-21 12:30:00 | QQQ | ETF | 27.55 | 27.69 | 27.53 | 27.63 | 5328000.0 |
| 2003-05-21 13:00:00 | QQQ | ETF | 27.63 | 27.69 | 27.56 | 27.62 | 3155000.0 |
| 2003-05-21 13:30:00 | QQQ | ETF | 27.62 | 27.63 | 27.5 | 27.52 | 2398400.0 |
| 2003-05-21 14:00:00 | QQQ | ETF | 27.5 | 27.7 | 27.47 | 27.67 | 4224500.0 |
| 2003-05-21 14:30:00 | QQQ | ETF | 27.66 | 27.69 | 27.59 | 27.64 | 2306400.0 |
| 2003-05-21 15:00:00 | QQQ | ETF | 27.64 | 27.65 | 27.55 | 27.62 | 1885400.0 |
| 2003-05-21 15:30:00 | QQQ | ETF | 27.64 | 27.73 | 27.59 | 27.71 | 5273000.0 |
| 2003-05-21 16:00:00 | QQQ | ETF | 27.71 | 27.73 | 27.66 | 27.68 | 917300.0 |
| 2003-05-21 16:30:00 | QQQ | ETF | 27.68 | 27.7 | 27.66 | 27.7 | 40500.0 |
| 2003-05-21 17:00:00 | QQQ | ETF | 27.7 | 27.71 | 27.64 | 27.65 | 99300.0 |
| 2003-05-21 17:30:00 | QQQ | ETF | 27.67 | 27.67 | 27.62 | 27.63 | 239500.0 |
| 2003-05-21 18:00:00 | QQQ | ETF | 27.63 | 27.64 | 27.59 | 27.61 | 132000.0 |
| 2003-05-21 18:30:00 | QQQ | ETF | 27.61 | 27.64 | 27.6 | 27.6 | 29500.0 |
| 2003-05-21 19:00:00 | QQQ | ETF | 27.62 | 27.62 | 27.57 | 27.58 | 21800.0 |
| 2003-05-21 19:30:00 | QQQ | ETF | 27.58 | 27.6 | 27.58 | 27.59 | 10400.0 |
| 2003-05-21 20:00:00 | QQQ | ETF | 27.59 | 27.59 | 27.58 | 27.58 | 600.0 |
| 2003-05-21 09:00:00 | IWM | ETF | 40.705 | 40.705 | 40.705 | 40.705 | 1000.0 |
> showing 50 of 637 rows — these rows as CSV