PREVIEW / etf_30min / 2011-02-04
file: by_date/etf_30min/2011/2011-02-04.parquet size: 275 KB rows: 9,097
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 |
|---|---|---|---|---|---|---|---|
| 2011-02-04 04:00:00 | SPY | ETF | 130.72 | 130.75 | 130.71 | 130.75 | 890.0 |
| 2011-02-04 04:30:00 | SPY | ETF | 130.75 | 130.79 | 130.75 | 130.79 | 2410.0 |
| 2011-02-04 05:00:00 | SPY | ETF | 130.82 | 130.82 | 130.82 | 130.82 | 200.0 |
| 2011-02-04 05:30:00 | SPY | ETF | 130.81 | 130.81 | 130.81 | 130.81 | 400.0 |
| 2011-02-04 06:00:00 | SPY | ETF | 130.75 | 130.75 | 130.75 | 130.75 | 200.0 |
| 2011-02-04 06:30:00 | SPY | ETF | 130.8 | 130.81 | 130.8 | 130.8 | 3200.0 |
| 2011-02-04 07:00:00 | SPY | ETF | 130.77 | 130.87 | 130.76 | 130.84 | 222200.0 |
| 2011-02-04 07:30:00 | SPY | ETF | 130.84 | 130.92 | 130.84 | 130.9 | 129095.0 |
| 2011-02-04 08:00:00 | SPY | ETF | 130.89 | 131.24 | 130.87 | 131.14 | 1368685.0 |
| 2011-02-04 08:30:00 | SPY | ETF | 131.08 | 131.21 | 130.5 | 130.88 | 6855519.0 |
| 2011-02-04 09:00:00 | SPY | ETF | 130.89 | 131.02 | 130.83 | 130.83 | 771570.0 |
| 2011-02-04 09:30:00 | SPY | ETF | 130.83 | 131.02 | 130.43 | 130.77 | 17357094.0 |
| 2011-02-04 10:00:00 | SPY | ETF | 130.78 | 131.01 | 130.64 | 130.94 | 10447005.0 |
| 2011-02-04 10:30:00 | SPY | ETF | 130.94 | 130.97 | 130.28 | 130.43 | 13030154.0 |
| 2011-02-04 11:00:00 | SPY | ETF | 130.43 | 130.68 | 130.23 | 130.6 | 11243134.0 |
| 2011-02-04 11:30:00 | SPY | ETF | 130.61 | 130.75 | 130.57 | 130.6 | 5798243.0 |
| 2011-02-04 12:00:00 | SPY | ETF | 130.59 | 130.72 | 130.5 | 130.66 | 5636652.0 |
| 2011-02-04 12:30:00 | SPY | ETF | 130.66 | 130.8 | 130.65 | 130.77 | 3263886.0 |
| 2011-02-04 13:00:00 | SPY | ETF | 130.77 | 130.99 | 130.73 | 130.91 | 6764510.0 |
| 2011-02-04 13:30:00 | SPY | ETF | 130.92 | 131.0 | 130.84 | 130.97 | 4745231.0 |
| 2011-02-04 14:00:00 | SPY | ETF | 130.98 | 130.99 | 130.84 | 130.94 | 4732926.0 |
| 2011-02-04 14:30:00 | SPY | ETF | 130.94 | 130.98 | 130.79 | 130.97 | 4253266.0 |
| 2011-02-04 15:00:00 | SPY | ETF | 130.97 | 131.09 | 130.87 | 131.01 | 8135670.0 |
| 2011-02-04 15:30:00 | SPY | ETF | 131.01 | 131.2 | 130.99 | 131.15 | 15096368.0 |
| 2011-02-04 16:00:00 | SPY | ETF | 131.16 | 131.45 | 130.8076 | 131.09 | 11568214.0 |
| 2011-02-04 16:30:00 | SPY | ETF | 131.09 | 131.14 | 130.8075 | 131.14 | 1400117.0 |
| 2011-02-04 17:00:00 | SPY | ETF | 131.14 | 131.18 | 131.12 | 131.15 | 110024.0 |
| 2011-02-04 17:30:00 | SPY | ETF | 131.12 | 131.17 | 131.12 | 131.14 | 101353.0 |
| 2011-02-04 18:00:00 | SPY | ETF | 131.16 | 131.21 | 131.15 | 131.21 | 24175.0 |
| 2011-02-04 18:30:00 | SPY | ETF | 131.22 | 131.22 | 131.17 | 131.2 | 3340.0 |
| 2011-02-04 19:00:00 | SPY | ETF | 131.18 | 131.23 | 131.18 | 131.22 | 21880.0 |
| 2011-02-04 19:30:00 | SPY | ETF | 131.22 | 131.24 | 131.16 | 131.22 | 6678.0 |
| 2011-02-04 06:00:00 | QQQ | ETF | 57.06 | 57.06 | 57.06 | 57.06 | 2700.0 |
| 2011-02-04 06:30:00 | QQQ | ETF | 57.07 | 57.07 | 57.07 | 57.07 | 1000.0 |
| 2011-02-04 07:00:00 | QQQ | ETF | 57.04 | 57.09 | 57.04 | 57.09 | 1500.0 |
| 2011-02-04 07:30:00 | QQQ | ETF | 57.1 | 57.12 | 57.09 | 57.12 | 110741.0 |
| 2011-02-04 08:00:00 | QQQ | ETF | 57.09 | 57.44 | 57.07 | 57.23 | 368687.0 |
| 2011-02-04 08:30:00 | QQQ | ETF | 57.17 | 57.3 | 56.92 | 57.08 | 1789817.0 |
| 2011-02-04 09:00:00 | QQQ | ETF | 57.09 | 57.11 | 57.04 | 57.06 | 316362.0 |
| 2011-02-04 09:30:00 | QQQ | ETF | 57.05 | 57.18 | 56.9 | 57.1389 | 7155926.0 |
| 2011-02-04 10:00:00 | QQQ | ETF | 57.13 | 57.25 | 57.06 | 57.2099 | 3865528.0 |
| 2011-02-04 10:30:00 | QQQ | ETF | 57.209 | 57.23 | 56.95 | 57.0301 | 3093122.0 |
| 2011-02-04 11:00:00 | QQQ | ETF | 57.02 | 57.12 | 56.93 | 57.08 | 5670161.0 |
| 2011-02-04 11:30:00 | QQQ | ETF | 57.09 | 57.13 | 57.06 | 57.0881 | 1625652.0 |
| 2011-02-04 12:00:00 | QQQ | ETF | 57.085 | 57.16 | 57.0698 | 57.125 | 994764.0 |
| 2011-02-04 12:30:00 | QQQ | ETF | 57.13 | 57.23 | 57.12 | 57.22 | 963028.0 |
| 2011-02-04 13:00:00 | QQQ | ETF | 57.2251 | 57.4 | 57.19 | 57.37 | 4165587.0 |
| 2011-02-04 13:30:00 | QQQ | ETF | 57.38 | 57.41 | 57.33 | 57.39 | 1583737.0 |
| 2011-02-04 14:00:00 | QQQ | ETF | 57.38 | 57.39 | 57.29 | 57.35 | 1671442.0 |
| 2011-02-04 14:30:00 | QQQ | ETF | 57.35 | 57.3689 | 57.29 | 57.36 | 1718709.0 |
> showing 50 of 9,097 rows — these rows as CSV