PREVIEW / etf_30min / 2004-12-29
file: by_date/etf_30min/2004/2004-12-29.parquet size: 38 KB rows: 1,364
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-12-29 08:00:00 | SPY | ETF | 121.14 | 121.2 | 121.14 | 121.2 | 178600.0 |
| 2004-12-29 08:30:00 | SPY | ETF | 121.16 | 121.17 | 121.12 | 121.16 | 94100.0 |
| 2004-12-29 09:00:00 | SPY | ETF | 121.16 | 121.16 | 121.03 | 121.07 | 50800.0 |
| 2004-12-29 09:30:00 | SPY | ETF | 121.08 | 121.18 | 120.99 | 121.06 | 2062200.0 |
| 2004-12-29 10:00:00 | SPY | ETF | 121.06 | 121.23 | 121.03 | 121.14 | 1820800.0 |
| 2004-12-29 10:30:00 | SPY | ETF | 121.14 | 121.21 | 121.03 | 121.14 | 1565600.0 |
| 2004-12-29 11:00:00 | SPY | ETF | 121.14 | 121.33 | 121.11 | 121.25 | 1043500.0 |
| 2004-12-29 11:30:00 | SPY | ETF | 121.25 | 121.29 | 121.07 | 121.1 | 1137100.0 |
| 2004-12-29 12:00:00 | SPY | ETF | 121.1 | 121.14 | 121.07 | 121.12 | 837700.0 |
| 2004-12-29 12:30:00 | SPY | ETF | 121.12 | 121.15 | 121.01 | 121.04 | 2026300.0 |
| 2004-12-29 13:00:00 | SPY | ETF | 121.04 | 121.1 | 120.95 | 121.02 | 1600600.0 |
| 2004-12-29 13:30:00 | SPY | ETF | 121.03 | 121.1 | 120.95 | 121.07 | 1370100.0 |
| 2004-12-29 14:00:00 | SPY | ETF | 121.07 | 121.15 | 121.03 | 121.06 | 768500.0 |
| 2004-12-29 14:30:00 | SPY | ETF | 121.06 | 121.16 | 121.04 | 121.1 | 945100.0 |
| 2004-12-29 15:00:00 | SPY | ETF | 121.1 | 121.24 | 121.07 | 121.23 | 1419200.0 |
| 2004-12-29 15:30:00 | SPY | ETF | 121.23 | 121.3 | 121.1 | 121.29 | 1998100.0 |
| 2004-12-29 16:00:00 | SPY | ETF | 121.27 | 121.4 | 121.22 | 121.36 | 3265800.0 |
| 2004-12-29 16:30:00 | SPY | ETF | 121.33 | 121.38 | 121.3 | 121.37 | 33200.0 |
| 2004-12-29 17:00:00 | SPY | ETF | 121.38 | 121.39 | 121.24 | 121.38 | 1144000.0 |
| 2004-12-29 17:30:00 | SPY | ETF | 121.37 | 121.38 | 121.37 | 121.38 | 300.0 |
| 2004-12-29 18:00:00 | SPY | ETF | 121.37 | 121.37 | 121.35 | 121.35 | 1100.0 |
| 2004-12-29 18:30:00 | SPY | ETF | 121.33 | 121.33 | 121.33 | 121.33 | 100.0 |
| 2004-12-29 19:00:00 | SPY | ETF | 121.36 | 121.36 | 121.36 | 121.36 | 1300.0 |
| 2004-12-29 19:30:00 | SPY | ETF | 121.35 | 121.35 | 121.35 | 121.35 | 1000.0 |
| 2004-12-29 08:00:00 | QQQ | ETF | 39.95 | 39.98 | 39.95 | 39.98 | 127856.0 |
| 2004-12-29 08:30:00 | QQQ | ETF | 39.97 | 39.97 | 39.95 | 39.97 | 26440.0 |
| 2004-12-29 09:00:00 | QQQ | ETF | 39.97 | 39.97 | 39.91 | 39.93 | 321296.0 |
| 2004-12-29 09:30:00 | QQQ | ETF | 39.92 | 40.01 | 39.9 | 39.98 | 6118442.0 |
| 2004-12-29 10:00:00 | QQQ | ETF | 39.99 | 40.14 | 39.97 | 40.091 | 6953724.0 |
| 2004-12-29 10:30:00 | QQQ | ETF | 40.1 | 40.12 | 40.04 | 40.076 | 3186603.0 |
| 2004-12-29 11:00:00 | QQQ | ETF | 40.075 | 40.16 | 40.06 | 40.11 | 3373421.0 |
| 2004-12-29 11:30:00 | QQQ | ETF | 40.1101 | 40.12 | 39.99 | 40.01 | 3923911.0 |
| 2004-12-29 12:00:00 | QQQ | ETF | 40.01 | 40.03 | 39.998 | 40.003 | 2294663.0 |
| 2004-12-29 12:30:00 | QQQ | ETF | 40.006 | 40.01 | 39.94 | 39.962 | 2032162.0 |
| 2004-12-29 13:00:00 | QQQ | ETF | 39.96 | 39.99 | 39.9 | 39.96 | 2910364.0 |
| 2004-12-29 13:30:00 | QQQ | ETF | 39.97 | 40.02 | 39.948 | 39.974 | 2009066.0 |
| 2004-12-29 14:00:00 | QQQ | ETF | 39.973 | 40.01 | 39.93 | 39.95 | 1967029.0 |
| 2004-12-29 14:30:00 | QQQ | ETF | 39.94 | 39.9999 | 39.94 | 39.969 | 1528540.0 |
| 2004-12-29 15:00:00 | QQQ | ETF | 39.97 | 40.03 | 39.95 | 40.021 | 3079220.0 |
| 2004-12-29 15:30:00 | QQQ | ETF | 40.03 | 40.04 | 39.9399 | 40.01 | 4519337.0 |
| 2004-12-29 16:00:00 | QQQ | ETF | 40.01 | 40.061 | 40.0 | 40.03 | 1803807.0 |
| 2004-12-29 16:30:00 | QQQ | ETF | 40.03 | 40.05 | 39.99 | 40.04 | 155580.0 |
| 2004-12-29 17:00:00 | QQQ | ETF | 40.05 | 40.05 | 40.049 | 40.05 | 4516.0 |
| 2004-12-29 17:30:00 | QQQ | ETF | 40.04 | 40.05 | 40.03 | 40.05 | 2400.0 |
| 2004-12-29 18:00:00 | QQQ | ETF | 40.05 | 40.07 | 40.05 | 40.07 | 10933.0 |
| 2004-12-29 08:30:00 | IWM | ETF | 65.025 | 65.025 | 65.025 | 65.025 | 1800.0 |
| 2004-12-29 09:00:00 | IWM | ETF | 65.0 | 65.0 | 64.99 | 64.99 | 26600.0 |
| 2004-12-29 09:30:00 | IWM | ETF | 65.01 | 65.015 | 64.86 | 64.945 | 1194400.0 |
| 2004-12-29 10:00:00 | IWM | ETF | 64.95 | 65.09 | 64.89 | 65.03 | 738600.0 |
| 2004-12-29 10:30:00 | IWM | ETF | 65.03 | 65.05 | 64.945 | 65.025 | 771600.0 |
> showing 50 of 1,364 rows — these rows as CSV