PREVIEW / etf_1hour / 2015-01-09

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-01-09.parquet
  size:    240 KB
  rows:    7,581

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-01-09 04:00:00	SPY	ETF	205.75	205.78	205.45	205.48	8984.0
2015-01-09 05:00:00	SPY	ETF	205.48	205.58	205.44	205.46	9987.0
2015-01-09 06:00:00	SPY	ETF	205.58	205.67	205.09	205.15	180554.0
2015-01-09 07:00:00	SPY	ETF	205.2	205.37	205.05	205.1	227341.0
2015-01-09 08:00:00	SPY	ETF	205.4701	206.52	205.01	206.06	4414499.0
2015-01-09 09:00:00	SPY	ETF	206.05	206.42	204.82	205.01	16492508.0
2015-01-09 10:00:00	SPY	ETF	205.02	205.55	203.97	204.47	26811469.0
2015-01-09 11:00:00	SPY	ETF	204.465	204.56	203.51	204.5	23322709.0
2015-01-09 12:00:00	SPY	ETF	204.51	204.88	204.06	204.08	13055255.0
2015-01-09 13:00:00	SPY	ETF	204.08	204.69	203.95	204.42	15079813.0
2015-01-09 14:00:00	SPY	ETF	204.41	204.67	204.12	204.51	12862182.0
2015-01-09 15:00:00	SPY	ETF	204.51	205.08	204.18	204.18	29936055.0
2015-01-09 16:00:00	SPY	ETF	204.18	205.25	203.86	203.88	11129064.0
2015-01-09 17:00:00	SPY	ETF	203.88	204.25	203.77	203.84	3363447.0
2015-01-09 18:00:00	SPY	ETF	203.88	203.89	203.82	203.83	13823.0
2015-01-09 19:00:00	SPY	ETF	203.85	203.93	203.83	203.85	17538.0
2015-01-09 05:00:00	QQQ	ETF	103.2	103.24	103.17	103.17	10300.0
2015-01-09 06:00:00	QQQ	ETF	103.22	103.24	103.05	103.05	8300.0
2015-01-09 07:00:00	QQQ	ETF	103.13	103.18	103.01	103.06	21235.0
2015-01-09 08:00:00	QQQ	ETF	103.04	103.75	102.96	103.55	800354.0
2015-01-09 09:00:00	QQQ	ETF	103.48	103.65	103.03	103.16	6914918.0
2015-01-09 10:00:00	QQQ	ETF	103.16	103.4	102.41	102.66	7316750.0
2015-01-09 11:00:00	QQQ	ETF	102.66	102.72	102.02	102.69	6628890.0
2015-01-09 12:00:00	QQQ	ETF	102.68	103.04	102.54	102.5599	3601119.0
2015-01-09 13:00:00	QQQ	ETF	102.56	102.89	102.48	102.76	2849989.0
2015-01-09 14:00:00	QQQ	ETF	102.75	102.92	102.63	102.9	2519305.0
2015-01-09 15:00:00	QQQ	ETF	102.9	103.15	102.62	102.63	8004821.0
2015-01-09 16:00:00	QQQ	ETF	102.62	102.897	102.5	102.52	1069172.0
2015-01-09 17:00:00	QQQ	ETF	102.5	102.52	102.45	102.52	13108.0
2015-01-09 18:00:00	QQQ	ETF	102.52	102.52	102.46	102.46	597.0
2015-01-09 19:00:00	QQQ	ETF	102.45	102.57	102.45	102.48	6525.0
2015-01-09 07:00:00	IWM	ETF	118.5	118.54	118.46	118.46	3000.0
2015-01-09 08:00:00	IWM	ETF	118.38	119.04	118.25	118.7	372845.0
2015-01-09 09:00:00	IWM	ETF	118.68	118.84	118.08	118.2	3473891.0
2015-01-09 10:00:00	IWM	ETF	118.2	118.54	117.75	118.03	5098753.0
2015-01-09 11:00:00	IWM	ETF	118.025	118.025	117.31	117.97	3262857.0
2015-01-09 12:00:00	IWM	ETF	117.96	118.25	117.76	117.79	2541179.0
2015-01-09 13:00:00	IWM	ETF	117.79	118.135	117.66	117.99	1740095.0
2015-01-09 14:00:00	IWM	ETF	117.98	118.16	117.849	118.05	1571636.0
2015-01-09 15:00:00	IWM	ETF	118.05	118.29	117.58	117.6	4634641.0
2015-01-09 16:00:00	IWM	ETF	117.58	117.7267	117.51	117.59	1268449.0
2015-01-09 17:00:00	IWM	ETF	117.56	117.59	117.5	117.59	4063.0
2015-01-09 18:00:00	IWM	ETF	117.59	117.59	117.59	117.59	224.0
2015-01-09 04:00:00	DIA	ETF	178.52	178.52	178.31	178.31	10043.0
2015-01-09 06:00:00	DIA	ETF	178.29	178.29	178.17	178.17	11675.0
2015-01-09 07:00:00	DIA	ETF	178.2	178.2	178.11	178.11	15800.0
2015-01-09 08:00:00	DIA	ETF	178.12	179.2	178.01	178.8	143796.0
2015-01-09 09:00:00	DIA	ETF	178.72	179.06	177.74	177.89	841693.0
2015-01-09 10:00:00	DIA	ETF	177.89	178.41	177.05	177.45	1143956.0
2015-01-09 11:00:00	DIA	ETF	177.44	177.48	176.63	177.45	890656.0

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

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