PREVIEW / etf_30min / 2004-08-24
file: by_date/etf_30min/2004/2004-08-24.parquet size: 34 KB rows: 1,142
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-08-24 08:00:00 | SPY | ETF | 110.54 | 110.64 | 110.52 | 110.62 | 13000.0 |
| 2004-08-24 08:30:00 | SPY | ETF | 110.64 | 110.64 | 110.56 | 110.56 | 25400.0 |
| 2004-08-24 09:00:00 | SPY | ETF | 110.6 | 110.7 | 110.6 | 110.62 | 90900.0 |
| 2004-08-24 09:30:00 | SPY | ETF | 110.64 | 110.7 | 110.45 | 110.6 | 2382400.0 |
| 2004-08-24 10:00:00 | SPY | ETF | 110.58 | 110.73 | 110.32 | 110.33 | 2899600.0 |
| 2004-08-24 10:30:00 | SPY | ETF | 110.33 | 110.36 | 110.06 | 110.22 | 3721000.0 |
| 2004-08-24 11:00:00 | SPY | ETF | 110.22 | 110.25 | 110.03 | 110.17 | 2031900.0 |
| 2004-08-24 11:30:00 | SPY | ETF | 110.16 | 110.23 | 110.03 | 110.06 | 1215800.0 |
| 2004-08-24 12:00:00 | SPY | ETF | 110.06 | 110.07 | 109.85 | 109.95 | 1751200.0 |
| 2004-08-24 12:30:00 | SPY | ETF | 109.95 | 110.2 | 109.89 | 110.17 | 2360700.0 |
| 2004-08-24 13:00:00 | SPY | ETF | 110.16 | 110.38 | 110.09 | 110.32 | 1286500.0 |
| 2004-08-24 13:30:00 | SPY | ETF | 110.31 | 110.39 | 110.23 | 110.33 | 1162500.0 |
| 2004-08-24 14:00:00 | SPY | ETF | 110.33 | 110.34 | 110.1 | 110.18 | 1543100.0 |
| 2004-08-24 14:30:00 | SPY | ETF | 110.19 | 110.22 | 110.08 | 110.11 | 1283700.0 |
| 2004-08-24 15:00:00 | SPY | ETF | 110.1 | 110.18 | 109.95 | 110.09 | 1909600.0 |
| 2004-08-24 15:30:00 | SPY | ETF | 110.09 | 110.28 | 110.05 | 110.19 | 3103900.0 |
| 2004-08-24 16:00:00 | SPY | ETF | 110.21 | 110.4 | 110.14 | 110.35 | 802500.0 |
| 2004-08-24 16:30:00 | SPY | ETF | 110.35 | 110.4 | 110.33 | 110.36 | 8400.0 |
| 2004-08-24 17:00:00 | SPY | ETF | 110.37 | 110.38 | 110.37 | 110.37 | 21100.0 |
| 2004-08-24 17:30:00 | SPY | ETF | 110.33 | 110.35 | 110.31 | 110.32 | 20300.0 |
| 2004-08-24 18:00:00 | SPY | ETF | 110.31 | 110.36 | 110.3 | 110.3 | 79800.0 |
| 2004-08-24 18:30:00 | SPY | ETF | 110.28 | 110.28 | 110.28 | 110.28 | 2000.0 |
| 2004-08-24 19:00:00 | SPY | ETF | 110.28 | 110.28 | 110.21 | 110.21 | 1500.0 |
| 2004-08-24 19:30:00 | SPY | ETF | 110.25 | 110.25 | 110.18 | 110.18 | 8300.0 |
| 2004-08-24 08:00:00 | QQQ | ETF | 34.19 | 34.23 | 34.19 | 34.22 | 72500.0 |
| 2004-08-24 08:30:00 | QQQ | ETF | 34.22 | 34.23 | 34.2 | 34.22 | 77100.0 |
| 2004-08-24 09:00:00 | QQQ | ETF | 34.22 | 34.29 | 34.21 | 34.24 | 300900.0 |
| 2004-08-24 09:30:00 | QQQ | ETF | 34.25 | 34.31 | 34.13 | 34.21 | 12331700.0 |
| 2004-08-24 10:00:00 | QQQ | ETF | 34.21 | 34.292 | 34.078 | 34.082 | 9216300.0 |
| 2004-08-24 10:30:00 | QQQ | ETF | 34.1 | 34.11 | 33.92 | 33.97 | 10495500.0 |
| 2004-08-24 11:00:00 | QQQ | ETF | 33.97 | 33.98 | 33.82 | 33.91 | 7717800.0 |
| 2004-08-24 11:30:00 | QQQ | ETF | 33.9 | 33.983 | 33.89 | 33.94 | 4184900.0 |
| 2004-08-24 12:00:00 | QQQ | ETF | 33.937 | 33.95 | 33.84 | 33.9 | 4552100.0 |
| 2004-08-24 12:30:00 | QQQ | ETF | 33.89 | 34.02 | 33.868 | 34.0 | 5392000.0 |
| 2004-08-24 13:00:00 | QQQ | ETF | 34.0 | 34.08 | 33.943 | 34.07 | 3692000.0 |
| 2004-08-24 13:30:00 | QQQ | ETF | 34.066 | 34.1 | 34.02 | 34.07 | 3456600.0 |
| 2004-08-24 14:00:00 | QQQ | ETF | 34.08 | 34.11 | 33.94 | 33.98 | 4625700.0 |
| 2004-08-24 14:30:00 | QQQ | ETF | 33.9785 | 34.001 | 33.94 | 33.95 | 2390400.0 |
| 2004-08-24 15:00:00 | QQQ | ETF | 33.95 | 33.96 | 33.86 | 33.924 | 5137100.0 |
| 2004-08-24 15:30:00 | QQQ | ETF | 33.924 | 34.05 | 33.9 | 34.036 | 6989200.0 |
| 2004-08-24 16:00:00 | QQQ | ETF | 34.03 | 34.14 | 34.02 | 34.05 | 2537600.0 |
| 2004-08-24 16:30:00 | QQQ | ETF | 34.08 | 34.139 | 34.072 | 34.12 | 578900.0 |
| 2004-08-24 17:00:00 | QQQ | ETF | 34.12 | 34.15 | 34.12 | 34.12 | 359700.0 |
| 2004-08-24 17:30:00 | QQQ | ETF | 34.13 | 34.13 | 34.09 | 34.09 | 134800.0 |
| 2004-08-24 18:00:00 | QQQ | ETF | 34.1 | 34.12 | 34.06 | 34.09 | 134900.0 |
| 2004-08-24 18:30:00 | QQQ | ETF | 34.1 | 34.1 | 34.1 | 34.1 | 1000.0 |
| 2004-08-24 19:00:00 | QQQ | ETF | 34.12 | 34.12 | 34.08 | 34.08 | 15000.0 |
| 2004-08-24 19:30:00 | QQQ | ETF | 34.08 | 34.11 | 34.07 | 34.11 | 9200.0 |
| 2004-08-24 09:00:00 | IWM | ETF | 54.625 | 54.625 | 54.62 | 54.62 | 3000.0 |
| 2004-08-24 09:30:00 | IWM | ETF | 54.625 | 54.75 | 54.475 | 54.6 | 914600.0 |
> showing 50 of 1,142 rows — these rows as CSV