PREVIEW / etf_30min / 2005-02-04
file: by_date/etf_30min/2005/2005-02-04.parquet size: 43 KB rows: 1,449
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 |
|---|---|---|---|---|---|---|---|
| 2005-02-04 08:00:00 | SPY | ETF | 119.23 | 119.23 | 119.19 | 119.21 | 81700.0 |
| 2005-02-04 08:30:00 | SPY | ETF | 119.19 | 119.2 | 118.8 | 119.05 | 834000.0 |
| 2005-02-04 09:00:00 | SPY | ETF | 119.04 | 119.04 | 118.93 | 119.02 | 187200.0 |
| 2005-02-04 09:30:00 | SPY | ETF | 119.0 | 119.49 | 118.98 | 119.38 | 8264400.0 |
| 2005-02-04 10:00:00 | SPY | ETF | 119.37 | 119.62 | 119.37 | 119.62 | 5914700.0 |
| 2005-02-04 10:30:00 | SPY | ETF | 119.6 | 119.63 | 119.4 | 119.57 | 2782200.0 |
| 2005-02-04 11:00:00 | SPY | ETF | 119.56 | 119.77 | 119.55 | 119.56 | 2996200.0 |
| 2005-02-04 11:30:00 | SPY | ETF | 119.56 | 119.63 | 119.4 | 119.48 | 2329900.0 |
| 2005-02-04 12:00:00 | SPY | ETF | 119.47 | 119.7 | 119.46 | 119.65 | 1436500.0 |
| 2005-02-04 12:30:00 | SPY | ETF | 119.65 | 119.74 | 119.61 | 119.72 | 1791700.0 |
| 2005-02-04 13:00:00 | SPY | ETF | 119.72 | 119.73 | 119.58 | 119.6604 | 782700.0 |
| 2005-02-04 13:30:00 | SPY | ETF | 119.68 | 119.9 | 119.6 | 119.78 | 3909600.0 |
| 2005-02-04 14:00:00 | SPY | ETF | 119.78 | 119.92 | 119.77 | 119.82 | 1976000.0 |
| 2005-02-04 14:30:00 | SPY | ETF | 119.82 | 119.9 | 119.71 | 119.81 | 2163700.0 |
| 2005-02-04 15:00:00 | SPY | ETF | 119.79 | 120.08 | 119.78 | 120.07 | 2716200.0 |
| 2005-02-04 15:30:00 | SPY | ETF | 120.05 | 120.43 | 120.05 | 120.31 | 7666700.0 |
| 2005-02-04 16:00:00 | SPY | ETF | 120.3 | 120.375 | 120.17 | 120.19 | 2635800.0 |
| 2005-02-04 16:30:00 | SPY | ETF | 120.21 | 120.23 | 120.16 | 120.21 | 40400.0 |
| 2005-02-04 17:00:00 | SPY | ETF | 120.22 | 120.23 | 120.22 | 120.23 | 400.0 |
| 2005-02-04 18:00:00 | SPY | ETF | 120.22 | 120.22 | 120.21 | 120.21 | 2000.0 |
| 2005-02-04 18:30:00 | SPY | ETF | 120.21 | 120.21 | 120.2 | 120.2 | 2600.0 |
| 2005-02-04 19:00:00 | SPY | ETF | 120.21 | 120.23 | 120.2 | 120.23 | 7400.0 |
| 2005-02-04 19:30:00 | SPY | ETF | 120.23 | 120.23 | 120.23 | 120.23 | 100.0 |
| 2005-02-04 09:30:00 | QQQ | ETF | 37.15 | 37.44 | 37.15 | 37.39 | 12783400.0 |
| 2005-02-04 10:00:00 | QQQ | ETF | 37.39 | 37.6 | 37.37 | 37.57 | 15257300.0 |
| 2005-02-04 10:30:00 | QQQ | ETF | 37.57 | 37.6 | 37.52 | 37.53 | 7173300.0 |
| 2005-02-04 11:00:00 | QQQ | ETF | 37.53 | 37.6 | 37.47 | 37.48 | 5011100.0 |
| 2005-02-04 11:30:00 | QQQ | ETF | 37.48 | 37.5 | 37.41 | 37.41 | 4493600.0 |
| 2005-02-04 12:00:00 | QQQ | ETF | 37.42 | 37.54 | 37.42 | 37.53 | 3811300.0 |
| 2005-02-04 12:30:00 | QQQ | ETF | 37.53 | 37.58 | 37.5 | 37.57 | 2654700.0 |
| 2005-02-04 13:00:00 | QQQ | ETF | 37.57 | 37.57 | 37.47 | 37.53 | 2607100.0 |
| 2005-02-04 13:30:00 | QQQ | ETF | 37.53 | 37.68 | 37.51 | 37.62 | 6789900.0 |
| 2005-02-04 14:00:00 | QQQ | ETF | 37.62 | 37.66 | 37.56 | 37.57 | 4277700.0 |
| 2005-02-04 14:30:00 | QQQ | ETF | 37.58 | 37.61 | 37.52 | 37.58 | 3960700.0 |
| 2005-02-04 15:00:00 | QQQ | ETF | 37.58 | 37.71 | 37.58 | 37.71 | 7687500.0 |
| 2005-02-04 15:30:00 | QQQ | ETF | 37.71 | 38.79 | 37.7 | 37.8 | 12525300.0 |
| 2005-02-04 08:00:00 | IWM | ETF | 62.645 | 62.645 | 62.645 | 62.645 | 2000.0 |
| 2005-02-04 08:30:00 | IWM | ETF | 62.6 | 62.605 | 62.5 | 62.56 | 16600.0 |
| 2005-02-04 09:00:00 | IWM | ETF | 62.51 | 62.575 | 62.47 | 62.55 | 10800.0 |
| 2005-02-04 09:30:00 | IWM | ETF | 62.605 | 63.045 | 62.53 | 63.005 | 1930400.0 |
| 2005-02-04 10:00:00 | IWM | ETF | 63.02 | 63.2 | 63.02 | 63.15 | 1956800.0 |
| 2005-02-04 10:30:00 | IWM | ETF | 63.135 | 63.2 | 62.99 | 63.1 | 1090800.0 |
| 2005-02-04 11:00:00 | IWM | ETF | 63.1 | 63.16 | 62.935 | 62.96 | 930600.0 |
| 2005-02-04 11:30:00 | IWM | ETF | 62.965 | 63.055 | 62.95 | 62.99 | 588600.0 |
| 2005-02-04 12:00:00 | IWM | ETF | 62.985 | 63.1 | 62.985 | 63.07 | 708800.0 |
| 2005-02-04 12:30:00 | IWM | ETF | 63.065 | 63.125 | 63.0 | 63.1 | 889600.0 |
| 2005-02-04 13:00:00 | IWM | ETF | 63.0955 | 63.15 | 63.05 | 63.115 | 537600.0 |
| 2005-02-04 13:30:00 | IWM | ETF | 63.115 | 63.325 | 63.11 | 63.225 | 1092200.0 |
| 2005-02-04 14:00:00 | IWM | ETF | 63.245 | 63.34 | 63.075 | 63.295 | 1137600.0 |
| 2005-02-04 14:30:00 | IWM | ETF | 63.295 | 63.335 | 63.235 | 63.265 | 762200.0 |
> showing 50 of 1,449 rows — these rows as CSV