PREVIEW / etf_1min / 2018-03-22

all etf 1-min files

  file:    by_date/etf_1min/2018/2018-03-22.parquet
  size:    3.3 MB
  rows:    168,991

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-03-22 04:00:00	SPY	ETF	268.99	269.11	268.84	268.84	1744.0
2018-03-22 04:01:00	SPY	ETF	268.84	268.89	268.84	268.89	1407.0
2018-03-22 04:02:00	SPY	ETF	268.89	268.9	268.89	268.9	750.0
2018-03-22 04:03:00	SPY	ETF	269.01	269.01	268.99	268.99	2927.0
2018-03-22 04:04:00	SPY	ETF	268.87	268.92	268.87	268.92	609.0
2018-03-22 04:05:00	SPY	ETF	269.04	269.16	269.04	269.16	3044.0
2018-03-22 04:06:00	SPY	ETF	269.15	269.15	269.15	269.15	244.0
2018-03-22 04:08:00	SPY	ETF	269.26	269.28	269.26	269.28	210.0
2018-03-22 04:10:00	SPY	ETF	269.26	269.26	269.26	269.26	300.0
2018-03-22 04:12:00	SPY	ETF	269.14	269.14	269.14	269.14	1090.0
2018-03-22 04:13:00	SPY	ETF	269.39	269.39	269.39	269.39	1020.0
2018-03-22 04:14:00	SPY	ETF	269.44	269.44	269.44	269.44	100.0
2018-03-22 04:17:00	SPY	ETF	269.45	269.46	269.45	269.46	1100.0
2018-03-22 04:30:00	SPY	ETF	269.6	269.6	269.6	269.6	500.0
2018-03-22 04:39:00	SPY	ETF	269.68	269.68	269.68	269.68	500.0
2018-03-22 04:50:00	SPY	ETF	269.62	269.62	269.62	269.62	125.0
2018-03-22 04:51:00	SPY	ETF	269.49	269.49	269.49	269.49	220.0
2018-03-22 04:52:00	SPY	ETF	269.56	269.56	269.56	269.56	420.0
2018-03-22 04:55:00	SPY	ETF	269.57	269.57	269.57	269.57	1000.0
2018-03-22 04:58:00	SPY	ETF	269.6	269.6	269.6	269.6	100.0
2018-03-22 04:59:00	SPY	ETF	269.63	269.63	269.63	269.63	600.0
2018-03-22 05:01:00	SPY	ETF	269.55	269.56	269.55	269.56	7920.0
2018-03-22 05:05:00	SPY	ETF	269.46	269.46	269.4	269.41	1120.0
2018-03-22 05:07:00	SPY	ETF	269.41	269.41	269.41	269.41	500.0
2018-03-22 05:09:00	SPY	ETF	269.45	269.45	269.43	269.43	1220.0
2018-03-22 05:12:00	SPY	ETF	269.31	269.31	269.31	269.31	900.0
2018-03-22 05:13:00	SPY	ETF	269.22	269.22	269.22	269.22	220.0
2018-03-22 05:14:00	SPY	ETF	269.12	269.12	269.04	269.04	3630.0
2018-03-22 05:15:00	SPY	ETF	268.95	268.95	268.95	268.95	2075.0
2018-03-22 05:16:00	SPY	ETF	268.84	268.9	268.82	268.9	5522.0
2018-03-22 05:17:00	SPY	ETF	268.87	268.9	268.87	268.9	205.0
2018-03-22 05:18:00	SPY	ETF	268.97	268.97	268.97	268.97	402.0
2018-03-22 05:20:00	SPY	ETF	268.82	268.82	268.82	268.82	107.0
2018-03-22 05:23:00	SPY	ETF	268.93	268.93	268.87	268.87	2465.0
2018-03-22 05:24:00	SPY	ETF	268.82	268.95	268.82	268.95	14718.0
2018-03-22 05:25:00	SPY	ETF	268.95	268.95	268.85	268.85	1910.0
2018-03-22 05:27:00	SPY	ETF	268.88	268.88	268.64	268.65	22840.0
2018-03-22 05:28:00	SPY	ETF	268.62	268.63	268.58	268.62	1705.0
2018-03-22 05:29:00	SPY	ETF	268.61	268.66	268.61	268.66	1803.0
2018-03-22 05:31:00	SPY	ETF	268.73	268.92	268.73	268.92	2676.0
2018-03-22 05:32:00	SPY	ETF	268.91	268.91	268.86	268.89	4306.0
2018-03-22 05:33:00	SPY	ETF	268.83	268.83	268.81	268.81	1006.0
2018-03-22 05:36:00	SPY	ETF	268.58	268.58	268.58	268.58	580.0
2018-03-22 05:39:00	SPY	ETF	268.81	268.81	268.81	268.81	526.0
2018-03-22 05:40:00	SPY	ETF	268.88	268.89	268.88	268.89	6307.0
2018-03-22 05:41:00	SPY	ETF	268.9	268.92	268.81	268.81	4006.0
2018-03-22 05:42:00	SPY	ETF	268.87	268.9	268.84	268.9	2909.0
2018-03-22 05:43:00	SPY	ETF	268.89	268.89	268.89	268.89	101.0
2018-03-22 05:44:00	SPY	ETF	268.94	268.94	268.94	268.94	404.0
2018-03-22 05:46:00	SPY	ETF	268.93	268.93	268.93	268.93	1053.0

> showing 50 of 168,991 rows — these rows as CSV

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