PREVIEW / etf_1hour / 2017-05-24

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-05-24.parquet
  size:    274 KB
  rows:    8,875

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-05-24 04:00:00	SPY	ETF	240.1	240.19	240.1	240.19	5310.0
2017-05-24 05:00:00	SPY	ETF	240.17	240.2	240.12	240.2	6333.0
2017-05-24 06:00:00	SPY	ETF	240.16	240.21	240.05	240.06	104400.0
2017-05-24 07:00:00	SPY	ETF	240.02	240.13	240.02	240.13	96647.0
2017-05-24 08:00:00	SPY	ETF	240.07	240.25	240.03	240.2	163108.0
2017-05-24 09:00:00	SPY	ETF	240.22	240.39	240.08	240.19	3654213.0
2017-05-24 10:00:00	SPY	ETF	240.185	240.32	240.02	240.16	5590089.0
2017-05-24 11:00:00	SPY	ETF	240.16	240.3	240.03	240.16	4589315.0
2017-05-24 12:00:00	SPY	ETF	240.155	240.27	240.095	240.18	2265071.0
2017-05-24 13:00:00	SPY	ETF	240.175	240.21	240.06	240.15	4111056.0
2017-05-24 14:00:00	SPY	ETF	240.15	240.53	239.93	240.3412	7744835.0
2017-05-24 15:00:00	SPY	ETF	240.35	240.73	240.17	240.59	13423133.0
2017-05-24 16:00:00	SPY	ETF	240.58	240.7	240.48	240.7	5414766.0
2017-05-24 17:00:00	SPY	ETF	240.63	240.65	240.55	240.59	366176.0
2017-05-24 18:00:00	SPY	ETF	240.6	240.68	240.58	240.65	185458.0
2017-05-24 19:00:00	SPY	ETF	240.65	240.71	240.62	240.62	68197.0
2017-05-24 04:00:00	QQQ	ETF	139.35	139.4	139.3	139.39	36300.0
2017-05-24 05:00:00	QQQ	ETF	139.41	139.42	139.37	139.39	4000.0
2017-05-24 06:00:00	QQQ	ETF	139.44	139.47	139.39	139.43	3598.0
2017-05-24 07:00:00	QQQ	ETF	139.4	139.45	139.39	139.43	29300.0
2017-05-24 08:00:00	QQQ	ETF	139.45	139.54	139.45	139.52	57695.0
2017-05-24 09:00:00	QQQ	ETF	139.51	139.59	139.25	139.31	1760654.0
2017-05-24 10:00:00	QQQ	ETF	139.31	139.42	139.17	139.33	1696151.0
2017-05-24 11:00:00	QQQ	ETF	139.33	139.41	139.1807	139.34	1200955.0
2017-05-24 12:00:00	QQQ	ETF	139.335	139.46	139.33	139.42	861323.0
2017-05-24 13:00:00	QQQ	ETF	139.43	139.475	139.3014	139.44	1373623.0
2017-05-24 14:00:00	QQQ	ETF	139.43	139.62	139.3	139.55	2446827.0
2017-05-24 15:00:00	QQQ	ETF	139.56	139.85	139.48	139.79	4237330.0
2017-05-24 16:00:00	QQQ	ETF	139.78	139.82	139.71	139.81	1241333.0
2017-05-24 17:00:00	QQQ	ETF	139.83	139.83	139.77	139.78	1576.0
2017-05-24 18:00:00	QQQ	ETF	139.79	139.85	139.77	139.83	13554.0
2017-05-24 19:00:00	QQQ	ETF	139.85	139.89	139.85	139.86	28236.0
2017-05-24 04:00:00	IWM	ETF	137.4	137.4	137.4	137.4	117.0
2017-05-24 05:00:00	IWM	ETF	137.44	137.46	137.39	137.39	5203.0
2017-05-24 06:00:00	IWM	ETF	137.41	137.41	137.41	137.41	2500.0
2017-05-24 07:00:00	IWM	ETF	137.3	137.32	137.27	137.3	22205.0
2017-05-24 08:00:00	IWM	ETF	137.37	137.54	137.37	137.53	11365.0
2017-05-24 09:00:00	IWM	ETF	137.48	137.69	137.31	137.54	1179045.0
2017-05-24 10:00:00	IWM	ETF	137.55	138.03	137.42	137.83	2660648.0
2017-05-24 11:00:00	IWM	ETF	137.82	137.95	136.995	137.38	3380914.0
2017-05-24 12:00:00	IWM	ETF	137.37	137.62	137.17	137.17	2669227.0
2017-05-24 13:00:00	IWM	ETF	137.18	137.26	136.83	137.17	2117197.0
2017-05-24 14:00:00	IWM	ETF	137.17	137.48	136.97	137.36	2216749.0
2017-05-24 15:00:00	IWM	ETF	137.37	137.72	137.18	137.5	3419074.0
2017-05-24 16:00:00	IWM	ETF	137.5	137.51	137.37	137.49	818941.0
2017-05-24 17:00:00	IWM	ETF	137.49	137.56	137.45	137.45	152348.0
2017-05-24 18:00:00	IWM	ETF	137.44	137.44	137.44	137.44	142.0
2017-05-24 19:00:00	IWM	ETF	137.49	137.49	137.43	137.43	2000.0
2017-05-24 05:00:00	DIA	ETF	209.18	209.18	209.18	209.18	100.0
2017-05-24 07:00:00	DIA	ETF	209.12	209.12	209.12	209.12	100.0

> showing 50 of 8,875 rows — these rows as CSV

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