PREVIEW / etf_1hour / 2016-04-08

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-04-08.parquet
  size:    249 KB
  rows:    8,004

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-04-08 04:00:00	SPY	ETF	205.01	205.31	205.0	205.1	121648.0
2016-04-08 05:00:00	SPY	ETF	205.15	205.17	204.83	205.15	80149.0
2016-04-08 06:00:00	SPY	ETF	205.1	205.3	204.99	205.1	76489.0
2016-04-08 07:00:00	SPY	ETF	205.14	205.23	204.94	205.03	227830.0
2016-04-08 08:00:00	SPY	ETF	205.03	205.7	204.64	205.6	2068532.0
2016-04-08 09:00:00	SPY	ETF	205.6	205.68	205.05	205.57	12296946.0
2016-04-08 10:00:00	SPY	ETF	205.57	205.85	205.22	205.24	18204067.0
2016-04-08 11:00:00	SPY	ETF	205.24	205.49	204.44	204.75	14066804.0
2016-04-08 12:00:00	SPY	ETF	204.74	204.86	204.31	204.731	7507913.0
2016-04-08 13:00:00	SPY	ETF	204.73	204.89	204.27	204.8899	5522085.0
2016-04-08 14:00:00	SPY	ETF	204.88	205.07	204.28	204.44	7691328.0
2016-04-08 15:00:00	SPY	ETF	204.44	204.53	203.87	204.53	17189912.0
2016-04-08 16:00:00	SPY	ETF	204.53	204.62	204.353	204.61	4242463.0
2016-04-08 17:00:00	SPY	ETF	204.6	204.68	204.59	204.66	100230.0
2016-04-08 18:00:00	SPY	ETF	204.66	204.68	204.55	204.63	48779.0
2016-04-08 19:00:00	SPY	ETF	204.61	204.67	204.6	204.63	35109.0
2016-04-08 04:00:00	QQQ	ETF	109.82	109.86	109.73	109.76	1286.0
2016-04-08 06:00:00	QQQ	ETF	109.8	109.82	109.67	109.7	1780.0
2016-04-08 07:00:00	QQQ	ETF	109.73	109.78	109.65	109.73	16004.0
2016-04-08 08:00:00	QQQ	ETF	109.67	109.98	109.64	109.96	153543.0
2016-04-08 09:00:00	QQQ	ETF	109.95	109.99	109.42	109.845	2971785.0
2016-04-08 10:00:00	QQQ	ETF	109.84	110.02	109.401	109.415	3740725.0
2016-04-08 11:00:00	QQQ	ETF	109.42	109.625	108.83	109.08	3426929.0
2016-04-08 12:00:00	QQQ	ETF	109.07	109.13	108.615	108.99	2418974.0
2016-04-08 13:00:00	QQQ	ETF	109.0	109.12	108.68	109.12	1493737.0
2016-04-08 14:00:00	QQQ	ETF	109.12	109.33	108.865	108.97	1881291.0
2016-04-08 15:00:00	QQQ	ETF	108.97	109.02	108.635	109.0	3778440.0
2016-04-08 16:00:00	QQQ	ETF	109.01	109.05	108.97	109.04	1403207.0
2016-04-08 17:00:00	QQQ	ETF	109.03	109.03	108.99	109.02	29540.0
2016-04-08 18:00:00	QQQ	ETF	109.01	109.01	109.01	109.01	800.0
2016-04-08 19:00:00	QQQ	ETF	109.04	109.06	109.01	109.06	3000.0
2016-04-08 04:00:00	IWM	ETF	109.48	109.67	109.48	109.49	1850.0
2016-04-08 06:00:00	IWM	ETF	109.54	109.56	109.54	109.56	300.0
2016-04-08 07:00:00	IWM	ETF	109.53	109.62	109.44	109.55	20700.0
2016-04-08 08:00:00	IWM	ETF	109.47	109.82	109.43	109.75	219365.0
2016-04-08 09:00:00	IWM	ETF	109.75	109.83	109.18	109.82	3329764.0
2016-04-08 10:00:00	IWM	ETF	109.8299	110.07	109.57	109.57	4968412.0
2016-04-08 11:00:00	IWM	ETF	109.57	109.74	108.63	108.95	4567981.0
2016-04-08 12:00:00	IWM	ETF	108.94	109.075	108.71	109.01	1610796.0
2016-04-08 13:00:00	IWM	ETF	109.01	109.245	108.78	109.245	1035916.0
2016-04-08 14:00:00	IWM	ETF	109.24	109.36	108.91	108.99	1435239.0
2016-04-08 15:00:00	IWM	ETF	108.985	109.14	108.66	109.13	4073485.0
2016-04-08 16:00:00	IWM	ETF	109.13	109.24	109.1	109.22	525929.0
2016-04-08 17:00:00	IWM	ETF	109.21	109.24	109.21	109.24	852.0
2016-04-08 19:00:00	IWM	ETF	109.24	109.27	109.21	109.27	2795.0
2016-04-08 04:00:00	DIA	ETF	175.97	176.27	175.97	176.27	453.0
2016-04-08 05:00:00	DIA	ETF	176.1	176.1	176.1	176.1	902.0
2016-04-08 07:00:00	DIA	ETF	176.04	176.25	176.04	176.25	777.0
2016-04-08 08:00:00	DIA	ETF	176.07	176.69	176.07	176.51	3900.0
2016-04-08 09:00:00	DIA	ETF	176.55	176.6	176.14	176.57	452037.0

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

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