PREVIEW / etf_30min / 2001-12-14
file: by_date/etf_30min/2001/2001-12-14.parquet size: 17 KB rows: 442
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-12-14 09:30:00 | SPY | ETF | 112.33 | 112.62 | 112.16 | 112.29 | 2501000.0 |
| 2001-12-14 10:00:00 | SPY | ETF | 112.34 | 112.4 | 112.08 | 112.29 | 1280300.0 |
| 2001-12-14 10:30:00 | SPY | ETF | 112.27 | 112.7 | 112.0 | 112.7 | 1655900.0 |
| 2001-12-14 11:00:00 | SPY | ETF | 112.7 | 112.74 | 112.16 | 112.24 | 911400.0 |
| 2001-12-14 11:30:00 | SPY | ETF | 112.16 | 112.54 | 112.15 | 112.49 | 433400.0 |
| 2001-12-14 12:00:00 | SPY | ETF | 112.49 | 112.61 | 112.32 | 112.45 | 356800.0 |
| 2001-12-14 12:30:00 | SPY | ETF | 112.45 | 112.45 | 112.13 | 112.23 | 774500.0 |
| 2001-12-14 13:00:00 | SPY | ETF | 112.29 | 112.44 | 112.05 | 112.38 | 612900.0 |
| 2001-12-14 13:30:00 | SPY | ETF | 112.38 | 112.49 | 112.16 | 112.31 | 354400.0 |
| 2001-12-14 14:00:00 | SPY | ETF | 112.25 | 112.64 | 112.25 | 112.6 | 634500.0 |
| 2001-12-14 14:30:00 | SPY | ETF | 112.63 | 112.97 | 112.55 | 112.93 | 1793100.0 |
| 2001-12-14 15:00:00 | SPY | ETF | 112.95 | 113.49 | 112.91 | 113.03 | 2192400.0 |
| 2001-12-14 15:30:00 | SPY | ETF | 113.02 | 113.1 | 112.71 | 112.9 | 1682300.0 |
| 2001-12-14 16:00:00 | SPY | ETF | 112.9 | 113.24 | 112.9 | 113.13 | 1431100.0 |
| 2001-12-14 16:30:00 | SPY | ETF | 113.17 | 113.18 | 112.95 | 113.18 | 19900.0 |
| 2001-12-14 17:00:00 | SPY | ETF | 113.03 | 113.1 | 113.0 | 113.0 | 4600.0 |
| 2001-12-14 17:30:00 | SPY | ETF | 113.15 | 113.35 | 113.15 | 113.15 | 800.0 |
| 2001-12-14 18:00:00 | SPY | ETF | 113.2 | 113.24 | 113.2 | 113.24 | 400.0 |
| 2001-12-14 09:30:00 | QQQ | ETF | 39.87 | 40.15 | 39.76 | 39.97 | 9984300.0 |
| 2001-12-14 10:00:00 | QQQ | ETF | 39.95 | 40.04 | 39.77 | 39.9 | 6108500.0 |
| 2001-12-14 10:30:00 | QQQ | ETF | 39.91 | 40.07 | 39.58 | 40.06 | 6360200.0 |
| 2001-12-14 11:00:00 | QQQ | ETF | 40.06 | 40.13 | 39.69 | 39.87 | 5218500.0 |
| 2001-12-14 11:30:00 | QQQ | ETF | 39.89 | 40.1 | 39.84 | 40.08 | 2634600.0 |
| 2001-12-14 12:00:00 | QQQ | ETF | 40.01 | 40.14 | 39.91 | 39.94 | 1831900.0 |
| 2001-12-14 12:30:00 | QQQ | ETF | 39.95 | 39.97 | 39.61 | 39.72 | 3155400.0 |
| 2001-12-14 13:00:00 | QQQ | ETF | 39.71 | 39.87 | 39.59 | 39.82 | 2415700.0 |
| 2001-12-14 13:30:00 | QQQ | ETF | 39.81 | 39.84 | 39.57 | 39.62 | 3358400.0 |
| 2001-12-14 14:00:00 | QQQ | ETF | 39.62 | 39.91 | 39.6 | 39.88 | 3771600.0 |
| 2001-12-14 14:30:00 | QQQ | ETF | 39.88 | 40.19 | 39.85 | 40.16 | 6084700.0 |
| 2001-12-14 15:00:00 | QQQ | ETF | 40.16 | 40.46 | 40.06 | 40.12 | 10721500.0 |
| 2001-12-14 15:30:00 | QQQ | ETF | 40.11 | 40.24 | 39.89 | 40.03 | 4747300.0 |
| 2001-12-14 16:00:00 | QQQ | ETF | 40.03 | 40.4 | 40.01 | 40.15 | 1977600.0 |
| 2001-12-14 16:30:00 | QQQ | ETF | 40.16 | 40.19 | 40.14 | 40.18 | 32100.0 |
| 2001-12-14 17:00:00 | QQQ | ETF | 40.2 | 40.25 | 40.17 | 40.19 | 7700.0 |
| 2001-12-14 17:30:00 | QQQ | ETF | 40.18 | 40.25 | 40.18 | 40.19 | 6000.0 |
| 2001-12-14 18:00:00 | QQQ | ETF | 40.21 | 40.25 | 40.15 | 40.24 | 9900.0 |
| 2001-12-14 09:30:00 | IWM | ETF | 46.65 | 46.8 | 46.505 | 46.69 | 66000.0 |
| 2001-12-14 10:00:00 | IWM | ETF | 46.595 | 46.595 | 46.445 | 46.445 | 10600.0 |
| 2001-12-14 10:30:00 | IWM | ETF | 46.405 | 46.49 | 46.385 | 46.475 | 14000.0 |
| 2001-12-14 11:00:00 | IWM | ETF | 46.49 | 46.54 | 46.425 | 46.475 | 52600.0 |
| 2001-12-14 11:30:00 | IWM | ETF | 46.45 | 46.535 | 46.4 | 46.535 | 33600.0 |
| 2001-12-14 12:00:00 | IWM | ETF | 46.535 | 46.54 | 46.435 | 46.5 | 344600.0 |
| 2001-12-14 12:30:00 | IWM | ETF | 46.445 | 46.48 | 46.375 | 46.41 | 61200.0 |
| 2001-12-14 13:00:00 | IWM | ETF | 46.48 | 46.49 | 46.365 | 46.4 | 33600.0 |
| 2001-12-14 13:30:00 | IWM | ETF | 46.45 | 46.495 | 46.425 | 46.485 | 9000.0 |
| 2001-12-14 14:00:00 | IWM | ETF | 46.47 | 46.545 | 46.435 | 46.54 | 51800.0 |
| 2001-12-14 14:30:00 | IWM | ETF | 46.45 | 46.675 | 46.45 | 46.645 | 69600.0 |
| 2001-12-14 15:00:00 | IWM | ETF | 46.65 | 46.875 | 46.65 | 46.785 | 70000.0 |
| 2001-12-14 15:30:00 | IWM | ETF | 46.785 | 46.825 | 46.66 | 46.775 | 329600.0 |
| 2001-12-14 16:00:00 | IWM | ETF | 46.95 | 46.95 | 46.95 | 46.95 | 1200.0 |
> showing 50 of 442 rows — these rows as CSV