PREVIEW / etf_30min / 2006-02-28
file: by_date/etf_30min/2006/2006-02-28.parquet size: 60 KB rows: 2,198
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 |
|---|---|---|---|---|---|---|---|
| 2006-02-28 06:00:00 | SPY | ETF | 129.5 | 129.51 | 129.5 | 129.51 | 25000.0 |
| 2006-02-28 06:30:00 | SPY | ETF | 129.43 | 129.43 | 129.43 | 129.43 | 600.0 |
| 2006-02-28 07:00:00 | SPY | ETF | 129.44 | 129.44 | 129.42 | 129.42 | 7400.0 |
| 2006-02-28 07:30:00 | SPY | ETF | 129.42 | 129.53 | 129.42 | 129.53 | 6500.0 |
| 2006-02-28 08:00:00 | SPY | ETF | 129.5 | 129.51 | 129.39 | 129.44 | 33200.0 |
| 2006-02-28 08:30:00 | SPY | ETF | 129.41 | 129.48 | 129.29 | 129.3 | 620800.0 |
| 2006-02-28 09:00:00 | SPY | ETF | 129.33 | 129.33 | 129.2 | 129.2 | 163800.0 |
| 2006-02-28 09:30:00 | SPY | ETF | 129.2 | 129.31 | 129.11 | 129.24 | 5614600.0 |
| 2006-02-28 10:00:00 | SPY | ETF | 129.25 | 129.91 | 128.88 | 128.91 | 6754000.0 |
| 2006-02-28 10:30:00 | SPY | ETF | 128.91 | 129.04 | 128.35 | 128.37 | 10084100.0 |
| 2006-02-28 11:00:00 | SPY | ETF | 128.37 | 129.46 | 128.28 | 128.53 | 6335600.0 |
| 2006-02-28 11:30:00 | SPY | ETF | 128.52 | 128.6 | 128.43 | 128.43 | 2969700.0 |
| 2006-02-28 12:00:00 | SPY | ETF | 128.43 | 129.26 | 128.23 | 128.25 | 3990800.0 |
| 2006-02-28 12:30:00 | SPY | ETF | 128.25 | 128.5 | 128.17 | 128.38 | 5557700.0 |
| 2006-02-28 13:00:00 | SPY | ETF | 128.39 | 128.58 | 128.36 | 128.53 | 2179500.0 |
| 2006-02-28 13:30:00 | SPY | ETF | 128.53 | 128.73 | 128.35 | 128.39 | 4542000.0 |
| 2006-02-28 14:00:00 | SPY | ETF | 128.39 | 128.46 | 128.29 | 128.41 | 3361400.0 |
| 2006-02-28 14:30:00 | SPY | ETF | 128.43 | 128.46 | 128.24 | 128.31 | 3986800.0 |
| 2006-02-28 15:00:00 | SPY | ETF | 128.32 | 128.4 | 128.13 | 128.38 | 5122800.0 |
| 2006-02-28 15:30:00 | SPY | ETF | 128.38 | 129.6842 | 128.23 | 128.265 | 6997800.0 |
| 2006-02-28 16:00:00 | SPY | ETF | 128.24 | 128.55 | 128.23 | 128.25 | 1575500.0 |
| 2006-02-28 16:30:00 | SPY | ETF | 128.29 | 128.4892 | 128.25 | 128.3 | 69000.0 |
| 2006-02-28 17:00:00 | SPY | ETF | 128.28 | 128.31 | 128.27 | 128.28 | 10600.0 |
| 2006-02-28 17:30:00 | SPY | ETF | 128.28 | 128.28 | 128.28 | 128.28 | 100.0 |
| 2006-02-28 18:00:00 | SPY | ETF | 128.28 | 128.28 | 128.28 | 128.28 | 100.0 |
| 2006-02-28 18:30:00 | SPY | ETF | 128.3 | 128.31 | 128.3 | 128.31 | 2100.0 |
| 2006-02-28 19:00:00 | SPY | ETF | 128.32 | 128.35 | 128.32 | 128.35 | 5500.0 |
| 2006-02-28 09:30:00 | QQQ | ETF | 41.59 | 41.72 | 41.38 | 41.67 | 8516500.0 |
| 2006-02-28 10:00:00 | QQQ | ETF | 41.68 | 41.7 | 41.55 | 41.56 | 8317700.0 |
| 2006-02-28 10:30:00 | QQQ | ETF | 41.57 | 41.57 | 41.07 | 41.07 | 27668600.0 |
| 2006-02-28 11:00:00 | QQQ | ETF | 41.07 | 41.2 | 41.03 | 41.18 | 11531300.0 |
| 2006-02-28 11:30:00 | QQQ | ETF | 41.17 | 41.22 | 41.11 | 41.18 | 6259800.0 |
| 2006-02-28 12:00:00 | QQQ | ETF | 41.18 | 41.22 | 41.13 | 41.13 | 3639500.0 |
| 2006-02-28 12:30:00 | QQQ | ETF | 41.14 | 41.26 | 41.09 | 41.2 | 4604100.0 |
| 2006-02-28 13:00:00 | QQQ | ETF | 41.2 | 41.29 | 41.19 | 41.27 | 3624600.0 |
| 2006-02-28 13:30:00 | QQQ | ETF | 41.27 | 41.33 | 41.16 | 41.19 | 4793700.0 |
| 2006-02-28 14:00:00 | QQQ | ETF | 41.18 | 41.23 | 41.08 | 41.15 | 3936200.0 |
| 2006-02-28 14:30:00 | QQQ | ETF | 41.15 | 41.18 | 41.05 | 41.11 | 4199700.0 |
| 2006-02-28 15:00:00 | QQQ | ETF | 41.11 | 41.16 | 40.97 | 41.06 | 6564600.0 |
| 2006-02-28 15:30:00 | QQQ | ETF | 41.06 | 41.24 | 41.02 | 41.1 | 14613300.0 |
| 2006-02-28 08:00:00 | IWM | ETF | 73.53 | 73.54 | 73.53 | 73.53 | 3700.0 |
| 2006-02-28 08:30:00 | IWM | ETF | 73.51 | 73.51 | 73.44 | 73.45 | 45900.0 |
| 2006-02-28 09:00:00 | IWM | ETF | 73.46 | 73.46 | 73.39 | 73.39 | 105800.0 |
| 2006-02-28 09:30:00 | IWM | ETF | 73.38 | 73.47 | 73.14 | 73.19 | 4399000.0 |
| 2006-02-28 10:00:00 | IWM | ETF | 73.19 | 73.2 | 72.86 | 72.93 | 2846200.0 |
| 2006-02-28 10:30:00 | IWM | ETF | 72.93 | 72.95 | 72.7 | 72.71 | 2743500.0 |
| 2006-02-28 11:00:00 | IWM | ETF | 72.71 | 72.8 | 72.61 | 72.7 | 1859000.0 |
| 2006-02-28 11:30:00 | IWM | ETF | 72.7 | 72.75 | 72.68 | 72.7 | 869600.0 |
| 2006-02-28 12:00:00 | IWM | ETF | 72.7 | 72.74 | 72.6 | 72.6 | 828800.0 |
| 2006-02-28 12:30:00 | IWM | ETF | 72.61 | 72.69 | 72.45 | 72.64 | 1581300.0 |
> showing 50 of 2,198 rows — these rows as CSV