PREVIEW / etf_5min / 2017-05-08

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-05-08.parquet
  size:    1.2 MB
  rows:    52,710

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-08 04:00:00	SPY	ETF	239.5	239.5	239.5	239.5	175.0
2017-05-08 04:05:00	SPY	ETF	239.64	239.64	239.61	239.64	12606.0
2017-05-08 04:10:00	SPY	ETF	239.67	239.67	239.67	239.67	358.0
2017-05-08 04:15:00	SPY	ETF	239.69	239.69	239.69	239.69	2157.0
2017-05-08 04:25:00	SPY	ETF	239.68	239.72	239.68	239.72	1200.0
2017-05-08 04:30:00	SPY	ETF	239.72	239.72	239.67	239.67	300.0
2017-05-08 04:35:00	SPY	ETF	239.66	239.67	239.66	239.67	735.0
2017-05-08 04:45:00	SPY	ETF	239.66	239.66	239.66	239.66	800.0
2017-05-08 04:50:00	SPY	ETF	239.66	239.66	239.61	239.61	3250.0
2017-05-08 04:55:00	SPY	ETF	239.51	239.56	239.51	239.56	3900.0
2017-05-08 05:00:00	SPY	ETF	239.57	239.62	239.57	239.62	1100.0
2017-05-08 05:05:00	SPY	ETF	239.62	239.63	239.56	239.6	700.0
2017-05-08 05:10:00	SPY	ETF	239.53	239.53	239.53	239.53	500.0
2017-05-08 05:15:00	SPY	ETF	239.52	239.52	239.43	239.46	11260.0
2017-05-08 05:20:00	SPY	ETF	239.5	239.57	239.5	239.55	14400.0
2017-05-08 05:25:00	SPY	ETF	239.58	239.62	239.58	239.6	6600.0
2017-05-08 05:30:00	SPY	ETF	239.53	239.53	239.53	239.53	140.0
2017-05-08 05:40:00	SPY	ETF	239.58	239.58	239.56	239.56	400.0
2017-05-08 05:45:00	SPY	ETF	239.45	239.45	239.45	239.45	1500.0
2017-05-08 05:50:00	SPY	ETF	239.46	239.6	239.46	239.6	1500.0
2017-05-08 06:00:00	SPY	ETF	239.58	239.58	239.55	239.55	751.0
2017-05-08 06:05:00	SPY	ETF	239.59	239.62	239.59	239.62	649.0
2017-05-08 06:10:00	SPY	ETF	239.61	239.61	239.61	239.61	100.0
2017-05-08 06:15:00	SPY	ETF	239.58	239.58	239.55	239.55	950.0
2017-05-08 06:20:00	SPY	ETF	239.62	239.68	239.62	239.68	1100.0
2017-05-08 06:25:00	SPY	ETF	239.72	239.79	239.72	239.79	8650.0
2017-05-08 06:30:00	SPY	ETF	239.79	239.79	239.79	239.79	300.0
2017-05-08 06:45:00	SPY	ETF	239.85	239.85	239.85	239.85	200.0
2017-05-08 06:50:00	SPY	ETF	239.79	239.79	239.79	239.79	600.0
2017-05-08 06:55:00	SPY	ETF	239.75	239.77	239.75	239.77	400.0
2017-05-08 07:00:00	SPY	ETF	239.78	239.8	239.78	239.8	650.0
2017-05-08 07:05:00	SPY	ETF	239.77	239.77	239.71	239.73	5625.0
2017-05-08 07:10:00	SPY	ETF	239.76	239.77	239.72	239.75	4453.0
2017-05-08 07:15:00	SPY	ETF	239.71	239.75	239.71	239.75	1700.0
2017-05-08 07:20:00	SPY	ETF	239.78	239.8	239.78	239.8	17450.0
2017-05-08 07:25:00	SPY	ETF	239.78	239.82	239.78	239.82	3800.0
2017-05-08 07:30:00	SPY	ETF	239.84	239.85	239.84	239.85	2600.0
2017-05-08 07:35:00	SPY	ETF	239.84	239.87	239.81	239.87	2630.0
2017-05-08 07:40:00	SPY	ETF	239.87	239.87	239.8	239.8	1640.0
2017-05-08 07:45:00	SPY	ETF	239.8	239.8	239.79	239.79	37500.0
2017-05-08 07:50:00	SPY	ETF	239.76	239.78	239.74	239.74	3840.0
2017-05-08 07:55:00	SPY	ETF	239.77	239.77	239.69	239.69	8941.0
2017-05-08 08:00:00	SPY	ETF	239.73	239.84	239.69	239.69	475250.0
2017-05-08 08:05:00	SPY	ETF	239.69	239.7	239.65	239.67	17710.0
2017-05-08 08:10:00	SPY	ETF	239.66	239.66	239.6	239.63	20302.0
2017-05-08 08:15:00	SPY	ETF	239.64	239.66	239.62	239.62	57774.0
2017-05-08 08:20:00	SPY	ETF	239.62	239.69	239.57	239.68	39901.0
2017-05-08 08:25:00	SPY	ETF	239.64	239.66	239.6	239.62	14764.0
2017-05-08 08:30:00	SPY	ETF	239.66	239.66	239.61	239.61	19054.0
2017-05-08 08:35:00	SPY	ETF	239.65	239.65	239.59	239.59	30511.0

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

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