PREVIEW / etf_30min / 2004-04-16
file: by_date/etf_30min/2004/2004-04-16.parquet size: 35 KB rows: 1,165
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 |
|---|---|---|---|---|---|---|---|
| 2004-04-16 08:00:00 | SPY | ETF | 113.01 | 113.11 | 113.0 | 113.11 | 14800.0 |
| 2004-04-16 08:30:00 | SPY | ETF | 113.15 | 113.37 | 113.01 | 113.37 | 35000.0 |
| 2004-04-16 09:00:00 | SPY | ETF | 113.37 | 113.43 | 113.13 | 113.39 | 99800.0 |
| 2004-04-16 09:30:00 | SPY | ETF | 113.43 | 113.46 | 112.98 | 113.07 | 5012400.0 |
| 2004-04-16 10:00:00 | SPY | ETF | 113.08 | 113.39 | 113.02 | 113.31 | 3003500.0 |
| 2004-04-16 10:30:00 | SPY | ETF | 113.33 | 113.6 | 113.32 | 113.45 | 3125500.0 |
| 2004-04-16 11:00:00 | SPY | ETF | 113.43 | 113.78 | 113.4 | 113.61 | 2572100.0 |
| 2004-04-16 11:30:00 | SPY | ETF | 113.61 | 113.75 | 113.55 | 113.72 | 1659400.0 |
| 2004-04-16 12:00:00 | SPY | ETF | 113.71 | 113.94 | 113.64 | 113.81 | 3030800.0 |
| 2004-04-16 12:30:00 | SPY | ETF | 113.8 | 114.05 | 113.77 | 113.91 | 3020400.0 |
| 2004-04-16 13:00:00 | SPY | ETF | 113.91 | 113.97 | 113.69 | 113.73 | 1209800.0 |
| 2004-04-16 13:30:00 | SPY | ETF | 113.73 | 113.83 | 113.62 | 113.74 | 1020300.0 |
| 2004-04-16 14:00:00 | SPY | ETF | 113.73 | 113.96 | 113.73 | 113.91 | 902200.0 |
| 2004-04-16 14:30:00 | SPY | ETF | 113.94 | 113.95 | 113.64 | 113.74 | 1388400.0 |
| 2004-04-16 15:00:00 | SPY | ETF | 113.73 | 113.88 | 113.5 | 113.62 | 1525800.0 |
| 2004-04-16 15:30:00 | SPY | ETF | 113.62 | 113.92 | 113.62 | 113.73 | 2142400.0 |
| 2004-04-16 16:00:00 | SPY | ETF | 113.71 | 113.95 | 113.71 | 113.8 | 1545400.0 |
| 2004-04-16 16:30:00 | SPY | ETF | 113.13 | 113.83 | 113.13 | 113.81 | 1234800.0 |
| 2004-04-16 17:00:00 | SPY | ETF | 113.75 | 113.83 | 113.73 | 113.74 | 182900.0 |
| 2004-04-16 17:30:00 | SPY | ETF | 113.73 | 113.73 | 113.73 | 113.73 | 100.0 |
| 2004-04-16 19:00:00 | SPY | ETF | 113.73 | 113.73 | 113.73 | 113.73 | 100.0 |
| 2004-04-16 08:00:00 | QQQ | ETF | 36.05 | 36.11 | 36.05 | 36.09 | 149800.0 |
| 2004-04-16 08:30:00 | QQQ | ETF | 36.09 | 36.2 | 36.05 | 36.2 | 293400.0 |
| 2004-04-16 09:00:00 | QQQ | ETF | 36.2 | 36.2 | 36.09 | 36.19 | 657800.0 |
| 2004-04-16 09:30:00 | QQQ | ETF | 36.2 | 36.233 | 35.79 | 35.89 | 11764900.0 |
| 2004-04-16 10:00:00 | QQQ | ETF | 35.886 | 35.999 | 35.842 | 35.97 | 8940000.0 |
| 2004-04-16 10:30:00 | QQQ | ETF | 35.98 | 36.08 | 35.97 | 36.03 | 5720200.0 |
| 2004-04-16 11:00:00 | QQQ | ETF | 36.03 | 36.3 | 36.01 | 36.14 | 12502600.0 |
| 2004-04-16 11:30:00 | QQQ | ETF | 36.141 | 36.23 | 36.09 | 36.22 | 5829800.0 |
| 2004-04-16 12:00:00 | QQQ | ETF | 36.21 | 36.25 | 36.13 | 36.17 | 5044300.0 |
| 2004-04-16 12:30:00 | QQQ | ETF | 36.17 | 36.32 | 36.14 | 36.27 | 4033000.0 |
| 2004-04-16 13:00:00 | QQQ | ETF | 36.27 | 36.27 | 36.11 | 36.128 | 3209700.0 |
| 2004-04-16 13:30:00 | QQQ | ETF | 36.127 | 36.19 | 36.05 | 36.13 | 2604800.0 |
| 2004-04-16 14:00:00 | QQQ | ETF | 36.124 | 36.211 | 36.12 | 36.205 | 3095100.0 |
| 2004-04-16 14:30:00 | QQQ | ETF | 36.205 | 36.22 | 36.09 | 36.11 | 3595400.0 |
| 2004-04-16 15:00:00 | QQQ | ETF | 36.109 | 36.133 | 35.97 | 36.023 | 6729000.0 |
| 2004-04-16 15:30:00 | QQQ | ETF | 36.021 | 36.14 | 35.99 | 36.05 | 5432900.0 |
| 2004-04-16 16:00:00 | QQQ | ETF | 36.04 | 36.13 | 36.0 | 36.062 | 2292000.0 |
| 2004-04-16 16:30:00 | QQQ | ETF | 36.07 | 36.08 | 36.05 | 36.07 | 158300.0 |
| 2004-04-16 17:00:00 | QQQ | ETF | 36.07 | 36.08 | 36.06 | 36.08 | 12000.0 |
| 2004-04-16 17:30:00 | QQQ | ETF | 36.08 | 36.08 | 36.06 | 36.08 | 32600.0 |
| 2004-04-16 18:00:00 | QQQ | ETF | 36.08 | 36.1 | 36.05 | 36.05 | 28100.0 |
| 2004-04-16 18:30:00 | QQQ | ETF | 36.1 | 36.12 | 36.05 | 36.08 | 22900.0 |
| 2004-04-16 19:00:00 | QQQ | ETF | 36.06 | 36.06 | 36.03 | 36.03 | 11100.0 |
| 2004-04-16 19:30:00 | QQQ | ETF | 36.05 | 36.05 | 36.05 | 36.05 | 100.0 |
| 2004-04-16 08:00:00 | IWM | ETF | 57.745 | 57.745 | 57.71 | 57.71 | 5000.0 |
| 2004-04-16 08:30:00 | IWM | ETF | 57.57 | 57.95 | 57.57 | 57.95 | 3000.0 |
| 2004-04-16 09:00:00 | IWM | ETF | 57.88 | 57.99 | 57.88 | 57.95 | 46800.0 |
| 2004-04-16 09:30:00 | IWM | ETF | 57.95 | 57.96 | 57.385 | 57.43 | 849600.0 |
| 2004-04-16 10:00:00 | IWM | ETF | 57.415 | 57.65 | 57.365 | 57.63 | 1703600.0 |
> showing 50 of 1,165 rows — these rows as CSV