PREVIEW / etf_1hour / 2019-05-08

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-05-08.parquet
  size:    322 KB
  rows:    10,767

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-05-08 04:00:00	SPY	ETF	288.98	289.42	288.41	288.69	23984.0
2019-05-08 05:00:00	SPY	ETF	288.57	288.59	287.37	287.37	26309.0
2019-05-08 06:00:00	SPY	ETF	287.44	287.58	287.16	287.46	46091.0
2019-05-08 07:00:00	SPY	ETF	287.44	287.45	286.49	287.13	587109.0
2019-05-08 08:00:00	SPY	ETF	287.38	289.0	286.44	287.66	3082305.0
2019-05-08 09:00:00	SPY	ETF	287.65	288.28	286.87	287.99	11221527.0
2019-05-08 10:00:00	SPY	ETF	288.015	288.75	287.24	288.71	10943045.0
2019-05-08 11:00:00	SPY	ETF	288.72	289.43	287.8	288.38	20107457.0
2019-05-08 12:00:00	SPY	ETF	288.37	288.96	287.745	288.9567	5309590.0
2019-05-08 13:00:00	SPY	ETF	288.95	289.11	288.4	288.72	5534683.0
2019-05-08 14:00:00	SPY	ETF	288.73	288.96	288.32	288.765	5169578.0
2019-05-08 15:00:00	SPY	ETF	288.77	289.25	287.44	287.56	17698107.0
2019-05-08 16:00:00	SPY	ETF	287.57	288.86	287.53	287.97	9282358.0
2019-05-08 17:00:00	SPY	ETF	287.97	288.04	287.5358	287.89	505450.0
2019-05-08 18:00:00	SPY	ETF	287.9	288.05	287.53	287.98	140121.0
2019-05-08 19:00:00	SPY	ETF	287.91	288.06	287.64	287.72	44899.0
2019-05-08 04:00:00	QQQ	ETF	186.79	187.33	186.0	186.89	77983.0
2019-05-08 05:00:00	QQQ	ETF	186.55	186.61	185.83	185.83	42318.0
2019-05-08 06:00:00	QQQ	ETF	185.8	185.99	185.61	185.85	67275.0
2019-05-08 07:00:00	QQQ	ETF	185.81	185.81	185.09	185.52	348820.0
2019-05-08 08:00:00	QQQ	ETF	185.39	186.85	185.01	185.76	1103148.0
2019-05-08 09:00:00	QQQ	ETF	185.7701	186.44	184.96	186.09	7271812.0
2019-05-08 10:00:00	QQQ	ETF	186.1	186.77	185.38	186.73	4334133.0
2019-05-08 11:00:00	QQQ	ETF	186.74	187.17	185.91	186.27	6401770.0
2019-05-08 12:00:00	QQQ	ETF	186.27	186.86	185.85	186.7832	2104765.0
2019-05-08 13:00:00	QQQ	ETF	186.79	187.034	186.34	186.5295	1976794.0
2019-05-08 14:00:00	QQQ	ETF	186.55	186.6899	186.18	186.52	1965396.0
2019-05-08 15:00:00	QQQ	ETF	186.53	186.955	185.61	185.63	5398751.0
2019-05-08 16:00:00	QQQ	ETF	185.64	186.16	185.64	185.95	2434968.0
2019-05-08 17:00:00	QQQ	ETF	185.98	186.04	185.76	185.91	131987.0
2019-05-08 18:00:00	QQQ	ETF	185.91	185.99	185.69	185.97	74325.0
2019-05-08 19:00:00	QQQ	ETF	185.97	186.0	185.75	185.77	54366.0
2019-05-08 04:00:00	IWM	ETF	158.3	158.3	158.18	158.18	667.0
2019-05-08 05:00:00	IWM	ETF	157.71	157.71	157.3	157.3	6267.0
2019-05-08 06:00:00	IWM	ETF	157.22	157.28	157.22	157.28	2100.0
2019-05-08 07:00:00	IWM	ETF	157.33	157.33	156.86	157.18	32289.0
2019-05-08 08:00:00	IWM	ETF	156.9101	157.75	156.9101	157.4599	115625.0
2019-05-08 09:00:00	IWM	ETF	157.38	157.86	156.65	157.5	2628407.0
2019-05-08 10:00:00	IWM	ETF	157.5169	157.76	156.73	157.34	2357913.0
2019-05-08 11:00:00	IWM	ETF	157.33	158.09	157.06	157.495	3250378.0
2019-05-08 12:00:00	IWM	ETF	157.5	157.7	156.84	157.6	935459.0
2019-05-08 13:00:00	IWM	ETF	157.61	157.66	157.22	157.3381	786331.0
2019-05-08 14:00:00	IWM	ETF	157.34	157.52	157.08	157.31	831390.0
2019-05-08 15:00:00	IWM	ETF	157.33	157.52	156.6801	156.75	3071935.0
2019-05-08 16:00:00	IWM	ETF	156.76	157.18	156.7129	156.93	753019.0
2019-05-08 17:00:00	IWM	ETF	156.76	156.99	156.76	156.95	4699.0
2019-05-08 18:00:00	IWM	ETF	156.95	156.95	156.77	156.95	3900.0
2019-05-08 19:00:00	IWM	ETF	156.84	156.88	156.76	156.84	3080.0
2019-05-08 04:00:00	DIA	ETF	260.47	260.71	260.47	260.71	1350.0
2019-05-08 06:00:00	DIA	ETF	259.06	259.28	258.88	259.28	12300.0

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

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