PREVIEW / etf_1hour / 2017-07-25

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-07-25.parquet
  size:    281 KB
  rows:    9,214

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
2017-07-25 04:00:00	SPY	ETF	246.72	246.9	246.68	246.87	4655.0
2017-07-25 05:00:00	SPY	ETF	246.85	247.05	246.85	246.94	1746.0
2017-07-25 06:00:00	SPY	ETF	246.98	247.17	246.96	247.11	44504.0
2017-07-25 07:00:00	SPY	ETF	247.17	247.36	247.15	247.33	151750.0
2017-07-25 08:00:00	SPY	ETF	247.3	247.46	247.15	247.39	436049.0
2017-07-25 09:00:00	SPY	ETF	247.39	247.73	247.29	247.46	7884636.0
2017-07-25 10:00:00	SPY	ETF	247.47	247.58	247.16	247.42	10786411.0
2017-07-25 11:00:00	SPY	ETF	247.42	247.78	247.415	247.7	4359354.0
2017-07-25 12:00:00	SPY	ETF	247.71	247.8	247.58	247.655	3299867.0
2017-07-25 13:00:00	SPY	ETF	247.65	247.75	247.61	247.65	5261070.0
2017-07-25 14:00:00	SPY	ETF	247.645	247.68	247.47	247.58	4796087.0
2017-07-25 15:00:00	SPY	ETF	247.59	247.72	247.3	247.39	10784762.0
2017-07-25 16:00:00	SPY	ETF	247.39	247.5382	247.25	247.46	4250930.0
2017-07-25 17:00:00	SPY	ETF	247.43	247.52	247.42	247.46	989663.0
2017-07-25 18:00:00	SPY	ETF	247.46	247.46	247.34	247.39	58183.0
2017-07-25 19:00:00	SPY	ETF	247.39	247.44	247.36	247.44	35324.0
2017-07-25 04:00:00	QQQ	ETF	144.4	144.4	144.36	144.36	10499.0
2017-07-25 05:00:00	QQQ	ETF	144.43	144.45	144.42	144.42	25097.0
2017-07-25 06:00:00	QQQ	ETF	144.4	144.57	144.4	144.53	36286.0
2017-07-25 07:00:00	QQQ	ETF	144.51	144.62	144.49	144.52	86042.0
2017-07-25 08:00:00	QQQ	ETF	144.5	144.66	144.255	144.31	510264.0
2017-07-25 09:00:00	QQQ	ETF	144.3	144.46	144.01	144.45	5029468.0
2017-07-25 10:00:00	QQQ	ETF	144.45	144.52	144.12	144.15	3192908.0
2017-07-25 11:00:00	QQQ	ETF	144.15	144.54	144.15	144.48	2679638.0
2017-07-25 12:00:00	QQQ	ETF	144.48	144.52	144.32	144.48	1399468.0
2017-07-25 13:00:00	QQQ	ETF	144.4748	144.7258	144.43	144.675	1812146.0
2017-07-25 14:00:00	QQQ	ETF	144.675	144.74	144.4701	144.5499	1716818.0
2017-07-25 15:00:00	QQQ	ETF	144.55	144.57	144.3	144.39	4373448.0
2017-07-25 16:00:00	QQQ	ETF	144.4	144.55	144.3	144.43	1491874.0
2017-07-25 17:00:00	QQQ	ETF	144.43	144.53	144.43	144.5	277524.0
2017-07-25 18:00:00	QQQ	ETF	144.47	144.47	144.38	144.43	15237.0
2017-07-25 19:00:00	QQQ	ETF	144.44	144.5	144.44	144.49	2849.0
2017-07-25 04:00:00	IWM	ETF	142.77	142.79	142.77	142.79	5644.0
2017-07-25 05:00:00	IWM	ETF	142.79	142.96	142.79	142.96	5777.0
2017-07-25 06:00:00	IWM	ETF	142.99	143.17	142.96	143.17	9587.0
2017-07-25 07:00:00	IWM	ETF	143.19	143.38	143.19	143.35	23056.0
2017-07-25 08:00:00	IWM	ETF	143.37	143.49	143.34	143.38	127329.0
2017-07-25 09:00:00	IWM	ETF	143.37	143.69	143.21	143.48	1995719.0
2017-07-25 10:00:00	IWM	ETF	143.49	143.8	143.44	143.63	2642339.0
2017-07-25 11:00:00	IWM	ETF	143.64	144.13	143.63	144.06	2698852.0
2017-07-25 12:00:00	IWM	ETF	144.06	144.25	144.04	144.05	1452291.0
2017-07-25 13:00:00	IWM	ETF	144.04	144.13	143.92	144.02	878330.0
2017-07-25 14:00:00	IWM	ETF	144.02	144.125	143.97	144.08	1031314.0
2017-07-25 15:00:00	IWM	ETF	144.09	144.17	143.86	144.04	3446283.0
2017-07-25 16:00:00	IWM	ETF	144.05	144.09	142.7733	144.06	2657654.0
2017-07-25 17:00:00	IWM	ETF	144.18	144.18	144.04	144.13	3358.0
2017-07-25 18:00:00	IWM	ETF	144.07	144.08	144.07	144.08	3855.0
2017-07-25 19:00:00	IWM	ETF	144.06	144.08	144.06	144.08	252.0
2017-07-25 05:00:00	DIA	ETF	215.3	215.3	215.3	215.3	100.0
2017-07-25 06:00:00	DIA	ETF	215.42	215.42	215.42	215.42	200.0

> showing 50 of 9,214 rows — these rows as CSV

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