PREVIEW / etf_30min / 2001-05-04
file: by_date/etf_30min/2001/2001-05-04.parquet size: 15 KB rows: 356
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 |
|---|---|---|---|---|---|---|---|
| 2001-05-04 09:30:00 | SPY | ETF | 123.65 | 124.09 | 123.44 | 124.01 | 753200.0 |
| 2001-05-04 10:00:00 | SPY | ETF | 124.05 | 124.92 | 123.71 | 124.82 | 1119400.0 |
| 2001-05-04 10:30:00 | SPY | ETF | 124.77 | 125.42 | 124.73 | 125.19 | 1691900.0 |
| 2001-05-04 11:00:00 | SPY | ETF | 125.3 | 125.96 | 125.27 | 125.31 | 873700.0 |
| 2001-05-04 11:30:00 | SPY | ETF | 125.39 | 125.84 | 125.11 | 125.69 | 421200.0 |
| 2001-05-04 12:00:00 | SPY | ETF | 125.75 | 126.48 | 125.52 | 126.33 | 702300.0 |
| 2001-05-04 12:30:00 | SPY | ETF | 126.31 | 126.61 | 126.1 | 126.37 | 545700.0 |
| 2001-05-04 13:00:00 | SPY | ETF | 126.4 | 126.49 | 125.94 | 126.11 | 616000.0 |
| 2001-05-04 13:30:00 | SPY | ETF | 126.15 | 126.54 | 126.02 | 126.37 | 355700.0 |
| 2001-05-04 14:00:00 | SPY | ETF | 126.32 | 126.79 | 126.29 | 126.48 | 463800.0 |
| 2001-05-04 14:30:00 | SPY | ETF | 126.43 | 126.57 | 126.06 | 126.36 | 527000.0 |
| 2001-05-04 15:00:00 | SPY | ETF | 126.38 | 127.1 | 126.31 | 126.8 | 690200.0 |
| 2001-05-04 15:30:00 | SPY | ETF | 126.79 | 127.2 | 126.77 | 126.95 | 1190000.0 |
| 2001-05-04 16:00:00 | SPY | ETF | 127.04 | 127.35 | 126.78 | 127.28 | 468000.0 |
| 2001-05-04 16:30:00 | SPY | ETF | 127.28 | 127.28 | 127.1 | 127.1 | 1300.0 |
| 2001-05-04 09:30:00 | QQQ | ETF | 45.32 | 45.74 | 45.22 | 45.54 | 5232800.0 |
| 2001-05-04 10:00:00 | QQQ | ETF | 45.59 | 46.08 | 45.3 | 46.0 | 6405300.0 |
| 2001-05-04 10:30:00 | QQQ | ETF | 46.0 | 46.92 | 45.8 | 46.65 | 9723900.0 |
| 2001-05-04 11:00:00 | QQQ | ETF | 46.63 | 47.13 | 46.49 | 46.58 | 5716000.0 |
| 2001-05-04 11:30:00 | QQQ | ETF | 46.58 | 47.1 | 46.4 | 46.99 | 3943900.0 |
| 2001-05-04 12:00:00 | QQQ | ETF | 46.95 | 47.7 | 46.83 | 47.5 | 4443300.0 |
| 2001-05-04 12:30:00 | QQQ | ETF | 47.58 | 47.95 | 47.39 | 47.85 | 3021600.0 |
| 2001-05-04 13:00:00 | QQQ | ETF | 47.85 | 47.9 | 47.32 | 47.5 | 3502600.0 |
| 2001-05-04 13:30:00 | QQQ | ETF | 47.5 | 47.9 | 47.41 | 47.71 | 2727600.0 |
| 2001-05-04 14:00:00 | QQQ | ETF | 47.73 | 48.16 | 47.66 | 47.77 | 4135200.0 |
| 2001-05-04 14:30:00 | QQQ | ETF | 47.76 | 47.85 | 47.16 | 47.6 | 3935900.0 |
| 2001-05-04 15:00:00 | QQQ | ETF | 47.64 | 48.08 | 47.52 | 47.88 | 3932200.0 |
| 2001-05-04 15:30:00 | QQQ | ETF | 47.9 | 48.06 | 47.66 | 47.95 | 4219200.0 |
| 2001-05-04 16:00:00 | QQQ | ETF | 47.94 | 48.2 | 47.49 | 48.0 | 1393600.0 |
| 2001-05-04 16:30:00 | QQQ | ETF | 48.16 | 48.25 | 48.0 | 48.15 | 36800.0 |
| 2001-05-04 17:00:00 | QQQ | ETF | 48.12 | 48.17 | 48.1 | 48.15 | 26400.0 |
| 2001-05-04 17:30:00 | QQQ | ETF | 48.12 | 48.16 | 48.0 | 48.11 | 10800.0 |
| 2001-05-04 18:00:00 | QQQ | ETF | 48.07 | 48.2 | 48.07 | 48.1 | 3300.0 |
| 2001-05-04 09:30:00 | IWM | ETF | 47.9 | 48.05 | 47.735 | 47.875 | 208000.0 |
| 2001-05-04 10:00:00 | IWM | ETF | 47.995 | 48.195 | 47.985 | 48.195 | 43000.0 |
| 2001-05-04 10:30:00 | IWM | ETF | 48.25 | 48.35 | 48.1 | 48.155 | 27800.0 |
| 2001-05-04 11:00:00 | IWM | ETF | 48.4 | 48.525 | 48.255 | 48.255 | 45600.0 |
| 2001-05-04 11:30:00 | IWM | ETF | 48.345 | 48.435 | 48.345 | 48.435 | 13600.0 |
| 2001-05-04 12:00:00 | IWM | ETF | 48.495 | 48.75 | 48.365 | 48.7 | 120400.0 |
| 2001-05-04 12:30:00 | IWM | ETF | 48.72 | 48.72 | 48.51 | 48.715 | 1400.0 |
| 2001-05-04 13:00:00 | IWM | ETF | 48.77 | 48.825 | 48.75 | 48.765 | 14800.0 |
| 2001-05-04 13:30:00 | IWM | ETF | 48.775 | 48.875 | 48.7 | 48.7 | 12000.0 |
| 2001-05-04 14:00:00 | IWM | ETF | 48.7 | 48.95 | 48.7 | 48.85 | 15200.0 |
| 2001-05-04 14:30:00 | IWM | ETF | 48.825 | 48.95 | 48.7 | 48.7 | 6400.0 |
| 2001-05-04 15:00:00 | IWM | ETF | 48.835 | 49.05 | 48.71 | 48.95 | 60600.0 |
| 2001-05-04 15:30:00 | IWM | ETF | 49.0 | 49.145 | 49.0 | 49.145 | 135200.0 |
| 2001-05-04 16:00:00 | IWM | ETF | 49.15 | 49.15 | 49.05 | 49.05 | 6000.0 |
| 2001-05-04 09:30:00 | DIA | ETF | 106.97 | 107.23 | 106.77 | 107.2 | 276900.0 |
| 2001-05-04 10:00:00 | DIA | ETF | 107.29 | 108.2 | 107.01 | 107.9 | 553700.0 |
| 2001-05-04 10:30:00 | DIA | ETF | 107.94 | 108.3 | 107.76 | 108.11 | 1769400.0 |
> showing 50 of 356 rows — these rows as CSV