PREVIEW / etf_1min / 2017-07-06

all etf 1-min files

  file:    by_date/etf_1min/2017/2017-07-06.parquet
  size:    2.7 MB
  rows:    144,301

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-07-06 04:00:00	SPY	ETF	242.31	242.31	242.3	242.3	355.0
2017-07-06 04:22:00	SPY	ETF	242.38	242.38	242.38	242.38	100.0
2017-07-06 04:23:00	SPY	ETF	242.34	242.34	242.34	242.34	200.0
2017-07-06 04:24:00	SPY	ETF	242.32	242.32	242.32	242.32	104.0
2017-07-06 04:42:00	SPY	ETF	242.34	242.34	242.34	242.34	600.0
2017-07-06 04:43:00	SPY	ETF	242.3	242.3	242.3	242.3	100.0
2017-07-06 05:10:00	SPY	ETF	242.18	242.18	242.18	242.18	500.0
2017-07-06 05:11:00	SPY	ETF	242.14	242.14	242.14	242.14	120.0
2017-07-06 05:14:00	SPY	ETF	242.2	242.2	242.2	242.2	301.0
2017-07-06 05:15:00	SPY	ETF	242.17	242.17	242.17	242.17	100.0
2017-07-06 05:22:00	SPY	ETF	242.1	242.1	242.1	242.1	1051.0
2017-07-06 05:23:00	SPY	ETF	242.02	242.02	242.02	242.02	201.0
2017-07-06 05:24:00	SPY	ETF	242.01	242.01	242.01	242.01	1474.0
2017-07-06 05:25:00	SPY	ETF	242.01	242.01	242.01	242.01	2543.0
2017-07-06 05:27:00	SPY	ETF	242.02	242.02	241.9	241.9	5354.0
2017-07-06 05:29:00	SPY	ETF	241.9	241.9	241.9	241.9	123.0
2017-07-06 05:41:00	SPY	ETF	241.91	241.91	241.91	241.91	179.0
2017-07-06 05:42:00	SPY	ETF	241.85	241.85	241.85	241.85	201.0
2017-07-06 05:43:00	SPY	ETF	241.91	241.91	241.91	241.91	307.0
2017-07-06 05:51:00	SPY	ETF	241.89	241.89	241.89	241.89	100.0
2017-07-06 05:54:00	SPY	ETF	241.81	241.81	241.81	241.81	104.0
2017-07-06 05:55:00	SPY	ETF	241.84	241.84	241.84	241.84	500.0
2017-07-06 05:56:00	SPY	ETF	241.83	241.83	241.83	241.83	215.0
2017-07-06 05:57:00	SPY	ETF	241.78	241.78	241.78	241.78	3500.0
2017-07-06 05:59:00	SPY	ETF	241.81	241.81	241.81	241.81	200.0
2017-07-06 06:00:00	SPY	ETF	241.81	241.81	241.81	241.81	102.0
2017-07-06 06:05:00	SPY	ETF	241.79	241.79	241.79	241.79	3301.0
2017-07-06 06:06:00	SPY	ETF	241.71	241.71	241.67	241.67	3098.0
2017-07-06 06:09:00	SPY	ETF	241.64	241.64	241.64	241.64	100.0
2017-07-06 06:11:00	SPY	ETF	241.66	241.66	241.66	241.66	200.0
2017-07-06 06:13:00	SPY	ETF	241.67	241.67	241.67	241.67	152.0
2017-07-06 06:15:00	SPY	ETF	241.6	241.6	241.6	241.6	338.0
2017-07-06 06:18:00	SPY	ETF	241.54	241.54	241.51	241.51	798.0
2017-07-06 06:20:00	SPY	ETF	241.46	241.46	241.44	241.44	1224.0
2017-07-06 06:23:00	SPY	ETF	241.54	241.54	241.54	241.54	100.0
2017-07-06 06:24:00	SPY	ETF	241.5	241.5	241.5	241.5	150.0
2017-07-06 06:30:00	SPY	ETF	241.57	241.57	241.52	241.54	7101.0
2017-07-06 06:31:00	SPY	ETF	241.52	241.52	241.52	241.52	1000.0
2017-07-06 06:32:00	SPY	ETF	241.52	241.52	241.52	241.52	120.0
2017-07-06 06:33:00	SPY	ETF	241.51	241.51	241.51	241.51	500.0
2017-07-06 06:34:00	SPY	ETF	241.51	241.57	241.51	241.57	30000.0
2017-07-06 06:35:00	SPY	ETF	241.55	241.55	241.55	241.55	6000.0
2017-07-06 06:37:00	SPY	ETF	241.57	241.57	241.57	241.57	673.0
2017-07-06 06:38:00	SPY	ETF	241.58	241.58	241.54	241.54	8100.0
2017-07-06 06:39:00	SPY	ETF	241.55	241.55	241.55	241.55	5810.0
2017-07-06 06:41:00	SPY	ETF	241.58	241.58	241.58	241.58	6220.0
2017-07-06 06:47:00	SPY	ETF	241.68	241.7	241.68	241.68	12002.0
2017-07-06 06:48:00	SPY	ETF	241.65	241.65	241.65	241.65	311.0
2017-07-06 06:49:00	SPY	ETF	241.73	241.73	241.73	241.73	200.0
2017-07-06 06:50:00	SPY	ETF	241.73	241.74	241.73	241.74	200.0

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

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