PREVIEW / etf_30min / 2004-05-05
file: by_date/etf_30min/2004/2004-05-05.parquet size: 35 KB rows: 1,150
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-05-05 08:00:00 | SPY | ETF | 112.18 | 112.34 | 112.18 | 112.34 | 25200.0 |
| 2004-05-05 08:30:00 | SPY | ETF | 112.31 | 112.4 | 112.3 | 112.4 | 5700.0 |
| 2004-05-05 09:00:00 | SPY | ETF | 112.38 | 112.51 | 112.37 | 112.42 | 221000.0 |
| 2004-05-05 09:30:00 | SPY | ETF | 112.41 | 112.6 | 112.16 | 112.49 | 4638500.0 |
| 2004-05-05 10:00:00 | SPY | ETF | 112.47 | 112.89 | 112.21 | 112.74 | 4981800.0 |
| 2004-05-05 10:30:00 | SPY | ETF | 112.73 | 112.81 | 112.51 | 112.64 | 2467500.0 |
| 2004-05-05 11:00:00 | SPY | ETF | 112.65 | 112.7 | 112.4 | 112.55 | 3257100.0 |
| 2004-05-05 11:30:00 | SPY | ETF | 112.56 | 112.81 | 112.55 | 112.7 | 1369100.0 |
| 2004-05-05 12:00:00 | SPY | ETF | 112.67 | 112.72 | 112.35 | 112.38 | 1667400.0 |
| 2004-05-05 12:30:00 | SPY | ETF | 112.4 | 112.48 | 112.25 | 112.34 | 1425300.0 |
| 2004-05-05 13:00:00 | SPY | ETF | 112.37 | 112.52 | 112.27 | 112.42 | 931200.0 |
| 2004-05-05 13:30:00 | SPY | ETF | 112.42 | 112.71 | 112.39 | 112.69 | 1692100.0 |
| 2004-05-05 14:00:00 | SPY | ETF | 112.71 | 112.91 | 112.59 | 112.79 | 2333900.0 |
| 2004-05-05 14:30:00 | SPY | ETF | 112.78 | 112.96 | 112.59 | 112.81 | 1782800.0 |
| 2004-05-05 15:00:00 | SPY | ETF | 112.8 | 112.9 | 112.58 | 112.76 | 2086000.0 |
| 2004-05-05 15:30:00 | SPY | ETF | 112.76 | 112.89 | 112.57 | 112.58 | 2081500.0 |
| 2004-05-05 16:00:00 | SPY | ETF | 112.61 | 112.8 | 112.52 | 112.77 | 1615700.0 |
| 2004-05-05 16:30:00 | SPY | ETF | 112.73 | 112.76 | 112.66 | 112.66 | 21300.0 |
| 2004-05-05 17:00:00 | SPY | ETF | 112.67 | 112.69 | 112.67 | 112.67 | 23600.0 |
| 2004-05-05 17:30:00 | SPY | ETF | 112.15 | 112.15 | 112.15 | 112.15 | 25000.0 |
| 2004-05-05 18:00:00 | SPY | ETF | 112.64 | 112.66 | 112.64 | 112.66 | 300.0 |
| 2004-05-05 18:30:00 | SPY | ETF | 112.67 | 112.67 | 112.67 | 112.67 | 200.0 |
| 2004-05-05 19:00:00 | SPY | ETF | 112.65 | 112.65 | 112.65 | 112.65 | 500.0 |
| 2004-05-05 08:00:00 | QQQ | ETF | 35.31 | 35.38 | 35.31 | 35.38 | 38900.0 |
| 2004-05-05 08:30:00 | QQQ | ETF | 35.38 | 35.42 | 35.37 | 35.4 | 56300.0 |
| 2004-05-05 09:00:00 | QQQ | ETF | 35.41 | 35.45 | 35.4 | 35.42 | 131800.0 |
| 2004-05-05 09:30:00 | QQQ | ETF | 35.42 | 35.49 | 35.2 | 35.4 | 12643600.0 |
| 2004-05-05 10:00:00 | QQQ | ETF | 35.413 | 35.62 | 35.29 | 35.559 | 9992600.0 |
| 2004-05-05 10:30:00 | QQQ | ETF | 35.55 | 35.58 | 35.419 | 35.54 | 5822000.0 |
| 2004-05-05 11:00:00 | QQQ | ETF | 35.535 | 35.57 | 35.441 | 35.53 | 4904300.0 |
| 2004-05-05 11:30:00 | QQQ | ETF | 35.53 | 35.64 | 35.51 | 35.54 | 5186500.0 |
| 2004-05-05 12:00:00 | QQQ | ETF | 35.54 | 35.56 | 35.42 | 35.447 | 6114200.0 |
| 2004-05-05 12:30:00 | QQQ | ETF | 35.448 | 35.49 | 35.3 | 35.38 | 10056900.0 |
| 2004-05-05 13:00:00 | QQQ | ETF | 35.37 | 35.42 | 35.34 | 35.404 | 4140500.0 |
| 2004-05-05 13:30:00 | QQQ | ETF | 35.405 | 35.56 | 35.38 | 35.53 | 5961000.0 |
| 2004-05-05 14:00:00 | QQQ | ETF | 35.52 | 35.657 | 35.49 | 35.61 | 6549000.0 |
| 2004-05-05 14:30:00 | QQQ | ETF | 35.61 | 35.7 | 35.51 | 35.62 | 5429100.0 |
| 2004-05-05 15:00:00 | QQQ | ETF | 35.619 | 35.69 | 35.52 | 35.615 | 5283300.0 |
| 2004-05-05 15:30:00 | QQQ | ETF | 35.615 | 35.68 | 35.51 | 35.526 | 5484900.0 |
| 2004-05-05 16:00:00 | QQQ | ETF | 35.54 | 35.576 | 35.352 | 35.56 | 4708200.0 |
| 2004-05-05 16:30:00 | QQQ | ETF | 35.56 | 35.59 | 35.54 | 35.56 | 120300.0 |
| 2004-05-05 17:00:00 | QQQ | ETF | 35.56 | 35.602 | 35.55 | 35.57 | 159400.0 |
| 2004-05-05 17:30:00 | QQQ | ETF | 35.58 | 35.6 | 35.57 | 35.57 | 17800.0 |
| 2004-05-05 18:00:00 | QQQ | ETF | 35.58 | 35.58 | 35.57 | 35.58 | 22400.0 |
| 2004-05-05 18:30:00 | QQQ | ETF | 35.57 | 35.57 | 35.56 | 35.56 | 1300.0 |
| 2004-05-05 19:00:00 | QQQ | ETF | 35.58 | 35.58 | 35.56 | 35.56 | 11100.0 |
| 2004-05-05 19:30:00 | QQQ | ETF | 35.57 | 35.57 | 35.57 | 35.57 | 3600.0 |
| 2004-05-05 08:30:00 | IWM | ETF | 56.8 | 56.8 | 56.8 | 56.8 | 600.0 |
| 2004-05-05 09:00:00 | IWM | ETF | 56.865 | 56.865 | 56.815 | 56.83 | 3200.0 |
| 2004-05-05 09:30:00 | IWM | ETF | 56.8 | 57.1 | 56.645 | 56.955 | 1482800.0 |
> showing 50 of 1,150 rows — these rows as CSV