PREVIEW / etf_1hour / 2015-10-05

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-10-05.parquet
  size:    251 KB
  rows:    7,964

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-05 04:00:00	SPY	ETF	195.4	195.69	195.1	195.35	13722.0
2015-10-05 05:00:00	SPY	ETF	195.56	196.03	195.47	196.03	77028.0
2015-10-05 06:00:00	SPY	ETF	196.02	196.25	195.92	196.05	105200.0
2015-10-05 07:00:00	SPY	ETF	196.04	196.59	196.04	196.59	622339.0
2015-10-05 08:00:00	SPY	ETF	196.59	196.71	194.52	196.49	1551325.0
2015-10-05 09:00:00	SPY	ETF	196.49	197.39	196.3	197.31	18982860.0
2015-10-05 10:00:00	SPY	ETF	197.29	197.59	196.84	197.16	21718026.0
2015-10-05 11:00:00	SPY	ETF	197.175	197.51	197.1	197.465	10012000.0
2015-10-05 12:00:00	SPY	ETF	197.47	197.84	197.4	197.595	11758998.0
2015-10-05 13:00:00	SPY	ETF	197.6	198.16	197.49	198.08	9853368.0
2015-10-05 14:00:00	SPY	ETF	198.08	198.68	197.98	198.4232	15906871.0
2015-10-05 15:00:00	SPY	ETF	198.43	198.74	198.27	198.5	27693154.0
2015-10-05 16:00:00	SPY	ETF	198.5	198.6	198.12	198.25	5740137.0
2015-10-05 17:00:00	SPY	ETF	198.25	198.47	197.7602	198.05	1125500.0
2015-10-05 18:00:00	SPY	ETF	198.05	198.07	197.85	197.95	319909.0
2015-10-05 19:00:00	SPY	ETF	197.98	198.1	197.87	198.07	230100.0
2015-10-05 05:00:00	QQQ	ETF	104.48	104.76	104.48	104.76	15585.0
2015-10-05 06:00:00	QQQ	ETF	104.78	104.85	104.73	104.73	9000.0
2015-10-05 07:00:00	QQQ	ETF	104.76	104.97	104.75	104.9	70907.0
2015-10-05 08:00:00	QQQ	ETF	104.89	104.95	104.56	104.7	306912.0
2015-10-05 09:00:00	QQQ	ETF	104.71	104.86	104.55	104.82	5619698.0
2015-10-05 10:00:00	QQQ	ETF	104.81	105.21	104.6	104.94	5817919.0
2015-10-05 11:00:00	QQQ	ETF	104.94	105.22	104.78	105.03	3181418.0
2015-10-05 12:00:00	QQQ	ETF	105.03	105.19	104.92	105.02	3265837.0
2015-10-05 13:00:00	QQQ	ETF	105.02	105.53	104.959	105.49	2303001.0
2015-10-05 14:00:00	QQQ	ETF	105.47	105.78	105.395	105.57	3866197.0
2015-10-05 15:00:00	QQQ	ETF	105.58	105.73	105.42	105.53	5982915.0
2015-10-05 16:00:00	QQQ	ETF	105.53	105.6	105.29	105.37	927935.0
2015-10-05 17:00:00	QQQ	ETF	105.38	105.4	105.29	105.29	43150.0
2015-10-05 18:00:00	QQQ	ETF	105.27	105.27	105.13	105.16	51211.0
2015-10-05 19:00:00	QQQ	ETF	105.16	105.24	105.14	105.24	9265.0
2015-10-05 04:00:00	IWM	ETF	111.12	111.39	111.12	111.39	400.0
2015-10-05 05:00:00	IWM	ETF	111.56	111.56	111.56	111.56	100.0
2015-10-05 06:00:00	IWM	ETF	111.55	111.62	111.5	111.5	22900.0
2015-10-05 07:00:00	IWM	ETF	111.5	111.74	111.48	111.74	51429.0
2015-10-05 08:00:00	IWM	ETF	111.69	111.84	111.5	111.64	398466.0
2015-10-05 09:00:00	IWM	ETF	111.68	112.2	111.54	112.19	6019899.0
2015-10-05 10:00:00	IWM	ETF	112.19	112.66	111.99	112.315	7564308.0
2015-10-05 11:00:00	IWM	ETF	112.32	112.694	112.2591	112.56	3890859.0
2015-10-05 12:00:00	IWM	ETF	112.56	112.675	112.32	112.43	2208944.0
2015-10-05 13:00:00	IWM	ETF	112.445	112.925	112.4	112.8885	2861685.0
2015-10-05 14:00:00	IWM	ETF	112.89	113.19	112.8	112.995	3747966.0
2015-10-05 15:00:00	IWM	ETF	112.995	113.45	112.92	113.24	8813505.0
2015-10-05 16:00:00	IWM	ETF	113.25	113.42	112.789	113.12	5963996.0
2015-10-05 17:00:00	IWM	ETF	113.09	113.09	113.0	113.05	18106.0
2015-10-05 18:00:00	IWM	ETF	113.01	113.08	112.96	112.96	2580.0
2015-10-05 04:00:00	DIA	ETF	164.91	165.09	164.91	165.09	200.0
2015-10-05 05:00:00	DIA	ETF	165.41	165.41	165.41	165.41	100.0
2015-10-05 06:00:00	DIA	ETF	165.5	165.5	165.5	165.5	100.0
2015-10-05 07:00:00	DIA	ETF	165.48	165.74	165.48	165.74	2325.0

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

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