PREVIEW / etf_1min / 2018-04-16

all etf 1-min files

  file:    by_date/etf_1min/2018/2018-04-16.parquet
  size:    2.9 MB
  rows:    150,970

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
2018-04-16 04:00:00	SPY	ETF	266.0	266.19	266.0	266.19	733.0
2018-04-16 04:01:00	SPY	ETF	266.2	266.2	266.2	266.2	110.0
2018-04-16 04:04:00	SPY	ETF	266.29	266.29	266.29	266.29	1200.0
2018-04-16 04:05:00	SPY	ETF	266.28	266.29	266.28	266.29	1150.0
2018-04-16 04:12:00	SPY	ETF	266.34	266.34	266.29	266.29	500.0
2018-04-16 04:16:00	SPY	ETF	266.4	266.4	266.4	266.4	100.0
2018-04-16 04:17:00	SPY	ETF	266.39	266.4	266.39	266.4	330.0
2018-04-16 04:21:00	SPY	ETF	266.38	266.38	266.38	266.38	117.0
2018-04-16 04:24:00	SPY	ETF	266.22	266.22	266.22	266.22	1100.0
2018-04-16 04:50:00	SPY	ETF	266.26	266.26	266.26	266.26	100.0
2018-04-16 04:59:00	SPY	ETF	266.43	266.43	266.43	266.43	900.0
2018-04-16 05:01:00	SPY	ETF	266.41	266.44	266.41	266.44	700.0
2018-04-16 05:08:00	SPY	ETF	266.46	266.49	266.46	266.49	1000.0
2018-04-16 05:09:00	SPY	ETF	266.5	266.5	266.5	266.5	800.0
2018-04-16 05:11:00	SPY	ETF	266.46	266.46	266.46	266.46	100.0
2018-04-16 05:14:00	SPY	ETF	266.46	266.46	266.46	266.46	500.0
2018-04-16 05:16:00	SPY	ETF	266.52	266.52	266.52	266.52	1100.0
2018-04-16 05:17:00	SPY	ETF	266.61	266.61	266.61	266.61	550.0
2018-04-16 05:18:00	SPY	ETF	266.63	266.72	266.63	266.72	2210.0
2018-04-16 05:19:00	SPY	ETF	266.79	266.79	266.71	266.71	800.0
2018-04-16 05:21:00	SPY	ETF	266.73	266.75	266.73	266.75	400.0
2018-04-16 05:24:00	SPY	ETF	266.8	266.8	266.8	266.8	300.0
2018-04-16 05:25:00	SPY	ETF	266.83	266.83	266.83	266.83	200.0
2018-04-16 05:26:00	SPY	ETF	266.88	266.89	266.88	266.89	861.0
2018-04-16 05:34:00	SPY	ETF	266.86	266.86	266.86	266.86	1000.0
2018-04-16 05:36:00	SPY	ETF	266.83	266.83	266.83	266.83	500.0
2018-04-16 05:37:00	SPY	ETF	266.89	266.93	266.89	266.93	200.0
2018-04-16 05:39:00	SPY	ETF	266.95	266.95	266.91	266.95	600.0
2018-04-16 05:43:00	SPY	ETF	266.92	266.92	266.92	266.92	1000.0
2018-04-16 05:47:00	SPY	ETF	266.94	266.94	266.94	266.94	550.0
2018-04-16 05:49:00	SPY	ETF	266.88	266.88	266.88	266.88	1000.0
2018-04-16 05:54:00	SPY	ETF	266.95	266.95	266.9	266.9	540.0
2018-04-16 05:55:00	SPY	ETF	266.9	266.9	266.9	266.9	800.0
2018-04-16 05:56:00	SPY	ETF	266.93	266.94	266.92	266.92	3300.0
2018-04-16 05:57:00	SPY	ETF	266.92	266.92	266.92	266.92	15000.0
2018-04-16 05:59:00	SPY	ETF	266.92	266.96	266.92	266.96	15500.0
2018-04-16 06:00:00	SPY	ETF	266.92	266.92	266.92	266.92	500.0
2018-04-16 06:01:00	SPY	ETF	266.92	266.92	266.92	266.92	1500.0
2018-04-16 06:02:00	SPY	ETF	266.92	266.92	266.92	266.92	13400.0
2018-04-16 06:03:00	SPY	ETF	266.92	266.92	266.92	266.92	1500.0
2018-04-16 06:04:00	SPY	ETF	266.92	266.92	266.92	266.92	1100.0
2018-04-16 06:07:00	SPY	ETF	266.74	266.78	266.74	266.78	3000.0
2018-04-16 06:19:00	SPY	ETF	266.92	266.92	266.92	266.92	300.0
2018-04-16 06:20:00	SPY	ETF	266.94	266.94	266.94	266.94	1015.0
2018-04-16 06:21:00	SPY	ETF	266.98	267.0	266.97	266.97	738.0
2018-04-16 06:22:00	SPY	ETF	266.87	266.87	266.87	266.87	500.0
2018-04-16 06:26:00	SPY	ETF	266.87	266.87	266.87	266.87	1500.0
2018-04-16 06:27:00	SPY	ETF	267.01	267.01	267.01	267.01	100.0
2018-04-16 06:34:00	SPY	ETF	266.92	266.92	266.92	266.92	200.0
2018-04-16 06:39:00	SPY	ETF	266.78	266.84	266.78	266.84	350.0

> showing 50 of 150,970 rows — these rows as CSV

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