PREVIEW / etf_30min / 2004-06-09
file: by_date/etf_30min/2004/2004-06-09.parquet size: 36 KB rows: 1,171
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-09 08:00:00 | SPY | ETF | 114.54 | 114.56 | 114.54 | 114.54 | 12500.0 |
| 2004-06-09 08:30:00 | SPY | ETF | 114.56 | 114.59 | 114.51 | 114.57 | 40200.0 |
| 2004-06-09 09:00:00 | SPY | ETF | 114.55 | 114.6 | 114.5 | 114.5 | 24400.0 |
| 2004-06-09 09:30:00 | SPY | ETF | 114.51 | 114.7 | 114.42 | 114.55 | 2273900.0 |
| 2004-06-09 10:00:00 | SPY | ETF | 114.549 | 114.6 | 114.36 | 114.4 | 1910300.0 |
| 2004-06-09 10:30:00 | SPY | ETF | 114.41 | 114.52 | 114.21 | 114.23 | 2780300.0 |
| 2004-06-09 11:00:00 | SPY | ETF | 114.23 | 114.37 | 114.1 | 114.16 | 1995700.0 |
| 2004-06-09 11:30:00 | SPY | ETF | 114.16 | 114.27 | 114.11 | 114.24 | 2317500.0 |
| 2004-06-09 12:00:00 | SPY | ETF | 114.24 | 114.26 | 114.06 | 114.22 | 1927400.0 |
| 2004-06-09 12:30:00 | SPY | ETF | 114.21 | 114.26 | 114.12 | 114.25 | 1238700.0 |
| 2004-06-09 13:00:00 | SPY | ETF | 114.28 | 114.32 | 114.13 | 114.19 | 1295700.0 |
| 2004-06-09 13:30:00 | SPY | ETF | 114.19 | 114.22 | 113.89 | 113.96 | 1903800.0 |
| 2004-06-09 14:00:00 | SPY | ETF | 113.94 | 114.17 | 113.84 | 114.15 | 3388200.0 |
| 2004-06-09 14:30:00 | SPY | ETF | 114.15 | 114.25 | 114.1 | 114.14 | 3308000.0 |
| 2004-06-09 15:00:00 | SPY | ETF | 114.14 | 114.19 | 113.9 | 113.93 | 2259600.0 |
| 2004-06-09 15:30:00 | SPY | ETF | 113.93 | 114.02 | 113.73 | 113.77 | 4113900.0 |
| 2004-06-09 16:00:00 | SPY | ETF | 113.78 | 114.2 | 113.72 | 114.08 | 1714000.0 |
| 2004-06-09 16:30:00 | SPY | ETF | 114.07 | 114.07 | 113.56 | 113.9 | 1078200.0 |
| 2004-06-09 17:00:00 | SPY | ETF | 113.9 | 113.97 | 113.9 | 113.96 | 99900.0 |
| 2004-06-09 17:30:00 | SPY | ETF | 113.95 | 113.97 | 113.94 | 113.94 | 10200.0 |
| 2004-06-09 18:00:00 | SPY | ETF | 113.95 | 113.97 | 113.95 | 113.97 | 6200.0 |
| 2004-06-09 18:30:00 | SPY | ETF | 113.97 | 113.97 | 113.95 | 113.95 | 3900.0 |
| 2004-06-09 19:00:00 | SPY | ETF | 113.94 | 113.94 | 113.91 | 113.91 | 5000.0 |
| 2004-06-09 19:30:00 | SPY | ETF | 113.92 | 113.92 | 113.87 | 113.87 | 4600.0 |
| 2004-06-09 08:00:00 | QQQ | ETF | 36.97 | 36.99 | 36.95 | 36.95 | 25200.0 |
| 2004-06-09 08:30:00 | QQQ | ETF | 36.96 | 36.98 | 36.94 | 36.98 | 32800.0 |
| 2004-06-09 09:00:00 | QQQ | ETF | 36.98 | 36.98 | 36.96 | 36.98 | 41500.0 |
| 2004-06-09 09:30:00 | QQQ | ETF | 36.98 | 37.05 | 36.926 | 36.97 | 9413300.0 |
| 2004-06-09 10:00:00 | QQQ | ETF | 36.972 | 37.0 | 36.89 | 36.92 | 6228500.0 |
| 2004-06-09 10:30:00 | QQQ | ETF | 36.917 | 36.97 | 36.83 | 36.857 | 8457900.0 |
| 2004-06-09 11:00:00 | QQQ | ETF | 36.86 | 36.9 | 36.8 | 36.84 | 4343700.0 |
| 2004-06-09 11:30:00 | QQQ | ETF | 36.83 | 36.89 | 36.8 | 36.84 | 3597300.0 |
| 2004-06-09 12:00:00 | QQQ | ETF | 36.85 | 36.86 | 36.74 | 36.8 | 5432200.0 |
| 2004-06-09 12:30:00 | QQQ | ETF | 36.8 | 36.831 | 36.75 | 36.823 | 2341500.0 |
| 2004-06-09 13:00:00 | QQQ | ETF | 36.823 | 36.86 | 36.77 | 36.797 | 5202300.0 |
| 2004-06-09 13:30:00 | QQQ | ETF | 36.79 | 36.81 | 36.56 | 36.57 | 10248700.0 |
| 2004-06-09 14:00:00 | QQQ | ETF | 36.577 | 36.669 | 36.55 | 36.668 | 9259200.0 |
| 2004-06-09 14:30:00 | QQQ | ETF | 36.67 | 36.74 | 36.64 | 36.67 | 9114000.0 |
| 2004-06-09 15:00:00 | QQQ | ETF | 36.677 | 36.7 | 36.58 | 36.59 | 5717900.0 |
| 2004-06-09 15:30:00 | QQQ | ETF | 36.59 | 36.63 | 36.51 | 36.53 | 10991600.0 |
| 2004-06-09 16:00:00 | QQQ | ETF | 36.515 | 36.632 | 36.5 | 36.59 | 3754700.0 |
| 2004-06-09 16:30:00 | QQQ | ETF | 36.59 | 36.63 | 36.499 | 36.6 | 816500.0 |
| 2004-06-09 17:00:00 | QQQ | ETF | 36.59 | 36.61 | 36.59 | 36.61 | 12600.0 |
| 2004-06-09 17:30:00 | QQQ | ETF | 36.6 | 36.61 | 36.6 | 36.6 | 11000.0 |
| 2004-06-09 18:00:00 | QQQ | ETF | 36.6 | 36.6 | 36.59 | 36.59 | 14700.0 |
| 2004-06-09 18:30:00 | QQQ | ETF | 36.59 | 36.6 | 36.58 | 36.6 | 4700.0 |
| 2004-06-09 19:00:00 | QQQ | ETF | 36.6 | 36.6 | 36.6 | 36.6 | 1000.0 |
| 2004-06-09 19:30:00 | QQQ | ETF | 36.6 | 36.6 | 36.59 | 36.6 | 7300.0 |
| 2004-06-09 08:30:00 | IWM | ETF | 57.56 | 57.56 | 57.51 | 57.51 | 1800.0 |
| 2004-06-09 09:00:00 | IWM | ETF | 57.555 | 57.555 | 57.555 | 57.555 | 400.0 |
> showing 50 of 1,171 rows — these rows as CSV