PREVIEW / etf_1hour / 2016-08-08

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-08-08.parquet
  size:    249 KB
  rows:    8,025

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-08 04:00:00	SPY	ETF	218.5	218.68	218.46	218.62	10373.0
2016-08-08 05:00:00	SPY	ETF	218.6	218.61	218.5	218.5	9902.0
2016-08-08 06:00:00	SPY	ETF	218.5	218.56	218.42	218.48	31931.0
2016-08-08 07:00:00	SPY	ETF	218.45	218.54	218.42	218.44	79555.0
2016-08-08 08:00:00	SPY	ETF	218.43	218.52	218.07	218.27	193924.0
2016-08-08 09:00:00	SPY	ETF	218.28	218.52	218.11	218.1607	6812577.0
2016-08-08 10:00:00	SPY	ETF	218.17	218.28	217.91	218.075	6416492.0
2016-08-08 11:00:00	SPY	ETF	218.075	218.24	218.02	218.09	3948686.0
2016-08-08 12:00:00	SPY	ETF	218.08	218.12	217.91	218.04	3103850.0
2016-08-08 13:00:00	SPY	ETF	218.04	218.07	217.95	218.06	3049006.0
2016-08-08 14:00:00	SPY	ETF	218.055	218.09	217.74	217.81	4370813.0
2016-08-08 15:00:00	SPY	ETF	217.81	218.04	217.76	218.03	8536293.0
2016-08-08 16:00:00	SPY	ETF	218.04	218.07	217.93	218.07	2214702.0
2016-08-08 17:00:00	SPY	ETF	218.03	218.14	217.99	218.0	194019.0
2016-08-08 18:00:00	SPY	ETF	217.98	218.0	217.9	217.95	89379.0
2016-08-08 19:00:00	SPY	ETF	217.95	218.0603	217.9	217.95	47529.0
2016-08-08 04:00:00	QQQ	ETF	116.9	117.06	116.9	117.06	1955.0
2016-08-08 05:00:00	QQQ	ETF	117.03	117.1	116.97	116.97	52900.0
2016-08-08 06:00:00	QQQ	ETF	116.98	116.99	116.98	116.98	26100.0
2016-08-08 07:00:00	QQQ	ETF	116.95	116.98	116.93	116.94	14396.0
2016-08-08 08:00:00	QQQ	ETF	116.94	117.0	116.79	116.79	75223.0
2016-08-08 09:00:00	QQQ	ETF	116.78	116.87	116.56	116.6134	1855320.0
2016-08-08 10:00:00	QQQ	ETF	116.61	116.66	116.28	116.43	2106817.0
2016-08-08 11:00:00	QQQ	ETF	116.44	116.56	116.37	116.4835	1029248.0
2016-08-08 12:00:00	QQQ	ETF	116.49	116.55	116.43	116.4965	656503.0
2016-08-08 13:00:00	QQQ	ETF	116.49	116.545	116.43	116.51	869233.0
2016-08-08 14:00:00	QQQ	ETF	116.51	116.519	116.34	116.44	1195313.0
2016-08-08 15:00:00	QQQ	ETF	116.4393	116.65	116.42	116.65	2065403.0
2016-08-08 16:00:00	QQQ	ETF	116.64	116.65	116.5089	116.61	400052.0
2016-08-08 17:00:00	QQQ	ETF	116.69	116.69	116.61	116.62	6751.0
2016-08-08 18:00:00	QQQ	ETF	116.61	116.61	116.58	116.59	5168.0
2016-08-08 19:00:00	QQQ	ETF	116.58	116.59	116.56	116.59	5900.0
2016-08-08 05:00:00	IWM	ETF	122.53	122.53	122.53	122.53	1000.0
2016-08-08 07:00:00	IWM	ETF	122.45	122.46	122.43	122.45	11100.0
2016-08-08 08:00:00	IWM	ETF	122.46	122.46	122.26	122.26	28836.0
2016-08-08 09:00:00	IWM	ETF	122.28	122.85	122.27	122.59	2534835.0
2016-08-08 10:00:00	IWM	ETF	122.59	122.68	122.21	122.54	1882679.0
2016-08-08 11:00:00	IWM	ETF	122.54	122.72	122.47	122.521	1344044.0
2016-08-08 12:00:00	IWM	ETF	122.53	122.56	122.255	122.43	1039637.0
2016-08-08 13:00:00	IWM	ETF	122.43	122.46	122.29	122.36	1032865.0
2016-08-08 14:00:00	IWM	ETF	122.35	122.36	122.03	122.16	1157812.0
2016-08-08 15:00:00	IWM	ETF	122.16	122.27	122.12	122.23	2826072.0
2016-08-08 16:00:00	IWM	ETF	122.24	122.31	122.15	122.31	621463.0
2016-08-08 17:00:00	IWM	ETF	122.31	122.31	122.23	122.23	5700.0
2016-08-08 18:00:00	IWM	ETF	122.27	122.29	122.26	122.26	4633.0
2016-08-08 19:00:00	IWM	ETF	122.26	122.26	122.23	122.23	300.0
2016-08-08 04:00:00	DIA	ETF	185.67	185.67	185.67	185.67	100.0
2016-08-08 07:00:00	DIA	ETF	185.49	185.49	185.49	185.49	100.0
2016-08-08 08:00:00	DIA	ETF	185.4	185.4	185.39	185.39	220.0
2016-08-08 09:00:00	DIA	ETF	185.38	185.7	185.29	185.43	283489.0

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

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