PREVIEW / etf_30min / 2006-10-02
file: by_date/etf_30min/2006/2006-10-02.parquet size: 81 KB rows: 2,840
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-10-02 07:00:00 | SPY | ETF | 133.66 | 133.66 | 133.66 | 133.66 | 2500.0 |
| 2006-10-02 07:30:00 | SPY | ETF | 133.59 | 133.59 | 133.45 | 133.45 | 13100.0 |
| 2006-10-02 08:00:00 | SPY | ETF | 133.46 | 133.8 | 133.37 | 133.39 | 173800.0 |
| 2006-10-02 08:30:00 | SPY | ETF | 133.44 | 133.61 | 133.4 | 133.43 | 104400.0 |
| 2006-10-02 09:00:00 | SPY | ETF | 133.42 | 133.55 | 133.41 | 133.55 | 431300.0 |
| 2006-10-02 09:30:00 | SPY | ETF | 133.54 | 133.56 | 133.38 | 133.46 | 3561000.0 |
| 2006-10-02 10:00:00 | SPY | ETF | 133.46 | 133.61 | 133.36 | 133.46 | 3805400.0 |
| 2006-10-02 10:30:00 | SPY | ETF | 133.49 | 133.58 | 133.4 | 133.55 | 4112100.0 |
| 2006-10-02 11:00:00 | SPY | ETF | 133.54 | 133.59 | 133.45 | 133.57 | 1732900.0 |
| 2006-10-02 11:30:00 | SPY | ETF | 133.57 | 133.83 | 133.57 | 133.7 | 6345700.0 |
| 2006-10-02 12:00:00 | SPY | ETF | 133.67 | 133.75 | 133.64 | 133.68 | 1240800.0 |
| 2006-10-02 12:30:00 | SPY | ETF | 133.67 | 133.81 | 133.67 | 133.71 | 923900.0 |
| 2006-10-02 13:00:00 | SPY | ETF | 133.71 | 133.75 | 133.63 | 133.64 | 1452500.0 |
| 2006-10-02 13:30:00 | SPY | ETF | 133.64 | 133.68 | 133.05 | 133.16 | 7202400.0 |
| 2006-10-02 14:00:00 | SPY | ETF | 133.15 | 133.24 | 133.04 | 133.15 | 2553900.0 |
| 2006-10-02 14:30:00 | SPY | ETF | 133.15 | 133.18 | 132.96 | 133.03 | 2018300.0 |
| 2006-10-02 15:00:00 | SPY | ETF | 133.02 | 133.27 | 132.95 | 133.25 | 2643500.0 |
| 2006-10-02 15:30:00 | SPY | ETF | 133.27 | 133.3 | 133.07 | 133.07 | 3716100.0 |
| 2006-10-02 16:00:00 | SPY | ETF | 133.07 | 133.13 | 133.02 | 133.02 | 892600.0 |
| 2006-10-02 16:30:00 | SPY | ETF | 133.08 | 133.12 | 133.04 | 133.04 | 3948200.0 |
| 2006-10-02 17:00:00 | SPY | ETF | 133.04 | 133.48 | 133.02 | 133.02 | 15900.0 |
| 2006-10-02 17:30:00 | SPY | ETF | 133.07 | 133.07 | 133.02 | 133.02 | 800.0 |
| 2006-10-02 18:00:00 | SPY | ETF | 133.02 | 133.063 | 133.02 | 133.03 | 756100.0 |
| 2006-10-02 18:30:00 | SPY | ETF | 133.07 | 133.09 | 133.07 | 133.09 | 1000.0 |
| 2006-10-02 19:00:00 | SPY | ETF | 133.08 | 133.08 | 133.08 | 133.08 | 500.0 |
| 2006-10-02 19:30:00 | SPY | ETF | 133.1 | 133.1 | 133.1 | 133.1 | 500.0 |
| 2006-10-02 09:30:00 | QQQ | ETF | 40.6 | 40.62 | 40.44 | 40.51 | 9591200.0 |
| 2006-10-02 10:00:00 | QQQ | ETF | 40.52 | 40.62 | 40.46 | 40.54 | 9340700.0 |
| 2006-10-02 10:30:00 | QQQ | ETF | 40.54 | 40.57 | 40.46 | 40.53 | 4092200.0 |
| 2006-10-02 11:00:00 | QQQ | ETF | 40.53 | 40.56 | 40.48 | 40.54 | 2280800.0 |
| 2006-10-02 11:30:00 | QQQ | ETF | 40.54 | 40.7 | 40.54 | 40.65 | 8003300.0 |
| 2006-10-02 12:00:00 | QQQ | ETF | 40.64 | 40.7 | 40.62 | 40.63 | 2072000.0 |
| 2006-10-02 12:30:00 | QQQ | ETF | 40.63 | 40.67 | 40.58 | 40.59 | 2668100.0 |
| 2006-10-02 13:00:00 | QQQ | ETF | 40.59 | 40.61 | 40.53 | 40.54 | 1390400.0 |
| 2006-10-02 13:30:00 | QQQ | ETF | 40.54 | 40.55 | 40.11 | 40.16 | 16637200.0 |
| 2006-10-02 14:00:00 | QQQ | ETF | 40.17 | 40.24 | 40.08 | 40.17 | 10454100.0 |
| 2006-10-02 14:30:00 | QQQ | ETF | 40.17 | 40.24 | 40.11 | 40.16 | 5982000.0 |
| 2006-10-02 15:00:00 | QQQ | ETF | 40.15 | 40.27 | 40.11 | 40.26 | 5915400.0 |
| 2006-10-02 15:30:00 | QQQ | ETF | 40.26 | 40.27 | 40.13 | 40.15 | 9479700.0 |
| 2006-10-02 07:30:00 | IWM | ETF | 71.93 | 71.93 | 71.93 | 71.93 | 1000.0 |
| 2006-10-02 08:00:00 | IWM | ETF | 72.0 | 72.0 | 71.85 | 71.99 | 314600.0 |
| 2006-10-02 08:30:00 | IWM | ETF | 71.96 | 71.96 | 71.82 | 71.84 | 31000.0 |
| 2006-10-02 09:00:00 | IWM | ETF | 71.88 | 72.0 | 71.88 | 72.0 | 242000.0 |
| 2006-10-02 09:30:00 | IWM | ETF | 71.97 | 72.0 | 71.5 | 71.63 | 4776400.0 |
| 2006-10-02 10:00:00 | IWM | ETF | 71.64 | 71.83 | 71.57 | 71.74 | 4103100.0 |
| 2006-10-02 10:30:00 | IWM | ETF | 71.74 | 72.0 | 71.7 | 71.92 | 2535400.0 |
| 2006-10-02 11:00:00 | IWM | ETF | 71.92 | 72.11 | 71.86 | 72.08 | 1186000.0 |
| 2006-10-02 11:30:00 | IWM | ETF | 72.08 | 72.21 | 72.07 | 72.11 | 2420600.0 |
| 2006-10-02 12:00:00 | IWM | ETF | 72.11 | 72.21 | 72.1 | 72.14 | 832500.0 |
| 2006-10-02 12:30:00 | IWM | ETF | 72.13 | 72.2 | 72.04 | 72.06 | 850800.0 |
> showing 50 of 2,840 rows — these rows as CSV