PREVIEW / etf_30min / 2001-04-25
file: by_date/etf_30min/2001/2001-04-25.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-04-25 09:30:00 | SPY | ETF | 121.42 | 121.65 | 120.95 | 121.5 | 1020600.0 |
| 2001-04-25 10:00:00 | SPY | ETF | 121.44 | 122.25 | 121.4 | 121.82 | 1089300.0 |
| 2001-04-25 10:30:00 | SPY | ETF | 121.8 | 122.26 | 121.62 | 121.85 | 438900.0 |
| 2001-04-25 11:00:00 | SPY | ETF | 121.78 | 122.13 | 121.57 | 122.1 | 505100.0 |
| 2001-04-25 11:30:00 | SPY | ETF | 122.03 | 122.39 | 121.86 | 122.02 | 304300.0 |
| 2001-04-25 12:00:00 | SPY | ETF | 122.0 | 122.13 | 121.83 | 121.95 | 123700.0 |
| 2001-04-25 12:30:00 | SPY | ETF | 121.98 | 122.08 | 121.65 | 121.75 | 240000.0 |
| 2001-04-25 13:00:00 | SPY | ETF | 121.71 | 121.92 | 121.53 | 121.9 | 185200.0 |
| 2001-04-25 13:30:00 | SPY | ETF | 121.92 | 122.37 | 121.85 | 122.3 | 187500.0 |
| 2001-04-25 14:00:00 | SPY | ETF | 122.34 | 122.7 | 122.0 | 122.52 | 433400.0 |
| 2001-04-25 14:30:00 | SPY | ETF | 122.51 | 123.36 | 122.31 | 123.2 | 867800.0 |
| 2001-04-25 15:00:00 | SPY | ETF | 123.3 | 123.63 | 123.06 | 123.53 | 930900.0 |
| 2001-04-25 15:30:00 | SPY | ETF | 123.53 | 123.67 | 123.02 | 123.24 | 1112200.0 |
| 2001-04-25 16:00:00 | SPY | ETF | 123.29 | 123.3 | 122.97 | 123.11 | 299600.0 |
| 2001-04-25 16:30:00 | SPY | ETF | 123.05 | 123.05 | 122.84 | 122.94 | 3100.0 |
| 2001-04-25 17:00:00 | SPY | ETF | 123.0 | 123.0 | 122.67 | 122.68 | 600.0 |
| 2001-04-25 17:30:00 | SPY | ETF | 122.83 | 122.83 | 122.76 | 122.8 | 4000.0 |
| 2001-04-25 18:00:00 | SPY | ETF | 122.82 | 122.82 | 122.82 | 122.82 | 500.0 |
| 2001-04-25 09:30:00 | QQQ | ETF | 43.9 | 44.33 | 43.43 | 43.71 | 8865700.0 |
| 2001-04-25 10:00:00 | QQQ | ETF | 43.7 | 44.47 | 43.65 | 44.18 | 6112800.0 |
| 2001-04-25 10:30:00 | QQQ | ETF | 44.16 | 44.72 | 43.9 | 44.45 | 5294500.0 |
| 2001-04-25 11:00:00 | QQQ | ETF | 44.45 | 44.72 | 44.15 | 44.51 | 3962600.0 |
| 2001-04-25 11:30:00 | QQQ | ETF | 44.52 | 44.73 | 44.3 | 44.31 | 3006700.0 |
| 2001-04-25 12:00:00 | QQQ | ETF | 44.29 | 44.38 | 44.1 | 44.25 | 2076600.0 |
| 2001-04-25 12:30:00 | QQQ | ETF | 44.25 | 44.28 | 43.8 | 43.83 | 2449700.0 |
| 2001-04-25 13:00:00 | QQQ | ETF | 43.86 | 44.1 | 43.69 | 44.05 | 3003700.0 |
| 2001-04-25 13:30:00 | QQQ | ETF | 44.07 | 44.49 | 44.0 | 44.49 | 3238100.0 |
| 2001-04-25 14:00:00 | QQQ | ETF | 44.49 | 44.85 | 44.24 | 44.68 | 6547800.0 |
| 2001-04-25 14:30:00 | QQQ | ETF | 44.73 | 45.42 | 44.57 | 45.33 | 7366500.0 |
| 2001-04-25 15:00:00 | QQQ | ETF | 45.31 | 45.58 | 45.07 | 45.32 | 3905100.0 |
| 2001-04-25 15:30:00 | QQQ | ETF | 45.38 | 45.52 | 45.07 | 45.2 | 4458300.0 |
| 2001-04-25 16:00:00 | QQQ | ETF | 45.23 | 45.37 | 44.95 | 45.34 | 1122800.0 |
| 2001-04-25 16:30:00 | QQQ | ETF | 45.39 | 45.4 | 44.66 | 44.8 | 822600.0 |
| 2001-04-25 17:00:00 | QQQ | ETF | 44.84 | 45.3 | 44.45 | 44.73 | 539200.0 |
| 2001-04-25 17:30:00 | QQQ | ETF | 44.72 | 44.8 | 44.6 | 44.68 | 139300.0 |
| 2001-04-25 18:00:00 | QQQ | ETF | 44.7 | 44.8 | 44.66 | 44.75 | 83100.0 |
| 2001-04-25 09:30:00 | IWM | ETF | 46.25 | 46.25 | 45.955 | 46.195 | 27400.0 |
| 2001-04-25 10:00:00 | IWM | ETF | 46.145 | 46.7 | 46.145 | 46.65 | 95200.0 |
| 2001-04-25 10:30:00 | IWM | ETF | 46.65 | 46.65 | 46.6 | 46.6 | 38200.0 |
| 2001-04-25 11:00:00 | IWM | ETF | 46.75 | 46.85 | 46.75 | 46.8 | 5600.0 |
| 2001-04-25 11:30:00 | IWM | ETF | 46.825 | 46.85 | 46.7 | 46.85 | 60000.0 |
| 2001-04-25 12:00:00 | IWM | ETF | 46.8 | 46.8 | 46.61 | 46.61 | 4800.0 |
| 2001-04-25 12:30:00 | IWM | ETF | 46.725 | 46.725 | 46.725 | 46.725 | 1400.0 |
| 2001-04-25 13:00:00 | IWM | ETF | 46.61 | 46.715 | 46.61 | 46.625 | 10600.0 |
| 2001-04-25 13:30:00 | IWM | ETF | 46.675 | 46.825 | 46.675 | 46.8 | 8200.0 |
| 2001-04-25 14:00:00 | IWM | ETF | 46.8 | 46.8 | 46.7 | 46.75 | 8400.0 |
| 2001-04-25 14:30:00 | IWM | ETF | 46.95 | 47.025 | 46.95 | 47.0 | 2000.0 |
| 2001-04-25 15:00:00 | IWM | ETF | 46.995 | 47.175 | 46.995 | 47.175 | 64200.0 |
| 2001-04-25 15:30:00 | IWM | ETF | 47.175 | 47.2 | 47.015 | 47.09 | 44400.0 |
| 2001-04-25 16:00:00 | IWM | ETF | 47.05 | 47.175 | 47.05 | 47.15 | 11800.0 |
> showing 50 of 356 rows — these rows as CSV