PREVIEW / etf_1hour / 2016-12-07

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-12-07.parquet
  size:    281 KB
  rows:    8,956

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-12-07 04:00:00	SPY	ETF	221.78	221.86	221.6	221.67	21841.0
2016-12-07 05:00:00	SPY	ETF	221.7	221.76	221.67	221.67	4710.0
2016-12-07 06:00:00	SPY	ETF	221.71	221.73	221.63	221.63	25179.0
2016-12-07 07:00:00	SPY	ETF	221.65	221.65	221.5	221.54	100110.0
2016-12-07 08:00:00	SPY	ETF	221.55	221.56	221.25	221.45	520812.0
2016-12-07 09:00:00	SPY	ETF	221.46	221.63	221.38	221.395	4948575.0
2016-12-07 10:00:00	SPY	ETF	221.39	221.965	221.39	221.916	9976761.0
2016-12-07 11:00:00	SPY	ETF	221.915	222.32	221.79	222.3134	7367956.0
2016-12-07 12:00:00	SPY	ETF	222.32	222.77	222.22	222.76	6802410.0
2016-12-07 13:00:00	SPY	ETF	222.77	223.98	222.76	223.92	22217574.0
2016-12-07 14:00:00	SPY	ETF	223.93	224.11	223.7	224.0	15507438.0
2016-12-07 15:00:00	SPY	ETF	224.0	224.67	223.8	224.57	28697479.0
2016-12-07 16:00:00	SPY	ETF	224.58	224.64	224.09	224.25	10530647.0
2016-12-07 17:00:00	SPY	ETF	224.24	224.6	224.2	224.27	286203.0
2016-12-07 18:00:00	SPY	ETF	224.27	224.3	224.03	224.27	409772.0
2016-12-07 19:00:00	SPY	ETF	224.27	224.38	224.26	224.35	58645.0
2016-12-07 04:00:00	QQQ	ETF	116.93	117.0	116.93	116.94	1696.0
2016-12-07 05:00:00	QQQ	ETF	116.9	116.93	116.9	116.91	1384.0
2016-12-07 06:00:00	QQQ	ETF	116.88	116.88	116.87	116.87	2292.0
2016-12-07 07:00:00	QQQ	ETF	116.82	116.84	116.82	116.82	1715.0
2016-12-07 08:00:00	QQQ	ETF	116.82	116.82	116.58	116.61	68427.0
2016-12-07 09:00:00	QQQ	ETF	116.6	116.79	116.2919	116.2919	2258085.0
2016-12-07 10:00:00	QQQ	ETF	116.3	116.99	116.3	116.88	2347788.0
2016-12-07 11:00:00	QQQ	ETF	116.89	117.01	116.65	116.9908	1544608.0
2016-12-07 12:00:00	QQQ	ETF	117.01	117.375	116.93	117.37	1727712.0
2016-12-07 13:00:00	QQQ	ETF	117.36	117.88	117.35	117.84	5043398.0
2016-12-07 14:00:00	QQQ	ETF	117.841	118.265	117.72	118.23	2980323.0
2016-12-07 15:00:00	QQQ	ETF	118.23	118.51	118.09	118.38	5669949.0
2016-12-07 16:00:00	QQQ	ETF	118.36	118.4287	118.16	118.25	1712243.0
2016-12-07 17:00:00	QQQ	ETF	118.18	118.36	118.18	118.28	64329.0
2016-12-07 18:00:00	QQQ	ETF	118.14	118.2	118.11	118.2	16397.0
2016-12-07 19:00:00	QQQ	ETF	118.28	118.33	118.27	118.3	9573.0
2016-12-07 04:00:00	IWM	ETF	134.57	134.57	134.57	134.57	299.0
2016-12-07 05:00:00	IWM	ETF	134.61	134.61	134.6	134.6	416.0
2016-12-07 06:00:00	IWM	ETF	134.58	134.58	134.58	134.58	100.0
2016-12-07 07:00:00	IWM	ETF	134.55	134.55	134.47	134.54	8688.0
2016-12-07 08:00:00	IWM	ETF	134.45	134.6	134.39	134.6	92123.0
2016-12-07 09:00:00	IWM	ETF	134.61	134.72	134.18	134.2065	2568922.0
2016-12-07 10:00:00	IWM	ETF	134.205	134.74	134.205	134.68	3364839.0
2016-12-07 11:00:00	IWM	ETF	134.68	135.19	134.42	135.1001	3833550.0
2016-12-07 12:00:00	IWM	ETF	135.11	135.45	135.05	135.45	2909886.0
2016-12-07 13:00:00	IWM	ETF	135.45	135.67	135.3	135.5489	3878497.0
2016-12-07 14:00:00	IWM	ETF	135.55	135.9182	135.41	135.8548	2684730.0
2016-12-07 15:00:00	IWM	ETF	135.86	136.18	135.67	135.87	7353939.0
2016-12-07 16:00:00	IWM	ETF	135.86	135.94	135.63	135.94	1628041.0
2016-12-07 17:00:00	IWM	ETF	135.91	135.97	135.9	135.97	13006.0
2016-12-07 18:00:00	IWM	ETF	135.95	135.95	135.81	135.82	14939.0
2016-12-07 19:00:00	IWM	ETF	135.87	135.98	135.87	135.98	4464.0
2016-12-07 05:00:00	DIA	ETF	192.56	192.56	192.56	192.56	100.0
2016-12-07 06:00:00	DIA	ETF	192.56	192.56	192.56	192.56	100.0

> showing 50 of 8,956 rows — these rows as CSV

> unlock the full archive -- $79 one-time