PREVIEW / etf_5min / 2017-05-01

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-05-01.parquet
  size:    1.3 MB
  rows:    53,789

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-01 04:00:00	SPY	ETF	238.1	238.32	238.1	238.32	483.0
2017-05-01 04:05:00	SPY	ETF	238.3	238.34	238.3	238.34	517.0
2017-05-01 04:10:00	SPY	ETF	238.34	238.39	238.34	238.39	830.0
2017-05-01 04:20:00	SPY	ETF	238.39	238.42	238.39	238.42	1500.0
2017-05-01 04:35:00	SPY	ETF	238.42	238.42	238.42	238.42	500.0
2017-05-01 04:40:00	SPY	ETF	238.41	238.43	238.41	238.43	200.0
2017-05-01 04:50:00	SPY	ETF	238.37	238.37	238.37	238.37	200.0
2017-05-01 04:55:00	SPY	ETF	238.37	238.37	238.37	238.37	700.0
2017-05-01 05:05:00	SPY	ETF	238.37	238.37	238.37	238.37	500.0
2017-05-01 05:10:00	SPY	ETF	238.38	238.38	238.38	238.38	900.0
2017-05-01 05:15:00	SPY	ETF	238.41	238.41	238.41	238.41	200.0
2017-05-01 05:20:00	SPY	ETF	238.44	238.44	238.39	238.39	1300.0
2017-05-01 05:25:00	SPY	ETF	238.44	238.44	238.38	238.39	8641.0
2017-05-01 05:30:00	SPY	ETF	238.39	238.39	238.39	238.39	6900.0
2017-05-01 05:35:00	SPY	ETF	238.38	238.38	238.38	238.38	500.0
2017-05-01 05:40:00	SPY	ETF	238.39	238.42	238.39	238.42	1455.0
2017-05-01 05:45:00	SPY	ETF	238.43	238.44	238.43	238.44	5000.0
2017-05-01 06:00:00	SPY	ETF	238.44	238.47	238.44	238.47	2510.0
2017-05-01 06:05:00	SPY	ETF	238.47	238.5	238.47	238.5	3823.0
2017-05-01 06:15:00	SPY	ETF	238.56	238.56	238.56	238.56	1500.0
2017-05-01 06:20:00	SPY	ETF	238.55	238.56	238.55	238.56	6330.0
2017-05-01 06:25:00	SPY	ETF	238.56	238.56	238.56	238.56	100.0
2017-05-01 06:30:00	SPY	ETF	238.56	238.56	238.55	238.55	19791.0
2017-05-01 06:40:00	SPY	ETF	238.55	238.55	238.55	238.55	100.0
2017-05-01 06:45:00	SPY	ETF	238.56	238.56	238.56	238.56	250.0
2017-05-01 06:50:00	SPY	ETF	238.55	238.55	238.55	238.55	1200.0
2017-05-01 06:55:00	SPY	ETF	238.55	238.56	238.55	238.56	400.0
2017-05-01 07:00:00	SPY	ETF	238.55	238.56	238.55	238.56	6995.0
2017-05-01 07:05:00	SPY	ETF	238.55	238.55	238.55	238.55	900.0
2017-05-01 07:10:00	SPY	ETF	238.58	238.58	238.55	238.55	1700.0
2017-05-01 07:15:00	SPY	ETF	238.58	238.59	238.57	238.58	10150.0
2017-05-01 07:20:00	SPY	ETF	238.57	238.58	238.57	238.58	450.0
2017-05-01 07:30:00	SPY	ETF	238.58	238.6	238.58	238.58	3800.0
2017-05-01 07:35:00	SPY	ETF	238.6	238.6	238.6	238.6	209.0
2017-05-01 07:40:00	SPY	ETF	238.59	238.61	238.59	238.6	9122.0
2017-05-01 07:45:00	SPY	ETF	238.6	238.61	238.6	238.61	10150.0
2017-05-01 07:50:00	SPY	ETF	238.58	238.58	238.58	238.58	650.0
2017-05-01 07:55:00	SPY	ETF	238.57	238.6	238.55	238.6	25822.0
2017-05-01 08:00:00	SPY	ETF	238.6	238.69	238.55	238.68	55396.0
2017-05-01 08:05:00	SPY	ETF	238.68	238.72	238.66	238.68	28547.0
2017-05-01 08:10:00	SPY	ETF	238.68	238.85	238.68	238.83	88064.0
2017-05-01 08:15:00	SPY	ETF	238.82	238.83	238.78	238.8	31078.0
2017-05-01 08:20:00	SPY	ETF	238.74	238.8	238.74	238.78	31397.0
2017-05-01 08:25:00	SPY	ETF	238.79	238.83	238.76	238.78	64463.0
2017-05-01 08:30:00	SPY	ETF	238.73	238.73	238.71	238.72	8050.0
2017-05-01 08:35:00	SPY	ETF	238.72	238.76	238.71	238.73	24213.0
2017-05-01 08:40:00	SPY	ETF	238.71	238.73	238.7	238.73	4322.0
2017-05-01 08:45:00	SPY	ETF	238.74	238.75	238.71	238.74	19733.0
2017-05-01 08:50:00	SPY	ETF	238.73	238.73	238.65	238.65	5585.0
2017-05-01 08:55:00	SPY	ETF	238.65	238.69	238.65	238.67	15894.0

> showing 50 of 53,789 rows — these rows as CSV

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