PREVIEW / etf_30min / 2002-09-12
file: by_date/etf_30min/2002/2002-09-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-09-12 09:30:00 | SPY | ETF | 90.75 | 90.84 | 90.18 | 90.42 | 4971300.0 |
| 2002-09-12 10:00:00 | SPY | ETF | 90.29 | 90.53 | 89.91 | 90.11 | 5124600.0 |
| 2002-09-12 10:30:00 | SPY | ETF | 90.11 | 90.23 | 89.84 | 89.91 | 1846200.0 |
| 2002-09-12 11:00:00 | SPY | ETF | 89.96 | 90.34 | 89.91 | 90.0 | 2297900.0 |
| 2002-09-12 11:30:00 | SPY | ETF | 90.0 | 90.38 | 89.95 | 90.33 | 1604500.0 |
| 2002-09-12 12:00:00 | SPY | ETF | 90.37 | 90.4 | 90.02 | 90.05 | 1694000.0 |
| 2002-09-12 12:30:00 | SPY | ETF | 90.04 | 90.13 | 89.75 | 89.87 | 3635100.0 |
| 2002-09-12 13:00:00 | SPY | ETF | 89.87 | 90.15 | 89.77 | 90.04 | 1360300.0 |
| 2002-09-12 13:30:00 | SPY | ETF | 90.05 | 90.1 | 89.81 | 90.08 | 1057400.0 |
| 2002-09-12 14:00:00 | SPY | ETF | 90.09 | 90.1 | 89.68 | 89.76 | 2036900.0 |
| 2002-09-12 14:30:00 | SPY | ETF | 89.73 | 89.9 | 89.22 | 89.25 | 4749700.0 |
| 2002-09-12 15:00:00 | SPY | ETF | 89.25 | 89.47 | 89.1 | 89.43 | 4093300.0 |
| 2002-09-12 15:30:00 | SPY | ETF | 89.46 | 89.49 | 88.99 | 89.26 | 5926700.0 |
| 2002-09-12 16:00:00 | SPY | ETF | 89.26 | 89.48 | 89.19 | 89.45 | 887200.0 |
| 2002-09-12 09:30:00 | QQQ | ETF | 23.23 | 23.26 | 23.02 | 23.14 | 9800700.0 |
| 2002-09-12 10:00:00 | QQQ | ETF | 23.14 | 23.17 | 22.9 | 23.01 | 7744900.0 |
| 2002-09-12 10:30:00 | QQQ | ETF | 23.04 | 23.13 | 22.91 | 22.96 | 3666700.0 |
| 2002-09-12 11:00:00 | QQQ | ETF | 22.96 | 23.11 | 22.95 | 22.99 | 5823100.0 |
| 2002-09-12 11:30:00 | QQQ | ETF | 23.02 | 23.2 | 23.0 | 23.18 | 4244500.0 |
| 2002-09-12 12:00:00 | QQQ | ETF | 23.16 | 23.22 | 23.05 | 23.06 | 4004100.0 |
| 2002-09-12 12:30:00 | QQQ | ETF | 23.06 | 23.1 | 22.95 | 23.03 | 3748300.0 |
| 2002-09-12 13:00:00 | QQQ | ETF | 23.03 | 23.15 | 22.96 | 23.05 | 2582200.0 |
| 2002-09-12 13:30:00 | QQQ | ETF | 23.06 | 23.07 | 22.95 | 23.05 | 2433400.0 |
| 2002-09-12 14:00:00 | QQQ | ETF | 23.05 | 23.08 | 22.9 | 22.92 | 4057900.0 |
| 2002-09-12 14:30:00 | QQQ | ETF | 22.93 | 22.98 | 22.75 | 22.78 | 6536700.0 |
| 2002-09-12 15:00:00 | QQQ | ETF | 22.78 | 22.89 | 22.75 | 22.87 | 6192900.0 |
| 2002-09-12 15:30:00 | QQQ | ETF | 22.88 | 22.9 | 22.71 | 22.79 | 5766500.0 |
| 2002-09-12 16:00:00 | QQQ | ETF | 22.8 | 22.83 | 22.76 | 22.81 | 782600.0 |
| 2002-09-12 09:30:00 | IWM | ETF | 39.0 | 39.17 | 38.8 | 38.95 | 305000.0 |
| 2002-09-12 10:00:00 | IWM | ETF | 38.825 | 38.95 | 38.685 | 38.725 | 88000.0 |
| 2002-09-12 10:30:00 | IWM | ETF | 38.705 | 38.785 | 38.615 | 38.67 | 105400.0 |
| 2002-09-12 11:00:00 | IWM | ETF | 38.6 | 38.75 | 38.585 | 38.63 | 73200.0 |
| 2002-09-12 11:30:00 | IWM | ETF | 38.675 | 38.705 | 38.635 | 38.69 | 4400.0 |
| 2002-09-12 12:00:00 | IWM | ETF | 38.745 | 38.755 | 38.675 | 38.755 | 10000.0 |
| 2002-09-12 12:30:00 | IWM | ETF | 38.735 | 38.735 | 38.585 | 38.585 | 26400.0 |
| 2002-09-12 13:00:00 | IWM | ETF | 38.605 | 38.735 | 38.605 | 38.635 | 17200.0 |
| 2002-09-12 13:30:00 | IWM | ETF | 38.715 | 38.75 | 38.61 | 38.685 | 15600.0 |
| 2002-09-12 14:00:00 | IWM | ETF | 38.685 | 38.69 | 38.605 | 38.625 | 35200.0 |
| 2002-09-12 14:30:00 | IWM | ETF | 38.64 | 38.645 | 38.505 | 38.505 | 40200.0 |
| 2002-09-12 15:00:00 | IWM | ETF | 38.51 | 38.56 | 38.5 | 38.51 | 326800.0 |
| 2002-09-12 15:30:00 | IWM | ETF | 38.56 | 38.65 | 38.485 | 38.57 | 413800.0 |
| 2002-09-12 16:00:00 | IWM | ETF | 38.6 | 38.625 | 38.5 | 38.5 | 150000.0 |
| 2002-09-12 09:30:00 | DIA | ETF | 85.32 | 85.42 | 84.8 | 85.01 | 1027700.0 |
| 2002-09-12 10:00:00 | DIA | ETF | 85.02 | 85.1 | 84.5 | 84.65 | 1044500.0 |
| 2002-09-12 10:30:00 | DIA | ETF | 84.63 | 84.79 | 84.4 | 84.46 | 397600.0 |
| 2002-09-12 11:00:00 | DIA | ETF | 84.5 | 84.95 | 84.45 | 84.56 | 453400.0 |
| 2002-09-12 11:30:00 | DIA | ETF | 84.63 | 85.01 | 84.54 | 84.93 | 300500.0 |
| 2002-09-12 12:00:00 | DIA | ETF | 84.93 | 84.98 | 84.57 | 84.63 | 264100.0 |
| 2002-09-12 12:30:00 | DIA | ETF | 84.64 | 84.71 | 84.5 | 84.63 | 342100.0 |
| 2002-09-12 13:00:00 | DIA | ETF | 84.62 | 84.84 | 84.52 | 84.79 | 216800.0 |
> showing 50 of 532 rows — these rows as CSV