PREVIEW / etf_5min / 2017-09-18

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-09-18.parquet
  size:    1.2 MB
  rows:    53,946

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-18 04:00:00	SPY	ETF	249.61	249.71	249.61	249.71	456.0
2017-09-18 04:05:00	SPY	ETF	249.73	249.73	249.73	249.73	507.0
2017-09-18 04:20:00	SPY	ETF	249.71	249.71	249.71	249.71	100.0
2017-09-18 04:25:00	SPY	ETF	249.73	249.78	249.73	249.78	2200.0
2017-09-18 04:30:00	SPY	ETF	249.78	249.86	249.78	249.86	2000.0
2017-09-18 04:35:00	SPY	ETF	249.8	249.8	249.8	249.8	200.0
2017-09-18 04:40:00	SPY	ETF	249.77	249.77	249.77	249.77	100.0
2017-09-18 04:45:00	SPY	ETF	249.76	249.76	249.76	249.76	200.0
2017-09-18 04:55:00	SPY	ETF	249.8	249.8	249.8	249.8	200.0
2017-09-18 05:00:00	SPY	ETF	249.8	249.8	249.79	249.8	1200.0
2017-09-18 05:10:00	SPY	ETF	249.86	249.86	249.8	249.8	700.0
2017-09-18 05:35:00	SPY	ETF	249.85	249.87	249.85	249.87	600.0
2017-09-18 05:40:00	SPY	ETF	249.87	249.87	249.87	249.87	300.0
2017-09-18 05:55:00	SPY	ETF	249.87	249.88	249.87	249.88	730.0
2017-09-18 06:00:00	SPY	ETF	249.78	249.82	249.78	249.81	2100.0
2017-09-18 06:15:00	SPY	ETF	249.75	249.75	249.75	249.75	1200.0
2017-09-18 06:20:00	SPY	ETF	249.76	249.76	249.75	249.75	600.0
2017-09-18 06:30:00	SPY	ETF	249.75	249.75	249.75	249.75	100.0
2017-09-18 06:45:00	SPY	ETF	249.78	249.82	249.78	249.82	9000.0
2017-09-18 06:50:00	SPY	ETF	249.82	249.82	249.82	249.82	500.0
2017-09-18 06:55:00	SPY	ETF	249.8	249.82	249.75	249.75	45451.0
2017-09-18 07:00:00	SPY	ETF	249.75	249.75	249.7	249.7	25510.0
2017-09-18 07:05:00	SPY	ETF	249.72	249.73	249.72	249.73	5125.0
2017-09-18 07:10:00	SPY	ETF	249.74	249.74	249.71	249.73	9300.0
2017-09-18 07:20:00	SPY	ETF	249.7	249.7	249.7	249.7	1800.0
2017-09-18 07:25:00	SPY	ETF	249.68	249.68	249.67	249.67	7892.0
2017-09-18 07:30:00	SPY	ETF	249.66	249.7	249.66	249.7	2000.0
2017-09-18 07:35:00	SPY	ETF	249.7	249.72	249.7	249.71	743.0
2017-09-18 07:40:00	SPY	ETF	249.72	249.72	249.7	249.7	1900.0
2017-09-18 07:45:00	SPY	ETF	249.71	249.71	249.7	249.7	1000.0
2017-09-18 07:50:00	SPY	ETF	249.68	249.72	249.68	249.7	22859.0
2017-09-18 07:55:00	SPY	ETF	249.73	249.75	249.7	249.74	7585.0
2017-09-18 08:00:00	SPY	ETF	249.74	249.75	249.68	249.73	114431.0
2017-09-18 08:05:00	SPY	ETF	249.7	249.7	249.68	249.68	3700.0
2017-09-18 08:10:00	SPY	ETF	249.69	249.71	249.68	249.7	2601.0
2017-09-18 08:15:00	SPY	ETF	249.71	249.71	249.68	249.68	5300.0
2017-09-18 08:20:00	SPY	ETF	249.68	249.69	249.67	249.67	10842.0
2017-09-18 08:25:00	SPY	ETF	249.65	249.65	249.6	249.6	17074.0
2017-09-18 08:30:00	SPY	ETF	249.61	249.62	249.58	249.62	13856.0
2017-09-18 08:35:00	SPY	ETF	249.61	249.62	249.61	249.62	6169.0
2017-09-18 08:40:00	SPY	ETF	249.61	249.63	249.6	249.63	3747.0
2017-09-18 08:45:00	SPY	ETF	249.65	249.65	249.58	249.59	19635.0
2017-09-18 08:50:00	SPY	ETF	249.58	249.58	249.52	249.55	25949.0
2017-09-18 08:55:00	SPY	ETF	249.54	249.56	249.54	249.56	11942.0
2017-09-18 09:00:00	SPY	ETF	249.57	249.61	249.57	249.6	7970.0
2017-09-18 09:05:00	SPY	ETF	249.59	249.64	249.59	249.63	11122.0
2017-09-18 09:10:00	SPY	ETF	249.63	249.65	249.61	249.63	12370.0
2017-09-18 09:15:00	SPY	ETF	249.63	249.69	249.63	249.69	43883.0
2017-09-18 09:20:00	SPY	ETF	249.68	249.71	249.68	249.69	9370.0
2017-09-18 09:25:00	SPY	ETF	249.69	249.69	249.6	249.65	208375.0

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

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