PREVIEW / etf_5min / 2014-06-26

all etf 5-min files

  file:    by_date/etf_5min/2014/2014-06-26.parquet
  size:    940 KB
  rows:    40,309

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-06-26 04:10:00	SPY	ETF	195.36	195.36	195.36	195.36	500.0
2014-06-26 04:15:00	SPY	ETF	195.37	195.37	195.37	195.37	200.0
2014-06-26 04:30:00	SPY	ETF	195.35	195.35	195.35	195.35	200.0
2014-06-26 04:35:00	SPY	ETF	195.35	195.35	195.25	195.25	4825.0
2014-06-26 04:50:00	SPY	ETF	195.3	195.3	195.3	195.3	700.0
2014-06-26 05:35:00	SPY	ETF	195.54	195.54	195.42	195.42	1050.0
2014-06-26 05:40:00	SPY	ETF	195.44	195.46	195.44	195.46	600.0
2014-06-26 05:50:00	SPY	ETF	195.44	195.44	195.42	195.42	400.0
2014-06-26 05:55:00	SPY	ETF	195.38	195.38	195.38	195.38	200.0
2014-06-26 06:00:00	SPY	ETF	195.34	195.38	195.34	195.38	200.0
2014-06-26 06:05:00	SPY	ETF	195.4	195.4	195.4	195.4	100.0
2014-06-26 06:10:00	SPY	ETF	195.38	195.4	195.38	195.4	600.0
2014-06-26 06:15:00	SPY	ETF	195.42	195.42	195.42	195.42	5000.0
2014-06-26 06:25:00	SPY	ETF	195.42	195.42	195.38	195.38	500.0
2014-06-26 06:30:00	SPY	ETF	195.38	195.38	195.38	195.38	200.0
2014-06-26 06:35:00	SPY	ETF	195.34	195.34	195.3	195.3	600.0
2014-06-26 06:50:00	SPY	ETF	195.3	195.3	195.25	195.25	2000.0
2014-06-26 06:55:00	SPY	ETF	195.29	195.29	195.29	195.29	250.0
2014-06-26 07:00:00	SPY	ETF	195.29	195.29	195.29	195.29	100.0
2014-06-26 07:10:00	SPY	ETF	195.3	195.3	195.28	195.28	2300.0
2014-06-26 07:15:00	SPY	ETF	195.27	195.28	195.24	195.26	6570.0
2014-06-26 07:20:00	SPY	ETF	195.26	195.27	195.26	195.27	1600.0
2014-06-26 07:25:00	SPY	ETF	195.28	195.3	195.28	195.3	22300.0
2014-06-26 07:30:00	SPY	ETF	195.31	195.32	195.27	195.27	7100.0
2014-06-26 07:35:00	SPY	ETF	195.33	195.33	195.3	195.3	27000.0
2014-06-26 07:40:00	SPY	ETF	195.33	195.33	195.3	195.3	2110.0
2014-06-26 07:45:00	SPY	ETF	195.32	195.32	195.32	195.32	500.0
2014-06-26 07:50:00	SPY	ETF	195.32	195.4	195.32	195.4	6206.0
2014-06-26 07:55:00	SPY	ETF	195.42	195.42	195.4	195.4	15310.0
2014-06-26 08:00:00	SPY	ETF	195.32	195.43	195.32	195.38	15676.0
2014-06-26 08:05:00	SPY	ETF	195.38	195.46	195.37	195.46	56170.0
2014-06-26 08:10:00	SPY	ETF	195.45	195.49	195.45	195.45	21650.0
2014-06-26 08:15:00	SPY	ETF	195.45	195.46	195.41	195.41	26903.0
2014-06-26 08:20:00	SPY	ETF	195.41	195.48	195.41	195.48	10060.0
2014-06-26 08:25:00	SPY	ETF	195.47	195.5	195.43	195.44	28117.0
2014-06-26 08:30:00	SPY	ETF	195.45	195.46	195.34	195.38	79185.0
2014-06-26 08:35:00	SPY	ETF	195.4	195.54	195.4	195.48	96453.0
2014-06-26 08:40:00	SPY	ETF	195.47	195.51	195.45	195.51	9649.0
2014-06-26 08:45:00	SPY	ETF	195.5	195.5	195.38	195.39	12198.0
2014-06-26 08:50:00	SPY	ETF	195.39	195.45	195.39	195.45	17764.0
2014-06-26 08:55:00	SPY	ETF	195.45	195.46	195.35	195.41	82036.0
2014-06-26 09:00:00	SPY	ETF	195.38	195.39	195.34	195.36	45529.0
2014-06-26 09:05:00	SPY	ETF	195.34	195.41	195.34	195.41	30290.0
2014-06-26 09:10:00	SPY	ETF	195.39	195.43	195.37	195.43	15763.0
2014-06-26 09:15:00	SPY	ETF	195.43	195.63	195.43	195.62	81839.0
2014-06-26 09:20:00	SPY	ETF	195.63	195.73	195.61	195.71	150873.0
2014-06-26 09:25:00	SPY	ETF	195.71	195.71	195.6	195.61	8961455.0
2014-06-26 09:30:00	SPY	ETF	195.61	195.63	195.23	195.25	2365496.0
2014-06-26 09:35:00	SPY	ETF	195.25	195.36	195.12	195.18	1935924.0
2014-06-26 09:40:00	SPY	ETF	195.19	195.195	194.77	194.82	2755670.0

> showing 50 of 40,309 rows — these rows as CSV

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