PREVIEW / etf_5min / 2013-08-09

all etf 5-min files

  file:    by_date/etf_5min/2013/2013-08-09.parquet
  size:    914 KB
  rows:    39,047

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-08-09 04:00:00	SPY	ETF	169.85	169.85	169.64	169.64	1150.0
2013-08-09 04:05:00	SPY	ETF	169.65	169.65	169.61	169.61	2900.0
2013-08-09 04:15:00	SPY	ETF	169.57	169.57	169.56	169.56	400.0
2013-08-09 04:20:00	SPY	ETF	169.55	169.57	169.47	169.47	1250.0
2013-08-09 04:25:00	SPY	ETF	169.44	169.44	169.44	169.44	200.0
2013-08-09 04:30:00	SPY	ETF	169.41	169.41	169.35	169.38	2700.0
2013-08-09 04:35:00	SPY	ETF	169.4	169.4	169.4	169.4	5000.0
2013-08-09 04:40:00	SPY	ETF	169.41	169.44	169.41	169.44	300.0
2013-08-09 04:45:00	SPY	ETF	169.42	169.42	169.41	169.41	500.0
2013-08-09 04:50:00	SPY	ETF	169.42	169.42	169.38	169.41	1400.0
2013-08-09 04:55:00	SPY	ETF	169.42	169.42	169.42	169.42	100.0
2013-08-09 05:05:00	SPY	ETF	169.44	169.47	169.44	169.47	400.0
2013-08-09 05:10:00	SPY	ETF	169.49	169.49	169.46	169.46	15500.0
2013-08-09 05:15:00	SPY	ETF	169.47	169.47	169.4	169.4	8100.0
2013-08-09 05:20:00	SPY	ETF	169.4	169.4	169.4	169.4	7000.0
2013-08-09 05:45:00	SPY	ETF	169.41	169.41	169.4	169.4	300.0
2013-08-09 05:50:00	SPY	ETF	169.41	169.41	169.4	169.4	295.0
2013-08-09 05:55:00	SPY	ETF	169.41	169.41	169.35	169.35	505.0
2013-08-09 06:00:00	SPY	ETF	169.32	169.32	169.22	169.22	1100.0
2013-08-09 06:05:00	SPY	ETF	169.21	169.22	169.16	169.19	1350.0
2013-08-09 06:10:00	SPY	ETF	169.2	169.2	169.13	169.13	1673.0
2013-08-09 06:15:00	SPY	ETF	169.13	169.13	169.13	169.13	500.0
2013-08-09 06:20:00	SPY	ETF	169.15	169.2	169.15	169.2	1000.0
2013-08-09 06:25:00	SPY	ETF	169.2	169.21	169.2	169.21	300.0
2013-08-09 06:30:00	SPY	ETF	169.21	169.25	169.21	169.25	800.0
2013-08-09 06:35:00	SPY	ETF	169.24	169.25	169.24	169.24	2600.0
2013-08-09 06:40:00	SPY	ETF	169.22	169.22	169.14	169.14	7100.0
2013-08-09 06:45:00	SPY	ETF	169.16	169.2	169.14	169.2	1200.0
2013-08-09 06:50:00	SPY	ETF	169.22	169.23	169.22	169.23	500.0
2013-08-09 06:55:00	SPY	ETF	169.21	169.26	169.21	169.26	900.0
2013-08-09 07:00:00	SPY	ETF	169.27	169.29	169.26	169.28	10795.0
2013-08-09 07:05:00	SPY	ETF	169.28	169.28	169.24	169.25	15705.0
2013-08-09 07:10:00	SPY	ETF	169.24	169.25	169.24	169.25	420.0
2013-08-09 07:15:00	SPY	ETF	169.28	169.31	169.27	169.31	26900.0
2013-08-09 07:20:00	SPY	ETF	169.32	169.33	169.3	169.32	1398.0
2013-08-09 07:25:00	SPY	ETF	169.32	169.33	169.31	169.33	700.0
2013-08-09 07:30:00	SPY	ETF	169.31	169.35	169.31	169.35	1497.0
2013-08-09 07:35:00	SPY	ETF	169.32	169.35	169.31	169.35	6200.0
2013-08-09 07:40:00	SPY	ETF	169.33	169.35	169.33	169.35	21950.0
2013-08-09 07:45:00	SPY	ETF	169.35	169.36	169.35	169.35	17400.0
2013-08-09 07:55:00	SPY	ETF	169.37	169.44	169.37	169.41	5898.0
2013-08-09 08:00:00	SPY	ETF	169.31	169.48	169.24	169.45	33832.0
2013-08-09 08:05:00	SPY	ETF	169.45	169.46	169.45	169.45	7690.0
2013-08-09 08:10:00	SPY	ETF	169.45	169.45	169.43	169.43	21660.0
2013-08-09 08:15:00	SPY	ETF	169.42	169.45	169.41	169.45	121800.0
2013-08-09 08:20:00	SPY	ETF	169.45	169.46	169.43	169.43	6070.0
2013-08-09 08:25:00	SPY	ETF	169.42	169.44	169.4	169.44	86800.0
2013-08-09 08:30:00	SPY	ETF	169.45	169.47	169.44	169.44	26100.0
2013-08-09 08:35:00	SPY	ETF	169.45	169.45	169.42	169.45	27431.0
2013-08-09 08:40:00	SPY	ETF	169.425	169.425	169.32	169.33	99344.0

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

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