PREVIEW / etf_30min / 2002-10-09
file: by_date/etf_30min/2002/2002-10-09.parquet size: 22 KB rows: 619
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-10-09 08:00:00 | SPY | ETF | 79.61 | 79.61 | 79.41 | 79.41 | 1700.0 |
| 2002-10-09 08:30:00 | SPY | ETF | 79.56 | 79.61 | 79.16 | 79.16 | 4100.0 |
| 2002-10-09 09:00:00 | SPY | ETF | 79.25 | 79.36 | 79.15 | 79.15 | 18400.0 |
| 2002-10-09 09:30:00 | SPY | ETF | 79.09 | 79.25 | 78.55 | 78.7 | 6671600.0 |
| 2002-10-09 10:00:00 | SPY | ETF | 78.71 | 79.4 | 78.22 | 79.33 | 7816500.0 |
| 2002-10-09 10:30:00 | SPY | ETF | 79.34 | 79.7 | 78.7 | 78.78 | 5583200.0 |
| 2002-10-09 11:00:00 | SPY | ETF | 78.75 | 79.24 | 78.45 | 79.06 | 2815900.0 |
| 2002-10-09 11:30:00 | SPY | ETF | 79.02 | 79.24 | 78.68 | 79.08 | 1823000.0 |
| 2002-10-09 12:00:00 | SPY | ETF | 79.11 | 79.15 | 78.14 | 78.14 | 4382100.0 |
| 2002-10-09 12:30:00 | SPY | ETF | 78.18 | 78.81 | 78.05 | 78.71 | 5051700.0 |
| 2002-10-09 13:00:00 | SPY | ETF | 78.73 | 78.75 | 78.07 | 78.57 | 3820700.0 |
| 2002-10-09 13:30:00 | SPY | ETF | 78.55 | 79.44 | 78.5 | 79.2 | 5398400.0 |
| 2002-10-09 14:00:00 | SPY | ETF | 79.25 | 79.26 | 78.4 | 78.74 | 7597500.0 |
| 2002-10-09 14:30:00 | SPY | ETF | 78.76 | 78.99 | 78.04 | 78.1 | 5090300.0 |
| 2002-10-09 15:00:00 | SPY | ETF | 78.14 | 78.75 | 77.86 | 77.92 | 6876600.0 |
| 2002-10-09 15:30:00 | SPY | ETF | 77.94 | 78.45 | 77.78 | 77.96 | 6396600.0 |
| 2002-10-09 16:00:00 | SPY | ETF | 78.0 | 78.37 | 77.9 | 78.03 | 5933500.0 |
| 2002-10-09 16:30:00 | SPY | ETF | 78.09 | 79.0 | 78.05 | 78.3 | 365200.0 |
| 2002-10-09 17:00:00 | SPY | ETF | 78.3 | 78.4 | 78.05 | 78.33 | 306100.0 |
| 2002-10-09 17:30:00 | SPY | ETF | 77.83 | 78.3 | 77.83 | 78.23 | 25000.0 |
| 2002-10-09 18:00:00 | SPY | ETF | 78.23 | 78.3 | 78.15 | 78.15 | 40100.0 |
| 2002-10-09 08:00:00 | QQQ | ETF | 20.0 | 20.0 | 19.95 | 19.95 | 7300.0 |
| 2002-10-09 08:30:00 | QQQ | ETF | 19.95 | 19.95 | 19.87 | 19.87 | 16400.0 |
| 2002-10-09 09:00:00 | QQQ | ETF | 19.91 | 19.97 | 19.91 | 19.94 | 37400.0 |
| 2002-10-09 09:30:00 | QQQ | ETF | 19.94 | 20.08 | 19.84 | 20.03 | 11359200.0 |
| 2002-10-09 10:00:00 | QQQ | ETF | 19.97 | 20.39 | 19.87 | 20.36 | 12449100.0 |
| 2002-10-09 10:30:00 | QQQ | ETF | 20.36 | 20.52 | 20.23 | 20.28 | 10316700.0 |
| 2002-10-09 11:00:00 | QQQ | ETF | 20.28 | 20.42 | 20.12 | 20.36 | 9301900.0 |
| 2002-10-09 11:30:00 | QQQ | ETF | 20.36 | 20.48 | 20.29 | 20.45 | 6227300.0 |
| 2002-10-09 12:00:00 | QQQ | ETF | 20.43 | 20.46 | 20.11 | 20.15 | 4911300.0 |
| 2002-10-09 12:30:00 | QQQ | ETF | 20.11 | 20.29 | 20.1 | 20.26 | 5460200.0 |
| 2002-10-09 13:00:00 | QQQ | ETF | 20.24 | 20.29 | 20.1 | 20.25 | 4345600.0 |
| 2002-10-09 13:30:00 | QQQ | ETF | 20.25 | 20.53 | 20.24 | 20.43 | 7999800.0 |
| 2002-10-09 14:00:00 | QQQ | ETF | 20.43 | 20.48 | 20.27 | 20.3 | 5274600.0 |
| 2002-10-09 14:30:00 | QQQ | ETF | 20.31 | 20.39 | 20.08 | 20.1 | 4572200.0 |
| 2002-10-09 15:00:00 | QQQ | ETF | 20.09 | 20.26 | 19.98 | 20.01 | 7386300.0 |
| 2002-10-09 15:30:00 | QQQ | ETF | 20.01 | 20.16 | 19.97 | 20.09 | 9292000.0 |
| 2002-10-09 16:00:00 | QQQ | ETF | 20.1 | 20.18 | 19.94 | 20.09 | 1624400.0 |
| 2002-10-09 16:30:00 | QQQ | ETF | 20.05 | 20.17 | 20.01 | 20.15 | 180000.0 |
| 2002-10-09 17:00:00 | QQQ | ETF | 20.16 | 20.24 | 20.13 | 20.18 | 132600.0 |
| 2002-10-09 17:30:00 | QQQ | ETF | 20.16 | 20.2 | 20.15 | 20.15 | 17100.0 |
| 2002-10-09 18:00:00 | QQQ | ETF | 20.15 | 20.2 | 20.12 | 20.14 | 46800.0 |
| 2002-10-09 18:30:00 | QQQ | ETF | 20.14 | 20.17 | 20.14 | 20.14 | 600.0 |
| 2002-10-09 19:00:00 | QQQ | ETF | 20.13 | 20.13 | 20.12 | 20.12 | 400.0 |
| 2002-10-09 19:30:00 | QQQ | ETF | 20.12 | 20.12 | 20.09 | 20.09 | 1300.0 |
| 2002-10-09 09:30:00 | IWM | ETF | 33.575 | 33.745 | 33.42 | 33.42 | 593800.0 |
| 2002-10-09 10:00:00 | IWM | ETF | 33.41 | 33.59 | 33.28 | 33.59 | 330600.0 |
| 2002-10-09 10:30:00 | IWM | ETF | 33.575 | 33.625 | 33.3 | 33.365 | 274000.0 |
| 2002-10-09 11:00:00 | IWM | ETF | 33.28 | 33.345 | 33.15 | 33.335 | 237200.0 |
| 2002-10-09 11:30:00 | IWM | ETF | 33.335 | 33.39 | 33.255 | 33.34 | 85800.0 |
> showing 50 of 619 rows — these rows as CSV