PREVIEW / etf_1hour / 2015-02-05

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-02-05.parquet
  size:    240 KB
  rows:    7,654

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-02-05 04:00:00	SPY	ETF	203.8	204.65	203.8	204.55	87338.0
2015-02-05 05:00:00	SPY	ETF	204.56	204.79	204.42	204.51	40400.0
2015-02-05 06:00:00	SPY	ETF	204.5	204.53	204.26	204.51	43390.0
2015-02-05 07:00:00	SPY	ETF	204.51	205.08	204.45	204.76	773453.0
2015-02-05 08:00:00	SPY	ETF	204.47	205.22	203.12	204.91	1535994.0
2015-02-05 09:00:00	SPY	ETF	204.9	205.69	204.69	205.33	15750839.0
2015-02-05 10:00:00	SPY	ETF	205.34	205.936	205.26	205.79	13357051.0
2015-02-05 11:00:00	SPY	ETF	205.79	205.9	205.47	205.765	10056300.0
2015-02-05 12:00:00	SPY	ETF	205.76	205.82	205.31	205.45	4747996.0
2015-02-05 13:00:00	SPY	ETF	205.45	205.94	205.4	205.7701	7079007.0
2015-02-05 14:00:00	SPY	ETF	205.77	206.0	205.54	205.785	10719578.0
2015-02-05 15:00:00	SPY	ETF	205.79	206.3	205.65	206.18	24077488.0
2015-02-05 16:00:00	SPY	ETF	206.19	206.19	204.0722	206.11	4934831.0
2015-02-05 17:00:00	SPY	ETF	206.11	206.18	206.0	206.06	130683.0
2015-02-05 18:00:00	SPY	ETF	206.07	206.15	205.97	205.97	107867.0
2015-02-05 19:00:00	SPY	ETF	205.95	205.98	205.86	205.96	119745.0
2015-02-05 04:00:00	QQQ	ETF	102.72	102.99	102.72	102.99	20286.0
2015-02-05 05:00:00	QQQ	ETF	103.01	103.11	102.94	102.94	5900.0
2015-02-05 06:00:00	QQQ	ETF	102.94	102.99	102.8	102.99	30550.0
2015-02-05 07:00:00	QQQ	ETF	102.96	103.2	102.96	103.05	54216.0
2015-02-05 08:00:00	QQQ	ETF	103.05	103.29	103.0	103.13	186752.0
2015-02-05 09:00:00	QQQ	ETF	103.15	103.4869	102.87	103.31	3627110.0
2015-02-05 10:00:00	QQQ	ETF	103.315	103.57	103.13	103.48	3900226.0
2015-02-05 11:00:00	QQQ	ETF	103.48	103.56	103.34	103.475	1654992.0
2015-02-05 12:00:00	QQQ	ETF	103.48	103.51	103.2228	103.3	1305252.0
2015-02-05 13:00:00	QQQ	ETF	103.31	103.55	103.29	103.49	930252.0
2015-02-05 14:00:00	QQQ	ETF	103.49	103.62	103.3739	103.52	1732752.0
2015-02-05 15:00:00	QQQ	ETF	103.52	103.83	103.43	103.77	6394892.0
2015-02-05 16:00:00	QQQ	ETF	103.76	103.79	102.9287	103.79	2495630.0
2015-02-05 17:00:00	QQQ	ETF	103.79	103.79	103.6345	103.7	37829.0
2015-02-05 18:00:00	QQQ	ETF	103.74	103.77	103.71	103.71	32260.0
2015-02-05 19:00:00	QQQ	ETF	103.67	103.71	103.67	103.69	8179.0
2015-02-05 05:00:00	IWM	ETF	118.95	118.95	118.95	118.95	100.0
2015-02-05 06:00:00	IWM	ETF	118.95	118.95	118.56	118.7	1000.0
2015-02-05 07:00:00	IWM	ETF	118.72	119.07	118.72	118.89	78962.0
2015-02-05 08:00:00	IWM	ETF	118.89	119.07	118.8	118.92	158954.0
2015-02-05 09:00:00	IWM	ETF	118.91	119.53	118.6	119.34	3791457.0
2015-02-05 10:00:00	IWM	ETF	119.34	119.58	119.215	119.3799	3233564.0
2015-02-05 11:00:00	IWM	ETF	119.37	119.68	119.32	119.61	2307192.0
2015-02-05 12:00:00	IWM	ETF	119.62	119.6759	119.29	119.41	1943681.0
2015-02-05 13:00:00	IWM	ETF	119.4	119.8	119.36	119.69	2443620.0
2015-02-05 14:00:00	IWM	ETF	119.6901	119.88	119.59	119.86	3472635.0
2015-02-05 15:00:00	IWM	ETF	119.87	120.25	119.855	119.96	8010405.0
2015-02-05 16:00:00	IWM	ETF	119.96	119.96	119.7	119.8	2506200.0
2015-02-05 17:00:00	IWM	ETF	119.8	119.8	119.71	119.72	43982.0
2015-02-05 18:00:00	IWM	ETF	119.85	119.85	119.85	119.85	250.0
2015-02-05 19:00:00	IWM	ETF	119.71	119.82	119.71	119.82	710.0
2015-02-05 04:00:00	DIA	ETF	176.0	176.58	176.0	176.58	500.0
2015-02-05 05:00:00	DIA	ETF	177.05	177.05	176.85	176.9	1100.0
2015-02-05 06:00:00	DIA	ETF	176.8	176.8	176.65	176.65	1000.0

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

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