PREVIEW / etf_1hour / 2017-05-01

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-05-01.parquet
  size:    276 KB
  rows:    8,966

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-01 04:00:00	SPY	ETF	238.1	238.43	238.1	238.37	4930.0
2017-05-01 05:00:00	SPY	ETF	238.37	238.44	238.37	238.44	25396.0
2017-05-01 06:00:00	SPY	ETF	238.44	238.56	238.44	238.56	36004.0
2017-05-01 07:00:00	SPY	ETF	238.55	238.61	238.55	238.6	69948.0
2017-05-01 08:00:00	SPY	ETF	238.6	238.85	238.55	238.67	376742.0
2017-05-01 09:00:00	SPY	ETF	238.67	238.71	238.42	238.5	5089330.0
2017-05-01 10:00:00	SPY	ETF	238.49	238.84	238.195	238.77	6509056.0
2017-05-01 11:00:00	SPY	ETF	238.765	238.8399	238.59	238.74	4029651.0
2017-05-01 12:00:00	SPY	ETF	238.74	238.87	238.25	238.56	5353091.0
2017-05-01 13:00:00	SPY	ETF	238.56	239.03	238.49	239.02	3503425.0
2017-05-01 14:00:00	SPY	ETF	239.025	239.17	238.85	238.94	5238768.0
2017-05-01 15:00:00	SPY	ETF	238.935	239.12	238.61	238.65	11784168.0
2017-05-01 16:00:00	SPY	ETF	238.65	238.8667	238.5468	238.78	18233318.0
2017-05-01 17:00:00	SPY	ETF	238.75	238.78	238.55	238.68	2915482.0
2017-05-01 18:00:00	SPY	ETF	238.67	238.8	238.62	238.72	177983.0
2017-05-01 19:00:00	SPY	ETF	238.73	238.76	238.71	238.73	18150.0
2017-05-01 04:00:00	QQQ	ETF	136.11	136.27	136.11	136.27	1700.0
2017-05-01 05:00:00	QQQ	ETF	136.28	136.35	136.25	136.25	19800.0
2017-05-01 06:00:00	QQQ	ETF	136.35	136.35	136.31	136.35	1200.0
2017-05-01 07:00:00	QQQ	ETF	136.29	136.35	136.29	136.32	26163.0
2017-05-01 08:00:00	QQQ	ETF	136.27	136.5	136.27	136.45	143473.0
2017-05-01 09:00:00	QQQ	ETF	136.45	136.67	136.38	136.6276	2285664.0
2017-05-01 10:00:00	QQQ	ETF	136.61	136.91	136.46	136.85	3172700.0
2017-05-01 11:00:00	QQQ	ETF	136.86	136.99	136.81	136.9211	1997746.0
2017-05-01 12:00:00	QQQ	ETF	136.93	137.06	136.81	136.95	1714308.0
2017-05-01 13:00:00	QQQ	ETF	136.96	137.23	136.94	137.23	1296770.0
2017-05-01 14:00:00	QQQ	ETF	137.23	137.29	137.18	137.225	2470127.0
2017-05-01 15:00:00	QQQ	ETF	137.228	137.38	137.15	137.15	4225309.0
2017-05-01 16:00:00	QQQ	ETF	137.15	137.3132	137.11	137.25	1175577.0
2017-05-01 17:00:00	QQQ	ETF	137.25	137.28	137.21	137.23	13756.0
2017-05-01 18:00:00	QQQ	ETF	137.18	137.24	137.18	137.22	14200.0
2017-05-01 19:00:00	QQQ	ETF	137.21	137.24	137.2	137.24	8398.0
2017-05-01 05:00:00	IWM	ETF	139.34	139.52	139.34	139.52	2900.0
2017-05-01 06:00:00	IWM	ETF	139.52	139.52	139.52	139.52	200.0
2017-05-01 07:00:00	IWM	ETF	139.54	139.6	139.48	139.58	47704.0
2017-05-01 08:00:00	IWM	ETF	139.59	139.77	139.52	139.58	75453.0
2017-05-01 09:00:00	IWM	ETF	139.58	139.65	139.07	139.17	1858312.0
2017-05-01 10:00:00	IWM	ETF	139.18	139.52	138.7799	139.29	3101956.0
2017-05-01 11:00:00	IWM	ETF	139.3	139.64	139.06	139.585	2275664.0
2017-05-01 12:00:00	IWM	ETF	139.59	139.78	139.2	139.5	1629079.0
2017-05-01 13:00:00	IWM	ETF	139.51	140.175	139.43	140.17	2007378.0
2017-05-01 14:00:00	IWM	ETF	140.17	140.29	139.42	139.62	2374082.0
2017-05-01 15:00:00	IWM	ETF	139.61	139.96	139.52	139.85	3254412.0
2017-05-01 16:00:00	IWM	ETF	139.86	140.14	139.8	140.14	624291.0
2017-05-01 17:00:00	IWM	ETF	139.86	140.14	139.86	140.03	905750.0
2017-05-01 18:00:00	IWM	ETF	140.01	140.06	140.01	140.06	600.0
2017-05-01 19:00:00	IWM	ETF	140.05	140.05	140.01	140.01	1621.0
2017-05-01 04:00:00	DIA	ETF	209.23	209.23	209.23	209.23	100.0
2017-05-01 05:00:00	DIA	ETF	209.23	209.23	209.23	209.23	100.0
2017-05-01 07:00:00	DIA	ETF	209.4	209.4	209.33	209.39	619.0

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

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