PREVIEW / etf_30min / 2005-12-15
file: by_date/etf_30min/2005/2005-12-15.parquet size: 55 KB rows: 2,044
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-12-15 07:00:00 | SPY | ETF | 127.65 | 127.65 | 127.64 | 127.64 | 26100.0 |
| 2005-12-15 07:30:00 | SPY | ETF | 127.64 | 127.65 | 127.63 | 127.65 | 29900.0 |
| 2005-12-15 08:00:00 | SPY | ETF | 127.66 | 127.84 | 127.63 | 127.72 | 384100.0 |
| 2005-12-15 08:30:00 | SPY | ETF | 127.75 | 128.0 | 127.75 | 127.77 | 685700.0 |
| 2005-12-15 09:00:00 | SPY | ETF | 127.8 | 127.9 | 127.8 | 127.83 | 321000.0 |
| 2005-12-15 09:30:00 | SPY | ETF | 127.84 | 128.0 | 127.71 | 127.71 | 5570700.0 |
| 2005-12-15 10:00:00 | SPY | ETF | 127.72 | 127.99 | 127.18 | 127.44 | 14470300.0 |
| 2005-12-15 10:30:00 | SPY | ETF | 127.43 | 127.5 | 127.34 | 127.41 | 3383600.0 |
| 2005-12-15 11:00:00 | SPY | ETF | 127.41 | 127.62 | 127.28 | 127.5 | 2840600.0 |
| 2005-12-15 11:30:00 | SPY | ETF | 127.5 | 127.6 | 127.405 | 127.57 | 1616100.0 |
| 2005-12-15 12:00:00 | SPY | ETF | 127.57 | 127.67 | 127.47 | 127.61 | 2643600.0 |
| 2005-12-15 12:30:00 | SPY | ETF | 127.6 | 127.7 | 127.54 | 127.64 | 1440100.0 |
| 2005-12-15 13:00:00 | SPY | ETF | 127.64 | 127.64 | 127.44 | 127.509 | 1948200.0 |
| 2005-12-15 13:30:00 | SPY | ETF | 127.5 | 127.73 | 127.5 | 127.7 | 2088800.0 |
| 2005-12-15 14:00:00 | SPY | ETF | 127.7 | 127.77 | 127.51 | 127.53 | 2175000.0 |
| 2005-12-15 14:30:00 | SPY | ETF | 127.52 | 127.57 | 127.28 | 127.36 | 5360600.0 |
| 2005-12-15 15:00:00 | SPY | ETF | 127.36 | 127.53 | 127.31 | 127.45 | 3152000.0 |
| 2005-12-15 15:30:00 | SPY | ETF | 127.44 | 127.57 | 127.42 | 127.53 | 4534300.0 |
| 2005-12-15 16:00:00 | SPY | ETF | 127.53 | 127.53 | 127.35 | 127.41 | 650700.0 |
| 2005-12-15 16:30:00 | SPY | ETF | 127.39 | 127.43 | 127.36 | 127.4 | 130900.0 |
| 2005-12-15 17:00:00 | SPY | ETF | 127.4 | 127.53 | 127.4 | 127.53 | 199800.0 |
| 2005-12-15 17:30:00 | SPY | ETF | 127.54 | 127.6 | 127.44 | 127.58 | 342700.0 |
| 2005-12-15 18:00:00 | SPY | ETF | 127.5 | 127.59 | 127.49 | 127.55 | 449700.0 |
| 2005-12-15 18:30:00 | SPY | ETF | 127.58 | 127.58 | 127.58 | 127.58 | 900.0 |
| 2005-12-15 19:00:00 | SPY | ETF | 127.55 | 127.55 | 127.53 | 127.53 | 5000.0 |
| 2005-12-15 19:30:00 | SPY | ETF | 127.54 | 127.54 | 127.53 | 127.53 | 900.0 |
| 2005-12-15 09:30:00 | QQQ | ETF | 42.02 | 42.07 | 41.98 | 41.99 | 7755800.0 |
| 2005-12-15 10:00:00 | QQQ | ETF | 41.98 | 42.03 | 41.61 | 41.75 | 15239100.0 |
| 2005-12-15 10:30:00 | QQQ | ETF | 41.75 | 41.78 | 41.69 | 41.74 | 5411100.0 |
| 2005-12-15 11:00:00 | QQQ | ETF | 41.74 | 41.89 | 41.69 | 41.86 | 5796300.0 |
| 2005-12-15 11:30:00 | QQQ | ETF | 41.85 | 41.95 | 41.83 | 41.93 | 4170500.0 |
| 2005-12-15 12:00:00 | QQQ | ETF | 41.94 | 41.97 | 41.85 | 41.87 | 4251400.0 |
| 2005-12-15 12:30:00 | QQQ | ETF | 41.86 | 41.93 | 41.84 | 41.92 | 2104400.0 |
| 2005-12-15 13:00:00 | QQQ | ETF | 41.92 | 41.92 | 41.82 | 41.82 | 2714100.0 |
| 2005-12-15 13:30:00 | QQQ | ETF | 41.83 | 41.94 | 41.82 | 41.92 | 1892200.0 |
| 2005-12-15 14:00:00 | QQQ | ETF | 41.92 | 41.96 | 41.88 | 41.88 | 1961300.0 |
| 2005-12-15 14:30:00 | QQQ | ETF | 41.88 | 41.92 | 41.8 | 41.83 | 3467100.0 |
| 2005-12-15 15:00:00 | QQQ | ETF | 41.82 | 41.89 | 41.8 | 41.86 | 3282900.0 |
| 2005-12-15 15:30:00 | QQQ | ETF | 41.86 | 41.97 | 41.85 | 41.97 | 4330300.0 |
| 2005-12-15 07:30:00 | IWM | ETF | 68.7 | 68.72 | 68.7 | 68.72 | 7000.0 |
| 2005-12-15 08:00:00 | IWM | ETF | 68.71 | 68.71 | 68.7 | 68.7 | 7000.0 |
| 2005-12-15 08:30:00 | IWM | ETF | 68.81 | 68.86 | 68.74 | 68.74 | 522500.0 |
| 2005-12-15 09:00:00 | IWM | ETF | 68.76 | 68.84 | 68.76 | 68.84 | 548000.0 |
| 2005-12-15 09:30:00 | IWM | ETF | 68.82 | 68.82 | 68.24 | 68.29 | 3217100.0 |
| 2005-12-15 10:00:00 | IWM | ETF | 68.28 | 68.42 | 67.73 | 68.09 | 6180500.0 |
| 2005-12-15 10:30:00 | IWM | ETF | 68.08 | 68.15 | 67.99 | 68.1 | 2441800.0 |
| 2005-12-15 11:00:00 | IWM | ETF | 68.09 | 68.25 | 67.94 | 68.11 | 2825700.0 |
| 2005-12-15 11:30:00 | IWM | ETF | 68.11 | 68.26 | 68.08 | 68.23 | 1041100.0 |
| 2005-12-15 12:00:00 | IWM | ETF | 68.23 | 68.31 | 68.13 | 68.18 | 1803100.0 |
| 2005-12-15 12:30:00 | IWM | ETF | 68.18 | 68.25 | 68.11 | 68.14 | 739700.0 |
> showing 50 of 2,044 rows — these rows as CSV