PREVIEW / etf_30min / 2001-05-31
file: by_date/etf_30min/2001/2001-05-31.parquet size: 14 KB rows: 358
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-05-31 09:30:00 | SPY | ETF | 125.43 | 126.0 | 125.43 | 126.0 | 1519100.0 |
| 2001-05-31 10:00:00 | SPY | ETF | 125.87 | 126.15 | 125.37 | 125.62 | 693500.0 |
| 2001-05-31 10:30:00 | SPY | ETF | 125.71 | 125.87 | 125.31 | 125.44 | 578000.0 |
| 2001-05-31 11:00:00 | SPY | ETF | 125.44 | 125.9 | 125.26 | 125.74 | 516100.0 |
| 2001-05-31 11:30:00 | SPY | ETF | 125.82 | 125.99 | 125.62 | 125.87 | 239600.0 |
| 2001-05-31 12:00:00 | SPY | ETF | 125.81 | 125.87 | 125.58 | 125.77 | 185200.0 |
| 2001-05-31 12:30:00 | SPY | ETF | 125.82 | 126.38 | 125.77 | 126.27 | 1683100.0 |
| 2001-05-31 13:00:00 | SPY | ETF | 126.22 | 126.5 | 126.12 | 126.37 | 307700.0 |
| 2001-05-31 13:30:00 | SPY | ETF | 126.35 | 126.76 | 126.32 | 126.39 | 305600.0 |
| 2001-05-31 14:00:00 | SPY | ETF | 126.36 | 126.67 | 126.15 | 126.46 | 315300.0 |
| 2001-05-31 14:30:00 | SPY | ETF | 126.42 | 126.73 | 126.35 | 126.5 | 553700.0 |
| 2001-05-31 15:00:00 | SPY | ETF | 126.55 | 126.59 | 126.26 | 126.27 | 928400.0 |
| 2001-05-31 15:30:00 | SPY | ETF | 126.25 | 126.36 | 126.0 | 126.1 | 1178600.0 |
| 2001-05-31 16:00:00 | SPY | ETF | 126.04 | 126.12 | 125.7 | 125.87 | 549900.0 |
| 2001-05-31 16:30:00 | SPY | ETF | 125.82 | 125.82 | 125.82 | 125.82 | 100.0 |
| 2001-05-31 17:00:00 | SPY | ETF | 125.79 | 126.04 | 125.79 | 126.04 | 3100.0 |
| 2001-05-31 17:30:00 | SPY | ETF | 125.95 | 125.96 | 125.95 | 125.96 | 1000.0 |
| 2001-05-31 09:30:00 | QQQ | ETF | 44.54 | 45.22 | 44.5 | 45.15 | 8320200.0 |
| 2001-05-31 10:00:00 | QQQ | ETF | 45.14 | 45.42 | 44.39 | 45.13 | 7077100.0 |
| 2001-05-31 10:30:00 | QQQ | ETF | 45.13 | 45.3 | 44.7 | 44.77 | 4834500.0 |
| 2001-05-31 11:00:00 | QQQ | ETF | 44.77 | 45.17 | 44.62 | 45.07 | 4303900.0 |
| 2001-05-31 11:30:00 | QQQ | ETF | 45.09 | 45.34 | 44.92 | 45.25 | 3126800.0 |
| 2001-05-31 12:00:00 | QQQ | ETF | 45.24 | 45.29 | 45.01 | 45.18 | 3566100.0 |
| 2001-05-31 12:30:00 | QQQ | ETF | 45.2 | 45.57 | 45.17 | 45.38 | 3996000.0 |
| 2001-05-31 13:00:00 | QQQ | ETF | 45.35 | 45.68 | 45.25 | 45.65 | 3727500.0 |
| 2001-05-31 13:30:00 | QQQ | ETF | 45.62 | 45.85 | 45.52 | 45.6 | 3606900.0 |
| 2001-05-31 14:00:00 | QQQ | ETF | 45.6 | 45.8 | 45.41 | 45.58 | 2886700.0 |
| 2001-05-31 14:30:00 | QQQ | ETF | 45.57 | 45.76 | 45.49 | 45.6 | 2208000.0 |
| 2001-05-31 15:00:00 | QQQ | ETF | 45.59 | 45.61 | 45.2 | 45.22 | 4160000.0 |
| 2001-05-31 15:30:00 | QQQ | ETF | 45.25 | 45.25 | 44.72 | 44.85 | 8526800.0 |
| 2001-05-31 16:00:00 | QQQ | ETF | 44.81 | 45.6 | 44.7 | 44.75 | 1584400.0 |
| 2001-05-31 16:30:00 | QQQ | ETF | 44.78 | 44.91 | 44.73 | 44.77 | 184400.0 |
| 2001-05-31 17:00:00 | QQQ | ETF | 44.83 | 44.97 | 44.75 | 44.82 | 70500.0 |
| 2001-05-31 17:30:00 | QQQ | ETF | 44.85 | 44.92 | 44.73 | 44.86 | 122900.0 |
| 2001-05-31 18:00:00 | QQQ | ETF | 44.87 | 45.0 | 44.75 | 44.75 | 46000.0 |
| 2001-05-31 18:30:00 | QQQ | ETF | 45.0 | 45.0 | 45.0 | 45.0 | 100.0 |
| 2001-05-31 09:30:00 | IWM | ETF | 49.575 | 49.865 | 49.575 | 49.865 | 61200.0 |
| 2001-05-31 10:00:00 | IWM | ETF | 49.745 | 49.89 | 49.745 | 49.795 | 29600.0 |
| 2001-05-31 10:30:00 | IWM | ETF | 49.75 | 49.87 | 49.665 | 49.71 | 35800.0 |
| 2001-05-31 11:00:00 | IWM | ETF | 49.725 | 49.785 | 49.665 | 49.72 | 46400.0 |
| 2001-05-31 11:30:00 | IWM | ETF | 49.775 | 49.875 | 49.775 | 49.855 | 63800.0 |
| 2001-05-31 12:00:00 | IWM | ETF | 49.85 | 49.85 | 49.75 | 49.8 | 13800.0 |
| 2001-05-31 12:30:00 | IWM | ETF | 49.8 | 49.89 | 49.78 | 49.85 | 66800.0 |
| 2001-05-31 13:00:00 | IWM | ETF | 49.845 | 50.0 | 49.8 | 49.95 | 59600.0 |
| 2001-05-31 13:30:00 | IWM | ETF | 49.95 | 50.045 | 49.9 | 49.955 | 88400.0 |
| 2001-05-31 14:00:00 | IWM | ETF | 49.955 | 50.09 | 49.95 | 49.95 | 63000.0 |
| 2001-05-31 14:30:00 | IWM | ETF | 49.925 | 50.025 | 49.925 | 50.025 | 23600.0 |
| 2001-05-31 15:00:00 | IWM | ETF | 50.0 | 50.1 | 49.85 | 49.93 | 138000.0 |
| 2001-05-31 15:30:00 | IWM | ETF | 49.91 | 49.99 | 49.6 | 49.65 | 129600.0 |
| 2001-05-31 16:00:00 | IWM | ETF | 49.4 | 49.55 | 49.4 | 49.55 | 133600.0 |
> showing 50 of 358 rows — these rows as CSV