PREVIEW / etf_1hour / 2016-07-08

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-07-08.parquet
  size:    260 KB
  rows:    8,300

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-07-08 04:00:00	SPY	ETF	209.93	210.11	209.64	209.79	17867.0
2016-07-08 05:00:00	SPY	ETF	209.77	210.05	209.49	210.02	17108.0
2016-07-08 06:00:00	SPY	ETF	210.04	210.18	209.89	210.11	17910.0
2016-07-08 07:00:00	SPY	ETF	210.14	210.3	210.05	210.22	272445.0
2016-07-08 08:00:00	SPY	ETF	210.2	211.41	209.519	211.24	3921258.0
2016-07-08 09:00:00	SPY	ETF	211.23	211.49	210.7785	211.3501	16976323.0
2016-07-08 10:00:00	SPY	ETF	211.355	211.98	211.32	211.91	19790444.0
2016-07-08 11:00:00	SPY	ETF	211.91	212.26	211.84	212.14	17112758.0
2016-07-08 12:00:00	SPY	ETF	212.14	212.24	212.01	212.1759	10151892.0
2016-07-08 13:00:00	SPY	ETF	212.17	212.47	212.17	212.4	8235144.0
2016-07-08 14:00:00	SPY	ETF	212.4	212.94	212.335	212.71	16501664.0
2016-07-08 15:00:00	SPY	ETF	212.72	212.79	212.39	212.65	25165944.0
2016-07-08 16:00:00	SPY	ETF	212.64	212.7115	212.4	212.49	12873449.0
2016-07-08 17:00:00	SPY	ETF	212.51	212.7	212.47	212.56	268012.0
2016-07-08 18:00:00	SPY	ETF	212.55	212.6	212.51	212.56	29463.0
2016-07-08 19:00:00	SPY	ETF	212.53	212.56	212.43	212.55	26429.0
2016-07-08 04:00:00	QQQ	ETF	108.89	108.89	108.57	108.57	785.0
2016-07-08 05:00:00	QQQ	ETF	108.52	108.68	108.45	108.68	1300.0
2016-07-08 06:00:00	QQQ	ETF	108.73	108.82	108.73	108.82	300.0
2016-07-08 07:00:00	QQQ	ETF	108.84	108.85	108.8	108.83	87540.0
2016-07-08 08:00:00	QQQ	ETF	108.82	109.35	108.5	109.24	577431.0
2016-07-08 09:00:00	QQQ	ETF	109.25	109.705	109.02	109.5993	4562944.0
2016-07-08 10:00:00	QQQ	ETF	109.6	109.965	109.56	109.9415	4619058.0
2016-07-08 11:00:00	QQQ	ETF	109.95	110.13	109.91	110.0227	2709519.0
2016-07-08 12:00:00	QQQ	ETF	110.0239	110.07	109.93	110.0	1592583.0
2016-07-08 13:00:00	QQQ	ETF	110.01	110.14	110.01	110.125	965855.0
2016-07-08 14:00:00	QQQ	ETF	110.13	110.36	110.07	110.26	2337678.0
2016-07-08 15:00:00	QQQ	ETF	110.27	110.34	110.14	110.3	5287262.0
2016-07-08 16:00:00	QQQ	ETF	110.3	110.3	110.18	110.22	1349616.0
2016-07-08 17:00:00	QQQ	ETF	110.15	110.22	110.15	110.16	422142.0
2016-07-08 18:00:00	QQQ	ETF	110.16	110.2	110.11	110.15	2825.0
2016-07-08 19:00:00	QQQ	ETF	110.13	110.24	110.11	110.24	3580.0
2016-07-08 04:00:00	IWM	ETF	114.48	114.48	114.39	114.39	265.0
2016-07-08 05:00:00	IWM	ETF	114.26	114.35	114.26	114.35	200.0
2016-07-08 06:00:00	IWM	ETF	114.63	114.63	114.63	114.63	100.0
2016-07-08 07:00:00	IWM	ETF	114.68	114.76	114.65	114.76	65950.0
2016-07-08 08:00:00	IWM	ETF	114.76	115.58	114.25	115.47	670081.0
2016-07-08 09:00:00	IWM	ETF	115.38	115.9	115.14	115.86	4787334.0
2016-07-08 10:00:00	IWM	ETF	115.86	116.52	115.61	116.42	6441312.0
2016-07-08 11:00:00	IWM	ETF	116.43	116.86	116.3364	116.68	3364617.0
2016-07-08 12:00:00	IWM	ETF	116.68	116.95	116.57	116.83	2496773.0
2016-07-08 13:00:00	IWM	ETF	116.84	116.99	116.82	116.9	1572516.0
2016-07-08 14:00:00	IWM	ETF	116.91	117.09	116.76	116.775	2334334.0
2016-07-08 15:00:00	IWM	ETF	116.78	117.01	116.68	116.84	5322445.0
2016-07-08 16:00:00	IWM	ETF	116.84	116.8767	116.65	116.71	2257725.0
2016-07-08 17:00:00	IWM	ETF	116.71	116.79	116.68	116.79	103232.0
2016-07-08 18:00:00	IWM	ETF	116.75	116.77	116.73	116.74	2400.0
2016-07-08 19:00:00	IWM	ETF	116.74	116.76	116.68	116.68	2200.0
2016-07-08 05:00:00	DIA	ETF	178.96	179.05	178.96	179.05	200.0
2016-07-08 07:00:00	DIA	ETF	179.39	179.39	179.39	179.39	200.0

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

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