PREVIEW / etf_5min / 2013-09-25

all etf 5-min files

  file:    by_date/etf_5min/2013/2013-09-25.parquet
  size:    935 KB
  rows:    39,954

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-25 04:00:00	SPY	ETF	169.33	169.33	169.13	169.13	3400.0
2013-09-25 04:05:00	SPY	ETF	169.16	169.16	169.16	169.16	1000.0
2013-09-25 04:20:00	SPY	ETF	169.27	169.27	169.27	169.27	100.0
2013-09-25 04:30:00	SPY	ETF	169.26	169.26	169.24	169.26	2000.0
2013-09-25 04:35:00	SPY	ETF	169.31	169.37	169.31	169.37	1500.0
2013-09-25 04:40:00	SPY	ETF	169.4	169.52	169.4	169.52	1400.0
2013-09-25 04:45:00	SPY	ETF	169.55	169.55	169.52	169.52	200.0
2013-09-25 04:50:00	SPY	ETF	169.49	169.49	169.49	169.49	300.0
2013-09-25 04:55:00	SPY	ETF	169.52	169.52	169.51	169.51	1060.0
2013-09-25 05:05:00	SPY	ETF	169.55	169.55	169.55	169.55	300.0
2013-09-25 05:10:00	SPY	ETF	169.55	169.61	169.55	169.61	900.0
2013-09-25 05:15:00	SPY	ETF	169.64	169.64	169.64	169.64	300.0
2013-09-25 05:20:00	SPY	ETF	169.64	169.7	169.64	169.67	1300.0
2013-09-25 05:30:00	SPY	ETF	169.7	169.7	169.67	169.67	1100.0
2013-09-25 05:35:00	SPY	ETF	169.66	169.66	169.66	169.66	100.0
2013-09-25 05:40:00	SPY	ETF	169.7	169.73	169.7	169.73	700.0
2013-09-25 05:45:00	SPY	ETF	169.75	169.75	169.75	169.75	500.0
2013-09-25 05:50:00	SPY	ETF	169.7	169.7	169.67	169.67	700.0
2013-09-25 06:05:00	SPY	ETF	169.61	169.61	169.58	169.58	1300.0
2013-09-25 06:10:00	SPY	ETF	169.55	169.55	169.46	169.46	2200.0
2013-09-25 06:15:00	SPY	ETF	169.46	169.46	169.46	169.46	200.0
2013-09-25 06:20:00	SPY	ETF	169.49	169.49	169.49	169.49	300.0
2013-09-25 06:25:00	SPY	ETF	169.51	169.51	169.51	169.51	200.0
2013-09-25 06:30:00	SPY	ETF	169.5	169.5	169.47	169.5	10100.0
2013-09-25 06:35:00	SPY	ETF	169.5	169.5	169.4	169.4	11100.0
2013-09-25 06:40:00	SPY	ETF	169.38	169.38	169.33	169.37	2700.0
2013-09-25 06:45:00	SPY	ETF	169.4	169.4	169.4	169.4	200.0
2013-09-25 06:50:00	SPY	ETF	169.37	169.37	169.36	169.36	500.0
2013-09-25 06:55:00	SPY	ETF	169.38	169.39	169.36	169.38	13900.0
2013-09-25 07:00:00	SPY	ETF	169.37	169.37	169.31	169.32	3895.0
2013-09-25 07:05:00	SPY	ETF	169.3	169.3	169.28	169.3	22351.0
2013-09-25 07:10:00	SPY	ETF	169.3	169.31	169.29	169.31	700.0
2013-09-25 07:15:00	SPY	ETF	169.32	169.37	169.32	169.37	5325.0
2013-09-25 07:20:00	SPY	ETF	169.37	169.37	169.35	169.36	9000.0
2013-09-25 07:25:00	SPY	ETF	169.36	169.36	169.33	169.34	2255.0
2013-09-25 07:30:00	SPY	ETF	169.37	169.37	169.32	169.37	6900.0
2013-09-25 07:35:00	SPY	ETF	169.37	169.4	169.34	169.4	27021.0
2013-09-25 07:40:00	SPY	ETF	169.4	169.44	169.4	169.44	1500.0
2013-09-25 07:45:00	SPY	ETF	169.42	169.42	169.33	169.33	82342.0
2013-09-25 07:50:00	SPY	ETF	169.35	169.37	169.33	169.37	25500.0
2013-09-25 07:55:00	SPY	ETF	169.39	169.49	169.33	169.49	36200.0
2013-09-25 08:00:00	SPY	ETF	169.35	169.52	169.35	169.42	83466.0
2013-09-25 08:05:00	SPY	ETF	169.42	169.43	169.4	169.41	16450.0
2013-09-25 08:10:00	SPY	ETF	169.41	169.49	169.41	169.49	3900.0
2013-09-25 08:15:00	SPY	ETF	169.5	169.5	169.44	169.47	8274.0
2013-09-25 08:20:00	SPY	ETF	169.47	169.47	169.41	169.41	6400.0
2013-09-25 08:25:00	SPY	ETF	169.42	169.45	169.4	169.43	1746.0
2013-09-25 08:30:00	SPY	ETF	169.41	169.51	169.37	169.5	143397.0
2013-09-25 08:35:00	SPY	ETF	169.5	169.5	169.43	169.5	50364.0
2013-09-25 08:40:00	SPY	ETF	169.5	169.63	169.49	169.63	76865.0

> showing 50 of 39,954 rows — these rows as CSV

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