PREVIEW / etf_1hour / 2019-01-16

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-01-16.parquet
  size:    320 KB
  rows:    10,635

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-01-16 04:00:00	SPY	ETF	260.77	260.83	260.33	260.42	11872.0
2019-01-16 05:00:00	SPY	ETF	260.47	260.72	260.31	260.32	17462.0
2019-01-16 06:00:00	SPY	ETF	260.26	260.36	260.14	260.35	10664.0
2019-01-16 07:00:00	SPY	ETF	260.38	260.66	260.09	260.54	135891.0
2019-01-16 08:00:00	SPY	ETF	260.1501	260.83	260.1501	260.61	214195.0
2019-01-16 09:00:00	SPY	ETF	260.61	261.72	260.35	261.415	8080246.0
2019-01-16 10:00:00	SPY	ETF	261.42	261.73	260.6	261.21	11078067.0
2019-01-16 11:00:00	SPY	ETF	261.215	261.625	260.66	261.005	7999049.0
2019-01-16 12:00:00	SPY	ETF	261.01	261.48	260.74	261.36	5311962.0
2019-01-16 13:00:00	SPY	ETF	261.36	261.52	261.08	261.41	3587739.0
2019-01-16 14:00:00	SPY	ETF	261.41	261.9666	261.4	261.49	9716385.0
2019-01-16 15:00:00	SPY	ETF	261.5	261.85	260.86	260.95	16278360.0
2019-01-16 16:00:00	SPY	ETF	260.95	261.06	260.59	260.88	12101420.0
2019-01-16 17:00:00	SPY	ETF	260.86	260.98	260.76	260.76	176844.0
2019-01-16 18:00:00	SPY	ETF	260.78	260.92	260.51	260.53	63868.0
2019-01-16 19:00:00	SPY	ETF	260.53	260.6	260.26	260.49	70171.0
2019-01-16 20:00:00	SPY	ETF	260.9701	260.98	260.9701	260.98	28259.0
2019-01-16 04:00:00	QQQ	ETF	162.38	162.58	162.26	162.35	15910.0
2019-01-16 05:00:00	QQQ	ETF	162.38	162.49	162.25	162.29	26671.0
2019-01-16 06:00:00	QQQ	ETF	162.28	162.37	162.19	162.35	14790.0
2019-01-16 07:00:00	QQQ	ETF	162.4	162.65	162.27	162.55	102484.0
2019-01-16 08:00:00	QQQ	ETF	162.38	162.8	162.3001	162.55	200971.0
2019-01-16 09:00:00	QQQ	ETF	162.55	163.78	162.55	163.43	4521740.0
2019-01-16 10:00:00	QQQ	ETF	163.44	163.66	162.37	162.69	4789245.0
2019-01-16 11:00:00	QQQ	ETF	162.7	163.24	162.29	162.53	4188717.0
2019-01-16 12:00:00	QQQ	ETF	162.5201	162.9	162.3	162.78	2676363.0
2019-01-16 13:00:00	QQQ	ETF	162.7573	162.77	162.5	162.635	1606454.0
2019-01-16 14:00:00	QQQ	ETF	162.635	163.04	162.63	162.7	2536533.0
2019-01-16 15:00:00	QQQ	ETF	162.71	162.94	162.3	162.38	5280102.0
2019-01-16 16:00:00	QQQ	ETF	162.4	162.45	162.0	162.21	2726002.0
2019-01-16 17:00:00	QQQ	ETF	162.21	162.24	162.16	162.17	68086.0
2019-01-16 18:00:00	QQQ	ETF	162.17	162.26	161.9	161.94	75879.0
2019-01-16 19:00:00	QQQ	ETF	161.95	162.06	161.74	161.96	52792.0
2019-01-16 07:00:00	IWM	ETF	143.51	143.56	143.48	143.56	2900.0
2019-01-16 08:00:00	IWM	ETF	143.55	143.69	143.38	143.65	15117.0
2019-01-16 09:00:00	IWM	ETF	143.66	144.92	143.66	144.87	2400623.0
2019-01-16 10:00:00	IWM	ETF	144.87	145.2501	143.94	144.88	4210884.0
2019-01-16 11:00:00	IWM	ETF	144.89	144.99	144.11	144.235	2305692.0
2019-01-16 12:00:00	IWM	ETF	144.22	144.66	144.09	144.48	1589871.0
2019-01-16 13:00:00	IWM	ETF	144.47	144.61	144.13	144.44	1030188.0
2019-01-16 14:00:00	IWM	ETF	144.44	144.845	144.435	144.5	2120137.0
2019-01-16 15:00:00	IWM	ETF	144.49	144.75	144.38	144.5	3643308.0
2019-01-16 16:00:00	IWM	ETF	144.52	144.6	144.12	144.4	1618165.0
2019-01-16 17:00:00	IWM	ETF	144.4	144.4	144.32	144.33	2224.0
2019-01-16 18:00:00	IWM	ETF	144.33	144.48	144.18	144.18	8950.0
2019-01-16 19:00:00	IWM	ETF	144.24	144.25	144.02	144.17	17650.0
2019-01-16 20:00:00	IWM	ETF	144.6386	144.6386	144.52	144.52	500.0
2019-01-16 04:00:00	DIA	ETF	241.06	241.06	241.06	241.06	221.0
2019-01-16 07:00:00	DIA	ETF	240.45	241.09	240.45	241.09	4068.0
2019-01-16 08:00:00	DIA	ETF	240.99	241.22	240.97	241.15	8032.0

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

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