PREVIEW / etf_30min / 2004-10-01
file: by_date/etf_30min/2004/2004-10-01.parquet size: 36 KB rows: 1,215
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-10-01 08:00:00 | SPY | ETF | 112.23 | 112.36 | 112.2 | 112.3 | 61400.0 |
| 2004-10-01 08:30:00 | SPY | ETF | 112.3 | 112.37 | 112.2 | 112.27 | 79500.0 |
| 2004-10-01 09:00:00 | SPY | ETF | 112.28 | 112.28 | 112.2 | 112.26 | 44600.0 |
| 2004-10-01 09:30:00 | SPY | ETF | 112.26 | 112.65 | 112.21 | 112.64 | 11482000.0 |
| 2004-10-01 10:00:00 | SPY | ETF | 112.64 | 113.22 | 112.55 | 113.04 | 9249800.0 |
| 2004-10-01 10:30:00 | SPY | ETF | 113.04 | 113.25 | 113.02 | 113.25 | 5082100.0 |
| 2004-10-01 11:00:00 | SPY | ETF | 113.25 | 113.34 | 113.17 | 113.25 | 5175000.0 |
| 2004-10-01 11:30:00 | SPY | ETF | 113.23 | 113.45 | 113.23 | 113.26 | 2907300.0 |
| 2004-10-01 12:00:00 | SPY | ETF | 113.28 | 113.39 | 113.23 | 113.34 | 1575900.0 |
| 2004-10-01 12:30:00 | SPY | ETF | 113.34 | 113.45 | 113.33 | 113.37 | 1083900.0 |
| 2004-10-01 13:00:00 | SPY | ETF | 113.37 | 113.4 | 113.2 | 113.32 | 1286000.0 |
| 2004-10-01 13:30:00 | SPY | ETF | 113.32 | 113.32 | 113.15 | 113.18 | 2212300.0 |
| 2004-10-01 14:00:00 | SPY | ETF | 113.18 | 113.3 | 113.1 | 113.28 | 1891100.0 |
| 2004-10-01 14:30:00 | SPY | ETF | 113.29 | 113.5 | 113.25 | 113.44 | 2746100.0 |
| 2004-10-01 15:00:00 | SPY | ETF | 113.42 | 113.48 | 113.28 | 113.35 | 1950700.0 |
| 2004-10-01 15:30:00 | SPY | ETF | 113.33 | 113.52 | 113.21 | 113.48 | 4738100.0 |
| 2004-10-01 16:00:00 | SPY | ETF | 113.49 | 113.65 | 113.44 | 113.61 | 2275900.0 |
| 2004-10-01 16:30:00 | SPY | ETF | 113.61 | 113.73 | 113.53 | 113.73 | 288500.0 |
| 2004-10-01 17:00:00 | SPY | ETF | 113.73 | 113.89 | 113.6 | 113.6 | 15400.0 |
| 2004-10-01 17:30:00 | SPY | ETF | 113.66 | 113.66 | 113.57 | 113.59 | 9800.0 |
| 2004-10-01 18:00:00 | SPY | ETF | 113.59 | 113.59 | 113.57 | 113.58 | 300.0 |
| 2004-10-01 08:00:00 | QQQ | ETF | 35.35 | 35.47 | 35.35 | 35.46 | 756400.0 |
| 2004-10-01 08:30:00 | QQQ | ETF | 35.48 | 35.54 | 35.44 | 35.48 | 211800.0 |
| 2004-10-01 09:00:00 | QQQ | ETF | 35.49 | 35.49 | 35.43 | 35.44 | 184200.0 |
| 2004-10-01 09:30:00 | QQQ | ETF | 35.45 | 35.56 | 35.36 | 35.54 | 15276900.0 |
| 2004-10-01 10:00:00 | QQQ | ETF | 35.53 | 35.88 | 35.53 | 35.77 | 17256300.0 |
| 2004-10-01 10:30:00 | QQQ | ETF | 35.768 | 35.91 | 35.74 | 35.89 | 11256500.0 |
| 2004-10-01 11:00:00 | QQQ | ETF | 35.89 | 36.0 | 35.89 | 35.97 | 11568000.0 |
| 2004-10-01 11:30:00 | QQQ | ETF | 35.97 | 36.1 | 35.95 | 36.028 | 8805200.0 |
| 2004-10-01 12:00:00 | QQQ | ETF | 36.028 | 36.07 | 35.99 | 36.03 | 4682300.0 |
| 2004-10-01 12:30:00 | QQQ | ETF | 36.029 | 36.09 | 36.01 | 36.04 | 3713100.0 |
| 2004-10-01 13:00:00 | QQQ | ETF | 36.03 | 36.056 | 35.96 | 36.03 | 3036300.0 |
| 2004-10-01 13:30:00 | QQQ | ETF | 36.032 | 36.04 | 35.95 | 35.97 | 4147700.0 |
| 2004-10-01 14:00:00 | QQQ | ETF | 35.97 | 36.05 | 35.93 | 36.05 | 6033200.0 |
| 2004-10-01 14:30:00 | QQQ | ETF | 36.04 | 36.14 | 36.0 | 36.1 | 7363400.0 |
| 2004-10-01 15:00:00 | QQQ | ETF | 36.1 | 36.14 | 36.03 | 36.062 | 5558400.0 |
| 2004-10-01 15:30:00 | QQQ | ETF | 36.06 | 36.15 | 36.0 | 36.11 | 11636700.0 |
| 2004-10-01 16:00:00 | QQQ | ETF | 36.11 | 36.15 | 36.07 | 36.12 | 3272800.0 |
| 2004-10-01 16:30:00 | QQQ | ETF | 36.12 | 36.14 | 36.101 | 36.14 | 71300.0 |
| 2004-10-01 17:00:00 | QQQ | ETF | 36.13 | 36.17 | 36.11 | 36.14 | 59700.0 |
| 2004-10-01 17:30:00 | QQQ | ETF | 36.15 | 36.16 | 36.14 | 36.15 | 32600.0 |
| 2004-10-01 18:00:00 | QQQ | ETF | 36.14 | 36.16 | 36.13 | 36.14 | 12300.0 |
| 2004-10-01 18:30:00 | QQQ | ETF | 36.17 | 36.17 | 36.17 | 36.17 | 600.0 |
| 2004-10-01 19:00:00 | QQQ | ETF | 36.16 | 36.17 | 36.16 | 36.17 | 2200.0 |
| 2004-10-01 19:30:00 | QQQ | ETF | 36.17 | 36.17 | 36.16 | 36.17 | 6300.0 |
| 2004-10-01 08:00:00 | IWM | ETF | 57.32 | 57.32 | 57.32 | 57.32 | 7000.0 |
| 2004-10-01 09:00:00 | IWM | ETF | 57.35 | 57.35 | 57.33 | 57.33 | 25600.0 |
| 2004-10-01 09:30:00 | IWM | ETF | 57.285 | 57.45 | 57.215 | 57.45 | 1795400.0 |
| 2004-10-01 10:00:00 | IWM | ETF | 57.44 | 57.82 | 57.44 | 57.68 | 2364400.0 |
| 2004-10-01 10:30:00 | IWM | ETF | 57.705 | 57.97 | 57.645 | 57.97 | 1494400.0 |
> showing 50 of 1,215 rows — these rows as CSV