PREVIEW / etf_1hour / 2016-05-06

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-05-06.parquet
  size:    249 KB
  rows:    7,963

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-06 04:00:00	SPY	ETF	204.74	204.99	204.72	204.97	14041.0
2016-05-06 05:00:00	SPY	ETF	204.82	204.82	204.59	204.59	12456.0
2016-05-06 06:00:00	SPY	ETF	204.59	204.61	204.3	204.47	51056.0
2016-05-06 07:00:00	SPY	ETF	204.45	204.48	204.26	204.47	402643.0
2016-05-06 08:00:00	SPY	ETF	204.45	204.571	203.6	203.82	3776888.0
2016-05-06 09:00:00	SPY	ETF	203.82	205.17	203.81	204.64	13550510.0
2016-05-06 10:00:00	SPY	ETF	204.64	205.08	203.88	204.04	14533023.0
2016-05-06 11:00:00	SPY	ETF	204.04	204.73	204.02	204.32	9388283.0
2016-05-06 12:00:00	SPY	ETF	204.32	204.64	204.22	204.62	4909587.0
2016-05-06 13:00:00	SPY	ETF	204.63	205.34	204.6	205.34	7270359.0
2016-05-06 14:00:00	SPY	ETF	205.34	205.77	205.28	205.5	10245220.0
2016-05-06 15:00:00	SPY	ETF	205.5	205.7201	205.27	205.7	14964861.0
2016-05-06 16:00:00	SPY	ETF	205.71	205.94	204.9538	205.93	7437151.0
2016-05-06 17:00:00	SPY	ETF	205.93	205.96	205.7	205.94	1501301.0
2016-05-06 18:00:00	SPY	ETF	205.93	205.96	205.81	205.85	83631.0
2016-05-06 19:00:00	SPY	ETF	205.83	205.88	205.83	205.87	22549.0
2016-05-06 04:00:00	QQQ	ETF	104.98	104.98	104.98	104.98	100.0
2016-05-06 05:00:00	QQQ	ETF	104.78	104.9	104.78	104.78	27695.0
2016-05-06 06:00:00	QQQ	ETF	104.73	104.8	104.73	104.75	29592.0
2016-05-06 07:00:00	QQQ	ETF	104.74	104.85	104.68	104.81	156831.0
2016-05-06 08:00:00	QQQ	ETF	104.78	104.87	104.31	104.5	621078.0
2016-05-06 09:00:00	QQQ	ETF	104.5	105.25	104.47	104.81	3039757.0
2016-05-06 10:00:00	QQQ	ETF	104.81	105.07	104.4	104.5	3481805.0
2016-05-06 11:00:00	QQQ	ETF	104.51	104.84	104.48	104.51	2428129.0
2016-05-06 12:00:00	QQQ	ETF	104.51	104.78	104.43	104.77	1758777.0
2016-05-06 13:00:00	QQQ	ETF	104.77	105.28	104.77	105.2701	2196959.0
2016-05-06 14:00:00	QQQ	ETF	105.28	105.56	105.24	105.4	4125364.0
2016-05-06 15:00:00	QQQ	ETF	105.405	105.6	105.34	105.59	3704830.0
2016-05-06 16:00:00	QQQ	ETF	105.59	105.8	104.87	105.8	718136.0
2016-05-06 17:00:00	QQQ	ETF	105.75	105.82	104.64	105.77	851768.0
2016-05-06 18:00:00	QQQ	ETF	105.77	105.78	105.71	105.74	3859.0
2016-05-06 19:00:00	QQQ	ETF	105.73	105.74	105.67	105.74	2610.0
2016-05-06 06:00:00	IWM	ETF	110.01	110.04	110.0	110.04	1250.0
2016-05-06 07:00:00	IWM	ETF	110.04	110.08	109.93	110.06	69858.0
2016-05-06 08:00:00	IWM	ETF	110.02	110.12	109.51	109.7	333689.0
2016-05-06 09:00:00	IWM	ETF	109.73	110.7	109.73	110.01	3375610.0
2016-05-06 10:00:00	IWM	ETF	110.01	110.39	109.54	109.67	3639801.0
2016-05-06 11:00:00	IWM	ETF	109.67	110.27	109.6557	109.82	2365960.0
2016-05-06 12:00:00	IWM	ETF	109.81	110.15	109.76	110.14	1511387.0
2016-05-06 13:00:00	IWM	ETF	110.15	110.5	110.12	110.5	1739540.0
2016-05-06 14:00:00	IWM	ETF	110.51	110.83	110.47	110.63	3450852.0
2016-05-06 15:00:00	IWM	ETF	110.62	110.93	110.44	110.91	3879962.0
2016-05-06 16:00:00	IWM	ETF	110.92	111.18	110.87	111.18	892212.0
2016-05-06 17:00:00	IWM	ETF	111.18	111.18	110.93	110.93	333449.0
2016-05-06 18:00:00	IWM	ETF	111.11	111.16	111.11	111.16	3197.0
2016-05-06 19:00:00	IWM	ETF	111.15	111.15	111.12	111.12	1348.0
2016-05-06 08:00:00	DIA	ETF	175.99	176.17	175.37	175.41	6206.0
2016-05-06 09:00:00	DIA	ETF	175.55	176.6322	175.55	176.26	467347.0
2016-05-06 10:00:00	DIA	ETF	176.29	176.68	175.74	175.87	416537.0
2016-05-06 11:00:00	DIA	ETF	175.88	176.61	175.88	176.3	249092.0

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

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