PREVIEW / etf_30min / 2004-07-14
file: by_date/etf_30min/2004/2004-07-14.parquet size: 35 KB rows: 1,148
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-07-14 08:00:00 | SPY | ETF | 111.35 | 111.35 | 111.22 | 111.3 | 39400.0 |
| 2004-07-14 08:30:00 | SPY | ETF | 111.25 | 111.29 | 111.11 | 111.15 | 45800.0 |
| 2004-07-14 09:00:00 | SPY | ETF | 111.18 | 111.27 | 111.15 | 111.27 | 42500.0 |
| 2004-07-14 09:30:00 | SPY | ETF | 111.26 | 111.62 | 111.2 | 111.54 | 5598200.0 |
| 2004-07-14 10:00:00 | SPY | ETF | 111.53 | 111.94 | 111.46 | 111.83 | 4275400.0 |
| 2004-07-14 10:30:00 | SPY | ETF | 111.84 | 112.22 | 111.78 | 112.17 | 6597400.0 |
| 2004-07-14 11:00:00 | SPY | ETF | 112.17 | 112.19 | 112.07 | 112.19 | 2264400.0 |
| 2004-07-14 11:30:00 | SPY | ETF | 112.18 | 112.39 | 112.16 | 112.19 | 3817600.0 |
| 2004-07-14 12:00:00 | SPY | ETF | 112.18 | 112.34 | 112.16 | 112.23 | 1953200.0 |
| 2004-07-14 12:30:00 | SPY | ETF | 112.23 | 112.23 | 112.01 | 112.07 | 1966600.0 |
| 2004-07-14 13:00:00 | SPY | ETF | 112.07 | 112.12 | 111.67 | 111.78 | 4177300.0 |
| 2004-07-14 13:30:00 | SPY | ETF | 111.78 | 111.94 | 111.71 | 111.84 | 1899900.0 |
| 2004-07-14 14:00:00 | SPY | ETF | 111.83 | 111.91 | 111.73 | 111.78 | 1823700.0 |
| 2004-07-14 14:30:00 | SPY | ETF | 111.8 | 111.83 | 111.34 | 111.51 | 4777100.0 |
| 2004-07-14 15:00:00 | SPY | ETF | 111.52 | 111.62 | 111.19 | 111.2 | 4115600.0 |
| 2004-07-14 15:30:00 | SPY | ETF | 111.19 | 111.6 | 111.12 | 111.5 | 4821700.0 |
| 2004-07-14 16:00:00 | SPY | ETF | 111.5 | 111.65 | 111.47 | 111.54 | 2341100.0 |
| 2004-07-14 16:30:00 | SPY | ETF | 111.54 | 111.79 | 111.43 | 111.71 | 539600.0 |
| 2004-07-14 17:00:00 | SPY | ETF | 111.71 | 111.74 | 111.68 | 111.71 | 156300.0 |
| 2004-07-14 17:30:00 | SPY | ETF | 111.71 | 111.75 | 111.7 | 111.7 | 55300.0 |
| 2004-07-14 18:00:00 | SPY | ETF | 111.7 | 111.71 | 111.61 | 111.69 | 51800.0 |
| 2004-07-14 18:30:00 | SPY | ETF | 111.69 | 111.69 | 111.65 | 111.65 | 3500.0 |
| 2004-07-14 19:00:00 | SPY | ETF | 111.7 | 111.7 | 111.7 | 111.7 | 100.0 |
| 2004-07-14 08:00:00 | QQQ | ETF | 35.26 | 35.31 | 35.18 | 35.2 | 326900.0 |
| 2004-07-14 08:30:00 | QQQ | ETF | 35.2 | 35.22 | 35.13 | 35.13 | 303800.0 |
| 2004-07-14 09:00:00 | QQQ | ETF | 35.14 | 35.21 | 35.11 | 35.2 | 258100.0 |
| 2004-07-14 09:30:00 | QQQ | ETF | 35.2 | 35.27 | 35.1 | 35.24 | 18376300.0 |
| 2004-07-14 10:00:00 | QQQ | ETF | 35.24 | 35.419 | 35.2 | 35.4 | 11930100.0 |
| 2004-07-14 10:30:00 | QQQ | ETF | 35.4 | 35.59 | 35.36 | 35.53 | 11680000.0 |
| 2004-07-14 11:00:00 | QQQ | ETF | 35.535 | 35.56 | 35.44 | 35.55 | 5961700.0 |
| 2004-07-14 11:30:00 | QQQ | ETF | 35.54 | 35.65 | 35.5 | 35.5077 | 5159600.0 |
| 2004-07-14 12:00:00 | QQQ | ETF | 35.506 | 35.58 | 35.49 | 35.51 | 2323500.0 |
| 2004-07-14 12:30:00 | QQQ | ETF | 35.51 | 35.52 | 35.36 | 35.423 | 8832000.0 |
| 2004-07-14 13:00:00 | QQQ | ETF | 35.425 | 35.47 | 35.29 | 35.34 | 6512400.0 |
| 2004-07-14 13:30:00 | QQQ | ETF | 35.34 | 35.43 | 35.293 | 35.38 | 6809300.0 |
| 2004-07-14 14:00:00 | QQQ | ETF | 35.37 | 35.44 | 35.33 | 35.35 | 4148000.0 |
| 2004-07-14 14:30:00 | QQQ | ETF | 35.35 | 35.37 | 35.13 | 35.21 | 9780300.0 |
| 2004-07-14 15:00:00 | QQQ | ETF | 35.219 | 35.29 | 35.14 | 35.14 | 7002700.0 |
| 2004-07-14 15:30:00 | QQQ | ETF | 35.14 | 35.26 | 35.05 | 35.21 | 14125800.0 |
| 2004-07-14 16:00:00 | QQQ | ETF | 35.22 | 35.28 | 35.16 | 35.28 | 1917700.0 |
| 2004-07-14 16:30:00 | QQQ | ETF | 35.27 | 35.36 | 35.18 | 35.34 | 784900.0 |
| 2004-07-14 17:00:00 | QQQ | ETF | 35.34 | 35.38 | 35.32 | 35.33 | 549200.0 |
| 2004-07-14 17:30:00 | QQQ | ETF | 35.33 | 35.35 | 35.31 | 35.34 | 292800.0 |
| 2004-07-14 18:00:00 | QQQ | ETF | 35.33 | 35.34 | 35.32 | 35.34 | 245800.0 |
| 2004-07-14 18:30:00 | QQQ | ETF | 35.34 | 35.34 | 35.34 | 35.34 | 3900.0 |
| 2004-07-14 19:00:00 | QQQ | ETF | 35.33 | 35.33 | 35.33 | 35.33 | 100.0 |
| 2004-07-14 19:30:00 | QQQ | ETF | 35.33 | 35.35 | 35.33 | 35.35 | 13000.0 |
| 2004-07-14 08:30:00 | IWM | ETF | 55.66 | 55.66 | 55.66 | 55.66 | 4000.0 |
| 2004-07-14 09:00:00 | IWM | ETF | 55.63 | 55.665 | 55.62 | 55.665 | 46000.0 |
| 2004-07-14 09:30:00 | IWM | ETF | 55.635 | 55.785 | 55.54 | 55.755 | 874600.0 |
> showing 50 of 1,148 rows — these rows as CSV