PREVIEW / etf_30min / 2001-03-19
file: by_date/etf_30min/2001/2001-03-19.parquet size: 14 KB rows: 350
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-03-19 09:30:00 | SPY | ETF | 115.76 | 116.06 | 115.4 | 115.62 | 1773500.0 |
| 2001-03-19 10:00:00 | SPY | ETF | 115.5 | 116.13 | 115.42 | 115.49 | 947100.0 |
| 2001-03-19 10:30:00 | SPY | ETF | 115.56 | 115.8 | 115.36 | 115.58 | 270500.0 |
| 2001-03-19 11:00:00 | SPY | ETF | 115.6 | 115.76 | 115.4 | 115.44 | 155900.0 |
| 2001-03-19 11:30:00 | SPY | ETF | 115.5 | 115.66 | 115.01 | 115.01 | 145200.0 |
| 2001-03-19 12:00:00 | SPY | ETF | 115.01 | 115.26 | 114.82 | 115.17 | 416300.0 |
| 2001-03-19 12:30:00 | SPY | ETF | 115.25 | 115.54 | 115.02 | 115.35 | 379000.0 |
| 2001-03-19 13:00:00 | SPY | ETF | 115.37 | 115.64 | 115.34 | 115.52 | 157200.0 |
| 2001-03-19 13:30:00 | SPY | ETF | 115.6 | 115.87 | 115.53 | 115.79 | 566100.0 |
| 2001-03-19 14:00:00 | SPY | ETF | 115.77 | 116.53 | 115.6 | 116.53 | 438200.0 |
| 2001-03-19 14:30:00 | SPY | ETF | 116.55 | 117.21 | 116.41 | 117.16 | 1560700.0 |
| 2001-03-19 15:00:00 | SPY | ETF | 117.21 | 117.69 | 116.95 | 117.49 | 1189400.0 |
| 2001-03-19 15:30:00 | SPY | ETF | 117.48 | 117.69 | 117.06 | 117.3 | 1211500.0 |
| 2001-03-19 16:00:00 | SPY | ETF | 117.3 | 117.67 | 115.55 | 115.55 | 525000.0 |
| 2001-03-19 16:30:00 | SPY | ETF | 117.05 | 117.55 | 117.05 | 117.55 | 600.0 |
| 2001-03-19 17:30:00 | SPY | ETF | 117.35 | 117.35 | 117.35 | 117.35 | 2100.0 |
| 2001-03-19 09:30:00 | QQQ | ETF | 41.44 | 41.76 | 40.94 | 41.29 | 7087000.0 |
| 2001-03-19 10:00:00 | QQQ | ETF | 41.3 | 41.79 | 41.19 | 41.35 | 4055200.0 |
| 2001-03-19 10:30:00 | QQQ | ETF | 41.35 | 41.49 | 41.02 | 41.32 | 2413800.0 |
| 2001-03-19 11:00:00 | QQQ | ETF | 41.35 | 41.49 | 41.1 | 41.11 | 1890500.0 |
| 2001-03-19 11:30:00 | QQQ | ETF | 41.11 | 41.2 | 40.76 | 40.81 | 2985800.0 |
| 2001-03-19 12:00:00 | QQQ | ETF | 40.81 | 41.0 | 40.75 | 40.96 | 1673100.0 |
| 2001-03-19 12:30:00 | QQQ | ETF | 40.95 | 41.25 | 40.85 | 41.14 | 1807100.0 |
| 2001-03-19 13:00:00 | QQQ | ETF | 41.12 | 41.35 | 41.01 | 41.2 | 1721300.0 |
| 2001-03-19 13:30:00 | QQQ | ETF | 41.2 | 41.49 | 41.18 | 41.36 | 1914800.0 |
| 2001-03-19 14:00:00 | QQQ | ETF | 41.4 | 42.2 | 41.28 | 42.2 | 4760600.0 |
| 2001-03-19 14:30:00 | QQQ | ETF | 42.2 | 42.86 | 42.11 | 42.8 | 5857800.0 |
| 2001-03-19 15:00:00 | QQQ | ETF | 42.77 | 43.02 | 42.5 | 43.0 | 7065900.0 |
| 2001-03-19 15:30:00 | QQQ | ETF | 42.96 | 43.25 | 42.82 | 43.19 | 5545400.0 |
| 2001-03-19 16:00:00 | QQQ | ETF | 43.2 | 43.3 | 43.04 | 43.1 | 1598900.0 |
| 2001-03-19 16:30:00 | QQQ | ETF | 43.11 | 43.25 | 43.1 | 43.15 | 69100.0 |
| 2001-03-19 17:00:00 | QQQ | ETF | 43.15 | 43.3 | 43.15 | 43.27 | 120300.0 |
| 2001-03-19 17:30:00 | QQQ | ETF | 43.25 | 43.31 | 43.18 | 43.29 | 56700.0 |
| 2001-03-19 18:00:00 | QQQ | ETF | 43.26 | 43.33 | 43.22 | 43.29 | 15500.0 |
| 2001-03-19 18:30:00 | QQQ | ETF | 43.3 | 43.3 | 43.3 | 43.3 | 500.0 |
| 2001-03-19 09:30:00 | IWM | ETF | 44.5 | 44.5 | 44.025 | 44.05 | 11000.0 |
| 2001-03-19 10:00:00 | IWM | ETF | 44.1 | 44.15 | 43.925 | 43.925 | 14200.0 |
| 2001-03-19 10:30:00 | IWM | ETF | 44.05 | 44.05 | 43.925 | 43.925 | 2400.0 |
| 2001-03-19 11:30:00 | IWM | ETF | 44.12 | 44.12 | 43.975 | 43.975 | 12000.0 |
| 2001-03-19 12:00:00 | IWM | ETF | 43.875 | 43.985 | 43.755 | 43.985 | 61200.0 |
| 2001-03-19 12:30:00 | IWM | ETF | 43.925 | 44.15 | 43.925 | 44.15 | 3600.0 |
| 2001-03-19 13:00:00 | IWM | ETF | 44.0 | 44.1 | 44.0 | 44.1 | 20800.0 |
| 2001-03-19 14:00:00 | IWM | ETF | 44.0 | 44.25 | 43.975 | 44.25 | 7600.0 |
| 2001-03-19 14:30:00 | IWM | ETF | 44.475 | 44.475 | 44.38 | 44.46 | 47600.0 |
| 2001-03-19 15:00:00 | IWM | ETF | 44.5 | 44.625 | 44.45 | 44.595 | 394000.0 |
| 2001-03-19 15:30:00 | IWM | ETF | 44.675 | 45.05 | 44.675 | 45.05 | 157200.0 |
| 2001-03-19 16:00:00 | IWM | ETF | 44.95 | 45.2 | 44.89 | 45.15 | 52000.0 |
| 2001-03-19 09:30:00 | DIA | ETF | 98.91 | 99.06 | 98.45 | 98.64 | 640800.0 |
| 2001-03-19 10:00:00 | DIA | ETF | 98.75 | 99.1 | 98.55 | 98.6 | 691600.0 |
| 2001-03-19 10:30:00 | DIA | ETF | 98.73 | 98.9 | 98.6 | 98.75 | 233700.0 |
> showing 50 of 350 rows — these rows as CSV