PREVIEW / etf_30min / 2001-08-10
file: by_date/etf_30min/2001/2001-08-10.parquet size: 15 KB rows: 360
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-08-10 09:30:00 | SPY | ETF | 118.8 | 118.87 | 118.43 | 118.58 | 1168200.0 |
| 2001-08-10 10:00:00 | SPY | ETF | 118.55 | 118.63 | 117.34 | 117.68 | 1220000.0 |
| 2001-08-10 10:30:00 | SPY | ETF | 117.7 | 117.85 | 117.62 | 117.73 | 832200.0 |
| 2001-08-10 11:00:00 | SPY | ETF | 117.76 | 117.99 | 117.45 | 117.93 | 1243700.0 |
| 2001-08-10 11:30:00 | SPY | ETF | 117.95 | 118.26 | 117.9 | 118.06 | 496100.0 |
| 2001-08-10 12:00:00 | SPY | ETF | 118.06 | 118.13 | 117.91 | 117.99 | 399900.0 |
| 2001-08-10 12:30:00 | SPY | ETF | 118.0 | 119.32 | 117.98 | 119.0 | 847700.0 |
| 2001-08-10 13:00:00 | SPY | ETF | 119.05 | 119.37 | 119.0 | 119.26 | 960000.0 |
| 2001-08-10 13:30:00 | SPY | ETF | 119.25 | 119.68 | 119.17 | 119.43 | 1017100.0 |
| 2001-08-10 14:00:00 | SPY | ETF | 119.33 | 119.43 | 119.0 | 119.39 | 443100.0 |
| 2001-08-10 14:30:00 | SPY | ETF | 119.4 | 119.71 | 119.32 | 119.68 | 578900.0 |
| 2001-08-10 15:00:00 | SPY | ETF | 119.68 | 119.84 | 119.24 | 119.42 | 667200.0 |
| 2001-08-10 15:30:00 | SPY | ETF | 119.43 | 119.62 | 119.16 | 119.44 | 570400.0 |
| 2001-08-10 16:00:00 | SPY | ETF | 119.55 | 119.55 | 119.26 | 119.35 | 453800.0 |
| 2001-08-10 16:30:00 | SPY | ETF | 118.75 | 119.27 | 118.51 | 118.51 | 1600.0 |
| 2001-08-10 17:00:00 | SPY | ETF | 119.24 | 119.3 | 119.24 | 119.3 | 600.0 |
| 2001-08-10 09:30:00 | QQQ | ETF | 40.42 | 40.75 | 40.12 | 40.2 | 6353000.0 |
| 2001-08-10 10:00:00 | QQQ | ETF | 40.2 | 40.25 | 39.23 | 39.58 | 13511500.0 |
| 2001-08-10 10:30:00 | QQQ | ETF | 39.58 | 39.74 | 39.46 | 39.55 | 5087900.0 |
| 2001-08-10 11:00:00 | QQQ | ETF | 39.55 | 39.7 | 39.37 | 39.69 | 4446300.0 |
| 2001-08-10 11:30:00 | QQQ | ETF | 39.68 | 39.99 | 39.65 | 39.81 | 6001700.0 |
| 2001-08-10 12:00:00 | QQQ | ETF | 39.81 | 39.83 | 39.5 | 39.67 | 4780300.0 |
| 2001-08-10 12:30:00 | QQQ | ETF | 39.65 | 40.22 | 39.61 | 40.2 | 2998600.0 |
| 2001-08-10 13:00:00 | QQQ | ETF | 40.17 | 40.31 | 40.0 | 40.18 | 4554300.0 |
| 2001-08-10 13:30:00 | QQQ | ETF | 40.2 | 40.52 | 40.16 | 40.35 | 3675900.0 |
| 2001-08-10 14:00:00 | QQQ | ETF | 40.37 | 40.42 | 40.1 | 40.31 | 2199300.0 |
| 2001-08-10 14:30:00 | QQQ | ETF | 40.29 | 40.62 | 40.22 | 40.6 | 3122200.0 |
| 2001-08-10 15:00:00 | QQQ | ETF | 40.6 | 40.68 | 40.26 | 40.4 | 3498000.0 |
| 2001-08-10 15:30:00 | QQQ | ETF | 40.41 | 40.49 | 40.21 | 40.33 | 4223400.0 |
| 2001-08-10 16:00:00 | QQQ | ETF | 40.35 | 40.38 | 40.08 | 40.28 | 943400.0 |
| 2001-08-10 16:30:00 | QQQ | ETF | 40.28 | 40.34 | 40.17 | 40.17 | 39800.0 |
| 2001-08-10 17:00:00 | QQQ | ETF | 40.16 | 40.3 | 40.0 | 40.1 | 37100.0 |
| 2001-08-10 17:30:00 | QQQ | ETF | 40.1 | 40.23 | 40.05 | 40.1 | 24900.0 |
| 2001-08-10 18:00:00 | QQQ | ETF | 40.1 | 40.18 | 40.05 | 40.1 | 26200.0 |
| 2001-08-10 09:30:00 | IWM | ETF | 47.175 | 47.295 | 47.175 | 47.25 | 54000.0 |
| 2001-08-10 10:00:00 | IWM | ETF | 47.245 | 47.245 | 46.755 | 46.925 | 11400.0 |
| 2001-08-10 10:30:00 | IWM | ETF | 46.78 | 46.925 | 46.78 | 46.925 | 13200.0 |
| 2001-08-10 11:00:00 | IWM | ETF | 46.825 | 46.995 | 46.8 | 46.995 | 106200.0 |
| 2001-08-10 11:30:00 | IWM | ETF | 46.995 | 46.995 | 46.995 | 46.995 | 2200.0 |
| 2001-08-10 12:00:00 | IWM | ETF | 47.01 | 47.01 | 47.0 | 47.0 | 1800.0 |
| 2001-08-10 12:30:00 | IWM | ETF | 46.86 | 47.15 | 46.86 | 47.125 | 15800.0 |
| 2001-08-10 13:00:00 | IWM | ETF | 47.15 | 47.55 | 47.15 | 47.45 | 32000.0 |
| 2001-08-10 13:30:00 | IWM | ETF | 47.5 | 47.525 | 47.35 | 47.45 | 22600.0 |
| 2001-08-10 14:00:00 | IWM | ETF | 47.45 | 47.45 | 47.28 | 47.285 | 9800.0 |
| 2001-08-10 14:30:00 | IWM | ETF | 47.285 | 47.45 | 47.285 | 47.45 | 7600.0 |
| 2001-08-10 15:00:00 | IWM | ETF | 47.435 | 47.585 | 47.405 | 47.545 | 61400.0 |
| 2001-08-10 15:30:00 | IWM | ETF | 47.435 | 47.6 | 47.28 | 47.28 | 83200.0 |
| 2001-08-10 16:00:00 | IWM | ETF | 47.3 | 47.3 | 47.3 | 47.3 | 2000.0 |
| 2001-08-10 09:30:00 | DIA | ETF | 102.93 | 103.29 | 102.93 | 103.09 | 332600.0 |
| 2001-08-10 10:00:00 | DIA | ETF | 103.11 | 103.15 | 102.02 | 102.32 | 447600.0 |
> showing 50 of 360 rows — these rows as CSV