PREVIEW / etf_1hour / 2020-06-26

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-06-26.parquet
  size:    360 KB
  rows:    12,416

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-26 04:00:00	SPY	ETF	306.48	306.48	304.99	306.09	103795.0
2020-06-26 05:00:00	SPY	ETF	305.97	307.02	305.97	306.81	71423.0
2020-06-26 06:00:00	SPY	ETF	307.0	307.75	306.99	307.54	110778.0
2020-06-26 07:00:00	SPY	ETF	307.58	308.11	306.94	307.0	336510.0
2020-06-26 08:00:00	SPY	ETF	306.2	308.2	305.4	306.05	742914.0
2020-06-26 09:00:00	SPY	ETF	306.1	306.39	304.5201	305.2301	7939469.0
2020-06-26 10:00:00	SPY	ETF	305.23	305.25	300.69	301.51	20624158.0
2020-06-26 11:00:00	SPY	ETF	301.54	302.91	301.39	302.603	11872733.0
2020-06-26 12:00:00	SPY	ETF	302.61	302.67	300.5	301.83	9470445.0
2020-06-26 13:00:00	SPY	ETF	301.8	302.58	301.54	301.79	8809697.0
2020-06-26 14:00:00	SPY	ETF	301.79	302.09	299.85	300.47	16331405.0
2020-06-26 15:00:00	SPY	ETF	300.46	301.46	299.42	300.01	33402872.0
2020-06-26 16:00:00	SPY	ETF	300.01	301.45	299.8916	300.39	16015172.0
2020-06-26 17:00:00	SPY	ETF	300.33	300.7	300.05	300.47	212246.0
2020-06-26 18:00:00	SPY	ETF	300.45	300.47	300.19	300.25	53842.0
2020-06-26 19:00:00	SPY	ETF	300.27	300.3	299.95	300.15	94324.0
2020-06-26 04:00:00	QQQ	ETF	245.56	245.72	244.8	245.72	65144.0
2020-06-26 05:00:00	QQQ	ETF	245.72	246.2	245.68	246.17	7589.0
2020-06-26 06:00:00	QQQ	ETF	246.25	246.68	246.25	246.55	50753.0
2020-06-26 07:00:00	QQQ	ETF	246.53	246.86	246.15	246.18	91082.0
2020-06-26 08:00:00	QQQ	ETF	246.56	246.84	245.15	245.72	167487.0
2020-06-26 09:00:00	QQQ	ETF	245.78	245.96	243.86	244.47	3917925.0
2020-06-26 10:00:00	QQQ	ETF	244.43	244.43	240.37	241.22	9682443.0
2020-06-26 11:00:00	QQQ	ETF	241.24	243.51	241.18	243.235	8486002.0
2020-06-26 12:00:00	QQQ	ETF	243.235	243.28	240.98	242.05	4560744.0
2020-06-26 13:00:00	QQQ	ETF	242.03	242.81	241.77	241.9	2963717.0
2020-06-26 14:00:00	QQQ	ETF	241.91	242.47	240.58	241.04	4828753.0
2020-06-26 15:00:00	QQQ	ETF	241.02	241.78	239.68	240.08	9956267.0
2020-06-26 16:00:00	QQQ	ETF	240.09	240.97	239.968	240.23	2171754.0
2020-06-26 17:00:00	QQQ	ETF	240.2	240.27	239.91	240.16	106152.0
2020-06-26 18:00:00	QQQ	ETF	240.16	240.25	239.94	240.0	18343.0
2020-06-26 19:00:00	QQQ	ETF	240.0	240.0	239.59	239.7	39245.0
2020-06-26 04:00:00	IWM	ETF	139.45	139.45	138.75	139.35	7384.0
2020-06-26 05:00:00	IWM	ETF	139.33	140.0	139.32	140.0	3160.0
2020-06-26 06:00:00	IWM	ETF	140.29	140.38	139.92	140.07	10373.0
2020-06-26 07:00:00	IWM	ETF	140.41	140.51	139.79	139.9	89015.0
2020-06-26 08:00:00	IWM	ETF	140.3599	140.58	139.12	139.31	169751.0
2020-06-26 09:00:00	IWM	ETF	139.32	139.83	138.6301	139.13	3007995.0
2020-06-26 10:00:00	IWM	ETF	139.13	139.15	136.49	137.04	5100260.0
2020-06-26 11:00:00	IWM	ETF	137.05	138.23	136.99	137.89	3183862.0
2020-06-26 12:00:00	IWM	ETF	137.89	137.935	137.0	137.7	2011849.0
2020-06-26 13:00:00	IWM	ETF	137.7	138.135	137.32	137.34	1952409.0
2020-06-26 14:00:00	IWM	ETF	137.33	137.5	136.5418	136.82	3938409.0
2020-06-26 15:00:00	IWM	ETF	136.82	137.77	136.6	136.79	9980757.0
2020-06-26 16:00:00	IWM	ETF	136.79	137.57	136.1915	136.8	3907799.0
2020-06-26 17:00:00	IWM	ETF	136.99	137.03	136.74	137.03	69287.0
2020-06-26 18:00:00	IWM	ETF	137.0	137.1	136.67	137.01	28240.0
2020-06-26 19:00:00	IWM	ETF	137.01	137.02	136.75	136.75	7724.0
2020-06-26 04:00:00	DIA	ETF	255.47	255.47	254.79	255.46	3504.0
2020-06-26 05:00:00	DIA	ETF	255.52	256.5	255.51	256.27	2515.0

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

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