PREVIEW / etf_30min / 2006-03-02
file: by_date/etf_30min/2006/2006-03-02.parquet size: 61 KB rows: 2,171
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 |
|---|---|---|---|---|---|---|---|
| 2006-03-02 07:00:00 | SPY | ETF | 129.17 | 129.18 | 129.16 | 129.18 | 17000.0 |
| 2006-03-02 07:30:00 | SPY | ETF | 129.14 | 129.17 | 129.1 | 129.17 | 39000.0 |
| 2006-03-02 08:00:00 | SPY | ETF | 129.12 | 129.2 | 129.1 | 129.1 | 1325200.0 |
| 2006-03-02 08:30:00 | SPY | ETF | 129.11 | 129.15 | 129.05 | 129.05 | 334200.0 |
| 2006-03-02 09:00:00 | SPY | ETF | 129.06 | 129.08 | 128.84 | 128.9 | 744000.0 |
| 2006-03-02 09:30:00 | SPY | ETF | 128.9 | 129.05 | 128.69 | 128.71 | 8555100.0 |
| 2006-03-02 10:00:00 | SPY | ETF | 128.71 | 128.93 | 128.64 | 128.91 | 5271300.0 |
| 2006-03-02 10:30:00 | SPY | ETF | 128.91 | 129.21 | 128.79 | 129.11 | 5443400.0 |
| 2006-03-02 11:00:00 | SPY | ETF | 129.11 | 129.42 | 129.11 | 129.22 | 4262700.0 |
| 2006-03-02 11:30:00 | SPY | ETF | 129.21 | 129.25 | 128.96 | 129.05 | 3290100.0 |
| 2006-03-02 12:00:00 | SPY | ETF | 129.05 | 129.07 | 128.61 | 128.64 | 3730600.0 |
| 2006-03-02 12:30:00 | SPY | ETF | 128.64 | 129.08 | 128.61 | 128.8088 | 4429400.0 |
| 2006-03-02 13:00:00 | SPY | ETF | 128.81 | 129.01 | 128.73 | 128.78 | 2825200.0 |
| 2006-03-02 13:30:00 | SPY | ETF | 128.77 | 129.05 | 128.76 | 129.0 | 2466100.0 |
| 2006-03-02 14:00:00 | SPY | ETF | 129.0 | 129.04 | 128.82 | 128.88 | 1642700.0 |
| 2006-03-02 14:30:00 | SPY | ETF | 128.88 | 129.08 | 128.86 | 129.04 | 1900700.0 |
| 2006-03-02 15:00:00 | SPY | ETF | 129.03 | 129.35 | 129.02 | 129.27 | 3484900.0 |
| 2006-03-02 15:30:00 | SPY | ETF | 129.27 | 129.33 | 129.1 | 129.22 | 3624100.0 |
| 2006-03-02 16:00:00 | SPY | ETF | 129.23 | 129.41 | 129.19 | 129.4 | 867600.0 |
| 2006-03-02 16:30:00 | SPY | ETF | 129.4 | 129.4 | 129.32 | 129.35 | 170900.0 |
| 2006-03-02 17:00:00 | SPY | ETF | 129.37 | 129.37 | 129.1868 | 129.34 | 9000.0 |
| 2006-03-02 17:30:00 | SPY | ETF | 129.4 | 129.4 | 129.35 | 129.35 | 200.0 |
| 2006-03-02 18:00:00 | SPY | ETF | 129.34 | 129.34 | 129.3 | 129.3 | 2200.0 |
| 2006-03-02 19:30:00 | SPY | ETF | 129.31 | 129.31 | 129.29 | 129.29 | 6400.0 |
| 2006-03-02 09:30:00 | QQQ | ETF | 41.55 | 41.63 | 41.5 | 41.53 | 9908800.0 |
| 2006-03-02 10:00:00 | QQQ | ETF | 41.53 | 41.66 | 41.51 | 41.6 | 6561000.0 |
| 2006-03-02 10:30:00 | QQQ | ETF | 41.6 | 41.76 | 41.55 | 41.71 | 4562900.0 |
| 2006-03-02 11:00:00 | QQQ | ETF | 41.71 | 41.84 | 41.66 | 41.71 | 8097100.0 |
| 2006-03-02 11:30:00 | QQQ | ETF | 41.71 | 41.74 | 41.57 | 41.59 | 4329400.0 |
| 2006-03-02 12:00:00 | QQQ | ETF | 41.59 | 41.61 | 41.45 | 41.46 | 5707400.0 |
| 2006-03-02 12:30:00 | QQQ | ETF | 41.46 | 41.55 | 41.41 | 41.5 | 4279900.0 |
| 2006-03-02 13:00:00 | QQQ | ETF | 41.5 | 41.64 | 41.47 | 41.54 | 3060600.0 |
| 2006-03-02 13:30:00 | QQQ | ETF | 41.53 | 41.63 | 41.51 | 41.61 | 2825900.0 |
| 2006-03-02 14:00:00 | QQQ | ETF | 41.61 | 41.63 | 41.45 | 41.48 | 4123200.0 |
| 2006-03-02 14:30:00 | QQQ | ETF | 41.47 | 41.55 | 41.47 | 41.53 | 1726900.0 |
| 2006-03-02 15:00:00 | QQQ | ETF | 41.53 | 41.72 | 41.53 | 41.67 | 5476800.0 |
| 2006-03-02 15:30:00 | QQQ | ETF | 41.68 | 41.7 | 41.59 | 41.7 | 5045200.0 |
| 2006-03-02 08:30:00 | IWM | ETF | 73.77 | 73.8 | 73.7 | 73.71 | 16600.0 |
| 2006-03-02 09:00:00 | IWM | ETF | 73.72 | 73.72 | 73.61 | 73.65 | 162100.0 |
| 2006-03-02 09:30:00 | IWM | ETF | 73.66 | 73.7 | 73.32 | 73.32 | 5543600.0 |
| 2006-03-02 10:00:00 | IWM | ETF | 73.32 | 73.67 | 73.25 | 73.64 | 3980100.0 |
| 2006-03-02 10:30:00 | IWM | ETF | 73.63 | 73.82 | 73.55 | 73.78 | 3092300.0 |
| 2006-03-02 11:00:00 | IWM | ETF | 73.77 | 73.89 | 73.77 | 73.81 | 1584600.0 |
| 2006-03-02 11:30:00 | IWM | ETF | 73.82 | 73.82 | 73.5 | 73.52 | 2210100.0 |
| 2006-03-02 12:00:00 | IWM | ETF | 73.53 | 73.58 | 73.23 | 73.25 | 3007400.0 |
| 2006-03-02 12:30:00 | IWM | ETF | 73.26 | 73.36 | 73.09 | 73.24 | 3327700.0 |
| 2006-03-02 13:00:00 | IWM | ETF | 73.24 | 73.35 | 73.16 | 73.19 | 1831700.0 |
| 2006-03-02 13:30:00 | IWM | ETF | 73.2 | 73.34 | 73.16 | 73.31 | 1707600.0 |
| 2006-03-02 14:00:00 | IWM | ETF | 73.31 | 73.34 | 73.11 | 73.22 | 2702500.0 |
| 2006-03-02 14:30:00 | IWM | ETF | 73.22 | 73.45 | 73.2 | 73.41 | 1662900.0 |
> showing 50 of 2,171 rows — these rows as CSV