PREVIEW / etf_30min / 2004-03-26
file: by_date/etf_30min/2004/2004-03-26.parquet size: 34 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-03-26 08:00:00 | SPY | ETF | 111.19 | 111.19 | 111.15 | 111.15 | 7200.0 |
| 2004-03-26 08:30:00 | SPY | ETF | 111.11 | 111.18 | 111.01 | 111.01 | 12200.0 |
| 2004-03-26 09:00:00 | SPY | ETF | 111.01 | 111.06 | 110.96 | 110.96 | 7800.0 |
| 2004-03-26 09:30:00 | SPY | ETF | 110.955 | 111.37 | 110.83 | 111.16 | 5922800.0 |
| 2004-03-26 10:00:00 | SPY | ETF | 111.17 | 111.37 | 111.0 | 111.19 | 2681200.0 |
| 2004-03-26 10:30:00 | SPY | ETF | 111.19 | 111.21 | 110.92 | 111.15 | 1668500.0 |
| 2004-03-26 11:00:00 | SPY | ETF | 111.12 | 111.4 | 111.06 | 111.31 | 1561300.0 |
| 2004-03-26 11:30:00 | SPY | ETF | 111.3 | 111.69 | 111.28 | 111.56 | 3539900.0 |
| 2004-03-26 12:00:00 | SPY | ETF | 111.56 | 111.64 | 111.41 | 111.46 | 2042000.0 |
| 2004-03-26 12:30:00 | SPY | ETF | 111.46 | 111.55 | 111.35 | 111.48 | 858700.0 |
| 2004-03-26 13:00:00 | SPY | ETF | 111.48 | 111.61 | 111.44 | 111.53 | 511800.0 |
| 2004-03-26 13:30:00 | SPY | ETF | 111.54 | 111.59 | 111.33 | 111.34 | 2225800.0 |
| 2004-03-26 14:00:00 | SPY | ETF | 111.36 | 111.58 | 111.35 | 111.5 | 779000.0 |
| 2004-03-26 14:30:00 | SPY | ETF | 111.52 | 111.68 | 111.48 | 111.58 | 1317600.0 |
| 2004-03-26 15:00:00 | SPY | ETF | 111.59 | 111.79 | 111.49 | 111.5 | 2496500.0 |
| 2004-03-26 15:30:00 | SPY | ETF | 111.51 | 111.57 | 111.08 | 111.17 | 4861700.0 |
| 2004-03-26 16:00:00 | SPY | ETF | 111.18 | 111.2 | 110.86 | 110.9 | 2242100.0 |
| 2004-03-26 16:30:00 | SPY | ETF | 111.63 | 111.63 | 110.9 | 110.98 | 28800.0 |
| 2004-03-26 17:00:00 | SPY | ETF | 110.9 | 111.0 | 110.9 | 111.0 | 2100.0 |
| 2004-03-26 17:30:00 | SPY | ETF | 110.91 | 110.98 | 110.9 | 110.9 | 3100.0 |
| 2004-03-26 18:00:00 | SPY | ETF | 110.96 | 110.98 | 110.96 | 110.98 | 500.0 |
| 2004-03-26 19:00:00 | SPY | ETF | 110.95 | 110.95 | 110.95 | 110.95 | 300.0 |
| 2004-03-26 19:30:00 | SPY | ETF | 110.95 | 110.97 | 110.95 | 110.97 | 300.0 |
| 2004-03-26 08:00:00 | QQQ | ETF | 34.92 | 35.42 | 34.92 | 35.41 | 147600.0 |
| 2004-03-26 08:30:00 | QQQ | ETF | 35.41 | 35.43 | 35.35 | 35.37 | 234000.0 |
| 2004-03-26 09:00:00 | QQQ | ETF | 35.36 | 35.36 | 35.3 | 35.31 | 132800.0 |
| 2004-03-26 09:30:00 | QQQ | ETF | 35.3 | 35.53 | 35.24 | 35.464 | 11507300.0 |
| 2004-03-26 10:00:00 | QQQ | ETF | 35.464 | 35.54 | 35.33 | 35.436 | 8796000.0 |
| 2004-03-26 10:30:00 | QQQ | ETF | 35.44 | 35.45 | 35.25 | 35.37 | 5225900.0 |
| 2004-03-26 11:00:00 | QQQ | ETF | 35.372 | 35.49 | 35.36 | 35.45 | 6018400.0 |
| 2004-03-26 11:30:00 | QQQ | ETF | 35.45 | 35.58 | 35.43 | 35.45 | 6354200.0 |
| 2004-03-26 12:00:00 | QQQ | ETF | 35.45 | 35.5 | 35.4 | 35.42 | 3104900.0 |
| 2004-03-26 12:30:00 | QQQ | ETF | 35.42 | 35.49 | 35.39 | 35.45 | 3008500.0 |
| 2004-03-26 13:00:00 | QQQ | ETF | 35.45 | 35.52 | 35.44 | 35.46 | 2415400.0 |
| 2004-03-26 13:30:00 | QQQ | ETF | 35.46 | 35.47 | 35.36 | 35.387 | 3127900.0 |
| 2004-03-26 14:00:00 | QQQ | ETF | 35.385 | 35.5 | 35.37 | 35.45 | 1950900.0 |
| 2004-03-26 14:30:00 | QQQ | ETF | 35.445 | 35.5 | 35.43 | 35.477 | 3425800.0 |
| 2004-03-26 15:00:00 | QQQ | ETF | 35.47 | 35.583 | 35.46 | 35.461 | 5001100.0 |
| 2004-03-26 15:30:00 | QQQ | ETF | 35.46 | 35.481 | 35.26 | 35.27 | 8032800.0 |
| 2004-03-26 16:00:00 | QQQ | ETF | 35.28 | 35.3 | 35.2 | 35.3 | 2658100.0 |
| 2004-03-26 16:30:00 | QQQ | ETF | 35.27 | 35.35 | 35.25 | 35.28 | 45700.0 |
| 2004-03-26 17:00:00 | QQQ | ETF | 35.29 | 35.37 | 35.28 | 35.32 | 111200.0 |
| 2004-03-26 17:30:00 | QQQ | ETF | 35.32 | 35.35 | 35.32 | 35.35 | 10600.0 |
| 2004-03-26 18:00:00 | QQQ | ETF | 35.35 | 35.37 | 35.3 | 35.3 | 7300.0 |
| 2004-03-26 18:30:00 | QQQ | ETF | 35.31 | 35.31 | 35.31 | 35.31 | 400.0 |
| 2004-03-26 19:00:00 | QQQ | ETF | 35.32 | 35.32 | 35.3 | 35.31 | 600.0 |
| 2004-03-26 19:30:00 | QQQ | ETF | 35.34 | 35.36 | 35.32 | 35.36 | 5000.0 |
| 2004-03-26 08:00:00 | IWM | ETF | 57.04 | 57.075 | 57.025 | 57.025 | 7200.0 |
| 2004-03-26 09:00:00 | IWM | ETF | 56.905 | 56.905 | 56.855 | 56.855 | 600.0 |
| 2004-03-26 09:30:00 | IWM | ETF | 56.83 | 57.225 | 56.795 | 57.14 | 1233800.0 |
> showing 50 of 1,146 rows — these rows as CSV