PREVIEW / etf_1hour / 2019-08-14

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-08-14.parquet
  size:    359 KB
  rows:    11,780

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-08-14 04:00:00	SPY	ETF	292.34	292.36	291.62	291.84	21022.0
2019-08-14 05:00:00	SPY	ETF	291.87	291.87	291.12	291.12	25540.0
2019-08-14 06:00:00	SPY	ETF	291.12	291.12	290.0	290.34	172273.0
2019-08-14 07:00:00	SPY	ETF	290.4	290.54	288.76	289.11	1007608.0
2019-08-14 08:00:00	SPY	ETF	290.43	293.0	288.42	289.16	2655481.0
2019-08-14 09:00:00	SPY	ETF	289.18	292.55	287.38	288.31	13983471.0
2019-08-14 10:00:00	SPY	ETF	288.29	288.31	286.58	286.61	13551391.0
2019-08-14 11:00:00	SPY	ETF	286.595	292.4644	285.41	285.7	12776210.0
2019-08-14 12:00:00	SPY	ETF	285.7	285.76	284.22	284.38	12280894.0
2019-08-14 13:00:00	SPY	ETF	284.38	292.4644	283.97	285.5199	14136963.0
2019-08-14 14:00:00	SPY	ETF	285.52	285.71	284.0	284.55	11393955.0
2019-08-14 15:00:00	SPY	ETF	284.54	285.61	283.76	283.92	37462300.0
2019-08-14 16:00:00	SPY	ETF	283.92	292.4644	283.47	283.49	12350085.0
2019-08-14 17:00:00	SPY	ETF	283.51	283.75	283.41	283.55	397888.0
2019-08-14 18:00:00	SPY	ETF	283.51	283.91	283.28	283.45	527584.0
2019-08-14 19:00:00	SPY	ETF	283.54	284.53	283.42	284.47	160524.0
2019-08-14 04:00:00	QQQ	ETF	188.22	188.33	187.75	187.83	28783.0
2019-08-14 05:00:00	QQQ	ETF	187.85	187.85	187.25	187.36	17277.0
2019-08-14 06:00:00	QQQ	ETF	187.33	187.36	186.47	186.8	62950.0
2019-08-14 07:00:00	QQQ	ETF	186.89	187.0	185.75	185.99	380741.0
2019-08-14 08:00:00	QQQ	ETF	186.34	188.79	185.4	185.95	549937.0
2019-08-14 09:00:00	QQQ	ETF	186.0	188.39	184.79	185.62	6054588.0
2019-08-14 10:00:00	QQQ	ETF	185.6	185.64	184.21	184.21	5657628.0
2019-08-14 11:00:00	QQQ	ETF	184.21	184.38	183.18	183.36	6372369.0
2019-08-14 12:00:00	QQQ	ETF	183.34	183.5127	182.5499	182.68	5008528.0
2019-08-14 13:00:00	QQQ	ETF	182.67	183.8862	182.42	183.46	4897262.0
2019-08-14 14:00:00	QQQ	ETF	183.43	183.66	182.515	182.9835	3474839.0
2019-08-14 15:00:00	QQQ	ETF	182.97	183.69	182.52	182.71	9762431.0
2019-08-14 16:00:00	QQQ	ETF	182.7	183.01	182.15	182.15	2620894.0
2019-08-14 17:00:00	QQQ	ETF	182.2	182.33	182.05	182.17	46686.0
2019-08-14 18:00:00	QQQ	ETF	182.16	182.24	181.9	181.93	137177.0
2019-08-14 19:00:00	QQQ	ETF	181.98	182.8	181.96	182.77	161696.0
2019-08-14 04:00:00	IWM	ETF	150.14	150.14	149.93	149.93	9600.0
2019-08-14 05:00:00	IWM	ETF	149.64	149.67	149.52	149.52	8490.0
2019-08-14 06:00:00	IWM	ETF	149.48	149.48	148.9	149.01	6338.0
2019-08-14 07:00:00	IWM	ETF	149.05	149.05	148.25	148.34	389463.0
2019-08-14 08:00:00	IWM	ETF	148.55	149.06	148.11	148.4899	171324.0
2019-08-14 09:00:00	IWM	ETF	148.45	148.45	146.99	147.58	4322245.0
2019-08-14 10:00:00	IWM	ETF	147.55	147.56	146.84	146.85	3286237.0
2019-08-14 11:00:00	IWM	ETF	146.84	147.05	146.25	146.42	3086931.0
2019-08-14 12:00:00	IWM	ETF	146.41	147.125	145.88	145.97	2139031.0
2019-08-14 13:00:00	IWM	ETF	145.965	146.77	145.72	146.6	2062993.0
2019-08-14 14:00:00	IWM	ETF	146.59	146.6	145.84	146.175	2283205.0
2019-08-14 15:00:00	IWM	ETF	146.16	146.66	145.82	146.08	5500918.0
2019-08-14 16:00:00	IWM	ETF	146.09	146.25	145.88	145.95	1434003.0
2019-08-14 17:00:00	IWM	ETF	145.97	146.06	145.9	145.9	18193.0
2019-08-14 18:00:00	IWM	ETF	145.91	146.12	145.8	145.9	29323.0
2019-08-14 19:00:00	IWM	ETF	145.9	146.39	145.9	146.39	10100.0
2019-08-14 04:00:00	DIA	ETF	262.96	262.96	262.96	262.96	200.0
2019-08-14 05:00:00	DIA	ETF	262.38	262.38	262.38	262.38	200.0

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

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