PREVIEW / etf_1hour / 2017-03-01

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-03-01.parquet
  size:    288 KB
  rows:    9,297

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-03-01 04:00:00	SPY	ETF	237.42	237.69	237.42	237.6	86861.0
2017-03-01 05:00:00	SPY	ETF	237.61	237.74	237.51	237.73	51374.0
2017-03-01 06:00:00	SPY	ETF	237.73	237.77	237.53	237.63	63098.0
2017-03-01 07:00:00	SPY	ETF	237.68	237.89	237.64	237.88	355059.0
2017-03-01 08:00:00	SPY	ETF	237.88	238.31	237.58	238.24	1113484.0
2017-03-01 09:00:00	SPY	ETF	238.25	238.83	238.2	238.8	15205278.0
2017-03-01 10:00:00	SPY	ETF	238.81	239.19	238.78	239.11	13378815.0
2017-03-01 11:00:00	SPY	ETF	239.115	239.65	239.04	239.56	16688815.0
2017-03-01 12:00:00	SPY	ETF	239.56	240.11	239.555	239.8	13618013.0
2017-03-01 13:00:00	SPY	ETF	239.81	239.95	239.75	239.895	11078189.0
2017-03-01 14:00:00	SPY	ETF	239.9	240.32	239.79	240.27	16008341.0
2017-03-01 15:00:00	SPY	ETF	240.27	240.27	239.68	239.75	27555024.0
2017-03-01 16:00:00	SPY	ETF	239.74	239.7962	239.52	239.54	24773254.0
2017-03-01 17:00:00	SPY	ETF	239.53	239.78	239.51	239.58	6679387.0
2017-03-01 18:00:00	SPY	ETF	239.58	239.67	239.49	239.61	115488.0
2017-03-01 19:00:00	SPY	ETF	239.62	239.7	239.56	239.61	39993.0
2017-03-01 04:00:00	QQQ	ETF	130.6	130.64	130.26	130.63	3361.0
2017-03-01 05:00:00	QQQ	ETF	130.58	130.79	130.58	130.75	7199.0
2017-03-01 06:00:00	QQQ	ETF	130.82	130.82	130.65	130.65	7313.0
2017-03-01 07:00:00	QQQ	ETF	130.7	130.75	130.59	130.75	30752.0
2017-03-01 08:00:00	QQQ	ETF	130.7	130.9	130.67	130.8	157997.0
2017-03-01 09:00:00	QQQ	ETF	130.79	130.93	130.6	130.77	3308175.0
2017-03-01 10:00:00	QQQ	ETF	130.78	131.07	130.78	131.005	2405925.0
2017-03-01 11:00:00	QQQ	ETF	131.0047	131.32	130.98	131.275	2465146.0
2017-03-01 12:00:00	QQQ	ETF	131.28	131.56	131.275	131.37	1846156.0
2017-03-01 13:00:00	QQQ	ETF	131.3734	131.44	131.31	131.43	1941789.0
2017-03-01 14:00:00	QQQ	ETF	131.435	131.64	131.36	131.615	2680629.0
2017-03-01 15:00:00	QQQ	ETF	131.615	131.68	131.42	131.46	3879920.0
2017-03-01 16:00:00	QQQ	ETF	131.45	131.4924	131.3	131.3	1578974.0
2017-03-01 17:00:00	QQQ	ETF	131.28	131.46	131.27	131.31	1337379.0
2017-03-01 18:00:00	QQQ	ETF	131.29	131.4	131.28	131.37	13087.0
2017-03-01 19:00:00	QQQ	ETF	131.37	131.4	131.37	131.39	2200.0
2017-03-01 04:00:00	IWM	ETF	138.56	138.7	138.56	138.64	12968.0
2017-03-01 05:00:00	IWM	ETF	138.62	138.72	138.62	138.72	10650.0
2017-03-01 06:00:00	IWM	ETF	138.74	138.77	138.69	138.71	60196.0
2017-03-01 07:00:00	IWM	ETF	138.71	139.05	138.67	139.02	171184.0
2017-03-01 08:00:00	IWM	ETF	139.02	139.49	138.99	139.49	649190.0
2017-03-01 09:00:00	IWM	ETF	139.49	140.22	139.47	140.12	5819510.0
2017-03-01 10:00:00	IWM	ETF	140.13	140.6	139.92	140.09	5831151.0
2017-03-01 11:00:00	IWM	ETF	140.095	140.55	140.025	140.5	2944593.0
2017-03-01 12:00:00	IWM	ETF	140.5	140.86	140.48	140.59	3547406.0
2017-03-01 13:00:00	IWM	ETF	140.59	140.76	140.4	140.645	1950897.0
2017-03-01 14:00:00	IWM	ETF	140.645	140.77	140.46	140.565	1877036.0
2017-03-01 15:00:00	IWM	ETF	140.57	140.69	140.3801	140.4	5953063.0
2017-03-01 16:00:00	IWM	ETF	140.4	140.6	137.8989	140.36	3422613.0
2017-03-01 17:00:00	IWM	ETF	140.49	140.57	140.4	140.48	9672.0
2017-03-01 18:00:00	IWM	ETF	140.54	140.54	140.36	140.43	7967.0
2017-03-01 19:00:00	IWM	ETF	140.48	140.49	140.43	140.45	1843.0
2017-03-01 04:00:00	DIA	ETF	208.57	208.77	208.57	208.77	400.0
2017-03-01 07:00:00	DIA	ETF	208.8	209.15	208.8	209.15	4960.0

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

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