PREVIEW / etf_30min / 2002-08-20
file: by_date/etf_30min/2002/2002-08-20.parquet size: 20 KB rows: 585
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-08-20 09:30:00 | SPY | ETF | 94.82 | 95.02 | 94.2 | 94.6 | 5489900.0 |
| 2002-08-20 10:00:00 | SPY | ETF | 94.58 | 94.67 | 94.02 | 94.06 | 3050700.0 |
| 2002-08-20 10:30:00 | SPY | ETF | 94.06 | 94.62 | 94.03 | 94.6 | 1874600.0 |
| 2002-08-20 11:00:00 | SPY | ETF | 94.6 | 94.9 | 94.2 | 94.36 | 3686700.0 |
| 2002-08-20 11:30:00 | SPY | ETF | 94.38 | 94.42 | 93.76 | 94.03 | 1761200.0 |
| 2002-08-20 12:00:00 | SPY | ETF | 94.03 | 94.25 | 93.85 | 94.0 | 1270300.0 |
| 2002-08-20 12:30:00 | SPY | ETF | 94.0 | 94.22 | 93.88 | 94.07 | 931700.0 |
| 2002-08-20 13:00:00 | SPY | ETF | 94.09 | 94.11 | 93.62 | 93.76 | 1552600.0 |
| 2002-08-20 13:30:00 | SPY | ETF | 93.76 | 94.34 | 93.7 | 94.34 | 1363300.0 |
| 2002-08-20 14:00:00 | SPY | ETF | 94.35 | 94.39 | 93.93 | 94.2 | 1310000.0 |
| 2002-08-20 14:30:00 | SPY | ETF | 94.19 | 94.62 | 93.96 | 94.56 | 2062000.0 |
| 2002-08-20 15:00:00 | SPY | ETF | 94.56 | 94.83 | 94.36 | 94.46 | 2078400.0 |
| 2002-08-20 15:30:00 | SPY | ETF | 94.46 | 94.58 | 94.01 | 94.27 | 2311300.0 |
| 2002-08-20 16:00:00 | SPY | ETF | 94.27 | 94.48 | 94.14 | 94.39 | 843200.0 |
| 2002-08-20 09:30:00 | QQQ | ETF | 25.18 | 25.28 | 24.95 | 25.07 | 13225300.0 |
| 2002-08-20 10:00:00 | QQQ | ETF | 25.07 | 25.22 | 25.0 | 25.04 | 8041400.0 |
| 2002-08-20 10:30:00 | QQQ | ETF | 25.06 | 25.31 | 25.05 | 25.31 | 8290100.0 |
| 2002-08-20 11:00:00 | QQQ | ETF | 25.3 | 25.43 | 25.15 | 25.2 | 8239400.0 |
| 2002-08-20 11:30:00 | QQQ | ETF | 25.2 | 25.23 | 25.03 | 25.14 | 5140900.0 |
| 2002-08-20 12:00:00 | QQQ | ETF | 25.14 | 25.2 | 25.1 | 25.11 | 2709300.0 |
| 2002-08-20 12:30:00 | QQQ | ETF | 25.13 | 25.19 | 25.04 | 25.13 | 3045100.0 |
| 2002-08-20 13:00:00 | QQQ | ETF | 25.14 | 25.15 | 24.85 | 24.99 | 9023800.0 |
| 2002-08-20 13:30:00 | QQQ | ETF | 24.98 | 25.2 | 24.92 | 25.2 | 6864500.0 |
| 2002-08-20 14:00:00 | QQQ | ETF | 25.19 | 25.22 | 25.0 | 25.09 | 2536500.0 |
| 2002-08-20 14:30:00 | QQQ | ETF | 25.08 | 25.26 | 25.04 | 25.23 | 6021000.0 |
| 2002-08-20 15:00:00 | QQQ | ETF | 25.22 | 25.28 | 25.12 | 25.12 | 3713200.0 |
| 2002-08-20 15:30:00 | QQQ | ETF | 25.15 | 25.2 | 24.95 | 25.1 | 8941200.0 |
| 2002-08-20 16:00:00 | QQQ | ETF | 25.1 | 25.19 | 25.08 | 25.19 | 639300.0 |
| 2002-08-20 09:30:00 | IWM | ETF | 39.905 | 39.945 | 39.595 | 39.725 | 246400.0 |
| 2002-08-20 10:00:00 | IWM | ETF | 39.67 | 39.775 | 39.67 | 39.67 | 125400.0 |
| 2002-08-20 10:30:00 | IWM | ETF | 39.65 | 39.83 | 39.65 | 39.83 | 208800.0 |
| 2002-08-20 11:00:00 | IWM | ETF | 39.82 | 39.9 | 39.73 | 39.73 | 211800.0 |
| 2002-08-20 11:30:00 | IWM | ETF | 39.73 | 39.745 | 39.56 | 39.685 | 161400.0 |
| 2002-08-20 12:00:00 | IWM | ETF | 39.68 | 39.72 | 39.59 | 39.655 | 282800.0 |
| 2002-08-20 12:30:00 | IWM | ETF | 39.655 | 39.7 | 39.575 | 39.7 | 32000.0 |
| 2002-08-20 13:00:00 | IWM | ETF | 39.675 | 39.7 | 39.525 | 39.525 | 85600.0 |
| 2002-08-20 13:30:00 | IWM | ETF | 39.545 | 39.7 | 39.545 | 39.7 | 44200.0 |
| 2002-08-20 14:00:00 | IWM | ETF | 39.64 | 39.725 | 39.595 | 39.65 | 51800.0 |
| 2002-08-20 14:30:00 | IWM | ETF | 39.6 | 39.8 | 39.585 | 39.785 | 202800.0 |
| 2002-08-20 15:00:00 | IWM | ETF | 39.8 | 39.925 | 39.76 | 39.825 | 185000.0 |
| 2002-08-20 15:30:00 | IWM | ETF | 39.805 | 39.825 | 39.6 | 39.6 | 479600.0 |
| 2002-08-20 16:00:00 | IWM | ETF | 39.825 | 39.825 | 39.825 | 39.825 | 200.0 |
| 2002-08-20 09:30:00 | DIA | ETF | 89.32 | 89.64 | 88.8 | 89.18 | 1547500.0 |
| 2002-08-20 10:00:00 | DIA | ETF | 89.18 | 89.23 | 88.65 | 88.67 | 1026200.0 |
| 2002-08-20 10:30:00 | DIA | ETF | 88.68 | 89.21 | 88.68 | 89.15 | 1193400.0 |
| 2002-08-20 11:00:00 | DIA | ETF | 89.19 | 89.5 | 88.7 | 88.85 | 746600.0 |
| 2002-08-20 11:30:00 | DIA | ETF | 88.83 | 88.9 | 88.38 | 88.6 | 1060400.0 |
| 2002-08-20 12:00:00 | DIA | ETF | 88.54 | 88.85 | 88.5 | 88.66 | 285500.0 |
| 2002-08-20 12:30:00 | DIA | ETF | 88.65 | 88.79 | 88.41 | 88.66 | 239800.0 |
| 2002-08-20 13:00:00 | DIA | ETF | 88.65 | 88.72 | 88.25 | 88.44 | 309500.0 |
> showing 50 of 585 rows — these rows as CSV