PREVIEW / etf_1hour / 2016-05-17

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-05-17.parquet
  size:    251 KB
  rows:    7,995

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-17 04:00:00	SPY	ETF	207.2	207.27	207.0	207.04	6747.0
2016-05-17 05:00:00	SPY	ETF	206.82	206.97	206.67	206.97	8134.0
2016-05-17 06:00:00	SPY	ETF	206.87	207.07	206.64	206.64	30393.0
2016-05-17 07:00:00	SPY	ETF	206.67	206.77	206.51	206.73	251702.0
2016-05-17 08:00:00	SPY	ETF	206.67	206.75	206.22	206.32	875861.0
2016-05-17 09:00:00	SPY	ETF	206.32	206.8	205.91	206.28	12310472.0
2016-05-17 10:00:00	SPY	ETF	206.27	206.52	205.76	206.465	13001252.0
2016-05-17 11:00:00	SPY	ETF	206.45	206.57	206.03	206.44	6854848.0
2016-05-17 12:00:00	SPY	ETF	206.45	206.45	205.65	205.77	7303531.0
2016-05-17 13:00:00	SPY	ETF	205.77	206.01	205.26	205.26	6442070.0
2016-05-17 14:00:00	SPY	ETF	205.26	205.33	204.33	204.84	24274927.0
2016-05-17 15:00:00	SPY	ETF	204.84	205.12	204.23	204.88	33889660.0
2016-05-17 16:00:00	SPY	ETF	204.89	205.05	204.783	205.0	7230072.0
2016-05-17 17:00:00	SPY	ETF	204.98	204.98	204.82	204.85	427774.0
2016-05-17 18:00:00	SPY	ETF	204.88	205.03	204.78	204.94	315455.0
2016-05-17 19:00:00	SPY	ETF	204.96	205.04	204.86	204.95	50077.0
2016-05-17 04:00:00	QQQ	ETF	107.15	107.17	107.15	107.16	560.0
2016-05-17 05:00:00	QQQ	ETF	106.98	106.98	106.98	106.98	800.0
2016-05-17 06:00:00	QQQ	ETF	106.98	107.06	106.88	106.93	14871.0
2016-05-17 07:00:00	QQQ	ETF	106.89	106.89	106.75	106.86	18246.0
2016-05-17 08:00:00	QQQ	ETF	106.86	106.86	106.6	106.62	37795.0
2016-05-17 09:00:00	QQQ	ETF	106.67	107.04	106.38	106.6	3448284.0
2016-05-17 10:00:00	QQQ	ETF	106.6	106.6	106.1	106.45	2829615.0
2016-05-17 11:00:00	QQQ	ETF	106.44	106.63	106.28	106.53	1774796.0
2016-05-17 12:00:00	QQQ	ETF	106.53	106.58	106.12	106.2	1274823.0
2016-05-17 13:00:00	QQQ	ETF	106.2	106.31	105.87	105.87	1660427.0
2016-05-17 14:00:00	QQQ	ETF	105.87	105.92	105.35	105.54	4699647.0
2016-05-17 15:00:00	QQQ	ETF	105.55	105.68	105.2	105.48	5638057.0
2016-05-17 16:00:00	QQQ	ETF	105.46	105.53	105.4	105.51	1513858.0
2016-05-17 17:00:00	QQQ	ETF	105.53	105.53	105.48	105.5	19272.0
2016-05-17 18:00:00	QQQ	ETF	105.45	105.55	105.45	105.54	8296.0
2016-05-17 19:00:00	QQQ	ETF	105.54	105.54	105.52	105.52	2366.0
2016-05-17 04:00:00	IWM	ETF	111.33	111.4	111.33	111.4	400.0
2016-05-17 07:00:00	IWM	ETF	111.07	111.07	110.88	110.99	17856.0
2016-05-17 08:00:00	IWM	ETF	110.88	110.88	110.69	110.79	52313.0
2016-05-17 09:00:00	IWM	ETF	110.78	111.08	110.415	110.99	3557192.0
2016-05-17 10:00:00	IWM	ETF	110.98	111.33	110.34	111.2	4266409.0
2016-05-17 11:00:00	IWM	ETF	111.19	111.42	111.07	111.18	2018282.0
2016-05-17 12:00:00	IWM	ETF	111.18	111.229	110.26	110.3	2822101.0
2016-05-17 13:00:00	IWM	ETF	110.3	110.39	109.81	109.81	3273676.0
2016-05-17 14:00:00	IWM	ETF	109.82	109.88	108.77	109.09	9898420.0
2016-05-17 15:00:00	IWM	ETF	109.09	109.4	108.79	109.29	12593415.0
2016-05-17 16:00:00	IWM	ETF	109.31	109.41	109.2	109.4	1484037.0
2016-05-17 17:00:00	IWM	ETF	109.37	109.4	109.31	109.31	6881.0
2016-05-17 18:00:00	IWM	ETF	109.27	109.4	109.27	109.4	5115.0
2016-05-17 19:00:00	IWM	ETF	109.37	109.37	109.37	109.37	200.0
2016-05-17 06:00:00	DIA	ETF	177.25	177.25	177.25	177.25	200.0
2016-05-17 08:00:00	DIA	ETF	177.0	177.0	176.8	176.8	801.0
2016-05-17 09:00:00	DIA	ETF	176.9	177.24	176.38	176.76	353722.0
2016-05-17 10:00:00	DIA	ETF	176.75	177.05	176.34	177.0027	423789.0

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

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