PREVIEW / etf_1hour / 2020-08-18

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-08-18.parquet
  size:    369 KB
  rows:    12,540

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-08-18 04:00:00	SPY	ETF	338.0	338.22	337.7	338.1	8034.0
2020-08-18 05:00:00	SPY	ETF	338.12	338.58	338.12	338.55	17891.0
2020-08-18 06:00:00	SPY	ETF	338.53	338.93	338.5	338.85	57699.0
2020-08-18 07:00:00	SPY	ETF	338.81	338.94	338.34	338.39	122486.0
2020-08-18 08:00:00	SPY	ETF	338.39	338.9496	337.86	338.59	386101.0
2020-08-18 09:00:00	SPY	ETF	338.56	339.07	338.16	338.4	4444559.0
2020-08-18 10:00:00	SPY	ETF	338.39	338.45	336.61	337.77	6569323.0
2020-08-18 11:00:00	SPY	ETF	337.77	338.46	337.67	338.38	4347815.0
2020-08-18 12:00:00	SPY	ETF	338.38	338.8	338.24	338.72	3006860.0
2020-08-18 13:00:00	SPY	ETF	338.71	338.94	338.49	338.73	2277261.0
2020-08-18 14:00:00	SPY	ETF	338.74	338.99	338.525	338.865	3691543.0
2020-08-18 15:00:00	SPY	ETF	338.88	339.1	338.28	338.62	8930872.0
2020-08-18 16:00:00	SPY	ETF	338.6	338.85	338.3683	338.83	3557296.0
2020-08-18 17:00:00	SPY	ETF	338.84	338.84	338.64	338.78	102161.0
2020-08-18 18:00:00	SPY	ETF	338.85	338.95	338.68	338.88	65165.0
2020-08-18 19:00:00	SPY	ETF	338.89	338.99	338.84	338.92	54244.0
2020-08-18 04:00:00	QQQ	ETF	275.26	275.55	275.26	275.55	33105.0
2020-08-18 05:00:00	QQQ	ETF	275.46	276.29	275.46	276.26	21471.0
2020-08-18 06:00:00	QQQ	ETF	276.18	276.44	276.17	276.38	18061.0
2020-08-18 07:00:00	QQQ	ETF	276.34	276.55	276.06	276.1	164976.0
2020-08-18 08:00:00	QQQ	ETF	275.54	276.78	275.21	276.5096	199952.0
2020-08-18 09:00:00	QQQ	ETF	276.478	277.64	276.23	276.68	3422941.0
2020-08-18 10:00:00	QQQ	ETF	276.685	276.83	274.91	276.65	4069455.0
2020-08-18 11:00:00	QQQ	ETF	276.66	277.13	276.41	277.02	1395911.0
2020-08-18 12:00:00	QQQ	ETF	277.02	277.73	276.95	277.39	1478692.0
2020-08-18 13:00:00	QQQ	ETF	277.38	277.78	277.22	277.53	1169243.0
2020-08-18 14:00:00	QQQ	ETF	277.54	278.14	277.27	278.05	2031526.0
2020-08-18 15:00:00	QQQ	ETF	278.05	278.465	277.78	277.962	4108033.0
2020-08-18 16:00:00	QQQ	ETF	277.96	278.43	277.89	278.4	1002722.0
2020-08-18 17:00:00	QQQ	ETF	278.11	278.4	278.1	278.3	18173.0
2020-08-18 18:00:00	QQQ	ETF	278.34	278.59	278.2	278.38	64063.0
2020-08-18 19:00:00	QQQ	ETF	278.4	278.55	278.33	278.5	212223.0
2020-08-18 04:00:00	IWM	ETF	157.93	158.0	157.72	157.93	6620.0
2020-08-18 05:00:00	IWM	ETF	158.0	158.07	157.93	157.98	3812.0
2020-08-18 06:00:00	IWM	ETF	158.04	158.15	157.96	158.15	7287.0
2020-08-18 07:00:00	IWM	ETF	158.14	158.27	157.95	157.98	65845.0
2020-08-18 08:00:00	IWM	ETF	157.9699	158.23	157.47	158.0	69676.0
2020-08-18 09:00:00	IWM	ETF	157.95	158.02	156.58	156.62	1815074.0
2020-08-18 10:00:00	IWM	ETF	156.64	157.079	155.71	156.41	2427482.0
2020-08-18 11:00:00	IWM	ETF	156.412	156.83	156.33	156.495	1001912.0
2020-08-18 12:00:00	IWM	ETF	156.495	156.72	156.15	156.505	817945.0
2020-08-18 13:00:00	IWM	ETF	156.505	156.615	156.35	156.52	705136.0
2020-08-18 14:00:00	IWM	ETF	156.505	156.59	156.25	156.33	759064.0
2020-08-18 15:00:00	IWM	ETF	156.34	156.57	156.07	156.39	2409390.0
2020-08-18 16:00:00	IWM	ETF	156.39	156.39	156.0	156.38	895068.0
2020-08-18 17:00:00	IWM	ETF	156.33	156.36	156.11	156.26	1611.0
2020-08-18 18:00:00	IWM	ETF	156.36	156.45	156.26	156.45	8683.0
2020-08-18 19:00:00	IWM	ETF	156.41	156.46	156.35	156.39	12006.0
2020-08-18 04:00:00	DIA	ETF	278.51	278.51	278.51	278.51	100.0
2020-08-18 05:00:00	DIA	ETF	279.01	279.33	279.01	279.33	1700.0

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

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