PREVIEW / etf_1hour / 2019-02-25

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-02-25.parquet
  size:    333 KB
  rows:    11,002

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-25 04:00:00	SPY	ETF	279.9	280.16	279.9	280.03	33426.0
2019-02-25 05:00:00	SPY	ETF	280.02	280.33	280.0	280.29	26388.0
2019-02-25 06:00:00	SPY	ETF	280.35	280.46	280.3	280.35	46407.0
2019-02-25 07:00:00	SPY	ETF	280.29	280.36	280.2	280.36	154090.0
2019-02-25 08:00:00	SPY	ETF	280.37	280.71	279.75	280.71	388597.0
2019-02-25 09:00:00	SPY	ETF	280.73	281.08	280.61	280.63	8027541.0
2019-02-25 10:00:00	SPY	ETF	280.625	281.27	280.41	281.2	11168530.0
2019-02-25 11:00:00	SPY	ETF	281.2	281.31	280.78	280.9	8518355.0
2019-02-25 12:00:00	SPY	ETF	280.8864	280.95	280.08	280.25	8276332.0
2019-02-25 13:00:00	SPY	ETF	280.2562	280.42	279.95	280.21	4657841.0
2019-02-25 14:00:00	SPY	ETF	280.21	280.42	280.08	280.12	5442673.0
2019-02-25 15:00:00	SPY	ETF	280.12	280.19	279.43	279.57	15310384.0
2019-02-25 16:00:00	SPY	ETF	279.6	279.7611	279.42	279.47	5588704.0
2019-02-25 17:00:00	SPY	ETF	279.48	279.51	279.25	279.4	242688.0
2019-02-25 18:00:00	SPY	ETF	279.4	279.5	279.14	279.34	172172.0
2019-02-25 19:00:00	SPY	ETF	279.33	279.45	279.13	279.15	58122.0
2019-02-25 04:00:00	QQQ	ETF	173.41	173.64	173.41	173.6	30298.0
2019-02-25 05:00:00	QQQ	ETF	173.64	173.79	173.59	173.78	32506.0
2019-02-25 06:00:00	QQQ	ETF	173.81	173.91	173.77	173.86	18947.0
2019-02-25 07:00:00	QQQ	ETF	173.83	173.93	173.73	173.91	89204.0
2019-02-25 08:00:00	QQQ	ETF	173.75	174.18	173.23	174.17	273835.0
2019-02-25 09:00:00	QQQ	ETF	174.19	174.64	174.13	174.17	4262237.0
2019-02-25 10:00:00	QQQ	ETF	174.17	174.62	174.03	174.54	4566682.0
2019-02-25 11:00:00	QQQ	ETF	174.54	174.66	174.25	174.3184	3343914.0
2019-02-25 12:00:00	QQQ	ETF	174.31	174.335	173.43	173.65	3484216.0
2019-02-25 13:00:00	QQQ	ETF	173.65	173.85	173.585	173.8	2003078.0
2019-02-25 14:00:00	QQQ	ETF	173.8	174.06	173.7521	173.91	3192921.0
2019-02-25 15:00:00	QQQ	ETF	173.9176	174.05	173.4	173.51	5586936.0
2019-02-25 16:00:00	QQQ	ETF	173.52	173.64	173.43	173.52	1897203.0
2019-02-25 17:00:00	QQQ	ETF	173.57	173.57	173.43	173.45	37473.0
2019-02-25 18:00:00	QQQ	ETF	173.48	173.52	173.18	173.32	50816.0
2019-02-25 19:00:00	QQQ	ETF	173.3	173.37	173.1	173.1	45542.0
2019-02-25 04:00:00	IWM	ETF	158.64	158.71	158.64	158.7	400.0
2019-02-25 05:00:00	IWM	ETF	158.73	158.82	158.69	158.81	2500.0
2019-02-25 06:00:00	IWM	ETF	158.83	158.91	158.83	158.86	2700.0
2019-02-25 07:00:00	IWM	ETF	158.81	158.89	158.8	158.85	22850.0
2019-02-25 08:00:00	IWM	ETF	158.83	158.96	158.83	158.92	42446.0
2019-02-25 09:00:00	IWM	ETF	158.95	159.5	158.95	159.38	2263582.0
2019-02-25 10:00:00	IWM	ETF	159.39	159.48	158.72	159.38	2871009.0
2019-02-25 11:00:00	IWM	ETF	159.38	159.5	159.02	159.16	1332364.0
2019-02-25 12:00:00	IWM	ETF	159.15	159.162	158.325	158.43	1966875.0
2019-02-25 13:00:00	IWM	ETF	158.43	158.73	158.37	158.7	1188184.0
2019-02-25 14:00:00	IWM	ETF	158.69	158.79	158.32	158.39	845591.0
2019-02-25 15:00:00	IWM	ETF	158.39	158.48	158.09	158.19	3473672.0
2019-02-25 16:00:00	IWM	ETF	158.3616	158.83	158.0807	158.13	1252235.0
2019-02-25 17:00:00	IWM	ETF	158.11	158.14	157.85	158.05	80302.0
2019-02-25 18:00:00	IWM	ETF	158.01	158.08	157.88	157.98	47016.0
2019-02-25 19:00:00	IWM	ETF	158.05	158.07	157.9	157.9	18053.0
2019-02-25 04:00:00	DIA	ETF	260.96	261.2	260.96	261.2	700.0
2019-02-25 05:00:00	DIA	ETF	261.5	261.54	261.5	261.54	3090.0

> showing 50 of 11,002 rows — these rows as CSV

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