PREVIEW / etf_5min / 2013-10-02

all etf 5-min files

  file:    by_date/etf_5min/2013/2013-10-02.parquet
  size:    960 KB
  rows:    40,670

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-10-02 04:00:00	SPY	ETF	168.65	168.65	168.15	168.3	25958.0
2013-10-02 04:05:00	SPY	ETF	168.32	168.37	168.27	168.27	50820.0
2013-10-02 04:10:00	SPY	ETF	168.27	168.41	168.27	168.32	16300.0
2013-10-02 04:15:00	SPY	ETF	168.3	168.3	168.27	168.27	900.0
2013-10-02 04:20:00	SPY	ETF	168.25	168.25	168.15	168.17	4600.0
2013-10-02 04:25:00	SPY	ETF	168.15	168.15	168.04	168.07	22345.0
2013-10-02 04:30:00	SPY	ETF	168.09	168.11	168.07	168.09	2000.0
2013-10-02 04:35:00	SPY	ETF	168.11	168.17	168.11	168.17	1400.0
2013-10-02 04:40:00	SPY	ETF	168.16	168.17	168.12	168.12	500.0
2013-10-02 04:45:00	SPY	ETF	168.11	168.13	168.11	168.13	400.0
2013-10-02 04:50:00	SPY	ETF	168.11	168.11	168.11	168.11	100.0
2013-10-02 04:55:00	SPY	ETF	168.12	168.19	168.12	168.19	1200.0
2013-10-02 05:00:00	SPY	ETF	168.17	168.23	168.17	168.22	7100.0
2013-10-02 05:05:00	SPY	ETF	168.27	168.29	168.27	168.29	400.0
2013-10-02 05:10:00	SPY	ETF	168.29	168.31	168.27	168.27	1100.0
2013-10-02 05:15:00	SPY	ETF	168.23	168.31	168.23	168.31	1331.0
2013-10-02 05:20:00	SPY	ETF	168.33	168.41	168.33	168.37	21100.0
2013-10-02 05:25:00	SPY	ETF	168.37	168.37	168.37	168.37	1500.0
2013-10-02 05:30:00	SPY	ETF	168.35	168.35	168.35	168.35	400.0
2013-10-02 05:35:00	SPY	ETF	168.35	168.41	168.35	168.41	1990.0
2013-10-02 05:40:00	SPY	ETF	168.43	168.48	168.43	168.48	2900.0
2013-10-02 05:45:00	SPY	ETF	168.45	168.45	168.42	168.43	999.0
2013-10-02 05:50:00	SPY	ETF	168.41	168.41	168.21	168.21	2100.0
2013-10-02 05:55:00	SPY	ETF	168.22	168.23	168.1	168.21	14900.0
2013-10-02 06:00:00	SPY	ETF	168.23	168.27	168.17	168.27	18200.0
2013-10-02 06:05:00	SPY	ETF	168.27	168.31	168.23	168.31	2100.0
2013-10-02 06:10:00	SPY	ETF	168.28	168.28	168.12	168.23	5928.0
2013-10-02 06:15:00	SPY	ETF	168.21	168.25	168.19	168.23	2600.0
2013-10-02 06:20:00	SPY	ETF	168.25	168.28	168.25	168.28	5300.0
2013-10-02 06:25:00	SPY	ETF	168.28	168.28	168.24	168.26	3900.0
2013-10-02 06:30:00	SPY	ETF	168.27	168.28	168.27	168.28	1200.0
2013-10-02 06:35:00	SPY	ETF	168.25	168.25	168.21	168.21	2200.0
2013-10-02 06:40:00	SPY	ETF	168.19	168.19	168.18	168.18	2900.0
2013-10-02 06:45:00	SPY	ETF	168.21	168.21	168.17	168.18	5300.0
2013-10-02 06:50:00	SPY	ETF	168.18	168.29	168.18	168.28	16441.0
2013-10-02 06:55:00	SPY	ETF	168.28	168.29	168.22	168.27	26100.0
2013-10-02 07:00:00	SPY	ETF	168.26	168.26	168.21	168.26	13300.0
2013-10-02 07:05:00	SPY	ETF	168.25	168.35	168.25	168.33	25100.0
2013-10-02 07:10:00	SPY	ETF	168.34	168.38	168.33	168.38	15602.0
2013-10-02 07:15:00	SPY	ETF	168.35	168.38	168.33	168.33	20300.0
2013-10-02 07:20:00	SPY	ETF	168.33	168.35	168.3	168.31	64107.0
2013-10-02 07:25:00	SPY	ETF	168.33	168.5	168.33	168.45	90071.0
2013-10-02 07:30:00	SPY	ETF	168.47	168.6	168.43	168.57	203595.0
2013-10-02 07:35:00	SPY	ETF	168.59	168.63	168.56	168.63	314315.0
2013-10-02 07:40:00	SPY	ETF	168.65	168.66	168.58	168.59	193067.0
2013-10-02 07:45:00	SPY	ETF	168.61	168.63	168.53	168.55	68758.0
2013-10-02 07:50:00	SPY	ETF	168.58	168.62	168.58	168.62	36700.0
2013-10-02 07:55:00	SPY	ETF	168.62	168.64	168.53	168.56	13332.0
2013-10-02 08:00:00	SPY	ETF	168.6186	168.95	168.21	168.54	459109.0
2013-10-02 08:05:00	SPY	ETF	168.52	168.6	168.52	168.56	127980.0

> showing 50 of 40,670 rows — these rows as CSV

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