PREVIEW / etf_30min / 2002-05-17
file: by_date/etf_30min/2002/2002-05-17.parquet size: 18 KB rows: 505
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-05-17 09:30:00 | SPY | ETF | 110.66 | 111.1 | 110.6 | 110.87 | 3505800.0 |
| 2002-05-17 10:00:00 | SPY | ETF | 110.9 | 111.16 | 110.67 | 110.78 | 1626000.0 |
| 2002-05-17 10:30:00 | SPY | ETF | 110.78 | 110.88 | 110.1 | 110.36 | 1268300.0 |
| 2002-05-17 11:00:00 | SPY | ETF | 110.37 | 110.41 | 110.17 | 110.34 | 755100.0 |
| 2002-05-17 11:30:00 | SPY | ETF | 110.32 | 110.34 | 110.15 | 110.15 | 965000.0 |
| 2002-05-17 12:00:00 | SPY | ETF | 110.17 | 110.47 | 110.12 | 110.38 | 402100.0 |
| 2002-05-17 12:30:00 | SPY | ETF | 110.35 | 110.61 | 110.35 | 110.52 | 696000.0 |
| 2002-05-17 13:00:00 | SPY | ETF | 110.55 | 110.7 | 110.45 | 110.6 | 1196900.0 |
| 2002-05-17 13:30:00 | SPY | ETF | 110.59 | 110.64 | 110.3 | 110.4 | 485100.0 |
| 2002-05-17 14:00:00 | SPY | ETF | 110.42 | 110.52 | 110.25 | 110.52 | 1256500.0 |
| 2002-05-17 14:30:00 | SPY | ETF | 110.48 | 110.57 | 110.38 | 110.57 | 1129900.0 |
| 2002-05-17 15:00:00 | SPY | ETF | 110.55 | 110.93 | 110.51 | 110.81 | 1634200.0 |
| 2002-05-17 15:30:00 | SPY | ETF | 110.83 | 111.17 | 110.68 | 111.11 | 2846500.0 |
| 2002-05-17 16:00:00 | SPY | ETF | 111.09 | 111.25 | 110.65 | 110.84 | 1804400.0 |
| 2002-05-17 16:30:00 | SPY | ETF | 110.94 | 110.94 | 110.91 | 110.91 | 1200.0 |
| 2002-05-17 09:30:00 | QQQ | ETF | 33.29 | 33.41 | 33.05 | 33.22 | 17550000.0 |
| 2002-05-17 10:00:00 | QQQ | ETF | 33.22 | 33.38 | 33.0 | 33.1 | 8727000.0 |
| 2002-05-17 10:30:00 | QQQ | ETF | 33.08 | 33.19 | 32.55 | 32.72 | 10620500.0 |
| 2002-05-17 11:00:00 | QQQ | ETF | 32.72 | 32.8 | 32.66 | 32.75 | 4571000.0 |
| 2002-05-17 11:30:00 | QQQ | ETF | 32.75 | 32.78 | 32.51 | 32.52 | 2920400.0 |
| 2002-05-17 12:00:00 | QQQ | ETF | 32.53 | 32.77 | 32.5 | 32.65 | 2676900.0 |
| 2002-05-17 12:30:00 | QQQ | ETF | 32.64 | 32.89 | 32.63 | 32.79 | 3759600.0 |
| 2002-05-17 13:00:00 | QQQ | ETF | 32.76 | 32.85 | 32.65 | 32.71 | 1716400.0 |
| 2002-05-17 13:30:00 | QQQ | ETF | 32.66 | 32.79 | 32.47 | 32.55 | 2888800.0 |
| 2002-05-17 14:00:00 | QQQ | ETF | 32.55 | 32.66 | 32.48 | 32.65 | 2292600.0 |
| 2002-05-17 14:30:00 | QQQ | ETF | 32.63 | 32.66 | 32.55 | 32.61 | 2024100.0 |
| 2002-05-17 15:00:00 | QQQ | ETF | 32.61 | 32.89 | 32.59 | 32.78 | 5013700.0 |
| 2002-05-17 15:30:00 | QQQ | ETF | 32.79 | 33.01 | 32.68 | 33.0 | 9764500.0 |
| 2002-05-17 16:00:00 | QQQ | ETF | 32.98 | 33.02 | 32.7 | 32.97 | 4691200.0 |
| 2002-05-17 16:30:00 | QQQ | ETF | 32.97 | 33.07 | 32.95 | 33.04 | 143500.0 |
| 2002-05-17 17:00:00 | QQQ | ETF | 33.0 | 33.03 | 32.95 | 32.97 | 60400.0 |
| 2002-05-17 17:30:00 | QQQ | ETF | 32.97 | 32.99 | 32.96 | 32.99 | 5800.0 |
| 2002-05-17 18:00:00 | QQQ | ETF | 32.97 | 32.97 | 32.9 | 32.96 | 31400.0 |
| 2002-05-17 09:30:00 | IWM | ETF | 50.6 | 50.885 | 50.6 | 50.765 | 350400.0 |
| 2002-05-17 10:00:00 | IWM | ETF | 50.76 | 50.815 | 50.595 | 50.66 | 276000.0 |
| 2002-05-17 10:30:00 | IWM | ETF | 50.65 | 50.68 | 50.26 | 50.36 | 303000.0 |
| 2002-05-17 11:00:00 | IWM | ETF | 50.36 | 50.445 | 50.34 | 50.425 | 141800.0 |
| 2002-05-17 11:30:00 | IWM | ETF | 50.42 | 50.445 | 50.345 | 50.445 | 20000.0 |
| 2002-05-17 12:00:00 | IWM | ETF | 50.42 | 50.485 | 50.385 | 50.485 | 55800.0 |
| 2002-05-17 12:30:00 | IWM | ETF | 50.485 | 50.545 | 50.485 | 50.535 | 39200.0 |
| 2002-05-17 13:00:00 | IWM | ETF | 50.525 | 50.555 | 50.52 | 50.555 | 7400.0 |
| 2002-05-17 13:30:00 | IWM | ETF | 50.54 | 50.56 | 50.44 | 50.44 | 190000.0 |
| 2002-05-17 14:00:00 | IWM | ETF | 50.47 | 50.49 | 50.405 | 50.405 | 33800.0 |
| 2002-05-17 14:30:00 | IWM | ETF | 50.485 | 50.5 | 50.45 | 50.5 | 13000.0 |
| 2002-05-17 15:00:00 | IWM | ETF | 50.505 | 50.72 | 50.505 | 50.72 | 73200.0 |
| 2002-05-17 15:30:00 | IWM | ETF | 50.67 | 50.85 | 50.61 | 50.795 | 61000.0 |
| 2002-05-17 16:00:00 | IWM | ETF | 50.795 | 50.845 | 50.55 | 50.7 | 12800.0 |
| 2002-05-17 09:30:00 | DIA | ETF | 103.22 | 103.57 | 103.11 | 103.39 | 296000.0 |
| 2002-05-17 10:00:00 | DIA | ETF | 103.38 | 103.63 | 103.18 | 103.25 | 411200.0 |
| 2002-05-17 10:30:00 | DIA | ETF | 103.24 | 103.34 | 102.64 | 102.89 | 182900.0 |
> showing 50 of 505 rows — these rows as CSV