PREVIEW / etf_1hour / 2018-10-08

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-10-08.parquet
  size:    314 KB
  rows:    10,274

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-08 04:00:00	SPY	ETF	287.5	287.72	287.2	287.2	28276.0
2018-10-08 05:00:00	SPY	ETF	287.23	287.74	287.23	287.63	17895.0
2018-10-08 06:00:00	SPY	ETF	287.66	287.74	287.34	287.52	68568.0
2018-10-08 07:00:00	SPY	ETF	287.49	287.83	287.41	287.79	206871.0
2018-10-08 08:00:00	SPY	ETF	287.716	288.31	287.43	287.5	555681.0
2018-10-08 09:00:00	SPY	ETF	287.5	288.0	286.71	287.7275	7986189.0
2018-10-08 10:00:00	SPY	ETF	287.73	288.19	287.39	287.57	6633945.0
2018-10-08 11:00:00	SPY	ETF	287.57	287.5985	285.5	286.135	13882658.0
2018-10-08 12:00:00	SPY	ETF	286.1367	286.5388	285.57	285.6	9463329.0
2018-10-08 13:00:00	SPY	ETF	285.59	286.69	285.55	286.4	8899825.0
2018-10-08 14:00:00	SPY	ETF	286.3827	287.94	286.34	287.59	11780981.0
2018-10-08 15:00:00	SPY	ETF	287.59	288.22	287.515	287.8	17823262.0
2018-10-08 16:00:00	SPY	ETF	287.78	288.23	286.0	288.09	8708676.0
2018-10-08 17:00:00	SPY	ETF	288.09	288.09	288.01	288.06	148058.0
2018-10-08 18:00:00	SPY	ETF	288.06	288.15	288.0	288.08	66152.0
2018-10-08 19:00:00	SPY	ETF	288.12	288.12	287.89	287.94	25075.0
2018-10-08 04:00:00	QQQ	ETF	179.85	179.86	179.4	179.44	7774.0
2018-10-08 05:00:00	QQQ	ETF	179.46	180.01	179.46	179.93	39809.0
2018-10-08 06:00:00	QQQ	ETF	179.97	180.06	179.76	179.86	52788.0
2018-10-08 07:00:00	QQQ	ETF	179.92	180.28	179.83	180.23	202584.0
2018-10-08 08:00:00	QQQ	ETF	179.85	180.51	179.82	179.9	359918.0
2018-10-08 09:00:00	QQQ	ETF	179.87	180.27	178.72	180.08	5975847.0
2018-10-08 10:00:00	QQQ	ETF	180.08	180.6427	179.45	179.75	5257865.0
2018-10-08 11:00:00	QQQ	ETF	179.74	179.76	177.12	178.1	12564467.0
2018-10-08 12:00:00	QQQ	ETF	178.1	178.2455	176.95	177.0	9302729.0
2018-10-08 13:00:00	QQQ	ETF	176.995	178.34	176.93	177.92	6832585.0
2018-10-08 14:00:00	QQQ	ETF	177.94	179.4	177.88	179.0385	7245877.0
2018-10-08 15:00:00	QQQ	ETF	179.03	179.55	178.92	179.09	8312037.0
2018-10-08 16:00:00	QQQ	ETF	179.09	179.53	179.05	179.45	2203858.0
2018-10-08 17:00:00	QQQ	ETF	179.4001	179.43	179.05	179.05	27064.0
2018-10-08 18:00:00	QQQ	ETF	179.43	179.47	179.35	179.4	30267.0
2018-10-08 19:00:00	QQQ	ETF	179.41	179.41	179.27	179.29	20906.0
2018-10-08 04:00:00	IWM	ETF	162.45	162.45	162.03	162.03	659.0
2018-10-08 05:00:00	IWM	ETF	161.99	162.13	161.99	162.09	6873.0
2018-10-08 07:00:00	IWM	ETF	162.09	162.26	162.05	162.21	68456.0
2018-10-08 08:00:00	IWM	ETF	162.11	162.23	162.0	162.07	10202.0
2018-10-08 09:00:00	IWM	ETF	162.03	162.11	161.48	161.9599	2117896.0
2018-10-08 10:00:00	IWM	ETF	161.96	162.4	161.67	161.735	2428088.0
2018-10-08 11:00:00	IWM	ETF	161.73	161.73	160.62	160.92	2668115.0
2018-10-08 12:00:00	IWM	ETF	160.94	161.18	160.6015	160.62	2259194.0
2018-10-08 13:00:00	IWM	ETF	160.6099	161.22	160.55	160.95	2078990.0
2018-10-08 14:00:00	IWM	ETF	160.95	162.18	160.92	161.99	2706226.0
2018-10-08 15:00:00	IWM	ETF	161.98	162.36	161.85	161.86	2916533.0
2018-10-08 16:00:00	IWM	ETF	161.84	162.06	161.82	161.95	1993942.0
2018-10-08 17:00:00	IWM	ETF	161.86	161.98	161.85	161.98	1820.0
2018-10-08 18:00:00	IWM	ETF	161.95	162.0	161.91	161.98	5505.0
2018-10-08 19:00:00	IWM	ETF	161.89	161.96	161.85	161.85	6655.0
2018-10-08 20:00:00	IWM	ETF	161.8795	161.8795	161.82	161.82	1263816.0
2018-10-08 04:00:00	DIA	ETF	263.55	263.55	263.55	263.55	100.0
2018-10-08 06:00:00	DIA	ETF	263.75	263.75	263.75	263.75	1500.0

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

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