PREVIEW / etf_1min / 2017-09-07

all etf 1-min files

  file:    by_date/etf_1min/2017/2017-09-07.parquet
  size:    2.6 MB
  rows:    133,144

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:12:00	SPY	ETF	246.58	246.58	246.58	246.58	1000.0
2017-09-07 04:15:00	SPY	ETF	246.58	246.58	246.58	246.58	500.0
2017-09-07 04:17:00	SPY	ETF	246.63	246.63	246.63	246.63	600.0
2017-09-07 04:23:00	SPY	ETF	246.63	246.63	246.63	246.63	4600.0
2017-09-07 04:24:00	SPY	ETF	246.66	246.66	246.66	246.66	400.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:41:00	SPY	ETF	246.55	246.55	246.55	246.55	300.0
2017-09-07 04:52: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	300.0
2017-09-07 04:57:00	SPY	ETF	246.53	246.53	246.53	246.53	400.0
2017-09-07 05:00:00	SPY	ETF	246.55	246.57	246.55	246.57	400.0
2017-09-07 05:06:00	SPY	ETF	246.62	246.62	246.61	246.61	300.0
2017-09-07 05:08:00	SPY	ETF	246.58	246.6	246.58	246.6	700.0
2017-09-07 05:13:00	SPY	ETF	246.72	246.72	246.72	246.72	150.0
2017-09-07 05:33:00	SPY	ETF	246.76	246.76	246.76	246.76	800.0
2017-09-07 05:44: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.79	1300.0
2017-09-07 05:47:00	SPY	ETF	246.79	246.79	246.79	246.79	300.0
2017-09-07 05:49:00	SPY	ETF	246.77	246.77	246.77	246.77	250.0
2017-09-07 05:50:00	SPY	ETF	246.76	246.76	246.76	246.76	750.0
2017-09-07 05:54:00	SPY	ETF	246.77	246.78	246.77	246.78	400.0
2017-09-07 05:57:00	SPY	ETF	246.74	246.74	246.74	246.74	800.0
2017-09-07 06:01:00	SPY	ETF	246.78	246.78	246.78	246.78	400.0
2017-09-07 06:14:00	SPY	ETF	246.9	246.9	246.9	246.9	250.0
2017-09-07 06:20:00	SPY	ETF	246.94	246.94	246.94	246.94	200.0
2017-09-07 06:21:00	SPY	ETF	246.96	246.96	246.96	246.96	7500.0
2017-09-07 06:23:00	SPY	ETF	247.0	247.0	247.0	247.0	3005.0
2017-09-07 06:28: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.99	246.99	400.0
2017-09-07 06:31:00	SPY	ETF	246.98	246.98	246.98	246.98	4050.0
2017-09-07 06:35:00	SPY	ETF	247.01	247.01	247.01	247.01	5160.0
2017-09-07 06:36:00	SPY	ETF	246.96	246.96	246.96	246.96	2500.0
2017-09-07 06:42:00	SPY	ETF	247.01	247.01	247.01	247.01	100.0
2017-09-07 06:43:00	SPY	ETF	247.01	247.01	247.01	247.01	1200.0
2017-09-07 06:44:00	SPY	ETF	247.02	247.02	247.02	247.02	6600.0
2017-09-07 06:45:00	SPY	ETF	247.02	247.02	247.02	247.02	4250.0
2017-09-07 06:47:00	SPY	ETF	247.05	247.05	247.05	247.05	100.0
2017-09-07 06:49:00	SPY	ETF	247.03	247.06	247.03	247.06	35176.0
2017-09-07 06:50:00	SPY	ETF	247.06	247.06	247.06	247.06	1600.0
2017-09-07 06:52:00	SPY	ETF	247.08	247.08	247.08	247.08	200.0
2017-09-07 06:54:00	SPY	ETF	247.08	247.13	247.08	247.13	5950.0
2017-09-07 06:55:00	SPY	ETF	247.15	247.15	247.15	247.15	100.0
2017-09-07 06:58:00	SPY	ETF	247.13	247.14	247.13	247.14	500.0
2017-09-07 07:02:00	SPY	ETF	247.09	247.1	247.09	247.1	18401.0
2017-09-07 07:04:00	SPY	ETF	247.12	247.12	247.12	247.12	200.0
2017-09-07 07:05:00	SPY	ETF	247.12	247.12	247.09	247.09	1175.0
2017-09-07 07:07:00	SPY	ETF	247.14	247.14	247.14	247.14	505.0

> showing 50 of 133,144 rows — these rows as CSV

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