PREVIEW / etf_30min / 2002-08-12
file: by_date/etf_30min/2002/2002-08-12.parquet size: 19 KB rows: 532
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-12 09:30:00 | SPY | ETF | 89.99 | 90.05 | 89.55 | 90.03 | 3638900.0 |
| 2002-08-12 10:00:00 | SPY | ETF | 89.99 | 90.61 | 89.77 | 90.36 | 3689100.0 |
| 2002-08-12 10:30:00 | SPY | ETF | 90.37 | 90.54 | 90.0 | 90.29 | 2540700.0 |
| 2002-08-12 11:00:00 | SPY | ETF | 90.28 | 90.44 | 90.03 | 90.14 | 1245100.0 |
| 2002-08-12 11:30:00 | SPY | ETF | 90.12 | 90.24 | 89.82 | 90.16 | 1077900.0 |
| 2002-08-12 12:00:00 | SPY | ETF | 90.16 | 90.44 | 90.0 | 90.38 | 702200.0 |
| 2002-08-12 12:30:00 | SPY | ETF | 90.4 | 90.58 | 90.22 | 90.34 | 1510800.0 |
| 2002-08-12 13:00:00 | SPY | ETF | 90.33 | 90.44 | 89.97 | 90.0 | 1272900.0 |
| 2002-08-12 13:30:00 | SPY | ETF | 90.02 | 90.26 | 89.91 | 90.05 | 573700.0 |
| 2002-08-12 14:00:00 | SPY | ETF | 90.03 | 90.45 | 89.95 | 90.44 | 1155900.0 |
| 2002-08-12 14:30:00 | SPY | ETF | 90.41 | 90.73 | 90.22 | 90.7 | 1332500.0 |
| 2002-08-12 15:00:00 | SPY | ETF | 90.76 | 91.19 | 90.67 | 91.19 | 2067900.0 |
| 2002-08-12 15:30:00 | SPY | ETF | 91.15 | 91.27 | 90.52 | 90.69 | 2921500.0 |
| 2002-08-12 16:00:00 | SPY | ETF | 90.69 | 90.76 | 90.54 | 90.62 | 604900.0 |
| 2002-08-12 09:30:00 | QQQ | ETF | 23.05 | 23.15 | 22.92 | 23.12 | 14215300.0 |
| 2002-08-12 10:00:00 | QQQ | ETF | 23.13 | 23.16 | 22.99 | 23.1 | 6539500.0 |
| 2002-08-12 10:30:00 | QQQ | ETF | 23.11 | 23.15 | 22.96 | 23.03 | 5922100.0 |
| 2002-08-12 11:00:00 | QQQ | ETF | 23.03 | 23.1 | 22.99 | 23.03 | 1928000.0 |
| 2002-08-12 11:30:00 | QQQ | ETF | 23.02 | 23.05 | 22.9 | 23.04 | 2992600.0 |
| 2002-08-12 12:00:00 | QQQ | ETF | 23.04 | 23.14 | 22.98 | 23.13 | 2043800.0 |
| 2002-08-12 12:30:00 | QQQ | ETF | 23.12 | 23.28 | 23.12 | 23.17 | 3929900.0 |
| 2002-08-12 13:00:00 | QQQ | ETF | 23.18 | 23.23 | 23.02 | 23.05 | 1769800.0 |
| 2002-08-12 13:30:00 | QQQ | ETF | 23.06 | 23.14 | 23.03 | 23.08 | 1004800.0 |
| 2002-08-12 14:00:00 | QQQ | ETF | 23.09 | 23.2 | 23.05 | 23.18 | 2152500.0 |
| 2002-08-12 14:30:00 | QQQ | ETF | 23.19 | 23.3 | 23.1 | 23.3 | 3115500.0 |
| 2002-08-12 15:00:00 | QQQ | ETF | 23.3 | 23.46 | 23.24 | 23.46 | 6148200.0 |
| 2002-08-12 15:30:00 | QQQ | ETF | 23.45 | 23.48 | 23.2 | 23.33 | 5735100.0 |
| 2002-08-12 16:00:00 | QQQ | ETF | 23.31 | 23.42 | 23.29 | 23.4 | 364100.0 |
| 2002-08-12 09:30:00 | IWM | ETF | 38.25 | 38.275 | 38.105 | 38.19 | 248400.0 |
| 2002-08-12 10:00:00 | IWM | ETF | 38.25 | 38.335 | 38.175 | 38.325 | 160400.0 |
| 2002-08-12 10:30:00 | IWM | ETF | 38.325 | 38.325 | 38.205 | 38.295 | 80600.0 |
| 2002-08-12 11:00:00 | IWM | ETF | 38.225 | 38.325 | 38.22 | 38.25 | 50000.0 |
| 2002-08-12 11:30:00 | IWM | ETF | 38.25 | 38.315 | 38.205 | 38.315 | 56000.0 |
| 2002-08-12 12:00:00 | IWM | ETF | 38.275 | 38.37 | 38.26 | 38.37 | 31200.0 |
| 2002-08-12 12:30:00 | IWM | ETF | 38.34 | 38.52 | 38.34 | 38.52 | 49200.0 |
| 2002-08-12 13:00:00 | IWM | ETF | 38.395 | 38.45 | 38.365 | 38.365 | 11000.0 |
| 2002-08-12 13:30:00 | IWM | ETF | 38.345 | 38.435 | 38.31 | 38.375 | 64400.0 |
| 2002-08-12 14:00:00 | IWM | ETF | 38.445 | 38.47 | 38.375 | 38.44 | 98800.0 |
| 2002-08-12 14:30:00 | IWM | ETF | 38.485 | 38.56 | 38.44 | 38.485 | 73200.0 |
| 2002-08-12 15:00:00 | IWM | ETF | 38.52 | 38.805 | 38.495 | 38.76 | 136600.0 |
| 2002-08-12 15:30:00 | IWM | ETF | 38.765 | 38.88 | 38.62 | 38.65 | 172800.0 |
| 2002-08-12 16:00:00 | IWM | ETF | 38.6 | 38.6 | 38.6 | 38.6 | 64600.0 |
| 2002-08-12 09:30:00 | DIA | ETF | 86.38 | 86.4 | 85.98 | 86.31 | 1313800.0 |
| 2002-08-12 10:00:00 | DIA | ETF | 86.25 | 86.8 | 86.05 | 86.55 | 1502100.0 |
| 2002-08-12 10:30:00 | DIA | ETF | 86.54 | 86.74 | 86.28 | 86.57 | 811400.0 |
| 2002-08-12 11:00:00 | DIA | ETF | 86.58 | 86.69 | 86.35 | 86.49 | 365500.0 |
| 2002-08-12 11:30:00 | DIA | ETF | 86.5 | 86.62 | 86.18 | 86.48 | 462000.0 |
| 2002-08-12 12:00:00 | DIA | ETF | 86.51 | 86.68 | 86.25 | 86.6 | 259700.0 |
| 2002-08-12 12:30:00 | DIA | ETF | 86.54 | 86.81 | 86.4 | 86.54 | 374300.0 |
| 2002-08-12 13:00:00 | DIA | ETF | 86.55 | 86.69 | 86.11 | 86.23 | 263200.0 |
> showing 50 of 532 rows — these rows as CSV