PREVIEW / etf_1hour / 2016-07-22

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-07-22.parquet
  size:    247 KB
  rows:    7,892

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-22 04:00:00	SPY	ETF	216.39	216.65	216.26	216.63	6091.0
2016-07-22 05:00:00	SPY	ETF	216.68	216.78	216.45	216.45	31995.0
2016-07-22 06:00:00	SPY	ETF	216.42	216.65	216.42	216.64	8865.0
2016-07-22 07:00:00	SPY	ETF	216.6	216.66	216.37	216.44	125414.0
2016-07-22 08:00:00	SPY	ETF	216.46	216.62	216.31	216.5	290173.0
2016-07-22 09:00:00	SPY	ETF	216.46	216.49	216.1	216.24	5633358.0
2016-07-22 10:00:00	SPY	ETF	216.23	216.77	216.2	216.745	7285489.0
2016-07-22 11:00:00	SPY	ETF	216.745	217.0	216.54	216.97	5988137.0
2016-07-22 12:00:00	SPY	ETF	216.965	217.1	216.89	216.99	6176598.0
2016-07-22 13:00:00	SPY	ETF	217.0	217.13	216.945	217.045	4465511.0
2016-07-22 14:00:00	SPY	ETF	217.05	217.1896	216.98	217.15	4501327.0
2016-07-22 15:00:00	SPY	ETF	217.15	217.3	217.05	217.23	17103864.0
2016-07-22 16:00:00	SPY	ETF	217.24	217.25	216.98	217.11	8930527.0
2016-07-22 17:00:00	SPY	ETF	217.11	217.25	217.07	217.15	541031.0
2016-07-22 18:00:00	SPY	ETF	217.16	217.18	217.12	217.16	42376.0
2016-07-22 19:00:00	SPY	ETF	217.14	217.17	217.1	217.13	35732.0
2016-07-22 04:00:00	QQQ	ETF	113.33	113.46	113.23	113.45	1700.0
2016-07-22 05:00:00	QQQ	ETF	113.45	113.45	113.45	113.45	300.0
2016-07-22 06:00:00	QQQ	ETF	113.37	113.37	113.37	113.37	100.0
2016-07-22 07:00:00	QQQ	ETF	113.32	113.35	113.24	113.24	18075.0
2016-07-22 08:00:00	QQQ	ETF	113.34	113.34	113.25	113.32	177386.0
2016-07-22 09:00:00	QQQ	ETF	113.3	113.33	112.911	113.1901	2218025.0
2016-07-22 10:00:00	QQQ	ETF	113.1801	113.55	113.16	113.52	2045001.0
2016-07-22 11:00:00	QQQ	ETF	113.52	113.72	113.36	113.7	1233659.0
2016-07-22 12:00:00	QQQ	ETF	113.7	113.78	113.64	113.67	1538910.0
2016-07-22 13:00:00	QQQ	ETF	113.67	113.68	113.56	113.65	948784.0
2016-07-22 14:00:00	QQQ	ETF	113.65	113.69	113.59	113.63	973610.0
2016-07-22 15:00:00	QQQ	ETF	113.64	113.69	113.55	113.65	3409682.0
2016-07-22 16:00:00	QQQ	ETF	113.65	113.67	113.56	113.64	571068.0
2016-07-22 17:00:00	QQQ	ETF	113.63	113.66	113.61	113.65	204075.0
2016-07-22 18:00:00	QQQ	ETF	113.68	113.68	113.64	113.64	5262.0
2016-07-22 19:00:00	QQQ	ETF	113.55	113.55	113.55	113.55	600.0
2016-07-22 04:00:00	IWM	ETF	119.75	119.75	119.75	119.75	200.0
2016-07-22 05:00:00	IWM	ETF	119.85	119.85	119.85	119.85	10000.0
2016-07-22 07:00:00	IWM	ETF	119.59	119.59	119.59	119.59	100.0
2016-07-22 08:00:00	IWM	ETF	119.61	119.69	119.59	119.64	22508.0
2016-07-22 09:00:00	IWM	ETF	119.62	119.77	119.35	119.55	1505359.0
2016-07-22 10:00:00	IWM	ETF	119.53	120.1693	119.37	120.1605	2689375.0
2016-07-22 11:00:00	IWM	ETF	120.17	120.359	119.98	120.2841	2128623.0
2016-07-22 12:00:00	IWM	ETF	120.29	120.64	120.29	120.56	2565195.0
2016-07-22 13:00:00	IWM	ETF	120.57	120.65	120.48	120.54	1425372.0
2016-07-22 14:00:00	IWM	ETF	120.54	120.59	120.45	120.57	1387524.0
2016-07-22 15:00:00	IWM	ETF	120.57	120.61	120.36	120.42	3395799.0
2016-07-22 16:00:00	IWM	ETF	120.4	120.46	120.34	120.42	963969.0
2016-07-22 17:00:00	IWM	ETF	120.41	120.49	120.35	120.41	45898.0
2016-07-22 18:00:00	IWM	ETF	120.4	120.4	120.4	120.4	300.0
2016-07-22 19:00:00	IWM	ETF	120.37	120.37	120.37	120.37	500.0
2016-07-22 04:00:00	DIA	ETF	185.27	185.27	185.18	185.18	550.0
2016-07-22 05:00:00	DIA	ETF	185.26	185.3	185.26	185.28	2200.0
2016-07-22 08:00:00	DIA	ETF	185.04	185.08	185.04	185.05	2300.0

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

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