PREVIEW / etf_5min / 2013-01-16

all etf 5-min files

  file:    by_date/etf_5min/2013/2013-01-16.parquet
  size:    886 KB
  rows:    38,647

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-01-16 04:00:00	SPY	ETF	146.84	146.84	146.5	146.5	2900.0
2013-01-16 04:05:00	SPY	ETF	146.53	146.53	146.41	146.41	11099.0
2013-01-16 04:20:00	SPY	ETF	146.45	146.45	146.45	146.45	4400.0
2013-01-16 04:50:00	SPY	ETF	146.5	146.5	146.45	146.45	300.0
2013-01-16 05:00:00	SPY	ETF	146.42	146.45	146.42	146.45	329.0
2013-01-16 05:05:00	SPY	ETF	146.41	146.41	146.41	146.41	100.0
2013-01-16 05:10:00	SPY	ETF	146.4	146.41	146.38	146.41	4500.0
2013-01-16 05:15:00	SPY	ETF	146.47	146.56	146.47	146.55	5049.0
2013-01-16 05:20:00	SPY	ETF	146.55	146.55	146.55	146.55	2200.0
2013-01-16 05:25:00	SPY	ETF	146.5	146.5	146.5	146.5	690.0
2013-01-16 05:30:00	SPY	ETF	146.52	146.52	146.52	146.52	100.0
2013-01-16 05:35:00	SPY	ETF	146.53	146.53	146.53	146.53	1000.0
2013-01-16 05:45:00	SPY	ETF	146.53	146.53	146.52	146.52	8900.0
2013-01-16 05:50:00	SPY	ETF	146.52	146.58	146.52	146.58	9100.0
2013-01-16 05:55:00	SPY	ETF	146.55	146.55	146.55	146.55	4000.0
2013-01-16 06:00:00	SPY	ETF	146.58	146.62	146.58	146.62	33600.0
2013-01-16 06:05:00	SPY	ETF	146.63	146.63	146.63	146.63	196.0
2013-01-16 06:10:00	SPY	ETF	146.73	146.8	146.72	146.77	28399.0
2013-01-16 06:20:00	SPY	ETF	146.76	146.79	146.76	146.77	10400.0
2013-01-16 06:25:00	SPY	ETF	146.69	146.69	146.69	146.69	600.0
2013-01-16 06:30:00	SPY	ETF	146.71	146.71	146.67	146.67	16200.0
2013-01-16 06:35:00	SPY	ETF	146.65	146.65	146.64	146.64	200.0
2013-01-16 06:45:00	SPY	ETF	146.68	146.68	146.68	146.68	100.0
2013-01-16 06:50:00	SPY	ETF	146.65	146.65	146.65	146.65	100.0
2013-01-16 06:55:00	SPY	ETF	146.63	146.63	146.63	146.63	1139.0
2013-01-16 07:00:00	SPY	ETF	146.72	146.72	146.55	146.56	82492.0
2013-01-16 07:05:00	SPY	ETF	146.56	146.56	146.52	146.54	11000.0
2013-01-16 07:10:00	SPY	ETF	146.52	146.57	146.5	146.57	35180.0
2013-01-16 07:15:00	SPY	ETF	146.57	146.58	146.51	146.57	27900.0
2013-01-16 07:20:00	SPY	ETF	146.55	146.57	146.48	146.5	54400.0
2013-01-16 07:25:00	SPY	ETF	146.52	146.52	146.49	146.5	5300.0
2013-01-16 07:30:00	SPY	ETF	146.49	146.56	146.49	146.54	35681.0
2013-01-16 07:35:00	SPY	ETF	146.61	146.71	146.6	146.61	185498.0
2013-01-16 07:40:00	SPY	ETF	146.62	146.63	146.54	146.6	50145.0
2013-01-16 07:45:00	SPY	ETF	146.55	146.58	146.39	146.4	105530.0
2013-01-16 07:50:00	SPY	ETF	146.41	146.47	146.39	146.45	128244.0
2013-01-16 07:55:00	SPY	ETF	146.48	146.5	146.4	146.4	83800.0
2013-01-16 08:00:00	SPY	ETF	146.42	146.7	146.4	146.51	135545.0
2013-01-16 08:05:00	SPY	ETF	146.505	146.54	146.5	146.54	49782.0
2013-01-16 08:10:00	SPY	ETF	146.54	146.6	146.53	146.59	74753.0
2013-01-16 08:15:00	SPY	ETF	146.59	146.63	146.55	146.63	31857.0
2013-01-16 08:20:00	SPY	ETF	146.63	146.69	146.61	146.67	80316.0
2013-01-16 08:25:00	SPY	ETF	146.67	146.76	146.65	146.73	70371.0
2013-01-16 08:30:00	SPY	ETF	146.73	146.73	146.62	146.63	99922.0
2013-01-16 08:35:00	SPY	ETF	146.62	146.62	146.52	146.57	135602.0
2013-01-16 08:40:00	SPY	ETF	146.57	146.6	146.54	146.54	133115.0
2013-01-16 08:45:00	SPY	ETF	146.54	146.58	146.52	146.57	153152.0
2013-01-16 08:50:00	SPY	ETF	146.56	146.57	146.5	146.53	85411.0
2013-01-16 08:55:00	SPY	ETF	146.52	146.56	146.49	146.55	66280.0
2013-01-16 09:00:00	SPY	ETF	146.555	146.65	146.555	146.63	689186.0

> showing 50 of 38,647 rows — these rows as CSV

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