PREVIEW / etf_1hour / 2020-04-23

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-04-23.parquet
  size:    370 KB
  rows:    12,505

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-04-23 04:00:00	SPY	ETF	278.25	279.14	278.0	278.72	68624.0
2020-04-23 05:00:00	SPY	ETF	278.58	279.97	278.58	279.86	56894.0
2020-04-23 06:00:00	SPY	ETF	279.91	279.92	278.69	278.69	65091.0
2020-04-23 07:00:00	SPY	ETF	278.7	279.48	278.7	279.2	221229.0
2020-04-23 08:00:00	SPY	ETF	279.1801	280.94	278.12	280.84	1791294.0
2020-04-23 09:00:00	SPY	ETF	280.8	282.38	280.15	281.52	9910567.0
2020-04-23 10:00:00	SPY	ETF	281.5	283.94	281.02	283.2801	13592289.0
2020-04-23 11:00:00	SPY	ETF	283.29	283.4	281.8	282.29	10308958.0
2020-04-23 12:00:00	SPY	ETF	282.31	283.12	278.88	281.01	20978455.0
2020-04-23 13:00:00	SPY	ETF	281.03	282.01	279.06	279.8801	15850153.0
2020-04-23 14:00:00	SPY	ETF	279.88	281.53	278.75	281.3304	10496982.0
2020-04-23 15:00:00	SPY	ETF	281.32	281.42	279.03	279.06	16461344.0
2020-04-23 16:00:00	SPY	ETF	279.03	279.175	278.19	278.49	3334074.0
2020-04-23 17:00:00	SPY	ETF	278.5	279.08	278.03	278.07	148223.0
2020-04-23 18:00:00	SPY	ETF	278.1	278.46	276.74	277.33	654712.0
2020-04-23 19:00:00	SPY	ETF	277.27	277.56	276.9	277.37	367582.0
2020-04-23 04:00:00	QQQ	ETF	210.12	210.55	209.8	210.3	15967.0
2020-04-23 05:00:00	QQQ	ETF	210.23	211.35	210.23	211.35	24210.0
2020-04-23 06:00:00	QQQ	ETF	211.19	211.23	210.34	210.41	96778.0
2020-04-23 07:00:00	QQQ	ETF	210.5	211.1	210.5	210.97	140075.0
2020-04-23 08:00:00	QQQ	ETF	210.99	212.25	209.94	212.18	363106.0
2020-04-23 09:00:00	QQQ	ETF	212.25	213.41	211.4293	212.9219	5159908.0
2020-04-23 10:00:00	QQQ	ETF	212.91	214.435	212.6	214.01	5871197.0
2020-04-23 11:00:00	QQQ	ETF	214.01	214.04	212.77	213.04	3846266.0
2020-04-23 12:00:00	QQQ	ETF	213.035	213.89	210.2	212.3999	7756194.0
2020-04-23 13:00:00	QQQ	ETF	212.39	213.15	210.29	210.88	5068538.0
2020-04-23 14:00:00	QQQ	ETF	210.87	212.5	210.095	212.37	4753495.0
2020-04-23 15:00:00	QQQ	ETF	212.3815	212.42	210.39	210.55	4865658.0
2020-04-23 16:00:00	QQQ	ETF	210.55	210.5911	209.68	209.96	1160376.0
2020-04-23 17:00:00	QQQ	ETF	209.83	210.0	209.34	209.45	66746.0
2020-04-23 18:00:00	QQQ	ETF	209.45	209.69	208.31	208.7	209916.0
2020-04-23 19:00:00	QQQ	ETF	208.82	208.91	208.41	208.79	129783.0
2020-04-23 04:00:00	IWM	ETF	118.96	119.09	118.96	119.09	450.0
2020-04-23 05:00:00	IWM	ETF	118.98	119.57	118.98	119.45	8040.0
2020-04-23 06:00:00	IWM	ETF	119.41	119.41	119.17	119.22	1800.0
2020-04-23 07:00:00	IWM	ETF	119.03	119.26	119.03	119.18	29255.0
2020-04-23 08:00:00	IWM	ETF	119.1399	120.18	119.07	120.08	266574.0
2020-04-23 09:00:00	IWM	ETF	120.11	121.24	119.68	120.83	3371183.0
2020-04-23 10:00:00	IWM	ETF	120.82	122.9	120.56	122.39	4644216.0
2020-04-23 11:00:00	IWM	ETF	122.39	122.46	121.375	121.75	2883262.0
2020-04-23 12:00:00	IWM	ETF	121.76	122.47	119.735	121.22	6242191.0
2020-04-23 13:00:00	IWM	ETF	121.24	122.07	120.3634	120.75	3914688.0
2020-04-23 14:00:00	IWM	ETF	120.74	121.96	120.19	121.8	2450297.0
2020-04-23 15:00:00	IWM	ETF	121.78	121.85	120.415	120.43	6356136.0
2020-04-23 16:00:00	IWM	ETF	120.44	120.49	120.0	120.23	2698412.0
2020-04-23 17:00:00	IWM	ETF	120.31	120.44	120.01	120.27	33599.0
2020-04-23 18:00:00	IWM	ETF	120.02	120.38	119.21	119.41	62674.0
2020-04-23 19:00:00	IWM	ETF	119.5	119.55	119.27	119.5	26548.0
2020-04-23 04:00:00	DIA	ETF	234.18	234.47	234.06	234.38	33848.0
2020-04-23 05:00:00	DIA	ETF	234.35	234.87	234.35	234.87	700.0

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

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