PREVIEW / etf_30min / 2001-04-09
file: by_date/etf_30min/2001/2001-04-09.parquet size: 15 KB rows: 357
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-09 09:30:00 | SPY | ETF | 114.0 | 114.65 | 113.62 | 114.31 | 1639200.0 |
| 2001-04-09 10:00:00 | SPY | ETF | 114.34 | 114.99 | 114.15 | 114.66 | 1186500.0 |
| 2001-04-09 10:30:00 | SPY | ETF | 114.77 | 114.95 | 114.31 | 114.4 | 1041700.0 |
| 2001-04-09 11:00:00 | SPY | ETF | 114.35 | 114.5 | 113.8 | 113.82 | 530000.0 |
| 2001-04-09 11:30:00 | SPY | ETF | 113.94 | 114.08 | 113.64 | 114.08 | 502500.0 |
| 2001-04-09 12:00:00 | SPY | ETF | 114.12 | 114.28 | 113.8 | 113.8 | 256800.0 |
| 2001-04-09 12:30:00 | SPY | ETF | 113.72 | 113.84 | 113.28 | 113.6 | 350100.0 |
| 2001-04-09 13:00:00 | SPY | ETF | 113.51 | 113.73 | 113.1 | 113.25 | 482600.0 |
| 2001-04-09 13:30:00 | SPY | ETF | 113.2 | 113.45 | 112.81 | 113.13 | 423100.0 |
| 2001-04-09 14:00:00 | SPY | ETF | 113.15 | 113.49 | 112.78 | 113.06 | 271500.0 |
| 2001-04-09 14:30:00 | SPY | ETF | 113.06 | 113.85 | 112.97 | 113.6 | 414800.0 |
| 2001-04-09 15:00:00 | SPY | ETF | 113.6 | 113.94 | 113.3 | 113.54 | 385500.0 |
| 2001-04-09 15:30:00 | SPY | ETF | 113.45 | 114.1 | 113.11 | 114.0 | 839900.0 |
| 2001-04-09 16:00:00 | SPY | ETF | 114.1 | 114.56 | 114.0 | 114.3 | 669300.0 |
| 2001-04-09 16:30:00 | SPY | ETF | 114.44 | 114.45 | 114.44 | 114.45 | 2000.0 |
| 2001-04-09 17:00:00 | SPY | ETF | 114.56 | 114.68 | 114.52 | 114.68 | 6300.0 |
| 2001-04-09 17:30:00 | SPY | ETF | 114.62 | 114.62 | 114.62 | 114.62 | 1100.0 |
| 2001-04-09 18:00:00 | SPY | ETF | 114.51 | 114.6 | 114.51 | 114.6 | 2600.0 |
| 2001-04-09 09:30:00 | QQQ | ETF | 36.79 | 37.39 | 36.5 | 36.95 | 8958000.0 |
| 2001-04-09 10:00:00 | QQQ | ETF | 36.99 | 37.24 | 36.8 | 36.86 | 4226400.0 |
| 2001-04-09 10:30:00 | QQQ | ETF | 36.9 | 37.02 | 36.56 | 36.61 | 5454000.0 |
| 2001-04-09 11:00:00 | QQQ | ETF | 36.62 | 36.72 | 36.31 | 36.32 | 4501600.0 |
| 2001-04-09 11:30:00 | QQQ | ETF | 36.37 | 36.48 | 36.25 | 36.47 | 2436200.0 |
| 2001-04-09 12:00:00 | QQQ | ETF | 36.46 | 36.61 | 36.36 | 36.41 | 1697000.0 |
| 2001-04-09 12:30:00 | QQQ | ETF | 36.41 | 36.46 | 36.18 | 36.39 | 2026400.0 |
| 2001-04-09 13:00:00 | QQQ | ETF | 36.31 | 36.41 | 35.94 | 36.03 | 2772000.0 |
| 2001-04-09 13:30:00 | QQQ | ETF | 36.05 | 36.15 | 35.85 | 36.0 | 2372900.0 |
| 2001-04-09 14:00:00 | QQQ | ETF | 35.99 | 36.24 | 35.86 | 36.06 | 2335800.0 |
| 2001-04-09 14:30:00 | QQQ | ETF | 36.06 | 36.55 | 36.0 | 36.36 | 3426800.0 |
| 2001-04-09 15:00:00 | QQQ | ETF | 36.36 | 36.64 | 36.24 | 36.44 | 3292200.0 |
| 2001-04-09 15:30:00 | QQQ | ETF | 36.41 | 36.99 | 36.24 | 36.95 | 4927100.0 |
| 2001-04-09 16:00:00 | QQQ | ETF | 36.93 | 37.15 | 36.8 | 37.07 | 2335700.0 |
| 2001-04-09 16:30:00 | QQQ | ETF | 37.06 | 37.19 | 37.02 | 37.12 | 92800.0 |
| 2001-04-09 17:00:00 | QQQ | ETF | 37.11 | 37.3 | 37.1 | 37.28 | 73500.0 |
| 2001-04-09 17:30:00 | QQQ | ETF | 37.3 | 37.5 | 37.16 | 37.3 | 26200.0 |
| 2001-04-09 18:00:00 | QQQ | ETF | 37.22 | 37.28 | 37.16 | 37.23 | 8500.0 |
| 2001-04-09 09:30:00 | IWM | ETF | 43.8 | 43.95 | 43.55 | 43.935 | 80200.0 |
| 2001-04-09 10:00:00 | IWM | ETF | 43.95 | 44.275 | 43.9 | 44.21 | 83400.0 |
| 2001-04-09 10:30:00 | IWM | ETF | 44.125 | 44.135 | 44.125 | 44.125 | 15400.0 |
| 2001-04-09 11:00:00 | IWM | ETF | 44.3 | 44.3 | 44.05 | 44.1 | 126400.0 |
| 2001-04-09 11:30:00 | IWM | ETF | 44.025 | 44.08 | 43.95 | 44.08 | 25400.0 |
| 2001-04-09 12:00:00 | IWM | ETF | 44.08 | 44.175 | 43.95 | 43.95 | 42600.0 |
| 2001-04-09 12:30:00 | IWM | ETF | 43.925 | 44.075 | 43.91 | 43.925 | 4000.0 |
| 2001-04-09 13:00:00 | IWM | ETF | 44.0 | 44.025 | 43.825 | 43.825 | 96400.0 |
| 2001-04-09 13:30:00 | IWM | ETF | 43.825 | 43.895 | 43.75 | 43.75 | 8600.0 |
| 2001-04-09 14:00:00 | IWM | ETF | 43.75 | 43.875 | 43.675 | 43.775 | 9000.0 |
| 2001-04-09 14:30:00 | IWM | ETF | 43.675 | 43.975 | 43.65 | 43.95 | 12600.0 |
| 2001-04-09 15:00:00 | IWM | ETF | 43.955 | 43.975 | 43.825 | 43.9 | 21200.0 |
| 2001-04-09 15:30:00 | IWM | ETF | 43.845 | 44.085 | 43.765 | 44.025 | 32200.0 |
| 2001-04-09 16:00:00 | IWM | ETF | 44.0 | 44.25 | 44.0 | 44.15 | 11400.0 |
> showing 50 of 357 rows — these rows as CSV