PREVIEW / etf_5min / 2016-04-05

all etf 5-min files

  file:    by_date/etf_5min/2016/2016-04-05.parquet
  size:    1.1 MB
  rows:    49,762

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-05 04:00:00	SPY	ETF	205.25	205.4	204.8	204.9	12543.0
2016-04-05 04:05:00	SPY	ETF	204.82	204.82	204.79	204.79	790.0
2016-04-05 04:10:00	SPY	ETF	204.86	204.86	204.78	204.78	2620.0
2016-04-05 04:15:00	SPY	ETF	204.71	204.78	204.65	204.65	25330.0
2016-04-05 04:20:00	SPY	ETF	204.65	204.74	204.65	204.7	1211.0
2016-04-05 04:25:00	SPY	ETF	204.65	204.68	204.58	204.58	913.0
2016-04-05 04:30:00	SPY	ETF	204.62	204.62	204.4	204.41	11543.0
2016-04-05 04:35:00	SPY	ETF	204.5	204.52	204.42	204.46	3317.0
2016-04-05 04:40:00	SPY	ETF	204.44	204.49	204.44	204.49	556.0
2016-04-05 04:45:00	SPY	ETF	204.62	204.62	204.62	204.62	420.0
2016-04-05 04:50:00	SPY	ETF	204.63	204.63	204.63	204.63	124.0
2016-04-05 04:55:00	SPY	ETF	204.7	204.76	204.7	204.73	29100.0
2016-04-05 05:00:00	SPY	ETF	204.8	204.8	204.68	204.68	17612.0
2016-04-05 05:05:00	SPY	ETF	204.63	204.65	204.55	204.6	14446.0
2016-04-05 05:10:00	SPY	ETF	204.63	204.67	204.63	204.65	5620.0
2016-04-05 05:15:00	SPY	ETF	204.58	204.72	204.58	204.72	3073.0
2016-04-05 05:20:00	SPY	ETF	204.75	204.76	204.68	204.73	10033.0
2016-04-05 05:25:00	SPY	ETF	204.75	204.75	204.7	204.7	1051.0
2016-04-05 05:30:00	SPY	ETF	204.62	204.65	204.56	204.56	56738.0
2016-04-05 05:35:00	SPY	ETF	204.51	204.51	204.43	204.5	15875.0
2016-04-05 05:40:00	SPY	ETF	204.48	204.49	204.46	204.47	9809.0
2016-04-05 05:45:00	SPY	ETF	204.45	204.45	204.27	204.32	20213.0
2016-04-05 05:50:00	SPY	ETF	204.27	204.37	204.27	204.37	881.0
2016-04-05 05:55:00	SPY	ETF	204.32	204.39	204.21	204.39	4105.0
2016-04-05 06:00:00	SPY	ETF	204.38	204.45	204.37	204.44	929.0
2016-04-05 06:05:00	SPY	ETF	204.42	204.42	204.37	204.42	1856.0
2016-04-05 06:10:00	SPY	ETF	204.4	204.42	204.39	204.42	1401.0
2016-04-05 06:15:00	SPY	ETF	204.37	204.51	204.37	204.5	4281.0
2016-04-05 06:20:00	SPY	ETF	204.48	204.48	204.38	204.38	9372.0
2016-04-05 06:25:00	SPY	ETF	204.37	204.4	204.33	204.4	5672.0
2016-04-05 06:30:00	SPY	ETF	204.45	204.45	204.31	204.31	3684.0
2016-04-05 06:35:00	SPY	ETF	204.4	204.47	204.4	204.44	903.0
2016-04-05 06:40:00	SPY	ETF	204.47	204.55	204.47	204.54	4454.0
2016-04-05 06:45:00	SPY	ETF	204.54	204.65	204.53	204.65	6638.0
2016-04-05 06:50:00	SPY	ETF	204.58	204.69	204.58	204.59	12943.0
2016-04-05 06:55:00	SPY	ETF	204.63	204.67	204.63	204.67	20904.0
2016-04-05 07:00:00	SPY	ETF	204.69	204.71	204.64	204.65	22614.0
2016-04-05 07:05:00	SPY	ETF	204.64	204.74	204.6	204.71	68124.0
2016-04-05 07:10:00	SPY	ETF	204.7	204.74	204.6	204.72	7062.0
2016-04-05 07:15:00	SPY	ETF	204.71	204.75	204.69	204.69	8407.0
2016-04-05 07:20:00	SPY	ETF	204.73	204.8	204.73	204.8	37303.0
2016-04-05 07:25:00	SPY	ETF	204.8	204.9	204.8	204.89	52642.0
2016-04-05 07:30:00	SPY	ETF	204.89	204.89	204.78	204.81	46778.0
2016-04-05 07:35:00	SPY	ETF	204.76	204.77	204.7	204.74	60947.0
2016-04-05 07:40:00	SPY	ETF	204.72	204.81	204.71	204.77	61346.0
2016-04-05 07:45:00	SPY	ETF	204.78	204.78	204.61	204.63	39367.0
2016-04-05 07:50:00	SPY	ETF	204.61	204.63	204.49	204.57	94336.0
2016-04-05 07:55:00	SPY	ETF	204.62	204.62	204.56	204.6	57328.0
2016-04-05 08:00:00	SPY	ETF	204.6	204.84	204.48	204.59	191929.0
2016-04-05 08:05:00	SPY	ETF	204.58	204.74	204.55	204.74	112139.0

> showing 50 of 49,762 rows — these rows as CSV

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