PREVIEW / etf_30min / 2004-03-11
file: by_date/etf_30min/2004/2004-03-11.parquet size: 39 KB rows: 1,241
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-03-11 08:00:00 | SPY | ETF | 112.11 | 112.11 | 111.88 | 112.04 | 452800.0 |
| 2004-03-11 08:30:00 | SPY | ETF | 112.0 | 112.1 | 111.84 | 112.06 | 478100.0 |
| 2004-03-11 09:00:00 | SPY | ETF | 112.05 | 112.36 | 112.02 | 112.36 | 603200.0 |
| 2004-03-11 09:30:00 | SPY | ETF | 112.4 | 112.79 | 112.19 | 112.7 | 6489500.0 |
| 2004-03-11 10:00:00 | SPY | ETF | 112.66 | 112.95 | 112.39 | 112.92 | 3496200.0 |
| 2004-03-11 10:30:00 | SPY | ETF | 112.92 | 112.92 | 112.51 | 112.55 | 1817000.0 |
| 2004-03-11 11:00:00 | SPY | ETF | 112.56 | 112.57 | 112.24 | 112.5 | 2537200.0 |
| 2004-03-11 11:30:00 | SPY | ETF | 112.5 | 112.77 | 112.42 | 112.69 | 2502700.0 |
| 2004-03-11 12:00:00 | SPY | ETF | 112.69 | 113.1 | 112.62 | 112.9 | 4699800.0 |
| 2004-03-11 12:30:00 | SPY | ETF | 112.92 | 113.24 | 112.85 | 113.23 | 2281000.0 |
| 2004-03-11 13:00:00 | SPY | ETF | 113.23 | 113.27 | 112.97 | 113.1 | 2582700.0 |
| 2004-03-11 13:30:00 | SPY | ETF | 113.1 | 113.12 | 112.8 | 112.84 | 1783800.0 |
| 2004-03-11 14:00:00 | SPY | ETF | 112.84 | 113.18 | 112.68 | 112.97 | 3536300.0 |
| 2004-03-11 14:30:00 | SPY | ETF | 112.98 | 113.02 | 112.3 | 112.42 | 6291000.0 |
| 2004-03-11 15:00:00 | SPY | ETF | 112.45 | 112.68 | 111.76 | 111.82 | 7267500.0 |
| 2004-03-11 15:30:00 | SPY | ETF | 111.85 | 112.03 | 111.15 | 111.33 | 8625100.0 |
| 2004-03-11 16:00:00 | SPY | ETF | 111.35 | 111.36 | 111.05 | 111.07 | 4860200.0 |
| 2004-03-11 16:30:00 | SPY | ETF | 111.14 | 111.41 | 111.04 | 111.25 | 722800.0 |
| 2004-03-11 17:00:00 | SPY | ETF | 111.23 | 111.25 | 111.17 | 111.2 | 120800.0 |
| 2004-03-11 17:30:00 | SPY | ETF | 111.24 | 112.98 | 111.19 | 111.2 | 107200.0 |
| 2004-03-11 18:00:00 | SPY | ETF | 111.17 | 111.23 | 111.15 | 111.15 | 34900.0 |
| 2004-03-11 18:30:00 | SPY | ETF | 111.18 | 111.18 | 111.0 | 111.0 | 43000.0 |
| 2004-03-11 19:00:00 | SPY | ETF | 111.05 | 111.08 | 110.99 | 111.04 | 38000.0 |
| 2004-03-11 19:30:00 | SPY | ETF | 111.07 | 111.2 | 111.07 | 111.19 | 6600.0 |
| 2004-03-11 08:00:00 | QQQ | ETF | 35.0 | 35.0 | 34.89 | 34.94 | 209100.0 |
| 2004-03-11 08:30:00 | QQQ | ETF | 34.92 | 34.98 | 34.89 | 34.97 | 320400.0 |
| 2004-03-11 09:00:00 | QQQ | ETF | 34.98 | 35.09 | 34.97 | 35.07 | 789500.0 |
| 2004-03-11 09:30:00 | QQQ | ETF | 35.07 | 35.37 | 34.98 | 35.265 | 15142800.0 |
| 2004-03-11 10:00:00 | QQQ | ETF | 35.27 | 35.47 | 35.18 | 35.43 | 7723700.0 |
| 2004-03-11 10:30:00 | QQQ | ETF | 35.44 | 35.45 | 35.22 | 35.233 | 6569800.0 |
| 2004-03-11 11:00:00 | QQQ | ETF | 35.23 | 35.24 | 35.08 | 35.22 | 7463100.0 |
| 2004-03-11 11:30:00 | QQQ | ETF | 35.23 | 35.32 | 35.18 | 35.31 | 4856400.0 |
| 2004-03-11 12:00:00 | QQQ | ETF | 35.31 | 35.47 | 35.249 | 35.42 | 6343900.0 |
| 2004-03-11 12:30:00 | QQQ | ETF | 35.41 | 35.53 | 35.39 | 35.506 | 7079700.0 |
| 2004-03-11 13:00:00 | QQQ | ETF | 35.5 | 35.53 | 35.37 | 35.448 | 6442100.0 |
| 2004-03-11 13:30:00 | QQQ | ETF | 35.44 | 35.45 | 35.32 | 35.35 | 3139300.0 |
| 2004-03-11 14:00:00 | QQQ | ETF | 35.35 | 35.53 | 35.27 | 35.43 | 6997700.0 |
| 2004-03-11 14:30:00 | QQQ | ETF | 35.44 | 35.452 | 35.225 | 35.297 | 6946200.0 |
| 2004-03-11 15:00:00 | QQQ | ETF | 35.3 | 35.38 | 35.04 | 35.07 | 8842600.0 |
| 2004-03-11 15:30:00 | QQQ | ETF | 35.07 | 35.142 | 34.86 | 34.9 | 16335900.0 |
| 2004-03-11 16:00:00 | QQQ | ETF | 34.9 | 34.95 | 34.8 | 34.88 | 4197900.0 |
| 2004-03-11 16:30:00 | QQQ | ETF | 34.88 | 34.921 | 34.83 | 34.91 | 722000.0 |
| 2004-03-11 17:00:00 | QQQ | ETF | 34.9 | 34.913 | 34.85 | 34.88 | 210000.0 |
| 2004-03-11 17:30:00 | QQQ | ETF | 34.87 | 34.91 | 34.861 | 34.89 | 211900.0 |
| 2004-03-11 18:00:00 | QQQ | ETF | 34.88 | 34.89 | 34.85 | 34.859 | 127900.0 |
| 2004-03-11 18:30:00 | QQQ | ETF | 34.85 | 34.85 | 34.82 | 34.82 | 37200.0 |
| 2004-03-11 19:00:00 | QQQ | ETF | 34.83 | 34.83 | 34.8 | 34.8 | 17600.0 |
| 2004-03-11 19:30:00 | QQQ | ETF | 34.83 | 34.88 | 34.81 | 34.88 | 37200.0 |
| 2004-03-11 08:00:00 | IWM | ETF | 56.625 | 56.625 | 56.625 | 56.625 | 200.0 |
| 2004-03-11 08:30:00 | IWM | ETF | 56.555 | 56.7 | 56.555 | 56.7 | 2400.0 |
> showing 50 of 1,241 rows — these rows as CSV