PREVIEW / etf_1hour / 2016-04-29

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-04-29.parquet
  size:    256 KB
  rows:    8,174

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-04-29 04:00:00	SPY	ETF	207.4	207.58	207.34	207.44	7851.0
2016-04-29 05:00:00	SPY	ETF	207.49	207.89	207.49	207.69	10973.0
2016-04-29 06:00:00	SPY	ETF	207.77	207.78	207.29	207.45	59028.0
2016-04-29 07:00:00	SPY	ETF	207.39	207.54	207.3	207.37	149151.0
2016-04-29 08:00:00	SPY	ETF	207.39	207.71	206.8	206.96	1214794.0
2016-04-29 09:00:00	SPY	ETF	206.96	207.13	206.1	206.12	12614939.0
2016-04-29 10:00:00	SPY	ETF	206.11	206.78	205.82	205.98	17143752.0
2016-04-29 11:00:00	SPY	ETF	205.98	206.21	205.06	205.52	16236595.0
2016-04-29 12:00:00	SPY	ETF	205.52	206.0	205.2	205.665	12431495.0
2016-04-29 13:00:00	SPY	ETF	205.66	206.2	205.3	205.35	12078120.0
2016-04-29 14:00:00	SPY	ETF	205.35	205.63	205.03	205.269	12494313.0
2016-04-29 15:00:00	SPY	ETF	205.2675	206.81	205.23	206.33	37327226.0
2016-04-29 16:00:00	SPY	ETF	206.33	206.67	206.21	206.49	16692059.0
2016-04-29 17:00:00	SPY	ETF	206.48	206.48	206.15	206.32	1851920.0
2016-04-29 18:00:00	SPY	ETF	206.3	206.33	206.27	206.33	20492.0
2016-04-29 19:00:00	SPY	ETF	206.33	206.34	206.25	206.28	22140.0
2016-04-29 04:00:00	QQQ	ETF	106.77	106.77	106.61	106.7	1550.0
2016-04-29 05:00:00	QQQ	ETF	106.89	106.95	106.89	106.95	2100.0
2016-04-29 06:00:00	QQQ	ETF	106.74	106.74	106.64	106.71	1600.0
2016-04-29 07:00:00	QQQ	ETF	106.72	106.73	106.53	106.58	55539.0
2016-04-29 08:00:00	QQQ	ETF	106.7	106.72	106.32	106.38	171852.0
2016-04-29 09:00:00	QQQ	ETF	106.45	106.495	105.63	105.71	6044886.0
2016-04-29 10:00:00	QQQ	ETF	105.7	105.98	105.39	105.51	8204163.0
2016-04-29 11:00:00	QQQ	ETF	105.51	105.62	104.88	105.21	7123124.0
2016-04-29 12:00:00	QQQ	ETF	105.21	105.644	105.06	105.48	4033346.0
2016-04-29 13:00:00	QQQ	ETF	105.48	105.91	105.27	105.28	3524256.0
2016-04-29 14:00:00	QQQ	ETF	105.28	105.43	105.12	105.23	3211745.0
2016-04-29 15:00:00	QQQ	ETF	105.23	105.9	105.2	105.72	7497369.0
2016-04-29 16:00:00	QQQ	ETF	105.72	105.87	105.62	105.8	1171327.0
2016-04-29 17:00:00	QQQ	ETF	105.78	105.78	105.7	105.7	2411.0
2016-04-29 18:00:00	QQQ	ETF	105.71	105.77	105.7	105.74	1751.0
2016-04-29 19:00:00	QQQ	ETF	105.75	105.75	105.75	105.75	500.0
2016-04-29 06:00:00	IWM	ETF	113.39	113.4	113.39	113.4	300.0
2016-04-29 07:00:00	IWM	ETF	113.39	113.44	113.39	113.43	4596.0
2016-04-29 08:00:00	IWM	ETF	113.43	113.55	113.06	113.12	90042.0
2016-04-29 09:00:00	IWM	ETF	113.17	113.46	112.57	112.58	3169892.0
2016-04-29 10:00:00	IWM	ETF	112.57	113.365	112.28	112.67	4895333.0
2016-04-29 11:00:00	IWM	ETF	112.67	112.77	111.85	112.19	3558436.0
2016-04-29 12:00:00	IWM	ETF	112.19	112.4	111.83	112.105	2219700.0
2016-04-29 13:00:00	IWM	ETF	112.11	112.46	112.0	112.02	2124846.0
2016-04-29 14:00:00	IWM	ETF	112.01	112.205	111.72	111.92	3943480.0
2016-04-29 15:00:00	IWM	ETF	111.9101	112.74	111.9	112.4	7218936.0
2016-04-29 16:00:00	IWM	ETF	112.4	112.76	112.0601	112.69	1980874.0
2016-04-29 17:00:00	IWM	ETF	112.7	112.73	112.6	112.6	2924.0
2016-04-29 18:00:00	IWM	ETF	112.6	112.69	112.6	112.6	4500.0
2016-04-29 19:00:00	IWM	ETF	112.65	112.65	112.6	112.6	500.0
2016-04-29 07:00:00	DIA	ETF	178.1	178.1	178.1	178.1	100.0
2016-04-29 08:00:00	DIA	ETF	178.1	178.1	177.52	177.52	6000.0
2016-04-29 09:00:00	DIA	ETF	177.69	177.71	176.97	177.0	513255.0
2016-04-29 10:00:00	DIA	ETF	176.97	177.62	176.765	176.94	899226.0

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

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