PREVIEW / etf_1hour / 2016-03-31

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-03-31.parquet
  size:    250 KB
  rows:    7,989

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
2016-03-31 04:00:00	SPY	ETF	205.5	205.73	205.2	205.62	20316.0
2016-03-31 05:00:00	SPY	ETF	205.59	205.76	205.49	205.6	15969.0
2016-03-31 06:00:00	SPY	ETF	205.6	205.8	205.47	205.8	29226.0
2016-03-31 07:00:00	SPY	ETF	205.83	206.18	205.83	206.01	185150.0
2016-03-31 08:00:00	SPY	ETF	206.0	206.12	205.635	205.94	349134.0
2016-03-31 09:00:00	SPY	ETF	205.95	206.29	205.76	205.99	7892826.0
2016-03-31 10:00:00	SPY	ETF	206.0	206.37	205.91	206.12	10535636.0
2016-03-31 11:00:00	SPY	ETF	206.125	206.37	206.02	206.33	7952863.0
2016-03-31 12:00:00	SPY	ETF	206.33	206.41	206.16	206.17	6513738.0
2016-03-31 13:00:00	SPY	ETF	206.169	206.2	205.69	205.83	8194779.0
2016-03-31 14:00:00	SPY	ETF	205.82	205.83	205.33	205.48	11879291.0
2016-03-31 15:00:00	SPY	ETF	205.49	206.02	205.43	205.55	23659202.0
2016-03-31 16:00:00	SPY	ETF	205.56	205.9953	205.47	205.69	14140446.0
2016-03-31 17:00:00	SPY	ETF	205.72	205.72	205.44	205.65	763361.0
2016-03-31 18:00:00	SPY	ETF	205.61	205.8	205.6	205.79	263183.0
2016-03-31 19:00:00	SPY	ETF	205.8	205.81	205.68	205.73	54041.0
2016-03-31 04:00:00	QQQ	ETF	109.01	109.01	109.01	109.01	5000.0
2016-03-31 05:00:00	QQQ	ETF	109.2	109.2	109.2	109.2	100.0
2016-03-31 06:00:00	QQQ	ETF	109.26	109.27	109.26	109.27	700.0
2016-03-31 07:00:00	QQQ	ETF	109.28	109.43	109.28	109.43	7137.0
2016-03-31 08:00:00	QQQ	ETF	109.36	109.38	109.32	109.32	32735.0
2016-03-31 09:00:00	QQQ	ETF	109.3	109.48	109.17	109.31	2218566.0
2016-03-31 10:00:00	QQQ	ETF	109.32	109.67	109.26	109.595	2643446.0
2016-03-31 11:00:00	QQQ	ETF	109.6	109.69	109.43	109.6	1613471.0
2016-03-31 12:00:00	QQQ	ETF	109.61	109.68	109.54	109.5499	1114913.0
2016-03-31 13:00:00	QQQ	ETF	109.54	109.56	109.22	109.27	1543509.0
2016-03-31 14:00:00	QQQ	ETF	109.27	109.28	109.03	109.18	2674769.0
2016-03-31 15:00:00	QQQ	ETF	109.18	109.4199	109.12	109.19	4877917.0
2016-03-31 16:00:00	QQQ	ETF	109.18	109.3494	109.14	109.2	2267491.0
2016-03-31 17:00:00	QQQ	ETF	109.2	109.2	109.15	109.15	4800.0
2016-03-31 18:00:00	QQQ	ETF	109.2	109.28	109.18	109.28	17729.0
2016-03-31 19:00:00	QQQ	ETF	109.29	109.31	109.23	109.27	8871.0
2016-03-31 04:00:00	IWM	ETF	110.14	110.33	110.0	110.33	618.0
2016-03-31 06:00:00	IWM	ETF	110.16	110.27	110.11	110.27	2500.0
2016-03-31 07:00:00	IWM	ETF	110.4	110.48	110.38	110.43	13632.0
2016-03-31 08:00:00	IWM	ETF	110.36	110.53	110.36	110.48	36303.0
2016-03-31 09:00:00	IWM	ETF	110.46	110.78	110.39	110.59	2589955.0
2016-03-31 10:00:00	IWM	ETF	110.59	110.69	110.34	110.52	2946018.0
2016-03-31 11:00:00	IWM	ETF	110.51	111.06	110.48	110.99	2949704.0
2016-03-31 12:00:00	IWM	ETF	110.99	111.17	110.91	110.94	2015037.0
2016-03-31 13:00:00	IWM	ETF	110.95	111.01	110.61	110.67	1596635.0
2016-03-31 14:00:00	IWM	ETF	110.66	110.811	110.56	110.74	3067215.0
2016-03-31 15:00:00	IWM	ETF	110.74	111.06	110.63	110.64	7460949.0
2016-03-31 16:00:00	IWM	ETF	110.66	110.72	110.59	110.59	2139499.0
2016-03-31 17:00:00	IWM	ETF	110.57	110.57	110.46	110.55	1547.0
2016-03-31 18:00:00	IWM	ETF	110.59	110.59	110.59	110.59	500.0
2016-03-31 19:00:00	IWM	ETF	110.59	110.64	110.5	110.64	6800.0
2016-03-31 07:00:00	DIA	ETF	176.95	176.95	176.95	176.95	100.0
2016-03-31 08:00:00	DIA	ETF	176.88	177.0	176.8	177.0	3593.0
2016-03-31 09:00:00	DIA	ETF	176.93	177.25	176.77	176.96	439774.0

> showing 50 of 7,989 rows — these rows as CSV

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