PREVIEW / etf_30min / 2008-02-26
file: by_date/etf_30min/2008/2008-02-26.parquet size: 158 KB rows: 5,680
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-26 04:00:00 | SPY | ETF | 137.33 | 137.33 | 137.33 | 137.33 | 200.0 |
| 2008-02-26 05:00:00 | SPY | ETF | 137.52 | 137.52 | 137.52 | 137.52 | 200.0 |
| 2008-02-26 06:00:00 | SPY | ETF | 137.4 | 137.43 | 137.4 | 137.43 | 10000.0 |
| 2008-02-26 06:30:00 | SPY | ETF | 137.31 | 137.34 | 137.29 | 137.34 | 5700.0 |
| 2008-02-26 07:00:00 | SPY | ETF | 137.3 | 137.52 | 137.28 | 137.39 | 122200.0 |
| 2008-02-26 07:30:00 | SPY | ETF | 137.4 | 137.44 | 137.18 | 137.19 | 101800.0 |
| 2008-02-26 08:00:00 | SPY | ETF | 137.25 | 137.4 | 137.05 | 137.33 | 1280300.0 |
| 2008-02-26 08:30:00 | SPY | ETF | 137.27 | 137.27 | 136.63 | 136.95 | 5706800.0 |
| 2008-02-26 09:00:00 | SPY | ETF | 136.95 | 137.05 | 136.63 | 136.73 | 1689813.0 |
| 2008-02-26 09:30:00 | SPY | ETF | 136.73 | 137.27 | 136.72 | 136.89 | 17901431.0 |
| 2008-02-26 10:00:00 | SPY | ETF | 136.87 | 137.22 | 136.55 | 136.76 | 17821936.0 |
| 2008-02-26 10:30:00 | SPY | ETF | 136.75 | 137.5 | 136.5 | 137.19 | 15968680.0 |
| 2008-02-26 11:00:00 | SPY | ETF | 137.19 | 137.66 | 137.13 | 137.55 | 15066990.0 |
| 2008-02-26 11:30:00 | SPY | ETF | 137.54 | 138.1 | 137.49 | 138.09 | 10985260.0 |
| 2008-02-26 12:00:00 | SPY | ETF | 138.07 | 138.81 | 137.98 | 138.57 | 16296166.0 |
| 2008-02-26 12:30:00 | SPY | ETF | 138.57 | 138.72 | 138.28 | 138.708 | 12739275.0 |
| 2008-02-26 13:00:00 | SPY | ETF | 138.69 | 138.95 | 138.3 | 138.44 | 9518277.0 |
| 2008-02-26 13:30:00 | SPY | ETF | 138.44 | 138.59 | 138.19 | 138.24 | 8351089.0 |
| 2008-02-26 14:00:00 | SPY | ETF | 138.25 | 138.65 | 138.14 | 138.51 | 7676344.0 |
| 2008-02-26 14:30:00 | SPY | ETF | 138.51 | 138.84 | 138.46 | 138.72 | 6388438.0 |
| 2008-02-26 15:00:00 | SPY | ETF | 138.71 | 138.9 | 137.65 | 138.24 | 16551495.0 |
| 2008-02-26 15:30:00 | SPY | ETF | 138.24 | 138.5 | 137.9 | 138.35 | 22432709.0 |
| 2008-02-26 16:00:00 | SPY | ETF | 138.31 | 138.82 | 137.38 | 138.34 | 13621200.0 |
| 2008-02-26 16:30:00 | SPY | ETF | 138.32 | 138.41 | 138.29 | 138.36 | 5782495.0 |
| 2008-02-26 17:00:00 | SPY | ETF | 138.37 | 138.45 | 138.33 | 138.37 | 263100.0 |
| 2008-02-26 17:30:00 | SPY | ETF | 138.42 | 138.52 | 138.4 | 138.42 | 121000.0 |
| 2008-02-26 18:00:00 | SPY | ETF | 138.4 | 138.4 | 138.29 | 138.32 | 77200.0 |
| 2008-02-26 18:30:00 | SPY | ETF | 138.34 | 138.34 | 138.25 | 138.25 | 22800.0 |
| 2008-02-26 19:00:00 | SPY | ETF | 138.29 | 138.34 | 138.29 | 138.33 | 3100.0 |
| 2008-02-26 19:30:00 | SPY | ETF | 138.32 | 138.42 | 138.28 | 138.38 | 11100.0 |
| 2008-02-26 05:00:00 | QQQ | ETF | 44.06 | 44.06 | 44.06 | 44.06 | 100.0 |
| 2008-02-26 05:30:00 | QQQ | ETF | 44.07 | 44.07 | 44.07 | 44.07 | 100.0 |
| 2008-02-26 06:30:00 | QQQ | ETF | 44.0 | 44.03 | 44.0 | 44.03 | 200.0 |
| 2008-02-26 07:00:00 | QQQ | ETF | 44.02 | 44.05 | 44.02 | 44.03 | 143770.0 |
| 2008-02-26 07:30:00 | QQQ | ETF | 44.03 | 44.05 | 43.98 | 43.99 | 123498.0 |
| 2008-02-26 08:00:00 | QQQ | ETF | 43.99 | 44.0 | 43.84 | 43.84 | 633948.0 |
| 2008-02-26 08:30:00 | QQQ | ETF | 43.83 | 43.83 | 43.64 | 43.7 | 1697361.0 |
| 2008-02-26 09:00:00 | QQQ | ETF | 43.7 | 43.75 | 43.6 | 43.63 | 1383899.0 |
| 2008-02-26 09:30:00 | QQQ | ETF | 43.64 | 43.8501 | 43.6 | 43.6 | 12135972.0 |
| 2008-02-26 10:00:00 | QQQ | ETF | 43.61 | 43.71 | 43.46 | 43.48 | 11043248.0 |
| 2008-02-26 10:30:00 | QQQ | ETF | 43.48 | 43.85 | 43.37 | 43.68 | 26133893.0 |
| 2008-02-26 11:00:00 | QQQ | ETF | 43.69 | 43.85 | 43.65 | 43.74 | 11679371.0 |
| 2008-02-26 11:30:00 | QQQ | ETF | 43.73 | 44.07 | 43.72 | 44.06 | 10636543.0 |
| 2008-02-26 12:00:00 | QQQ | ETF | 44.07 | 44.34 | 43.95 | 44.25 | 12969451.0 |
| 2008-02-26 12:30:00 | QQQ | ETF | 44.26 | 44.29 | 44.1 | 44.28 | 7306647.0 |
| 2008-02-26 13:00:00 | QQQ | ETF | 44.29 | 44.48 | 44.19 | 44.21 | 10472373.0 |
| 2008-02-26 13:30:00 | QQQ | ETF | 44.21 | 44.31 | 44.17 | 44.2 | 4481014.0 |
| 2008-02-26 14:00:00 | QQQ | ETF | 44.21 | 44.32 | 44.16 | 44.28 | 4183224.0 |
| 2008-02-26 14:30:00 | QQQ | ETF | 44.271 | 44.42 | 44.2215 | 44.38 | 4488333.0 |
| 2008-02-26 15:00:00 | QQQ | ETF | 44.38 | 44.38 | 43.87 | 44.02 | 12830315.0 |
> showing 50 of 5,680 rows — these rows as CSV