PREVIEW / etf_30min / 2001-12-06
file: by_date/etf_30min/2001/2001-12-06.parquet size: 18 KB rows: 476
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-06 09:30:00 | SPY | ETF | 117.34 | 117.45 | 117.09 | 117.4 | 2266000.0 |
| 2001-12-06 10:00:00 | SPY | ETF | 117.44 | 117.5 | 116.93 | 117.41 | 2017800.0 |
| 2001-12-06 10:30:00 | SPY | ETF | 117.45 | 117.61 | 117.22 | 117.33 | 1371100.0 |
| 2001-12-06 11:00:00 | SPY | ETF | 117.3 | 117.59 | 117.2 | 117.38 | 752400.0 |
| 2001-12-06 11:30:00 | SPY | ETF | 117.33 | 117.48 | 117.18 | 117.46 | 488800.0 |
| 2001-12-06 12:00:00 | SPY | ETF | 117.46 | 117.83 | 117.36 | 117.66 | 1452700.0 |
| 2001-12-06 12:30:00 | SPY | ETF | 117.62 | 117.9 | 117.56 | 117.89 | 734300.0 |
| 2001-12-06 13:00:00 | SPY | ETF | 117.9 | 117.94 | 117.42 | 117.55 | 804900.0 |
| 2001-12-06 13:30:00 | SPY | ETF | 117.58 | 117.64 | 117.39 | 117.53 | 1267400.0 |
| 2001-12-06 14:00:00 | SPY | ETF | 117.53 | 117.56 | 117.02 | 117.27 | 2014700.0 |
| 2001-12-06 14:30:00 | SPY | ETF | 117.24 | 117.6 | 117.01 | 117.33 | 939600.0 |
| 2001-12-06 15:00:00 | SPY | ETF | 117.31 | 117.57 | 117.15 | 117.17 | 1227000.0 |
| 2001-12-06 15:30:00 | SPY | ETF | 117.2 | 117.35 | 117.05 | 117.3 | 1045900.0 |
| 2001-12-06 16:00:00 | SPY | ETF | 117.25 | 117.82 | 117.0 | 117.75 | 1355600.0 |
| 2001-12-06 16:30:00 | SPY | ETF | 117.55 | 117.75 | 117.38 | 117.5 | 15900.0 |
| 2001-12-06 17:00:00 | SPY | ETF | 117.56 | 117.72 | 117.4 | 117.4 | 8600.0 |
| 2001-12-06 17:30:00 | SPY | ETF | 117.59 | 117.59 | 117.42 | 117.42 | 2400.0 |
| 2001-12-06 18:00:00 | SPY | ETF | 117.43 | 117.43 | 117.35 | 117.36 | 4300.0 |
| 2001-12-06 09:30:00 | QQQ | ETF | 42.7 | 42.84 | 42.45 | 42.81 | 12168500.0 |
| 2001-12-06 10:00:00 | QQQ | ETF | 42.79 | 42.98 | 42.51 | 42.88 | 8827700.0 |
| 2001-12-06 10:30:00 | QQQ | ETF | 42.85 | 43.08 | 42.65 | 42.73 | 5988200.0 |
| 2001-12-06 11:00:00 | QQQ | ETF | 42.73 | 42.92 | 42.6 | 42.7 | 3170200.0 |
| 2001-12-06 11:30:00 | QQQ | ETF | 42.7 | 42.77 | 42.53 | 42.75 | 2823900.0 |
| 2001-12-06 12:00:00 | QQQ | ETF | 42.75 | 43.08 | 42.66 | 42.96 | 6689500.0 |
| 2001-12-06 12:30:00 | QQQ | ETF | 42.96 | 43.24 | 42.87 | 43.2 | 3072300.0 |
| 2001-12-06 13:00:00 | QQQ | ETF | 43.2 | 43.24 | 42.83 | 42.9 | 3754700.0 |
| 2001-12-06 13:30:00 | QQQ | ETF | 42.93 | 42.95 | 42.7 | 42.82 | 5320700.0 |
| 2001-12-06 14:00:00 | QQQ | ETF | 42.81 | 42.83 | 42.46 | 42.59 | 5910200.0 |
| 2001-12-06 14:30:00 | QQQ | ETF | 42.62 | 42.78 | 42.36 | 42.66 | 4890600.0 |
| 2001-12-06 15:00:00 | QQQ | ETF | 42.66 | 42.89 | 42.56 | 42.59 | 4921400.0 |
| 2001-12-06 15:30:00 | QQQ | ETF | 42.59 | 42.81 | 42.52 | 42.77 | 5121300.0 |
| 2001-12-06 16:00:00 | QQQ | ETF | 42.79 | 43.5 | 42.73 | 43.22 | 3451300.0 |
| 2001-12-06 16:30:00 | QQQ | ETF | 43.21 | 43.25 | 42.93 | 43.11 | 357800.0 |
| 2001-12-06 17:00:00 | QQQ | ETF | 43.1 | 43.1 | 42.98 | 43.0 | 414900.0 |
| 2001-12-06 17:30:00 | QQQ | ETF | 43.03 | 43.09 | 42.9 | 43.03 | 40500.0 |
| 2001-12-06 18:00:00 | QQQ | ETF | 43.03 | 43.09 | 43.01 | 43.04 | 25300.0 |
| 2001-12-06 09:30:00 | IWM | ETF | 47.8 | 47.945 | 47.675 | 47.85 | 89400.0 |
| 2001-12-06 10:00:00 | IWM | ETF | 47.925 | 48.0 | 47.8 | 47.9 | 112000.0 |
| 2001-12-06 10:30:00 | IWM | ETF | 47.89 | 48.17 | 47.89 | 48.02 | 15800.0 |
| 2001-12-06 11:00:00 | IWM | ETF | 48.0 | 48.015 | 47.85 | 47.985 | 18400.0 |
| 2001-12-06 11:30:00 | IWM | ETF | 47.965 | 48.01 | 47.9 | 48.005 | 22000.0 |
| 2001-12-06 12:00:00 | IWM | ETF | 48.0 | 48.2 | 47.995 | 48.195 | 34200.0 |
| 2001-12-06 12:30:00 | IWM | ETF | 48.15 | 48.195 | 48.05 | 48.195 | 20800.0 |
| 2001-12-06 13:00:00 | IWM | ETF | 48.21 | 48.215 | 48.1 | 48.1 | 8000.0 |
| 2001-12-06 13:30:00 | IWM | ETF | 48.1 | 48.12 | 47.945 | 48.07 | 24200.0 |
| 2001-12-06 14:00:00 | IWM | ETF | 48.07 | 48.07 | 47.79 | 47.93 | 13400.0 |
| 2001-12-06 14:30:00 | IWM | ETF | 47.8 | 47.95 | 47.75 | 47.78 | 117600.0 |
| 2001-12-06 15:00:00 | IWM | ETF | 47.935 | 48.06 | 47.935 | 48.015 | 73200.0 |
| 2001-12-06 15:30:00 | IWM | ETF | 47.975 | 48.125 | 47.805 | 48.125 | 159800.0 |
| 2001-12-06 16:00:00 | IWM | ETF | 48.2 | 48.315 | 48.19 | 48.315 | 27000.0 |
> showing 50 of 476 rows — these rows as CSV