PREVIEW / etf_30min / 2005-04-13
file: by_date/etf_30min/2005/2005-04-13.parquet size: 44 KB rows: 1,474
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-13 06:30:00 | SPY | ETF | 118.59 | 118.59 | 118.59 | 118.59 | 500.0 |
| 2005-04-13 07:30:00 | SPY | ETF | 118.7 | 118.72 | 118.7 | 118.72 | 16400.0 |
| 2005-04-13 08:00:00 | SPY | ETF | 118.7 | 118.72 | 118.68 | 118.69 | 28500.0 |
| 2005-04-13 08:30:00 | SPY | ETF | 118.67 | 118.68 | 118.56 | 118.59 | 129000.0 |
| 2005-04-13 09:00:00 | SPY | ETF | 118.58 | 118.65 | 118.56 | 118.56 | 26000.0 |
| 2005-04-13 09:30:00 | SPY | ETF | 118.56 | 118.8 | 118.42 | 118.48 | 5556100.0 |
| 2005-04-13 10:00:00 | SPY | ETF | 118.47 | 118.55 | 118.34 | 118.43 | 4796500.0 |
| 2005-04-13 10:30:00 | SPY | ETF | 118.43 | 118.75 | 118.28 | 118.39 | 8074900.0 |
| 2005-04-13 11:00:00 | SPY | ETF | 118.38 | 118.38 | 118.15 | 118.28 | 3867900.0 |
| 2005-04-13 11:30:00 | SPY | ETF | 118.28 | 118.65 | 118.26 | 118.34 | 3057700.0 |
| 2005-04-13 12:00:00 | SPY | ETF | 118.35 | 118.36 | 118.15 | 118.24 | 1932600.0 |
| 2005-04-13 12:30:00 | SPY | ETF | 118.24 | 118.45 | 118.15 | 118.43 | 2012800.0 |
| 2005-04-13 13:00:00 | SPY | ETF | 118.43 | 118.47 | 117.99 | 118.05 | 4613300.0 |
| 2005-04-13 13:30:00 | SPY | ETF | 118.04 | 118.2 | 117.6 | 117.68 | 7086700.0 |
| 2005-04-13 14:00:00 | SPY | ETF | 117.68 | 117.79 | 117.55 | 117.7 | 5019900.0 |
| 2005-04-13 14:30:00 | SPY | ETF | 117.71 | 117.79 | 117.45 | 117.53 | 4853100.0 |
| 2005-04-13 15:00:00 | SPY | ETF | 117.53 | 117.54 | 117.21 | 117.27 | 5132300.0 |
| 2005-04-13 15:30:00 | SPY | ETF | 117.26 | 117.46 | 117.13 | 117.41 | 6565100.0 |
| 2005-04-13 16:00:00 | SPY | ETF | 117.41 | 117.41 | 117.28 | 117.32 | 816000.0 |
| 2005-04-13 16:30:00 | SPY | ETF | 117.33 | 117.44 | 117.2 | 117.3 | 890300.0 |
| 2005-04-13 17:00:00 | SPY | ETF | 117.31 | 117.33 | 117.3 | 117.32 | 15600.0 |
| 2005-04-13 17:30:00 | SPY | ETF | 117.33 | 117.35 | 117.3 | 117.3 | 4700.0 |
| 2005-04-13 18:00:00 | SPY | ETF | 117.3 | 117.39 | 117.29 | 117.36 | 27500.0 |
| 2005-04-13 18:30:00 | SPY | ETF | 117.39 | 117.4 | 117.39 | 117.4 | 3100.0 |
| 2005-04-13 19:30:00 | SPY | ETF | 117.33 | 117.33 | 117.33 | 117.33 | 2000.0 |
| 2005-04-13 09:30:00 | QQQ | ETF | 36.56 | 36.59 | 36.47 | 36.5 | 9084500.0 |
| 2005-04-13 10:00:00 | QQQ | ETF | 36.5 | 36.52 | 36.4 | 36.47 | 8184300.0 |
| 2005-04-13 10:30:00 | QQQ | ETF | 36.48 | 36.6 | 36.34 | 36.39 | 11298600.0 |
| 2005-04-13 11:00:00 | QQQ | ETF | 36.4 | 36.46 | 36.32 | 36.37 | 6262000.0 |
| 2005-04-13 11:30:00 | QQQ | ETF | 36.38 | 36.46 | 36.38 | 36.4 | 3903900.0 |
| 2005-04-13 12:00:00 | QQQ | ETF | 36.4 | 36.4 | 36.3 | 36.34 | 4591200.0 |
| 2005-04-13 12:30:00 | QQQ | ETF | 36.34 | 36.42 | 36.3 | 36.41 | 4044300.0 |
| 2005-04-13 13:00:00 | QQQ | ETF | 36.41 | 36.43 | 36.27 | 36.27 | 5745500.0 |
| 2005-04-13 13:30:00 | QQQ | ETF | 36.27 | 36.29 | 36.15 | 36.19 | 9014100.0 |
| 2005-04-13 14:00:00 | QQQ | ETF | 36.19 | 36.23 | 36.11 | 36.15 | 6854400.0 |
| 2005-04-13 14:30:00 | QQQ | ETF | 36.16 | 36.19 | 36.07 | 36.1 | 6161600.0 |
| 2005-04-13 15:00:00 | QQQ | ETF | 36.1 | 36.11 | 35.99 | 36.01 | 10787900.0 |
| 2005-04-13 15:30:00 | QQQ | ETF | 36.02 | 36.1 | 35.98 | 36.05 | 14533000.0 |
| 2005-04-13 08:00:00 | IWM | ETF | 60.95 | 60.99 | 60.95 | 60.975 | 31000.0 |
| 2005-04-13 08:30:00 | IWM | ETF | 60.96 | 60.96 | 60.87 | 60.875 | 2800.0 |
| 2005-04-13 09:00:00 | IWM | ETF | 60.835 | 60.85 | 60.8 | 60.8 | 5600.0 |
| 2005-04-13 09:30:00 | IWM | ETF | 60.8 | 60.9 | 60.665 | 60.8 | 3085400.0 |
| 2005-04-13 10:00:00 | IWM | ETF | 60.8 | 60.855 | 60.57 | 60.635 | 2517400.0 |
| 2005-04-13 10:30:00 | IWM | ETF | 60.64 | 60.88 | 60.475 | 60.57 | 2026800.0 |
| 2005-04-13 11:00:00 | IWM | ETF | 60.55 | 60.565 | 60.34 | 60.465 | 1766800.0 |
| 2005-04-13 11:30:00 | IWM | ETF | 60.475 | 60.66 | 60.47 | 60.495 | 513600.0 |
| 2005-04-13 12:00:00 | IWM | ETF | 60.5 | 60.52 | 60.395 | 60.405 | 778600.0 |
| 2005-04-13 12:30:00 | IWM | ETF | 60.4 | 60.5 | 60.365 | 60.48 | 911000.0 |
| 2005-04-13 13:00:00 | IWM | ETF | 60.48 | 60.52 | 60.16 | 60.205 | 2012200.0 |
| 2005-04-13 13:30:00 | IWM | ETF | 60.205 | 60.215 | 60.015 | 60.09 | 2456000.0 |
> showing 50 of 1,474 rows — these rows as CSV