PREVIEW / etf_5min / 2011-04-18

all etf 5-min files

  file:    by_date/etf_5min/2011/2011-04-18.parquet
  size:    948 KB
  rows:    38,789

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
2011-04-18 04:00:00	SPY	ETF	132.3	132.3	131.8	131.8	101579.0
2011-04-18 04:05:00	SPY	ETF	131.81	131.81	131.81	131.81	100.0
2011-04-18 04:15:00	SPY	ETF	131.74	131.74	131.73	131.73	400.0
2011-04-18 04:35:00	SPY	ETF	131.65	131.65	131.65	131.65	100.0
2011-04-18 04:50:00	SPY	ETF	131.61	131.61	131.61	131.61	400.0
2011-04-18 04:55:00	SPY	ETF	131.57	131.57	131.48	131.48	1600.0
2011-04-18 05:05:00	SPY	ETF	131.57	131.57	131.57	131.57	200.0
2011-04-18 05:10:00	SPY	ETF	131.66	131.66	131.55	131.55	1000.0
2011-04-18 05:20:00	SPY	ETF	131.55	131.55	131.55	131.55	600.0
2011-04-18 05:25:00	SPY	ETF	131.53	131.53	131.47	131.47	1700.0
2011-04-18 05:40:00	SPY	ETF	131.5	131.55	131.5	131.55	700.0
2011-04-18 05:45:00	SPY	ETF	131.47	131.47	131.47	131.47	300.0
2011-04-18 05:55:00	SPY	ETF	131.53	131.55	131.53	131.54	25000.0
2011-04-18 06:05:00	SPY	ETF	131.5	131.5	131.5	131.5	2500.0
2011-04-18 06:15:00	SPY	ETF	131.5	131.5	131.47	131.47	1100.0
2011-04-18 06:20:00	SPY	ETF	131.47	131.47	131.37	131.37	6100.0
2011-04-18 06:25:00	SPY	ETF	131.4	131.4	131.4	131.4	1300.0
2011-04-18 06:30:00	SPY	ETF	131.4	131.4	131.35	131.35	800.0
2011-04-18 06:35:00	SPY	ETF	131.38	131.38	131.33	131.38	50550.0
2011-04-18 06:40:00	SPY	ETF	131.35	131.35	131.3	131.35	11250.0
2011-04-18 06:45:00	SPY	ETF	131.38	131.38	131.33	131.37	36550.0
2011-04-18 06:50:00	SPY	ETF	131.4	131.41	131.35	131.41	13300.0
2011-04-18 06:55:00	SPY	ETF	131.43	131.43	131.4	131.42	22500.0
2011-04-18 07:00:00	SPY	ETF	131.42	131.42	131.39	131.41	24500.0
2011-04-18 07:05:00	SPY	ETF	131.41	131.42	131.4	131.42	12675.0
2011-04-18 07:10:00	SPY	ETF	131.42	131.47	131.4	131.47	27400.0
2011-04-18 07:15:00	SPY	ETF	131.5	131.55	131.5	131.52	108600.0
2011-04-18 07:20:00	SPY	ETF	131.52	131.52	131.49	131.5	7652.0
2011-04-18 07:25:00	SPY	ETF	131.5	131.52	131.5	131.51	3300.0
2011-04-18 07:30:00	SPY	ETF	131.5	131.5	131.45	131.47	20386.0
2011-04-18 07:35:00	SPY	ETF	131.45	131.45	131.39	131.43	24450.0
2011-04-18 07:40:00	SPY	ETF	131.43	131.43	131.36	131.4	13107.0
2011-04-18 07:45:00	SPY	ETF	131.4	131.45	131.37	131.42	64600.0
2011-04-18 07:50:00	SPY	ETF	131.41	131.41	131.39	131.39	86250.0
2011-04-18 07:55:00	SPY	ETF	131.39	131.42	131.35	131.41	59300.0
2011-04-18 08:00:00	SPY	ETF	131.42	131.5	131.37	131.4	289873.0
2011-04-18 08:05:00	SPY	ETF	131.49	131.53	131.47	131.51	100651.0
2011-04-18 08:10:00	SPY	ETF	131.5	132.08	131.4	131.41	123556.0
2011-04-18 08:15:00	SPY	ETF	131.42	131.51	131.41	131.51	33910.0
2011-04-18 08:20:00	SPY	ETF	131.52	131.55	131.5	131.51	157227.0
2011-04-18 08:25:00	SPY	ETF	131.51	131.53	131.49	131.53	73637.0
2011-04-18 08:30:00	SPY	ETF	131.53	131.57	131.5	131.52	102516.0
2011-04-18 08:35:00	SPY	ETF	131.51	131.57	131.51	131.55	132254.0
2011-04-18 08:40:00	SPY	ETF	131.56	131.57	131.5	131.5	52511.0
2011-04-18 08:45:00	SPY	ETF	131.51	131.52	131.45	131.46	257253.0
2011-04-18 08:50:00	SPY	ETF	131.46	131.47	131.44	131.45	84820.0
2011-04-18 08:55:00	SPY	ETF	131.45	131.46	131.37	131.4	219814.0
2011-04-18 09:00:00	SPY	ETF	131.39	131.45	130.63	130.67	3668920.0
2011-04-18 09:05:00	SPY	ETF	130.66	130.93	130.33	130.43	3788154.0
2011-04-18 09:10:00	SPY	ETF	130.43	130.75	130.41	130.71	2096680.0

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

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