PREVIEW / etf_1hour / 2018-12-06

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-12-06.parquet
  size:    352 KB
  rows:    11,465

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-12-06 04:00:00	SPY	ETF	267.63	267.63	265.52	265.58	222714.0
2018-12-06 05:00:00	SPY	ETF	265.67	266.1	265.37	265.84	202179.0
2018-12-06 06:00:00	SPY	ETF	265.72	266.49	265.5	265.98	288881.0
2018-12-06 07:00:00	SPY	ETF	265.98	266.73	265.92	266.34	490287.0
2018-12-06 08:00:00	SPY	ETF	266.3201	268.55	265.69	266.33	1213771.0
2018-12-06 09:00:00	SPY	ETF	266.36	267.15	264.62	265.07	22032515.0
2018-12-06 10:00:00	SPY	ETF	265.07	266.13	264.06	264.27	24639107.0
2018-12-06 11:00:00	SPY	ETF	264.26	265.02	262.44	264.87	27933556.0
2018-12-06 12:00:00	SPY	ETF	264.86	267.09	264.39	266.65	22327464.0
2018-12-06 13:00:00	SPY	ETF	266.64	267.24	264.75	267.2	20052584.0
2018-12-06 14:00:00	SPY	ETF	267.1803	267.639	265.19	267.0299	20850313.0
2018-12-06 15:00:00	SPY	ETF	267.03	269.97	266.55	269.93	43936262.0
2018-12-06 16:00:00	SPY	ETF	269.94	270.3161	262.85	269.83	17109035.0
2018-12-06 17:00:00	SPY	ETF	269.78	269.94	269.75	269.8	156558.0
2018-12-06 18:00:00	SPY	ETF	269.76	270.0	269.42	269.87	249742.0
2018-12-06 19:00:00	SPY	ETF	269.9	270.14	269.28	269.48	163106.0
2018-12-06 04:00:00	QQQ	ETF	163.61	163.61	161.91	161.92	129424.0
2018-12-06 05:00:00	QQQ	ETF	161.89	162.34	161.78	162.04	154127.0
2018-12-06 06:00:00	QQQ	ETF	162.05	162.59	161.9	162.35	74531.0
2018-12-06 07:00:00	QQQ	ETF	162.37	162.99	162.33	162.76	330485.0
2018-12-06 08:00:00	QQQ	ETF	162.55	165.72	161.81	162.78	531590.0
2018-12-06 09:00:00	QQQ	ETF	162.75	164.16	162.03	162.67	9804983.0
2018-12-06 10:00:00	QQQ	ETF	162.69	163.97	162.45	162.78	10475375.0
2018-12-06 11:00:00	QQQ	ETF	162.77	164.09	161.77	164.06	8993120.0
2018-12-06 12:00:00	QQQ	ETF	164.07	165.81	163.56	165.41	9247715.0
2018-12-06 13:00:00	QQQ	ETF	165.41	165.69	163.96	165.63	6608376.0
2018-12-06 14:00:00	QQQ	ETF	165.63	165.93	164.08	165.3085	6742812.0
2018-12-06 15:00:00	QQQ	ETF	165.31	166.91	164.85	166.89	10965877.0
2018-12-06 16:00:00	QQQ	ETF	166.9	167.14	166.35	166.87	2167963.0
2018-12-06 17:00:00	QQQ	ETF	166.88	166.97	166.87	166.89	45945.0
2018-12-06 18:00:00	QQQ	ETF	166.89	167.01	166.6	166.95	60972.0
2018-12-06 19:00:00	QQQ	ETF	166.99	167.15	166.51	166.68	81710.0
2018-12-06 04:00:00	IWM	ETF	146.55	146.55	145.34	145.34	17323.0
2018-12-06 05:00:00	IWM	ETF	145.32	145.36	144.94	145.14	60239.0
2018-12-06 06:00:00	IWM	ETF	145.18	145.32	144.87	144.95	64621.0
2018-12-06 07:00:00	IWM	ETF	145.08	145.75	145.01	145.64	323003.0
2018-12-06 08:00:00	IWM	ETF	145.09	146.49	145.09	145.63	169476.0
2018-12-06 09:00:00	IWM	ETF	145.62	145.77	144.16	144.44	5470507.0
2018-12-06 10:00:00	IWM	ETF	144.46	146.18	144.26	144.59	5421375.0
2018-12-06 11:00:00	IWM	ETF	144.59	145.44	143.43	145.22	4884849.0
2018-12-06 12:00:00	IWM	ETF	145.2142	146.04	144.98	145.63	3472735.0
2018-12-06 13:00:00	IWM	ETF	145.61	146.06	144.45	146.04	2608903.0
2018-12-06 14:00:00	IWM	ETF	146.0143	146.36	144.97	145.8	3213127.0
2018-12-06 15:00:00	IWM	ETF	145.79	147.13	145.33	147.11	7403781.0
2018-12-06 16:00:00	IWM	ETF	147.13	147.41	146.85	147.12	1373551.0
2018-12-06 17:00:00	IWM	ETF	147.05	154.39	146.99	147.01	28902.0
2018-12-06 18:00:00	IWM	ETF	147.0	147.27	146.99	147.14	32857.0
2018-12-06 19:00:00	IWM	ETF	147.16	147.25	146.93	147.06	109087.0
2018-12-06 04:00:00	DIA	ETF	248.48	248.48	246.4	246.4	2129.0
2018-12-06 05:00:00	DIA	ETF	245.84	246.48	245.84	246.3	8900.0

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

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