PREVIEW / etf_30min / 2004-02-19
file: by_date/etf_30min/2004/2004-02-19.parquet size: 36 KB rows: 1,220
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-02-19 08:00:00 | SPY | ETF | 116.16 | 116.16 | 116.09 | 116.16 | 46400.0 |
| 2004-02-19 08:30:00 | SPY | ETF | 116.15 | 116.28 | 116.07 | 116.24 | 95400.0 |
| 2004-02-19 09:00:00 | SPY | ETF | 116.24 | 116.31 | 116.23 | 116.31 | 54400.0 |
| 2004-02-19 09:30:00 | SPY | ETF | 116.33 | 116.39 | 116.18 | 116.29 | 4516900.0 |
| 2004-02-19 10:00:00 | SPY | ETF | 116.27 | 116.28 | 115.91 | 115.98 | 3737100.0 |
| 2004-02-19 10:30:00 | SPY | ETF | 115.97 | 116.13 | 115.94 | 116.02 | 1828000.0 |
| 2004-02-19 11:00:00 | SPY | ETF | 116.05 | 116.15 | 115.83 | 116.15 | 3387700.0 |
| 2004-02-19 11:30:00 | SPY | ETF | 116.14 | 116.24 | 116.08 | 116.16 | 1686200.0 |
| 2004-02-19 12:00:00 | SPY | ETF | 116.15 | 116.37 | 115.97 | 116.32 | 1381700.0 |
| 2004-02-19 12:30:00 | SPY | ETF | 116.32 | 116.36 | 116.15 | 116.19 | 1323700.0 |
| 2004-02-19 13:00:00 | SPY | ETF | 116.2 | 116.22 | 115.92 | 116.03 | 998800.0 |
| 2004-02-19 13:30:00 | SPY | ETF | 116.03 | 116.28 | 115.91 | 116.23 | 2979900.0 |
| 2004-02-19 14:00:00 | SPY | ETF | 116.23 | 116.28 | 116.05 | 116.11 | 1641300.0 |
| 2004-02-19 14:30:00 | SPY | ETF | 116.13 | 116.22 | 115.92 | 115.98 | 2031800.0 |
| 2004-02-19 15:00:00 | SPY | ETF | 116.0 | 116.02 | 115.58 | 115.6 | 4511400.0 |
| 2004-02-19 15:30:00 | SPY | ETF | 115.6 | 115.69 | 115.13 | 115.22 | 9188500.0 |
| 2004-02-19 16:00:00 | SPY | ETF | 115.22 | 115.668 | 115.06 | 115.21 | 4406300.0 |
| 2004-02-19 16:30:00 | SPY | ETF | 115.22 | 115.25 | 115.19 | 115.2 | 281200.0 |
| 2004-02-19 17:00:00 | SPY | ETF | 115.23 | 115.23 | 115.1 | 115.17 | 3700.0 |
| 2004-02-19 17:30:00 | SPY | ETF | 115.12 | 115.24 | 115.12 | 115.24 | 35800.0 |
| 2004-02-19 18:00:00 | SPY | ETF | 115.17 | 115.17 | 115.12 | 115.16 | 1100.0 |
| 2004-02-19 19:00:00 | SPY | ETF | 115.15 | 115.19 | 115.15 | 115.19 | 1100.0 |
| 2004-02-19 08:00:00 | QQQ | ETF | 37.83 | 37.85 | 37.75 | 37.8 | 68800.0 |
| 2004-02-19 08:30:00 | QQQ | ETF | 37.82 | 37.87 | 37.81 | 37.86 | 84600.0 |
| 2004-02-19 09:00:00 | QQQ | ETF | 37.87 | 37.89 | 37.83 | 37.85 | 174600.0 |
| 2004-02-19 09:30:00 | QQQ | ETF | 37.87 | 37.9 | 37.76 | 37.81 | 9316900.0 |
| 2004-02-19 10:00:00 | QQQ | ETF | 37.802 | 37.802 | 37.61 | 37.67 | 7621800.0 |
| 2004-02-19 10:30:00 | QQQ | ETF | 37.67 | 37.73 | 37.63 | 37.66 | 4795700.0 |
| 2004-02-19 11:00:00 | QQQ | ETF | 37.65 | 37.66 | 37.538 | 37.66 | 5380000.0 |
| 2004-02-19 11:30:00 | QQQ | ETF | 37.66 | 37.72 | 37.61 | 37.63 | 2722300.0 |
| 2004-02-19 12:00:00 | QQQ | ETF | 37.62 | 37.721 | 37.527 | 37.69 | 5470300.0 |
| 2004-02-19 12:30:00 | QQQ | ETF | 37.69 | 37.7 | 37.61 | 37.62 | 1976800.0 |
| 2004-02-19 13:00:00 | QQQ | ETF | 37.63 | 37.64 | 37.43 | 37.48 | 5310300.0 |
| 2004-02-19 13:30:00 | QQQ | ETF | 37.47 | 37.57 | 37.425 | 37.55 | 4236700.0 |
| 2004-02-19 14:00:00 | QQQ | ETF | 37.55 | 37.57 | 37.49 | 37.53 | 2899300.0 |
| 2004-02-19 14:30:00 | QQQ | ETF | 37.527 | 37.56 | 37.31 | 37.32 | 11558900.0 |
| 2004-02-19 15:00:00 | QQQ | ETF | 37.32 | 37.34 | 37.16 | 37.18 | 9172500.0 |
| 2004-02-19 15:30:00 | QQQ | ETF | 37.161 | 37.18 | 36.92 | 36.96 | 16695700.0 |
| 2004-02-19 16:00:00 | QQQ | ETF | 36.95 | 37.0 | 36.84 | 36.98 | 5368800.0 |
| 2004-02-19 16:30:00 | QQQ | ETF | 36.97 | 37.0 | 36.95 | 36.98 | 376000.0 |
| 2004-02-19 17:00:00 | QQQ | ETF | 36.98 | 37.0 | 36.93 | 36.939 | 102000.0 |
| 2004-02-19 17:30:00 | QQQ | ETF | 36.94 | 36.95 | 36.93 | 36.94 | 22500.0 |
| 2004-02-19 18:00:00 | QQQ | ETF | 36.93 | 36.97 | 36.93 | 36.967 | 25600.0 |
| 2004-02-19 18:30:00 | QQQ | ETF | 36.96 | 36.98 | 36.95 | 36.98 | 29900.0 |
| 2004-02-19 19:00:00 | QQQ | ETF | 36.98 | 36.99 | 36.95 | 36.96 | 23200.0 |
| 2004-02-19 19:30:00 | QQQ | ETF | 36.99 | 37.01 | 36.95 | 37.01 | 16100.0 |
| 2004-02-19 08:30:00 | IWM | ETF | 59.285 | 59.285 | 59.285 | 59.285 | 1000.0 |
| 2004-02-19 09:00:00 | IWM | ETF | 59.315 | 59.335 | 59.28 | 59.335 | 13600.0 |
| 2004-02-19 09:30:00 | IWM | ETF | 59.4 | 59.47 | 59.285 | 59.355 | 452800.0 |
| 2004-02-19 10:00:00 | IWM | ETF | 59.31 | 59.34 | 59.04 | 59.08 | 799000.0 |
> showing 50 of 1,220 rows — these rows as CSV