PREVIEW / etf_1min / 2014-09-25

all etf 1-min files

  file:    by_date/etf_1min/2014/2014-09-25.parquet
  size:    2.4 MB
  rows:    125,885

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-25 04:05:00	SPY	ETF	199.43	199.43	199.43	199.43	236.0
2014-09-25 04:17:00	SPY	ETF	199.41	199.41	199.41	199.41	131.0
2014-09-25 04:44:00	SPY	ETF	199.55	199.55	199.55	199.55	1000.0
2014-09-25 04:45:00	SPY	ETF	199.53	199.53	199.53	199.53	1000.0
2014-09-25 04:46:00	SPY	ETF	199.53	199.56	199.53	199.56	1032.0
2014-09-25 04:47:00	SPY	ETF	199.51	199.51	199.51	199.51	1050.0
2014-09-25 04:55:00	SPY	ETF	199.43	199.45	199.43	199.45	314.0
2014-09-25 04:59:00	SPY	ETF	199.42	199.42	199.37	199.37	500.0
2014-09-25 05:06:00	SPY	ETF	199.42	199.42	199.42	199.42	199.0
2014-09-25 05:10:00	SPY	ETF	199.43	199.43	199.43	199.43	20100.0
2014-09-25 05:16:00	SPY	ETF	199.39	199.39	199.39	199.39	149.0
2014-09-25 05:26:00	SPY	ETF	199.37	199.37	199.37	199.37	100.0
2014-09-25 05:35:00	SPY	ETF	199.42	199.42	199.42	199.42	500.0
2014-09-25 05:42:00	SPY	ETF	199.43	199.44	199.43	199.44	22500.0
2014-09-25 05:54:00	SPY	ETF	199.4	199.4	199.4	199.4	172.0
2014-09-25 06:04:00	SPY	ETF	199.38	199.38	199.38	199.38	150.0
2014-09-25 06:12:00	SPY	ETF	199.4	199.4	199.4	199.4	125.0
2014-09-25 06:14:00	SPY	ETF	199.36	199.36	199.34	199.35	10170.0
2014-09-25 06:16:00	SPY	ETF	199.31	199.31	199.31	199.31	434.0
2014-09-25 06:17:00	SPY	ETF	199.38	199.38	199.38	199.38	200.0
2014-09-25 06:24:00	SPY	ETF	199.33	199.33	199.33	199.33	180.0
2014-09-25 06:31:00	SPY	ETF	199.37	199.37	199.37	199.37	1889.0
2014-09-25 06:32:00	SPY	ETF	199.37	199.37	199.37	199.37	3000.0
2014-09-25 06:33:00	SPY	ETF	199.39	199.39	199.39	199.39	200.0
2014-09-25 06:38:00	SPY	ETF	199.48	199.48	199.48	199.48	3000.0
2014-09-25 06:40:00	SPY	ETF	199.45	199.45	199.45	199.45	419.0
2014-09-25 06:44:00	SPY	ETF	199.51	199.52	199.51	199.52	2306.0
2014-09-25 06:48:00	SPY	ETF	199.52	199.52	199.52	199.52	3000.0
2014-09-25 06:51:00	SPY	ETF	199.5	199.5	199.5	199.5	122.0
2014-09-25 06:57:00	SPY	ETF	199.52	199.52	199.52	199.52	200.0
2014-09-25 06:59:00	SPY	ETF	199.49	199.49	199.49	199.49	184.0
2014-09-25 07:01:00	SPY	ETF	199.48	199.48	199.48	199.48	100.0
2014-09-25 07:02:00	SPY	ETF	199.49	199.49	199.49	199.49	2000.0
2014-09-25 07:05:00	SPY	ETF	199.48	199.48	199.48	199.48	100.0
2014-09-25 07:09:00	SPY	ETF	199.47	199.47	199.46	199.46	1190.0
2014-09-25 07:12:00	SPY	ETF	199.45	199.45	199.45	199.45	467.0
2014-09-25 07:13:00	SPY	ETF	199.44	199.44	199.44	199.44	159.0
2014-09-25 07:14:00	SPY	ETF	199.45	199.46	199.45	199.46	700.0
2014-09-25 07:15:00	SPY	ETF	199.46	199.47	199.46	199.47	427.0
2014-09-25 07:18:00	SPY	ETF	199.47	199.47	199.47	199.47	300.0
2014-09-25 07:22:00	SPY	ETF	199.47	199.47	199.47	199.47	500.0
2014-09-25 07:23:00	SPY	ETF	199.47	199.47	199.46	199.46	1350.0
2014-09-25 07:24:00	SPY	ETF	199.47	199.47	199.47	199.47	291.0
2014-09-25 07:25:00	SPY	ETF	199.49	199.49	199.49	199.49	530.0
2014-09-25 07:28:00	SPY	ETF	199.5	199.5	199.5	199.5	200.0
2014-09-25 07:30:00	SPY	ETF	199.46	199.46	199.46	199.46	420.0
2014-09-25 07:32:00	SPY	ETF	199.46	199.47	199.46	199.46	700.0
2014-09-25 07:33:00	SPY	ETF	199.45	199.45	199.45	199.45	500.0
2014-09-25 07:35:00	SPY	ETF	199.45	199.45	199.45	199.45	1000.0
2014-09-25 07:36:00	SPY	ETF	199.48	199.48	199.47	199.47	15000.0

> showing 50 of 125,885 rows — these rows as CSV

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