PREVIEW / etf_30min / 2002-06-21
file: by_date/etf_30min/2002/2002-06-21.parquet size: 19 KB rows: 504
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 |
|---|---|---|---|---|---|---|---|
| 2002-06-21 09:30:00 | SPY | ETF | 100.47 | 100.57 | 99.9 | 100.45 | 5004300.0 |
| 2002-06-21 10:00:00 | SPY | ETF | 100.41 | 100.93 | 100.37 | 100.53 | 3368900.0 |
| 2002-06-21 10:30:00 | SPY | ETF | 100.52 | 100.6 | 100.13 | 100.39 | 2125100.0 |
| 2002-06-21 11:00:00 | SPY | ETF | 100.41 | 100.46 | 99.81 | 100.0 | 1405400.0 |
| 2002-06-21 11:30:00 | SPY | ETF | 99.96 | 99.99 | 99.52 | 99.85 | 2103500.0 |
| 2002-06-21 12:00:00 | SPY | ETF | 99.85 | 99.91 | 99.42 | 99.45 | 1012000.0 |
| 2002-06-21 12:30:00 | SPY | ETF | 99.47 | 99.75 | 99.33 | 99.55 | 1351600.0 |
| 2002-06-21 13:00:00 | SPY | ETF | 99.53 | 99.86 | 99.31 | 99.5 | 1218300.0 |
| 2002-06-21 13:30:00 | SPY | ETF | 99.5 | 99.88 | 99.4 | 99.85 | 858900.0 |
| 2002-06-21 14:00:00 | SPY | ETF | 99.88 | 99.97 | 99.41 | 99.66 | 1320200.0 |
| 2002-06-21 14:30:00 | SPY | ETF | 99.69 | 99.82 | 99.52 | 99.62 | 795500.0 |
| 2002-06-21 15:00:00 | SPY | ETF | 99.62 | 99.88 | 99.12 | 99.35 | 1281400.0 |
| 2002-06-21 15:30:00 | SPY | ETF | 99.35 | 99.35 | 98.68 | 99.19 | 3438300.0 |
| 2002-06-21 16:00:00 | SPY | ETF | 99.27 | 99.5 | 99.02 | 99.29 | 2422100.0 |
| 2002-06-21 16:30:00 | SPY | ETF | 99.32 | 99.5 | 99.32 | 99.5 | 3300.0 |
| 2002-06-21 17:00:00 | SPY | ETF | 99.4 | 99.4 | 99.4 | 99.4 | 1808000.0 |
| 2002-06-21 18:00:00 | SPY | ETF | 99.42 | 99.42 | 99.38 | 99.38 | 700.0 |
| 2002-06-21 09:30:00 | QQQ | ETF | 26.36 | 26.53 | 26.27 | 26.47 | 14314600.0 |
| 2002-06-21 10:00:00 | QQQ | ETF | 26.46 | 26.78 | 26.4 | 26.43 | 11763000.0 |
| 2002-06-21 10:30:00 | QQQ | ETF | 26.43 | 26.45 | 26.2 | 26.36 | 9351700.0 |
| 2002-06-21 11:00:00 | QQQ | ETF | 26.36 | 26.44 | 26.1 | 26.19 | 6830900.0 |
| 2002-06-21 11:30:00 | QQQ | ETF | 26.18 | 26.19 | 25.99 | 26.16 | 7918000.0 |
| 2002-06-21 12:00:00 | QQQ | ETF | 26.16 | 26.2 | 25.92 | 25.97 | 4831100.0 |
| 2002-06-21 12:30:00 | QQQ | ETF | 25.97 | 26.12 | 25.91 | 26.06 | 4507900.0 |
| 2002-06-21 13:00:00 | QQQ | ETF | 26.05 | 26.25 | 25.99 | 26.11 | 4777500.0 |
| 2002-06-21 13:30:00 | QQQ | ETF | 26.12 | 26.22 | 26.05 | 26.22 | 3875700.0 |
| 2002-06-21 14:00:00 | QQQ | ETF | 26.22 | 26.27 | 25.96 | 26.06 | 4851100.0 |
| 2002-06-21 14:30:00 | QQQ | ETF | 26.06 | 26.19 | 26.0 | 26.04 | 3445600.0 |
| 2002-06-21 15:00:00 | QQQ | ETF | 26.06 | 26.17 | 25.78 | 25.88 | 7698400.0 |
| 2002-06-21 15:30:00 | QQQ | ETF | 25.89 | 25.91 | 25.65 | 25.8 | 12290100.0 |
| 2002-06-21 16:00:00 | QQQ | ETF | 25.8 | 25.98 | 25.75 | 25.77 | 3767300.0 |
| 2002-06-21 16:30:00 | QQQ | ETF | 25.77 | 25.83 | 25.75 | 25.8 | 148500.0 |
| 2002-06-21 17:00:00 | QQQ | ETF | 25.8 | 25.82 | 25.77 | 25.8 | 21200.0 |
| 2002-06-21 17:30:00 | QQQ | ETF | 25.8 | 25.81 | 25.75 | 25.75 | 22800.0 |
| 2002-06-21 18:00:00 | QQQ | ETF | 25.77 | 25.81 | 25.75 | 25.8 | 26800.0 |
| 2002-06-21 09:30:00 | IWM | ETF | 45.9 | 46.2 | 45.865 | 46.16 | 124200.0 |
| 2002-06-21 10:00:00 | IWM | ETF | 46.16 | 46.32 | 46.16 | 46.185 | 186400.0 |
| 2002-06-21 10:30:00 | IWM | ETF | 46.15 | 46.16 | 46.03 | 46.14 | 86600.0 |
| 2002-06-21 11:00:00 | IWM | ETF | 46.14 | 46.16 | 45.9 | 45.955 | 73400.0 |
| 2002-06-21 11:30:00 | IWM | ETF | 45.955 | 45.99 | 45.81 | 45.93 | 87200.0 |
| 2002-06-21 12:00:00 | IWM | ETF | 45.9 | 45.925 | 45.72 | 45.72 | 245200.0 |
| 2002-06-21 12:30:00 | IWM | ETF | 45.72 | 45.72 | 45.6 | 45.665 | 80800.0 |
| 2002-06-21 13:00:00 | IWM | ETF | 45.66 | 45.79 | 45.63 | 45.77 | 50400.0 |
| 2002-06-21 13:30:00 | IWM | ETF | 45.73 | 45.85 | 45.725 | 45.85 | 87800.0 |
| 2002-06-21 14:00:00 | IWM | ETF | 45.85 | 45.88 | 45.785 | 45.85 | 64400.0 |
| 2002-06-21 14:30:00 | IWM | ETF | 45.86 | 45.89 | 45.805 | 45.875 | 61400.0 |
| 2002-06-21 15:00:00 | IWM | ETF | 45.88 | 46.0 | 45.87 | 45.935 | 134600.0 |
| 2002-06-21 15:30:00 | IWM | ETF | 45.935 | 45.945 | 45.62 | 45.945 | 365600.0 |
| 2002-06-21 16:00:00 | IWM | ETF | 45.945 | 46.025 | 45.8 | 45.8 | 55600.0 |
| 2002-06-21 18:00:00 | IWM | ETF | 45.86 | 45.86 | 45.86 | 45.86 | 294400.0 |
> showing 50 of 504 rows — these rows as CSV