PREVIEW / etf_1hour / 2019-02-20

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-02-20.parquet
  size:    323 KB
  rows:    10,771

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-02-20 04:00:00	SPY	ETF	277.72	277.87	277.27	277.27	8459.0
2019-02-20 05:00:00	SPY	ETF	277.38	277.59	277.37	277.56	6360.0
2019-02-20 06:00:00	SPY	ETF	277.56	277.56	277.37	277.56	3290.0
2019-02-20 07:00:00	SPY	ETF	277.6	277.66	277.53	277.59	43307.0
2019-02-20 08:00:00	SPY	ETF	277.58	277.77	277.38	277.68	230975.0
2019-02-20 09:00:00	SPY	ETF	277.68	278.08	277.64	278.02	5650691.0
2019-02-20 10:00:00	SPY	ETF	278.025	278.43	277.74	278.11	5549163.0
2019-02-20 11:00:00	SPY	ETF	278.11	278.54	278.0	278.36	7285917.0
2019-02-20 12:00:00	SPY	ETF	278.37	278.405	277.45	277.66	7477776.0
2019-02-20 13:00:00	SPY	ETF	277.64	278.62	277.6	278.42	5345982.0
2019-02-20 14:00:00	SPY	ETF	278.42	278.92	277.25	278.43	18913683.0
2019-02-20 15:00:00	SPY	ETF	278.43	278.59	278.11	278.44	16428310.0
2019-02-20 16:00:00	SPY	ETF	278.44	278.63	278.2951	278.52	8702847.0
2019-02-20 17:00:00	SPY	ETF	278.55	278.6	278.48	278.5	72346.0
2019-02-20 18:00:00	SPY	ETF	278.5	278.5	278.36	278.47	57329.0
2019-02-20 19:00:00	SPY	ETF	278.46	278.59	278.28	278.32	50830.0
2019-02-20 04:00:00	QQQ	ETF	172.28	172.3	171.97	171.97	5300.0
2019-02-20 05:00:00	QQQ	ETF	171.97	172.19	171.97	172.17	1000.0
2019-02-20 06:00:00	QQQ	ETF	172.22	172.22	171.99	172.13	15100.0
2019-02-20 07:00:00	QQQ	ETF	172.23	172.28	172.18	172.18	25567.0
2019-02-20 08:00:00	QQQ	ETF	172.21	172.45	172.11	172.39	80783.0
2019-02-20 09:00:00	QQQ	ETF	172.39	172.87	172.35	172.79	2000284.0
2019-02-20 10:00:00	QQQ	ETF	172.79	173.08	172.55	172.83	3175995.0
2019-02-20 11:00:00	QQQ	ETF	172.84	172.92	172.66	172.72	2011334.0
2019-02-20 12:00:00	QQQ	ETF	172.72	172.77	171.46	171.66	4581322.0
2019-02-20 13:00:00	QQQ	ETF	171.66	172.45	171.63	172.3415	2780394.0
2019-02-20 14:00:00	QQQ	ETF	172.35	172.71	171.32	172.15	7688696.0
2019-02-20 15:00:00	QQQ	ETF	172.15	172.37	171.95	172.27	3990146.0
2019-02-20 16:00:00	QQQ	ETF	172.27	172.37	172.22	172.28	744186.0
2019-02-20 17:00:00	QQQ	ETF	172.34	172.34	172.25	172.25	7195.0
2019-02-20 18:00:00	QQQ	ETF	172.2	172.25	172.15	172.22	11800.0
2019-02-20 19:00:00	QQQ	ETF	172.29	172.31	172.09	172.1	23312.0
2019-02-20 04:00:00	IWM	ETF	156.57	156.57	156.57	156.57	100.0
2019-02-20 05:00:00	IWM	ETF	156.48	156.53	156.48	156.53	3600.0
2019-02-20 06:00:00	IWM	ETF	156.5	156.5	156.42	156.43	8000.0
2019-02-20 07:00:00	IWM	ETF	156.56	156.56	156.56	156.56	100.0
2019-02-20 08:00:00	IWM	ETF	156.5	156.57	156.39	156.56	47496.0
2019-02-20 09:00:00	IWM	ETF	156.55	156.96	156.53	156.9	1469846.0
2019-02-20 10:00:00	IWM	ETF	156.9	157.12	156.61	156.99	1785508.0
2019-02-20 11:00:00	IWM	ETF	156.9877	157.47	156.86	157.32	1752259.0
2019-02-20 12:00:00	IWM	ETF	157.32	157.35	156.71	156.84	2547234.0
2019-02-20 13:00:00	IWM	ETF	156.84	157.34	156.81	157.2221	1100244.0
2019-02-20 14:00:00	IWM	ETF	157.23	157.58	156.75	157.39	2899441.0
2019-02-20 15:00:00	IWM	ETF	157.4	157.58	157.24	157.4	2835322.0
2019-02-20 16:00:00	IWM	ETF	157.4	157.56	157.2971	157.5	544216.0
2019-02-20 17:00:00	IWM	ETF	157.46	157.55	157.45	157.5	4794.0
2019-02-20 18:00:00	IWM	ETF	157.4	157.45	157.36	157.41	10481.0
2019-02-20 19:00:00	IWM	ETF	157.45	157.52	157.32	157.37	11520.0
2019-02-20 04:00:00	DIA	ETF	258.9	258.9	258.9	258.9	100.0
2019-02-20 06:00:00	DIA	ETF	258.3	258.3	258.3	258.3	500.0

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

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