PREVIEW / etf_30min / 2001-04-19
file: by_date/etf_30min/2001/2001-04-19.parquet size: 15 KB rows: 372
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-04-19 09:30:00 | SPY | ETF | 124.25 | 124.4 | 123.7 | 123.94 | 1411600.0 |
| 2001-04-19 10:00:00 | SPY | ETF | 123.94 | 124.49 | 123.58 | 124.2 | 1068000.0 |
| 2001-04-19 10:30:00 | SPY | ETF | 124.21 | 124.84 | 124.18 | 124.73 | 963900.0 |
| 2001-04-19 11:00:00 | SPY | ETF | 124.73 | 124.98 | 124.11 | 124.23 | 958500.0 |
| 2001-04-19 11:30:00 | SPY | ETF | 124.33 | 124.38 | 124.01 | 124.01 | 385700.0 |
| 2001-04-19 12:00:00 | SPY | ETF | 124.07 | 124.64 | 123.92 | 124.43 | 833700.0 |
| 2001-04-19 12:30:00 | SPY | ETF | 124.59 | 124.6 | 124.17 | 124.52 | 1622200.0 |
| 2001-04-19 13:00:00 | SPY | ETF | 124.51 | 124.83 | 124.45 | 124.59 | 401100.0 |
| 2001-04-19 13:30:00 | SPY | ETF | 124.58 | 125.4 | 124.54 | 125.29 | 652700.0 |
| 2001-04-19 14:00:00 | SPY | ETF | 125.29 | 125.35 | 124.99 | 125.19 | 2329400.0 |
| 2001-04-19 14:30:00 | SPY | ETF | 125.22 | 125.49 | 124.85 | 125.01 | 392000.0 |
| 2001-04-19 15:00:00 | SPY | ETF | 125.05 | 125.28 | 124.63 | 125.08 | 589400.0 |
| 2001-04-19 15:30:00 | SPY | ETF | 125.02 | 125.83 | 125.02 | 125.72 | 1449300.0 |
| 2001-04-19 16:00:00 | SPY | ETF | 125.75 | 125.9 | 125.35 | 125.53 | 492100.0 |
| 2001-04-19 16:30:00 | SPY | ETF | 125.61 | 126.0 | 125.43 | 125.45 | 11200.0 |
| 2001-04-19 17:00:00 | SPY | ETF | 125.5 | 125.9 | 124.2 | 125.9 | 3400.0 |
| 2001-04-19 17:30:00 | SPY | ETF | 125.92 | 125.92 | 125.92 | 125.92 | 200.0 |
| 2001-04-19 18:00:00 | SPY | ETF | 125.92 | 126.0 | 125.92 | 126.0 | 1200.0 |
| 2001-04-19 09:30:00 | QQQ | ETF | 46.1 | 46.45 | 45.58 | 46.2 | 16597600.0 |
| 2001-04-19 10:00:00 | QQQ | ETF | 46.2 | 46.49 | 45.87 | 46.38 | 11412200.0 |
| 2001-04-19 10:30:00 | QQQ | ETF | 46.37 | 47.1 | 46.35 | 46.98 | 11127600.0 |
| 2001-04-19 11:00:00 | QQQ | ETF | 46.98 | 47.12 | 46.4 | 46.45 | 6270400.0 |
| 2001-04-19 11:30:00 | QQQ | ETF | 46.5 | 46.71 | 46.4 | 46.45 | 4151800.0 |
| 2001-04-19 12:00:00 | QQQ | ETF | 46.48 | 46.9 | 46.25 | 46.79 | 3427700.0 |
| 2001-04-19 12:30:00 | QQQ | ETF | 46.82 | 46.99 | 46.67 | 46.96 | 2755400.0 |
| 2001-04-19 13:00:00 | QQQ | ETF | 46.95 | 47.4 | 46.86 | 47.32 | 7324800.0 |
| 2001-04-19 13:30:00 | QQQ | ETF | 47.32 | 47.83 | 47.22 | 47.78 | 6531000.0 |
| 2001-04-19 14:00:00 | QQQ | ETF | 47.8 | 47.85 | 47.4 | 47.65 | 5810500.0 |
| 2001-04-19 14:30:00 | QQQ | ETF | 47.65 | 48.0 | 46.5 | 47.5 | 5678800.0 |
| 2001-04-19 15:00:00 | QQQ | ETF | 47.51 | 47.96 | 47.21 | 47.89 | 6064100.0 |
| 2001-04-19 15:30:00 | QQQ | ETF | 47.89 | 48.73 | 47.84 | 48.7 | 10080200.0 |
| 2001-04-19 16:00:00 | QQQ | ETF | 48.7 | 49.5 | 46.5 | 48.44 | 5229900.0 |
| 2001-04-19 16:30:00 | QQQ | ETF | 48.35 | 49.0 | 47.3 | 48.64 | 1294500.0 |
| 2001-04-19 17:00:00 | QQQ | ETF | 48.6 | 49.5 | 48.5 | 49.05 | 546900.0 |
| 2001-04-19 17:30:00 | QQQ | ETF | 49.05 | 49.25 | 48.95 | 49.1 | 253000.0 |
| 2001-04-19 18:00:00 | QQQ | ETF | 49.15 | 49.65 | 49.12 | 49.6 | 810000.0 |
| 2001-04-19 09:30:00 | IWM | ETF | 46.65 | 46.75 | 46.51 | 46.75 | 56000.0 |
| 2001-04-19 10:00:00 | IWM | ETF | 46.745 | 46.745 | 46.35 | 46.425 | 31600.0 |
| 2001-04-19 10:30:00 | IWM | ETF | 46.8 | 46.85 | 46.795 | 46.825 | 16600.0 |
| 2001-04-19 11:00:00 | IWM | ETF | 46.825 | 46.9 | 46.675 | 46.7 | 19400.0 |
| 2001-04-19 11:30:00 | IWM | ETF | 46.775 | 46.775 | 46.73 | 46.75 | 6800.0 |
| 2001-04-19 12:00:00 | IWM | ETF | 46.685 | 46.775 | 46.625 | 46.775 | 6000.0 |
| 2001-04-19 12:30:00 | IWM | ETF | 46.64 | 46.825 | 46.64 | 46.825 | 400.0 |
| 2001-04-19 13:00:00 | IWM | ETF | 46.825 | 47.0 | 46.825 | 47.0 | 5400.0 |
| 2001-04-19 13:30:00 | IWM | ETF | 46.985 | 47.2 | 46.95 | 47.2 | 12800.0 |
| 2001-04-19 14:00:00 | IWM | ETF | 47.2 | 47.2 | 46.975 | 47.12 | 30600.0 |
| 2001-04-19 14:30:00 | IWM | ETF | 47.125 | 47.125 | 47.0 | 47.0 | 2600.0 |
| 2001-04-19 15:00:00 | IWM | ETF | 46.855 | 47.02 | 46.725 | 46.995 | 4400.0 |
| 2001-04-19 15:30:00 | IWM | ETF | 47.105 | 47.245 | 46.95 | 47.195 | 9000.0 |
| 2001-04-19 09:30:00 | DIA | ETF | 106.4 | 106.45 | 105.7 | 105.9 | 741100.0 |
> showing 50 of 372 rows — these rows as CSV