PREVIEW / etf_1hour / 2016-04-22

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-04-22.parquet
  size:    251 KB
  rows:    8,054

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-04-22 04:00:00	SPY	ETF	208.75	208.89	208.49	208.49	1740.0
2016-04-22 05:00:00	SPY	ETF	208.5	208.77	208.5	208.62	724.0
2016-04-22 06:00:00	SPY	ETF	208.7	209.17	208.7	209.04	50803.0
2016-04-22 07:00:00	SPY	ETF	209.0	209.18	208.87	208.93	247324.0
2016-04-22 08:00:00	SPY	ETF	208.94	209.3712	208.61	208.74	496263.0
2016-04-22 09:00:00	SPY	ETF	208.73	209.2	208.5	209.13	10349793.0
2016-04-22 10:00:00	SPY	ETF	209.13	209.29	207.91	208.03	18343771.0
2016-04-22 11:00:00	SPY	ETF	208.04	208.5	207.9993	208.46	10799030.0
2016-04-22 12:00:00	SPY	ETF	208.47	208.48	208.01	208.1	5713116.0
2016-04-22 13:00:00	SPY	ETF	208.11	208.86	208.07	208.68	7428486.0
2016-04-22 14:00:00	SPY	ETF	208.69	209.08	208.61	209.0	9142478.0
2016-04-22 15:00:00	SPY	ETF	209.01	209.06	208.66	208.99	21410267.0
2016-04-22 16:00:00	SPY	ETF	209.0	209.08	208.86	208.98	12166328.0
2016-04-22 17:00:00	SPY	ETF	208.99	209.08	208.94	209.03	59709.0
2016-04-22 18:00:00	SPY	ETF	209.01	209.05	209.0	209.05	14648.0
2016-04-22 19:00:00	SPY	ETF	209.02	209.08	208.9554	209.02	1004915.0
2016-04-22 04:00:00	QQQ	ETF	109.5	109.69	109.4	109.4	2246.0
2016-04-22 05:00:00	QQQ	ETF	109.5	109.5	109.5	109.5	150.0
2016-04-22 06:00:00	QQQ	ETF	109.58	109.76	109.58	109.69	2715.0
2016-04-22 07:00:00	QQQ	ETF	109.67	109.8	109.62	109.62	49834.0
2016-04-22 08:00:00	QQQ	ETF	109.65	109.73	109.5	109.51	75928.0
2016-04-22 09:00:00	QQQ	ETF	109.52	109.72	109.1	109.4	5684978.0
2016-04-22 10:00:00	QQQ	ETF	109.4	109.475	108.12	108.28	6872979.0
2016-04-22 11:00:00	QQQ	ETF	108.29	108.57	108.18	108.56	4293892.0
2016-04-22 12:00:00	QQQ	ETF	108.57	108.59	108.19	108.31	2420575.0
2016-04-22 13:00:00	QQQ	ETF	108.325	108.85	108.32	108.69	2398786.0
2016-04-22 14:00:00	QQQ	ETF	108.7	109.07	108.61	109.02	2667053.0
2016-04-22 15:00:00	QQQ	ETF	109.03	109.09	108.81	108.97	5300887.0
2016-04-22 16:00:00	QQQ	ETF	108.99	108.99	108.9	108.98	1013653.0
2016-04-22 17:00:00	QQQ	ETF	108.97	109.03	108.92	108.97	6358.0
2016-04-22 18:00:00	QQQ	ETF	108.98	109.02	108.98	109.02	3614.0
2016-04-22 19:00:00	QQQ	ETF	109.02	109.02	108.96	108.98	2714.0
2016-04-22 06:00:00	IWM	ETF	113.01	113.19	113.01	113.19	1198.0
2016-04-22 07:00:00	IWM	ETF	113.19	113.2	113.19	113.19	1660.0
2016-04-22 08:00:00	IWM	ETF	113.15	113.15	112.95	113.06	68433.0
2016-04-22 09:00:00	IWM	ETF	112.99	113.85	112.96	113.81	2718885.0
2016-04-22 10:00:00	IWM	ETF	113.81	113.97	113.12	113.16	4420627.0
2016-04-22 11:00:00	IWM	ETF	113.16	113.78	113.16	113.69	3299437.0
2016-04-22 12:00:00	IWM	ETF	113.69	113.74	113.52	113.61	2216989.0
2016-04-22 13:00:00	IWM	ETF	113.63	114.12	113.47	113.93	2288916.0
2016-04-22 14:00:00	IWM	ETF	113.93	114.19	113.91	114.07	2175112.0
2016-04-22 15:00:00	IWM	ETF	114.08	114.125	113.75	114.1	5854994.0
2016-04-22 16:00:00	IWM	ETF	114.08	114.29	113.75	114.26	1751250.0
2016-04-22 17:00:00	IWM	ETF	114.2	114.26	114.2	114.26	13254.0
2016-04-22 18:00:00	IWM	ETF	114.25	114.29	114.25	114.25	5101.0
2016-04-22 19:00:00	IWM	ETF	114.25	114.29	114.0404	114.0404	162450.0
2016-04-22 07:00:00	DIA	ETF	179.76	179.76	179.76	179.76	3532.0
2016-04-22 08:00:00	DIA	ETF	179.62	179.7	179.6	179.6	2000.0
2016-04-22 09:00:00	DIA	ETF	179.65	180.08	179.6	179.95	384068.0
2016-04-22 10:00:00	DIA	ETF	179.98	180.08	178.87	178.91	531908.0

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

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