PREVIEW / etf_30min / 2001-12-18
file: by_date/etf_30min/2001/2001-12-18.parquet size: 18 KB rows: 483
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-18 09:30:00 | SPY | ETF | 114.63 | 115.15 | 114.61 | 114.93 | 2781800.0 |
| 2001-12-18 10:00:00 | SPY | ETF | 114.98 | 115.12 | 114.72 | 115.0 | 1515100.0 |
| 2001-12-18 10:30:00 | SPY | ETF | 115.01 | 115.06 | 114.8 | 114.8 | 482200.0 |
| 2001-12-18 11:00:00 | SPY | ETF | 114.8 | 114.88 | 114.56 | 114.58 | 438400.0 |
| 2001-12-18 11:30:00 | SPY | ETF | 114.6 | 114.7 | 114.43 | 114.7 | 800900.0 |
| 2001-12-18 12:00:00 | SPY | ETF | 114.7 | 114.81 | 114.61 | 114.7 | 394900.0 |
| 2001-12-18 12:30:00 | SPY | ETF | 114.72 | 114.89 | 114.67 | 114.85 | 452600.0 |
| 2001-12-18 13:00:00 | SPY | ETF | 114.85 | 114.94 | 114.67 | 114.72 | 1285600.0 |
| 2001-12-18 13:30:00 | SPY | ETF | 114.76 | 114.78 | 114.51 | 114.73 | 376100.0 |
| 2001-12-18 14:00:00 | SPY | ETF | 114.72 | 114.78 | 114.42 | 114.56 | 479200.0 |
| 2001-12-18 14:30:00 | SPY | ETF | 114.57 | 114.71 | 114.34 | 114.62 | 619700.0 |
| 2001-12-18 15:00:00 | SPY | ETF | 114.65 | 114.91 | 114.56 | 114.85 | 736800.0 |
| 2001-12-18 15:30:00 | SPY | ETF | 114.86 | 115.08 | 114.82 | 114.9 | 1172900.0 |
| 2001-12-18 16:00:00 | SPY | ETF | 114.93 | 115.09 | 114.8 | 114.98 | 776200.0 |
| 2001-12-18 16:30:00 | SPY | ETF | 114.9 | 115.1 | 114.81 | 114.82 | 11900.0 |
| 2001-12-18 17:00:00 | SPY | ETF | 114.7 | 114.7 | 114.55 | 114.55 | 3100.0 |
| 2001-12-18 17:30:00 | SPY | ETF | 114.55 | 114.68 | 114.55 | 114.68 | 700.0 |
| 2001-12-18 18:00:00 | SPY | ETF | 114.4 | 114.4 | 114.4 | 114.4 | 100.0 |
| 2001-12-18 09:30:00 | QQQ | ETF | 41.16 | 41.5 | 41.1 | 41.26 | 10371400.0 |
| 2001-12-18 10:00:00 | QQQ | ETF | 41.24 | 41.34 | 41.05 | 41.29 | 7017300.0 |
| 2001-12-18 10:30:00 | QQQ | ETF | 41.28 | 41.33 | 41.1 | 41.1 | 3079700.0 |
| 2001-12-18 11:00:00 | QQQ | ETF | 41.13 | 41.2 | 40.92 | 40.97 | 3447500.0 |
| 2001-12-18 11:30:00 | QQQ | ETF | 40.96 | 41.13 | 40.88 | 41.1 | 2667000.0 |
| 2001-12-18 12:00:00 | QQQ | ETF | 41.1 | 41.17 | 41.0 | 41.13 | 1543700.0 |
| 2001-12-18 12:30:00 | QQQ | ETF | 41.11 | 41.25 | 41.11 | 41.23 | 1657300.0 |
| 2001-12-18 13:00:00 | QQQ | ETF | 41.22 | 41.26 | 41.08 | 41.13 | 1626300.0 |
| 2001-12-18 13:30:00 | QQQ | ETF | 41.13 | 41.19 | 40.95 | 41.12 | 2916500.0 |
| 2001-12-18 14:00:00 | QQQ | ETF | 41.12 | 41.14 | 40.96 | 41.01 | 1867200.0 |
| 2001-12-18 14:30:00 | QQQ | ETF | 41.0 | 41.2 | 40.9 | 41.12 | 2513600.0 |
| 2001-12-18 15:00:00 | QQQ | ETF | 41.11 | 41.33 | 41.08 | 41.31 | 3686600.0 |
| 2001-12-18 15:30:00 | QQQ | ETF | 41.31 | 41.43 | 41.25 | 41.3 | 5036900.0 |
| 2001-12-18 16:00:00 | QQQ | ETF | 41.29 | 41.37 | 41.19 | 41.25 | 1674800.0 |
| 2001-12-18 16:30:00 | QQQ | ETF | 41.35 | 41.35 | 41.1 | 41.1 | 295300.0 |
| 2001-12-18 17:00:00 | QQQ | ETF | 41.14 | 41.15 | 40.88 | 40.88 | 228200.0 |
| 2001-12-18 17:30:00 | QQQ | ETF | 40.91 | 40.97 | 40.87 | 40.87 | 288200.0 |
| 2001-12-18 18:00:00 | QQQ | ETF | 40.88 | 40.93 | 40.86 | 40.91 | 15500.0 |
| 2001-12-18 09:30:00 | IWM | ETF | 48.25 | 48.325 | 48.135 | 48.32 | 319000.0 |
| 2001-12-18 10:00:00 | IWM | ETF | 48.325 | 48.325 | 48.0 | 48.175 | 96200.0 |
| 2001-12-18 10:30:00 | IWM | ETF | 48.175 | 48.225 | 48.03 | 48.085 | 54400.0 |
| 2001-12-18 11:00:00 | IWM | ETF | 48.125 | 48.125 | 48.0 | 48.0 | 57000.0 |
| 2001-12-18 11:30:00 | IWM | ETF | 48.0 | 48.01 | 47.875 | 48.0 | 59000.0 |
| 2001-12-18 12:00:00 | IWM | ETF | 47.98 | 48.025 | 47.85 | 48.02 | 6200.0 |
| 2001-12-18 12:30:00 | IWM | ETF | 47.99 | 48.07 | 47.88 | 48.07 | 46800.0 |
| 2001-12-18 13:00:00 | IWM | ETF | 48.04 | 48.04 | 47.91 | 47.995 | 19600.0 |
| 2001-12-18 13:30:00 | IWM | ETF | 47.95 | 47.975 | 47.895 | 47.975 | 25800.0 |
| 2001-12-18 14:00:00 | IWM | ETF | 47.975 | 48.05 | 47.85 | 47.865 | 84000.0 |
| 2001-12-18 14:30:00 | IWM | ETF | 47.815 | 48.025 | 47.815 | 47.88 | 82000.0 |
| 2001-12-18 15:00:00 | IWM | ETF | 47.98 | 48.125 | 47.945 | 48.125 | 10800.0 |
| 2001-12-18 15:30:00 | IWM | ETF | 48.17 | 48.275 | 48.025 | 48.075 | 231200.0 |
| 2001-12-18 16:00:00 | IWM | ETF | 48.265 | 48.275 | 48.265 | 48.275 | 2600.0 |
> showing 50 of 483 rows — these rows as CSV