PREVIEW / etf_1hour / 2015-01-08

all etf 1-hour files

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

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-08 04:00:00	SPY	ETF	203.0	203.73	203.0	203.61	15377.0
2015-01-08 05:00:00	SPY	ETF	203.61	203.75	203.52	203.7	124576.0
2015-01-08 06:00:00	SPY	ETF	203.7	204.22	203.64	204.05	597785.0
2015-01-08 07:00:00	SPY	ETF	204.1	204.42	203.95	204.0	830149.0
2015-01-08 08:00:00	SPY	ETF	203.99	204.37	203.56	203.87	1167496.0
2015-01-08 09:00:00	SPY	ETF	203.88	204.82	203.82	204.81	18196513.0
2015-01-08 10:00:00	SPY	ETF	204.805	205.49	204.8	205.49	23228548.0
2015-01-08 11:00:00	SPY	ETF	205.49	205.81	205.43	205.62	17027862.0
2015-01-08 12:00:00	SPY	ETF	205.63	205.72	205.21	205.66	7946266.0
2015-01-08 13:00:00	SPY	ETF	205.66	205.95	205.36	205.46	12518429.0
2015-01-08 14:00:00	SPY	ETF	205.46	206.16	205.35	205.92	22043376.0
2015-01-08 15:00:00	SPY	ETF	205.915	206.13	205.5724	205.92	31286965.0
2015-01-08 16:00:00	SPY	ETF	205.92	205.96	205.68	205.7	8530846.0
2015-01-08 17:00:00	SPY	ETF	205.71	205.8	205.68	205.74	216524.0
2015-01-08 18:00:00	SPY	ETF	205.75	205.78	205.68	205.74	52359.0
2015-01-08 19:00:00	SPY	ETF	205.74	205.75	205.64	205.73	99487.0
2015-01-08 04:00:00	QQQ	ETF	101.75	102.35	101.75	102.14	8450.0
2015-01-08 05:00:00	QQQ	ETF	102.05	102.05	102.05	102.05	300.0
2015-01-08 06:00:00	QQQ	ETF	102.13	102.3	102.13	102.22	35150.0
2015-01-08 07:00:00	QQQ	ETF	102.3	102.39	102.22	102.22	61080.0
2015-01-08 08:00:00	QQQ	ETF	102.2	102.36	102.07	102.12	148347.0
2015-01-08 09:00:00	QQQ	ETF	102.14	102.665	102.08	102.66	5697959.0
2015-01-08 10:00:00	QQQ	ETF	102.67	103.19	102.65	103.19	7323906.0
2015-01-08 11:00:00	QQQ	ETF	103.2	103.36	103.06	103.21	5495951.0
2015-01-08 12:00:00	QQQ	ETF	103.215	103.33	102.9807	103.3	3243861.0
2015-01-08 13:00:00	QQQ	ETF	103.3	103.5	103.2	103.25	3265302.0
2015-01-08 14:00:00	QQQ	ETF	103.2599	103.5	103.21	103.375	2885115.0
2015-01-08 15:00:00	QQQ	ETF	103.38	103.48	103.19	103.3	5989683.0
2015-01-08 16:00:00	QQQ	ETF	103.3	103.35	102.876	103.24	1752780.0
2015-01-08 17:00:00	QQQ	ETF	103.24	103.37	103.24	103.37	56912.0
2015-01-08 18:00:00	QQQ	ETF	103.3	103.31	103.25	103.29	20646.0
2015-01-08 19:00:00	QQQ	ETF	103.27	103.31	103.26	103.31	16296.0
2015-01-08 04:00:00	IWM	ETF	117.15	117.5	117.15	117.5	200.0
2015-01-08 05:00:00	IWM	ETF	117.57	117.57	117.57	117.57	700.0
2015-01-08 06:00:00	IWM	ETF	117.73	117.73	117.73	117.73	100.0
2015-01-08 07:00:00	IWM	ETF	117.8	118.15	117.8	117.8	36356.0
2015-01-08 08:00:00	IWM	ETF	117.8	117.94	117.63	117.67	201848.0
2015-01-08 09:00:00	IWM	ETF	117.7	118.16	117.45	118.16	4400566.0
2015-01-08 10:00:00	IWM	ETF	118.16	118.735	118.16	118.735	5971153.0
2015-01-08 11:00:00	IWM	ETF	118.74	118.8457	118.4	118.64	3675380.0
2015-01-08 12:00:00	IWM	ETF	118.65	118.665	118.32	118.57	1348360.0
2015-01-08 13:00:00	IWM	ETF	118.586	118.71	118.42	118.47	1892047.0
2015-01-08 14:00:00	IWM	ETF	118.48	118.81	118.44	118.561	2666365.0
2015-01-08 15:00:00	IWM	ETF	118.565	118.78	118.47	118.7	4477056.0
2015-01-08 16:00:00	IWM	ETF	118.7	118.75	118.48	118.65	1290795.0
2015-01-08 17:00:00	IWM	ETF	118.62	118.7	118.57	118.57	10854.0
2015-01-08 18:00:00	IWM	ETF	118.6	118.65	118.55	118.65	4154.0
2015-01-08 19:00:00	IWM	ETF	118.65	118.65	118.65	118.65	298.0
2015-01-08 04:00:00	DIA	ETF	176.75	176.85	176.75	176.85	200.0
2015-01-08 06:00:00	DIA	ETF	177.0	177.35	177.0	177.35	872.0

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

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