PREVIEW / etf_5min / 2017-05-02

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-05-02.parquet
  size:    1.3 MB
  rows:    54,603

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
2017-05-02 04:10:00	SPY	ETF	238.5	238.5	238.5	238.5	300.0
2017-05-02 04:20:00	SPY	ETF	238.62	238.62	238.62	238.62	304.0
2017-05-02 04:25:00	SPY	ETF	238.56	238.56	238.56	238.56	100.0
2017-05-02 04:30:00	SPY	ETF	238.58	238.58	238.58	238.58	400.0
2017-05-02 04:45:00	SPY	ETF	238.56	238.58	238.56	238.58	600.0
2017-05-02 04:55:00	SPY	ETF	238.56	238.56	238.51	238.51	301.0
2017-05-02 05:00:00	SPY	ETF	238.56	238.56	238.56	238.56	400.0
2017-05-02 05:05:00	SPY	ETF	238.56	238.58	238.56	238.58	800.0
2017-05-02 05:10:00	SPY	ETF	238.6	238.6	238.54	238.54	800.0
2017-05-02 05:15:00	SPY	ETF	238.58	238.58	238.58	238.58	200.0
2017-05-02 05:25:00	SPY	ETF	238.63	238.63	238.62	238.62	200.0
2017-05-02 05:30:00	SPY	ETF	238.66	238.68	238.66	238.68	5175.0
2017-05-02 05:40:00	SPY	ETF	238.68	238.71	238.68	238.71	950.0
2017-05-02 05:45:00	SPY	ETF	238.68	238.7	238.68	238.68	500.0
2017-05-02 05:50:00	SPY	ETF	238.66	238.75	238.66	238.74	1400.0
2017-05-02 05:55:00	SPY	ETF	238.71	238.71	238.71	238.71	200.0
2017-05-02 06:00:00	SPY	ETF	238.74	238.74	238.74	238.74	200.0
2017-05-02 06:15:00	SPY	ETF	238.66	238.66	238.66	238.66	100.0
2017-05-02 06:20:00	SPY	ETF	238.6	238.6	238.54	238.54	500.0
2017-05-02 06:30:00	SPY	ETF	238.58	238.58	238.58	238.58	1000.0
2017-05-02 06:35:00	SPY	ETF	238.6	238.6	238.6	238.6	4000.0
2017-05-02 06:40:00	SPY	ETF	238.61	238.61	238.61	238.61	300.0
2017-05-02 06:45:00	SPY	ETF	238.6	238.61	238.58	238.61	37600.0
2017-05-02 06:50:00	SPY	ETF	238.61	238.61	238.6	238.6	500.0
2017-05-02 06:55:00	SPY	ETF	238.6	238.64	238.6	238.63	18300.0
2017-05-02 07:00:00	SPY	ETF	238.63	238.63	238.6	238.6	6000.0
2017-05-02 07:05:00	SPY	ETF	238.6	238.66	238.6	238.66	3200.0
2017-05-02 07:10:00	SPY	ETF	238.66	238.66	238.66	238.66	300.0
2017-05-02 07:15:00	SPY	ETF	238.65	238.66	238.62	238.66	7100.0
2017-05-02 07:25:00	SPY	ETF	238.63	238.63	238.63	238.63	800.0
2017-05-02 07:30:00	SPY	ETF	238.63	238.64	238.63	238.64	20100.0
2017-05-02 07:35:00	SPY	ETF	238.61	238.61	238.61	238.61	2100.0
2017-05-02 07:40:00	SPY	ETF	238.6	238.61	238.6	238.61	3254.0
2017-05-02 07:45:00	SPY	ETF	238.66	238.66	238.66	238.66	500.0
2017-05-02 07:50:00	SPY	ETF	238.63	238.67	238.63	238.67	42800.0
2017-05-02 07:55:00	SPY	ETF	238.67	238.69	238.66	238.66	2001.0
2017-05-02 08:00:00	SPY	ETF	238.68	238.72	238.6	238.65	208553.0
2017-05-02 08:05:00	SPY	ETF	238.69	238.69	238.68	238.68	1203.0
2017-05-02 08:10:00	SPY	ETF	238.69	238.69	238.67	238.67	3210.0
2017-05-02 08:15:00	SPY	ETF	238.68	238.69	238.65	238.69	3800.0
2017-05-02 08:20:00	SPY	ETF	238.71	238.76	238.71	238.75	23780.0
2017-05-02 08:25:00	SPY	ETF	238.77	238.81	238.77	238.78	43976.0
2017-05-02 08:30:00	SPY	ETF	238.78	238.78	238.71	238.74	5759.0
2017-05-02 08:35:00	SPY	ETF	238.74	238.76	238.71	238.74	4105.0
2017-05-02 08:40:00	SPY	ETF	238.74	238.78	238.73	238.78	11364.0
2017-05-02 08:45:00	SPY	ETF	238.77	238.78	238.77	238.78	300.0
2017-05-02 08:50:00	SPY	ETF	238.78	238.79	238.76	238.79	5042.0
2017-05-02 08:55:00	SPY	ETF	238.76	238.81	238.76	238.79	4862.0
2017-05-02 09:00:00	SPY	ETF	238.79	238.79	238.78	238.79	9094.0
2017-05-02 09:05:00	SPY	ETF	238.79	238.8	238.74	238.79	140769.0

> showing 50 of 54,603 rows — these rows as CSV

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