PREVIEW / etf_1hour / 2015-12-17

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-12-17.parquet
  size:    252 KB
  rows:    8,000

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
2015-12-17 04:00:00	SPY	ETF	208.03	208.56	208.02	208.56	59993.0
2015-12-17 05:00:00	SPY	ETF	208.5	208.75	208.4	208.67	144492.0
2015-12-17 06:00:00	SPY	ETF	208.7	208.89	208.56	208.65	87911.0
2015-12-17 07:00:00	SPY	ETF	208.62	208.79	208.36	208.38	477430.0
2015-12-17 08:00:00	SPY	ETF	208.65	208.67	208.13	208.43	569272.0
2015-12-17 09:00:00	SPY	ETF	208.45	208.59	207.17	207.65	16926432.0
2015-12-17 10:00:00	SPY	ETF	207.65	207.66	205.93	206.3	30813918.0
2015-12-17 11:00:00	SPY	ETF	206.31	206.5	205.44	206.11	25932931.0
2015-12-17 12:00:00	SPY	ETF	206.1	206.39	205.415	205.87	14827430.0
2015-12-17 13:00:00	SPY	ETF	205.87	206.67	205.79	206.57	14787777.0
2015-12-17 14:00:00	SPY	ETF	206.58	206.69	205.72	206.02	14941344.0
2015-12-17 15:00:00	SPY	ETF	206.02	206.34	204.84	204.89	29607955.0
2015-12-17 16:00:00	SPY	ETF	204.88	205.41	203.99	204.03	12295869.0
2015-12-17 17:00:00	SPY	ETF	204.03	204.86	204.01	204.1	1516030.0
2015-12-17 18:00:00	SPY	ETF	204.16	204.22	203.96	204.07	217476.0
2015-12-17 19:00:00	SPY	ETF	204.12	204.33	203.24	203.4	385628.0
2015-12-17 20:00:00	SPY	ETF	204.9095	204.9095	204.9095	204.9095	50000.0
2015-12-17 04:00:00	QQQ	ETF	114.1	114.35	113.9	114.35	25850.0
2015-12-17 05:00:00	QQQ	ETF	114.33	114.44	114.33	114.44	11050.0
2015-12-17 06:00:00	QQQ	ETF	114.32	114.52	114.32	114.39	35000.0
2015-12-17 07:00:00	QQQ	ETF	114.43	114.49	114.4	114.4	156875.0
2015-12-17 08:00:00	QQQ	ETF	114.45	114.46	114.28	114.44	145156.0
2015-12-17 09:00:00	QQQ	ETF	114.46	114.52	113.78	114.06	5009989.0
2015-12-17 10:00:00	QQQ	ETF	114.06	114.12	113.03	113.25	8140974.0
2015-12-17 11:00:00	QQQ	ETF	113.25	113.395	112.68	113.17	5112895.0
2015-12-17 12:00:00	QQQ	ETF	113.17	113.35	112.76	113.05	2387369.0
2015-12-17 13:00:00	QQQ	ETF	113.04	113.5272	112.985	113.43	2196272.0
2015-12-17 14:00:00	QQQ	ETF	113.4399	113.48	112.8499	113.02	2767304.0
2015-12-17 15:00:00	QQQ	ETF	113.02	113.14	112.3	112.33	6660603.0
2015-12-17 16:00:00	QQQ	ETF	112.32	112.365	111.7	111.81	2938622.0
2015-12-17 17:00:00	QQQ	ETF	111.8	112.32	111.75	111.84	242100.0
2015-12-17 18:00:00	QQQ	ETF	111.85	111.87	111.75	111.84	18039.0
2015-12-17 19:00:00	QQQ	ETF	111.87	111.95	111.28	111.37	19274.0
2015-12-17 04:00:00	IWM	ETF	114.82	114.82	114.82	114.82	100.0
2015-12-17 05:00:00	IWM	ETF	114.95	115.0	114.91	114.91	1496.0
2015-12-17 06:00:00	IWM	ETF	114.99	115.18	114.95	114.95	3300.0
2015-12-17 07:00:00	IWM	ETF	115.02	115.03	114.98	114.99	140500.0
2015-12-17 08:00:00	IWM	ETF	114.94	114.97	114.85	114.94	55823.0
2015-12-17 09:00:00	IWM	ETF	114.97	115.01	114.33	114.5905	4812972.0
2015-12-17 10:00:00	IWM	ETF	114.6	114.81	113.59	113.76	8291210.0
2015-12-17 11:00:00	IWM	ETF	113.78	113.87	113.17	113.62	7173506.0
2015-12-17 12:00:00	IWM	ETF	113.61	113.74	112.9701	113.3	3248918.0
2015-12-17 13:00:00	IWM	ETF	113.3	113.8	113.25	113.735	2649439.0
2015-12-17 14:00:00	IWM	ETF	113.7423	113.815	113.32	113.5501	2525628.0
2015-12-17 15:00:00	IWM	ETF	113.56	113.59	113.08	113.18	5394633.0
2015-12-17 16:00:00	IWM	ETF	113.18	113.21	112.58	112.59	1994776.0
2015-12-17 17:00:00	IWM	ETF	112.6	112.61	112.57	112.6	2175.0
2015-12-17 18:00:00	IWM	ETF	112.6	112.75	112.6	112.75	400.0
2015-12-17 19:00:00	IWM	ETF	112.72	112.72	112.4	112.4	11140.0
2015-12-17 05:00:00	DIA	ETF	178.0	178.0	178.0	178.0	200.0

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

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