PREVIEW / etf_5min / 2014-07-03

all etf 5-min files

  file:    by_date/etf_5min/2014/2014-07-03.parquet
  size:    646 KB
  rows:    26,377

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-03 04:05:00	SPY	ETF	197.38	197.38	197.38	197.38	183.0
2014-07-03 05:20:00	SPY	ETF	197.32	197.32	197.32	197.32	100.0
2014-07-03 05:30:00	SPY	ETF	197.32	197.32	197.32	197.32	100.0
2014-07-03 05:35:00	SPY	ETF	197.24	197.4	197.24	197.4	1200.0
2014-07-03 05:45:00	SPY	ETF	197.42	197.45	197.42	197.45	600.0
2014-07-03 05:55:00	SPY	ETF	197.4	197.4	197.4	197.4	100.0
2014-07-03 06:15:00	SPY	ETF	197.46	197.46	197.45	197.45	594.0
2014-07-03 06:20:00	SPY	ETF	197.42	197.42	197.42	197.42	200.0
2014-07-03 06:25:00	SPY	ETF	197.45	197.46	197.45	197.46	300.0
2014-07-03 06:40:00	SPY	ETF	197.44	197.44	197.44	197.44	200.0
2014-07-03 06:45:00	SPY	ETF	197.46	197.46	197.46	197.46	200.0
2014-07-03 06:50:00	SPY	ETF	197.43	197.43	197.43	197.43	500.0
2014-07-03 07:00:00	SPY	ETF	197.44	197.44	197.43	197.43	300.0
2014-07-03 07:05:00	SPY	ETF	197.46	197.47	197.46	197.47	6000.0
2014-07-03 07:10:00	SPY	ETF	197.45	197.45	197.45	197.45	100.0
2014-07-03 07:15:00	SPY	ETF	197.46	197.49	197.45	197.49	60378.0
2014-07-03 07:20:00	SPY	ETF	197.49	197.49	197.45	197.48	9698.0
2014-07-03 07:25:00	SPY	ETF	197.45	197.45	197.44	197.44	900.0
2014-07-03 07:30:00	SPY	ETF	197.44	197.47	197.44	197.44	11480.0
2014-07-03 07:35:00	SPY	ETF	197.46	197.47	197.44	197.44	2900.0
2014-07-03 07:40:00	SPY	ETF	197.44	197.53	197.44	197.52	25300.0
2014-07-03 07:45:00	SPY	ETF	197.5	197.5	197.45	197.45	1023.0
2014-07-03 07:50:00	SPY	ETF	197.44	197.44	197.43	197.44	601.0
2014-07-03 07:55:00	SPY	ETF	197.43	197.45	197.42	197.45	11870.0
2014-07-03 08:00:00	SPY	ETF	197.45	197.47	197.41	197.47	33429.0
2014-07-03 08:05:00	SPY	ETF	197.46	197.47	197.44	197.44	41000.0
2014-07-03 08:10:00	SPY	ETF	197.42	197.44	197.36	197.37	44551.0
2014-07-03 08:15:00	SPY	ETF	197.36	197.42	197.35	197.4	25562.0
2014-07-03 08:20:00	SPY	ETF	197.37	197.39	197.35	197.38	18111.0
2014-07-03 08:25:00	SPY	ETF	197.38	197.46	197.36	197.42	28738.0
2014-07-03 08:30:00	SPY	ETF	197.46	197.84	197.21	197.23	763296.0
2014-07-03 08:35:00	SPY	ETF	197.22	197.36	197.14	197.35	383605.0
2014-07-03 08:40:00	SPY	ETF	197.35	197.47	197.32	197.46	311993.0
2014-07-03 08:45:00	SPY	ETF	197.45	197.59	197.43	197.59	119191.0
2014-07-03 08:50:00	SPY	ETF	197.57	197.6	197.5	197.52	129959.0
2014-07-03 08:55:00	SPY	ETF	197.51	197.8	197.51	197.78	302081.0
2014-07-03 09:00:00	SPY	ETF	197.78	197.86	197.71	197.83	320581.0
2014-07-03 09:05:00	SPY	ETF	197.84	197.85	197.73	197.74	153251.0
2014-07-03 09:10:00	SPY	ETF	197.74	197.81	197.72	197.78	48255.0
2014-07-03 09:15:00	SPY	ETF	197.8	197.81	197.72	197.76	45807.0
2014-07-03 09:20:00	SPY	ETF	197.77	197.83	197.76	197.81	249625.0
2014-07-03 09:25:00	SPY	ETF	197.81	197.84	197.76	197.78	418533.0
2014-07-03 09:30:00	SPY	ETF	197.79	197.92	197.64	197.88	2872999.0
2014-07-03 09:35:00	SPY	ETF	197.88	197.99	197.76	197.8675	1384371.0
2014-07-03 09:40:00	SPY	ETF	197.8601	197.98	197.81	197.83	1003547.0
2014-07-03 09:45:00	SPY	ETF	197.835	197.855	197.66	197.703	1365999.0
2014-07-03 09:50:00	SPY	ETF	197.7	197.81	197.68	197.8	913917.0
2014-07-03 09:55:00	SPY	ETF	197.8	197.835	197.71	197.795	814785.0
2014-07-03 10:00:00	SPY	ETF	197.79	197.87	197.73	197.87	933736.0
2014-07-03 10:05:00	SPY	ETF	197.86	197.97	197.86	197.895	1155906.0

> showing 50 of 26,377 rows — these rows as CSV

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