PREVIEW / etf_30min / 2004-01-02
file: by_date/etf_30min/2004/2004-01-02.parquet size: 34 KB rows: 1,140
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-01-02 08:00:00 | SPY | ETF | 111.85 | 111.87 | 111.8 | 111.82 | 11800.0 |
| 2004-01-02 08:30:00 | SPY | ETF | 111.82 | 111.9 | 111.78 | 111.9 | 25500.0 |
| 2004-01-02 09:00:00 | SPY | ETF | 111.9 | 111.93 | 111.75 | 111.75 | 90500.0 |
| 2004-01-02 09:30:00 | SPY | ETF | 111.73 | 111.98 | 111.61 | 111.76 | 6374700.0 |
| 2004-01-02 10:00:00 | SPY | ETF | 111.76 | 112.19 | 111.7 | 111.96 | 5479900.0 |
| 2004-01-02 10:30:00 | SPY | ETF | 111.96 | 112.19 | 111.9 | 112.11 | 1882300.0 |
| 2004-01-02 11:00:00 | SPY | ETF | 112.12 | 112.18 | 111.87 | 111.9 | 1366400.0 |
| 2004-01-02 11:30:00 | SPY | ETF | 111.89 | 112.11 | 111.88 | 111.9 | 1203600.0 |
| 2004-01-02 12:00:00 | SPY | ETF | 111.9 | 111.99 | 111.6 | 111.72 | 2864800.0 |
| 2004-01-02 12:30:00 | SPY | ETF | 111.71 | 111.81 | 111.66 | 111.77 | 817600.0 |
| 2004-01-02 13:00:00 | SPY | ETF | 111.75 | 111.79 | 111.6 | 111.72 | 925100.0 |
| 2004-01-02 13:30:00 | SPY | ETF | 111.72 | 111.77 | 111.59 | 111.7 | 1153200.0 |
| 2004-01-02 14:00:00 | SPY | ETF | 111.7 | 111.72 | 111.32 | 111.37 | 1512400.0 |
| 2004-01-02 14:30:00 | SPY | ETF | 111.37 | 111.45 | 110.88 | 110.93 | 3214000.0 |
| 2004-01-02 15:00:00 | SPY | ETF | 110.93 | 111.03 | 110.73 | 110.89 | 2360400.0 |
| 2004-01-02 15:30:00 | SPY | ETF | 110.89 | 111.14 | 110.85 | 111.0 | 3424400.0 |
| 2004-01-02 16:00:00 | SPY | ETF | 111.0 | 111.3 | 110.98 | 111.23 | 3509600.0 |
| 2004-01-02 16:30:00 | SPY | ETF | 111.3 | 111.39 | 111.03 | 111.36 | 373600.0 |
| 2004-01-02 17:00:00 | SPY | ETF | 111.3 | 111.34 | 111.25 | 111.25 | 11900.0 |
| 2004-01-02 17:30:00 | SPY | ETF | 111.25 | 111.34 | 111.23 | 111.34 | 1900.0 |
| 2004-01-02 18:30:00 | SPY | ETF | 111.25 | 111.35 | 111.25 | 111.35 | 9200.0 |
| 2004-01-02 08:00:00 | QQQ | ETF | 36.6 | 36.71 | 36.6 | 36.68 | 63800.0 |
| 2004-01-02 08:30:00 | QQQ | ETF | 36.7 | 36.7 | 36.67 | 36.7 | 38600.0 |
| 2004-01-02 09:00:00 | QQQ | ETF | 36.71 | 36.72 | 36.65 | 36.65 | 52600.0 |
| 2004-01-02 09:30:00 | QQQ | ETF | 36.66 | 36.77 | 36.62 | 36.66 | 8850900.0 |
| 2004-01-02 10:00:00 | QQQ | ETF | 36.66 | 36.79 | 36.62 | 36.64 | 8259900.0 |
| 2004-01-02 10:30:00 | QQQ | ETF | 36.65 | 36.77 | 36.62 | 36.733 | 2751800.0 |
| 2004-01-02 11:00:00 | QQQ | ETF | 36.73 | 36.79 | 36.664 | 36.69 | 2401200.0 |
| 2004-01-02 11:30:00 | QQQ | ETF | 36.7 | 36.777 | 36.66 | 36.7 | 2420000.0 |
| 2004-01-02 12:00:00 | QQQ | ETF | 36.702 | 36.737 | 36.6 | 36.64 | 2415900.0 |
| 2004-01-02 12:30:00 | QQQ | ETF | 36.65 | 36.71 | 36.6 | 36.69 | 2589800.0 |
| 2004-01-02 13:00:00 | QQQ | ETF | 36.68 | 36.73 | 36.62 | 36.68 | 1803300.0 |
| 2004-01-02 13:30:00 | QQQ | ETF | 36.67 | 36.7 | 36.64 | 36.68 | 1624100.0 |
| 2004-01-02 14:00:00 | QQQ | ETF | 36.68 | 36.69 | 36.54 | 36.57 | 2329900.0 |
| 2004-01-02 14:30:00 | QQQ | ETF | 36.56 | 36.57 | 36.31 | 36.35 | 5997200.0 |
| 2004-01-02 15:00:00 | QQQ | ETF | 36.35 | 36.39 | 36.22 | 36.32 | 5340800.0 |
| 2004-01-02 15:30:00 | QQQ | ETF | 36.314 | 36.42 | 36.31 | 36.33 | 4062800.0 |
| 2004-01-02 16:00:00 | QQQ | ETF | 36.338 | 36.41 | 36.33 | 36.36 | 1823600.0 |
| 2004-01-02 16:30:00 | QQQ | ETF | 36.369 | 36.39 | 36.36 | 36.38 | 38000.0 |
| 2004-01-02 17:00:00 | QQQ | ETF | 36.34 | 36.399 | 36.34 | 36.38 | 19500.0 |
| 2004-01-02 17:30:00 | QQQ | ETF | 36.39 | 36.41 | 36.37 | 36.4 | 29700.0 |
| 2004-01-02 18:00:00 | QQQ | ETF | 36.4 | 36.41 | 36.39 | 36.39 | 21200.0 |
| 2004-01-02 18:30:00 | QQQ | ETF | 36.39 | 36.39 | 36.34 | 36.34 | 10300.0 |
| 2004-01-02 19:00:00 | QQQ | ETF | 36.41 | 36.41 | 36.4 | 36.4 | 2300.0 |
| 2004-01-02 19:30:00 | QQQ | ETF | 36.4 | 36.4 | 36.34 | 36.34 | 900.0 |
| 2004-01-02 08:00:00 | IWM | ETF | 55.8 | 55.8 | 55.8 | 55.8 | 1200.0 |
| 2004-01-02 08:30:00 | IWM | ETF | 55.8 | 55.8 | 55.79 | 55.79 | 2400.0 |
| 2004-01-02 09:00:00 | IWM | ETF | 55.825 | 55.825 | 55.825 | 55.825 | 1200.0 |
| 2004-01-02 09:30:00 | IWM | ETF | 55.5835 | 56.055 | 55.5835 | 55.995 | 1362400.0 |
| 2004-01-02 10:00:00 | IWM | ETF | 55.999 | 56.3145 | 55.975 | 56.12 | 1087800.0 |
> showing 50 of 1,140 rows — these rows as CSV