PREVIEW / etf_30min / 2015-01-28
file: by_date/etf_30min/2015/2015-01-28.parquet size: 388 KB rows: 12,993
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 |
|---|---|---|---|---|---|---|---|
| 2015-01-28 04:00:00 | SPY | ETF | 204.02 | 204.02 | 203.8 | 203.92 | 1000.0 |
| 2015-01-28 04:30:00 | SPY | ETF | 204.08 | 204.29 | 204.08 | 204.29 | 850.0 |
| 2015-01-28 05:00:00 | SPY | ETF | 204.25 | 204.25 | 203.32 | 203.5 | 6475.0 |
| 2015-01-28 05:30:00 | SPY | ETF | 203.47 | 203.7 | 203.43 | 203.45 | 41305.0 |
| 2015-01-28 06:00:00 | SPY | ETF | 203.36 | 203.75 | 203.35 | 203.69 | 8306.0 |
| 2015-01-28 06:30:00 | SPY | ETF | 203.76 | 203.9 | 203.62 | 203.79 | 37510.0 |
| 2015-01-28 07:00:00 | SPY | ETF | 203.7 | 203.85 | 203.6 | 203.84 | 65872.0 |
| 2015-01-28 07:30:00 | SPY | ETF | 203.85 | 204.42 | 203.85 | 204.32 | 210172.0 |
| 2015-01-28 08:00:00 | SPY | ETF | 204.3 | 204.35 | 203.72 | 204.04 | 482785.0 |
| 2015-01-28 08:30:00 | SPY | ETF | 204.05 | 204.12 | 203.88 | 203.96 | 313363.0 |
| 2015-01-28 09:00:00 | SPY | ETF | 203.93 | 204.2 | 203.86 | 204.18 | 762658.0 |
| 2015-01-28 09:30:00 | SPY | ETF | 204.17 | 204.29 | 203.41 | 203.68 | 11827931.0 |
| 2015-01-28 10:00:00 | SPY | ETF | 203.69 | 203.97 | 203.38 | 203.43 | 8681704.0 |
| 2015-01-28 10:30:00 | SPY | ETF | 203.43 | 203.62 | 202.24 | 202.37 | 11004215.0 |
| 2015-01-28 11:00:00 | SPY | ETF | 202.37 | 202.81 | 202.05 | 202.46 | 9485340.0 |
| 2015-01-28 11:30:00 | SPY | ETF | 202.47 | 203.06 | 202.36 | 202.84 | 5808811.0 |
| 2015-01-28 12:00:00 | SPY | ETF | 202.85 | 203.48 | 202.816 | 203.405 | 4785292.0 |
| 2015-01-28 12:30:00 | SPY | ETF | 203.405 | 203.44 | 203.11 | 203.13 | 3111231.0 |
| 2015-01-28 13:00:00 | SPY | ETF | 203.12 | 203.1315 | 202.81 | 202.83 | 4087611.0 |
| 2015-01-28 13:30:00 | SPY | ETF | 202.83 | 203.23 | 202.72 | 202.75 | 5349834.0 |
| 2015-01-28 14:00:00 | SPY | ETF | 202.78 | 203.57 | 201.91 | 202.02 | 16453529.0 |
| 2015-01-28 14:30:00 | SPY | ETF | 202.0165 | 202.5251 | 201.51 | 202.21 | 12742502.0 |
| 2015-01-28 15:00:00 | SPY | ETF | 202.2 | 202.5 | 200.97 | 201.2101 | 14302719.0 |
| 2015-01-28 15:30:00 | SPY | ETF | 201.21 | 201.25 | 199.91 | 200.07 | 32712613.0 |
| 2015-01-28 16:00:00 | SPY | ETF | 200.04 | 204.0151 | 199.56 | 199.71 | 14714797.0 |
| 2015-01-28 16:30:00 | SPY | ETF | 199.72 | 199.92 | 199.59 | 199.87 | 6875337.0 |
| 2015-01-28 17:00:00 | SPY | ETF | 199.88 | 199.9 | 199.67 | 199.77 | 118754.0 |
| 2015-01-28 17:30:00 | SPY | ETF | 199.76 | 199.82 | 199.73 | 199.82 | 145052.0 |
| 2015-01-28 18:00:00 | SPY | ETF | 199.83 | 200.0 | 199.83 | 199.84 | 162967.0 |
| 2015-01-28 18:30:00 | SPY | ETF | 199.86 | 200.06 | 199.84 | 200.06 | 311772.0 |
| 2015-01-28 19:00:00 | SPY | ETF | 200.06 | 200.09 | 199.97 | 199.99 | 73901.0 |
| 2015-01-28 19:30:00 | SPY | ETF | 199.98 | 200.1 | 199.98 | 200.07 | 198264.0 |
| 2015-01-28 04:30:00 | QQQ | ETF | 102.87 | 103.0 | 102.87 | 103.0 | 3060.0 |
| 2015-01-28 05:00:00 | QQQ | ETF | 102.8 | 102.8 | 102.65 | 102.67 | 11000.0 |
| 2015-01-28 05:30:00 | QQQ | ETF | 102.62 | 102.62 | 102.62 | 102.62 | 1000.0 |
| 2015-01-28 06:00:00 | QQQ | ETF | 102.59 | 102.8 | 102.57 | 102.8 | 590.0 |
| 2015-01-28 06:30:00 | QQQ | ETF | 102.85 | 102.89 | 102.84 | 102.89 | 3700.0 |
| 2015-01-28 07:00:00 | QQQ | ETF | 102.76 | 102.94 | 102.76 | 102.94 | 67195.0 |
| 2015-01-28 07:30:00 | QQQ | ETF | 102.97 | 103.2 | 102.97 | 103.14 | 112230.0 |
| 2015-01-28 08:00:00 | QQQ | ETF | 103.1 | 103.11 | 102.93 | 102.95 | 156594.0 |
| 2015-01-28 08:30:00 | QQQ | ETF | 102.98 | 103.07 | 102.92 | 102.94 | 121445.0 |
| 2015-01-28 09:00:00 | QQQ | ETF | 102.94 | 103.14 | 102.9 | 103.08 | 287102.0 |
| 2015-01-28 09:30:00 | QQQ | ETF | 103.07 | 103.18 | 102.605 | 102.8667 | 5335640.0 |
| 2015-01-28 10:00:00 | QQQ | ETF | 102.87 | 103.065 | 102.64 | 102.69 | 2633757.0 |
| 2015-01-28 10:30:00 | QQQ | ETF | 102.69 | 102.78 | 101.93 | 101.99 | 2770176.0 |
| 2015-01-28 11:00:00 | QQQ | ETF | 101.995 | 102.25 | 101.75 | 102.02 | 2032119.0 |
| 2015-01-28 11:30:00 | QQQ | ETF | 102.02 | 102.3332 | 101.98 | 102.2 | 1447527.0 |
| 2015-01-28 12:00:00 | QQQ | ETF | 102.22 | 102.71 | 102.2 | 102.65 | 1368819.0 |
| 2015-01-28 12:30:00 | QQQ | ETF | 102.65 | 102.71 | 102.511 | 102.59 | 1363565.0 |
| 2015-01-28 13:00:00 | QQQ | ETF | 102.589 | 102.59 | 102.38 | 102.431 | 1028939.0 |
> showing 50 of 12,993 rows — these rows as CSV