PREVIEW / etf_5min / 2013-03-07

all etf 5-min files

  file:    by_date/etf_5min/2013/2013-03-07.parquet
  size:    911 KB
  rows:    40,311

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-03-07 04:35:00	SPY	ETF	154.54	154.54	154.54	154.54	150.0
2013-03-07 04:50:00	SPY	ETF	154.6	154.6	154.58	154.58	300.0
2013-03-07 05:15:00	SPY	ETF	154.66	154.66	154.66	154.66	300.0
2013-03-07 05:30:00	SPY	ETF	154.6	154.6	154.6	154.6	200.0
2013-03-07 05:35:00	SPY	ETF	154.59	154.61	154.59	154.61	2000.0
2013-03-07 05:40:00	SPY	ETF	154.59	154.59	154.59	154.59	100.0
2013-03-07 05:50:00	SPY	ETF	154.6	154.6	154.59	154.59	600.0
2013-03-07 05:55:00	SPY	ETF	154.6	154.6	154.57	154.57	400.0
2013-03-07 06:00:00	SPY	ETF	154.55	154.6	154.55	154.6	400.0
2013-03-07 06:05:00	SPY	ETF	154.6	154.6	154.6	154.6	200.0
2013-03-07 06:15:00	SPY	ETF	154.65	154.65	154.65	154.65	200.0
2013-03-07 06:25:00	SPY	ETF	154.6	154.6	154.56	154.56	1000.0
2013-03-07 06:40:00	SPY	ETF	154.52	154.52	154.52	154.52	300.0
2013-03-07 06:50:00	SPY	ETF	154.57	154.57	154.57	154.57	300.0
2013-03-07 06:55:00	SPY	ETF	154.59	154.62	154.59	154.62	400.0
2013-03-07 07:00:00	SPY	ETF	154.59	154.6	154.5	154.51	87000.0
2013-03-07 07:05:00	SPY	ETF	154.51	154.53	154.47	154.47	128100.0
2013-03-07 07:10:00	SPY	ETF	154.48	154.55	154.47	154.5	181122.0
2013-03-07 07:15:00	SPY	ETF	154.47	154.495	154.47	154.47	16370.0
2013-03-07 07:20:00	SPY	ETF	154.47	154.47	154.39	154.39	29300.0
2013-03-07 07:25:00	SPY	ETF	154.39	154.44	154.38	154.39	27700.0
2013-03-07 07:30:00	SPY	ETF	154.43	154.44	154.43	154.44	9005.0
2013-03-07 07:35:00	SPY	ETF	154.435	154.48	154.42	154.48	9100.0
2013-03-07 07:40:00	SPY	ETF	154.49	154.49	154.47	154.49	26900.0
2013-03-07 07:45:00	SPY	ETF	154.47	154.49	154.34	154.4	90000.0
2013-03-07 07:50:00	SPY	ETF	154.37	154.45	154.37	154.45	116697.0
2013-03-07 07:55:00	SPY	ETF	154.44	154.5	154.44	154.5	47016.0
2013-03-07 08:00:00	SPY	ETF	154.5	154.54	154.4	154.48	819598.0
2013-03-07 08:05:00	SPY	ETF	154.52	154.53	154.48	154.48	65880.0
2013-03-07 08:10:00	SPY	ETF	154.48	154.5	154.48	154.48	11500.0
2013-03-07 08:15:00	SPY	ETF	154.47	154.51	154.47	154.48	75353.0
2013-03-07 08:20:00	SPY	ETF	154.47	154.55	154.47	154.55	43706.0
2013-03-07 08:25:00	SPY	ETF	154.54	154.62	154.52	154.57	233463.0
2013-03-07 08:30:00	SPY	ETF	154.54	154.68	154.53	154.61	328197.0
2013-03-07 08:35:00	SPY	ETF	154.65	154.69	154.59	154.67	148315.0
2013-03-07 08:40:00	SPY	ETF	154.67	154.82	154.65	154.78	203645.0
2013-03-07 08:45:00	SPY	ETF	154.79	154.84	154.68	154.75	135508.0
2013-03-07 08:50:00	SPY	ETF	154.73	154.88	154.73	154.81	245596.0
2013-03-07 08:55:00	SPY	ETF	154.82	154.87	154.74	154.74	95002.0
2013-03-07 09:00:00	SPY	ETF	154.74	154.81	154.74	154.81	16350.0
2013-03-07 09:05:00	SPY	ETF	154.8	154.83	154.6	154.6	130806.0
2013-03-07 09:10:00	SPY	ETF	154.6	154.64	154.49	154.58	235625.0
2013-03-07 09:15:00	SPY	ETF	154.58	154.66	154.56	154.66	36310.0
2013-03-07 09:20:00	SPY	ETF	154.66	154.66	154.57	154.63	114167.0
2013-03-07 09:25:00	SPY	ETF	154.64	154.73	154.62	154.71	88307.0
2013-03-07 09:30:00	SPY	ETF	154.7	154.9	154.64	154.87	2742541.0
2013-03-07 09:35:00	SPY	ETF	154.87	154.91	154.71	154.71	1850128.0
2013-03-07 09:40:00	SPY	ETF	154.71	154.76	154.6	154.75	1379719.0
2013-03-07 09:45:00	SPY	ETF	154.75	154.78	154.62	154.64	1071026.0
2013-03-07 09:50:00	SPY	ETF	154.65	154.8	154.54	154.738	1478935.0

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

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