PREVIEW / etf_1hour / 2018-11-28

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-11-28.parquet
  size:    328 KB
  rows:    10,752

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
2018-11-28 04:00:00	SPY	ETF	268.84	269.07	268.62	268.87	50585.0
2018-11-28 05:00:00	SPY	ETF	268.77	269.24	268.73	269.24	24650.0
2018-11-28 06:00:00	SPY	ETF	269.24	269.38	269.01	269.29	56805.0
2018-11-28 07:00:00	SPY	ETF	269.43	269.8	269.33	269.67	233443.0
2018-11-28 08:00:00	SPY	ETF	269.61	269.78	268.7	269.61	352967.0
2018-11-28 09:00:00	SPY	ETF	269.61	269.91	269.18	269.34	7684903.0
2018-11-28 10:00:00	SPY	ETF	269.33	269.655	268.53	269.01	9656528.0
2018-11-28 11:00:00	SPY	ETF	269.01	269.75	268.96	269.64	10329192.0
2018-11-28 12:00:00	SPY	ETF	269.635	272.83	269.61	272.33	29784876.0
2018-11-28 13:00:00	SPY	ETF	272.34	273.49	271.85	273.3	17437220.0
2018-11-28 14:00:00	SPY	ETF	273.3	273.58	272.77	272.81	11103754.0
2018-11-28 15:00:00	SPY	ETF	272.82	274.55	272.5473	274.49	25477066.0
2018-11-28 16:00:00	SPY	ETF	274.48	274.58	273.3252	274.17	12785298.0
2018-11-28 17:00:00	SPY	ETF	274.19	274.58	273.89	273.93	239846.0
2018-11-28 18:00:00	SPY	ETF	273.91	274.13	273.77	274.03	217585.0
2018-11-28 19:00:00	SPY	ETF	274.03	274.25	273.92	273.99	189296.0
2018-11-28 04:00:00	QQQ	ETF	163.91	164.02	163.74	163.92	38834.0
2018-11-28 05:00:00	QQQ	ETF	163.89	164.33	163.83	164.33	88542.0
2018-11-28 06:00:00	QQQ	ETF	164.33	164.44	164.18	164.44	188422.0
2018-11-28 07:00:00	QQQ	ETF	164.43	164.73	164.39	164.56	255204.0
2018-11-28 08:00:00	QQQ	ETF	164.49	164.76	163.62	164.64	448285.0
2018-11-28 09:00:00	QQQ	ETF	164.64	164.89	164.12	164.44	4914141.0
2018-11-28 10:00:00	QQQ	ETF	164.44	164.77	163.71	163.92	4317399.0
2018-11-28 11:00:00	QQQ	ETF	163.91	164.46	163.83	164.34	3430212.0
2018-11-28 12:00:00	QQQ	ETF	164.37	167.23	164.34	166.58	14293527.0
2018-11-28 13:00:00	QQQ	ETF	166.58	167.85	166.18	167.65	7965191.0
2018-11-28 14:00:00	QQQ	ETF	167.65	167.89	167.2601	167.43	4578108.0
2018-11-28 15:00:00	QQQ	ETF	167.42	168.69	167.22	168.65	10827749.0
2018-11-28 16:00:00	QQQ	ETF	168.65	168.72	168.42	168.54	3157697.0
2018-11-28 17:00:00	QQQ	ETF	168.43	168.57	168.43	168.45	56413.0
2018-11-28 18:00:00	QQQ	ETF	168.33	168.5	168.25	168.41	112944.0
2018-11-28 19:00:00	QQQ	ETF	168.41	168.61	168.32	168.32	50183.0
2018-11-28 04:00:00	IWM	ETF	148.9	148.9	148.9	148.9	300.0
2018-11-28 05:00:00	IWM	ETF	148.79	148.99	148.79	148.98	1700.0
2018-11-28 06:00:00	IWM	ETF	149.05	149.09	149.05	149.08	1800.0
2018-11-28 07:00:00	IWM	ETF	149.2	149.46	149.19	149.28	48823.0
2018-11-28 08:00:00	IWM	ETF	149.23	149.37	148.74	149.21	37524.0
2018-11-28 09:00:00	IWM	ETF	149.17	149.58	148.88	149.34	1858090.0
2018-11-28 10:00:00	IWM	ETF	149.3	149.51	147.7	148.36	2744549.0
2018-11-28 11:00:00	IWM	ETF	148.36	149.635	148.33	149.39	2268463.0
2018-11-28 12:00:00	IWM	ETF	149.39	151.68	149.36	151.43	5560338.0
2018-11-28 13:00:00	IWM	ETF	151.43	151.85	150.95	151.73	3244607.0
2018-11-28 14:00:00	IWM	ETF	151.74	151.86	151.39	151.46	1869879.0
2018-11-28 15:00:00	IWM	ETF	151.46	152.37	151.2	152.27	4237821.0
2018-11-28 16:00:00	IWM	ETF	152.26	152.27	151.81	151.81	1183327.0
2018-11-28 17:00:00	IWM	ETF	151.81	151.85	151.75	151.81	16751.0
2018-11-28 18:00:00	IWM	ETF	151.75	151.81	151.64	151.81	13403.0
2018-11-28 19:00:00	IWM	ETF	151.84	151.91	151.7	151.7	8187.0
2018-11-28 05:00:00	DIA	ETF	248.4	248.4	248.4	248.4	1609.0
2018-11-28 06:00:00	DIA	ETF	248.4	248.4	248.4	248.4	1000.0

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

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