PREVIEW / etf_30min / 2015-12-11
file: by_date/etf_30min/2015/2015-12-11.parquet size: 406 KB rows: 13,668
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-12-11 04:00:00 | SPY | ETF | 205.5 | 205.61 | 205.27 | 205.38 | 13729.0 |
| 2015-12-11 04:30:00 | SPY | ETF | 205.53 | 205.84 | 205.53 | 205.75 | 6869.0 |
| 2015-12-11 05:00:00 | SPY | ETF | 205.8 | 205.82 | 205.36 | 205.36 | 2462.0 |
| 2015-12-11 05:30:00 | SPY | ETF | 205.39 | 205.39 | 204.18 | 204.48 | 97869.0 |
| 2015-12-11 06:00:00 | SPY | ETF | 204.36 | 204.6 | 204.0 | 204.5 | 55847.0 |
| 2015-12-11 06:30:00 | SPY | ETF | 204.42 | 204.45 | 204.07 | 204.22 | 74784.0 |
| 2015-12-11 07:00:00 | SPY | ETF | 204.27 | 204.52 | 204.03 | 204.22 | 463154.0 |
| 2015-12-11 07:30:00 | SPY | ETF | 204.15 | 204.15 | 203.65 | 203.79 | 495320.0 |
| 2015-12-11 08:00:00 | SPY | ETF | 203.8 | 205.82 | 203.7 | 204.17 | 843628.0 |
| 2015-12-11 08:30:00 | SPY | ETF | 204.17 | 204.5 | 203.94 | 204.27 | 887693.0 |
| 2015-12-11 09:00:00 | SPY | ETF | 204.28 | 204.32 | 202.83 | 203.37 | 2837282.0 |
| 2015-12-11 09:30:00 | SPY | ETF | 203.35 | 203.8 | 202.75 | 203.019 | 25852529.0 |
| 2015-12-11 10:00:00 | SPY | ETF | 203.0 | 203.9499 | 202.83 | 203.87 | 18375543.0 |
| 2015-12-11 10:30:00 | SPY | ETF | 203.87 | 204.14 | 202.99 | 203.069 | 15053930.0 |
| 2015-12-11 11:00:00 | SPY | ETF | 203.05 | 203.55 | 202.85 | 203.1 | 9841330.0 |
| 2015-12-11 11:30:00 | SPY | ETF | 203.11 | 203.36 | 202.63 | 202.825 | 8776927.0 |
| 2015-12-11 12:00:00 | SPY | ETF | 202.84 | 202.93 | 202.0 | 202.26 | 12142074.0 |
| 2015-12-11 12:30:00 | SPY | ETF | 202.2599 | 202.48 | 202.0 | 202.43 | 8792609.0 |
| 2015-12-11 13:00:00 | SPY | ETF | 202.44 | 202.89 | 202.27 | 202.27 | 8341227.0 |
| 2015-12-11 13:30:00 | SPY | ETF | 202.27 | 202.75 | 202.15 | 202.5326 | 6760139.0 |
| 2015-12-11 14:00:00 | SPY | ETF | 202.53 | 203.11 | 202.51 | 202.64 | 10024963.0 |
| 2015-12-11 14:30:00 | SPY | ETF | 202.64 | 202.85 | 202.46 | 202.46 | 8630896.0 |
| 2015-12-11 15:00:00 | SPY | ETF | 202.47 | 202.69 | 201.51 | 201.87 | 19909129.0 |
| 2015-12-11 15:30:00 | SPY | ETF | 201.87 | 203.3002 | 201.63 | 201.85 | 33049165.0 |
| 2015-12-11 16:00:00 | SPY | ETF | 201.86 | 202.09 | 201.63 | 201.64 | 11319777.0 |
| 2015-12-11 16:30:00 | SPY | ETF | 201.67 | 201.88 | 201.27 | 201.5 | 4221276.0 |
| 2015-12-11 17:00:00 | SPY | ETF | 201.57 | 201.8926 | 201.45 | 201.49 | 2375619.0 |
| 2015-12-11 17:30:00 | SPY | ETF | 201.49 | 201.5 | 201.32 | 201.4 | 65061.0 |
| 2015-12-11 18:00:00 | SPY | ETF | 201.39 | 201.42 | 201.21 | 201.23 | 91894.0 |
| 2015-12-11 18:30:00 | SPY | ETF | 201.26 | 201.33 | 201.21 | 201.32 | 18175.0 |
| 2015-12-11 19:00:00 | SPY | ETF | 201.32 | 201.37 | 201.27 | 201.27 | 16145.0 |
| 2015-12-11 19:30:00 | SPY | ETF | 201.27 | 201.3 | 201.2 | 201.22 | 20544.0 |
| 2015-12-11 04:00:00 | QQQ | ETF | 113.26 | 113.3 | 113.22 | 113.22 | 8050.0 |
| 2015-12-11 05:00:00 | QQQ | ETF | 113.35 | 113.35 | 113.19 | 113.19 | 500.0 |
| 2015-12-11 05:30:00 | QQQ | ETF | 113.17 | 113.17 | 112.6 | 112.6 | 29600.0 |
| 2015-12-11 06:00:00 | QQQ | ETF | 112.72 | 112.73 | 112.36 | 112.73 | 22050.0 |
| 2015-12-11 06:30:00 | QQQ | ETF | 112.58 | 112.6 | 112.42 | 112.57 | 24050.0 |
| 2015-12-11 07:00:00 | QQQ | ETF | 112.63 | 112.73 | 112.46 | 112.46 | 24530.0 |
| 2015-12-11 07:30:00 | QQQ | ETF | 112.53 | 112.53 | 112.22 | 112.22 | 43548.0 |
| 2015-12-11 08:00:00 | QQQ | ETF | 112.26 | 113.5 | 112.21 | 112.47 | 314834.0 |
| 2015-12-11 08:30:00 | QQQ | ETF | 112.51 | 112.67 | 112.38 | 112.57 | 117395.0 |
| 2015-12-11 09:00:00 | QQQ | ETF | 112.57 | 112.57 | 111.94 | 112.08 | 612224.0 |
| 2015-12-11 09:30:00 | QQQ | ETF | 112.09 | 112.39 | 111.7005 | 111.88 | 7208347.0 |
| 2015-12-11 10:00:00 | QQQ | ETF | 111.89 | 112.6 | 111.76 | 112.23 | 4943612.0 |
| 2015-12-11 10:30:00 | QQQ | ETF | 112.21 | 112.3 | 111.65 | 111.74 | 3457432.0 |
| 2015-12-11 11:00:00 | QQQ | ETF | 111.75 | 111.93 | 111.55 | 111.61 | 3253003.0 |
| 2015-12-11 11:30:00 | QQQ | ETF | 111.62 | 111.74 | 111.39 | 111.42 | 2402812.0 |
| 2015-12-11 12:00:00 | QQQ | ETF | 111.43 | 111.5 | 110.9184 | 111.11 | 3838513.0 |
| 2015-12-11 12:30:00 | QQQ | ETF | 111.1 | 111.3 | 110.95 | 111.21 | 2961622.0 |
| 2015-12-11 13:00:00 | QQQ | ETF | 111.21 | 111.52 | 111.14 | 111.17 | 1976440.0 |
> showing 50 of 13,668 rows — these rows as CSV