PREVIEW / etf_1hour / 2016-05-16

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-05-16.parquet
  size:    251 KB
  rows:    8,083

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-05-16 04:00:00	SPY	ETF	204.99	205.1	204.92	205.1	13977.0
2016-05-16 05:00:00	SPY	ETF	205.12	205.17	205.0	205.07	7619.0
2016-05-16 06:00:00	SPY	ETF	205.12	205.12	204.8	204.87	24070.0
2016-05-16 07:00:00	SPY	ETF	204.91	205.29	204.89	205.17	224425.0
2016-05-16 08:00:00	SPY	ETF	205.17	205.425	204.73	204.88	656770.0
2016-05-16 09:00:00	SPY	ETF	204.9	205.71	204.86	205.49	9959253.0
2016-05-16 10:00:00	SPY	ETF	205.51	206.15	205.42	206.08	10277515.0
2016-05-16 11:00:00	SPY	ETF	206.08	206.63	206.08	206.6265	8773186.0
2016-05-16 12:00:00	SPY	ETF	206.6299	206.665	206.28	206.58	5692717.0
2016-05-16 13:00:00	SPY	ETF	206.6	206.75	206.48	206.656	5202352.0
2016-05-16 14:00:00	SPY	ETF	206.655	207.23	206.65	207.185	9334449.0
2016-05-16 15:00:00	SPY	ETF	207.1899	207.34	206.71	206.78	15812553.0
2016-05-16 16:00:00	SPY	ETF	206.77	206.91	205.884	206.69	5878226.0
2016-05-16 17:00:00	SPY	ETF	206.7	206.74	206.58	206.68	195625.0
2016-05-16 18:00:00	SPY	ETF	206.69	206.78	206.55	206.68	178408.0
2016-05-16 19:00:00	SPY	ETF	206.68	206.74	206.6	206.6	65308.0
2016-05-16 04:00:00	QQQ	ETF	105.66	105.66	105.55	105.55	300.0
2016-05-16 05:00:00	QQQ	ETF	105.61	105.63	105.61	105.63	250.0
2016-05-16 06:00:00	QQQ	ETF	105.59	105.59	105.45	105.5	2000.0
2016-05-16 07:00:00	QQQ	ETF	105.54	105.93	105.54	105.87	323841.0
2016-05-16 08:00:00	QQQ	ETF	105.86	105.93	105.6	105.69	94606.0
2016-05-16 09:00:00	QQQ	ETF	105.69	106.06	105.56	106.02	2765307.0
2016-05-16 10:00:00	QQQ	ETF	106.03	106.32	105.8	106.29	2852767.0
2016-05-16 11:00:00	QQQ	ETF	106.2899	106.73	106.285	106.69	2007146.0
2016-05-16 12:00:00	QQQ	ETF	106.69	106.72	106.51	106.66	1434124.0
2016-05-16 13:00:00	QQQ	ETF	106.67	106.8399	106.645	106.79	1172066.0
2016-05-16 14:00:00	QQQ	ETF	106.8	107.1605	106.79	107.1224	1847686.0
2016-05-16 15:00:00	QQQ	ETF	107.12	107.21	106.77	106.81	3942829.0
2016-05-16 16:00:00	QQQ	ETF	106.82	106.85	105.9498	106.77	719559.0
2016-05-16 17:00:00	QQQ	ETF	106.78	106.78	106.73	106.73	2305.0
2016-05-16 18:00:00	QQQ	ETF	106.77	106.77	106.76	106.76	4280.0
2016-05-16 19:00:00	QQQ	ETF	106.78	106.78	106.76	106.76	3705.0
2016-05-16 05:00:00	IWM	ETF	109.92	109.92	109.92	109.92	100.0
2016-05-16 06:00:00	IWM	ETF	109.76	109.82	109.75	109.82	1200.0
2016-05-16 07:00:00	IWM	ETF	109.85	110.1	109.85	110.01	23299.0
2016-05-16 08:00:00	IWM	ETF	110.01	110.03	109.88	109.88	41734.0
2016-05-16 09:00:00	IWM	ETF	109.94	110.7477	109.87	110.49	3120480.0
2016-05-16 10:00:00	IWM	ETF	110.5	111.1926	110.46	111.0	3703938.0
2016-05-16 11:00:00	IWM	ETF	110.99	111.43	110.87	111.37	3768296.0
2016-05-16 12:00:00	IWM	ETF	111.37	111.39	110.935	111.17	1711304.0
2016-05-16 13:00:00	IWM	ETF	111.165	111.26	111.01	111.07	1351102.0
2016-05-16 14:00:00	IWM	ETF	111.08	111.45	111.07	111.36	1573858.0
2016-05-16 15:00:00	IWM	ETF	111.37	111.52	111.04	111.07	5574699.0
2016-05-16 16:00:00	IWM	ETF	111.08	111.1	110.92	110.95	783191.0
2016-05-16 17:00:00	IWM	ETF	110.94	110.98	110.93	110.97	5456.0
2016-05-16 19:00:00	IWM	ETF	110.92	110.92	110.92	110.92	500.0
2016-05-16 06:00:00	DIA	ETF	175.6	175.6	175.6	175.6	100.0
2016-05-16 07:00:00	DIA	ETF	175.6	175.8	175.6	175.8	3200.0
2016-05-16 08:00:00	DIA	ETF	175.7	175.8	175.43	175.68	14573.0
2016-05-16 09:00:00	DIA	ETF	175.6	176.36	175.58	176.19	347864.0

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

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