PREVIEW / etf_30min / 2005-03-02
file: by_date/etf_30min/2005/2005-03-02.parquet size: 43 KB rows: 1,449
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 |
|---|---|---|---|---|---|---|---|
| 2005-03-02 08:00:00 | SPY | ETF | 120.92 | 120.99 | 120.92 | 120.99 | 6100.0 |
| 2005-03-02 08:30:00 | SPY | ETF | 120.98 | 120.98 | 120.84 | 120.86 | 22500.0 |
| 2005-03-02 09:00:00 | SPY | ETF | 120.84 | 120.84 | 120.74 | 120.79 | 86500.0 |
| 2005-03-02 09:30:00 | SPY | ETF | 120.76 | 120.94 | 120.65 | 120.93 | 6483800.0 |
| 2005-03-02 10:00:00 | SPY | ETF | 120.92 | 121.09 | 120.81 | 121.05 | 5125700.0 |
| 2005-03-02 10:30:00 | SPY | ETF | 121.05 | 121.32 | 120.9 | 121.29 | 4275500.0 |
| 2005-03-02 11:00:00 | SPY | ETF | 121.29 | 121.93 | 121.24 | 121.76 | 8182500.0 |
| 2005-03-02 11:30:00 | SPY | ETF | 121.77 | 121.87 | 121.68 | 121.69 | 2937800.0 |
| 2005-03-02 12:00:00 | SPY | ETF | 121.7 | 121.79 | 121.66 | 121.74 | 2510000.0 |
| 2005-03-02 12:30:00 | SPY | ETF | 121.73 | 121.75 | 121.57 | 121.67 | 2407100.0 |
| 2005-03-02 13:00:00 | SPY | ETF | 121.67 | 121.83 | 121.6 | 121.79 | 1391200.0 |
| 2005-03-02 13:30:00 | SPY | ETF | 121.79 | 121.85 | 121.18 | 121.37 | 8123900.0 |
| 2005-03-02 14:00:00 | SPY | ETF | 121.38 | 121.48 | 121.23 | 121.31 | 4531100.0 |
| 2005-03-02 14:30:00 | SPY | ETF | 121.31 | 121.37 | 120.92 | 121.08 | 7275900.0 |
| 2005-03-02 15:00:00 | SPY | ETF | 121.07 | 121.42 | 121.07 | 121.4 | 4129300.0 |
| 2005-03-02 15:30:00 | SPY | ETF | 121.4 | 121.485 | 121.25 | 121.29 | 3952500.0 |
| 2005-03-02 16:00:00 | SPY | ETF | 121.29 | 121.37 | 121.11 | 121.23 | 1327200.0 |
| 2005-03-02 16:30:00 | SPY | ETF | 121.24 | 121.2705 | 121.14 | 121.2 | 253400.0 |
| 2005-03-02 17:00:00 | SPY | ETF | 121.19 | 121.2 | 121.18 | 121.18 | 8500.0 |
| 2005-03-02 17:30:00 | SPY | ETF | 121.15 | 121.15 | 121.15 | 121.15 | 300.0 |
| 2005-03-02 18:00:00 | SPY | ETF | 121.13 | 121.13 | 121.11 | 121.11 | 1500.0 |
| 2005-03-02 19:30:00 | SPY | ETF | 121.18 | 121.18 | 121.18 | 121.18 | 300.0 |
| 2005-03-02 09:30:00 | QQQ | ETF | 37.42 | 37.47 | 37.36 | 37.47 | 10822300.0 |
| 2005-03-02 10:00:00 | QQQ | ETF | 37.47 | 37.57 | 37.41 | 37.53 | 8588100.0 |
| 2005-03-02 10:30:00 | QQQ | ETF | 37.53 | 37.76 | 37.45 | 37.74 | 10929200.0 |
| 2005-03-02 11:00:00 | QQQ | ETF | 37.75 | 38.02 | 37.67 | 37.92 | 19497100.0 |
| 2005-03-02 11:30:00 | QQQ | ETF | 37.92 | 37.96 | 37.86 | 37.89 | 5213200.0 |
| 2005-03-02 12:00:00 | QQQ | ETF | 37.89 | 37.93 | 37.86 | 37.89 | 3437100.0 |
| 2005-03-02 12:30:00 | QQQ | ETF | 37.89 | 37.9 | 37.81 | 37.84 | 4727500.0 |
| 2005-03-02 13:00:00 | QQQ | ETF | 37.84 | 37.9 | 37.82 | 37.89 | 2360600.0 |
| 2005-03-02 13:30:00 | QQQ | ETF | 37.89 | 37.94 | 37.47 | 37.77 | 9140100.0 |
| 2005-03-02 14:00:00 | QQQ | ETF | 37.77 | 37.8 | 37.68 | 37.75 | 5635400.0 |
| 2005-03-02 14:30:00 | QQQ | ETF | 37.75 | 37.78 | 37.55 | 37.6 | 8473300.0 |
| 2005-03-02 15:00:00 | QQQ | ETF | 37.6 | 37.73 | 37.6 | 37.73 | 4658300.0 |
| 2005-03-02 15:30:00 | QQQ | ETF | 37.73 | 37.76 | 37.61 | 37.61 | 7303500.0 |
| 2005-03-02 08:30:00 | IWM | ETF | 63.425 | 63.425 | 63.425 | 63.425 | 1800.0 |
| 2005-03-02 09:00:00 | IWM | ETF | 63.405 | 63.405 | 63.325 | 63.355 | 47200.0 |
| 2005-03-02 09:30:00 | IWM | ETF | 63.355 | 63.485 | 63.25 | 63.44 | 1536200.0 |
| 2005-03-02 10:00:00 | IWM | ETF | 63.445 | 63.635 | 63.375 | 63.55 | 1556400.0 |
| 2005-03-02 10:30:00 | IWM | ETF | 63.55 | 63.74 | 63.445 | 63.74 | 1172600.0 |
| 2005-03-02 11:00:00 | IWM | ETF | 63.75 | 64.13 | 63.705 | 64.02 | 4395600.0 |
| 2005-03-02 11:30:00 | IWM | ETF | 64.025 | 64.04 | 63.9 | 63.91 | 1097000.0 |
| 2005-03-02 12:00:00 | IWM | ETF | 63.905 | 64.005 | 63.905 | 63.955 | 1056200.0 |
| 2005-03-02 12:30:00 | IWM | ETF | 63.94 | 63.945 | 63.82 | 63.91 | 1102400.0 |
| 2005-03-02 13:00:00 | IWM | ETF | 63.905 | 63.995 | 63.86 | 63.995 | 579200.0 |
| 2005-03-02 13:30:00 | IWM | ETF | 64.0 | 64.025 | 63.61 | 63.72 | 1643600.0 |
| 2005-03-02 14:00:00 | IWM | ETF | 63.72 | 63.85 | 63.625 | 63.74 | 1688800.0 |
| 2005-03-02 14:30:00 | IWM | ETF | 63.765 | 63.79 | 63.35 | 63.525 | 2044800.0 |
| 2005-03-02 15:00:00 | IWM | ETF | 63.515 | 63.695 | 63.515 | 63.68 | 784200.0 |
| 2005-03-02 15:30:00 | IWM | ETF | 63.7 | 63.755 | 63.52 | 63.545 | 1356400.0 |
> showing 50 of 1,449 rows — these rows as CSV