PREVIEW / etf_5min / 2012-03-13

all etf 5-min files

  file:    by_date/etf_5min/2012/2012-03-13.parquet
  size:    929 KB
  rows:    38,325

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-03-13 04:00:00	SPY	ETF	138.03	138.03	138.03	138.03	700.0
2012-03-13 04:05:00	SPY	ETF	138.11	138.27	138.11	138.27	748.0
2012-03-13 04:20:00	SPY	ETF	138.29	138.3	138.26	138.26	10500.0
2012-03-13 04:25:00	SPY	ETF	138.34	138.34	138.34	138.34	100.0
2012-03-13 04:30:00	SPY	ETF	138.35	138.35	138.35	138.35	688.0
2012-03-13 04:40:00	SPY	ETF	138.27	138.27	138.27	138.27	100.0
2012-03-13 04:45:00	SPY	ETF	138.26	138.26	138.26	138.26	300.0
2012-03-13 05:00:00	SPY	ETF	138.3	138.36	138.3	138.36	3700.0
2012-03-13 05:10:00	SPY	ETF	138.38	138.38	138.38	138.38	300.0
2012-03-13 05:15:00	SPY	ETF	138.37	138.37	138.37	138.37	662.0
2012-03-13 05:25:00	SPY	ETF	138.4	138.4	138.4	138.4	662.0
2012-03-13 05:35:00	SPY	ETF	138.4	138.4	138.4	138.4	2338.0
2012-03-13 05:40:00	SPY	ETF	138.45	138.45	138.45	138.45	500.0
2012-03-13 05:45:00	SPY	ETF	138.46	138.49	138.46	138.49	5400.0
2012-03-13 05:50:00	SPY	ETF	138.47	138.47	138.47	138.47	5000.0
2012-03-13 05:55:00	SPY	ETF	138.49	138.55	138.49	138.55	2215.0
2012-03-13 06:00:00	SPY	ETF	138.58	138.58	138.54	138.54	1800.0
2012-03-13 06:05:00	SPY	ETF	138.57	138.6	138.57	138.57	1350.0
2012-03-13 06:10:00	SPY	ETF	138.55	138.55	138.55	138.55	600.0
2012-03-13 06:15:00	SPY	ETF	138.52	138.52	138.5	138.5	400.0
2012-03-13 06:25:00	SPY	ETF	138.52	138.52	138.52	138.52	1700.0
2012-03-13 06:35:00	SPY	ETF	138.52	138.56	138.52	138.54	4700.0
2012-03-13 06:40:00	SPY	ETF	138.54	138.55	138.51	138.51	8500.0
2012-03-13 06:45:00	SPY	ETF	138.57	138.57	138.54	138.54	1200.0
2012-03-13 06:50:00	SPY	ETF	138.54	138.55	138.49	138.55	14350.0
2012-03-13 06:55:00	SPY	ETF	138.54	138.55	138.54	138.54	26600.0
2012-03-13 07:00:00	SPY	ETF	138.55	138.55	138.48	138.5	7600.0
2012-03-13 07:05:00	SPY	ETF	138.48	138.48	138.46	138.48	1900.0
2012-03-13 07:10:00	SPY	ETF	138.5	138.52	138.46	138.52	8000.0
2012-03-13 07:15:00	SPY	ETF	138.54	138.55	138.52	138.55	40400.0
2012-03-13 07:20:00	SPY	ETF	138.49	138.49	138.47	138.47	35700.0
2012-03-13 07:25:00	SPY	ETF	138.49	138.49	138.44	138.47	6062.0
2012-03-13 07:30:00	SPY	ETF	138.48	138.55	138.48	138.53	17800.0
2012-03-13 07:35:00	SPY	ETF	138.53	138.58	138.52	138.52	18025.0
2012-03-13 07:40:00	SPY	ETF	138.54	138.56	138.49	138.49	17702.0
2012-03-13 07:45:00	SPY	ETF	138.5	138.5	138.46	138.46	36575.0
2012-03-13 07:50:00	SPY	ETF	138.46	138.48	138.45	138.47	10950.0
2012-03-13 07:55:00	SPY	ETF	138.48	138.48	138.42	138.45	12154.0
2012-03-13 08:00:00	SPY	ETF	138.42	138.52	138.39	138.42	53305.0
2012-03-13 08:05:00	SPY	ETF	138.41	138.43	138.39	138.43	23550.0
2012-03-13 08:10:00	SPY	ETF	138.42	138.43	138.39	138.42	18450.0
2012-03-13 08:15:00	SPY	ETF	138.4	138.6385	138.4	138.45	76456.0
2012-03-13 08:20:00	SPY	ETF	138.44	138.45	138.41	138.43	37250.0
2012-03-13 08:25:00	SPY	ETF	138.42	138.43	138.4	138.42	54236.0
2012-03-13 08:30:00	SPY	ETF	138.43	138.49	138.37	138.45	207427.0
2012-03-13 08:35:00	SPY	ETF	138.46	138.47	138.395	138.44	169680.0
2012-03-13 08:40:00	SPY	ETF	138.45	138.48	138.34	138.4	203792.0
2012-03-13 08:45:00	SPY	ETF	138.4	138.43	138.33	138.33	122820.0
2012-03-13 08:50:00	SPY	ETF	138.34	138.35	138.28	138.29	169344.0
2012-03-13 08:55:00	SPY	ETF	138.29	138.3	138.23	138.27	139065.0

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

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