PREVIEW / etf_1hour / 2016-05-09

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-05-09.parquet
  size:    249 KB
  rows:    8,043

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-05-09 04:00:00	SPY	ETF	205.58	206.27	205.55	206.25	32525.0
2016-05-09 05:00:00	SPY	ETF	206.3	206.42	206.27	206.27	6283.0
2016-05-09 06:00:00	SPY	ETF	206.29	206.38	206.23	206.25	12674.0
2016-05-09 07:00:00	SPY	ETF	206.27	206.47	206.2	206.22	159437.0
2016-05-09 08:00:00	SPY	ETF	206.38	206.44	205.7	205.84	604599.0
2016-05-09 09:00:00	SPY	ETF	205.83	206.32	205.41	206.25	9957842.0
2016-05-09 10:00:00	SPY	ETF	206.25	206.39	205.55	205.76	12752235.0
2016-05-09 11:00:00	SPY	ETF	205.76	206.02	205.36	205.76	10516937.0
2016-05-09 12:00:00	SPY	ETF	205.745	205.96	205.52	205.89	4789668.0
2016-05-09 13:00:00	SPY	ETF	205.89	206.16	205.85	205.88	4868565.0
2016-05-09 14:00:00	SPY	ETF	205.88	206.4	205.69	206.34	7105351.0
2016-05-09 15:00:00	SPY	ETF	206.34	206.365	205.74	205.89	11751214.0
2016-05-09 16:00:00	SPY	ETF	205.88	206.05	205.78	205.94	8171771.0
2016-05-09 17:00:00	SPY	ETF	205.9	205.99	205.9	205.94	145449.0
2016-05-09 18:00:00	SPY	ETF	205.94	205.94	205.32	205.45	712523.0
2016-05-09 19:00:00	SPY	ETF	205.45	205.62	205.45	205.57	75535.0
2016-05-09 04:00:00	QQQ	ETF	105.6	105.6	105.56	105.56	300.0
2016-05-09 05:00:00	QQQ	ETF	106.0	106.04	106.0	106.0	3998.0
2016-05-09 06:00:00	QQQ	ETF	106.0	106.02	105.96	105.96	4379.0
2016-05-09 07:00:00	QQQ	ETF	105.94	106.06	105.93	105.93	24092.0
2016-05-09 08:00:00	QQQ	ETF	106.01	106.01	105.78	105.78	46354.0
2016-05-09 09:00:00	QQQ	ETF	105.78	106.16	105.54	106.16	2617824.0
2016-05-09 10:00:00	QQQ	ETF	106.15	106.25	105.72	105.92	2730034.0
2016-05-09 11:00:00	QQQ	ETF	105.92	106.08	105.71	105.95	2078160.0
2016-05-09 12:00:00	QQQ	ETF	105.95	106.105	105.81	106.04	1250017.0
2016-05-09 13:00:00	QQQ	ETF	106.04	106.2	106.01	106.04	1484264.0
2016-05-09 14:00:00	QQQ	ETF	106.0301	106.37	105.93	106.31	1379586.0
2016-05-09 15:00:00	QQQ	ETF	106.31	106.33	105.81	105.85	2847781.0
2016-05-09 16:00:00	QQQ	ETF	105.86	105.93	105.8	105.88	1554549.0
2016-05-09 17:00:00	QQQ	ETF	105.86	105.86	105.85	105.85	3313.0
2016-05-09 18:00:00	QQQ	ETF	105.84	105.84	105.64	105.74	361397.0
2016-05-09 19:00:00	QQQ	ETF	105.68	105.79	105.68	105.79	21778.0
2016-05-09 05:00:00	IWM	ETF	111.46	111.46	111.46	111.46	600.0
2016-05-09 06:00:00	IWM	ETF	111.39	111.4	111.39	111.4	4998.0
2016-05-09 07:00:00	IWM	ETF	111.37	111.4	111.25	111.26	7107.0
2016-05-09 08:00:00	IWM	ETF	111.24	111.24	110.93	111.06	26993.0
2016-05-09 09:00:00	IWM	ETF	111.04	111.39	110.72	111.34	2765661.0
2016-05-09 10:00:00	IWM	ETF	111.36	111.46	110.88	111.11	2500573.0
2016-05-09 11:00:00	IWM	ETF	111.09	111.31	110.625	111.12	1928642.0
2016-05-09 12:00:00	IWM	ETF	111.12	111.57	110.9161	111.48	1652563.0
2016-05-09 13:00:00	IWM	ETF	111.48	111.76	111.46	111.55	1508189.0
2016-05-09 14:00:00	IWM	ETF	111.56	111.8899	111.39	111.83	1801714.0
2016-05-09 15:00:00	IWM	ETF	111.82	111.85	111.18	111.21	3926999.0
2016-05-09 16:00:00	IWM	ETF	111.2	111.28	111.16	111.17	1050699.0
2016-05-09 17:00:00	IWM	ETF	111.2355	111.2355	111.14	111.15	2072476.0
2016-05-09 18:00:00	IWM	ETF	111.12	111.12	111.02	111.02	4200.0
2016-05-09 19:00:00	IWM	ETF	110.85	110.99	110.85	110.99	2300.0
2016-05-09 07:00:00	DIA	ETF	177.88	177.88	177.78	177.78	200.0
2016-05-09 08:00:00	DIA	ETF	177.43	177.43	177.43	177.43	100.0
2016-05-09 09:00:00	DIA	ETF	177.45	177.76	177.07	177.65	285731.0

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

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