PREVIEW / etf_1hour / 2020-06-12

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-06-12.parquet
  size:    374 KB
  rows:    12,990

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
2020-06-12 04:00:00	SPY	ETF	304.43	307.09	304.43	306.72	376154.0
2020-06-12 05:00:00	SPY	ETF	306.81	307.39	306.4	307.32	698149.0
2020-06-12 06:00:00	SPY	ETF	307.26	307.6	305.9	306.61	547662.0
2020-06-12 07:00:00	SPY	ETF	306.61	307.42	306.1	306.1	1066445.0
2020-06-12 08:00:00	SPY	ETF	306.08	307.66	303.0	307.2	2033422.0
2020-06-12 09:00:00	SPY	ETF	307.21	309.08	307.06	307.63	15993468.0
2020-06-12 10:00:00	SPY	ETF	307.63	308.42	302.67	302.68	24185444.0
2020-06-12 11:00:00	SPY	ETF	302.67	305.279	300.46	305.22	28739334.0
2020-06-12 12:00:00	SPY	ETF	305.21	305.89	302.59	303.79	15506764.0
2020-06-12 13:00:00	SPY	ETF	303.81	304.01	298.74	298.88	20642114.0
2020-06-12 14:00:00	SPY	ETF	298.88	302.68	298.6	302.095	24100864.0
2020-06-12 15:00:00	SPY	ETF	302.09	305.07	301.06	304.28	40528484.0
2020-06-12 16:00:00	SPY	ETF	304.26	307.2	300.4668	303.93	17553407.0
2020-06-12 17:00:00	SPY	ETF	303.94	304.21	303.21	303.96	907217.0
2020-06-12 18:00:00	SPY	ETF	303.96	304.21	303.72	303.75	147474.0
2020-06-12 19:00:00	SPY	ETF	303.75	303.85	303.57	303.58	72850.0
2020-06-12 04:00:00	QQQ	ETF	237.04	238.6	236.94	238.4	78447.0
2020-06-12 05:00:00	QQQ	ETF	238.1	238.86	237.98	238.83	81690.0
2020-06-12 06:00:00	QQQ	ETF	238.84	239.0	237.73	238.17	142409.0
2020-06-12 07:00:00	QQQ	ETF	238.17	238.64	238.0	238.0	217414.0
2020-06-12 08:00:00	QQQ	ETF	238.0	238.9796	236.39	238.14	487924.0
2020-06-12 09:00:00	QQQ	ETF	238.17	240.4	238.1402	239.46	6759557.0
2020-06-12 10:00:00	QQQ	ETF	239.47	239.9133	235.36	235.3861	8549987.0
2020-06-12 11:00:00	QQQ	ETF	235.36	237.22	233.54	237.17	10156067.0
2020-06-12 12:00:00	QQQ	ETF	237.16	237.65	235.04	236.04	5355482.0
2020-06-12 13:00:00	QQQ	ETF	236.05	236.18	231.88	231.94	9252960.0
2020-06-12 14:00:00	QQQ	ETF	231.97	234.66	231.74	234.44	9388506.0
2020-06-12 15:00:00	QQQ	ETF	234.44	236.41	233.43	235.77	11188513.0
2020-06-12 16:00:00	QQQ	ETF	235.75	236.01	235.18	235.45	949226.0
2020-06-12 17:00:00	QQQ	ETF	235.43	235.88	235.34	235.65	114779.0
2020-06-12 18:00:00	QQQ	ETF	235.68	235.84	235.68	235.69	68321.0
2020-06-12 19:00:00	QQQ	ETF	235.69	235.8	235.69	235.71	50381.0
2020-06-12 04:00:00	IWM	ETF	138.38	141.0	138.38	140.75	116507.0
2020-06-12 05:00:00	IWM	ETF	140.65	140.89	140.25	140.87	181094.0
2020-06-12 06:00:00	IWM	ETF	140.68	141.04	139.51	140.04	174121.0
2020-06-12 07:00:00	IWM	ETF	140.01	140.65	139.5	139.6	316303.0
2020-06-12 08:00:00	IWM	ETF	139.55	140.58	137.48	139.64	543765.0
2020-06-12 09:00:00	IWM	ETF	139.74	141.02	139.1	139.63	5434861.0
2020-06-12 10:00:00	IWM	ETF	139.64	140.36	136.4	136.4	6322326.0
2020-06-12 11:00:00	IWM	ETF	136.39	138.155	135.09	138.145	7948272.0
2020-06-12 12:00:00	IWM	ETF	138.16	138.56	136.685	137.565	4738151.0
2020-06-12 13:00:00	IWM	ETF	137.62	137.67	134.18	134.28	6891802.0
2020-06-12 14:00:00	IWM	ETF	134.29	136.68	134.15	136.39	7337558.0
2020-06-12 15:00:00	IWM	ETF	136.37	138.55	135.84	138.35	9888129.0
2020-06-12 16:00:00	IWM	ETF	138.36	138.45	137.69	137.69	1785559.0
2020-06-12 17:00:00	IWM	ETF	137.43	138.27	137.43	138.14	125704.0
2020-06-12 18:00:00	IWM	ETF	138.1	138.27	137.8	137.96	17777.0
2020-06-12 19:00:00	IWM	ETF	137.98	138.06	137.83	137.87	3854.0
2020-06-12 04:00:00	DIA	ETF	255.12	258.2	255.12	258.2	20495.0
2020-06-12 05:00:00	DIA	ETF	258.14	258.26	257.92	258.26	2620.0

> showing 50 of 12,990 rows — these rows as CSV

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