PREVIEW / etf_30min / 2002-07-05
file: by_date/etf_30min/2002/2002-07-05.parquet size: 13 KB rows: 289
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-07-05 09:30:00 | SPY | ETF | 96.78 | 97.3 | 96.66 | 97.18 | 3937200.0 |
| 2002-07-05 10:00:00 | SPY | ETF | 97.2 | 98.19 | 97.15 | 98.15 | 2649200.0 |
| 2002-07-05 10:30:00 | SPY | ETF | 98.09 | 98.54 | 98.05 | 98.17 | 1830000.0 |
| 2002-07-05 11:00:00 | SPY | ETF | 98.15 | 98.58 | 98.14 | 98.5 | 1901900.0 |
| 2002-07-05 11:30:00 | SPY | ETF | 98.5 | 98.83 | 98.45 | 98.53 | 1615400.0 |
| 2002-07-05 12:00:00 | SPY | ETF | 98.52 | 98.75 | 98.4 | 98.73 | 1558800.0 |
| 2002-07-05 12:30:00 | SPY | ETF | 98.69 | 99.31 | 98.5 | 99.31 | 3434800.0 |
| 2002-07-05 13:00:00 | SPY | ETF | 99.32 | 99.53 | 99.24 | 99.31 | 1149000.0 |
| 2002-07-05 09:30:00 | QQQ | ETF | 25.26 | 25.67 | 25.26 | 25.62 | 11943200.0 |
| 2002-07-05 10:00:00 | QQQ | ETF | 25.61 | 25.85 | 25.6 | 25.82 | 8825500.0 |
| 2002-07-05 10:30:00 | QQQ | ETF | 25.84 | 26.04 | 25.8 | 25.86 | 8549000.0 |
| 2002-07-05 11:00:00 | QQQ | ETF | 25.84 | 26.04 | 25.82 | 26.01 | 4864900.0 |
| 2002-07-05 11:30:00 | QQQ | ETF | 26.0 | 26.14 | 26.0 | 26.04 | 4424500.0 |
| 2002-07-05 12:00:00 | QQQ | ETF | 26.03 | 26.12 | 25.94 | 26.05 | 5699900.0 |
| 2002-07-05 12:30:00 | QQQ | ETF | 26.06 | 26.37 | 25.98 | 26.36 | 7052600.0 |
| 2002-07-05 13:00:00 | QQQ | ETF | 26.35 | 26.39 | 26.27 | 26.34 | 2375600.0 |
| 2002-07-05 09:30:00 | IWM | ETF | 43.075 | 43.25 | 42.9 | 43.225 | 108000.0 |
| 2002-07-05 10:00:00 | IWM | ETF | 43.325 | 43.78 | 43.3 | 43.725 | 109800.0 |
| 2002-07-05 10:30:00 | IWM | ETF | 43.84 | 43.925 | 43.765 | 43.765 | 113200.0 |
| 2002-07-05 11:00:00 | IWM | ETF | 43.765 | 43.835 | 43.705 | 43.825 | 81200.0 |
| 2002-07-05 11:30:00 | IWM | ETF | 43.8 | 43.875 | 43.795 | 43.84 | 95800.0 |
| 2002-07-05 12:00:00 | IWM | ETF | 43.8 | 43.825 | 43.65 | 43.655 | 186600.0 |
| 2002-07-05 12:30:00 | IWM | ETF | 43.745 | 43.925 | 43.645 | 43.825 | 57000.0 |
| 2002-07-05 13:00:00 | IWM | ETF | 43.8 | 43.96 | 43.8 | 43.96 | 4800.0 |
| 2002-07-05 09:30:00 | DIA | ETF | 91.6 | 92.14 | 91.49 | 92.02 | 880900.0 |
| 2002-07-05 10:00:00 | DIA | ETF | 92.05 | 92.99 | 92.03 | 92.9 | 341300.0 |
| 2002-07-05 10:30:00 | DIA | ETF | 92.9 | 93.17 | 92.82 | 92.93 | 244600.0 |
| 2002-07-05 11:00:00 | DIA | ETF | 92.91 | 93.35 | 92.9 | 93.32 | 254000.0 |
| 2002-07-05 11:30:00 | DIA | ETF | 93.35 | 93.66 | 93.31 | 93.39 | 256500.0 |
| 2002-07-05 12:00:00 | DIA | ETF | 93.35 | 93.58 | 93.14 | 93.5 | 353500.0 |
| 2002-07-05 12:30:00 | DIA | ETF | 93.5 | 94.0 | 93.26 | 94.0 | 444500.0 |
| 2002-07-05 13:00:00 | DIA | ETF | 93.9 | 94.17 | 93.9 | 94.17 | 98700.0 |
> showing 32 of 289 rows — these rows as CSV