PREVIEW / etf_30min / 2001-08-21
file: by_date/etf_30min/2001/2001-08-21.parquet size: 16 KB rows: 396
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-21 09:30:00 | SPY | ETF | 117.8 | 117.84 | 117.65 | 117.78 | 631100.0 |
| 2001-08-21 10:00:00 | SPY | ETF | 117.78 | 118.07 | 117.78 | 118.05 | 691500.0 |
| 2001-08-21 10:30:00 | SPY | ETF | 118.06 | 118.14 | 117.97 | 118.14 | 420900.0 |
| 2001-08-21 11:00:00 | SPY | ETF | 118.15 | 118.37 | 118.15 | 118.22 | 1099000.0 |
| 2001-08-21 11:30:00 | SPY | ETF | 118.26 | 118.39 | 118.15 | 118.19 | 458100.0 |
| 2001-08-21 12:00:00 | SPY | ETF | 118.17 | 118.27 | 118.17 | 118.2 | 227700.0 |
| 2001-08-21 12:30:00 | SPY | ETF | 118.22 | 118.34 | 118.19 | 118.26 | 470700.0 |
| 2001-08-21 13:00:00 | SPY | ETF | 118.26 | 118.44 | 118.23 | 118.38 | 480500.0 |
| 2001-08-21 13:30:00 | SPY | ETF | 118.36 | 118.51 | 118.3 | 118.47 | 798000.0 |
| 2001-08-21 14:00:00 | SPY | ETF | 118.49 | 118.54 | 117.7 | 117.95 | 2121800.0 |
| 2001-08-21 14:30:00 | SPY | ETF | 117.93 | 118.05 | 117.31 | 117.32 | 1442200.0 |
| 2001-08-21 15:00:00 | SPY | ETF | 117.3 | 117.35 | 116.65 | 116.84 | 1748800.0 |
| 2001-08-21 15:30:00 | SPY | ETF | 116.8 | 116.87 | 116.03 | 116.13 | 2204200.0 |
| 2001-08-21 16:00:00 | SPY | ETF | 116.12 | 116.12 | 115.76 | 115.98 | 876400.0 |
| 2001-08-21 16:30:00 | SPY | ETF | 115.92 | 116.05 | 115.92 | 115.95 | 55200.0 |
| 2001-08-21 17:00:00 | SPY | ETF | 115.9 | 115.9 | 115.9 | 115.9 | 100.0 |
| 2001-08-21 17:30:00 | SPY | ETF | 115.91 | 115.91 | 115.91 | 115.91 | 600.0 |
| 2001-08-21 18:00:00 | SPY | ETF | 116.0 | 116.0 | 116.0 | 116.0 | 100.0 |
| 2001-08-21 09:30:00 | QQQ | ETF | 38.29 | 38.45 | 38.19 | 38.33 | 3007400.0 |
| 2001-08-21 10:00:00 | QQQ | ETF | 38.32 | 38.49 | 38.32 | 38.42 | 3529500.0 |
| 2001-08-21 10:30:00 | QQQ | ETF | 38.45 | 38.5 | 38.3 | 38.39 | 3203100.0 |
| 2001-08-21 11:00:00 | QQQ | ETF | 38.37 | 38.49 | 38.35 | 38.45 | 1177400.0 |
| 2001-08-21 11:30:00 | QQQ | ETF | 38.46 | 38.58 | 38.42 | 38.46 | 1627400.0 |
| 2001-08-21 12:00:00 | QQQ | ETF | 38.46 | 38.56 | 38.46 | 38.51 | 1131100.0 |
| 2001-08-21 12:30:00 | QQQ | ETF | 38.51 | 38.55 | 38.44 | 38.46 | 1122300.0 |
| 2001-08-21 13:00:00 | QQQ | ETF | 38.47 | 38.5 | 38.42 | 38.46 | 1203700.0 |
| 2001-08-21 13:30:00 | QQQ | ETF | 38.46 | 38.58 | 38.43 | 38.57 | 3610100.0 |
| 2001-08-21 14:00:00 | QQQ | ETF | 38.56 | 38.65 | 38.07 | 38.27 | 7661100.0 |
| 2001-08-21 14:30:00 | QQQ | ETF | 38.25 | 38.31 | 37.84 | 37.84 | 6129300.0 |
| 2001-08-21 15:00:00 | QQQ | ETF | 37.86 | 37.88 | 37.45 | 37.5 | 7311600.0 |
| 2001-08-21 15:30:00 | QQQ | ETF | 37.52 | 37.54 | 36.89 | 36.92 | 10469400.0 |
| 2001-08-21 16:00:00 | QQQ | ETF | 36.91 | 37.15 | 36.64 | 36.65 | 2584800.0 |
| 2001-08-21 16:30:00 | QQQ | ETF | 36.65 | 36.65 | 36.61 | 36.62 | 41700.0 |
| 2001-08-21 17:00:00 | QQQ | ETF | 36.61 | 36.71 | 36.6 | 36.68 | 63300.0 |
| 2001-08-21 17:30:00 | QQQ | ETF | 36.68 | 36.97 | 36.59 | 36.77 | 74600.0 |
| 2001-08-21 18:00:00 | QQQ | ETF | 36.77 | 36.88 | 36.62 | 36.81 | 50700.0 |
| 2001-08-21 09:30:00 | IWM | ETF | 47.85 | 47.85 | 47.75 | 47.82 | 4200.0 |
| 2001-08-21 10:00:00 | IWM | ETF | 47.655 | 47.8 | 47.655 | 47.785 | 223200.0 |
| 2001-08-21 10:30:00 | IWM | ETF | 47.85 | 47.95 | 47.75 | 47.75 | 110000.0 |
| 2001-08-21 11:00:00 | IWM | ETF | 47.9 | 47.945 | 47.83 | 47.83 | 2200.0 |
| 2001-08-21 11:30:00 | IWM | ETF | 47.92 | 47.95 | 47.855 | 47.925 | 4200.0 |
| 2001-08-21 12:00:00 | IWM | ETF | 47.925 | 47.925 | 47.865 | 47.925 | 3000.0 |
| 2001-08-21 12:30:00 | IWM | ETF | 47.935 | 47.935 | 47.86 | 47.86 | 1600.0 |
| 2001-08-21 13:00:00 | IWM | ETF | 47.975 | 47.985 | 47.95 | 47.95 | 1400.0 |
| 2001-08-21 13:30:00 | IWM | ETF | 47.95 | 47.975 | 47.95 | 47.975 | 1600.0 |
| 2001-08-21 14:00:00 | IWM | ETF | 47.99 | 48.0 | 47.525 | 47.7 | 109400.0 |
| 2001-08-21 14:30:00 | IWM | ETF | 47.8 | 47.8 | 47.7 | 47.7 | 1400.0 |
| 2001-08-21 15:00:00 | IWM | ETF | 47.375 | 47.425 | 47.375 | 47.425 | 9000.0 |
| 2001-08-21 15:30:00 | IWM | ETF | 47.335 | 47.335 | 47.0 | 47.0 | 433000.0 |
| 2001-08-21 16:00:00 | IWM | ETF | 47.15 | 47.15 | 47.15 | 47.15 | 800.0 |
> showing 50 of 396 rows — these rows as CSV