PREVIEW / etf_30min / 2004-07-15
file: by_date/etf_30min/2004/2004-07-15.parquet size: 35 KB rows: 1,158
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-15 08:00:00 | SPY | ETF | 111.57 | 111.62 | 111.49 | 111.62 | 8800.0 |
| 2004-07-15 08:30:00 | SPY | ETF | 111.67 | 111.85 | 111.57 | 111.7 | 266600.0 |
| 2004-07-15 09:00:00 | SPY | ETF | 111.73 | 111.82 | 111.73 | 111.78 | 40800.0 |
| 2004-07-15 09:30:00 | SPY | ETF | 111.74 | 111.83 | 111.56 | 111.62 | 3290800.0 |
| 2004-07-15 10:00:00 | SPY | ETF | 111.64 | 111.68 | 111.27 | 111.45 | 2950400.0 |
| 2004-07-15 10:30:00 | SPY | ETF | 111.46 | 111.6 | 111.31 | 111.32 | 2056200.0 |
| 2004-07-15 11:00:00 | SPY | ETF | 111.32 | 111.48 | 111.25 | 111.33 | 1742800.0 |
| 2004-07-15 11:30:00 | SPY | ETF | 111.33 | 111.43 | 111.13 | 111.34 | 2935000.0 |
| 2004-07-15 12:00:00 | SPY | ETF | 111.34 | 111.62 | 111.29 | 111.5 | 2860500.0 |
| 2004-07-15 12:30:00 | SPY | ETF | 111.53 | 111.87 | 111.45 | 111.79 | 3176400.0 |
| 2004-07-15 13:00:00 | SPY | ETF | 111.8 | 111.91 | 111.58 | 111.64 | 1662000.0 |
| 2004-07-15 13:30:00 | SPY | ETF | 111.64 | 111.68 | 111.41 | 111.57 | 1866700.0 |
| 2004-07-15 14:00:00 | SPY | ETF | 111.55 | 111.6 | 111.36 | 111.49 | 1472400.0 |
| 2004-07-15 14:30:00 | SPY | ETF | 111.51 | 111.63 | 111.41 | 111.43 | 1710500.0 |
| 2004-07-15 15:00:00 | SPY | ETF | 111.42 | 111.5 | 111.3 | 111.31 | 1632600.0 |
| 2004-07-15 15:30:00 | SPY | ETF | 111.34 | 111.39 | 111.01 | 111.04 | 4791300.0 |
| 2004-07-15 16:00:00 | SPY | ETF | 111.03 | 111.18 | 110.7 | 110.93 | 4022600.0 |
| 2004-07-15 16:30:00 | SPY | ETF | 110.9 | 110.9 | 110.8 | 110.82 | 325900.0 |
| 2004-07-15 17:00:00 | SPY | ETF | 110.82 | 110.84 | 110.68 | 110.72 | 117600.0 |
| 2004-07-15 17:30:00 | SPY | ETF | 110.72 | 110.74 | 110.67 | 110.7 | 16600.0 |
| 2004-07-15 18:00:00 | SPY | ETF | 110.7 | 110.8 | 110.7 | 110.71 | 13100.0 |
| 2004-07-15 18:30:00 | SPY | ETF | 110.79 | 110.79 | 110.79 | 110.79 | 700.0 |
| 2004-07-15 19:00:00 | SPY | ETF | 110.79 | 110.86 | 110.79 | 110.85 | 1700.0 |
| 2004-07-15 19:30:00 | SPY | ETF | 110.87 | 110.88 | 110.87 | 110.88 | 3200.0 |
| 2004-07-15 08:00:00 | QQQ | ETF | 35.26 | 35.26 | 35.17 | 35.2 | 54800.0 |
| 2004-07-15 08:30:00 | QQQ | ETF | 35.27 | 35.35 | 35.23 | 35.32 | 182200.0 |
| 2004-07-15 09:00:00 | QQQ | ETF | 35.31 | 35.34 | 35.31 | 35.32 | 162400.0 |
| 2004-07-15 09:30:00 | QQQ | ETF | 35.32 | 35.443 | 35.26 | 35.27 | 9139200.0 |
| 2004-07-15 10:00:00 | QQQ | ETF | 35.279 | 35.31 | 35.1 | 35.258 | 9465900.0 |
| 2004-07-15 10:30:00 | QQQ | ETF | 35.26 | 35.33 | 35.2 | 35.213 | 7606100.0 |
| 2004-07-15 11:00:00 | QQQ | ETF | 35.21 | 35.31 | 35.17 | 35.218 | 5448000.0 |
| 2004-07-15 11:30:00 | QQQ | ETF | 35.21 | 35.34 | 35.16 | 35.293 | 5542800.0 |
| 2004-07-15 12:00:00 | QQQ | ETF | 35.293 | 35.43 | 35.28 | 35.379 | 6792400.0 |
| 2004-07-15 12:30:00 | QQQ | ETF | 35.373 | 35.49 | 35.35 | 35.447 | 5669100.0 |
| 2004-07-15 13:00:00 | QQQ | ETF | 35.46 | 35.48 | 35.36 | 35.37 | 3976300.0 |
| 2004-07-15 13:30:00 | QQQ | ETF | 35.368 | 35.39 | 35.26 | 35.362 | 4951400.0 |
| 2004-07-15 14:00:00 | QQQ | ETF | 35.37 | 35.39 | 35.28 | 35.37 | 3745600.0 |
| 2004-07-15 14:30:00 | QQQ | ETF | 35.37 | 35.41 | 35.319 | 35.32 | 3525800.0 |
| 2004-07-15 15:00:00 | QQQ | ETF | 35.33 | 35.36 | 35.27 | 35.28 | 4432900.0 |
| 2004-07-15 15:30:00 | QQQ | ETF | 35.284 | 35.33 | 35.18 | 35.19 | 9725200.0 |
| 2004-07-15 16:00:00 | QQQ | ETF | 35.19 | 35.3227 | 35.06 | 35.17 | 4966200.0 |
| 2004-07-15 16:30:00 | QQQ | ETF | 35.16 | 35.2 | 35.08 | 35.09 | 1113700.0 |
| 2004-07-15 17:00:00 | QQQ | ETF | 35.09 | 35.09 | 35.01 | 35.03 | 139600.0 |
| 2004-07-15 17:30:00 | QQQ | ETF | 35.02 | 35.1 | 35.01 | 35.07 | 205600.0 |
| 2004-07-15 18:00:00 | QQQ | ETF | 35.06 | 35.085 | 35.031 | 35.06 | 120300.0 |
| 2004-07-15 18:30:00 | QQQ | ETF | 35.07 | 35.1 | 35.07 | 35.1 | 6600.0 |
| 2004-07-15 19:00:00 | QQQ | ETF | 35.08 | 35.08 | 35.08 | 35.08 | 1900.0 |
| 2004-07-15 19:30:00 | QQQ | ETF | 35.08 | 35.13 | 35.08 | 35.13 | 2800.0 |
| 2004-07-15 08:30:00 | IWM | ETF | 55.915 | 55.915 | 55.915 | 55.915 | 2000.0 |
| 2004-07-15 09:00:00 | IWM | ETF | 55.9 | 55.955 | 55.895 | 55.955 | 7200.0 |
> showing 50 of 1,158 rows — these rows as CSV