PREVIEW / etf_5min / 2014-06-06

all etf 5-min files

  file:    by_date/etf_5min/2014/2014-06-06.parquet
  size:    954 KB
  rows:    41,790

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-06 04:05:00	SPY	ETF	194.46	194.48	194.46	194.48	200.0
2014-06-06 04:10:00	SPY	ETF	194.5	194.5	194.5	194.5	159.0
2014-06-06 04:15:00	SPY	ETF	194.5	194.5	194.5	194.5	500.0
2014-06-06 04:20:00	SPY	ETF	194.5	194.5	194.5	194.5	3342.0
2014-06-06 04:35:00	SPY	ETF	194.61	194.61	194.61	194.61	100.0
2014-06-06 05:20:00	SPY	ETF	194.59	194.59	194.58	194.58	420.0
2014-06-06 05:25:00	SPY	ETF	194.64	194.64	194.64	194.64	100.0
2014-06-06 05:35:00	SPY	ETF	194.51	194.61	194.51	194.61	2200.0
2014-06-06 05:40:00	SPY	ETF	194.65	194.7	194.65	194.69	1100.0
2014-06-06 05:45:00	SPY	ETF	194.72	194.72	194.72	194.72	600.0
2014-06-06 05:55:00	SPY	ETF	194.69	194.69	194.65	194.65	500.0
2014-06-06 06:00:00	SPY	ETF	194.68	194.69	194.62	194.69	5405.0
2014-06-06 06:15:00	SPY	ETF	194.71	194.71	194.66	194.66	11200.0
2014-06-06 06:20:00	SPY	ETF	194.7	194.7	194.7	194.7	100.0
2014-06-06 06:35:00	SPY	ETF	194.65	194.68	194.65	194.67	39300.0
2014-06-06 06:40:00	SPY	ETF	194.68	194.69	194.66	194.66	17300.0
2014-06-06 06:45:00	SPY	ETF	194.7	194.7	194.65	194.65	1420.0
2014-06-06 07:00:00	SPY	ETF	194.66	194.66	194.66	194.66	300.0
2014-06-06 07:05:00	SPY	ETF	194.65	194.65	194.65	194.65	9275.0
2014-06-06 07:10:00	SPY	ETF	194.65	194.65	194.65	194.65	309.0
2014-06-06 07:20:00	SPY	ETF	194.61	194.61	194.61	194.61	100.0
2014-06-06 07:25:00	SPY	ETF	194.64	194.64	194.64	194.64	801.0
2014-06-06 07:35:00	SPY	ETF	194.63	194.65	194.62	194.62	10527.0
2014-06-06 07:40:00	SPY	ETF	194.62	194.63	194.62	194.62	102300.0
2014-06-06 07:45:00	SPY	ETF	194.65	194.65	194.57	194.58	51201.0
2014-06-06 07:50:00	SPY	ETF	194.56	194.58	194.5	194.58	37330.0
2014-06-06 07:55:00	SPY	ETF	194.56	194.61	194.55	194.55	22574.0
2014-06-06 08:00:00	SPY	ETF	194.56	194.63	194.479	194.479	212954.0
2014-06-06 08:05:00	SPY	ETF	194.57	194.57	194.52	194.53	25380.0
2014-06-06 08:10:00	SPY	ETF	194.52	194.55	194.49	194.55	22304.0
2014-06-06 08:15:00	SPY	ETF	194.55	194.55	194.48	194.49	56406.0
2014-06-06 08:20:00	SPY	ETF	194.5	194.53	194.45	194.51	103268.0
2014-06-06 08:25:00	SPY	ETF	194.49	194.54	194.48	194.51	79231.0
2014-06-06 08:30:00	SPY	ETF	194.51	194.96	194.49	194.87	770088.0
2014-06-06 08:35:00	SPY	ETF	194.86	194.91	194.8	194.82	420428.0
2014-06-06 08:40:00	SPY	ETF	194.82	194.86	194.78	194.83	151657.0
2014-06-06 08:45:00	SPY	ETF	194.84	194.87	194.68	194.69	245014.0
2014-06-06 08:50:00	SPY	ETF	194.69	194.84	194.64	194.84	183683.0
2014-06-06 08:55:00	SPY	ETF	194.85	194.94	194.85	194.88	157513.0
2014-06-06 09:00:00	SPY	ETF	194.87	194.88	194.82	194.88	32158.0
2014-06-06 09:05:00	SPY	ETF	194.89	194.9	194.87	194.88	79977.0
2014-06-06 09:10:00	SPY	ETF	194.88	194.89	194.79	194.8	79519.0
2014-06-06 09:15:00	SPY	ETF	194.82	194.82	194.75	194.82	87663.0
2014-06-06 09:20:00	SPY	ETF	194.82	194.9	194.81	194.88	52907.0
2014-06-06 09:25:00	SPY	ETF	194.85	194.89	194.82	194.84	133041.0
2014-06-06 09:30:00	SPY	ETF	194.87	194.91	194.78	194.85	3032651.0
2014-06-06 09:35:00	SPY	ETF	194.85	195.1	194.84	195.03	1909872.0
2014-06-06 09:40:00	SPY	ETF	195.04	195.1	194.97	195.05	1250401.0
2014-06-06 09:45:00	SPY	ETF	195.05	195.08	194.92	195.06	1277755.0
2014-06-06 09:50:00	SPY	ETF	195.07	195.1	195.0	195.032	842985.0

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

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