PREVIEW / etf_30min / 2016-03-14
file: by_date/etf_30min/2016/2016-03-14.parquet size: 384 KB rows: 13,080
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 |
|---|---|---|---|---|---|---|---|
| 2016-03-14 04:00:00 | SPY | ETF | 202.28 | 202.65 | 202.25 | 202.62 | 29793.0 |
| 2016-03-14 04:30:00 | SPY | ETF | 202.53 | 202.53 | 202.25 | 202.25 | 4881.0 |
| 2016-03-14 05:00:00 | SPY | ETF | 202.41 | 202.44 | 202.29 | 202.42 | 7513.0 |
| 2016-03-14 05:30:00 | SPY | ETF | 202.43 | 202.6 | 202.23 | 202.23 | 11223.0 |
| 2016-03-14 06:00:00 | SPY | ETF | 202.2 | 202.31 | 202.1 | 202.28 | 11708.0 |
| 2016-03-14 06:30:00 | SPY | ETF | 202.25 | 202.39 | 202.23 | 202.25 | 16580.0 |
| 2016-03-14 07:00:00 | SPY | ETF | 202.25 | 202.25 | 202.16 | 202.21 | 80072.0 |
| 2016-03-14 07:30:00 | SPY | ETF | 202.27 | 202.28 | 201.98 | 202.01 | 266995.0 |
| 2016-03-14 08:00:00 | SPY | ETF | 202.05 | 202.64 | 201.99 | 202.14 | 488305.0 |
| 2016-03-14 08:30:00 | SPY | ETF | 202.15 | 202.18 | 202.04 | 202.06 | 255800.0 |
| 2016-03-14 09:00:00 | SPY | ETF | 202.06 | 202.19 | 202.0 | 202.14 | 403410.0 |
| 2016-03-14 09:30:00 | SPY | ETF | 202.16 | 202.4 | 201.8 | 201.85 | 8953662.0 |
| 2016-03-14 10:00:00 | SPY | ETF | 201.85 | 202.18 | 201.77 | 202.075 | 5632410.0 |
| 2016-03-14 10:30:00 | SPY | ETF | 202.07 | 202.5263 | 202.04 | 202.185 | 5058706.0 |
| 2016-03-14 11:00:00 | SPY | ETF | 202.18 | 202.45 | 202.06 | 202.26 | 3564531.0 |
| 2016-03-14 11:30:00 | SPY | ETF | 202.27 | 202.39 | 202.04 | 202.1 | 2799125.0 |
| 2016-03-14 12:00:00 | SPY | ETF | 202.1 | 202.51 | 202.01 | 202.39 | 3713614.0 |
| 2016-03-14 12:30:00 | SPY | ETF | 202.39 | 202.65 | 202.39 | 202.61 | 2881973.0 |
| 2016-03-14 13:00:00 | SPY | ETF | 202.61 | 202.72 | 202.5299 | 202.62 | 3775928.0 |
| 2016-03-14 13:30:00 | SPY | ETF | 202.62 | 202.75 | 202.5599 | 202.59 | 2742274.0 |
| 2016-03-14 14:00:00 | SPY | ETF | 202.58 | 202.67 | 202.38 | 202.65 | 4956280.0 |
| 2016-03-14 14:30:00 | SPY | ETF | 202.66 | 202.925 | 202.63 | 202.84 | 5316622.0 |
| 2016-03-14 15:00:00 | SPY | ETF | 202.84 | 203.04 | 202.66 | 202.94 | 5790732.0 |
| 2016-03-14 15:30:00 | SPY | ETF | 202.935 | 202.97 | 202.48 | 202.495 | 10898177.0 |
| 2016-03-14 16:00:00 | SPY | ETF | 202.5 | 202.64 | 202.43 | 202.43 | 4227570.0 |
| 2016-03-14 16:30:00 | SPY | ETF | 202.45 | 202.53 | 202.45 | 202.46 | 91456.0 |
| 2016-03-14 17:00:00 | SPY | ETF | 202.51 | 202.54 | 202.46 | 202.54 | 22574.0 |
| 2016-03-14 17:30:00 | SPY | ETF | 202.53 | 202.53 | 202.45 | 202.45 | 27739.0 |
| 2016-03-14 18:00:00 | SPY | ETF | 202.47 | 202.53 | 202.42 | 202.53 | 20955.0 |
| 2016-03-14 18:30:00 | SPY | ETF | 202.53 | 202.53 | 202.48 | 202.51 | 24292.0 |
| 2016-03-14 19:00:00 | SPY | ETF | 202.51 | 202.51 | 202.47 | 202.48 | 11916.0 |
| 2016-03-14 19:30:00 | SPY | ETF | 202.49 | 202.56 | 202.47 | 202.5 | 65380.0 |
| 2016-03-14 04:30:00 | QQQ | ETF | 106.43 | 106.43 | 106.22 | 106.22 | 460.0 |
| 2016-03-14 05:30:00 | QQQ | ETF | 106.38 | 106.38 | 106.38 | 106.38 | 300.0 |
| 2016-03-14 06:00:00 | QQQ | ETF | 106.15 | 106.19 | 106.15 | 106.19 | 800.0 |
| 2016-03-14 06:30:00 | QQQ | ETF | 106.24 | 106.25 | 106.21 | 106.21 | 650.0 |
| 2016-03-14 07:00:00 | QQQ | ETF | 106.22 | 106.22 | 106.15 | 106.15 | 7587.0 |
| 2016-03-14 07:30:00 | QQQ | ETF | 106.16 | 106.16 | 106.01 | 106.01 | 2800.0 |
| 2016-03-14 08:00:00 | QQQ | ETF | 106.16 | 106.16 | 106.0 | 106.04 | 18345.0 |
| 2016-03-14 08:30:00 | QQQ | ETF | 106.05 | 106.06 | 106.02 | 106.04 | 84555.0 |
| 2016-03-14 09:00:00 | QQQ | ETF | 106.05 | 106.09 | 106.01 | 106.07 | 45023.0 |
| 2016-03-14 09:30:00 | QQQ | ETF | 106.08 | 106.4 | 106.06 | 106.19 | 3029392.0 |
| 2016-03-14 10:00:00 | QQQ | ETF | 106.19 | 106.45 | 106.17 | 106.43 | 1490135.0 |
| 2016-03-14 10:30:00 | QQQ | ETF | 106.43 | 106.69 | 106.41 | 106.51 | 1818988.0 |
| 2016-03-14 11:00:00 | QQQ | ETF | 106.51 | 106.75 | 106.465 | 106.64 | 1078939.0 |
| 2016-03-14 11:30:00 | QQQ | ETF | 106.64 | 106.7285 | 106.52 | 106.55 | 965619.0 |
| 2016-03-14 12:00:00 | QQQ | ETF | 106.55 | 106.81 | 106.515 | 106.72 | 1110167.0 |
| 2016-03-14 12:30:00 | QQQ | ETF | 106.72 | 106.84 | 106.71 | 106.8 | 802412.0 |
| 2016-03-14 13:00:00 | QQQ | ETF | 106.81 | 106.84 | 106.72 | 106.79 | 694012.0 |
| 2016-03-14 13:30:00 | QQQ | ETF | 106.785 | 106.82 | 106.71 | 106.72 | 525945.0 |
> showing 50 of 13,080 rows — these rows as CSV