PREVIEW / etf_1hour / 2015-11-09

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-11-09.parquet
  size:    246 KB
  rows:    7,855

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-11-09 04:00:00	SPY	ETF	209.62	209.71	209.47	209.64	65774.0
2015-11-09 05:00:00	SPY	ETF	209.59	209.64	209.33	209.36	24028.0
2015-11-09 06:00:00	SPY	ETF	209.42	209.54	209.3	209.42	57899.0
2015-11-09 07:00:00	SPY	ETF	209.45	209.52	209.32	209.43	103097.0
2015-11-09 08:00:00	SPY	ETF	209.46	209.72	209.39	209.43	399144.0
2015-11-09 09:00:00	SPY	ETF	209.43	209.49	208.59	208.62	13171805.0
2015-11-09 10:00:00	SPY	ETF	208.62	208.73	207.92	208.2299	21607524.0
2015-11-09 11:00:00	SPY	ETF	208.2201	209.33	207.13	207.18	20839896.0
2015-11-09 12:00:00	SPY	ETF	207.17	207.74	206.95	207.72	11694293.0
2015-11-09 13:00:00	SPY	ETF	207.71	207.82	207.22	207.69	10643186.0
2015-11-09 14:00:00	SPY	ETF	207.69	207.95	207.41	207.61	12573199.0
2015-11-09 15:00:00	SPY	ETF	207.61	208.48	207.28	208.06	27485886.0
2015-11-09 16:00:00	SPY	ETF	208.05	210.0788	207.88	207.93	11586639.0
2015-11-09 17:00:00	SPY	ETF	207.98	208.08	207.89	207.95	56630.0
2015-11-09 18:00:00	SPY	ETF	207.99	208.02	207.73	207.95	86852.0
2015-11-09 19:00:00	SPY	ETF	207.98	208.21	207.94	208.07	61086.0
2015-11-09 04:00:00	QQQ	ETF	114.6	114.7	114.6	114.66	1226.0
2015-11-09 05:00:00	QQQ	ETF	114.56	114.56	114.5	114.5	1700.0
2015-11-09 06:00:00	QQQ	ETF	114.57	114.57	114.51	114.53	1760.0
2015-11-09 07:00:00	QQQ	ETF	114.55	114.55	114.38	114.4	19276.0
2015-11-09 08:00:00	QQQ	ETF	114.57	114.58	114.38	114.48	23292.0
2015-11-09 09:00:00	QQQ	ETF	114.42	114.51	114.13	114.14	3907440.0
2015-11-09 10:00:00	QQQ	ETF	114.14	114.19	113.58	113.769	4522117.0
2015-11-09 11:00:00	QQQ	ETF	113.765	113.78	112.91	112.93	5095443.0
2015-11-09 12:00:00	QQQ	ETF	112.94	113.3	112.865	113.28	2399090.0
2015-11-09 13:00:00	QQQ	ETF	113.28	113.42	113.1	113.25	2110988.0
2015-11-09 14:00:00	QQQ	ETF	113.26	113.369	113.12	113.26	2003819.0
2015-11-09 15:00:00	QQQ	ETF	113.26	113.75	113.15	113.58	5604634.0
2015-11-09 16:00:00	QQQ	ETF	113.58	113.7	113.3435	113.5	1019535.0
2015-11-09 17:00:00	QQQ	ETF	113.44	113.56	113.44	113.47	1522.0
2015-11-09 18:00:00	QQQ	ETF	113.49	113.49	113.4	113.45	2015.0
2015-11-09 19:00:00	QQQ	ETF	113.53	113.61	113.52	113.52	18470.0
2015-11-09 04:00:00	IWM	ETF	119.1	119.1	119.1	119.1	600.0
2015-11-09 05:00:00	IWM	ETF	119.16	119.16	119.16	119.16	100.0
2015-11-09 07:00:00	IWM	ETF	119.11	119.17	119.11	119.17	4637.0
2015-11-09 08:00:00	IWM	ETF	119.2	119.26	119.12	119.12	59275.0
2015-11-09 09:00:00	IWM	ETF	119.14	119.29	118.46	118.555	3242143.0
2015-11-09 10:00:00	IWM	ETF	118.555	118.58	118.0	118.37	4448622.0
2015-11-09 11:00:00	IWM	ETF	118.36	118.36	117.4	117.445	3971133.0
2015-11-09 12:00:00	IWM	ETF	117.44	117.92	117.27	117.82	3234441.0
2015-11-09 13:00:00	IWM	ETF	117.82	117.892	117.34	117.59	2225322.0
2015-11-09 14:00:00	IWM	ETF	117.59	117.835	117.46	117.525	2064978.0
2015-11-09 15:00:00	IWM	ETF	117.52	118.12	117.4	117.815	6352913.0
2015-11-09 16:00:00	IWM	ETF	117.82	118.0605	117.53	117.55	2254393.0
2015-11-09 17:00:00	IWM	ETF	117.55	117.55	117.54	117.54	10700.0
2015-11-09 18:00:00	IWM	ETF	117.56	117.59	117.56	117.59	307.0
2015-11-09 19:00:00	IWM	ETF	117.59	117.7	117.59	117.67	2333.0
2015-11-09 05:00:00	DIA	ETF	178.6	178.6	178.6	178.6	1366.0
2015-11-09 07:00:00	DIA	ETF	178.61	178.63	178.59	178.6	510.0
2015-11-09 08:00:00	DIA	ETF	178.69	178.79	178.67	178.67	1965.0

> showing 50 of 7,855 rows — these rows as CSV

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