PREVIEW / etf_1hour / 2019-06-04

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-06-04.parquet
  size:    336 KB
  rows:    10,952

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
2019-06-04 04:00:00	SPY	ETF	276.18	276.34	275.87	276.34	36554.0
2019-06-04 05:00:00	SPY	ETF	276.4	276.49	276.09	276.47	10828.0
2019-06-04 06:00:00	SPY	ETF	276.49	276.61	276.23	276.34	46916.0
2019-06-04 07:00:00	SPY	ETF	276.32	277.12	276.11	276.75	656552.0
2019-06-04 08:00:00	SPY	ETF	275.21	277.2	274.57	277.04	1026844.0
2019-06-04 09:00:00	SPY	ETF	277.06	277.64	276.62	277.07	10009733.0
2019-06-04 10:00:00	SPY	ETF	277.07	278.25	276.68	278.11	11364620.0
2019-06-04 11:00:00	SPY	ETF	278.11	279.35	277.93	279.135	9217068.0
2019-06-04 12:00:00	SPY	ETF	279.14	279.7262	278.67	279.45	5988808.0
2019-06-04 13:00:00	SPY	ETF	279.45	279.84	279.11	279.785	6335077.0
2019-06-04 14:00:00	SPY	ETF	279.78	279.84	279.27	279.3334	6829219.0
2019-06-04 15:00:00	SPY	ETF	279.34	280.68	279.32	280.52	17754598.0
2019-06-04 16:00:00	SPY	ETF	280.53	280.8	279.5	280.72	5891712.0
2019-06-04 17:00:00	SPY	ETF	280.73	280.87	280.53	280.83	367663.0
2019-06-04 18:00:00	SPY	ETF	280.87	281.48	280.87	281.02	399451.0
2019-06-04 19:00:00	SPY	ETF	281.02	281.4	281.0	281.39	77459.0
2019-06-04 04:00:00	QQQ	ETF	171.26	171.52	171.12	171.52	41704.0
2019-06-04 05:00:00	QQQ	ETF	171.42	171.57	171.24	171.52	38529.0
2019-06-04 06:00:00	QQQ	ETF	171.48	171.66	171.27	171.27	37074.0
2019-06-04 07:00:00	QQQ	ETF	171.31	171.88	171.12	171.53	240607.0
2019-06-04 08:00:00	QQQ	ETF	171.3299	172.0899	170.12	171.92	559874.0
2019-06-04 09:00:00	QQQ	ETF	171.95	172.35	171.37	171.7015	6364059.0
2019-06-04 10:00:00	QQQ	ETF	171.7	172.965	171.44	172.92	8047782.0
2019-06-04 11:00:00	QQQ	ETF	172.91	174.19	172.7815	173.96	4823097.0
2019-06-04 12:00:00	QQQ	ETF	173.96	174.22	173.47	174.07	3237339.0
2019-06-04 13:00:00	QQQ	ETF	174.07	174.56	173.9	174.5	3965958.0
2019-06-04 14:00:00	QQQ	ETF	174.495	174.565	174.04	174.12	2602459.0
2019-06-04 15:00:00	QQQ	ETF	174.13	174.97	174.13	174.91	7576016.0
2019-06-04 16:00:00	QQQ	ETF	174.91	175.25	171.91	175.25	4318963.0
2019-06-04 17:00:00	QQQ	ETF	175.21	175.39	174.91	175.38	80455.0
2019-06-04 18:00:00	QQQ	ETF	175.35	175.84	175.34	175.44	135374.0
2019-06-04 19:00:00	QQQ	ETF	175.46	175.71	175.45	175.67	72540.0
2019-06-04 04:00:00	IWM	ETF	147.37	147.51	147.28	147.51	8500.0
2019-06-04 05:00:00	IWM	ETF	147.45	147.56	147.45	147.55	8850.0
2019-06-04 06:00:00	IWM	ETF	147.75	147.75	147.75	147.75	2000.0
2019-06-04 07:00:00	IWM	ETF	147.65	148.01	147.55	147.8	73693.0
2019-06-04 08:00:00	IWM	ETF	147.6999	148.03	147.5701	147.82	256937.0
2019-06-04 09:00:00	IWM	ETF	147.85	148.509	147.785	148.26	3013065.0
2019-06-04 10:00:00	IWM	ETF	148.26	148.54	147.62	148.43	3431448.0
2019-06-04 11:00:00	IWM	ETF	148.42	149.125	148.31	148.97	1804538.0
2019-06-04 12:00:00	IWM	ETF	148.98	149.35	148.66	149.26	1411594.0
2019-06-04 13:00:00	IWM	ETF	149.26	149.39	148.92	149.36	1481740.0
2019-06-04 14:00:00	IWM	ETF	149.36	149.41	146.4238	149.21	1394568.0
2019-06-04 15:00:00	IWM	ETF	149.2184	150.29	149.205	150.15	4217645.0
2019-06-04 16:00:00	IWM	ETF	150.16	150.22	149.91	150.05	965731.0
2019-06-04 17:00:00	IWM	ETF	150.0799	150.19	150.07	150.19	155235.0
2019-06-04 18:00:00	IWM	ETF	150.21	150.51	150.13	150.21	49632.0
2019-06-04 19:00:00	IWM	ETF	150.26	150.4	150.26	150.4	4855.0
2019-06-04 04:00:00	DIA	ETF	249.5	250.0	249.5	250.0	700.0
2019-06-04 06:00:00	DIA	ETF	250.12	250.12	250.0	250.0	1000.0

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

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