PREVIEW / etf_5min / 2014-09-23

all etf 5-min files

  file:    by_date/etf_5min/2014/2014-09-23.parquet
  size:    1.0 MB
  rows:    44,442

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-09-23 04:00:00	SPY	ETF	198.6	198.6	198.6	198.6	1000.0
2014-09-23 04:05:00	SPY	ETF	198.55	198.57	198.55	198.57	2210.0
2014-09-23 04:10:00	SPY	ETF	198.6	198.61	198.6	198.61	400.0
2014-09-23 04:15:00	SPY	ETF	198.63	199.04	198.57	199.04	705.0
2014-09-23 04:40:00	SPY	ETF	198.61	198.61	198.6	198.61	499.0
2014-09-23 04:50:00	SPY	ETF	198.61	198.61	198.54	198.54	382.0
2014-09-23 05:00:00	SPY	ETF	198.54	198.54	198.5	198.54	750.0
2014-09-23 05:10:00	SPY	ETF	198.62	198.62	198.55	198.55	2600.0
2014-09-23 05:20:00	SPY	ETF	198.55	198.55	198.55	198.55	170.0
2014-09-23 05:35:00	SPY	ETF	198.41	198.41	198.36	198.4	7239.0
2014-09-23 05:40:00	SPY	ETF	198.45	198.45	198.45	198.45	500.0
2014-09-23 05:50:00	SPY	ETF	198.46	198.47	198.46	198.47	1200.0
2014-09-23 06:00:00	SPY	ETF	198.64	198.64	198.51	198.51	1050.0
2014-09-23 06:05:00	SPY	ETF	198.55	198.55	198.51	198.51	2125.0
2014-09-23 06:15:00	SPY	ETF	198.53	198.53	198.53	198.53	800.0
2014-09-23 06:20:00	SPY	ETF	198.58	198.58	198.58	198.58	200.0
2014-09-23 06:25:00	SPY	ETF	198.56	198.57	198.5	198.57	1200.0
2014-09-23 06:30:00	SPY	ETF	198.47	198.47	198.45	198.45	300.0
2014-09-23 06:35:00	SPY	ETF	198.47	198.47	198.41	198.41	2100.0
2014-09-23 06:40:00	SPY	ETF	198.49	198.52	198.49	198.52	550.0
2014-09-23 06:45:00	SPY	ETF	198.53	198.55	198.51	198.55	1300.0
2014-09-23 06:50:00	SPY	ETF	198.55	198.59	198.55	198.58	8500.0
2014-09-23 06:55:00	SPY	ETF	198.58	198.62	198.54	198.62	49617.0
2014-09-23 07:00:00	SPY	ETF	198.64	198.71	198.63	198.64	36014.0
2014-09-23 07:05:00	SPY	ETF	198.72	198.72	198.7	198.7	14500.0
2014-09-23 07:10:00	SPY	ETF	198.71	198.72	198.59	198.59	20605.0
2014-09-23 07:15:00	SPY	ETF	198.59	198.59	198.53	198.55	4930.0
2014-09-23 07:20:00	SPY	ETF	198.52	198.57	198.4	198.43	44372.0
2014-09-23 07:25:00	SPY	ETF	198.43	198.49	198.41	198.42	23124.0
2014-09-23 07:30:00	SPY	ETF	198.5	198.53	198.49	198.49	5800.0
2014-09-23 07:35:00	SPY	ETF	198.5	198.58	198.5	198.51	41600.0
2014-09-23 07:40:00	SPY	ETF	198.52	198.54	198.38	198.41	41449.0
2014-09-23 07:45:00	SPY	ETF	198.4	198.45	198.37	198.44	55393.0
2014-09-23 07:50:00	SPY	ETF	198.45	198.48	198.45	198.45	33090.0
2014-09-23 07:55:00	SPY	ETF	198.44	198.46	198.41	198.46	10926.0
2014-09-23 08:00:00	SPY	ETF	198.53	199.23	198.4	199.23	68650.0
2014-09-23 08:05:00	SPY	ETF	198.55	198.55	198.44	198.45	67629.0
2014-09-23 08:10:00	SPY	ETF	198.44	198.5	198.4	198.5	218746.0
2014-09-23 08:15:00	SPY	ETF	198.5	198.52	198.45	198.45	72632.0
2014-09-23 08:20:00	SPY	ETF	198.45	198.46	198.36	198.4	107452.0
2014-09-23 08:25:00	SPY	ETF	198.42	198.48	198.4	198.42	18838.0
2014-09-23 08:30:00	SPY	ETF	198.42	198.42	198.25	198.3	147723.0
2014-09-23 08:35:00	SPY	ETF	198.32	198.38	198.31	198.38	44993.0
2014-09-23 08:40:00	SPY	ETF	198.4	198.46	198.38	198.46	41602.0
2014-09-23 08:45:00	SPY	ETF	198.46	198.54	198.4	198.525	343173.0
2014-09-23 08:50:00	SPY	ETF	198.54	198.63	198.52	198.62	338968.0
2014-09-23 08:55:00	SPY	ETF	198.63	198.65	198.59	198.6	211614.0
2014-09-23 09:00:00	SPY	ETF	198.6	198.62	198.55	198.57	51868.0
2014-09-23 09:05:00	SPY	ETF	198.57	198.58	198.55	198.56	20192.0
2014-09-23 09:10:00	SPY	ETF	198.56	198.59	198.5	198.53	49290.0

> showing 50 of 44,442 rows — these rows as CSV

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