PREVIEW / etf_1hour / 2015-03-11

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-03-11.parquet
  size:    238 KB
  rows:    7,553

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
2015-03-11 04:00:00	SPY	ETF	205.35	205.56	204.99	205.51	79733.0
2015-03-11 05:00:00	SPY	ETF	205.5	205.67	205.42	205.65	38195.0
2015-03-11 06:00:00	SPY	ETF	205.64	205.74	205.55	205.65	128241.0
2015-03-11 07:00:00	SPY	ETF	205.65	205.7	205.25	205.35	391834.0
2015-03-11 08:00:00	SPY	ETF	205.37	205.67	205.25	205.46	963355.0
2015-03-11 09:00:00	SPY	ETF	205.47	205.47	205.01	205.27	12078959.0
2015-03-11 10:00:00	SPY	ETF	205.26	205.5	204.51	204.8	18395591.0
2015-03-11 11:00:00	SPY	ETF	204.79	205.335	204.72	205.1799	12282276.0
2015-03-11 12:00:00	SPY	ETF	205.18	205.37	204.89	205.2061	8858389.0
2015-03-11 13:00:00	SPY	ETF	205.2	205.345	204.52	204.8	11409489.0
2015-03-11 14:00:00	SPY	ETF	204.805	205.25	204.74	205.191	10826118.0
2015-03-11 15:00:00	SPY	ETF	205.19	205.2	204.4	204.51	23222267.0
2015-03-11 16:00:00	SPY	ETF	204.5	204.93	204.38	204.75	5042935.0
2015-03-11 17:00:00	SPY	ETF	204.75	204.84	204.66	204.7	207691.0
2015-03-11 18:00:00	SPY	ETF	204.72	204.76	204.44	204.6	208404.0
2015-03-11 19:00:00	SPY	ETF	204.6	204.61	204.5	204.56	869585.0
2015-03-11 04:00:00	QQQ	ETF	105.85	105.85	105.82	105.82	6930.0
2015-03-11 05:00:00	QQQ	ETF	106.03	106.07	105.97	106.05	59000.0
2015-03-11 06:00:00	QQQ	ETF	106.06	106.1	106.04	106.08	18200.0
2015-03-11 07:00:00	QQQ	ETF	106.08	106.08	105.9	105.96	79481.0
2015-03-11 08:00:00	QQQ	ETF	106.09	106.09	105.92	105.96	90956.0
2015-03-11 09:00:00	QQQ	ETF	105.96	105.96	105.52	105.85	3395096.0
2015-03-11 10:00:00	QQQ	ETF	105.84	106.01	105.35	105.48	4715166.0
2015-03-11 11:00:00	QQQ	ETF	105.481	105.86	105.46	105.76	2827992.0
2015-03-11 12:00:00	QQQ	ETF	105.77	105.82	105.52	105.6346	1709159.0
2015-03-11 13:00:00	QQQ	ETF	105.635	105.67	105.22	105.36	2318138.0
2015-03-11 14:00:00	QQQ	ETF	105.3553	105.6	105.32	105.525	1929363.0
2015-03-11 15:00:00	QQQ	ETF	105.52	105.52	105.07	105.1	4089424.0
2015-03-11 16:00:00	QQQ	ETF	105.1	105.6807	105.06	105.24	598675.0
2015-03-11 17:00:00	QQQ	ETF	105.25	105.27	105.21	105.27	28577.0
2015-03-11 18:00:00	QQQ	ETF	105.27	105.29	105.12	105.16	8935.0
2015-03-11 19:00:00	QQQ	ETF	105.11	105.2	105.11	105.2	1717491.0
2015-03-11 05:00:00	IWM	ETF	120.65	120.75	120.65	120.75	2000.0
2015-03-11 06:00:00	IWM	ETF	120.7	120.7	120.7	120.7	3000.0
2015-03-11 07:00:00	IWM	ETF	120.56	120.6	120.55	120.59	2700.0
2015-03-11 08:00:00	IWM	ETF	120.56	120.69	120.53	120.6	108975.0
2015-03-11 09:00:00	IWM	ETF	120.52	120.61	119.99	120.59	2029540.0
2015-03-11 10:00:00	IWM	ETF	120.58	120.81	119.88	120.17	3356065.0
2015-03-11 11:00:00	IWM	ETF	120.17	120.62	120.12	120.51	1831946.0
2015-03-11 12:00:00	IWM	ETF	120.51	120.65	120.37	120.57	1710641.0
2015-03-11 13:00:00	IWM	ETF	120.58	120.69	120.31	120.47	1986054.0
2015-03-11 14:00:00	IWM	ETF	120.46	121.139	120.4	121.1	2492121.0
2015-03-11 15:00:00	IWM	ETF	121.1	121.11	120.63	121.06	4979316.0
2015-03-11 16:00:00	IWM	ETF	121.07	121.66	120.8971	121.25	717160.0
2015-03-11 17:00:00	IWM	ETF	121.21	121.25	121.2	121.22	16608.0
2015-03-11 18:00:00	IWM	ETF	121.15	121.15	121.05	121.14	975.0
2015-03-11 19:00:00	IWM	ETF	121.15	121.23	121.15	121.15	4619.0
2015-03-11 07:00:00	DIA	ETF	177.24	177.24	177.0	177.0	1625.0
2015-03-11 08:00:00	DIA	ETF	177.0	177.18	176.97	176.97	3538.0
2015-03-11 09:00:00	DIA	ETF	176.97	177.17	176.75	177.07	1076626.0

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

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