PREVIEW / etf_30min / 2009-05-08
file: by_date/etf_30min/2009/2009-05-08.parquet size: 226 KB rows: 7,464
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 |
|---|---|---|---|---|---|---|---|
| 2009-05-08 04:30:00 | SPY | ETF | 91.83 | 91.95 | 91.83 | 91.95 | 1750.0 |
| 2009-05-08 05:00:00 | SPY | ETF | 91.94 | 92.11 | 91.94 | 92.11 | 11155.0 |
| 2009-05-08 05:30:00 | SPY | ETF | 92.16 | 92.16 | 92.07 | 92.09 | 15300.0 |
| 2009-05-08 06:00:00 | SPY | ETF | 92.05 | 92.22 | 92.0 | 92.22 | 26012.0 |
| 2009-05-08 06:30:00 | SPY | ETF | 92.1 | 92.34 | 92.1 | 92.24 | 29737.0 |
| 2009-05-08 07:00:00 | SPY | ETF | 92.27 | 92.48 | 92.2 | 92.47 | 368859.0 |
| 2009-05-08 07:30:00 | SPY | ETF | 92.5 | 92.6 | 92.33 | 92.38 | 721539.0 |
| 2009-05-08 08:00:00 | SPY | ETF | 92.38 | 92.57 | 91.9 | 92.41 | 3070271.0 |
| 2009-05-08 08:30:00 | SPY | ETF | 92.43 | 92.75 | 90.9 | 92.16 | 7333259.0 |
| 2009-05-08 09:00:00 | SPY | ETF | 92.15 | 92.4 | 91.61 | 92.02 | 2760373.0 |
| 2009-05-08 09:30:00 | SPY | ETF | 92.03 | 92.8 | 91.94 | 92.43 | 33814159.0 |
| 2009-05-08 10:00:00 | SPY | ETF | 92.42 | 92.48 | 91.44 | 91.62 | 30744708.0 |
| 2009-05-08 10:30:00 | SPY | ETF | 91.63 | 91.89 | 91.47 | 91.6 | 23497247.0 |
| 2009-05-08 11:00:00 | SPY | ETF | 91.6 | 92.12 | 91.6 | 91.83 | 15516743.0 |
| 2009-05-08 11:30:00 | SPY | ETF | 91.83 | 92.3 | 91.77 | 92.28 | 12091572.0 |
| 2009-05-08 12:00:00 | SPY | ETF | 92.29 | 92.7075 | 92.21 | 92.38 | 19247959.0 |
| 2009-05-08 12:30:00 | SPY | ETF | 92.37 | 92.75 | 92.28 | 92.7 | 16708867.0 |
| 2009-05-08 13:00:00 | SPY | ETF | 92.7 | 92.79 | 92.25 | 92.56 | 11232269.0 |
| 2009-05-08 13:30:00 | SPY | ETF | 92.56 | 92.68 | 92.32 | 92.38 | 11552413.0 |
| 2009-05-08 14:00:00 | SPY | ETF | 92.37 | 92.94 | 92.37 | 92.74 | 15987035.0 |
| 2009-05-08 14:30:00 | SPY | ETF | 92.74 | 93.22 | 92.74 | 93.02 | 17722867.0 |
| 2009-05-08 15:00:00 | SPY | ETF | 93.01 | 93.13 | 92.58 | 92.75 | 23743290.0 |
| 2009-05-08 15:30:00 | SPY | ETF | 92.75 | 93.12 | 92.5 | 93.03 | 38518679.0 |
| 2009-05-08 16:00:00 | SPY | ETF | 92.99 | 93.1 | 92.82 | 92.96 | 9509313.0 |
| 2009-05-08 16:30:00 | SPY | ETF | 92.96 | 92.99 | 92.83 | 92.83 | 1454401.0 |
| 2009-05-08 17:00:00 | SPY | ETF | 92.83 | 92.91 | 92.76 | 92.88 | 1579126.0 |
| 2009-05-08 17:30:00 | SPY | ETF | 92.88 | 92.9 | 92.81 | 92.89 | 23729.0 |
| 2009-05-08 18:00:00 | SPY | ETF | 92.9 | 92.99 | 92.89 | 92.94 | 17487.0 |
| 2009-05-08 18:30:00 | SPY | ETF | 92.95 | 93.0 | 92.91 | 92.94 | 25322.0 |
| 2009-05-08 19:00:00 | SPY | ETF | 92.97 | 93.0 | 92.93 | 92.99 | 5536.0 |
| 2009-05-08 19:30:00 | SPY | ETF | 92.93 | 93.09 | 92.93 | 93.08 | 12462.0 |
| 2009-05-08 05:00:00 | QQQ | ETF | 34.5 | 34.5 | 34.5 | 34.5 | 100.0 |
| 2009-05-08 05:30:00 | QQQ | ETF | 34.56 | 34.6 | 34.56 | 34.6 | 5930.0 |
| 2009-05-08 06:00:00 | QQQ | ETF | 34.55 | 34.55 | 34.53 | 34.53 | 200.0 |
| 2009-05-08 06:30:00 | QQQ | ETF | 34.54 | 34.6 | 34.52 | 34.58 | 12400.0 |
| 2009-05-08 07:00:00 | QQQ | ETF | 34.61 | 34.65 | 34.59 | 34.65 | 66600.0 |
| 2009-05-08 07:30:00 | QQQ | ETF | 34.66 | 34.68 | 34.63 | 34.67 | 115082.0 |
| 2009-05-08 08:00:00 | QQQ | ETF | 34.66 | 34.72 | 34.58 | 34.66 | 742515.0 |
| 2009-05-08 08:30:00 | QQQ | ETF | 34.67 | 34.73 | 34.51 | 34.58 | 2028217.0 |
| 2009-05-08 09:00:00 | QQQ | ETF | 34.59 | 34.67 | 34.32 | 34.35 | 2850705.0 |
| 2009-05-08 09:30:00 | QQQ | ETF | 34.35 | 34.74 | 34.34 | 34.49 | 26576485.0 |
| 2009-05-08 10:00:00 | QQQ | ETF | 34.5 | 34.7 | 33.93 | 33.99 | 24536186.0 |
| 2009-05-08 10:30:00 | QQQ | ETF | 34.0 | 34.09 | 33.88 | 33.97 | 13799833.0 |
| 2009-05-08 11:00:00 | QQQ | ETF | 33.96 | 34.17 | 33.96 | 34.03 | 10032200.0 |
| 2009-05-08 11:30:00 | QQQ | ETF | 34.03 | 34.15 | 33.97 | 34.14 | 6034757.0 |
| 2009-05-08 12:00:00 | QQQ | ETF | 34.13 | 34.34 | 34.07 | 34.23 | 9300543.0 |
| 2009-05-08 12:30:00 | QQQ | ETF | 34.24 | 34.37 | 34.18 | 34.35 | 8317114.0 |
| 2009-05-08 13:00:00 | QQQ | ETF | 34.3411 | 34.38 | 34.205 | 34.238 | 9071991.0 |
| 2009-05-08 13:30:00 | QQQ | ETF | 34.23 | 34.235 | 34.11 | 34.14 | 5317899.0 |
| 2009-05-08 14:00:00 | QQQ | ETF | 34.14 | 34.38 | 34.14 | 34.3 | 10860504.0 |
> showing 50 of 7,464 rows — these rows as CSV