PREVIEW / etf_30min / 2001-08-30
file: by_date/etf_30min/2001/2001-08-30.parquet size: 16 KB rows: 394
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-08-30 09:30:00 | SPY | ETF | 114.85 | 115.74 | 114.85 | 115.54 | 1789700.0 |
| 2001-08-30 10:00:00 | SPY | ETF | 115.52 | 115.57 | 114.79 | 115.02 | 1359200.0 |
| 2001-08-30 10:30:00 | SPY | ETF | 115.01 | 115.08 | 114.33 | 114.34 | 1111200.0 |
| 2001-08-30 11:00:00 | SPY | ETF | 114.32 | 114.44 | 113.7 | 113.96 | 1797100.0 |
| 2001-08-30 11:30:00 | SPY | ETF | 113.96 | 114.0 | 113.07 | 113.55 | 1469500.0 |
| 2001-08-30 12:00:00 | SPY | ETF | 113.61 | 113.91 | 113.53 | 113.67 | 858700.0 |
| 2001-08-30 12:30:00 | SPY | ETF | 113.7 | 113.75 | 113.46 | 113.61 | 634500.0 |
| 2001-08-30 13:00:00 | SPY | ETF | 113.61 | 113.74 | 113.28 | 113.47 | 408200.0 |
| 2001-08-30 13:30:00 | SPY | ETF | 113.48 | 113.8 | 113.29 | 113.33 | 393200.0 |
| 2001-08-30 14:00:00 | SPY | ETF | 113.34 | 113.37 | 113.0 | 113.18 | 688600.0 |
| 2001-08-30 14:30:00 | SPY | ETF | 113.12 | 113.58 | 112.93 | 113.52 | 1012100.0 |
| 2001-08-30 15:00:00 | SPY | ETF | 113.51 | 113.56 | 113.12 | 113.24 | 730400.0 |
| 2001-08-30 15:30:00 | SPY | ETF | 113.24 | 113.72 | 113.22 | 113.28 | 1307500.0 |
| 2001-08-30 16:00:00 | SPY | ETF | 113.28 | 113.44 | 113.16 | 113.28 | 1725400.0 |
| 2001-08-30 16:30:00 | SPY | ETF | 113.28 | 113.33 | 113.2 | 113.32 | 9100.0 |
| 2001-08-30 17:00:00 | SPY | ETF | 113.4 | 113.4 | 113.32 | 113.32 | 202000.0 |
| 2001-08-30 17:30:00 | SPY | ETF | 113.25 | 113.25 | 113.25 | 113.25 | 500.0 |
| 2001-08-30 18:00:00 | SPY | ETF | 113.25 | 113.25 | 113.25 | 113.25 | 200.0 |
| 2001-08-30 09:30:00 | QQQ | ETF | 36.8 | 37.31 | 36.64 | 37.15 | 8437400.0 |
| 2001-08-30 10:00:00 | QQQ | ETF | 37.13 | 37.21 | 36.69 | 36.88 | 5351700.0 |
| 2001-08-30 10:30:00 | QQQ | ETF | 36.88 | 36.91 | 36.44 | 36.45 | 6664200.0 |
| 2001-08-30 11:00:00 | QQQ | ETF | 36.45 | 36.5 | 36.08 | 36.26 | 8199400.0 |
| 2001-08-30 11:30:00 | QQQ | ETF | 36.29 | 36.3 | 35.87 | 36.21 | 8725800.0 |
| 2001-08-30 12:00:00 | QQQ | ETF | 36.22 | 36.44 | 36.19 | 36.26 | 2882800.0 |
| 2001-08-30 12:30:00 | QQQ | ETF | 36.26 | 36.38 | 36.15 | 36.24 | 1709400.0 |
| 2001-08-30 13:00:00 | QQQ | ETF | 36.24 | 36.35 | 36.06 | 36.16 | 2447200.0 |
| 2001-08-30 13:30:00 | QQQ | ETF | 36.16 | 36.33 | 36.02 | 36.02 | 2375200.0 |
| 2001-08-30 14:00:00 | QQQ | ETF | 36.03 | 36.13 | 35.89 | 35.97 | 4536900.0 |
| 2001-08-30 14:30:00 | QQQ | ETF | 35.97 | 36.32 | 35.83 | 36.26 | 6905900.0 |
| 2001-08-30 15:00:00 | QQQ | ETF | 36.26 | 36.3 | 36.05 | 36.15 | 5189100.0 |
| 2001-08-30 15:30:00 | QQQ | ETF | 36.16 | 36.42 | 36.12 | 36.2 | 6738700.0 |
| 2001-08-30 16:00:00 | QQQ | ETF | 36.2 | 36.58 | 36.11 | 36.11 | 1504700.0 |
| 2001-08-30 16:30:00 | QQQ | ETF | 36.18 | 36.22 | 36.1 | 36.22 | 135800.0 |
| 2001-08-30 17:00:00 | QQQ | ETF | 36.2 | 36.3 | 36.2 | 36.26 | 177500.0 |
| 2001-08-30 17:30:00 | QQQ | ETF | 36.26 | 36.35 | 36.2 | 36.27 | 19700.0 |
| 2001-08-30 18:00:00 | QQQ | ETF | 36.27 | 36.32 | 36.19 | 36.2 | 21600.0 |
| 2001-08-30 09:30:00 | IWM | ETF | 46.9 | 47.025 | 46.9 | 47.025 | 21800.0 |
| 2001-08-30 10:00:00 | IWM | ETF | 47.1 | 47.1 | 46.925 | 47.015 | 107000.0 |
| 2001-08-30 10:30:00 | IWM | ETF | 47.095 | 47.095 | 46.805 | 46.805 | 45600.0 |
| 2001-08-30 11:00:00 | IWM | ETF | 46.705 | 46.75 | 46.555 | 46.61 | 21400.0 |
| 2001-08-30 11:30:00 | IWM | ETF | 46.555 | 46.645 | 46.41 | 46.53 | 426800.0 |
| 2001-08-30 12:00:00 | IWM | ETF | 46.53 | 46.725 | 46.53 | 46.555 | 6600.0 |
| 2001-08-30 12:30:00 | IWM | ETF | 46.725 | 46.725 | 46.555 | 46.615 | 51200.0 |
| 2001-08-30 13:00:00 | IWM | ETF | 46.575 | 46.715 | 46.55 | 46.665 | 32800.0 |
| 2001-08-30 13:30:00 | IWM | ETF | 46.665 | 46.665 | 46.53 | 46.53 | 44200.0 |
| 2001-08-30 14:00:00 | IWM | ETF | 46.53 | 46.595 | 46.45 | 46.5 | 32400.0 |
| 2001-08-30 14:30:00 | IWM | ETF | 46.495 | 46.625 | 46.305 | 46.625 | 46000.0 |
| 2001-08-30 15:00:00 | IWM | ETF | 46.645 | 46.645 | 46.435 | 46.525 | 26600.0 |
| 2001-08-30 15:30:00 | IWM | ETF | 46.435 | 46.65 | 46.38 | 46.555 | 56400.0 |
| 2001-08-30 09:30:00 | DIA | ETF | 100.54 | 101.42 | 100.54 | 101.22 | 543900.0 |
> showing 50 of 394 rows — these rows as CSV