PREVIEW / etf_5min / 2017-09-07

all etf 5-min files

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

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-07 04:00:00	SPY	ETF	246.54	246.54	246.54	246.54	800.0
2017-09-07 04:05:00	SPY	ETF	246.55	246.55	246.55	246.55	150.0
2017-09-07 04:10:00	SPY	ETF	246.58	246.58	246.58	246.58	1000.0
2017-09-07 04:15:00	SPY	ETF	246.58	246.63	246.58	246.63	1100.0
2017-09-07 04:20:00	SPY	ETF	246.63	246.66	246.63	246.66	5000.0
2017-09-07 04:25:00	SPY	ETF	246.58	246.58	246.58	246.58	400.0
2017-09-07 04:30:00	SPY	ETF	246.59	246.59	246.59	246.59	100.0
2017-09-07 04:40:00	SPY	ETF	246.55	246.55	246.55	246.55	300.0
2017-09-07 04:50:00	SPY	ETF	246.53	246.53	246.53	246.53	200.0
2017-09-07 04:55:00	SPY	ETF	246.53	246.53	246.53	246.53	700.0
2017-09-07 05:00:00	SPY	ETF	246.55	246.57	246.55	246.57	400.0
2017-09-07 05:05:00	SPY	ETF	246.62	246.62	246.58	246.6	1000.0
2017-09-07 05:10:00	SPY	ETF	246.72	246.72	246.72	246.72	150.0
2017-09-07 05:30:00	SPY	ETF	246.76	246.76	246.76	246.76	800.0
2017-09-07 05:40:00	SPY	ETF	246.76	246.76	246.76	246.76	1000.0
2017-09-07 05:45:00	SPY	ETF	246.76	246.79	246.76	246.77	1850.0
2017-09-07 05:50:00	SPY	ETF	246.76	246.78	246.76	246.78	1150.0
2017-09-07 05:55:00	SPY	ETF	246.74	246.74	246.74	246.74	800.0
2017-09-07 06:00:00	SPY	ETF	246.78	246.78	246.78	246.78	400.0
2017-09-07 06:10:00	SPY	ETF	246.9	246.9	246.9	246.9	250.0
2017-09-07 06:20:00	SPY	ETF	246.94	247.0	246.94	247.0	10705.0
2017-09-07 06:25:00	SPY	ETF	247.01	247.01	247.01	247.01	100.0
2017-09-07 06:30:00	SPY	ETF	246.99	246.99	246.98	246.98	4450.0
2017-09-07 06:35:00	SPY	ETF	247.01	247.01	246.96	246.96	7660.0
2017-09-07 06:40:00	SPY	ETF	247.01	247.02	247.01	247.02	7900.0
2017-09-07 06:45:00	SPY	ETF	247.02	247.06	247.02	247.06	39526.0
2017-09-07 06:50:00	SPY	ETF	247.06	247.13	247.06	247.13	7750.0
2017-09-07 06:55:00	SPY	ETF	247.15	247.15	247.13	247.14	600.0
2017-09-07 07:00:00	SPY	ETF	247.09	247.12	247.09	247.12	18601.0
2017-09-07 07:05:00	SPY	ETF	247.12	247.14	247.09	247.14	1680.0
2017-09-07 07:10:00	SPY	ETF	247.08	247.1	247.08	247.09	2200.0
2017-09-07 07:15:00	SPY	ETF	247.08	247.08	247.07	247.07	1250.0
2017-09-07 07:20:00	SPY	ETF	247.08	247.12	247.02	247.02	13740.0
2017-09-07 07:25:00	SPY	ETF	247.01	247.01	246.96	246.96	13400.0
2017-09-07 07:30:00	SPY	ETF	246.96	246.96	246.94	246.95	1000.0
2017-09-07 07:35:00	SPY	ETF	246.93	246.99	246.93	246.99	5350.0
2017-09-07 07:40:00	SPY	ETF	246.99	246.99	246.94	246.96	14350.0
2017-09-07 07:45:00	SPY	ETF	246.96	247.12	246.96	247.12	17217.0
2017-09-07 07:50:00	SPY	ETF	247.11	247.14	247.08	247.1	6749.0
2017-09-07 07:55:00	SPY	ETF	247.08	247.09	247.08	247.09	400.0
2017-09-07 08:00:00	SPY	ETF	247.09	247.09	246.88	246.9	50722.0
2017-09-07 08:05:00	SPY	ETF	246.9	246.91	246.88	246.91	22524.0
2017-09-07 08:10:00	SPY	ETF	246.92	246.95	246.92	246.93	50500.0
2017-09-07 08:15:00	SPY	ETF	246.9	246.97	246.9	246.95	8240.0
2017-09-07 08:20:00	SPY	ETF	246.93	246.94	246.91	246.94	8638.0
2017-09-07 08:25:00	SPY	ETF	246.94	247.02	246.9	247.02	31700.0
2017-09-07 08:30:00	SPY	ETF	247.0	247.04	246.94	247.03	45000.0
2017-09-07 08:35:00	SPY	ETF	246.98	246.98	246.9	246.97	26183.0
2017-09-07 08:40:00	SPY	ETF	246.96	247.02	246.9	246.95	96618.0
2017-09-07 08:45:00	SPY	ETF	246.94	247.06	246.94	247.02	49900.0

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

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