PREVIEW / etf_5min / 2017-06-01

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-06-01.parquet
  size:    1.3 MB
  rows:    54,001

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-06-01 04:05:00	SPY	ETF	241.64	241.65	241.64	241.65	1360.0
2017-06-01 04:10:00	SPY	ETF	241.69	241.69	241.67	241.67	1753.0
2017-06-01 04:15:00	SPY	ETF	241.69	241.78	241.69	241.78	3200.0
2017-06-01 04:20:00	SPY	ETF	241.77	241.77	241.75	241.75	4200.0
2017-06-01 04:30:00	SPY	ETF	241.78	241.78	241.78	241.78	145.0
2017-06-01 04:35:00	SPY	ETF	241.74	241.74	241.74	241.74	300.0
2017-06-01 04:40:00	SPY	ETF	241.72	241.72	241.72	241.72	100.0
2017-06-01 04:45:00	SPY	ETF	241.72	241.77	241.72	241.77	3100.0
2017-06-01 04:50:00	SPY	ETF	241.77	241.77	241.75	241.75	1300.0
2017-06-01 05:00:00	SPY	ETF	241.74	241.74	241.69	241.72	5100.0
2017-06-01 05:05:00	SPY	ETF	241.69	241.75	241.69	241.72	3100.0
2017-06-01 05:10:00	SPY	ETF	241.67	241.67	241.67	241.67	500.0
2017-06-01 05:15:00	SPY	ETF	241.7	241.7	241.7	241.7	400.0
2017-06-01 05:20:00	SPY	ETF	241.69	241.69	241.67	241.67	2200.0
2017-06-01 05:25:00	SPY	ETF	241.68	241.71	241.66	241.71	2045.0
2017-06-01 05:30:00	SPY	ETF	241.7	241.7	241.7	241.7	400.0
2017-06-01 05:35:00	SPY	ETF	241.63	241.63	241.63	241.63	400.0
2017-06-01 05:40:00	SPY	ETF	241.6	241.6	241.6	241.6	300.0
2017-06-01 05:50:00	SPY	ETF	241.6	241.63	241.6	241.6	1200.0
2017-06-01 06:00:00	SPY	ETF	241.65	241.65	241.65	241.65	300.0
2017-06-01 06:15:00	SPY	ETF	241.59	241.59	241.57	241.57	510.0
2017-06-01 06:20:00	SPY	ETF	241.6	241.6	241.6	241.6	3210.0
2017-06-01 06:25:00	SPY	ETF	241.63	241.63	241.63	241.63	300.0
2017-06-01 06:30:00	SPY	ETF	241.64	241.64	241.64	241.64	300.0
2017-06-01 06:45:00	SPY	ETF	241.67	241.67	241.67	241.67	500.0
2017-06-01 06:50:00	SPY	ETF	241.65	241.65	241.65	241.65	500.0
2017-06-01 07:00:00	SPY	ETF	241.65	241.7	241.65	241.66	10800.0
2017-06-01 07:05:00	SPY	ETF	241.66	241.68	241.66	241.68	3369.0
2017-06-01 07:10:00	SPY	ETF	241.66	241.66	241.58	241.58	20202.0
2017-06-01 07:15:00	SPY	ETF	241.6	241.66	241.6	241.66	8307.0
2017-06-01 07:20:00	SPY	ETF	241.61	241.61	241.58	241.61	9367.0
2017-06-01 07:25:00	SPY	ETF	241.61	241.61	241.61	241.61	300.0
2017-06-01 07:30:00	SPY	ETF	241.61	241.61	241.6	241.61	806.0
2017-06-01 07:35:00	SPY	ETF	241.61	241.61	241.58	241.58	16188.0
2017-06-01 07:40:00	SPY	ETF	241.58	241.58	241.54	241.57	16745.0
2017-06-01 07:45:00	SPY	ETF	241.54	241.55	241.51	241.52	22434.0
2017-06-01 07:50:00	SPY	ETF	241.56	241.56	241.55	241.55	1500.0
2017-06-01 07:55:00	SPY	ETF	241.54	241.56	241.53	241.56	20043.0
2017-06-01 08:00:00	SPY	ETF	241.51	241.67	241.51	241.58	19228.0
2017-06-01 08:05:00	SPY	ETF	241.58	241.62	241.58	241.62	23728.0
2017-06-01 08:10:00	SPY	ETF	241.61	241.61	241.57	241.57	7569.0
2017-06-01 08:15:00	SPY	ETF	241.59	241.72	241.59	241.72	61425.0
2017-06-01 08:20:00	SPY	ETF	241.73	241.85	241.72	241.82	83881.0
2017-06-01 08:25:00	SPY	ETF	241.8	241.83	241.78	241.83	15358.0
2017-06-01 08:30:00	SPY	ETF	241.81	241.85	241.81	241.81	25431.0
2017-06-01 08:35:00	SPY	ETF	241.81	241.81	241.75	241.77	10222.0
2017-06-01 08:40:00	SPY	ETF	241.76	241.77	241.75	241.77	8355.0
2017-06-01 08:45:00	SPY	ETF	241.78	241.87	241.76	241.85	57321.0
2017-06-01 08:50:00	SPY	ETF	241.85	241.85	241.81	241.82	20486.0
2017-06-01 08:55:00	SPY	ETF	241.82	241.85	241.44	241.85	59113.0

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

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