PREVIEW / etf_1hour / 2018-12-18

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-12-18.parquet
  size:    338 KB
  rows:    10,966

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
2018-12-18 04:00:00	SPY	ETF	256.37	256.82	255.94	256.73	49415.0
2018-12-18 05:00:00	SPY	ETF	256.7	257.0	256.47	256.47	86492.0
2018-12-18 06:00:00	SPY	ETF	256.5	256.95	256.46	256.7	94039.0
2018-12-18 07:00:00	SPY	ETF	256.72	257.74	256.55	257.6	556118.0
2018-12-18 08:00:00	SPY	ETF	257.6	257.78	255.48	257.13	831769.0
2018-12-18 09:00:00	SPY	ETF	257.12	257.95	256.78	257.8138	10814502.0
2018-12-18 10:00:00	SPY	ETF	257.78	257.85	256.29	256.61	15468595.0
2018-12-18 11:00:00	SPY	ETF	256.62	257.0	255.65	256.38	15884851.0
2018-12-18 12:00:00	SPY	ETF	256.38	257.8	256.34	257.34	11680609.0
2018-12-18 13:00:00	SPY	ETF	257.33	257.53	255.6	255.9	10465367.0
2018-12-18 14:00:00	SPY	ETF	255.9	256.68	253.79	253.81	21371402.0
2018-12-18 15:00:00	SPY	ETF	253.81	256.51	253.28	255.14	33253037.0
2018-12-18 16:00:00	SPY	ETF	255.14	255.26	253.31	253.43	11100359.0
2018-12-18 17:00:00	SPY	ETF	253.4	255.08	253.3	253.58	398861.0
2018-12-18 18:00:00	SPY	ETF	253.45	255.08	253.45	254.52	955114.0
2018-12-18 19:00:00	SPY	ETF	254.55	254.96	254.01	254.72	404943.0
2018-12-18 20:00:00	SPY	ETF	255.08	255.08	254.7	254.7	270.0
2018-12-18 04:00:00	QQQ	ETF	158.1	158.56	157.94	158.56	41438.0
2018-12-18 05:00:00	QQQ	ETF	158.51	158.68	158.3	158.37	52833.0
2018-12-18 06:00:00	QQQ	ETF	158.35	158.81	158.34	158.64	68950.0
2018-12-18 07:00:00	QQQ	ETF	158.64	159.15	158.57	159.08	197305.0
2018-12-18 08:00:00	QQQ	ETF	158.71	159.2	158.0	158.65	266776.0
2018-12-18 09:00:00	QQQ	ETF	158.66	159.27	158.25	159.11	6095757.0
2018-12-18 10:00:00	QQQ	ETF	159.12	159.29	158.32	158.9	7124977.0
2018-12-18 11:00:00	QQQ	ETF	158.9	159.17	158.04	158.5999	5347859.0
2018-12-18 12:00:00	QQQ	ETF	158.59	159.95	158.57	159.79	5252818.0
2018-12-18 13:00:00	QQQ	ETF	159.8	159.86	158.64	158.85	3974588.0
2018-12-18 14:00:00	QQQ	ETF	158.86	159.53	157.49	157.52	6522554.0
2018-12-18 15:00:00	QQQ	ETF	157.51	159.38	157.04	158.44	12533047.0
2018-12-18 16:00:00	QQQ	ETF	158.44	158.51	157.17	157.17	1377181.0
2018-12-18 17:00:00	QQQ	ETF	157.17	158.42	156.98	157.22	3513936.0
2018-12-18 18:00:00	QQQ	ETF	157.2	157.9	157.16	157.9	85026.0
2018-12-18 19:00:00	QQQ	ETF	157.92	158.18	157.6	158.04	73118.0
2018-12-18 04:00:00	IWM	ETF	137.71	138.15	137.6	138.14	6386.0
2018-12-18 05:00:00	IWM	ETF	138.17	138.25	137.95	137.95	3390.0
2018-12-18 06:00:00	IWM	ETF	137.91	138.26	137.91	138.26	6300.0
2018-12-18 07:00:00	IWM	ETF	138.18	138.61	138.18	138.57	44295.0
2018-12-18 08:00:00	IWM	ETF	138.18	138.66	137.51	138.27	96209.0
2018-12-18 09:00:00	IWM	ETF	138.27	139.18	137.86	139.105	3285558.0
2018-12-18 10:00:00	IWM	ETF	139.11	139.14	137.7691	137.95	4811741.0
2018-12-18 11:00:00	IWM	ETF	137.95	138.25	137.15	137.595	4209418.0
2018-12-18 12:00:00	IWM	ETF	137.58	138.51	137.55	138.38	3436423.0
2018-12-18 13:00:00	IWM	ETF	138.39	138.44	136.95	137.08	2852727.0
2018-12-18 14:00:00	IWM	ETF	137.07	137.61	136.44	136.44	4241649.0
2018-12-18 15:00:00	IWM	ETF	136.44	137.45	136.29	136.78	7252290.0
2018-12-18 16:00:00	IWM	ETF	136.79	136.85	135.78	136.17	1011868.0
2018-12-18 17:00:00	IWM	ETF	135.86	136.12	135.66	136.0	412539.0
2018-12-18 18:00:00	IWM	ETF	136.1	136.55	136.0	136.55	17319.0
2018-12-18 19:00:00	IWM	ETF	136.37	136.73	136.34	136.73	10103.0
2018-12-18 04:00:00	DIA	ETF	237.72	237.95	237.37	237.95	4100.0

> showing 50 of 10,966 rows — these rows as CSV

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