PREVIEW / etf_5min / 2013-09-09

all etf 5-min files

  file:    by_date/etf_5min/2013/2013-09-09.parquet
  size:    1000 KB
  rows:    41,680

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-09 04:00:00	SPY	ETF	166.15	166.44	166.15	166.41	900.0
2013-09-09 04:05:00	SPY	ETF	166.41	166.44	166.41	166.44	6600.0
2013-09-09 04:10:00	SPY	ETF	166.42	166.52	166.42	166.52	2400.0
2013-09-09 04:15:00	SPY	ETF	166.5	166.5	166.46	166.48	2100.0
2013-09-09 04:20:00	SPY	ETF	166.52	166.52	166.52	166.52	700.0
2013-09-09 04:25:00	SPY	ETF	166.5	166.5	166.45	166.45	1500.0
2013-09-09 04:30:00	SPY	ETF	166.47	166.48	166.47	166.48	800.0
2013-09-09 04:35:00	SPY	ETF	166.46	166.46	166.46	166.46	700.0
2013-09-09 04:40:00	SPY	ETF	166.44	166.44	166.44	166.44	20000.0
2013-09-09 04:45:00	SPY	ETF	166.43	166.43	166.41	166.41	40800.0
2013-09-09 04:50:00	SPY	ETF	166.38	166.38	166.35	166.35	800.0
2013-09-09 04:55:00	SPY	ETF	166.4	166.52	166.4	166.51	2700.0
2013-09-09 05:00:00	SPY	ETF	166.46	166.46	166.46	166.46	700.0
2013-09-09 05:05:00	SPY	ETF	166.42	166.42	166.34	166.39	3200.0
2013-09-09 05:10:00	SPY	ETF	166.4	166.4	166.38	166.38	1900.0
2013-09-09 05:20:00	SPY	ETF	166.4	166.4	166.4	166.4	700.0
2013-09-09 05:25:00	SPY	ETF	166.38	166.38	166.34	166.34	1400.0
2013-09-09 05:30:00	SPY	ETF	166.35	166.35	166.35	166.35	5000.0
2013-09-09 05:35:00	SPY	ETF	166.35	166.35	166.35	166.35	100.0
2013-09-09 05:40:00	SPY	ETF	166.3	166.3	166.3	166.3	700.0
2013-09-09 05:45:00	SPY	ETF	166.27	166.27	166.27	166.27	100.0
2013-09-09 05:50:00	SPY	ETF	166.27	166.27	166.27	166.27	200.0
2013-09-09 06:00:00	SPY	ETF	166.26	166.28	166.26	166.28	1400.0
2013-09-09 06:05:00	SPY	ETF	166.28	166.28	166.28	166.28	300.0
2013-09-09 06:20:00	SPY	ETF	166.29	166.32	166.29	166.32	900.0
2013-09-09 06:25:00	SPY	ETF	166.36	166.37	166.36	166.37	1200.0
2013-09-09 06:30:00	SPY	ETF	166.4	166.43	166.4	166.43	7100.0
2013-09-09 06:35:00	SPY	ETF	166.44	166.5	166.42	166.42	7100.0
2013-09-09 06:40:00	SPY	ETF	166.38	166.38	166.37	166.38	1400.0
2013-09-09 06:50:00	SPY	ETF	166.4	166.41	166.4	166.41	1300.0
2013-09-09 06:55:00	SPY	ETF	166.38	166.38	166.26	166.26	3100.0
2013-09-09 07:00:00	SPY	ETF	166.24	166.28	166.2	166.26	24300.0
2013-09-09 07:05:00	SPY	ETF	166.25	166.3	166.22	166.3	6800.0
2013-09-09 07:10:00	SPY	ETF	166.3	166.35	166.3	166.35	15594.0
2013-09-09 07:15:00	SPY	ETF	166.3	166.33	166.3	166.33	2100.0
2013-09-09 07:20:00	SPY	ETF	166.33	166.37	166.31	166.37	13521.0
2013-09-09 07:25:00	SPY	ETF	166.37	166.42	166.37	166.41	36222.0
2013-09-09 07:30:00	SPY	ETF	166.42	166.44	166.32	166.32	16900.0
2013-09-09 07:35:00	SPY	ETF	166.32	166.36	166.32	166.36	790.0
2013-09-09 07:40:00	SPY	ETF	166.34	166.35	166.32	166.35	5700.0
2013-09-09 07:45:00	SPY	ETF	166.32	166.35	166.32	166.32	31550.0
2013-09-09 07:50:00	SPY	ETF	166.31	166.32	166.31	166.32	400.0
2013-09-09 07:55:00	SPY	ETF	166.32	166.32	166.28	166.29	10750.0
2013-09-09 08:00:00	SPY	ETF	166.32	166.38	166.29	166.38	18300.0
2013-09-09 08:05:00	SPY	ETF	166.38	166.4	166.36	166.4	29606.0
2013-09-09 08:10:00	SPY	ETF	166.39	166.39	166.3	166.31	226814.0
2013-09-09 08:15:00	SPY	ETF	166.3	166.33	166.29	166.32	64775.0
2013-09-09 08:20:00	SPY	ETF	166.32	166.33	166.3	166.31	59570.0
2013-09-09 08:25:00	SPY	ETF	166.3	166.34	166.3	166.34	22215.0
2013-09-09 08:30:00	SPY	ETF	166.34	166.35	166.28	166.28	97917.0

> showing 50 of 41,680 rows — these rows as CSV

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