PREVIEW / etf_1hour / 2016-11-25

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-11-25.parquet
  size:    169 KB
  rows:    5,177

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-11-25 04:00:00	SPY	ETF	220.83	221.09	220.83	221.03	4047.0
2016-11-25 05:00:00	SPY	ETF	221.02	221.04	220.89	220.9	4300.0
2016-11-25 06:00:00	SPY	ETF	220.94	220.94	220.89	220.92	17200.0
2016-11-25 07:00:00	SPY	ETF	220.97	221.08	220.97	221.08	226073.0
2016-11-25 08:00:00	SPY	ETF	221.07	221.13	220.97	221.05	223859.0
2016-11-25 09:00:00	SPY	ETF	221.05	221.28	221.01	221.275	5945401.0
2016-11-25 10:00:00	SPY	ETF	221.27	221.33	221.16	221.2699	9106662.0
2016-11-25 11:00:00	SPY	ETF	221.2673	221.37	221.23	221.31	4772442.0
2016-11-25 12:00:00	SPY	ETF	221.315	221.5489	221.29	221.54	9618234.0
2016-11-25 13:00:00	SPY	ETF	221.54	221.7	221.3261	221.56	5341772.0
2016-11-25 14:00:00	SPY	ETF	221.56	221.828	221.55	221.69	280890.0
2016-11-25 15:00:00	SPY	ETF	221.69	221.71	221.64	221.67	67674.0
2016-11-25 16:00:00	SPY	ETF	221.68	221.69	221.65	221.67	19101.0
2016-11-25 19:00:00	SPY	ETF	221.6234	221.6234	221.6234	221.6234	250000.0
2016-11-25 04:00:00	QQQ	ETF	118.48	118.58	118.48	118.58	1542.0
2016-11-25 06:00:00	QQQ	ETF	118.53	118.53	118.53	118.53	100.0
2016-11-25 07:00:00	QQQ	ETF	118.53	118.58	118.53	118.57	4969.0
2016-11-25 08:00:00	QQQ	ETF	118.57	118.61	118.49	118.5	10671.0
2016-11-25 09:00:00	QQQ	ETF	118.5	118.69	118.42	118.68	1509693.0
2016-11-25 10:00:00	QQQ	ETF	118.67	118.691	118.5143	118.581	1097798.0
2016-11-25 11:00:00	QQQ	ETF	118.59	118.78	118.5618	118.771	1021786.0
2016-11-25 12:00:00	QQQ	ETF	118.78	118.85	118.68	118.78	1766121.0
2016-11-25 13:00:00	QQQ	ETF	118.79	118.86	118.71	118.74	476660.0
2016-11-25 14:00:00	QQQ	ETF	118.7397	118.77	118.71	118.7516	12756.0
2016-11-25 15:00:00	QQQ	ETF	118.77	118.8	118.77	118.7998	1929.0
2016-11-25 16:00:00	QQQ	ETF	118.76	118.8	118.76	118.8	5600.0
2016-11-25 04:00:00	IWM	ETF	133.21	133.74	133.21	133.74	700.0
2016-11-25 06:00:00	IWM	ETF	133.78	133.82	133.78	133.82	300.0
2016-11-25 07:00:00	IWM	ETF	133.88	133.88	133.82	133.86	14066.0
2016-11-25 08:00:00	IWM	ETF	133.83	133.87	133.66	133.73	23669.0
2016-11-25 09:00:00	IWM	ETF	133.75	133.89	133.54	133.73	2225008.0
2016-11-25 10:00:00	IWM	ETF	133.74	133.9	133.619	133.75	1795790.0
2016-11-25 11:00:00	IWM	ETF	133.75	133.97	133.72	133.94	2610095.0
2016-11-25 12:00:00	IWM	ETF	133.94	134.1	133.89	134.08	2765878.0
2016-11-25 13:00:00	IWM	ETF	134.07	134.22	133.8399	133.9	1372030.0
2016-11-25 14:00:00	IWM	ETF	133.9	134.05	133.9	134.0295	10883.0
2016-11-25 15:00:00	IWM	ETF	134.0	134.0	133.92	133.92	978.0
2016-11-25 16:00:00	IWM	ETF	133.95	134.05	133.94	133.94	900.0
2016-11-25 04:00:00	DIA	ETF	190.69	190.69	190.69	190.69	100.0
2016-11-25 07:00:00	DIA	ETF	191.01	191.1	191.01	191.1	2154.0
2016-11-25 08:00:00	DIA	ETF	191.1	191.14	191.04	191.11	1682.0
2016-11-25 09:00:00	DIA	ETF	191.1	191.19	190.98	191.17	568855.0
2016-11-25 10:00:00	DIA	ETF	191.17	191.25	191.09	191.13	414933.0
2016-11-25 11:00:00	DIA	ETF	191.13	191.2	191.0916	191.14	183340.0
2016-11-25 12:00:00	DIA	ETF	191.13	191.28	191.04	191.26	253015.0
2016-11-25 13:00:00	DIA	ETF	191.27	191.5	191.26	191.41	13710.0
2016-11-25 14:00:00	DIA	ETF	191.4	191.5	191.4	191.5	1500.0
2016-11-25 16:00:00	DIA	ETF	191.3	191.6	191.3	191.59	3834.0
2016-11-25 04:00:00	GLD	ETF	113.52	113.52	113.01	113.2	1200.0
2016-11-25 05:00:00	GLD	ETF	113.25	113.4	113.25	113.4	500.0

> showing 50 of 5,177 rows — these rows as CSV

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