PREVIEW / etf_1hour / 2016-11-10

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-11-10.parquet
  size:    284 KB
  rows:    9,089

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-11-10 04:00:00	SPY	ETF	218.02	218.1	217.58	217.88	51233.0
2016-11-10 05:00:00	SPY	ETF	217.9	218.37	217.9	218.08	214554.0
2016-11-10 06:00:00	SPY	ETF	218.1	218.1	217.7	217.93	244441.0
2016-11-10 07:00:00	SPY	ETF	217.95	218.0	216.98	217.59	1008322.0
2016-11-10 08:00:00	SPY	ETF	217.59	217.95	217.05	217.58	2229017.0
2016-11-10 09:00:00	SPY	ETF	217.58	218.31	217.22	217.5	21061544.0
2016-11-10 10:00:00	SPY	ETF	217.5	217.71	215.22	215.49	43689507.0
2016-11-10 11:00:00	SPY	ETF	215.48	216.88	215.25	216.06	28027353.0
2016-11-10 12:00:00	SPY	ETF	216.07	217.14	216.02	217.08	17203016.0
2016-11-10 13:00:00	SPY	ETF	217.09	217.96	216.89	217.63	15576848.0
2016-11-10 14:00:00	SPY	ETF	217.635	217.85	217.1	217.495	11381123.0
2016-11-10 15:00:00	SPY	ETF	217.5	217.67	216.67	216.87	22642794.0
2016-11-10 16:00:00	SPY	ETF	216.88	217.2	216.71	216.87	6414907.0
2016-11-10 17:00:00	SPY	ETF	216.9	217.01	216.85	216.95	678644.0
2016-11-10 18:00:00	SPY	ETF	216.95	217.03	216.83	216.97	229227.0
2016-11-10 19:00:00	SPY	ETF	216.94	217.15	216.79	216.86	1280149.0
2016-11-10 04:00:00	QQQ	ETF	118.77	118.85	118.49	118.69	50629.0
2016-11-10 05:00:00	QQQ	ETF	118.69	118.88	118.69	118.75	7915.0
2016-11-10 06:00:00	QQQ	ETF	118.69	118.73	118.54	118.57	23289.0
2016-11-10 07:00:00	QQQ	ETF	118.63	118.63	118.14	118.4	96419.0
2016-11-10 08:00:00	QQQ	ETF	118.37	118.51	118.15	118.29	269882.0
2016-11-10 09:00:00	QQQ	ETF	118.31	118.38	117.51	117.54	5951338.0
2016-11-10 10:00:00	QQQ	ETF	117.53	117.67	114.195	114.8	19990429.0
2016-11-10 11:00:00	QQQ	ETF	114.8	115.77	114.67	115.01	11267845.0
2016-11-10 12:00:00	QQQ	ETF	115.01	115.7618	114.8684	115.75	7001297.0
2016-11-10 13:00:00	QQQ	ETF	115.76	116.56	115.61	116.33	6078780.0
2016-11-10 14:00:00	QQQ	ETF	116.32	116.57	115.95	116.36	3305111.0
2016-11-10 15:00:00	QQQ	ETF	116.37	116.45	115.55	115.71	5389247.0
2016-11-10 16:00:00	QQQ	ETF	115.74	115.82	115.59	115.66	1081630.0
2016-11-10 17:00:00	QQQ	ETF	115.75	117.6297	115.65	115.75	1054556.0
2016-11-10 18:00:00	QQQ	ETF	115.71	115.71	115.58	115.58	48849.0
2016-11-10 19:00:00	QQQ	ETF	115.56	115.7	115.5	115.53	30885.0
2016-11-10 04:00:00	IWM	ETF	123.34	123.66	123.34	123.44	4727.0
2016-11-10 05:00:00	IWM	ETF	123.48	123.81	123.48	123.75	8180.0
2016-11-10 06:00:00	IWM	ETF	123.86	123.96	123.78	123.95	10058.0
2016-11-10 07:00:00	IWM	ETF	123.96	124.01	123.53	124.0	193096.0
2016-11-10 08:00:00	IWM	ETF	124.0	124.54	123.92	124.43	513491.0
2016-11-10 09:00:00	IWM	ETF	124.4	125.145	123.98	124.59	10715601.0
2016-11-10 10:00:00	IWM	ETF	124.6	124.72	122.62	123.08	13374395.0
2016-11-10 11:00:00	IWM	ETF	123.07	124.9	122.91	124.37	12203626.0
2016-11-10 12:00:00	IWM	ETF	124.38	125.19	124.33	125.14	7293492.0
2016-11-10 13:00:00	IWM	ETF	125.15	125.4	124.63	125.15	5647076.0
2016-11-10 14:00:00	IWM	ETF	125.14	125.19	124.64	124.99	4057326.0
2016-11-10 15:00:00	IWM	ETF	124.99	125.1	124.36	124.46	9637356.0
2016-11-10 16:00:00	IWM	ETF	124.46	125.07	122.96	122.96	4027149.0
2016-11-10 17:00:00	IWM	ETF	124.88	124.9	124.5	124.86	287194.0
2016-11-10 18:00:00	IWM	ETF	124.82	124.82	124.82	124.82	320.0
2016-11-10 19:00:00	IWM	ETF	124.83	124.9	124.5144	124.81	1416400.0
2016-11-10 04:00:00	DIA	ETF	186.72	187.36	186.71	187.36	1200.0
2016-11-10 05:00:00	DIA	ETF	187.47	187.47	187.47	187.47	5200.0

> showing 50 of 9,089 rows — these rows as CSV

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