PREVIEW / etf_5min / 2013-09-24

all etf 5-min files

  file:    by_date/etf_5min/2013/2013-09-24.parquet
  size:    963 KB
  rows:    40,111

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-09-24 04:00:00	SPY	ETF	169.65	169.65	169.59	169.59	800.0
2013-09-24 04:05:00	SPY	ETF	169.51	169.51	169.51	169.51	5400.0
2013-09-24 04:10:00	SPY	ETF	169.5	169.5	169.5	169.5	475.0
2013-09-24 04:15:00	SPY	ETF	169.52	169.55	169.52	169.55	400.0
2013-09-24 04:20:00	SPY	ETF	169.56	169.56	169.56	169.56	2500.0
2013-09-24 04:25:00	SPY	ETF	169.61	169.65	169.61	169.65	5200.0
2013-09-24 04:30:00	SPY	ETF	169.63	169.65	169.63	169.65	1900.0
2013-09-24 04:35:00	SPY	ETF	169.63	169.7	169.63	169.67	1500.0
2013-09-24 04:40:00	SPY	ETF	169.7	169.7	169.7	169.7	300.0
2013-09-24 04:45:00	SPY	ETF	169.67	169.67	169.67	169.67	300.0
2013-09-24 04:50:00	SPY	ETF	169.64	169.64	169.61	169.64	900.0
2013-09-24 04:55:00	SPY	ETF	169.67	169.67	169.67	169.67	300.0
2013-09-24 05:00:00	SPY	ETF	169.7	169.7	169.7	169.7	300.0
2013-09-24 05:05:00	SPY	ETF	169.67	169.67	169.67	169.67	300.0
2013-09-24 05:10:00	SPY	ETF	169.64	169.64	169.64	169.64	300.0
2013-09-24 05:15:00	SPY	ETF	169.61	169.61	169.58	169.58	600.0
2013-09-24 05:35:00	SPY	ETF	169.55	169.55	169.49	169.5	1800.0
2013-09-24 05:40:00	SPY	ETF	169.46	169.52	169.46	169.5	2200.0
2013-09-24 05:55:00	SPY	ETF	169.55	169.56	169.55	169.56	500.0
2013-09-24 06:00:00	SPY	ETF	169.54	169.54	169.49	169.51	1200.0
2013-09-24 06:05:00	SPY	ETF	169.49	169.49	169.49	169.49	10000.0
2013-09-24 06:10:00	SPY	ETF	169.52	169.52	169.52	169.52	200.0
2013-09-24 06:15:00	SPY	ETF	169.55	169.6	169.55	169.6	600.0
2013-09-24 06:20:00	SPY	ETF	169.61	169.64	169.61	169.64	700.0
2013-09-24 06:30:00	SPY	ETF	169.67	169.67	169.67	169.67	300.0
2013-09-24 06:35:00	SPY	ETF	169.66	169.66	169.66	169.66	15000.0
2013-09-24 06:40:00	SPY	ETF	169.64	169.64	169.64	169.64	300.0
2013-09-24 06:45:00	SPY	ETF	169.64	169.64	169.64	169.64	20000.0
2013-09-24 06:50:00	SPY	ETF	169.67	169.67	169.64	169.64	1700.0
2013-09-24 06:55:00	SPY	ETF	169.67	169.67	169.64	169.64	1000.0
2013-09-24 07:00:00	SPY	ETF	169.63	169.64	169.58	169.58	4100.0
2013-09-24 07:05:00	SPY	ETF	169.58	169.61	169.56	169.61	1500.0
2013-09-24 07:10:00	SPY	ETF	169.64	169.66	169.61	169.61	3900.0
2013-09-24 07:15:00	SPY	ETF	169.64	169.64	169.61	169.61	200.0
2013-09-24 07:20:00	SPY	ETF	169.64	169.65	169.62	169.62	1100.0
2013-09-24 07:25:00	SPY	ETF	169.64	169.73	169.64	169.73	11745.0
2013-09-24 07:30:00	SPY	ETF	169.75	169.75	169.64	169.64	22775.0
2013-09-24 07:35:00	SPY	ETF	169.61	169.62	169.55	169.56	38765.0
2013-09-24 07:40:00	SPY	ETF	169.55	169.56	169.51	169.56	32552.0
2013-09-24 07:45:00	SPY	ETF	169.56	169.56	169.47	169.47	5625.0
2013-09-24 07:50:00	SPY	ETF	169.48	169.52	169.42	169.42	44300.0
2013-09-24 07:55:00	SPY	ETF	169.45	169.46	169.43	169.46	122200.0
2013-09-24 08:00:00	SPY	ETF	169.55	169.55	169.46	169.5	26270.0
2013-09-24 08:05:00	SPY	ETF	169.51	169.56	169.49	169.55	67423.0
2013-09-24 08:10:00	SPY	ETF	169.56	169.61	169.56	169.61	15017.0
2013-09-24 08:15:00	SPY	ETF	169.62	169.67	169.6	169.61	17869.0
2013-09-24 08:20:00	SPY	ETF	169.61	169.64	169.6	169.62	18754.0
2013-09-24 08:25:00	SPY	ETF	169.63	169.66	169.62	169.63	5010.0
2013-09-24 08:30:00	SPY	ETF	169.66	169.67	169.64	169.65	55249.0
2013-09-24 08:35:00	SPY	ETF	169.65	169.67	169.65	169.66	23317.0

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

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