PREVIEW / etf_30min / 2001-02-23
file: by_date/etf_30min/2001/2001-02-23.parquet size: 14 KB rows: 346
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-02-23 09:30:00 | SPY | ETF | 125.08 | 125.24 | 124.16 | 124.21 | 1786400.0 |
| 2001-02-23 10:00:00 | SPY | ETF | 124.4 | 124.78 | 123.7 | 124.06 | 1900600.0 |
| 2001-02-23 10:30:00 | SPY | ETF | 124.1 | 124.1 | 123.35 | 123.59 | 1072500.0 |
| 2001-02-23 11:00:00 | SPY | ETF | 123.88 | 124.29 | 123.56 | 123.78 | 1168000.0 |
| 2001-02-23 11:30:00 | SPY | ETF | 123.79 | 124.04 | 123.2 | 123.54 | 912900.0 |
| 2001-02-23 12:00:00 | SPY | ETF | 123.51 | 123.66 | 122.55 | 122.6 | 747000.0 |
| 2001-02-23 12:30:00 | SPY | ETF | 122.6 | 123.3 | 122.53 | 122.96 | 674700.0 |
| 2001-02-23 13:00:00 | SPY | ETF | 122.99 | 123.01 | 122.3 | 122.51 | 497600.0 |
| 2001-02-23 13:30:00 | SPY | ETF | 122.64 | 122.73 | 121.8 | 122.02 | 1349500.0 |
| 2001-02-23 14:00:00 | SPY | ETF | 122.0 | 122.62 | 121.81 | 122.29 | 801400.0 |
| 2001-02-23 14:30:00 | SPY | ETF | 122.39 | 123.7 | 122.3 | 123.23 | 1021800.0 |
| 2001-02-23 15:00:00 | SPY | ETF | 123.2 | 124.37 | 123.0 | 123.64 | 1245600.0 |
| 2001-02-23 15:30:00 | SPY | ETF | 123.7 | 125.54 | 123.7 | 124.89 | 1780400.0 |
| 2001-02-23 16:00:00 | SPY | ETF | 124.98 | 125.1 | 122.46 | 124.97 | 2710500.0 |
| 2001-02-23 16:30:00 | SPY | ETF | 124.8 | 125.0 | 122.97 | 125.0 | 207700.0 |
| 2001-02-23 17:00:00 | SPY | ETF | 124.8 | 125.0 | 124.12 | 124.12 | 1763700.0 |
| 2001-02-23 09:30:00 | QQQ | ETF | 50.09 | 50.62 | 49.48 | 49.79 | 10163300.0 |
| 2001-02-23 10:00:00 | QQQ | ETF | 49.66 | 50.18 | 49.2 | 49.37 | 5948300.0 |
| 2001-02-23 10:30:00 | QQQ | ETF | 49.5 | 49.57 | 48.7 | 49.15 | 8072400.0 |
| 2001-02-23 11:00:00 | QQQ | ETF | 49.11 | 49.8 | 48.9 | 49.25 | 5254000.0 |
| 2001-02-23 11:30:00 | QQQ | ETF | 49.26 | 49.53 | 48.85 | 49.25 | 2644300.0 |
| 2001-02-23 12:00:00 | QQQ | ETF | 49.25 | 49.35 | 48.4 | 48.45 | 4409000.0 |
| 2001-02-23 12:30:00 | QQQ | ETF | 48.45 | 49.16 | 48.4 | 48.85 | 7613900.0 |
| 2001-02-23 13:00:00 | QQQ | ETF | 48.85 | 48.99 | 48.5 | 48.69 | 3022200.0 |
| 2001-02-23 13:30:00 | QQQ | ETF | 48.7 | 48.91 | 48.25 | 48.52 | 3781300.0 |
| 2001-02-23 14:00:00 | QQQ | ETF | 48.52 | 49.3 | 48.36 | 48.89 | 5609800.0 |
| 2001-02-23 14:30:00 | QQQ | ETF | 48.75 | 50.08 | 48.7 | 49.55 | 11447200.0 |
| 2001-02-23 15:00:00 | QQQ | ETF | 49.6 | 50.45 | 49.42 | 50.0 | 8087800.0 |
| 2001-02-23 15:30:00 | QQQ | ETF | 49.85 | 51.6 | 49.79 | 51.26 | 10906500.0 |
| 2001-02-23 16:00:00 | QQQ | ETF | 51.3 | 51.5 | 49.85 | 51.25 | 2085700.0 |
| 2001-02-23 16:30:00 | QQQ | ETF | 51.3 | 51.55 | 51.18 | 51.45 | 107800.0 |
| 2001-02-23 17:00:00 | QQQ | ETF | 51.45 | 51.6 | 51.3 | 51.5 | 65100.0 |
| 2001-02-23 17:30:00 | QQQ | ETF | 51.5 | 51.68 | 51.5 | 51.5 | 17000.0 |
| 2001-02-23 18:00:00 | QQQ | ETF | 51.55 | 51.9 | 51.5 | 51.61 | 25600.0 |
| 2001-02-23 18:30:00 | QQQ | ETF | 51.65 | 51.65 | 51.65 | 51.65 | 500.0 |
| 2001-02-23 09:30:00 | IWM | ETF | 47.4 | 47.4 | 47.1 | 47.29 | 20000.0 |
| 2001-02-23 10:00:00 | IWM | ETF | 47.1 | 47.29 | 46.95 | 46.95 | 11200.0 |
| 2001-02-23 10:30:00 | IWM | ETF | 46.9 | 46.9 | 46.525 | 46.705 | 41200.0 |
| 2001-02-23 11:00:00 | IWM | ETF | 46.705 | 46.705 | 46.705 | 46.705 | 1200.0 |
| 2001-02-23 11:30:00 | IWM | ETF | 46.75 | 46.8 | 46.65 | 46.775 | 15000.0 |
| 2001-02-23 12:00:00 | IWM | ETF | 46.7 | 46.7 | 46.31 | 46.31 | 5200.0 |
| 2001-02-23 12:30:00 | IWM | ETF | 46.25 | 46.545 | 46.25 | 46.545 | 7800.0 |
| 2001-02-23 13:00:00 | IWM | ETF | 46.545 | 46.545 | 46.39 | 46.39 | 3000.0 |
| 2001-02-23 13:30:00 | IWM | ETF | 46.45 | 46.45 | 46.225 | 46.225 | 10600.0 |
| 2001-02-23 14:00:00 | IWM | ETF | 46.425 | 46.425 | 46.3 | 46.3 | 17600.0 |
| 2001-02-23 14:30:00 | IWM | ETF | 46.49 | 46.8 | 46.31 | 46.795 | 9400.0 |
| 2001-02-23 15:00:00 | IWM | ETF | 46.8 | 47.2 | 46.8 | 47.025 | 65800.0 |
| 2001-02-23 15:30:00 | IWM | ETF | 47.0 | 47.75 | 47.0 | 47.725 | 147000.0 |
| 2001-02-23 16:00:00 | IWM | ETF | 47.625 | 47.625 | 47.6 | 47.6 | 10800.0 |
| 2001-02-23 09:30:00 | DIA | ETF | 105.1 | 105.2 | 104.45 | 104.45 | 210600.0 |
> showing 50 of 346 rows — these rows as CSV