PREVIEW / etf_5min / 2017-09-28

all etf 5-min files

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

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-28 04:00:00	SPY	ETF	249.91	249.91	249.91	249.91	25000.0
2017-09-28 04:05:00	SPY	ETF	249.91	249.91	249.91	249.91	425.0
2017-09-28 04:10:00	SPY	ETF	249.92	249.92	249.9	249.9	1100.0
2017-09-28 04:20:00	SPY	ETF	249.9	249.9	249.9	249.9	600.0
2017-09-28 04:25:00	SPY	ETF	249.92	249.92	249.91	249.91	3825.0
2017-09-28 04:30:00	SPY	ETF	249.91	249.91	249.84	249.84	40075.0
2017-09-28 04:35:00	SPY	ETF	249.98	249.98	249.97	249.97	449.0
2017-09-28 04:40:00	SPY	ETF	249.92	249.92	249.9	249.9	4800.0
2017-09-28 04:50:00	SPY	ETF	249.93	250.01	249.93	249.97	4500.0
2017-09-28 04:55:00	SPY	ETF	250.03	250.03	249.99	249.99	1500.0
2017-09-28 05:00:00	SPY	ETF	249.96	249.96	249.96	249.96	500.0
2017-09-28 05:10:00	SPY	ETF	250.01	250.01	250.01	250.01	303.0
2017-09-28 05:20:00	SPY	ETF	249.91	249.91	249.87	249.87	403.0
2017-09-28 05:35:00	SPY	ETF	250.04	250.04	250.04	250.04	1005.0
2017-09-28 05:40:00	SPY	ETF	249.97	249.97	249.97	249.97	700.0
2017-09-28 05:45:00	SPY	ETF	249.97	250.0	249.97	250.0	900.0
2017-09-28 06:00:00	SPY	ETF	249.95	249.95	249.95	249.95	400.0
2017-09-28 06:20:00	SPY	ETF	249.95	249.95	249.95	249.95	300.0
2017-09-28 06:25:00	SPY	ETF	249.95	249.95	249.95	249.95	402.0
2017-09-28 06:35:00	SPY	ETF	249.96	249.96	249.96	249.96	200.0
2017-09-28 06:50:00	SPY	ETF	249.95	249.95	249.9	249.9	923.0
2017-09-28 06:55:00	SPY	ETF	249.9	249.9	249.87	249.87	901.0
2017-09-28 07:00:00	SPY	ETF	249.89	249.89	249.85	249.85	3801.0
2017-09-28 07:05:00	SPY	ETF	249.86	249.86	249.86	249.86	900.0
2017-09-28 07:10:00	SPY	ETF	249.86	249.91	249.86	249.91	1665.0
2017-09-28 07:15:00	SPY	ETF	249.91	249.91	249.91	249.91	3802.0
2017-09-28 07:20:00	SPY	ETF	249.86	249.87	249.85	249.87	32302.0
2017-09-28 07:25:00	SPY	ETF	249.86	249.86	249.85	249.85	13400.0
2017-09-28 07:30:00	SPY	ETF	249.87	249.87	249.85	249.85	802.0
2017-09-28 07:35:00	SPY	ETF	249.87	249.91	249.87	249.91	40201.0
2017-09-28 07:40:00	SPY	ETF	249.88	249.88	249.88	249.88	5001.0
2017-09-28 07:45:00	SPY	ETF	249.85	249.86	249.68	249.73	32795.0
2017-09-28 07:50:00	SPY	ETF	249.71	249.74	249.68	249.68	37355.0
2017-09-28 07:55:00	SPY	ETF	249.69	249.69	249.58	249.65	31365.0
2017-09-28 08:00:00	SPY	ETF	250.05	250.05	249.59	249.59	23676.0
2017-09-28 08:05:00	SPY	ETF	249.58	249.63	249.55	249.61	28721.0
2017-09-28 08:10:00	SPY	ETF	249.6	249.61	249.52	249.52	19675.0
2017-09-28 08:15:00	SPY	ETF	249.55	249.6	249.54	249.59	13875.0
2017-09-28 08:20:00	SPY	ETF	249.55	249.57	249.52	249.56	12460.0
2017-09-28 08:25:00	SPY	ETF	249.56	249.57	249.53	249.57	2611.0
2017-09-28 08:30:00	SPY	ETF	249.56	249.63	249.54	249.61	24392.0
2017-09-28 08:35:00	SPY	ETF	249.63	249.65	249.63	249.64	10163.0
2017-09-28 08:40:00	SPY	ETF	249.65	249.68	249.65	249.67	37010.0
2017-09-28 08:45:00	SPY	ETF	249.67	249.67	249.58	249.58	34833.0
2017-09-28 08:50:00	SPY	ETF	249.57	249.63	249.57	249.63	15810.0
2017-09-28 08:55:00	SPY	ETF	249.65	249.69	249.65	249.69	67712.0
2017-09-28 09:00:00	SPY	ETF	249.68	249.68	249.61	249.63	45136.0
2017-09-28 09:05:00	SPY	ETF	249.64	249.66	249.63	249.66	21969.0
2017-09-28 09:10:00	SPY	ETF	249.66	249.66	249.64	249.65	7015.0
2017-09-28 09:15:00	SPY	ETF	249.65	249.67	249.65	249.65	7855.0

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

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