PREVIEW / etf_1min / 2017-11-10

all etf 1-min files

  file:    by_date/etf_1min/2017/2017-11-10.parquet
  size:    2.6 MB
  rows:    136,796

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-11-10 04:00:00	SPY	ETF	257.73	257.73	257.73	257.73	1500.0
2017-11-10 04:02:00	SPY	ETF	257.79	257.79	257.79	257.79	100.0
2017-11-10 04:05:00	SPY	ETF	257.73	257.73	257.73	257.73	100.0
2017-11-10 04:06:00	SPY	ETF	257.7	257.7	257.7	257.7	200.0
2017-11-10 04:10:00	SPY	ETF	257.6	257.6	257.56	257.56	4000.0
2017-11-10 04:13:00	SPY	ETF	257.6	257.6	257.52	257.52	1900.0
2017-11-10 04:15:00	SPY	ETF	257.5	257.5	257.37	257.4	3100.0
2017-11-10 04:16:00	SPY	ETF	257.4	257.4	257.4	257.4	300.0
2017-11-10 04:18:00	SPY	ETF	257.4	257.4	257.4	257.4	1000.0
2017-11-10 04:19:00	SPY	ETF	257.45	257.45	257.45	257.45	2000.0
2017-11-10 04:23:00	SPY	ETF	257.58	257.58	257.58	257.58	201.0
2017-11-10 04:25:00	SPY	ETF	257.4	257.43	257.4	257.43	2002.0
2017-11-10 04:26:00	SPY	ETF	257.41	257.41	257.27	257.28	2434.0
2017-11-10 04:27:00	SPY	ETF	257.3	257.3	257.16	257.23	3209.0
2017-11-10 04:32:00	SPY	ETF	257.24	257.24	257.24	257.24	504.0
2017-11-10 04:33:00	SPY	ETF	257.23	257.23	257.23	257.23	304.0
2017-11-10 04:35:00	SPY	ETF	257.3	257.3	257.3	257.3	4713.0
2017-11-10 04:36:00	SPY	ETF	257.3	257.3	257.25	257.25	404.0
2017-11-10 04:39:00	SPY	ETF	257.3	257.3	257.3	257.3	315.0
2017-11-10 04:40:00	SPY	ETF	257.3	257.31	257.3	257.31	600.0
2017-11-10 04:41:00	SPY	ETF	257.28	257.28	257.17	257.17	1990.0
2017-11-10 04:43:00	SPY	ETF	257.24	257.24	257.23	257.23	2100.0
2017-11-10 04:44:00	SPY	ETF	257.25	257.25	257.25	257.25	414.0
2017-11-10 04:46:00	SPY	ETF	257.36	257.36	257.36	257.36	2502.0
2017-11-10 04:48:00	SPY	ETF	257.34	257.34	257.33	257.33	5705.0
2017-11-10 04:49:00	SPY	ETF	257.32	257.32	257.32	257.32	1300.0
2017-11-10 04:51:00	SPY	ETF	257.32	257.32	257.32	257.32	225.0
2017-11-10 04:54:00	SPY	ETF	257.33	257.33	257.25	257.25	802.0
2017-11-10 04:59:00	SPY	ETF	257.23	257.23	257.23	257.23	2005.0
2017-11-10 05:03:00	SPY	ETF	257.31	257.31	257.31	257.31	100.0
2017-11-10 05:10:00	SPY	ETF	257.46	257.46	257.46	257.46	301.0
2017-11-10 05:14:00	SPY	ETF	257.35	257.35	257.35	257.35	3003.0
2017-11-10 05:21:00	SPY	ETF	257.45	257.45	257.45	257.45	101.0
2017-11-10 05:22:00	SPY	ETF	257.48	257.48	257.48	257.48	1299.0
2017-11-10 05:23:00	SPY	ETF	257.45	257.45	257.43	257.43	603.0
2017-11-10 05:27:00	SPY	ETF	257.4	257.4	257.4	257.4	604.0
2017-11-10 05:30:00	SPY	ETF	257.46	257.46	257.46	257.46	1003.0
2017-11-10 05:44:00	SPY	ETF	257.49	257.49	257.49	257.49	101.0
2017-11-10 06:00:00	SPY	ETF	257.58	257.58	257.58	257.58	1000.0
2017-11-10 06:01:00	SPY	ETF	257.54	257.54	257.54	257.54	107.0
2017-11-10 06:04:00	SPY	ETF	257.6	257.6	257.6	257.6	302.0
2017-11-10 06:08:00	SPY	ETF	257.59	257.59	257.59	257.59	100.0
2017-11-10 06:09:00	SPY	ETF	257.59	257.59	257.59	257.59	102.0
2017-11-10 06:10:00	SPY	ETF	257.63	257.63	257.63	257.63	1000.0
2017-11-10 06:12:00	SPY	ETF	257.63	257.63	257.6	257.6	1902.0
2017-11-10 06:13:00	SPY	ETF	257.63	257.63	257.63	257.63	500.0
2017-11-10 06:15:00	SPY	ETF	257.63	257.63	257.63	257.63	1000.0
2017-11-10 06:16:00	SPY	ETF	257.62	257.62	257.6	257.6	242.0
2017-11-10 06:17:00	SPY	ETF	257.6	257.61	257.6	257.61	1000.0
2017-11-10 06:18:00	SPY	ETF	257.61	257.61	257.61	257.61	801.0

> showing 50 of 136,796 rows — these rows as CSV

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