PREVIEW / etf_30min / 2004-08-20
file: by_date/etf_30min/2004/2004-08-20.parquet size: 35 KB rows: 1,131
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-20 08:00:00 | SPY | ETF | 109.53 | 109.53 | 109.33 | 109.52 | 43500.0 |
| 2004-08-20 08:30:00 | SPY | ETF | 109.43 | 109.5 | 109.43 | 109.44 | 8500.0 |
| 2004-08-20 09:00:00 | SPY | ETF | 109.43 | 109.62 | 109.41 | 109.62 | 42300.0 |
| 2004-08-20 09:30:00 | SPY | ETF | 109.61 | 109.99 | 109.51 | 109.87 | 5835700.0 |
| 2004-08-20 10:00:00 | SPY | ETF | 109.86 | 109.99 | 109.79 | 109.82 | 3474600.0 |
| 2004-08-20 10:30:00 | SPY | ETF | 109.82 | 110.17 | 109.81 | 109.94 | 3528500.0 |
| 2004-08-20 11:00:00 | SPY | ETF | 109.94 | 110.0 | 109.84 | 109.96 | 1760800.0 |
| 2004-08-20 11:30:00 | SPY | ETF | 109.96 | 109.99 | 109.81 | 109.93 | 1697500.0 |
| 2004-08-20 12:00:00 | SPY | ETF | 109.92 | 110.14 | 109.91 | 110.02 | 4607400.0 |
| 2004-08-20 12:30:00 | SPY | ETF | 110.02 | 110.35 | 109.98 | 110.25 | 2235500.0 |
| 2004-08-20 13:00:00 | SPY | ETF | 110.25 | 110.32 | 110.21 | 110.24 | 1008700.0 |
| 2004-08-20 13:30:00 | SPY | ETF | 110.24 | 110.48 | 110.23 | 110.35 | 2904700.0 |
| 2004-08-20 14:00:00 | SPY | ETF | 110.35 | 110.54 | 110.29 | 110.4 | 2588900.0 |
| 2004-08-20 14:30:00 | SPY | ETF | 110.39 | 110.56 | 110.3 | 110.47 | 4369100.0 |
| 2004-08-20 15:00:00 | SPY | ETF | 110.45 | 110.6 | 110.4 | 110.48 | 3570400.0 |
| 2004-08-20 15:30:00 | SPY | ETF | 110.48 | 110.63 | 110.34 | 110.44 | 4393500.0 |
| 2004-08-20 16:00:00 | SPY | ETF | 110.44 | 110.5 | 110.38 | 110.46 | 1163200.0 |
| 2004-08-20 16:30:00 | SPY | ETF | 110.46 | 110.47 | 110.4 | 110.42 | 6900.0 |
| 2004-08-20 17:00:00 | SPY | ETF | 110.42 | 110.44 | 110.4 | 110.41 | 16400.0 |
| 2004-08-20 17:30:00 | SPY | ETF | 110.41 | 110.41 | 110.39 | 110.39 | 600.0 |
| 2004-08-20 18:00:00 | SPY | ETF | 110.41 | 110.48 | 110.41 | 110.48 | 5900.0 |
| 2004-08-20 18:30:00 | SPY | ETF | 110.48 | 110.48 | 110.46 | 110.46 | 1200.0 |
| 2004-08-20 19:30:00 | SPY | ETF | 110.44 | 110.5 | 110.44 | 110.5 | 5100.0 |
| 2004-08-20 08:00:00 | QQQ | ETF | 33.67 | 33.67 | 33.5 | 33.55 | 23600.0 |
| 2004-08-20 08:30:00 | QQQ | ETF | 33.55 | 33.55 | 33.52 | 33.53 | 35900.0 |
| 2004-08-20 09:00:00 | QQQ | ETF | 33.52 | 33.56 | 33.51 | 33.56 | 78600.0 |
| 2004-08-20 09:30:00 | QQQ | ETF | 33.57 | 33.75 | 33.51 | 33.691 | 10902700.0 |
| 2004-08-20 10:00:00 | QQQ | ETF | 33.694 | 33.763 | 33.64 | 33.7 | 7614100.0 |
| 2004-08-20 10:30:00 | QQQ | ETF | 33.7 | 33.863 | 33.69 | 33.772 | 7857000.0 |
| 2004-08-20 11:00:00 | QQQ | ETF | 33.77 | 33.79 | 33.71 | 33.772 | 4023000.0 |
| 2004-08-20 11:30:00 | QQQ | ETF | 33.772 | 33.8 | 33.72 | 33.785 | 3729600.0 |
| 2004-08-20 12:00:00 | QQQ | ETF | 33.785 | 33.88 | 33.75 | 33.8 | 5937000.0 |
| 2004-08-20 12:30:00 | QQQ | ETF | 33.8 | 33.99 | 33.78 | 33.95 | 6942700.0 |
| 2004-08-20 13:00:00 | QQQ | ETF | 33.944 | 33.96 | 33.91 | 33.93 | 3672800.0 |
| 2004-08-20 13:30:00 | QQQ | ETF | 33.93 | 34.01 | 33.889 | 33.98 | 6747900.0 |
| 2004-08-20 14:00:00 | QQQ | ETF | 33.98 | 34.07 | 33.96 | 34.02 | 5951300.0 |
| 2004-08-20 14:30:00 | QQQ | ETF | 34.023 | 34.08 | 33.97 | 34.05 | 5296700.0 |
| 2004-08-20 15:00:00 | QQQ | ETF | 34.05 | 34.14 | 34.04 | 34.084 | 6705900.0 |
| 2004-08-20 15:30:00 | QQQ | ETF | 34.085 | 34.14 | 33.98 | 34.01 | 10280300.0 |
| 2004-08-20 16:00:00 | QQQ | ETF | 34.0 | 34.03 | 33.97 | 33.98 | 3682700.0 |
| 2004-08-20 16:30:00 | QQQ | ETF | 33.98 | 34.0 | 33.97 | 34.0 | 276700.0 |
| 2004-08-20 17:00:00 | QQQ | ETF | 34.0 | 34.02 | 33.99 | 34.01 | 48800.0 |
| 2004-08-20 17:30:00 | QQQ | ETF | 34.02 | 34.02 | 33.96 | 33.99 | 44100.0 |
| 2004-08-20 18:00:00 | QQQ | ETF | 33.98 | 34.01 | 33.96 | 33.96 | 36800.0 |
| 2004-08-20 18:30:00 | QQQ | ETF | 34.01 | 34.01 | 33.94 | 33.94 | 12400.0 |
| 2004-08-20 19:00:00 | QQQ | ETF | 34.0 | 34.0 | 33.96 | 33.96 | 3100.0 |
| 2004-08-20 19:30:00 | QQQ | ETF | 34.0 | 34.0 | 34.0 | 34.0 | 100.0 |
| 2004-08-20 08:00:00 | IWM | ETF | 53.52 | 53.52 | 53.52 | 53.52 | 200.0 |
| 2004-08-20 08:30:00 | IWM | ETF | 53.505 | 53.505 | 53.405 | 53.405 | 1000.0 |
| 2004-08-20 09:00:00 | IWM | ETF | 53.415 | 53.48 | 53.36 | 53.405 | 15000.0 |
> showing 50 of 1,131 rows — these rows as CSV