PREVIEW / etf_5min / 2012-08-21

all etf 5-min files

  file:    by_date/etf_5min/2012/2012-08-21.parquet
  size:    914 KB
  rows:    36,622

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
2012-08-21 04:00:00	SPY	ETF	142.3	142.3	142.3	142.3	1300.0
2012-08-21 04:05:00	SPY	ETF	142.44	142.48	142.44	142.48	734.0
2012-08-21 05:25:00	SPY	ETF	142.41	142.41	142.36	142.36	418.0
2012-08-21 05:30:00	SPY	ETF	142.4	142.4	142.4	142.4	108.0
2012-08-21 05:35:00	SPY	ETF	142.42	142.42	142.42	142.42	200.0
2012-08-21 05:50:00	SPY	ETF	142.37	142.37	142.37	142.37	1000.0
2012-08-21 05:55:00	SPY	ETF	142.33	142.33	142.33	142.33	300.0
2012-08-21 06:05:00	SPY	ETF	142.42	142.42	142.42	142.42	200.0
2012-08-21 06:30:00	SPY	ETF	142.41	142.41	142.41	142.41	300.0
2012-08-21 06:40:00	SPY	ETF	142.42	142.42	142.4	142.4	600.0
2012-08-21 06:45:00	SPY	ETF	142.45	142.45	142.45	142.45	200.0
2012-08-21 06:50:00	SPY	ETF	142.41	142.41	142.41	142.41	100.0
2012-08-21 06:55:00	SPY	ETF	142.45	142.45	142.42	142.42	2550.0
2012-08-21 07:00:00	SPY	ETF	142.42	142.42	142.39	142.39	2000.0
2012-08-21 07:05:00	SPY	ETF	142.42	142.42	142.39	142.42	1500.0
2012-08-21 07:10:00	SPY	ETF	142.38	142.38	142.33	142.36	800.0
2012-08-21 07:15:00	SPY	ETF	142.36	142.37	142.36	142.37	300.0
2012-08-21 07:20:00	SPY	ETF	142.38	142.39	142.38	142.39	1200.0
2012-08-21 07:25:00	SPY	ETF	142.36	142.36	142.35	142.36	3000.0
2012-08-21 07:30:00	SPY	ETF	142.38	142.38	142.38	142.38	550.0
2012-08-21 07:35:00	SPY	ETF	142.39	142.4	142.37	142.37	1000.0
2012-08-21 07:40:00	SPY	ETF	142.38	142.41	142.38	142.41	3575.0
2012-08-21 07:45:00	SPY	ETF	142.42	142.43	142.4	142.4	6700.0
2012-08-21 07:50:00	SPY	ETF	142.4	142.42	142.38	142.42	1900.0
2012-08-21 07:55:00	SPY	ETF	142.43	142.47	142.43	142.47	9530.0
2012-08-21 08:00:00	SPY	ETF	142.45	142.47	142.43	142.43	32151.0
2012-08-21 08:05:00	SPY	ETF	142.46	142.46	142.4	142.42	35830.0
2012-08-21 08:10:00	SPY	ETF	142.42	142.43	142.38	142.38	54586.0
2012-08-21 08:15:00	SPY	ETF	142.38	142.38	142.35	142.36	12821.0
2012-08-21 08:20:00	SPY	ETF	142.38	142.4	142.37	142.39	12300.0
2012-08-21 08:25:00	SPY	ETF	142.39	142.4	142.38	142.39	18072.0
2012-08-21 08:30:00	SPY	ETF	142.39	142.42	142.38	142.41	42100.0
2012-08-21 08:35:00	SPY	ETF	142.42	142.55	142.41	142.53	99645.0
2012-08-21 08:40:00	SPY	ETF	142.54	142.67	142.54	142.61	140770.0
2012-08-21 08:45:00	SPY	ETF	142.6	142.61	142.55	142.56	40416.0
2012-08-21 08:50:00	SPY	ETF	142.56	142.6	142.55	142.57	72970.0
2012-08-21 08:55:00	SPY	ETF	142.56	142.6	142.55	142.6	92550.0
2012-08-21 09:00:00	SPY	ETF	142.59	142.6	142.58	142.59	19750.0
2012-08-21 09:05:00	SPY	ETF	142.59	142.6	142.55	142.56	41800.0
2012-08-21 09:10:00	SPY	ETF	142.56	142.56	142.53	142.54	40805.0
2012-08-21 09:15:00	SPY	ETF	142.55	142.58	142.55	142.58	63700.0
2012-08-21 09:20:00	SPY	ETF	142.58	142.59	142.54	142.55	53174.0
2012-08-21 09:25:00	SPY	ETF	142.55	142.6	142.51	142.53	186374.0
2012-08-21 09:30:00	SPY	ETF	142.54	142.73	142.46	142.682	2762066.0
2012-08-21 09:35:00	SPY	ETF	142.67	142.695	142.54	142.58	2473823.0
2012-08-21 09:40:00	SPY	ETF	142.58	142.61	142.52	142.565	1514307.0
2012-08-21 09:45:00	SPY	ETF	142.56	142.64	142.55	142.6	1000835.0
2012-08-21 09:50:00	SPY	ETF	142.6	142.63	142.49	142.5587	996662.0
2012-08-21 09:55:00	SPY	ETF	142.555	142.76	142.555	142.74	1344551.0
2012-08-21 10:00:00	SPY	ETF	142.74	142.91	142.74	142.89	1831553.0

> showing 50 of 36,622 rows — these rows as CSV

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