PREVIEW / etf_1hour / 2017-08-08

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-08-08.parquet
  size:    284 KB
  rows:    9,272

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
2017-08-08 04:00:00	SPY	ETF	247.81	247.81	247.65	247.65	1632.0
2017-08-08 05:00:00	SPY	ETF	247.65	247.71	247.65	247.71	1100.0
2017-08-08 06:00:00	SPY	ETF	247.71	247.71	247.67	247.71	6200.0
2017-08-08 07:00:00	SPY	ETF	247.73	247.74	247.45	247.51	353156.0
2017-08-08 08:00:00	SPY	ETF	247.53	247.59	247.47	247.53	288654.0
2017-08-08 09:00:00	SPY	ETF	247.53	247.65	247.33	247.61	3938097.0
2017-08-08 10:00:00	SPY	ETF	247.61	248.32	247.5701	248.3	5969978.0
2017-08-08 11:00:00	SPY	ETF	248.3	248.81	248.25	248.78	6665729.0
2017-08-08 12:00:00	SPY	ETF	248.79	248.91	248.28	248.29	5933354.0
2017-08-08 13:00:00	SPY	ETF	248.29	248.36	247.8625	248.12	4738510.0
2017-08-08 14:00:00	SPY	ETF	248.12	248.14	247.74	247.79	4109041.0
2017-08-08 15:00:00	SPY	ETF	247.79	247.83	246.83	247.291	19155560.0
2017-08-08 16:00:00	SPY	ETF	247.29	247.9958	247.21	247.24	8749974.0
2017-08-08 17:00:00	SPY	ETF	247.22	247.32	247.08	247.08	231273.0
2017-08-08 18:00:00	SPY	ETF	247.06	247.11	246.87	246.99	113568.0
2017-08-08 19:00:00	SPY	ETF	246.98	247.0	246.74	246.84	84248.0
2017-08-08 04:00:00	QQQ	ETF	144.49	144.49	144.49	144.49	700.0
2017-08-08 05:00:00	QQQ	ETF	144.46	144.55	144.46	144.55	15100.0
2017-08-08 06:00:00	QQQ	ETF	144.54	144.54	144.52	144.54	10100.0
2017-08-08 07:00:00	QQQ	ETF	144.5	144.5	144.33	144.41	235260.0
2017-08-08 08:00:00	QQQ	ETF	144.37	144.42	144.21	144.25	52299.0
2017-08-08 09:00:00	QQQ	ETF	144.25	144.36	144.0	144.3	2679251.0
2017-08-08 10:00:00	QQQ	ETF	144.305	144.7	144.24	144.69	2819290.0
2017-08-08 11:00:00	QQQ	ETF	144.68	145.34	144.6	145.3	3496957.0
2017-08-08 12:00:00	QQQ	ETF	145.3	145.47	145.16	145.17	3346750.0
2017-08-08 13:00:00	QQQ	ETF	145.165	145.26	144.86	145.04	3040856.0
2017-08-08 14:00:00	QQQ	ETF	145.05	145.06	144.81	144.85	1953510.0
2017-08-08 15:00:00	QQQ	ETF	144.8501	144.87	143.9	144.31	8190119.0
2017-08-08 16:00:00	QQQ	ETF	144.29	145.393	144.05	144.07	1019604.0
2017-08-08 17:00:00	QQQ	ETF	144.05	144.12	143.91	143.95	47470.0
2017-08-08 18:00:00	QQQ	ETF	143.93	143.98	143.83	143.95	45555.0
2017-08-08 19:00:00	QQQ	ETF	143.89	143.93	143.68	143.75	87709.0
2017-08-08 06:00:00	IWM	ETF	140.37	140.37	140.37	140.37	503.0
2017-08-08 07:00:00	IWM	ETF	140.4	140.4	140.18	140.22	72812.0
2017-08-08 08:00:00	IWM	ETF	140.18	140.33	140.18	140.32	137074.0
2017-08-08 09:00:00	IWM	ETF	140.33	140.43	139.81	140.22	1845601.0
2017-08-08 10:00:00	IWM	ETF	140.22	141.42	140.21	141.39	4152338.0
2017-08-08 11:00:00	IWM	ETF	141.3999	141.79	141.34	141.77	4178458.0
2017-08-08 12:00:00	IWM	ETF	141.765	141.765	140.47	140.59	3668261.0
2017-08-08 13:00:00	IWM	ETF	140.5801	140.84	140.39	140.68	2741381.0
2017-08-08 14:00:00	IWM	ETF	140.69	140.95	140.55	140.72	1821784.0
2017-08-08 15:00:00	IWM	ETF	140.72	140.74	139.69	140.02	6073868.0
2017-08-08 16:00:00	IWM	ETF	140.0	140.5222	139.91	140.1	1174987.0
2017-08-08 17:00:00	IWM	ETF	140.09	140.2	140.01	140.01	12042.0
2017-08-08 18:00:00	IWM	ETF	140.0	140.0	139.83	139.86	6479.0
2017-08-08 19:00:00	IWM	ETF	139.86	139.86	139.81	139.81	4130.0
2017-08-08 07:00:00	DIA	ETF	220.81	220.81	220.8	220.8	250.0
2017-08-08 08:00:00	DIA	ETF	220.85	220.85	220.71	220.75	1652.0
2017-08-08 09:00:00	DIA	ETF	220.83	220.96	220.68	220.91	263992.0
2017-08-08 10:00:00	DIA	ETF	220.92	221.475	220.9099	221.4301	489945.0

> showing 50 of 9,272 rows — these rows as CSV

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