PREVIEW / etf_1hour / 2020-06-24

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-06-24.parquet
  size:    373 KB
  rows:    12,876

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-24 04:00:00	SPY	ETF	310.71	310.81	308.74	309.81	128279.0
2020-06-24 05:00:00	SPY	ETF	309.84	310.13	308.18	308.98	151487.0
2020-06-24 06:00:00	SPY	ETF	309.05	309.61	308.76	309.5	90695.0
2020-06-24 07:00:00	SPY	ETF	309.6	310.01	309.38	309.7	182147.0
2020-06-24 08:00:00	SPY	ETF	309.65	312.5	309.0204	310.47	569892.0
2020-06-24 09:00:00	SPY	ETF	310.45	310.61	307.65	307.745	9268395.0
2020-06-24 10:00:00	SPY	ETF	307.75	308.3716	306.15	306.48	15658719.0
2020-06-24 11:00:00	SPY	ETF	306.46	306.82	302.1	303.46	26012298.0
2020-06-24 12:00:00	SPY	ETF	303.45	305.33	303.08	305.24	14249033.0
2020-06-24 13:00:00	SPY	ETF	305.235	305.5	303.03	303.8601	9458838.0
2020-06-24 14:00:00	SPY	ETF	303.86	304.83	302.78	303.7001	11364404.0
2020-06-24 15:00:00	SPY	ETF	303.73	305.74	303.63	304.12	29218548.0
2020-06-24 16:00:00	SPY	ETF	304.11	312.0536	303.9863	305.05	13193967.0
2020-06-24 17:00:00	SPY	ETF	305.07	305.07	304.72	304.72	162720.0
2020-06-24 18:00:00	SPY	ETF	304.8	305.26	304.14	304.35	466439.0
2020-06-24 19:00:00	SPY	ETF	304.34	304.43	303.81	303.81	279360.0
2020-06-24 04:00:00	QQQ	ETF	248.0	248.25	247.08	247.86	72749.0
2020-06-24 05:00:00	QQQ	ETF	247.8	247.8	246.56	247.3	48257.0
2020-06-24 06:00:00	QQQ	ETF	247.27	247.73	247.11	247.51	30381.0
2020-06-24 07:00:00	QQQ	ETF	247.6	247.97	247.54	247.72	100745.0
2020-06-24 08:00:00	QQQ	ETF	247.8	249.77	247.5504	248.35	227732.0
2020-06-24 09:00:00	QQQ	ETF	248.31	249.325	246.06	246.27	5464910.0
2020-06-24 10:00:00	QQQ	ETF	246.24	247.03	245.31	245.71	6543084.0
2020-06-24 11:00:00	QQQ	ETF	245.69	245.94	242.16	243.21	7878999.0
2020-06-24 12:00:00	QQQ	ETF	243.2	244.66	242.71	244.608	4433029.0
2020-06-24 13:00:00	QQQ	ETF	244.59	244.93	243.03	243.67	3734645.0
2020-06-24 14:00:00	QQQ	ETF	243.65	244.35	242.47	243.3	4058657.0
2020-06-24 15:00:00	QQQ	ETF	243.32	244.87	243.29	243.78	7393916.0
2020-06-24 16:00:00	QQQ	ETF	243.81	244.4	243.71	244.34	960454.0
2020-06-24 17:00:00	QQQ	ETF	244.34	244.34	243.71	244.1	18690.0
2020-06-24 18:00:00	QQQ	ETF	244.1	244.451	243.62	243.79	99724.0
2020-06-24 19:00:00	QQQ	ETF	243.84	243.9	243.3	243.35	113573.0
2020-06-24 04:00:00	IWM	ETF	142.23	142.3	140.8	141.25	15345.0
2020-06-24 05:00:00	IWM	ETF	141.45	141.5	140.37	140.9	15639.0
2020-06-24 06:00:00	IWM	ETF	140.56	141.09	140.5	141.09	23330.0
2020-06-24 07:00:00	IWM	ETF	141.09	141.69	141.09	141.41	117284.0
2020-06-24 08:00:00	IWM	ETF	140.5696	143.32	140.5696	141.83	77274.0
2020-06-24 09:00:00	IWM	ETF	141.71	141.88	139.47	139.53	4714128.0
2020-06-24 10:00:00	IWM	ETF	139.53	140.5201	139.02	139.33	6343398.0
2020-06-24 11:00:00	IWM	ETF	139.32	139.57	136.31	137.1	6410308.0
2020-06-24 12:00:00	IWM	ETF	137.085	138.8	136.86	138.79	3527623.0
2020-06-24 13:00:00	IWM	ETF	138.77	138.935	137.41	138.02	3420966.0
2020-06-24 14:00:00	IWM	ETF	138.01	138.835	137.41	138.15	3471733.0
2020-06-24 15:00:00	IWM	ETF	138.17	139.27	138.09	138.33	6885569.0
2020-06-24 16:00:00	IWM	ETF	138.32	139.17	138.3	139.13	1255520.0
2020-06-24 17:00:00	IWM	ETF	139.18	139.18	138.36	138.8	54650.0
2020-06-24 18:00:00	IWM	ETF	138.9	139.3	138.69	138.69	205955.0
2020-06-24 19:00:00	IWM	ETF	138.62	138.75	138.22	138.22	182808.0
2020-06-24 04:00:00	DIA	ETF	260.27	260.27	258.41	259.41	10820.0
2020-06-24 05:00:00	DIA	ETF	259.71	259.76	258.33	258.77	10750.0

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

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