PREVIEW / etf_1hour / 2016-02-23

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-02-23.parquet
  size:    247 KB
  rows:    7,864

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-02-23 04:00:00	SPY	ETF	193.82	194.0	193.47	193.48	27345.0
2016-02-23 05:00:00	SPY	ETF	193.52	193.81	193.39	193.8	16813.0
2016-02-23 06:00:00	SPY	ETF	193.81	194.1	193.79	193.9	56320.0
2016-02-23 07:00:00	SPY	ETF	193.95	194.24	193.86	193.97	232634.0
2016-02-23 08:00:00	SPY	ETF	193.96	194.38	193.65	194.3	1298274.0
2016-02-23 09:00:00	SPY	ETF	194.28	194.32	193.79	194.03	11856525.0
2016-02-23 10:00:00	SPY	ETF	194.03	194.125	192.78	192.92	18557360.0
2016-02-23 11:00:00	SPY	ETF	192.92	193.24	192.47	193.0	15739941.0
2016-02-23 12:00:00	SPY	ETF	192.99	193.08	192.65	193.06	6685440.0
2016-02-23 13:00:00	SPY	ETF	193.05	193.09	192.53	192.78	11350879.0
2016-02-23 14:00:00	SPY	ETF	192.78	193.1	192.57	192.5908	8386623.0
2016-02-23 15:00:00	SPY	ETF	192.5911	192.95	192.18	192.37	25467029.0
2016-02-23 16:00:00	SPY	ETF	192.37	192.58	191.96	192.0	9969698.0
2016-02-23 17:00:00	SPY	ETF	192.0	192.5885	191.9	191.98	453583.0
2016-02-23 18:00:00	SPY	ETF	191.99	192.08	191.91	192.0	86339.0
2016-02-23 19:00:00	SPY	ETF	191.98	192.11	191.91	192.06	78037.0
2016-02-23 20:00:00	SPY	ETF	192.3999	192.3999	192.3999	192.3999	500000.0
2016-02-23 04:00:00	QQQ	ETF	102.4	102.4	102.4	102.4	100.0
2016-02-23 05:00:00	QQQ	ETF	102.4	102.51	102.32	102.51	1500.0
2016-02-23 06:00:00	QQQ	ETF	102.64	102.71	102.59	102.62	27145.0
2016-02-23 07:00:00	QQQ	ETF	102.64	102.8	102.59	102.63	27081.0
2016-02-23 08:00:00	QQQ	ETF	102.76	102.87	102.42	102.81	192993.0
2016-02-23 09:00:00	QQQ	ETF	102.77	102.96	102.57	102.77	2297773.0
2016-02-23 10:00:00	QQQ	ETF	102.76	102.79	101.82	101.94	6824067.0
2016-02-23 11:00:00	QQQ	ETF	101.93	102.235	101.71	102.03	3648349.0
2016-02-23 12:00:00	QQQ	ETF	102.03	102.18	101.84	102.18	1391293.0
2016-02-23 13:00:00	QQQ	ETF	102.18	102.18	101.77	101.93	2184142.0
2016-02-23 14:00:00	QQQ	ETF	101.93	102.11	101.7401	101.75	1908436.0
2016-02-23 15:00:00	QQQ	ETF	101.75	101.95	101.51	101.6	5063214.0
2016-02-23 16:00:00	QQQ	ETF	101.6	101.74	101.45	101.5	1135445.0
2016-02-23 17:00:00	QQQ	ETF	101.45	101.51	101.45	101.47	6899.0
2016-02-23 18:00:00	QQQ	ETF	101.49	101.51	101.43	101.47	21825.0
2016-02-23 19:00:00	QQQ	ETF	101.45	101.51	101.4	101.47	13938.0
2016-02-23 20:00:00	QQQ	ETF	101.6101	101.6111	101.6101	101.6111	456000.0
2016-02-23 05:00:00	IWM	ETF	100.8	100.97	100.74	100.97	3000.0
2016-02-23 06:00:00	IWM	ETF	101.0	101.03	100.96	100.96	1200.0
2016-02-23 07:00:00	IWM	ETF	101.05	101.22	101.01	101.01	10844.0
2016-02-23 08:00:00	IWM	ETF	101.06	101.35	100.9	101.29	77144.0
2016-02-23 09:00:00	IWM	ETF	101.28	101.49	101.0	101.36	2577445.0
2016-02-23 10:00:00	IWM	ETF	101.36	101.48	100.8	100.951	4323147.0
2016-02-23 11:00:00	IWM	ETF	100.95	101.27	100.55	101.15	3434742.0
2016-02-23 12:00:00	IWM	ETF	101.14	101.21	100.91	101.19	1601517.0
2016-02-23 13:00:00	IWM	ETF	101.19	101.215	100.9501	101.1	1703168.0
2016-02-23 14:00:00	IWM	ETF	101.095	101.175	100.935	100.94	2497810.0
2016-02-23 15:00:00	IWM	ETF	100.94	100.98	100.57	100.65	6212641.0
2016-02-23 16:00:00	IWM	ETF	100.64	100.78	100.4	100.42	1163782.0
2016-02-23 17:00:00	IWM	ETF	100.44	100.48	100.44	100.48	2970.0
2016-02-23 18:00:00	IWM	ETF	100.4	100.44	100.38	100.38	1100.0
2016-02-23 19:00:00	IWM	ETF	100.47	100.47	100.47	100.47	100.0
2016-02-23 06:00:00	DIA	ETF	165.4	165.4	165.4	165.4	100.0

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

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