PREVIEW / etf_1hour / 2015-07-16

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-07-16.parquet
  size:    243 KB
  rows:    7,801

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-07-16 04:00:00	SPY	ETF	211.54	211.88	211.54	211.8	14021.0
2015-07-16 05:00:00	SPY	ETF	211.79	211.79	211.63	211.67	14118.0
2015-07-16 06:00:00	SPY	ETF	211.68	211.7	211.53	211.58	135059.0
2015-07-16 07:00:00	SPY	ETF	211.62	211.85	211.58	211.74	411996.0
2015-07-16 08:00:00	SPY	ETF	211.74	211.98	211.59	211.91	668040.0
2015-07-16 09:00:00	SPY	ETF	211.92	212.05	211.6	211.86	11530920.0
2015-07-16 10:00:00	SPY	ETF	211.85	211.96	211.58	211.89	14250356.0
2015-07-16 11:00:00	SPY	ETF	211.88	212.11	211.75	211.97	10223695.0
2015-07-16 12:00:00	SPY	ETF	211.975	212.155	211.88	211.9	10389529.0
2015-07-16 13:00:00	SPY	ETF	211.905	212.04	211.81	211.86	8025368.0
2015-07-16 14:00:00	SPY	ETF	211.86	212.19	211.83	212.06	8891246.0
2015-07-16 15:00:00	SPY	ETF	212.065	212.3	211.96	212.25	27243710.0
2015-07-16 16:00:00	SPY	ETF	212.25	212.36	212.13	212.2	9895578.0
2015-07-16 17:00:00	SPY	ETF	212.2	212.3	211.81	212.23	648886.0
2015-07-16 18:00:00	SPY	ETF	212.23	212.23	212.14	212.22	75224.0
2015-07-16 19:00:00	SPY	ETF	212.21	212.33	212.21	212.25	75365.0
2015-07-16 04:00:00	QQQ	ETF	111.03	111.22	111.03	111.22	37057.0
2015-07-16 05:00:00	QQQ	ETF	111.22	111.23	111.17	111.23	22177.0
2015-07-16 06:00:00	QQQ	ETF	111.19	111.2	111.15	111.18	22500.0
2015-07-16 07:00:00	QQQ	ETF	111.18	111.22	111.15	111.2	187817.0
2015-07-16 08:00:00	QQQ	ETF	111.18	111.31	111.16	111.26	251307.0
2015-07-16 09:00:00	QQQ	ETF	111.26	111.42	111.07	111.3196	3489155.0
2015-07-16 10:00:00	QQQ	ETF	111.31	111.475	111.17	111.415	2946723.0
2015-07-16 11:00:00	QQQ	ETF	111.42	111.67	111.415	111.565	2444123.0
2015-07-16 12:00:00	QQQ	ETF	111.56	111.74	111.54	111.565	2278612.0
2015-07-16 13:00:00	QQQ	ETF	111.56	111.64	111.51	111.55	1459168.0
2015-07-16 14:00:00	QQQ	ETF	111.55	111.7499	111.53	111.71	1723730.0
2015-07-16 15:00:00	QQQ	ETF	111.71	111.96	111.68	111.92	5723848.0
2015-07-16 16:00:00	QQQ	ETF	111.91	112.48	111.87	112.44	1371104.0
2015-07-16 17:00:00	QQQ	ETF	112.45	112.79	112.43	112.63	288395.0
2015-07-16 18:00:00	QQQ	ETF	112.63	112.75	112.51	112.59	87205.0
2015-07-16 19:00:00	QQQ	ETF	112.6	112.72	112.6	112.66	15110.0
2015-07-16 07:00:00	IWM	ETF	126.11	126.35	126.11	126.26	43750.0
2015-07-16 08:00:00	IWM	ETF	126.23	126.36	126.18	126.3	65677.0
2015-07-16 09:00:00	IWM	ETF	126.3	126.74	125.97	126.42	3693668.0
2015-07-16 10:00:00	IWM	ETF	126.41	126.61	126.265	126.55	2958179.0
2015-07-16 11:00:00	IWM	ETF	126.56	126.72	126.43	126.44	2562794.0
2015-07-16 12:00:00	IWM	ETF	126.44	126.49	126.09	126.16	2885657.0
2015-07-16 13:00:00	IWM	ETF	126.16	126.34	126.07	126.145	1586342.0
2015-07-16 14:00:00	IWM	ETF	126.146	126.38	126.11	126.22	1646397.0
2015-07-16 15:00:00	IWM	ETF	126.23	126.38	126.17	126.33	3698379.0
2015-07-16 16:00:00	IWM	ETF	126.33	126.48	126.16	126.39	2273053.0
2015-07-16 17:00:00	IWM	ETF	126.39	126.45	126.39	126.45	6765.0
2015-07-16 18:00:00	IWM	ETF	126.41	126.41	126.41	126.41	600.0
2015-07-16 19:00:00	IWM	ETF	126.44	126.44	126.41	126.41	200.0
2015-07-16 04:00:00	DIA	ETF	181.21	181.23	181.16	181.23	2100.0
2015-07-16 07:00:00	DIA	ETF	181.23	181.25	181.23	181.25	2000.0
2015-07-16 08:00:00	DIA	ETF	181.01	181.03	181.0	181.0	1922.0
2015-07-16 09:00:00	DIA	ETF	181.19	181.34	180.68	180.71	453123.0
2015-07-16 10:00:00	DIA	ETF	180.71	180.83	180.5	180.72	388515.0

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

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