PREVIEW / etf_30min / 2008-12-09
file: by_date/etf_30min/2008/2008-12-09.parquet size: 188 KB rows: 6,703
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-12-09 05:00:00 | SPY | ETF | 91.09 | 91.33 | 91.07 | 91.33 | 4700.0 |
| 2008-12-09 05:30:00 | SPY | ETF | 91.5 | 91.5 | 91.5 | 91.5 | 100.0 |
| 2008-12-09 06:00:00 | SPY | ETF | 91.64 | 91.68 | 91.35 | 91.42 | 78800.0 |
| 2008-12-09 06:30:00 | SPY | ETF | 91.4 | 91.55 | 91.21 | 91.39 | 91720.0 |
| 2008-12-09 07:00:00 | SPY | ETF | 91.35 | 91.51 | 91.31 | 91.43 | 364589.0 |
| 2008-12-09 07:30:00 | SPY | ETF | 91.42 | 91.5 | 91.23 | 91.27 | 257487.0 |
| 2008-12-09 08:00:00 | SPY | ETF | 91.1 | 91.48 | 90.11 | 90.91 | 1572395.0 |
| 2008-12-09 08:30:00 | SPY | ETF | 90.91 | 91.18 | 90.36 | 90.52 | 2671090.0 |
| 2008-12-09 09:00:00 | SPY | ETF | 90.53 | 90.64 | 90.25 | 90.37 | 1707213.0 |
| 2008-12-09 09:30:00 | SPY | ETF | 90.37 | 90.94 | 89.89 | 90.13 | 30067371.0 |
| 2008-12-09 10:00:00 | SPY | ETF | 90.13 | 91.63 | 89.95 | 91.31 | 29395019.0 |
| 2008-12-09 10:30:00 | SPY | ETF | 91.3 | 92.06 | 91.28 | 91.82 | 22202226.0 |
| 2008-12-09 11:00:00 | SPY | ETF | 91.82 | 92.13 | 90.78 | 90.78 | 21165477.0 |
| 2008-12-09 11:30:00 | SPY | ETF | 90.79 | 91.36 | 90.67 | 91.119 | 17019848.0 |
| 2008-12-09 12:00:00 | SPY | ETF | 91.12 | 91.56 | 90.76 | 90.98 | 17101419.0 |
| 2008-12-09 12:30:00 | SPY | ETF | 90.98 | 91.54 | 90.8 | 90.91 | 17124186.0 |
| 2008-12-09 13:00:00 | SPY | ETF | 90.92 | 91.18 | 90.23 | 90.3 | 17863048.0 |
| 2008-12-09 13:30:00 | SPY | ETF | 90.3 | 90.68 | 90.01 | 90.27 | 19020063.0 |
| 2008-12-09 14:00:00 | SPY | ETF | 90.28 | 90.3 | 89.09 | 89.26 | 27693019.0 |
| 2008-12-09 14:30:00 | SPY | ETF | 89.26 | 90.22 | 88.98 | 90.1 | 28479055.0 |
| 2008-12-09 15:00:00 | SPY | ETF | 90.09 | 90.53 | 89.19 | 89.25 | 41790548.0 |
| 2008-12-09 15:30:00 | SPY | ETF | 89.25 | 89.9667 | 89.02 | 89.4 | 49839286.0 |
| 2008-12-09 16:00:00 | SPY | ETF | 89.45 | 91.3756 | 89.37 | 89.5 | 14515207.0 |
| 2008-12-09 16:30:00 | SPY | ETF | 89.54 | 89.62 | 89.47 | 89.58 | 1345046.0 |
| 2008-12-09 17:00:00 | SPY | ETF | 89.58 | 89.84 | 89.47 | 89.7 | 3232844.0 |
| 2008-12-09 17:30:00 | SPY | ETF | 89.68 | 89.78 | 89.55 | 89.71 | 154040.0 |
| 2008-12-09 18:00:00 | SPY | ETF | 89.73 | 89.8 | 89.44 | 89.44 | 149230.0 |
| 2008-12-09 18:30:00 | SPY | ETF | 89.43 | 89.59 | 89.42 | 89.59 | 26484.0 |
| 2008-12-09 19:00:00 | SPY | ETF | 89.59 | 89.78 | 89.59 | 89.7 | 20185.0 |
| 2008-12-09 19:30:00 | SPY | ETF | 89.7 | 89.76 | 89.56 | 89.58 | 22935.0 |
| 2008-12-09 04:00:00 | QQQ | ETF | 29.75 | 29.75 | 29.75 | 29.75 | 200.0 |
| 2008-12-09 04:30:00 | QQQ | ETF | 29.93 | 29.93 | 29.93 | 29.93 | 300.0 |
| 2008-12-09 05:30:00 | QQQ | ETF | 30.09 | 30.09 | 30.09 | 30.09 | 290.0 |
| 2008-12-09 06:00:00 | QQQ | ETF | 30.11 | 30.11 | 30.11 | 30.11 | 100.0 |
| 2008-12-09 06:30:00 | QQQ | ETF | 30.01 | 30.05 | 29.96 | 29.99 | 101626.0 |
| 2008-12-09 07:00:00 | QQQ | ETF | 29.98 | 30.1 | 29.96 | 30.0 | 115525.0 |
| 2008-12-09 07:30:00 | QQQ | ETF | 30.0 | 30.01 | 29.91 | 29.96 | 46501.0 |
| 2008-12-09 08:00:00 | QQQ | ETF | 29.9 | 29.95 | 29.72 | 29.74 | 424060.0 |
| 2008-12-09 08:30:00 | QQQ | ETF | 29.74 | 29.82 | 29.58 | 29.63 | 563898.0 |
| 2008-12-09 09:00:00 | QQQ | ETF | 29.63 | 29.7 | 29.57 | 29.69 | 1080108.0 |
| 2008-12-09 09:30:00 | QQQ | ETF | 29.68 | 30.1 | 29.57 | 29.95 | 17209980.0 |
| 2008-12-09 10:00:00 | QQQ | ETF | 29.94 | 30.64 | 29.93 | 30.49 | 18097736.0 |
| 2008-12-09 10:30:00 | QQQ | ETF | 30.5 | 30.81 | 30.49 | 30.72 | 11615195.0 |
| 2008-12-09 11:00:00 | QQQ | ETF | 30.72 | 30.83 | 30.39 | 30.4 | 9118734.0 |
| 2008-12-09 11:30:00 | QQQ | ETF | 30.4 | 30.49 | 30.241 | 30.41 | 9698932.0 |
| 2008-12-09 12:00:00 | QQQ | ETF | 30.41 | 30.61 | 30.29 | 30.35 | 7105593.0 |
| 2008-12-09 12:30:00 | QQQ | ETF | 30.36 | 30.58 | 30.32 | 30.3399 | 6091797.0 |
| 2008-12-09 13:00:00 | QQQ | ETF | 30.34 | 30.42 | 30.03 | 30.05 | 9177891.0 |
| 2008-12-09 13:30:00 | QQQ | ETF | 30.04 | 30.25 | 29.94 | 30.0999 | 8494127.0 |
| 2008-12-09 14:00:00 | QQQ | ETF | 30.09 | 30.11 | 29.67 | 29.72 | 13177197.0 |
> showing 50 of 6,703 rows — these rows as CSV