PREVIEW / etf_30min / 2004-01-09
file: by_date/etf_30min/2004/2004-01-09.parquet size: 35 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-01-09 08:00:00 | SPY | ETF | 113.35 | 113.36 | 113.22 | 113.22 | 10900.0 |
| 2004-01-09 08:30:00 | SPY | ETF | 113.22 | 113.22 | 112.73 | 112.86 | 555400.0 |
| 2004-01-09 09:00:00 | SPY | ETF | 112.84 | 112.94 | 112.78 | 112.78 | 94900.0 |
| 2004-01-09 09:30:00 | SPY | ETF | 112.79 | 112.93 | 112.54 | 112.9 | 9626200.0 |
| 2004-01-09 10:00:00 | SPY | ETF | 112.9 | 113.2 | 112.85 | 112.88 | 3792600.0 |
| 2004-01-09 10:30:00 | SPY | ETF | 112.88 | 113.24 | 112.87 | 113.11 | 2885600.0 |
| 2004-01-09 11:00:00 | SPY | ETF | 113.11 | 113.31 | 113.05 | 113.3 | 1903800.0 |
| 2004-01-09 11:30:00 | SPY | ETF | 113.3 | 113.33 | 113.11 | 113.26 | 2032800.0 |
| 2004-01-09 12:00:00 | SPY | ETF | 113.27 | 113.34 | 113.16 | 113.17 | 1139800.0 |
| 2004-01-09 12:30:00 | SPY | ETF | 113.18 | 113.21 | 113.01 | 113.11 | 1953800.0 |
| 2004-01-09 13:00:00 | SPY | ETF | 113.12 | 113.44 | 113.1 | 113.37 | 1486900.0 |
| 2004-01-09 13:30:00 | SPY | ETF | 113.37 | 113.38 | 113.08 | 113.14 | 1114600.0 |
| 2004-01-09 14:00:00 | SPY | ETF | 113.15 | 113.24 | 113.03 | 113.11 | 1137900.0 |
| 2004-01-09 14:30:00 | SPY | ETF | 113.11 | 113.13 | 112.5 | 112.68 | 3937600.0 |
| 2004-01-09 15:00:00 | SPY | ETF | 112.66 | 112.71 | 112.43 | 112.5 | 3486600.0 |
| 2004-01-09 15:30:00 | SPY | ETF | 112.52 | 112.68 | 112.34 | 112.53 | 3262800.0 |
| 2004-01-09 16:00:00 | SPY | ETF | 112.51 | 112.56 | 112.27 | 112.4 | 2213500.0 |
| 2004-01-09 16:30:00 | SPY | ETF | 112.39 | 112.47 | 112.38 | 112.4 | 5574700.0 |
| 2004-01-09 17:00:00 | SPY | ETF | 112.39 | 112.47 | 112.39 | 112.4 | 5485100.0 |
| 2004-01-09 17:30:00 | SPY | ETF | 112.42 | 112.42 | 112.31 | 112.31 | 5200.0 |
| 2004-01-09 18:00:00 | SPY | ETF | 112.35 | 112.35 | 112.31 | 112.31 | 2600.0 |
| 2004-01-09 18:30:00 | SPY | ETF | 112.35 | 112.37 | 112.35 | 112.37 | 200.0 |
| 2004-01-09 19:00:00 | SPY | ETF | 112.38 | 112.39 | 112.38 | 112.39 | 400.0 |
| 2004-01-09 19:30:00 | SPY | ETF | 112.35 | 112.41 | 112.35 | 112.41 | 400.0 |
| 2004-01-09 08:00:00 | QQQ | ETF | 38.02 | 38.02 | 37.94 | 38.0 | 48700.0 |
| 2004-01-09 08:30:00 | QQQ | ETF | 37.96 | 37.97 | 37.65 | 37.69 | 637900.0 |
| 2004-01-09 09:00:00 | QQQ | ETF | 37.7 | 37.74 | 37.68 | 37.71 | 211000.0 |
| 2004-01-09 09:30:00 | QQQ | ETF | 37.71 | 37.81 | 37.59 | 37.79 | 12730900.0 |
| 2004-01-09 10:00:00 | QQQ | ETF | 37.79 | 37.927 | 37.77 | 37.81 | 7581100.0 |
| 2004-01-09 10:30:00 | QQQ | ETF | 37.81 | 38.07 | 37.8 | 38.0 | 8031400.0 |
| 2004-01-09 11:00:00 | QQQ | ETF | 38.03 | 38.12 | 37.97 | 38.1 | 5570800.0 |
| 2004-01-09 11:30:00 | QQQ | ETF | 38.12 | 38.19 | 38.05 | 38.19 | 5140200.0 |
| 2004-01-09 12:00:00 | QQQ | ETF | 38.18 | 38.25 | 38.15 | 38.191 | 5298700.0 |
| 2004-01-09 12:30:00 | QQQ | ETF | 38.2 | 38.2 | 38.1 | 38.16 | 2920800.0 |
| 2004-01-09 13:00:00 | QQQ | ETF | 38.16 | 38.35 | 38.15 | 38.326 | 4326100.0 |
| 2004-01-09 13:30:00 | QQQ | ETF | 38.33 | 38.33 | 38.17 | 38.21 | 3704200.0 |
| 2004-01-09 14:00:00 | QQQ | ETF | 38.2 | 38.25 | 38.14 | 38.21 | 2829000.0 |
| 2004-01-09 14:30:00 | QQQ | ETF | 38.21 | 38.22 | 37.82 | 37.9 | 9340400.0 |
| 2004-01-09 15:00:00 | QQQ | ETF | 37.931 | 37.94 | 37.76 | 37.763 | 8127200.0 |
| 2004-01-09 15:30:00 | QQQ | ETF | 37.763 | 37.89 | 37.71 | 37.818 | 9435400.0 |
| 2004-01-09 16:00:00 | QQQ | ETF | 37.82 | 37.84 | 37.71 | 37.75 | 3134400.0 |
| 2004-01-09 16:30:00 | QQQ | ETF | 37.75 | 37.79 | 37.73 | 37.77 | 101400.0 |
| 2004-01-09 17:00:00 | QQQ | ETF | 37.77 | 37.83 | 37.77 | 37.81 | 36400.0 |
| 2004-01-09 17:30:00 | QQQ | ETF | 37.82 | 37.83 | 37.79 | 37.8 | 7600.0 |
| 2004-01-09 18:00:00 | QQQ | ETF | 37.81 | 37.81 | 37.8 | 37.801 | 20500.0 |
| 2004-01-09 18:30:00 | QQQ | ETF | 37.8 | 37.81 | 37.78 | 37.81 | 1700.0 |
| 2004-01-09 19:00:00 | QQQ | ETF | 37.81 | 37.83 | 37.81 | 37.82 | 600.0 |
| 2004-01-09 19:30:00 | QQQ | ETF | 37.82 | 37.83 | 37.82 | 37.82 | 5500.0 |
| 2004-01-09 08:00:00 | IWM | ETF | 57.68 | 57.68 | 57.68 | 57.68 | 200.0 |
| 2004-01-09 08:30:00 | IWM | ETF | 57.35 | 57.46 | 57.3 | 57.335 | 6200.0 |
> showing 50 of 1,171 rows — these rows as CSV