PREVIEW / etf_30min / 2004-06-10
file: by_date/etf_30min/2004/2004-06-10.parquet size: 33 KB rows: 1,146
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-06-10 08:00:00 | SPY | ETF | 114.14 | 114.15 | 113.96 | 114.12 | 395900.0 |
| 2004-06-10 08:30:00 | SPY | ETF | 114.12 | 114.14 | 114.01 | 114.1 | 51000.0 |
| 2004-06-10 09:00:00 | SPY | ETF | 114.12 | 114.12 | 114.01 | 114.05 | 68600.0 |
| 2004-06-10 09:30:00 | SPY | ETF | 114.04 | 114.15 | 113.95 | 114.08 | 2422400.0 |
| 2004-06-10 10:00:00 | SPY | ETF | 114.09 | 114.29 | 114.07 | 114.23 | 3669700.0 |
| 2004-06-10 10:30:00 | SPY | ETF | 114.24 | 114.3 | 114.07 | 114.08 | 2397900.0 |
| 2004-06-10 11:00:00 | SPY | ETF | 114.08 | 114.15 | 113.93 | 114.14 | 1312000.0 |
| 2004-06-10 11:30:00 | SPY | ETF | 114.13 | 114.25 | 114.07 | 114.14 | 1225600.0 |
| 2004-06-10 12:00:00 | SPY | ETF | 114.09 | 114.18 | 114.04 | 114.04 | 813100.0 |
| 2004-06-10 12:30:00 | SPY | ETF | 114.04 | 114.19 | 114.04 | 114.09 | 858600.0 |
| 2004-06-10 13:00:00 | SPY | ETF | 114.1 | 114.19 | 114.03 | 114.1 | 811000.0 |
| 2004-06-10 13:30:00 | SPY | ETF | 114.1 | 114.17 | 113.97 | 114.09 | 697900.0 |
| 2004-06-10 14:00:00 | SPY | ETF | 114.11 | 114.17 | 114.03 | 114.16 | 526700.0 |
| 2004-06-10 14:30:00 | SPY | ETF | 114.16 | 114.2 | 114.11 | 114.16 | 1072600.0 |
| 2004-06-10 15:00:00 | SPY | ETF | 114.14 | 114.17 | 114.0 | 114.12 | 1164100.0 |
| 2004-06-10 15:30:00 | SPY | ETF | 114.12 | 114.32 | 114.08 | 114.3 | 2142900.0 |
| 2004-06-10 16:00:00 | SPY | ETF | 114.3 | 114.42 | 114.15 | 114.37 | 1191300.0 |
| 2004-06-10 16:30:00 | SPY | ETF | 114.35 | 114.35 | 114.25 | 114.32 | 82000.0 |
| 2004-06-10 17:00:00 | SPY | ETF | 114.32 | 114.32 | 114.29 | 114.32 | 6700.0 |
| 2004-06-10 17:30:00 | SPY | ETF | 114.39 | 114.39 | 114.28 | 114.28 | 2100.0 |
| 2004-06-10 18:00:00 | SPY | ETF | 114.32 | 114.34 | 114.29 | 114.34 | 2700.0 |
| 2004-06-10 18:30:00 | SPY | ETF | 114.34 | 114.34 | 114.28 | 114.28 | 600.0 |
| 2004-06-10 19:00:00 | SPY | ETF | 114.28 | 114.28 | 114.28 | 114.28 | 300.0 |
| 2004-06-10 08:00:00 | QQQ | ETF | 36.73 | 36.73 | 36.64 | 36.71 | 278300.0 |
| 2004-06-10 08:30:00 | QQQ | ETF | 36.68 | 36.78 | 36.67 | 36.78 | 178200.0 |
| 2004-06-10 09:00:00 | QQQ | ETF | 36.77 | 36.77 | 36.68 | 36.7 | 130100.0 |
| 2004-06-10 09:30:00 | QQQ | ETF | 36.69 | 36.79 | 36.65 | 36.69 | 9458900.0 |
| 2004-06-10 10:00:00 | QQQ | ETF | 36.7 | 36.82 | 36.69 | 36.79 | 6228700.0 |
| 2004-06-10 10:30:00 | QQQ | ETF | 36.8 | 36.802 | 36.708 | 36.71 | 4000100.0 |
| 2004-06-10 11:00:00 | QQQ | ETF | 36.709 | 36.71 | 36.55 | 36.67 | 7209600.0 |
| 2004-06-10 11:30:00 | QQQ | ETF | 36.67 | 36.77 | 36.65 | 36.69 | 3513100.0 |
| 2004-06-10 12:00:00 | QQQ | ETF | 36.69 | 36.7 | 36.63 | 36.65 | 1812500.0 |
| 2004-06-10 12:30:00 | QQQ | ETF | 36.653 | 36.7 | 36.639 | 36.641 | 1766200.0 |
| 2004-06-10 13:00:00 | QQQ | ETF | 36.64 | 36.7 | 36.61 | 36.67 | 1411500.0 |
| 2004-06-10 13:30:00 | QQQ | ETF | 36.67 | 36.7 | 36.62 | 36.68 | 1744400.0 |
| 2004-06-10 14:00:00 | QQQ | ETF | 36.678 | 36.7 | 36.64 | 36.7 | 1866500.0 |
| 2004-06-10 14:30:00 | QQQ | ETF | 36.69 | 36.76 | 36.69 | 36.72 | 2646100.0 |
| 2004-06-10 15:00:00 | QQQ | ETF | 36.71 | 36.73 | 36.67 | 36.72 | 2592400.0 |
| 2004-06-10 15:30:00 | QQQ | ETF | 36.727 | 36.81 | 36.69 | 36.8 | 6061800.0 |
| 2004-06-10 16:00:00 | QQQ | ETF | 36.79 | 36.85 | 36.765 | 36.84 | 1483600.0 |
| 2004-06-10 16:30:00 | QQQ | ETF | 36.83 | 36.859 | 36.82 | 36.84 | 285000.0 |
| 2004-06-10 17:00:00 | QQQ | ETF | 36.837 | 36.85 | 36.82 | 36.82 | 65300.0 |
| 2004-06-10 17:30:00 | QQQ | ETF | 36.82 | 36.84 | 36.82 | 36.82 | 3200.0 |
| 2004-06-10 18:00:00 | QQQ | ETF | 36.84 | 36.84 | 36.82 | 36.82 | 26500.0 |
| 2004-06-10 19:30:00 | QQQ | ETF | 36.82 | 36.83 | 36.82 | 36.83 | 2000.0 |
| 2004-06-10 09:00:00 | IWM | ETF | 56.85 | 56.94 | 56.85 | 56.94 | 6800.0 |
| 2004-06-10 09:30:00 | IWM | ETF | 56.97 | 57.075 | 56.82 | 56.91 | 848000.0 |
| 2004-06-10 10:00:00 | IWM | ETF | 56.91 | 57.04 | 56.875 | 56.955 | 683600.0 |
| 2004-06-10 10:30:00 | IWM | ETF | 56.95 | 56.95 | 56.68 | 56.755 | 396800.0 |
| 2004-06-10 11:00:00 | IWM | ETF | 56.74 | 56.745 | 56.585 | 56.745 | 1511800.0 |
> showing 50 of 1,146 rows — these rows as CSV