PREVIEW / etf_30min / 2008-02-11
file: by_date/etf_30min/2008/2008-02-11.parquet size: 151 KB rows: 5,475
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 |
|---|---|---|---|---|---|---|---|
| 2008-02-11 04:00:00 | SPY | ETF | 132.86 | 132.93 | 132.86 | 132.93 | 7000.0 |
| 2008-02-11 04:30:00 | SPY | ETF | 132.73 | 132.73 | 132.73 | 132.73 | 900.0 |
| 2008-02-11 05:30:00 | SPY | ETF | 133.1 | 133.1 | 133.1 | 133.1 | 100.0 |
| 2008-02-11 06:00:00 | SPY | ETF | 133.06 | 133.06 | 133.05 | 133.05 | 10000.0 |
| 2008-02-11 06:30:00 | SPY | ETF | 132.86 | 132.95 | 132.81 | 132.95 | 45000.0 |
| 2008-02-11 07:00:00 | SPY | ETF | 132.87 | 133.3 | 132.81 | 133.26 | 164400.0 |
| 2008-02-11 07:30:00 | SPY | ETF | 133.23 | 133.57 | 133.04 | 133.47 | 448700.0 |
| 2008-02-11 08:00:00 | SPY | ETF | 133.45 | 133.59 | 132.95 | 133.54 | 1906900.0 |
| 2008-02-11 08:30:00 | SPY | ETF | 133.57 | 133.58 | 133.25 | 133.35 | 699600.0 |
| 2008-02-11 09:00:00 | SPY | ETF | 133.34 | 133.35 | 133.08 | 133.1 | 1369154.0 |
| 2008-02-11 09:30:00 | SPY | ETF | 133.1 | 133.8 | 132.25 | 132.56 | 24653670.0 |
| 2008-02-11 10:00:00 | SPY | ETF | 132.55 | 132.77 | 132.04 | 132.48 | 20228587.0 |
| 2008-02-11 10:30:00 | SPY | ETF | 132.49 | 132.83 | 132.28 | 132.77 | 12861264.0 |
| 2008-02-11 11:00:00 | SPY | ETF | 132.77 | 133.31 | 132.66 | 132.98 | 15216984.0 |
| 2008-02-11 11:30:00 | SPY | ETF | 132.99 | 133.11 | 132.76 | 132.84 | 9839431.0 |
| 2008-02-11 12:00:00 | SPY | ETF | 132.84 | 133.52 | 132.84 | 133.1 | 9035941.0 |
| 2008-02-11 12:30:00 | SPY | ETF | 133.11 | 133.94 | 133.02 | 133.8799 | 12291624.0 |
| 2008-02-11 13:00:00 | SPY | ETF | 133.87 | 134.13 | 133.65 | 134.05 | 9250161.0 |
| 2008-02-11 13:30:00 | SPY | ETF | 134.05 | 134.2 | 133.83 | 133.9 | 6784528.0 |
| 2008-02-11 14:00:00 | SPY | ETF | 133.91 | 134.12 | 133.61 | 133.65 | 8090578.0 |
| 2008-02-11 14:30:00 | SPY | ETF | 133.65 | 133.95 | 133.45 | 133.73 | 12651792.0 |
| 2008-02-11 15:00:00 | SPY | ETF | 133.72 | 134.23 | 133.5 | 134.07 | 14418552.0 |
| 2008-02-11 15:30:00 | SPY | ETF | 134.08 | 134.12 | 133.66 | 133.91 | 14901155.0 |
| 2008-02-11 16:00:00 | SPY | ETF | 133.84 | 134.01 | 133.71 | 133.79 | 3536400.0 |
| 2008-02-11 16:30:00 | SPY | ETF | 133.79 | 133.8 | 133.2 | 133.63 | 4537500.0 |
| 2008-02-11 17:00:00 | SPY | ETF | 133.63 | 133.75 | 133.61 | 133.67 | 133700.0 |
| 2008-02-11 17:30:00 | SPY | ETF | 133.71 | 133.73 | 133.69 | 133.69 | 7700.0 |
| 2008-02-11 18:00:00 | SPY | ETF | 133.75 | 133.75 | 133.65 | 133.65 | 6100.0 |
| 2008-02-11 18:30:00 | SPY | ETF | 133.65 | 133.8 | 133.65 | 133.71 | 10600.0 |
| 2008-02-11 19:00:00 | SPY | ETF | 133.73 | 133.74 | 133.58 | 133.74 | 20200.0 |
| 2008-02-11 19:30:00 | SPY | ETF | 133.74 | 133.77 | 133.64 | 133.72 | 31000.0 |
| 2008-02-11 04:30:00 | QQQ | ETF | 43.45 | 43.45 | 43.45 | 43.45 | 4000.0 |
| 2008-02-11 05:00:00 | QQQ | ETF | 43.63 | 43.63 | 43.63 | 43.63 | 200.0 |
| 2008-02-11 05:30:00 | QQQ | ETF | 43.61 | 43.61 | 43.61 | 43.61 | 200.0 |
| 2008-02-11 06:00:00 | QQQ | ETF | 43.6 | 43.6 | 43.59 | 43.59 | 3300.0 |
| 2008-02-11 06:30:00 | QQQ | ETF | 43.57 | 43.59 | 43.57 | 43.59 | 25100.0 |
| 2008-02-11 07:00:00 | QQQ | ETF | 43.58 | 43.7 | 43.58 | 43.62 | 108598.0 |
| 2008-02-11 07:30:00 | QQQ | ETF | 43.62 | 43.75 | 43.61 | 43.72 | 108300.0 |
| 2008-02-11 08:00:00 | QQQ | ETF | 43.72 | 43.92 | 43.72 | 43.9 | 1212662.0 |
| 2008-02-11 08:30:00 | QQQ | ETF | 43.91 | 43.92 | 43.84 | 43.84 | 399834.0 |
| 2008-02-11 09:00:00 | QQQ | ETF | 43.84 | 43.89 | 43.78 | 43.79 | 1199778.0 |
| 2008-02-11 09:30:00 | QQQ | ETF | 43.79 | 43.9 | 43.62 | 43.74 | 17972816.0 |
| 2008-02-11 10:00:00 | QQQ | ETF | 43.73 | 43.82 | 43.54 | 43.65 | 11207422.0 |
| 2008-02-11 10:30:00 | QQQ | ETF | 43.6599 | 43.85 | 43.58 | 43.82 | 8756706.0 |
| 2008-02-11 11:00:00 | QQQ | ETF | 43.82 | 43.93 | 43.76 | 43.7805 | 7320487.0 |
| 2008-02-11 11:30:00 | QQQ | ETF | 43.7805 | 43.7899 | 43.67 | 43.71 | 5282285.0 |
| 2008-02-11 12:00:00 | QQQ | ETF | 43.72 | 43.91 | 43.71 | 43.8 | 4639356.0 |
| 2008-02-11 12:30:00 | QQQ | ETF | 43.81 | 44.0699 | 43.79 | 44.05 | 9074676.0 |
| 2008-02-11 13:00:00 | QQQ | ETF | 44.06 | 44.15 | 44.0 | 44.14 | 6168098.0 |
| 2008-02-11 13:30:00 | QQQ | ETF | 44.15 | 44.17 | 44.05 | 44.09 | 4173226.0 |
> showing 50 of 5,475 rows — these rows as CSV