PREVIEW / etf_30min / 2002-08-22
file: by_date/etf_30min/2002/2002-08-22.parquet size: 20 KB rows: 575
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-22 09:30:00 | SPY | ETF | 95.49 | 95.76 | 95.07 | 95.21 | 3853000.0 |
| 2002-08-22 10:00:00 | SPY | ETF | 95.22 | 96.55 | 95.21 | 96.5 | 4785900.0 |
| 2002-08-22 10:30:00 | SPY | ETF | 96.53 | 96.69 | 96.25 | 96.35 | 2968100.0 |
| 2002-08-22 11:00:00 | SPY | ETF | 96.39 | 96.66 | 96.12 | 96.6 | 1389600.0 |
| 2002-08-22 11:30:00 | SPY | ETF | 96.62 | 96.65 | 96.15 | 96.16 | 1670700.0 |
| 2002-08-22 12:00:00 | SPY | ETF | 96.14 | 96.2 | 95.85 | 96.02 | 1657300.0 |
| 2002-08-22 12:30:00 | SPY | ETF | 96.02 | 96.36 | 95.98 | 96.15 | 830800.0 |
| 2002-08-22 13:00:00 | SPY | ETF | 96.15 | 96.48 | 96.08 | 96.26 | 649900.0 |
| 2002-08-22 13:30:00 | SPY | ETF | 96.26 | 96.29 | 95.65 | 96.05 | 3682300.0 |
| 2002-08-22 14:00:00 | SPY | ETF | 96.04 | 96.45 | 95.85 | 96.31 | 1343300.0 |
| 2002-08-22 14:30:00 | SPY | ETF | 96.32 | 96.65 | 96.11 | 96.55 | 1324900.0 |
| 2002-08-22 15:00:00 | SPY | ETF | 96.58 | 96.99 | 96.44 | 96.95 | 4772200.0 |
| 2002-08-22 15:30:00 | SPY | ETF | 96.92 | 97.15 | 96.71 | 96.76 | 6373100.0 |
| 2002-08-22 16:00:00 | SPY | ETF | 96.79 | 96.85 | 96.63 | 96.68 | 765600.0 |
| 2002-08-22 09:30:00 | QQQ | ETF | 25.74 | 25.82 | 25.42 | 25.5 | 11392700.0 |
| 2002-08-22 10:00:00 | QQQ | ETF | 25.5 | 26.09 | 25.48 | 26.09 | 11766800.0 |
| 2002-08-22 10:30:00 | QQQ | ETF | 26.09 | 26.17 | 25.96 | 26.04 | 11426900.0 |
| 2002-08-22 11:00:00 | QQQ | ETF | 26.04 | 26.09 | 25.93 | 26.04 | 5690600.0 |
| 2002-08-22 11:30:00 | QQQ | ETF | 26.06 | 26.06 | 25.78 | 25.8 | 3417300.0 |
| 2002-08-22 12:00:00 | QQQ | ETF | 25.8 | 25.98 | 25.75 | 25.93 | 3863700.0 |
| 2002-08-22 12:30:00 | QQQ | ETF | 25.93 | 26.04 | 25.91 | 25.97 | 2505900.0 |
| 2002-08-22 13:00:00 | QQQ | ETF | 25.96 | 26.08 | 25.93 | 25.97 | 2124700.0 |
| 2002-08-22 13:30:00 | QQQ | ETF | 25.97 | 26.0 | 25.76 | 25.88 | 6058400.0 |
| 2002-08-22 14:00:00 | QQQ | ETF | 25.9 | 25.99 | 25.78 | 25.9 | 2967800.0 |
| 2002-08-22 14:30:00 | QQQ | ETF | 25.94 | 26.09 | 25.89 | 26.09 | 2524700.0 |
| 2002-08-22 15:00:00 | QQQ | ETF | 26.08 | 26.21 | 25.98 | 26.14 | 4778800.0 |
| 2002-08-22 15:30:00 | QQQ | ETF | 26.14 | 26.2 | 26.02 | 26.1 | 7021900.0 |
| 2002-08-22 16:00:00 | QQQ | ETF | 26.1 | 26.16 | 26.05 | 26.16 | 998000.0 |
| 2002-08-22 09:30:00 | IWM | ETF | 40.6 | 40.6 | 40.325 | 40.44 | 235800.0 |
| 2002-08-22 10:00:00 | IWM | ETF | 40.46 | 40.76 | 40.46 | 40.755 | 272400.0 |
| 2002-08-22 10:30:00 | IWM | ETF | 40.72 | 40.81 | 40.7 | 40.71 | 250200.0 |
| 2002-08-22 11:00:00 | IWM | ETF | 40.71 | 40.775 | 40.63 | 40.755 | 141200.0 |
| 2002-08-22 11:30:00 | IWM | ETF | 40.755 | 40.755 | 40.63 | 40.695 | 92400.0 |
| 2002-08-22 12:00:00 | IWM | ETF | 40.63 | 40.68 | 40.57 | 40.62 | 64400.0 |
| 2002-08-22 12:30:00 | IWM | ETF | 40.625 | 40.685 | 40.62 | 40.68 | 29400.0 |
| 2002-08-22 13:00:00 | IWM | ETF | 40.63 | 40.725 | 40.63 | 40.655 | 27400.0 |
| 2002-08-22 13:30:00 | IWM | ETF | 40.715 | 40.715 | 40.54 | 40.595 | 43600.0 |
| 2002-08-22 14:00:00 | IWM | ETF | 40.625 | 40.725 | 40.625 | 40.725 | 55600.0 |
| 2002-08-22 14:30:00 | IWM | ETF | 40.66 | 40.825 | 40.65 | 40.825 | 53600.0 |
| 2002-08-22 15:00:00 | IWM | ETF | 40.815 | 41.06 | 40.815 | 41.0 | 266600.0 |
| 2002-08-22 15:30:00 | IWM | ETF | 41.06 | 41.125 | 40.85 | 40.86 | 253600.0 |
| 2002-08-22 16:00:00 | IWM | ETF | 40.875 | 40.9 | 40.875 | 40.9 | 12200.0 |
| 2002-08-22 09:30:00 | DIA | ETF | 89.75 | 90.01 | 89.35 | 89.52 | 1319000.0 |
| 2002-08-22 10:00:00 | DIA | ETF | 89.52 | 90.56 | 89.4 | 90.54 | 1263500.0 |
| 2002-08-22 10:30:00 | DIA | ETF | 90.47 | 90.73 | 90.15 | 90.33 | 1190900.0 |
| 2002-08-22 11:00:00 | DIA | ETF | 90.34 | 90.61 | 90.13 | 90.57 | 591200.0 |
| 2002-08-22 11:30:00 | DIA | ETF | 90.45 | 90.59 | 90.15 | 90.22 | 365600.0 |
| 2002-08-22 12:00:00 | DIA | ETF | 90.2 | 90.3 | 89.95 | 90.1 | 276400.0 |
| 2002-08-22 12:30:00 | DIA | ETF | 90.13 | 90.43 | 90.07 | 90.26 | 400300.0 |
| 2002-08-22 13:00:00 | DIA | ETF | 90.3 | 90.4 | 90.12 | 90.19 | 188700.0 |
> showing 50 of 575 rows — these rows as CSV