PREVIEW / etf_1hour / 2018-11-16

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-11-16.parquet
  size:    314 KB
  rows:    10,399

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-16 04:00:00	SPY	ETF	272.45	272.59	272.28	272.5	20862.0
2018-11-16 05:00:00	SPY	ETF	272.41	272.44	271.9	272.0	32668.0
2018-11-16 06:00:00	SPY	ETF	271.97	272.08	271.54	271.93	96190.0
2018-11-16 07:00:00	SPY	ETF	272.0	272.09	271.13	271.68	349604.0
2018-11-16 08:00:00	SPY	ETF	271.8301	272.54	270.77	272.06	1205657.0
2018-11-16 09:00:00	SPY	ETF	272.04	272.81	271.21	272.72	16172862.0
2018-11-16 10:00:00	SPY	ETF	272.695	273.95	272.2678	273.23	16544305.0
2018-11-16 11:00:00	SPY	ETF	273.24	273.41	272.05	272.3511	13479163.0
2018-11-16 12:00:00	SPY	ETF	272.36	274.75	271.85	273.8625	16707984.0
2018-11-16 13:00:00	SPY	ETF	273.865	274.015	272.35	272.86	9891857.0
2018-11-16 14:00:00	SPY	ETF	272.8638	273.92	272.68	273.83	9092905.0
2018-11-16 15:00:00	SPY	ETF	273.83	274.39	273.41	273.67	24834931.0
2018-11-16 16:00:00	SPY	ETF	273.67	274.35	273.4259	274.04	15196023.0
2018-11-16 17:00:00	SPY	ETF	273.6	274.22	273.6	273.95	1201801.0
2018-11-16 18:00:00	SPY	ETF	273.95	273.99	273.81	273.97	30542.0
2018-11-16 19:00:00	SPY	ETF	273.97	274.1	273.92	274.1	11552.0
2018-11-16 04:00:00	QQQ	ETF	167.21	167.21	166.66	166.93	27559.0
2018-11-16 05:00:00	QQQ	ETF	166.98	166.98	166.4	166.51	41478.0
2018-11-16 06:00:00	QQQ	ETF	166.51	166.55	166.07	166.39	64705.0
2018-11-16 07:00:00	QQQ	ETF	166.5	166.73	166.08	166.57	362601.0
2018-11-16 08:00:00	QQQ	ETF	166.28	167.5	165.75	166.68	878973.0
2018-11-16 09:00:00	QQQ	ETF	166.68	167.44	165.78	167.26	7076533.0
2018-11-16 10:00:00	QQQ	ETF	167.2301	168.1	166.805	167.39	6950870.0
2018-11-16 11:00:00	QQQ	ETF	167.41	167.5299	166.19	166.46	4985444.0
2018-11-16 12:00:00	QQQ	ETF	166.46	168.31	166.12	167.58	7918799.0
2018-11-16 13:00:00	QQQ	ETF	167.58	167.72	166.4985	166.84	3869366.0
2018-11-16 14:00:00	QQQ	ETF	166.83	168.03	166.72	167.98	3800753.0
2018-11-16 15:00:00	QQQ	ETF	167.97	168.29	167.43	167.52	10133502.0
2018-11-16 16:00:00	QQQ	ETF	167.53	168.04	167.44	167.97	2766169.0
2018-11-16 17:00:00	QQQ	ETF	167.5	167.98	167.5	167.9	6490103.0
2018-11-16 18:00:00	QQQ	ETF	167.9	168.05	167.85	168.05	52508.0
2018-11-16 19:00:00	QQQ	ETF	168.05	168.1	167.96	168.1	20465.0
2018-11-16 05:00:00	IWM	ETF	150.96	150.96	150.96	150.96	100.0
2018-11-16 06:00:00	IWM	ETF	150.73	150.79	150.73	150.76	4407.0
2018-11-16 07:00:00	IWM	ETF	150.7	150.7	150.37	150.6	9902.0
2018-11-16 08:00:00	IWM	ETF	150.77	150.77	150.11	150.77	51223.0
2018-11-16 09:00:00	IWM	ETF	150.75	151.3701	150.13	151.31	2931781.0
2018-11-16 10:00:00	IWM	ETF	151.3	151.89	150.91	151.27	2187074.0
2018-11-16 11:00:00	IWM	ETF	151.29	151.39	150.06	150.2599	2026347.0
2018-11-16 12:00:00	IWM	ETF	150.26	151.93	150.15	151.5	2744994.0
2018-11-16 13:00:00	IWM	ETF	151.5	151.6	150.52	151.0681	2232141.0
2018-11-16 14:00:00	IWM	ETF	151.06	151.74	150.94	151.67	3467945.0
2018-11-16 15:00:00	IWM	ETF	151.68	152.29	151.56	151.95	4832460.0
2018-11-16 16:00:00	IWM	ETF	151.94	152.32	151.6034	152.12	2348925.0
2018-11-16 17:00:00	IWM	ETF	151.94	152.13	151.94	152.01	1846980.0
2018-11-16 18:00:00	IWM	ETF	152.12	152.12	152.12	152.12	300.0
2018-11-16 19:00:00	IWM	ETF	152.17	152.24	152.12	152.24	1000.0
2018-11-16 04:00:00	DIA	ETF	252.85	252.85	252.13	252.13	200.0
2018-11-16 05:00:00	DIA	ETF	252.14	252.14	252.09	252.09	395.0
2018-11-16 06:00:00	DIA	ETF	251.85	251.85	251.85	251.85	100.0

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

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