PREVIEW / etf_1hour / 2016-08-04

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-08-04.parquet
  size:    246 KB
  rows:    7,912

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-08-04 04:00:00	SPY	ETF	216.03	216.2	216.03	216.08	16107.0
2016-08-04 05:00:00	SPY	ETF	216.03	216.19	216.03	216.19	9861.0
2016-08-04 06:00:00	SPY	ETF	216.16	216.22	216.01	216.22	18467.0
2016-08-04 07:00:00	SPY	ETF	216.22	216.82	216.22	216.63	443902.0
2016-08-04 08:00:00	SPY	ETF	216.73	216.79	216.179	216.26	649993.0
2016-08-04 09:00:00	SPY	ETF	216.27	216.62	216.08	216.1	5746874.0
2016-08-04 10:00:00	SPY	ETF	216.09	216.58	215.83	216.52	7989419.0
2016-08-04 11:00:00	SPY	ETF	216.501	216.65	214.25	216.64	6404128.0
2016-08-04 12:00:00	SPY	ETF	216.638	216.78	216.41	216.425	4470830.0
2016-08-04 13:00:00	SPY	ETF	216.43	216.45	216.22	216.35	3740415.0
2016-08-04 14:00:00	SPY	ETF	216.36	216.46	216.11	216.3	3950048.0
2016-08-04 15:00:00	SPY	ETF	216.305	216.5	216.17	216.41	7893009.0
2016-08-04 16:00:00	SPY	ETF	216.41	216.45	216.29	216.42	3833211.0
2016-08-04 17:00:00	SPY	ETF	216.4	216.4	216.29	216.36	926839.0
2016-08-04 18:00:00	SPY	ETF	216.36	216.42	216.36	216.39	57074.0
2016-08-04 19:00:00	SPY	ETF	216.4	216.5	216.39	216.5	43731.0
2016-08-04 04:00:00	QQQ	ETF	115.22	115.22	115.15	115.15	500.0
2016-08-04 05:00:00	QQQ	ETF	115.19	115.19	115.19	115.19	1600.0
2016-08-04 06:00:00	QQQ	ETF	115.22	115.22	115.22	115.22	1600.0
2016-08-04 07:00:00	QQQ	ETF	115.23	115.55	115.23	115.48	94221.0
2016-08-04 08:00:00	QQQ	ETF	115.52	115.52	115.3	115.32	34607.0
2016-08-04 09:00:00	QQQ	ETF	115.29	115.585	115.23	115.255	2249867.0
2016-08-04 10:00:00	QQQ	ETF	115.255	115.71	115.03	115.69	2656230.0
2016-08-04 11:00:00	QQQ	ETF	115.69	115.71	115.48	115.68	1420562.0
2016-08-04 12:00:00	QQQ	ETF	115.68	115.78	115.55	115.5505	1146250.0
2016-08-04 13:00:00	QQQ	ETF	115.56	115.66	115.44	115.65	828877.0
2016-08-04 14:00:00	QQQ	ETF	115.65	115.72	115.47	115.65	643233.0
2016-08-04 15:00:00	QQQ	ETF	115.66	115.78	115.5636	115.67	2595006.0
2016-08-04 16:00:00	QQQ	ETF	115.66	115.8	115.63	115.77	586790.0
2016-08-04 17:00:00	QQQ	ETF	115.72	115.75	115.67	115.75	5698.0
2016-08-04 18:00:00	QQQ	ETF	115.75	115.75	115.69	115.75	11476.0
2016-08-04 19:00:00	QQQ	ETF	115.74	115.8	115.74	115.8	5633.0
2016-08-04 05:00:00	IWM	ETF	120.32	120.32	120.25	120.25	200.0
2016-08-04 06:00:00	IWM	ETF	120.32	120.32	120.32	120.32	100.0
2016-08-04 07:00:00	IWM	ETF	120.4	120.72	120.37	120.7	145700.0
2016-08-04 08:00:00	IWM	ETF	120.65	120.7	120.41	120.46	38872.0
2016-08-04 09:00:00	IWM	ETF	120.49	121.19	120.32	120.45	2997618.0
2016-08-04 10:00:00	IWM	ETF	120.45	120.9	120.26	120.83	3119489.0
2016-08-04 11:00:00	IWM	ETF	120.82	120.9725	120.48	120.91	2002161.0
2016-08-04 12:00:00	IWM	ETF	120.9	121.05	120.8	120.8	930211.0
2016-08-04 13:00:00	IWM	ETF	120.8093	120.93	120.69	120.9087	1334615.0
2016-08-04 14:00:00	IWM	ETF	120.9	120.93	120.61	120.715	909116.0
2016-08-04 15:00:00	IWM	ETF	120.71	120.71	120.49	120.55	3432245.0
2016-08-04 16:00:00	IWM	ETF	120.54	120.63	120.45	120.53	706931.0
2016-08-04 17:00:00	IWM	ETF	120.47	120.59	120.47	120.47	35886.0
2016-08-04 07:00:00	DIA	ETF	183.48	183.88	183.48	183.8	3950.0
2016-08-04 08:00:00	DIA	ETF	183.81	183.95	183.65	183.66	4800.0
2016-08-04 09:00:00	DIA	ETF	183.63	183.89	183.37	183.37	473762.0
2016-08-04 10:00:00	DIA	ETF	183.39	183.56	183.18	183.51	240992.0
2016-08-04 11:00:00	DIA	ETF	183.49	183.55	183.33	183.51	322133.0

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

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