PREVIEW / etf_5min / 2013-08-16

all etf 5-min files

  file:    by_date/etf_5min/2013/2013-08-16.parquet
  size:    997 KB
  rows:    41,905

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
2013-08-16 04:00:00	SPY	ETF	166.24	166.45	166.24	166.39	445.0
2013-08-16 04:05:00	SPY	ETF	166.4	166.4	166.39	166.39	300.0
2013-08-16 04:25:00	SPY	ETF	166.21	166.21	166.21	166.21	100.0
2013-08-16 04:35:00	SPY	ETF	166.31	166.31	166.31	166.31	100.0
2013-08-16 04:45:00	SPY	ETF	166.33	166.33	166.33	166.33	100.0
2013-08-16 05:00:00	SPY	ETF	166.4	166.4	166.4	166.4	100.0
2013-08-16 05:05:00	SPY	ETF	166.42	166.42	166.42	166.42	400.0
2013-08-16 05:15:00	SPY	ETF	166.3	166.3	166.3	166.3	100.0
2013-08-16 05:25:00	SPY	ETF	166.31	166.31	166.27	166.27	801.0
2013-08-16 05:45:00	SPY	ETF	166.36	166.36	166.34	166.34	2000.0
2013-08-16 06:00:00	SPY	ETF	166.48	166.5	166.48	166.5	2700.0
2013-08-16 06:05:00	SPY	ETF	166.49	166.54	166.49	166.5	1855.0
2013-08-16 06:25:00	SPY	ETF	166.48	166.48	166.48	166.48	100.0
2013-08-16 06:30:00	SPY	ETF	166.45	166.45	166.45	166.45	500.0
2013-08-16 06:35:00	SPY	ETF	166.47	166.56	166.47	166.56	7350.0
2013-08-16 06:40:00	SPY	ETF	166.61	166.61	166.57	166.57	5718.0
2013-08-16 06:45:00	SPY	ETF	166.61	166.62	166.57	166.57	1900.0
2013-08-16 06:50:00	SPY	ETF	166.51	166.51	166.45	166.45	17975.0
2013-08-16 07:00:00	SPY	ETF	166.53	166.53	166.5	166.5	8290.0
2013-08-16 07:05:00	SPY	ETF	166.49	166.49	166.49	166.49	300.0
2013-08-16 07:10:00	SPY	ETF	166.49	166.59	166.49	166.59	30490.0
2013-08-16 07:15:00	SPY	ETF	166.61	166.67	166.59	166.62	242495.0
2013-08-16 07:20:00	SPY	ETF	166.62	166.62	166.62	166.62	4100.0
2013-08-16 07:25:00	SPY	ETF	166.62	166.63	166.59	166.59	5200.0
2013-08-16 07:30:00	SPY	ETF	166.62	166.64	166.58	166.64	26298.0
2013-08-16 07:35:00	SPY	ETF	166.62	166.62	166.55	166.55	2000.0
2013-08-16 07:40:00	SPY	ETF	166.55	166.57	166.55	166.56	5700.0
2013-08-16 07:45:00	SPY	ETF	166.58	166.58	166.55	166.58	12100.0
2013-08-16 07:50:00	SPY	ETF	166.57	166.59	166.5	166.5	41255.0
2013-08-16 07:55:00	SPY	ETF	166.48	166.5	166.47	166.47	30590.0
2013-08-16 08:00:00	SPY	ETF	166.48	166.64	166.4	166.4	68320.0
2013-08-16 08:05:00	SPY	ETF	166.4	166.53	166.38	166.5	21748.0
2013-08-16 08:10:00	SPY	ETF	166.47	166.48	166.42	166.45	8750.0
2013-08-16 08:15:00	SPY	ETF	166.45	166.45	166.4	166.42	48250.0
2013-08-16 08:20:00	SPY	ETF	166.44	166.46	166.4	166.43	17020.0
2013-08-16 08:25:00	SPY	ETF	166.42	166.43	166.38	166.4	3400.0
2013-08-16 08:30:00	SPY	ETF	166.36	166.45	166.36	166.44	18540.0
2013-08-16 08:35:00	SPY	ETF	166.44	166.45	166.28	166.3	46138.0
2013-08-16 08:40:00	SPY	ETF	166.3	166.37	166.29	166.35	68040.0
2013-08-16 08:45:00	SPY	ETF	166.33	166.37	166.29	166.29	89437.0
2013-08-16 08:50:00	SPY	ETF	166.3	166.35	166.29	166.33	27840.0
2013-08-16 08:55:00	SPY	ETF	166.33	166.35	166.26	166.28	82800.0
2013-08-16 09:00:00	SPY	ETF	166.29	166.34	166.14	166.32	188369.0
2013-08-16 09:05:00	SPY	ETF	166.3	166.32	166.2	166.2	100515.0
2013-08-16 09:10:00	SPY	ETF	166.2	166.29	166.14	166.27	142991.0
2013-08-16 09:15:00	SPY	ETF	166.28	166.29	166.19	166.2	35107.0
2013-08-16 09:20:00	SPY	ETF	166.18	166.22	166.16	166.2	59079.0
2013-08-16 09:25:00	SPY	ETF	166.19	166.19	166.03	166.06	540275.0
2013-08-16 09:30:00	SPY	ETF	166.06	166.15	165.97	166.0	3595652.0
2013-08-16 09:35:00	SPY	ETF	166.0	166.18	165.87	166.16	3370357.0

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

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