PREVIEW / etf_30min / 2004-04-07
file: by_date/etf_30min/2004/2004-04-07.parquet size: 34 KB rows: 1,160
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-04-07 08:00:00 | SPY | ETF | 114.96 | 114.96 | 114.92 | 114.93 | 900.0 |
| 2004-04-07 08:30:00 | SPY | ETF | 114.96 | 114.99 | 114.89 | 114.89 | 6600.0 |
| 2004-04-07 09:00:00 | SPY | ETF | 114.86 | 114.9 | 114.81 | 114.9 | 14200.0 |
| 2004-04-07 09:30:00 | SPY | ETF | 114.94 | 114.98 | 114.6 | 114.7 | 3636200.0 |
| 2004-04-07 10:00:00 | SPY | ETF | 114.72 | 114.74 | 114.45 | 114.56 | 3202700.0 |
| 2004-04-07 10:30:00 | SPY | ETF | 114.55 | 114.64 | 114.11 | 114.19 | 5564800.0 |
| 2004-04-07 11:00:00 | SPY | ETF | 114.19 | 114.41 | 114.16 | 114.3 | 3832800.0 |
| 2004-04-07 11:30:00 | SPY | ETF | 114.3 | 114.35 | 114.22 | 114.29 | 1593900.0 |
| 2004-04-07 12:00:00 | SPY | ETF | 114.27 | 114.39 | 114.18 | 114.31 | 1751000.0 |
| 2004-04-07 12:30:00 | SPY | ETF | 114.29 | 114.42 | 114.21 | 114.22 | 1099800.0 |
| 2004-04-07 13:00:00 | SPY | ETF | 114.22 | 114.39 | 114.22 | 114.37 | 761200.0 |
| 2004-04-07 13:30:00 | SPY | ETF | 114.37 | 114.45 | 114.26 | 114.3 | 1104300.0 |
| 2004-04-07 14:00:00 | SPY | ETF | 114.3 | 114.39 | 114.13 | 114.37 | 2297100.0 |
| 2004-04-07 14:30:00 | SPY | ETF | 114.38 | 114.63 | 114.16 | 114.57 | 2582800.0 |
| 2004-04-07 15:00:00 | SPY | ETF | 114.57 | 114.93 | 114.57 | 114.73 | 7095600.0 |
| 2004-04-07 15:30:00 | SPY | ETF | 114.73 | 114.74 | 114.31 | 114.5 | 4292400.0 |
| 2004-04-07 16:00:00 | SPY | ETF | 114.48 | 114.67 | 114.38 | 114.63 | 1897100.0 |
| 2004-04-07 16:30:00 | SPY | ETF | 114.63 | 115.0 | 114.61 | 114.91 | 741200.0 |
| 2004-04-07 17:00:00 | SPY | ETF | 114.94 | 115.39 | 114.92 | 115.18 | 362000.0 |
| 2004-04-07 17:30:00 | SPY | ETF | 115.19 | 115.22 | 115.18 | 115.18 | 7400.0 |
| 2004-04-07 18:00:00 | SPY | ETF | 115.2 | 115.2 | 115.2 | 115.2 | 1000.0 |
| 2004-04-07 18:30:00 | SPY | ETF | 115.15 | 115.19 | 115.15 | 115.19 | 1400.0 |
| 2004-04-07 19:00:00 | SPY | ETF | 115.12 | 115.12 | 115.1 | 115.1 | 600.0 |
| 2004-04-07 19:30:00 | SPY | ETF | 115.14 | 115.14 | 115.1 | 115.12 | 900.0 |
| 2004-04-07 08:00:00 | QQQ | ETF | 37.02 | 37.02 | 36.99 | 37.0 | 94300.0 |
| 2004-04-07 08:30:00 | QQQ | ETF | 37.02 | 37.05 | 36.99 | 37.0 | 183100.0 |
| 2004-04-07 09:00:00 | QQQ | ETF | 37.0 | 37.01 | 36.97 | 36.99 | 241300.0 |
| 2004-04-07 09:30:00 | QQQ | ETF | 36.994 | 37.02 | 36.87 | 36.925 | 9723100.0 |
| 2004-04-07 10:00:00 | QQQ | ETF | 36.926 | 36.93 | 36.81 | 36.87 | 7050900.0 |
| 2004-04-07 10:30:00 | QQQ | ETF | 36.87 | 36.92 | 36.68 | 36.729 | 9172300.0 |
| 2004-04-07 11:00:00 | QQQ | ETF | 36.729 | 36.8 | 36.68 | 36.76 | 5462500.0 |
| 2004-04-07 11:30:00 | QQQ | ETF | 36.759 | 36.77 | 36.693 | 36.75 | 2976400.0 |
| 2004-04-07 12:00:00 | QQQ | ETF | 36.744 | 36.78 | 36.66 | 36.75 | 4667300.0 |
| 2004-04-07 12:30:00 | QQQ | ETF | 36.75 | 36.79 | 36.704 | 36.71 | 2428300.0 |
| 2004-04-07 13:00:00 | QQQ | ETF | 36.71 | 36.81 | 36.7 | 36.79 | 3388000.0 |
| 2004-04-07 13:30:00 | QQQ | ETF | 36.79 | 36.82 | 36.739 | 36.759 | 3818100.0 |
| 2004-04-07 14:00:00 | QQQ | ETF | 36.76 | 36.89 | 36.7 | 36.856 | 5466600.0 |
| 2004-04-07 14:30:00 | QQQ | ETF | 36.86 | 36.98 | 36.77 | 36.944 | 6811600.0 |
| 2004-04-07 15:00:00 | QQQ | ETF | 36.94 | 37.11 | 36.94 | 37.02 | 11209900.0 |
| 2004-04-07 15:30:00 | QQQ | ETF | 37.02 | 37.03 | 36.76 | 36.877 | 10191100.0 |
| 2004-04-07 16:00:00 | QQQ | ETF | 36.87 | 36.99 | 36.83 | 36.93 | 1532600.0 |
| 2004-04-07 16:30:00 | QQQ | ETF | 36.94 | 37.18 | 36.94 | 37.14 | 3016300.0 |
| 2004-04-07 17:00:00 | QQQ | ETF | 37.14 | 37.29 | 37.14 | 37.29 | 1775700.0 |
| 2004-04-07 17:30:00 | QQQ | ETF | 37.28 | 37.31 | 37.27 | 37.27 | 129000.0 |
| 2004-04-07 18:00:00 | QQQ | ETF | 37.27 | 37.29 | 37.26 | 37.27 | 25700.0 |
| 2004-04-07 18:30:00 | QQQ | ETF | 37.28 | 37.3 | 37.27 | 37.3 | 15100.0 |
| 2004-04-07 19:00:00 | QQQ | ETF | 37.27 | 37.27 | 37.25 | 37.25 | 16400.0 |
| 2004-04-07 19:30:00 | QQQ | ETF | 37.26 | 37.27 | 37.25 | 37.25 | 11900.0 |
| 2004-04-07 08:00:00 | IWM | ETF | 59.625 | 59.625 | 59.625 | 59.625 | 16000.0 |
| 2004-04-07 08:30:00 | IWM | ETF | 59.625 | 59.625 | 59.625 | 59.625 | 200.0 |
> showing 50 of 1,160 rows — these rows as CSV