PREVIEW / etf_1hour / 2018-10-09

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-10-09.parquet
  size:    312 KB
  rows:    10,189

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-10-09 04:00:00	SPY	ETF	287.59	287.6	287.35	287.5	41080.0
2018-10-09 05:00:00	SPY	ETF	287.5	287.5	286.86	286.86	37136.0
2018-10-09 06:00:00	SPY	ETF	286.84	287.17	286.68	287.09	46815.0
2018-10-09 07:00:00	SPY	ETF	287.17	287.18	286.34	286.38	389129.0
2018-10-09 08:00:00	SPY	ETF	286.6	287.93	286.38	287.35	660223.0
2018-10-09 09:00:00	SPY	ETF	287.36	287.87	286.77	287.84	8218421.0
2018-10-09 10:00:00	SPY	ETF	287.84	288.86	287.49	288.0225	10250389.0
2018-10-09 11:00:00	SPY	ETF	288.02	288.6	287.53	288.525	8054787.0
2018-10-09 12:00:00	SPY	ETF	288.53	288.75	287.18	287.46	11141958.0
2018-10-09 13:00:00	SPY	ETF	287.45	287.95	287.03	287.6701	6017901.0
2018-10-09 14:00:00	SPY	ETF	287.68	288.19	287.36	288.0849	7462420.0
2018-10-09 15:00:00	SPY	ETF	288.08	288.15	287.35	287.43	14256036.0
2018-10-09 16:00:00	SPY	ETF	287.42	287.72	287.29	287.6	6424190.0
2018-10-09 17:00:00	SPY	ETF	287.6	287.61	287.28	287.49	216186.0
2018-10-09 18:00:00	SPY	ETF	287.49	287.82	287.49	287.77	173126.0
2018-10-09 19:00:00	SPY	ETF	287.79	287.89	287.71	287.77	24346.0
2018-10-09 04:00:00	QQQ	ETF	179.1	179.11	178.86	179.06	41259.0
2018-10-09 05:00:00	QQQ	ETF	178.93	179.0	178.6	178.63	34020.0
2018-10-09 06:00:00	QQQ	ETF	178.62	178.85	178.46	178.82	44263.0
2018-10-09 07:00:00	QQQ	ETF	178.85	178.89	178.17	178.23	206578.0
2018-10-09 08:00:00	QQQ	ETF	178.24	179.43	178.2	179.12	634725.0
2018-10-09 09:00:00	QQQ	ETF	179.13	180.0	178.75	179.94	8158217.0
2018-10-09 10:00:00	QQQ	ETF	179.94	181.02	179.27	180.32	9405210.0
2018-10-09 11:00:00	QQQ	ETF	180.33	180.685	179.69	180.4781	5902560.0
2018-10-09 12:00:00	QQQ	ETF	180.5	180.69	179.28	179.42	4706781.0
2018-10-09 13:00:00	QQQ	ETF	179.43	179.85	178.93	179.5	4189794.0
2018-10-09 14:00:00	QQQ	ETF	179.5	180.03	179.16	179.91	3721857.0
2018-10-09 15:00:00	QQQ	ETF	179.9153	180.004	179.36	179.56	5410524.0
2018-10-09 16:00:00	QQQ	ETF	179.56	179.67	179.28	179.53	1889236.0
2018-10-09 17:00:00	QQQ	ETF	179.45	179.7	179.45	179.58	266198.0
2018-10-09 18:00:00	QQQ	ETF	179.58	179.82	179.53	179.78	30288.0
2018-10-09 19:00:00	QQQ	ETF	179.82	179.87	179.73	179.76	14167.0
2018-10-09 04:00:00	IWM	ETF	161.68	161.68	161.54	161.54	1824.0
2018-10-09 05:00:00	IWM	ETF	161.4	161.4	161.24	161.24	370.0
2018-10-09 06:00:00	IWM	ETF	161.19	161.42	161.19	161.39	1600.0
2018-10-09 07:00:00	IWM	ETF	161.4	161.4	161.03	161.09	104737.0
2018-10-09 08:00:00	IWM	ETF	161.15	161.66	161.1	161.65	102569.0
2018-10-09 09:00:00	IWM	ETF	161.63	162.45	161.44	162.3	2595219.0
2018-10-09 10:00:00	IWM	ETF	162.29	162.74	161.9	162.18	3485782.0
2018-10-09 11:00:00	IWM	ETF	162.17	162.65	161.93	162.19	2069648.0
2018-10-09 12:00:00	IWM	ETF	162.2	162.27	161.31	161.35	2354142.0
2018-10-09 13:00:00	IWM	ETF	161.36	161.59	161.08	161.48	1772776.0
2018-10-09 14:00:00	IWM	ETF	161.47	161.72	161.3	161.6	1560037.0
2018-10-09 15:00:00	IWM	ETF	161.6	161.68	160.98	161.19	3372368.0
2018-10-09 16:00:00	IWM	ETF	161.2	161.48	161.1	161.32	1439747.0
2018-10-09 17:00:00	IWM	ETF	161.38	161.38	161.09	161.11	39829.0
2018-10-09 18:00:00	IWM	ETF	161.22	161.43	161.22	161.43	30717.0
2018-10-09 19:00:00	IWM	ETF	161.49	161.54	161.4	161.4	3964.0
2018-10-09 06:00:00	DIA	ETF	263.78	263.78	263.78	263.78	100.0
2018-10-09 07:00:00	DIA	ETF	263.9	263.9	263.6	263.6	6617.0

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

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