PREVIEW / etf_30min / 2005-09-26
file: by_date/etf_30min/2005/2005-09-26.parquet size: 48 KB rows: 1,698
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-26 05:00:00 | SPY | ETF | 122.12 | 122.12 | 122.12 | 122.12 | 18400.0 |
| 2005-09-26 05:30:00 | SPY | ETF | 122.17 | 122.18 | 122.17 | 122.18 | 6700.0 |
| 2005-09-26 06:00:00 | SPY | ETF | 122.26 | 122.26 | 122.25 | 122.25 | 14800.0 |
| 2005-09-26 06:30:00 | SPY | ETF | 122.29 | 122.3 | 122.2 | 122.2 | 15000.0 |
| 2005-09-26 07:00:00 | SPY | ETF | 122.2 | 122.2 | 122.1 | 122.1 | 57300.0 |
| 2005-09-26 07:30:00 | SPY | ETF | 122.11 | 122.12 | 122.02 | 122.02 | 108000.0 |
| 2005-09-26 08:00:00 | SPY | ETF | 122.05 | 122.22 | 122.0 | 122.1 | 885700.0 |
| 2005-09-26 08:30:00 | SPY | ETF | 122.1 | 122.27 | 121.95 | 122.02 | 993600.0 |
| 2005-09-26 09:00:00 | SPY | ETF | 122.02 | 122.04 | 121.94 | 122.0 | 507400.0 |
| 2005-09-26 09:30:00 | SPY | ETF | 122.02 | 122.17 | 121.72 | 121.81 | 7140100.0 |
| 2005-09-26 10:00:00 | SPY | ETF | 121.79 | 122.24 | 121.71 | 122.08 | 6684900.0 |
| 2005-09-26 10:30:00 | SPY | ETF | 122.08 | 122.19 | 121.9 | 121.97 | 1938100.0 |
| 2005-09-26 11:00:00 | SPY | ETF | 121.98 | 122.12 | 121.92 | 122.04 | 3272400.0 |
| 2005-09-26 11:30:00 | SPY | ETF | 122.03 | 122.05 | 121.89 | 121.92 | 3736600.0 |
| 2005-09-26 12:00:00 | SPY | ETF | 121.92 | 122.15 | 121.89 | 122.01 | 4222800.0 |
| 2005-09-26 12:30:00 | SPY | ETF | 122.01 | 122.04 | 121.73 | 121.9 | 5449200.0 |
| 2005-09-26 13:00:00 | SPY | ETF | 121.91 | 121.94 | 121.51 | 121.6 | 4406800.0 |
| 2005-09-26 13:30:00 | SPY | ETF | 121.6 | 121.69 | 121.47 | 121.62 | 4343700.0 |
| 2005-09-26 14:00:00 | SPY | ETF | 121.61 | 121.64 | 121.23 | 121.34 | 4945800.0 |
| 2005-09-26 14:30:00 | SPY | ETF | 121.33 | 121.39 | 121.08 | 121.21 | 3247300.0 |
| 2005-09-26 15:00:00 | SPY | ETF | 121.22 | 121.37 | 121.15 | 121.25 | 2718900.0 |
| 2005-09-26 15:30:00 | SPY | ETF | 121.25 | 121.68 | 121.23 | 121.47 | 5176700.0 |
| 2005-09-26 16:00:00 | SPY | ETF | 121.47 | 121.9 | 121.4575 | 121.58 | 7228400.0 |
| 2005-09-26 16:30:00 | SPY | ETF | 121.56 | 121.57 | 121.54 | 121.56 | 79400.0 |
| 2005-09-26 17:00:00 | SPY | ETF | 121.48 | 121.6 | 121.47 | 121.53 | 830800.0 |
| 2005-09-26 17:30:00 | SPY | ETF | 121.55 | 121.55 | 121.55 | 121.55 | 500.0 |
| 2005-09-26 18:00:00 | SPY | ETF | 121.53 | 121.57 | 121.53 | 121.55 | 9900.0 |
| 2005-09-26 18:30:00 | SPY | ETF | 121.58 | 121.58 | 121.58 | 121.58 | 500.0 |
| 2005-09-26 09:30:00 | QQQ | ETF | 38.97 | 39.03 | 38.85 | 38.88 | 11185800.0 |
| 2005-09-26 10:00:00 | QQQ | ETF | 38.87 | 39.03 | 38.83 | 38.97 | 7093200.0 |
| 2005-09-26 10:30:00 | QQQ | ETF | 38.96 | 39.0 | 38.89 | 38.92 | 4834500.0 |
| 2005-09-26 11:00:00 | QQQ | ETF | 38.92 | 38.98 | 38.9 | 38.93 | 2923300.0 |
| 2005-09-26 11:30:00 | QQQ | ETF | 38.93 | 38.95 | 38.89 | 38.9 | 3155000.0 |
| 2005-09-26 12:00:00 | QQQ | ETF | 38.9 | 38.99 | 38.89 | 38.9 | 3072600.0 |
| 2005-09-26 12:30:00 | QQQ | ETF | 38.91 | 38.91 | 38.83 | 38.87 | 3087900.0 |
| 2005-09-26 13:00:00 | QQQ | ETF | 38.87 | 38.89 | 38.72 | 38.75 | 4616400.0 |
| 2005-09-26 13:30:00 | QQQ | ETF | 38.76 | 38.8 | 38.68 | 38.77 | 4241500.0 |
| 2005-09-26 14:00:00 | QQQ | ETF | 38.77 | 38.78 | 38.61 | 38.65 | 4153600.0 |
| 2005-09-26 14:30:00 | QQQ | ETF | 38.66 | 38.67 | 38.55 | 38.64 | 6814300.0 |
| 2005-09-26 15:00:00 | QQQ | ETF | 38.65 | 38.69 | 38.63 | 38.64 | 3010300.0 |
| 2005-09-26 15:30:00 | QQQ | ETF | 38.64 | 38.79 | 38.63 | 38.76 | 4039200.0 |
| 2005-09-26 08:00:00 | IWM | ETF | 65.68 | 65.78 | 65.62 | 65.65 | 35500.0 |
| 2005-09-26 08:30:00 | IWM | ETF | 65.68 | 65.71 | 65.64 | 65.67 | 25300.0 |
| 2005-09-26 09:00:00 | IWM | ETF | 65.58 | 65.67 | 65.58 | 65.63 | 173600.0 |
| 2005-09-26 09:30:00 | IWM | ETF | 65.62 | 65.76 | 65.24 | 65.27 | 4210200.0 |
| 2005-09-26 10:00:00 | IWM | ETF | 65.28 | 65.73 | 65.27 | 65.67 | 1855200.0 |
| 2005-09-26 10:30:00 | IWM | ETF | 65.67 | 65.8 | 65.61 | 65.69 | 1115100.0 |
| 2005-09-26 11:00:00 | IWM | ETF | 65.69 | 65.74 | 65.6 | 65.63 | 1155800.0 |
| 2005-09-26 11:30:00 | IWM | ETF | 65.62 | 65.73 | 65.61 | 65.62 | 598600.0 |
| 2005-09-26 12:00:00 | IWM | ETF | 65.62 | 65.85 | 65.61 | 65.79 | 1339100.0 |
> showing 50 of 1,698 rows — these rows as CSV