PREVIEW / etf_30min / 2005-04-21
file: by_date/etf_30min/2005/2005-04-21.parquet size: 46 KB rows: 1,538
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-21 04:00:00 | SPY | ETF | 114.62 | 114.62 | 114.5 | 114.54 | 22700.0 |
| 2005-04-21 04:30:00 | SPY | ETF | 114.52 | 114.52 | 114.52 | 114.52 | 1000.0 |
| 2005-04-21 05:00:00 | SPY | ETF | 114.49 | 114.5 | 114.41 | 114.47 | 12100.0 |
| 2005-04-21 06:30:00 | SPY | ETF | 114.56 | 114.66 | 114.54 | 114.66 | 5000.0 |
| 2005-04-21 07:00:00 | SPY | ETF | 114.64 | 114.67 | 114.59 | 114.67 | 69600.0 |
| 2005-04-21 07:30:00 | SPY | ETF | 114.65 | 114.66 | 114.5 | 114.6 | 184100.0 |
| 2005-04-21 08:00:00 | SPY | ETF | 114.6 | 114.71 | 114.55 | 114.69 | 336600.0 |
| 2005-04-21 08:30:00 | SPY | ETF | 114.7 | 114.83 | 114.67 | 114.76 | 416200.0 |
| 2005-04-21 09:00:00 | SPY | ETF | 114.76 | 114.84 | 114.72 | 114.79 | 166600.0 |
| 2005-04-21 09:30:00 | SPY | ETF | 114.79 | 115.03 | 114.62 | 114.99 | 10552300.0 |
| 2005-04-21 10:00:00 | SPY | ETF | 114.98 | 115.02 | 114.52 | 114.6 | 8844000.0 |
| 2005-04-21 10:30:00 | SPY | ETF | 114.6 | 114.8 | 114.46 | 114.64 | 6869700.0 |
| 2005-04-21 11:00:00 | SPY | ETF | 114.64 | 114.64 | 114.38 | 114.49 | 5249100.0 |
| 2005-04-21 11:30:00 | SPY | ETF | 114.48 | 115.53 | 114.48 | 114.77 | 5942600.0 |
| 2005-04-21 12:00:00 | SPY | ETF | 114.76 | 115.3 | 114.76 | 115.17 | 9434800.0 |
| 2005-04-21 12:30:00 | SPY | ETF | 115.18 | 115.21 | 115.01 | 115.07 | 3544700.0 |
| 2005-04-21 13:00:00 | SPY | ETF | 115.07 | 115.32 | 114.96 | 115.18 | 2404500.0 |
| 2005-04-21 13:30:00 | SPY | ETF | 115.19 | 115.52 | 115.17 | 115.46 | 4699300.0 |
| 2005-04-21 14:00:00 | SPY | ETF | 115.45 | 115.9 | 115.39 | 115.8 | 8455100.0 |
| 2005-04-21 14:30:00 | SPY | ETF | 115.79 | 115.84 | 115.63 | 115.73 | 3606700.0 |
| 2005-04-21 15:00:00 | SPY | ETF | 115.72 | 115.84 | 115.65 | 115.84 | 2832800.0 |
| 2005-04-21 15:30:00 | SPY | ETF | 115.84 | 116.04 | 115.81 | 115.99 | 6019000.0 |
| 2005-04-21 16:00:00 | SPY | ETF | 116.02 | 116.21 | 115.95 | 116.02 | 4032100.0 |
| 2005-04-21 16:30:00 | SPY | ETF | 115.99 | 115.99 | 115.93 | 115.93 | 124200.0 |
| 2005-04-21 17:00:00 | SPY | ETF | 115.92 | 115.98 | 115.9 | 115.95 | 163500.0 |
| 2005-04-21 17:30:00 | SPY | ETF | 115.96 | 116.0 | 115.94 | 115.95 | 17000.0 |
| 2005-04-21 18:00:00 | SPY | ETF | 115.95 | 115.96 | 115.9 | 115.96 | 4900.0 |
| 2005-04-21 18:30:00 | SPY | ETF | 115.94 | 115.94 | 115.94 | 115.94 | 400.0 |
| 2005-04-21 19:00:00 | SPY | ETF | 115.93 | 115.93 | 115.82 | 115.82 | 5800.0 |
| 2005-04-21 19:30:00 | SPY | ETF | 115.84 | 115.84 | 115.84 | 115.84 | 1800.0 |
| 2005-04-21 09:30:00 | QQQ | ETF | 35.09 | 35.26 | 35.06 | 35.22 | 16799800.0 |
| 2005-04-21 10:00:00 | QQQ | ETF | 35.22 | 35.23 | 35.01 | 35.06 | 11715700.0 |
| 2005-04-21 10:30:00 | QQQ | ETF | 35.06 | 35.2 | 35.04 | 35.14 | 7466000.0 |
| 2005-04-21 11:00:00 | QQQ | ETF | 35.14 | 35.14 | 34.96 | 35.06 | 5389800.0 |
| 2005-04-21 11:30:00 | QQQ | ETF | 35.06 | 35.22 | 35.05 | 35.21 | 7197500.0 |
| 2005-04-21 12:00:00 | QQQ | ETF | 35.22 | 35.39 | 34.37 | 35.35 | 14026100.0 |
| 2005-04-21 12:30:00 | QQQ | ETF | 35.36 | 35.37 | 35.25 | 35.29 | 4496900.0 |
| 2005-04-21 13:00:00 | QQQ | ETF | 35.29 | 35.38 | 35.26 | 35.3 | 3398600.0 |
| 2005-04-21 13:30:00 | QQQ | ETF | 35.3 | 35.43 | 35.3 | 35.42 | 5678400.0 |
| 2005-04-21 14:00:00 | QQQ | ETF | 35.43 | 35.59 | 35.4 | 35.55 | 8467000.0 |
| 2005-04-21 14:30:00 | QQQ | ETF | 35.56 | 35.56 | 35.48 | 35.51 | 7604600.0 |
| 2005-04-21 15:00:00 | QQQ | ETF | 35.51 | 35.62 | 35.5 | 35.61 | 5454400.0 |
| 2005-04-21 15:30:00 | QQQ | ETF | 35.62 | 35.71 | 35.55 | 35.64 | 14903400.0 |
| 2005-04-21 07:00:00 | IWM | ETF | 58.69 | 58.71 | 58.68 | 58.68 | 2800.0 |
| 2005-04-21 07:30:00 | IWM | ETF | 58.725 | 58.74 | 58.725 | 58.74 | 2200.0 |
| 2005-04-21 08:00:00 | IWM | ETF | 58.74 | 58.74 | 58.74 | 58.74 | 6000.0 |
| 2005-04-21 08:30:00 | IWM | ETF | 58.79 | 58.955 | 58.7 | 58.81 | 34600.0 |
| 2005-04-21 09:00:00 | IWM | ETF | 58.82 | 58.85 | 58.78 | 58.815 | 21600.0 |
| 2005-04-21 09:30:00 | IWM | ETF | 58.84 | 59.06 | 58.025 | 59.06 | 3930000.0 |
| 2005-04-21 10:00:00 | IWM | ETF | 59.06 | 59.07 | 58.66 | 58.71 | 2550200.0 |
> showing 50 of 1,538 rows — these rows as CSV