PREVIEW / etf_30min / 2005-09-29
file: by_date/etf_30min/2005/2005-09-29.parquet size: 51 KB rows: 1,738
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-09-29 07:00:00 | SPY | ETF | 121.76 | 121.76 | 121.76 | 121.76 | 400.0 |
| 2005-09-29 07:30:00 | SPY | ETF | 121.8 | 121.8 | 121.8 | 121.8 | 1000.0 |
| 2005-09-29 08:00:00 | SPY | ETF | 121.74 | 121.81 | 121.58 | 121.61 | 82800.0 |
| 2005-09-29 08:30:00 | SPY | ETF | 121.63 | 121.72 | 121.61 | 121.71 | 531000.0 |
| 2005-09-29 09:00:00 | SPY | ETF | 121.69 | 121.69 | 121.58 | 121.58 | 87200.0 |
| 2005-09-29 09:30:00 | SPY | ETF | 121.55 | 121.62 | 121.17 | 121.26 | 6293600.0 |
| 2005-09-29 10:00:00 | SPY | ETF | 121.26 | 121.68 | 121.2 | 121.62 | 5340000.0 |
| 2005-09-29 10:30:00 | SPY | ETF | 121.62 | 121.66 | 121.24 | 121.28 | 4559600.0 |
| 2005-09-29 11:00:00 | SPY | ETF | 121.28 | 121.43 | 121.08 | 121.29 | 6073100.0 |
| 2005-09-29 11:30:00 | SPY | ETF | 121.29 | 122.07 | 121.26 | 121.91 | 6799500.0 |
| 2005-09-29 12:00:00 | SPY | ETF | 121.91 | 121.97 | 121.72 | 121.78 | 2913900.0 |
| 2005-09-29 12:30:00 | SPY | ETF | 121.81 | 121.87 | 121.67 | 121.87 | 1637800.0 |
| 2005-09-29 13:00:00 | SPY | ETF | 121.86 | 122.32 | 121.85 | 122.24 | 6266300.0 |
| 2005-09-29 13:30:00 | SPY | ETF | 122.25 | 122.4 | 122.19 | 122.27 | 2811700.0 |
| 2005-09-29 14:00:00 | SPY | ETF | 122.27 | 122.66 | 122.25 | 122.58 | 4106000.0 |
| 2005-09-29 14:30:00 | SPY | ETF | 122.58 | 122.75 | 122.45 | 122.57 | 4416400.0 |
| 2005-09-29 15:00:00 | SPY | ETF | 122.57 | 122.86 | 122.47 | 122.84 | 3523200.0 |
| 2005-09-29 15:30:00 | SPY | ETF | 122.84 | 122.85 | 122.64 | 122.81 | 5487200.0 |
| 2005-09-29 16:00:00 | SPY | ETF | 122.79 | 122.8 | 121.6 | 122.6 | 1404500.0 |
| 2005-09-29 16:30:00 | SPY | ETF | 122.59 | 122.65 | 122.59 | 122.64 | 48100.0 |
| 2005-09-29 17:00:00 | SPY | ETF | 122.64 | 122.69 | 122.64 | 122.66 | 8200.0 |
| 2005-09-29 17:30:00 | SPY | ETF | 122.68 | 122.68 | 122.66 | 122.66 | 700.0 |
| 2005-09-29 18:00:00 | SPY | ETF | 122.67 | 122.69 | 122.67 | 122.68 | 13000.0 |
| 2005-09-29 18:30:00 | SPY | ETF | 122.67 | 122.67 | 122.67 | 122.67 | 200.0 |
| 2005-09-29 19:30:00 | SPY | ETF | 122.67 | 122.67 | 122.67 | 122.67 | 1000.0 |
| 2005-09-29 09:30:00 | QQQ | ETF | 38.63 | 38.65 | 38.45 | 38.47 | 12494200.0 |
| 2005-09-29 10:00:00 | QQQ | ETF | 38.47 | 38.71 | 38.44 | 38.68 | 10129000.0 |
| 2005-09-29 10:30:00 | QQQ | ETF | 38.68 | 38.77 | 38.58 | 38.59 | 9245000.0 |
| 2005-09-29 11:00:00 | QQQ | ETF | 38.59 | 38.68 | 38.54 | 38.63 | 5229500.0 |
| 2005-09-29 11:30:00 | QQQ | ETF | 38.63 | 38.9 | 38.63 | 38.86 | 9320900.0 |
| 2005-09-29 12:00:00 | QQQ | ETF | 38.85 | 38.91 | 38.73 | 38.84 | 6068800.0 |
| 2005-09-29 12:30:00 | QQQ | ETF | 38.83 | 38.85 | 38.79 | 38.85 | 2605500.0 |
| 2005-09-29 13:00:00 | QQQ | ETF | 38.85 | 39.08 | 38.85 | 39.05 | 11557400.0 |
| 2005-09-29 13:30:00 | QQQ | ETF | 39.06 | 39.12 | 38.98 | 39.02 | 7099000.0 |
| 2005-09-29 14:00:00 | QQQ | ETF | 39.03 | 39.13 | 39.02 | 39.07 | 8105700.0 |
| 2005-09-29 14:30:00 | QQQ | ETF | 39.08 | 39.11 | 38.97 | 39.05 | 9912600.0 |
| 2005-09-29 15:00:00 | QQQ | ETF | 39.06 | 39.21 | 39.02 | 39.19 | 11116000.0 |
| 2005-09-29 15:30:00 | QQQ | ETF | 39.19 | 39.2 | 39.1 | 39.19 | 10435300.0 |
| 2005-09-29 08:00:00 | IWM | ETF | 65.25 | 65.25 | 65.25 | 65.25 | 100.0 |
| 2005-09-29 08:30:00 | IWM | ETF | 65.31 | 65.31 | 65.28 | 65.28 | 72800.0 |
| 2005-09-29 09:00:00 | IWM | ETF | 65.24 | 65.29 | 65.24 | 65.24 | 35600.0 |
| 2005-09-29 09:30:00 | IWM | ETF | 65.245 | 65.3 | 64.83 | 64.84 | 2078100.0 |
| 2005-09-29 10:00:00 | IWM | ETF | 64.84 | 65.11 | 64.81 | 65.09 | 1422100.0 |
| 2005-09-29 10:30:00 | IWM | ETF | 65.1 | 65.19 | 64.95 | 64.96 | 1578900.0 |
| 2005-09-29 11:00:00 | IWM | ETF | 64.96 | 65.11 | 64.84 | 65.07 | 1459400.0 |
| 2005-09-29 11:30:00 | IWM | ETF | 65.09 | 65.45 | 65.04 | 65.35 | 1585600.0 |
| 2005-09-29 12:00:00 | IWM | ETF | 65.35 | 65.43 | 65.27 | 65.32 | 594300.0 |
| 2005-09-29 12:30:00 | IWM | ETF | 65.32 | 65.42 | 65.26 | 65.41 | 403900.0 |
| 2005-09-29 13:00:00 | IWM | ETF | 65.41 | 65.75 | 65.4 | 65.72 | 1030700.0 |
| 2005-09-29 13:30:00 | IWM | ETF | 65.72 | 65.9 | 65.72 | 65.8 | 1508300.0 |
> showing 50 of 1,738 rows — these rows as CSV