PREVIEW / etf_5min / 2014-07-28

all etf 5-min files

  file:    by_date/etf_5min/2014/2014-07-28.parquet
  size:    991 KB
  rows:    41,889

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
2014-07-28 04:05:00	SPY	ETF	197.49	197.49	197.49	197.49	100.0
2014-07-28 04:35:00	SPY	ETF	197.51	197.51	197.47	197.47	607.0
2014-07-28 04:40:00	SPY	ETF	197.45	197.45	197.43	197.45	475.0
2014-07-28 04:45:00	SPY	ETF	197.43	197.43	197.42	197.42	313.0
2014-07-28 05:05:00	SPY	ETF	197.43	197.43	197.43	197.43	198.0
2014-07-28 05:20:00	SPY	ETF	197.51	197.6	197.51	197.6	274.0
2014-07-28 05:30:00	SPY	ETF	197.53	197.53	197.53	197.53	200.0
2014-07-28 05:40:00	SPY	ETF	197.48	197.48	197.48	197.48	156.0
2014-07-28 05:50:00	SPY	ETF	197.55	197.56	197.55	197.56	400.0
2014-07-28 06:00:00	SPY	ETF	197.52	197.52	197.51	197.51	200.0
2014-07-28 06:10:00	SPY	ETF	197.48	197.48	197.48	197.48	100.0
2014-07-28 06:15:00	SPY	ETF	197.48	197.48	197.48	197.48	157.0
2014-07-28 06:20:00	SPY	ETF	197.5	197.51	197.5	197.51	215.0
2014-07-28 06:25:00	SPY	ETF	197.58	197.61	197.58	197.61	460.0
2014-07-28 06:30:00	SPY	ETF	197.68	197.68	197.66	197.66	300.0
2014-07-28 06:45:00	SPY	ETF	197.6	197.6	197.6	197.6	178.0
2014-07-28 06:50:00	SPY	ETF	197.56	197.56	197.53	197.53	25200.0
2014-07-28 06:55:00	SPY	ETF	197.59	197.59	197.59	197.59	100.0
2014-07-28 07:00:00	SPY	ETF	197.58	197.6	197.55	197.6	1650.0
2014-07-28 07:10:00	SPY	ETF	197.63	197.63	197.5	197.5	8600.0
2014-07-28 07:15:00	SPY	ETF	197.5	197.52	197.4	197.48	22976.0
2014-07-28 07:20:00	SPY	ETF	197.48	197.5	197.43	197.5	28090.0
2014-07-28 07:25:00	SPY	ETF	197.48	197.5	197.47	197.5	24400.0
2014-07-28 07:30:00	SPY	ETF	197.44	197.45	197.4	197.4	5862.0
2014-07-28 07:35:00	SPY	ETF	197.45	197.45	197.44	197.45	3400.0
2014-07-28 07:40:00	SPY	ETF	197.42	197.48	197.39	197.48	4800.0
2014-07-28 07:45:00	SPY	ETF	197.45	197.48	197.43	197.45	7100.0
2014-07-28 07:50:00	SPY	ETF	197.46	197.5	197.46	197.5	14330.0
2014-07-28 07:55:00	SPY	ETF	197.48	197.49	197.45	197.46	3785.0
2014-07-28 08:00:00	SPY	ETF	197.47	197.55	197.44	197.54	30113.0
2014-07-28 08:05:00	SPY	ETF	197.57	197.6	197.57	197.57	47950.0
2014-07-28 08:10:00	SPY	ETF	197.57	197.6	197.56	197.6	19400.0
2014-07-28 08:15:00	SPY	ETF	197.6	197.66	197.59	197.65	15650.0
2014-07-28 08:20:00	SPY	ETF	197.66	197.72	197.62	197.62	85051.0
2014-07-28 08:25:00	SPY	ETF	197.63	197.65	197.62	197.64	10257.0
2014-07-28 08:30:00	SPY	ETF	197.65	197.75	197.65	197.72	15453.0
2014-07-28 08:35:00	SPY	ETF	197.72	197.75	197.3	197.7	127858.0
2014-07-28 08:40:00	SPY	ETF	197.72	197.75	197.71	197.75	51231.0
2014-07-28 08:45:00	SPY	ETF	197.74	197.93	197.73	197.91	154893.0
2014-07-28 08:50:00	SPY	ETF	197.92	197.95	197.88	197.94	102739.0
2014-07-28 08:55:00	SPY	ETF	197.93	197.94	197.86	197.87	23250.0
2014-07-28 09:00:00	SPY	ETF	197.86	197.87	197.8	197.84	22406.0
2014-07-28 09:05:00	SPY	ETF	197.86	197.89	197.85	197.87	22694.0
2014-07-28 09:10:00	SPY	ETF	197.87	197.89	197.85	197.85	11375.0
2014-07-28 09:15:00	SPY	ETF	197.84	197.84	197.72	197.72	51123.0
2014-07-28 09:20:00	SPY	ETF	197.71	197.77	197.7	197.77	39326.0
2014-07-28 09:25:00	SPY	ETF	197.76	197.79	197.68	197.76	213419.0
2014-07-28 09:30:00	SPY	ETF	197.76	197.8	197.55	197.65	2417882.0
2014-07-28 09:35:00	SPY	ETF	197.65	197.8	197.6024	197.63	1815439.0
2014-07-28 09:40:00	SPY	ETF	197.655	197.655	197.33	197.34	1263374.0

> showing 50 of 41,889 rows — these rows as CSV

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