PREVIEW / etf_1hour / 2016-05-18

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-05-18.parquet
  size:    255 KB
  rows:    8,206

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-18 04:00:00	SPY	ETF	204.87	205.01	204.69	205.01	26430.0
2016-05-18 05:00:00	SPY	ETF	204.98	205.01	204.83	204.9	9776.0
2016-05-18 06:00:00	SPY	ETF	205.01	205.08	204.68	204.69	32282.0
2016-05-18 07:00:00	SPY	ETF	204.76	205.0	204.57	204.58	316172.0
2016-05-18 08:00:00	SPY	ETF	204.61	205.103	204.15	204.33	1144773.0
2016-05-18 09:00:00	SPY	ETF	204.32	204.84	204.07	204.84	10245005.0
2016-05-18 10:00:00	SPY	ETF	204.84	205.71	204.69	205.0	15627813.0
2016-05-18 11:00:00	SPY	ETF	205.01	205.76	205.0	205.34	11705794.0
2016-05-18 12:00:00	SPY	ETF	205.34	205.8	205.22	205.7957	5449586.0
2016-05-18 13:00:00	SPY	ETF	205.8	206.3	205.7992	205.9	9463501.0
2016-05-18 14:00:00	SPY	ETF	205.92	205.92	203.63	204.68	39010888.0
2016-05-18 15:00:00	SPY	ETF	204.69	205.14	204.04	204.96	24158079.0
2016-05-18 16:00:00	SPY	ETF	204.96	204.96	204.69	204.86	4029904.0
2016-05-18 17:00:00	SPY	ETF	204.86	204.94	204.86	204.9	652399.0
2016-05-18 18:00:00	SPY	ETF	204.9	205.0	204.68	204.78	183408.0
2016-05-18 19:00:00	SPY	ETF	204.77	204.9	204.75	204.89	70743.0
2016-05-18 04:00:00	QQQ	ETF	105.51	105.51	105.41	105.44	3700.0
2016-05-18 06:00:00	QQQ	ETF	105.53	105.53	105.39	105.39	1199.0
2016-05-18 07:00:00	QQQ	ETF	105.49	105.5	105.32	105.32	18046.0
2016-05-18 08:00:00	QQQ	ETF	105.35	105.36	105.15	105.26	96404.0
2016-05-18 09:00:00	QQQ	ETF	105.23	105.73	105.1	105.71	2987833.0
2016-05-18 10:00:00	QQQ	ETF	105.7	106.23	105.65	105.86	3137403.0
2016-05-18 11:00:00	QQQ	ETF	105.87	106.2765	105.86	106.0399	4509390.0
2016-05-18 12:00:00	QQQ	ETF	106.04	106.17	105.873	106.168	1563730.0
2016-05-18 13:00:00	QQQ	ETF	106.17	106.43	106.17	106.24	2162901.0
2016-05-18 14:00:00	QQQ	ETF	106.24	106.24	105.04	105.605	7671391.0
2016-05-18 15:00:00	QQQ	ETF	105.61	105.91	105.34	105.85	3912115.0
2016-05-18 16:00:00	QQQ	ETF	105.87	105.92	105.7	105.88	388973.0
2016-05-18 17:00:00	QQQ	ETF	105.91	105.94	105.83	105.93	32639.0
2016-05-18 18:00:00	QQQ	ETF	105.95	105.95	105.8	105.82	35699.0
2016-05-18 19:00:00	QQQ	ETF	105.87	105.94	105.87	105.94	14648.0
2016-05-18 04:00:00	IWM	ETF	109.01	109.16	109.01	109.16	2000.0
2016-05-18 05:00:00	IWM	ETF	109.09	109.09	109.08	109.08	1260.0
2016-05-18 06:00:00	IWM	ETF	109.2	109.2	108.97	108.97	1200.0
2016-05-18 07:00:00	IWM	ETF	109.06	109.18	108.97	108.97	18137.0
2016-05-18 08:00:00	IWM	ETF	108.96	108.97	108.6	108.75	178320.0
2016-05-18 09:00:00	IWM	ETF	108.75	109.65	108.6	109.63	2598953.0
2016-05-18 10:00:00	IWM	ETF	109.63	110.37	109.61	109.66	4225344.0
2016-05-18 11:00:00	IWM	ETF	109.67	110.35	109.61	110.05	3047469.0
2016-05-18 12:00:00	IWM	ETF	110.06	110.46	109.8	110.43	2360965.0
2016-05-18 13:00:00	IWM	ETF	110.43	110.661	110.26	110.39	2959662.0
2016-05-18 14:00:00	IWM	ETF	110.4	110.4001	108.9201	109.68	9670563.0
2016-05-18 15:00:00	IWM	ETF	109.68	109.95	109.31	109.83	5274600.0
2016-05-18 16:00:00	IWM	ETF	109.83	109.86	109.73	109.81	800587.0
2016-05-18 17:00:00	IWM	ETF	109.83	109.87	109.83	109.87	2627.0
2016-05-18 18:00:00	IWM	ETF	109.84	109.84	109.84	109.84	9000.0
2016-05-18 19:00:00	IWM	ETF	109.84	109.87	109.84	109.87	300.0
2016-05-18 07:00:00	DIA	ETF	175.43	175.43	175.43	175.43	200.0
2016-05-18 08:00:00	DIA	ETF	175.11	175.11	175.05	175.05	300.0
2016-05-18 09:00:00	DIA	ETF	174.9	175.39	174.8299	175.39	264115.0

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

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