PREVIEW / etf_30min / 2005-04-15
file: by_date/etf_30min/2005/2005-04-15.parquet size: 48 KB rows: 1,582
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 |
|---|---|---|---|---|---|---|---|
| 2005-04-15 04:00:00 | SPY | ETF | 115.58 | 115.58 | 115.53 | 115.53 | 2000.0 |
| 2005-04-15 04:30:00 | SPY | ETF | 115.51 | 115.51 | 115.51 | 115.51 | 1000.0 |
| 2005-04-15 06:30:00 | SPY | ETF | 115.63 | 115.63 | 115.53 | 115.53 | 30000.0 |
| 2005-04-15 07:00:00 | SPY | ETF | 115.53 | 115.53 | 115.48 | 115.5 | 14200.0 |
| 2005-04-15 07:30:00 | SPY | ETF | 115.5 | 115.57 | 115.41 | 115.54 | 209300.0 |
| 2005-04-15 08:00:00 | SPY | ETF | 115.53 | 115.81 | 115.53 | 115.77 | 429900.0 |
| 2005-04-15 08:30:00 | SPY | ETF | 115.75 | 115.95 | 115.58 | 115.86 | 466400.0 |
| 2005-04-15 09:00:00 | SPY | ETF | 115.86 | 115.88 | 115.73 | 115.74 | 327700.0 |
| 2005-04-15 09:30:00 | SPY | ETF | 115.74 | 116.14 | 115.5 | 116.0 | 17588500.0 |
| 2005-04-15 10:00:00 | SPY | ETF | 115.99 | 116.11 | 115.65 | 116.0 | 8766800.0 |
| 2005-04-15 10:30:00 | SPY | ETF | 116.0 | 116.2 | 115.81 | 116.12 | 7118500.0 |
| 2005-04-15 11:00:00 | SPY | ETF | 116.12 | 116.13 | 115.72 | 115.72 | 5375300.0 |
| 2005-04-15 11:30:00 | SPY | ETF | 115.73 | 115.78 | 115.4 | 115.6 | 8091900.0 |
| 2005-04-15 12:00:00 | SPY | ETF | 115.6 | 115.78 | 115.34 | 115.45 | 9487000.0 |
| 2005-04-15 12:30:00 | SPY | ETF | 115.45 | 115.6 | 114.93 | 114.97 | 8774000.0 |
| 2005-04-15 13:00:00 | SPY | ETF | 114.96 | 115.54 | 114.92 | 115.43 | 11086100.0 |
| 2005-04-15 13:30:00 | SPY | ETF | 115.43 | 115.58 | 115.19 | 115.24 | 5984600.0 |
| 2005-04-15 14:00:00 | SPY | ETF | 115.24 | 115.62 | 115.21 | 115.33 | 5842600.0 |
| 2005-04-15 14:30:00 | SPY | ETF | 115.37 | 115.37 | 114.9 | 115.18 | 6983400.0 |
| 2005-04-15 15:00:00 | SPY | ETF | 115.18 | 115.91 | 114.68 | 114.76 | 9074800.0 |
| 2005-04-15 15:30:00 | SPY | ETF | 114.77 | 114.96 | 114.16 | 114.27 | 17141100.0 |
| 2005-04-15 16:00:00 | SPY | ETF | 114.25 | 114.48 | 114.05 | 114.05 | 2185800.0 |
| 2005-04-15 16:30:00 | SPY | ETF | 114.04 | 114.15 | 113.97 | 114.0 | 1834800.0 |
| 2005-04-15 17:00:00 | SPY | ETF | 114.04 | 114.08 | 113.96 | 114.05 | 126300.0 |
| 2005-04-15 17:30:00 | SPY | ETF | 114.02 | 114.28 | 114.01 | 114.15 | 557900.0 |
| 2005-04-15 18:00:00 | SPY | ETF | 114.15 | 114.15 | 114.01 | 114.12 | 7200.0 |
| 2005-04-15 18:30:00 | SPY | ETF | 114.14 | 114.2 | 114.13 | 114.19 | 56700.0 |
| 2005-04-15 19:00:00 | SPY | ETF | 114.18 | 114.2 | 114.17 | 114.17 | 6300.0 |
| 2005-04-15 19:30:00 | SPY | ETF | 114.19 | 114.19 | 114.15 | 114.19 | 1200.0 |
| 2005-04-15 09:30:00 | QQQ | ETF | 35.24 | 36.15 | 35.12 | 35.28 | 27786300.0 |
| 2005-04-15 10:00:00 | QQQ | ETF | 35.28 | 35.34 | 35.14 | 35.26 | 12435200.0 |
| 2005-04-15 10:30:00 | QQQ | ETF | 35.26 | 35.35 | 35.18 | 35.27 | 8374300.0 |
| 2005-04-15 11:00:00 | QQQ | ETF | 35.27 | 35.28 | 35.14 | 35.15 | 6813200.0 |
| 2005-04-15 11:30:00 | QQQ | ETF | 35.15 | 35.18 | 35.04 | 35.1 | 8155500.0 |
| 2005-04-15 12:00:00 | QQQ | ETF | 35.11 | 35.17 | 34.99 | 35.03 | 11832900.0 |
| 2005-04-15 12:30:00 | QQQ | ETF | 35.03 | 35.08 | 34.87 | 34.89 | 7828600.0 |
| 2005-04-15 13:00:00 | QQQ | ETF | 34.89 | 35.05 | 34.88 | 35.02 | 9170100.0 |
| 2005-04-15 13:30:00 | QQQ | ETF | 35.01 | 35.15 | 34.98 | 35.0 | 7510700.0 |
| 2005-04-15 14:00:00 | QQQ | ETF | 35.01 | 35.15 | 34.99 | 35.05 | 6217200.0 |
| 2005-04-15 14:30:00 | QQQ | ETF | 35.05 | 35.08 | 34.91 | 34.98 | 9538800.0 |
| 2005-04-15 15:00:00 | QQQ | ETF | 34.98 | 35.01 | 34.85 | 34.88 | 13090900.0 |
| 2005-04-15 15:30:00 | QQQ | ETF | 34.88 | 34.95 | 34.68 | 34.75 | 24726000.0 |
| 2005-04-15 08:00:00 | IWM | ETF | 58.46 | 58.605 | 58.46 | 58.55 | 4000.0 |
| 2005-04-15 08:30:00 | IWM | ETF | 58.54 | 58.65 | 58.5 | 58.65 | 4800.0 |
| 2005-04-15 09:00:00 | IWM | ETF | 58.675 | 58.72 | 58.675 | 58.695 | 18600.0 |
| 2005-04-15 09:30:00 | IWM | ETF | 58.655 | 58.975 | 58.385 | 58.785 | 5122400.0 |
| 2005-04-15 10:00:00 | IWM | ETF | 58.79 | 58.885 | 58.53 | 58.725 | 3675800.0 |
| 2005-04-15 10:30:00 | IWM | ETF | 58.725 | 58.855 | 58.675 | 58.785 | 2543000.0 |
| 2005-04-15 11:00:00 | IWM | ETF | 58.78 | 58.815 | 58.56 | 58.56 | 2395400.0 |
| 2005-04-15 11:30:00 | IWM | ETF | 58.57 | 58.6 | 58.2 | 58.29 | 4474800.0 |
> showing 50 of 1,582 rows — these rows as CSV