PREVIEW / etf_30min / 2015-10-21
file: by_date/etf_30min/2015/2015-10-21.parquet size: 370 KB rows: 12,489
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-10-21 04:00:00 | SPY | ETF | 202.8 | 203.18 | 202.8 | 202.99 | 44140.0 |
| 2015-10-21 04:30:00 | SPY | ETF | 203.02 | 203.17 | 203.01 | 203.17 | 7906.0 |
| 2015-10-21 05:00:00 | SPY | ETF | 203.17 | 203.62 | 203.17 | 203.47 | 18165.0 |
| 2015-10-21 05:30:00 | SPY | ETF | 203.6 | 203.64 | 203.47 | 203.52 | 7680.0 |
| 2015-10-21 06:00:00 | SPY | ETF | 203.52 | 203.85 | 203.5 | 203.72 | 18209.0 |
| 2015-10-21 06:30:00 | SPY | ETF | 203.77 | 203.83 | 203.57 | 203.62 | 98084.0 |
| 2015-10-21 07:00:00 | SPY | ETF | 203.58 | 203.61 | 203.5 | 203.61 | 271237.0 |
| 2015-10-21 07:30:00 | SPY | ETF | 203.66 | 203.75 | 203.57 | 203.63 | 239621.0 |
| 2015-10-21 08:00:00 | SPY | ETF | 203.62 | 203.73 | 203.54 | 203.58 | 178902.0 |
| 2015-10-21 08:30:00 | SPY | ETF | 203.57 | 203.69 | 203.55 | 203.61 | 166423.0 |
| 2015-10-21 09:00:00 | SPY | ETF | 203.61 | 203.77 | 203.51 | 203.62 | 859392.0 |
| 2015-10-21 09:30:00 | SPY | ETF | 203.61 | 203.79 | 203.25 | 203.43 | 9230060.0 |
| 2015-10-21 10:00:00 | SPY | ETF | 203.42 | 203.42 | 202.6 | 202.76 | 9196727.0 |
| 2015-10-21 10:30:00 | SPY | ETF | 202.755 | 203.17 | 202.52 | 203.095 | 8909699.0 |
| 2015-10-21 11:00:00 | SPY | ETF | 203.09 | 203.29 | 202.58 | 203.14 | 6372815.0 |
| 2015-10-21 11:30:00 | SPY | ETF | 203.14 | 203.5 | 203.12 | 203.285 | 5596524.0 |
| 2015-10-21 12:00:00 | SPY | ETF | 203.29 | 203.42 | 203.18 | 203.34 | 2803168.0 |
| 2015-10-21 12:30:00 | SPY | ETF | 203.34 | 203.47 | 203.08 | 203.09 | 3821784.0 |
| 2015-10-21 13:00:00 | SPY | ETF | 203.09 | 203.09 | 201.98 | 202.0192 | 9489114.0 |
| 2015-10-21 13:30:00 | SPY | ETF | 202.01 | 202.53 | 201.93 | 202.25 | 8021842.0 |
| 2015-10-21 14:00:00 | SPY | ETF | 202.25 | 202.53 | 202.06 | 202.43 | 4765557.0 |
| 2015-10-21 14:30:00 | SPY | ETF | 202.435 | 203.07 | 202.42 | 202.76 | 6994473.0 |
| 2015-10-21 15:00:00 | SPY | ETF | 202.77 | 203.05 | 202.21 | 202.43 | 6624149.0 |
| 2015-10-21 15:30:00 | SPY | ETF | 202.42 | 202.43 | 201.65 | 201.82 | 11516979.0 |
| 2015-10-21 16:00:00 | SPY | ETF | 201.82 | 201.98 | 201.49 | 201.56 | 4851833.0 |
| 2015-10-21 16:30:00 | SPY | ETF | 201.54 | 201.85 | 201.44 | 201.78 | 822123.0 |
| 2015-10-21 17:00:00 | SPY | ETF | 201.74 | 201.87 | 201.71 | 201.81 | 528792.0 |
| 2015-10-21 17:30:00 | SPY | ETF | 201.8 | 201.82 | 201.68 | 201.74 | 59550.0 |
| 2015-10-21 18:00:00 | SPY | ETF | 201.77 | 201.85 | 201.7 | 201.84 | 85547.0 |
| 2015-10-21 18:30:00 | SPY | ETF | 201.84 | 201.84 | 201.69 | 201.69 | 19512.0 |
| 2015-10-21 19:00:00 | SPY | ETF | 201.72 | 201.73 | 201.56 | 201.73 | 22074.0 |
| 2015-10-21 19:30:00 | SPY | ETF | 201.73 | 201.75 | 201.65 | 201.72 | 13497.0 |
| 2015-10-21 04:00:00 | QQQ | ETF | 108.09 | 108.19 | 108.09 | 108.19 | 6650.0 |
| 2015-10-21 05:00:00 | QQQ | ETF | 108.27 | 108.51 | 108.27 | 108.47 | 13370.0 |
| 2015-10-21 05:30:00 | QQQ | ETF | 108.5 | 108.5 | 108.46 | 108.48 | 7834.0 |
| 2015-10-21 06:00:00 | QQQ | ETF | 108.46 | 108.61 | 108.44 | 108.61 | 2400.0 |
| 2015-10-21 06:30:00 | QQQ | ETF | 108.58 | 108.58 | 108.58 | 108.58 | 338.0 |
| 2015-10-21 07:00:00 | QQQ | ETF | 108.48 | 108.55 | 108.47 | 108.53 | 26745.0 |
| 2015-10-21 07:30:00 | QQQ | ETF | 108.53 | 108.61 | 108.52 | 108.53 | 25998.0 |
| 2015-10-21 08:00:00 | QQQ | ETF | 108.54 | 108.74 | 108.54 | 108.63 | 59942.0 |
| 2015-10-21 08:30:00 | QQQ | ETF | 108.62 | 108.71 | 108.62 | 108.66 | 34410.0 |
| 2015-10-21 09:00:00 | QQQ | ETF | 108.67 | 108.75 | 108.63 | 108.73 | 99171.0 |
| 2015-10-21 09:30:00 | QQQ | ETF | 108.73 | 108.84 | 108.36 | 108.639 | 3182412.0 |
| 2015-10-21 10:00:00 | QQQ | ETF | 108.62 | 108.62 | 107.92 | 108.069 | 2639824.0 |
| 2015-10-21 10:30:00 | QQQ | ETF | 108.06 | 108.5 | 107.94 | 108.39 | 2305086.0 |
| 2015-10-21 11:00:00 | QQQ | ETF | 108.4 | 108.4679 | 107.98 | 108.4 | 1875488.0 |
| 2015-10-21 11:30:00 | QQQ | ETF | 108.41 | 108.7 | 108.39 | 108.5462 | 1287851.0 |
| 2015-10-21 12:00:00 | QQQ | ETF | 108.545 | 108.66 | 108.46 | 108.62 | 830232.0 |
| 2015-10-21 12:30:00 | QQQ | ETF | 108.625 | 108.67 | 108.3 | 108.301 | 610639.0 |
| 2015-10-21 13:00:00 | QQQ | ETF | 108.3001 | 108.3001 | 107.57 | 107.6 | 2184187.0 |
> showing 50 of 12,489 rows — these rows as CSV