PREVIEW / etf_5min / 2013-04-29

all etf 5-min files

  file:    by_date/etf_5min/2013/2013-04-29.parquet
  size:    949 KB
  rows:    40,314

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-04-29 04:00:00	SPY	ETF	158.44	158.44	158.44	158.44	199.0
2013-04-29 04:10:00	SPY	ETF	158.56	158.56	158.56	158.56	260.0
2013-04-29 04:15:00	SPY	ETF	158.58	158.61	158.58	158.61	400.0
2013-04-29 04:20:00	SPY	ETF	158.64	158.65	158.64	158.65	7500.0
2013-04-29 04:30:00	SPY	ETF	158.6	158.6	158.56	158.56	20500.0
2013-04-29 04:35:00	SPY	ETF	158.62	158.62	158.62	158.62	100.0
2013-04-29 04:45:00	SPY	ETF	158.57	158.57	158.57	158.57	3600.0
2013-04-29 04:50:00	SPY	ETF	158.56	158.56	158.56	158.56	100.0
2013-04-29 05:15:00	SPY	ETF	158.6	158.6	158.6	158.6	2100.0
2013-04-29 05:20:00	SPY	ETF	158.6	158.6	158.6	158.6	500.0
2013-04-29 05:25:00	SPY	ETF	158.55	158.55	158.54	158.54	300.0
2013-04-29 05:30:00	SPY	ETF	158.52	158.52	158.52	158.52	500.0
2013-04-29 05:50:00	SPY	ETF	158.48	158.51	158.45	158.46	3700.0
2013-04-29 05:55:00	SPY	ETF	158.5	158.5	158.5	158.5	100.0
2013-04-29 06:00:00	SPY	ETF	158.47	158.47	158.46	158.46	6800.0
2013-04-29 06:05:00	SPY	ETF	158.46	158.46	158.46	158.46	100.0
2013-04-29 06:15:00	SPY	ETF	158.5	158.5	158.5	158.5	400.0
2013-04-29 06:20:00	SPY	ETF	158.52	158.52	158.52	158.52	100.0
2013-04-29 06:25:00	SPY	ETF	158.54	158.54	158.54	158.54	200.0
2013-04-29 06:45:00	SPY	ETF	158.53	158.56	158.53	158.56	500.0
2013-04-29 06:50:00	SPY	ETF	158.56	158.56	158.53	158.53	45283.0
2013-04-29 06:55:00	SPY	ETF	158.53	158.53	158.51	158.51	5200.0
2013-04-29 07:00:00	SPY	ETF	158.53	158.53	158.47	158.52	2100.0
2013-04-29 07:05:00	SPY	ETF	158.56	158.56	158.49	158.53	6360.0
2013-04-29 07:10:00	SPY	ETF	158.56	158.6	158.56	158.6	4600.0
2013-04-29 07:15:00	SPY	ETF	158.6	158.61	158.59	158.59	45369.0
2013-04-29 07:20:00	SPY	ETF	158.59	158.59	158.56	158.56	11800.0
2013-04-29 07:25:00	SPY	ETF	158.56	158.63	158.53	158.61	11831.0
2013-04-29 07:30:00	SPY	ETF	158.59	158.71	158.59	158.68	7224.0
2013-04-29 07:35:00	SPY	ETF	158.68	158.68	158.61	158.61	14500.0
2013-04-29 07:40:00	SPY	ETF	158.61	158.61	158.59	158.59	66190.0
2013-04-29 07:45:00	SPY	ETF	158.63	158.65	158.62	158.65	4310.0
2013-04-29 07:50:00	SPY	ETF	158.63	158.66	158.59	158.66	12727.0
2013-04-29 07:55:00	SPY	ETF	158.65	158.69	158.65	158.65	37977.0
2013-04-29 08:00:00	SPY	ETF	158.65	158.77	158.53	158.73	100718.0
2013-04-29 08:05:00	SPY	ETF	158.61	158.75	158.61	158.72	43354.0
2013-04-29 08:10:00	SPY	ETF	158.72	158.75	158.69	158.69	18492.0
2013-04-29 08:15:00	SPY	ETF	158.69	158.71	158.65	158.67	33380.0
2013-04-29 08:20:00	SPY	ETF	158.7	158.72	158.68	158.68	10500.0
2013-04-29 08:25:00	SPY	ETF	158.68	158.71	158.61	158.66	15230.0
2013-04-29 08:30:00	SPY	ETF	158.65	158.72	158.57	158.58	151899.0
2013-04-29 08:35:00	SPY	ETF	158.58	158.61	158.57	158.61	36442.0
2013-04-29 08:40:00	SPY	ETF	158.62	158.66	158.6	158.65	27788.0
2013-04-29 08:45:00	SPY	ETF	158.67	158.69	158.62	158.62	62428.0
2013-04-29 08:50:00	SPY	ETF	158.62	158.65	158.59	158.65	15920.0
2013-04-29 08:55:00	SPY	ETF	158.64	158.66	158.58	158.59	35742.0
2013-04-29 09:00:00	SPY	ETF	158.59	158.68	158.58	158.67	38612.0
2013-04-29 09:05:00	SPY	ETF	158.66	158.68	158.64	158.68	42300.0
2013-04-29 09:10:00	SPY	ETF	158.68	158.71	158.66	158.71	17795.0
2013-04-29 09:15:00	SPY	ETF	158.71	158.77	158.68	158.71	75058.0

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

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