PREVIEW / etf_5min / 2017-09-19

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-09-19.parquet
  size:    1.2 MB
  rows:    52,196

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-09-19 04:00:00	SPY	ETF	249.74	249.75	249.74	249.75	1430.0
2017-09-19 04:10:00	SPY	ETF	249.71	249.71	249.71	249.71	100.0
2017-09-19 04:15:00	SPY	ETF	249.72	249.72	249.72	249.72	300.0
2017-09-19 04:20:00	SPY	ETF	249.77	249.77	249.77	249.77	500.0
2017-09-19 04:55:00	SPY	ETF	249.77	249.77	249.77	249.77	300.0
2017-09-19 05:30:00	SPY	ETF	249.86	249.86	249.86	249.86	100.0
2017-09-19 05:40:00	SPY	ETF	249.9	249.9	249.9	249.9	224.0
2017-09-19 05:45:00	SPY	ETF	249.94	249.94	249.94	249.94	100.0
2017-09-19 05:50:00	SPY	ETF	249.95	249.95	249.95	249.95	200.0
2017-09-19 05:55:00	SPY	ETF	249.99	249.99	249.96	249.96	3243.0
2017-09-19 06:00:00	SPY	ETF	249.99	249.99	249.99	249.99	300.0
2017-09-19 06:05:00	SPY	ETF	250.0	250.0	250.0	250.0	128.0
2017-09-19 06:10:00	SPY	ETF	249.99	249.99	249.96	249.96	548.0
2017-09-19 06:25:00	SPY	ETF	249.94	249.94	249.94	249.94	4000.0
2017-09-19 06:30:00	SPY	ETF	249.94	249.94	249.94	249.94	302.0
2017-09-19 06:35:00	SPY	ETF	249.93	249.93	249.91	249.91	2800.0
2017-09-19 06:40:00	SPY	ETF	249.92	249.93	249.92	249.93	2500.0
2017-09-19 06:45:00	SPY	ETF	249.94	249.94	249.94	249.94	100.0
2017-09-19 06:50:00	SPY	ETF	249.95	249.96	249.95	249.96	17101.0
2017-09-19 06:55:00	SPY	ETF	249.96	249.98	249.96	249.98	7203.0
2017-09-19 07:00:00	SPY	ETF	249.96	249.96	249.91	249.91	1616.0
2017-09-19 07:05:00	SPY	ETF	249.9	249.93	249.9	249.93	10385.0
2017-09-19 07:10:00	SPY	ETF	249.94	249.96	249.94	249.94	14073.0
2017-09-19 07:15:00	SPY	ETF	249.91	249.93	249.91	249.93	600.0
2017-09-19 07:20:00	SPY	ETF	249.92	249.92	249.91	249.91	400.0
2017-09-19 07:25:00	SPY	ETF	249.94	249.99	249.92	249.92	20818.0
2017-09-19 07:30:00	SPY	ETF	249.92	249.92	249.91	249.92	2828.0
2017-09-19 07:35:00	SPY	ETF	249.9	249.91	249.9	249.91	4301.0
2017-09-19 07:45:00	SPY	ETF	249.91	249.91	249.91	249.91	210.0
2017-09-19 07:50:00	SPY	ETF	249.91	249.96	249.91	249.96	742.0
2017-09-19 07:55:00	SPY	ETF	249.96	249.96	249.9	249.9	2652.0
2017-09-19 08:00:00	SPY	ETF	249.92	249.96	249.92	249.94	3466.0
2017-09-19 08:05:00	SPY	ETF	249.92	249.96	249.92	249.93	3702.0
2017-09-19 08:10:00	SPY	ETF	249.95	249.96	249.92	249.92	1877.0
2017-09-19 08:15:00	SPY	ETF	249.92	249.92	249.92	249.92	700.0
2017-09-19 08:20:00	SPY	ETF	249.93	249.96	249.93	249.95	4001.0
2017-09-19 08:25:00	SPY	ETF	249.93	249.96	249.93	249.95	5953.0
2017-09-19 08:30:00	SPY	ETF	249.96	249.96	249.94	249.94	2101.0
2017-09-19 08:35:00	SPY	ETF	249.92	249.92	249.92	249.92	1450.0
2017-09-19 08:40:00	SPY	ETF	249.91	249.91	249.91	249.91	989.0
2017-09-19 08:45:00	SPY	ETF	249.9	249.91	249.89	249.91	4460.0
2017-09-19 08:50:00	SPY	ETF	249.94	249.94	249.9	249.91	2835.0
2017-09-19 08:55:00	SPY	ETF	249.9	249.91	249.88	249.91	24554.0
2017-09-19 09:00:00	SPY	ETF	249.89	249.93	249.89	249.93	23734.0
2017-09-19 09:05:00	SPY	ETF	249.92	249.96	249.92	249.94	22122.0
2017-09-19 09:10:00	SPY	ETF	249.94	249.96	249.93	249.94	12213.0
2017-09-19 09:15:00	SPY	ETF	249.93	249.93	249.93	249.93	1194.0
2017-09-19 09:20:00	SPY	ETF	249.94	249.99	249.92	249.99	27025.0
2017-09-19 09:25:00	SPY	ETF	249.99	250.0	249.98	249.98	29138.0
2017-09-19 09:30:00	SPY	ETF	250.0	250.02	249.9	249.96	992286.0

> showing 50 of 52,196 rows — these rows as CSV

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