PREVIEW / etf_30min / 2015-08-21
file: by_date/etf_30min/2015/2015-08-21.parquet size: 435 KB rows: 14,450
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-08-21 04:00:00 | SPY | ETF | 203.15 | 203.25 | 202.94 | 203.25 | 23274.0 |
| 2015-08-21 04:30:00 | SPY | ETF | 203.27 | 203.32 | 202.97 | 203.19 | 78312.0 |
| 2015-08-21 05:00:00 | SPY | ETF | 203.31 | 203.56 | 203.23 | 203.46 | 34152.0 |
| 2015-08-21 05:30:00 | SPY | ETF | 203.4 | 203.55 | 202.94 | 203.08 | 47750.0 |
| 2015-08-21 06:00:00 | SPY | ETF | 203.08 | 203.14 | 202.72 | 202.72 | 86923.0 |
| 2015-08-21 06:30:00 | SPY | ETF | 202.73 | 202.9 | 202.6 | 202.82 | 96346.0 |
| 2015-08-21 07:00:00 | SPY | ETF | 202.82 | 202.98 | 202.46 | 202.74 | 178944.0 |
| 2015-08-21 07:30:00 | SPY | ETF | 202.83 | 203.1 | 202.6 | 202.7 | 399710.0 |
| 2015-08-21 08:00:00 | SPY | ETF | 202.73 | 203.05 | 202.25 | 202.56 | 1055366.0 |
| 2015-08-21 08:30:00 | SPY | ETF | 202.6 | 202.79 | 202.46 | 202.65 | 577416.0 |
| 2015-08-21 09:00:00 | SPY | ETF | 202.65 | 203.4 | 201.61 | 201.72 | 3546895.0 |
| 2015-08-21 09:30:00 | SPY | ETF | 201.73 | 202.39 | 201.47 | 202.23 | 32771522.0 |
| 2015-08-21 10:00:00 | SPY | ETF | 202.2301 | 202.92 | 201.88 | 201.91 | 24819153.0 |
| 2015-08-21 10:30:00 | SPY | ETF | 201.92 | 203.9404 | 200.95 | 201.15 | 25886427.0 |
| 2015-08-21 11:00:00 | SPY | ETF | 201.16 | 201.23 | 199.97 | 200.376 | 23126476.0 |
| 2015-08-21 11:30:00 | SPY | ETF | 200.37 | 200.8 | 199.66 | 200.6501 | 23175386.0 |
| 2015-08-21 12:00:00 | SPY | ETF | 200.65 | 201.35 | 200.36 | 200.46 | 21484998.0 |
| 2015-08-21 12:30:00 | SPY | ETF | 200.465 | 200.77 | 199.585 | 199.61 | 13238837.0 |
| 2015-08-21 13:00:00 | SPY | ETF | 199.605 | 200.34 | 199.34 | 200.33 | 15761913.0 |
| 2015-08-21 13:30:00 | SPY | ETF | 200.335 | 200.71 | 199.9 | 200.68 | 15640733.0 |
| 2015-08-21 14:00:00 | SPY | ETF | 200.675 | 200.94 | 200.08 | 200.26 | 14705096.0 |
| 2015-08-21 14:30:00 | SPY | ETF | 200.26 | 200.45 | 198.89 | 199.15 | 20054219.0 |
| 2015-08-21 15:00:00 | SPY | ETF | 199.16 | 199.36 | 197.91 | 198.52 | 25640514.0 |
| 2015-08-21 15:30:00 | SPY | ETF | 198.52 | 199.4 | 197.53 | 197.54 | 49793646.0 |
| 2015-08-21 16:00:00 | SPY | ETF | 197.53 | 203.9404 | 197.52 | 197.84 | 19529449.0 |
| 2015-08-21 16:30:00 | SPY | ETF | 197.84 | 200.81 | 197.47 | 197.7 | 5908933.0 |
| 2015-08-21 17:00:00 | SPY | ETF | 197.66 | 202.16 | 197.5 | 197.6 | 1956483.0 |
| 2015-08-21 17:30:00 | SPY | ETF | 197.6 | 197.66 | 197.58 | 197.6 | 154823.0 |
| 2015-08-21 18:00:00 | SPY | ETF | 197.6 | 197.88 | 197.48 | 197.88 | 2781915.0 |
| 2015-08-21 18:30:00 | SPY | ETF | 197.87 | 197.96 | 197.81 | 197.91 | 73500.0 |
| 2015-08-21 19:00:00 | SPY | ETF | 197.91 | 197.92 | 197.87 | 197.92 | 17561.0 |
| 2015-08-21 19:30:00 | SPY | ETF | 197.89 | 197.96 | 197.86 | 197.92 | 31659.0 |
| 2015-08-21 04:00:00 | QQQ | ETF | 106.56 | 106.56 | 106.39 | 106.48 | 19500.0 |
| 2015-08-21 04:30:00 | QQQ | ETF | 106.47 | 106.5 | 106.29 | 106.4 | 37810.0 |
| 2015-08-21 05:00:00 | QQQ | ETF | 106.49 | 106.54 | 106.46 | 106.46 | 5300.0 |
| 2015-08-21 05:30:00 | QQQ | ETF | 106.47 | 106.53 | 106.27 | 106.29 | 36250.0 |
| 2015-08-21 06:00:00 | QQQ | ETF | 106.35 | 106.35 | 106.11 | 106.11 | 33699.0 |
| 2015-08-21 06:30:00 | QQQ | ETF | 106.1 | 106.22 | 106.04 | 106.22 | 18800.0 |
| 2015-08-21 07:00:00 | QQQ | ETF | 106.22 | 106.26 | 106.01 | 106.15 | 17043.0 |
| 2015-08-21 07:30:00 | QQQ | ETF | 106.15 | 106.32 | 106.11 | 106.14 | 139150.0 |
| 2015-08-21 08:00:00 | QQQ | ETF | 106.18 | 106.23 | 105.85 | 105.97 | 138877.0 |
| 2015-08-21 08:30:00 | QQQ | ETF | 105.99 | 106.09 | 105.9 | 105.99 | 90205.0 |
| 2015-08-21 09:00:00 | QQQ | ETF | 106.01 | 106.14 | 105.55 | 105.57 | 619836.0 |
| 2015-08-21 09:30:00 | QQQ | ETF | 105.57 | 106.11 | 105.07 | 106.051 | 11317366.0 |
| 2015-08-21 10:00:00 | QQQ | ETF | 106.05 | 106.47 | 105.75 | 105.76 | 6675418.0 |
| 2015-08-21 10:30:00 | QQQ | ETF | 105.76 | 105.857 | 104.91 | 105.12 | 5806830.0 |
| 2015-08-21 11:00:00 | QQQ | ETF | 105.12 | 105.16 | 104.32 | 104.66 | 7273810.0 |
| 2015-08-21 11:30:00 | QQQ | ETF | 104.66 | 104.87 | 104.16 | 104.76 | 4741014.0 |
| 2015-08-21 12:00:00 | QQQ | ETF | 104.76 | 105.16 | 104.54 | 104.59 | 4070483.0 |
| 2015-08-21 12:30:00 | QQQ | ETF | 104.59 | 104.78 | 104.1 | 104.1036 | 4293742.0 |
> showing 50 of 14,450 rows — these rows as CSV