PREVIEW / etf_1min / 2016-07-06

all etf 1-min files

  file:    by_date/etf_1min/2016/2016-07-06.parquet
  size:    2.8 MB
  rows:    152,564

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
2016-07-06 04:00:00	SPY	ETF	208.17	208.17	208.17	208.17	255.0
2016-07-06 04:01:00	SPY	ETF	208.13	208.15	208.13	208.15	450.0
2016-07-06 04:02:00	SPY	ETF	208.2	208.2	208.16	208.16	1500.0
2016-07-06 04:06:00	SPY	ETF	208.28	208.3	208.27	208.27	2300.0
2016-07-06 04:07:00	SPY	ETF	208.3	208.3	208.3	208.3	500.0
2016-07-06 04:09:00	SPY	ETF	208.3	208.3	208.3	208.3	100.0
2016-07-06 04:10:00	SPY	ETF	208.23	208.23	208.23	208.23	100.0
2016-07-06 04:12:00	SPY	ETF	208.19	208.25	208.19	208.25	2320.0
2016-07-06 04:13:00	SPY	ETF	208.19	208.19	208.19	208.19	200.0
2016-07-06 04:15:00	SPY	ETF	208.21	208.21	208.21	208.21	1000.0
2016-07-06 04:17:00	SPY	ETF	208.33	208.33	208.33	208.33	120.0
2016-07-06 04:20:00	SPY	ETF	208.3	208.3	208.3	208.3	200.0
2016-07-06 04:22:00	SPY	ETF	208.25	208.25	208.25	208.25	400.0
2016-07-06 04:25:00	SPY	ETF	208.27	208.27	208.25	208.25	13100.0
2016-07-06 04:26:00	SPY	ETF	208.22	208.22	208.22	208.22	400.0
2016-07-06 04:27:00	SPY	ETF	208.27	208.27	208.27	208.27	800.0
2016-07-06 04:28:00	SPY	ETF	208.27	208.27	208.27	208.27	300.0
2016-07-06 04:29:00	SPY	ETF	208.27	208.27	208.27	208.27	900.0
2016-07-06 04:31:00	SPY	ETF	208.25	208.25	208.25	208.25	4700.0
2016-07-06 04:32:00	SPY	ETF	208.2	208.2	208.2	208.2	1701.0
2016-07-06 04:33:00	SPY	ETF	208.08	208.08	208.08	208.08	260.0
2016-07-06 04:35:00	SPY	ETF	208.01	208.01	207.97	207.97	1499.0
2016-07-06 04:36:00	SPY	ETF	207.97	207.98	207.96	207.98	803.0
2016-07-06 04:37:00	SPY	ETF	208.0	208.0	208.0	208.0	114.0
2016-07-06 04:38:00	SPY	ETF	207.95	207.95	207.95	207.95	274.0
2016-07-06 04:39:00	SPY	ETF	207.93	207.93	207.93	207.93	305.0
2016-07-06 04:41:00	SPY	ETF	207.83	207.85	207.8	207.85	1235.0
2016-07-06 04:42:00	SPY	ETF	207.77	207.83	207.77	207.83	8506.0
2016-07-06 04:43:00	SPY	ETF	207.75	207.75	207.75	207.75	864.0
2016-07-06 04:44:00	SPY	ETF	207.73	207.73	207.66	207.66	1216.0
2016-07-06 04:45:00	SPY	ETF	207.73	207.73	207.63	207.63	1075.0
2016-07-06 04:46:00	SPY	ETF	207.6	207.6	207.6	207.6	244.0
2016-07-06 04:48:00	SPY	ETF	207.7	207.72	207.7	207.72	401.0
2016-07-06 04:49:00	SPY	ETF	207.75	207.75	207.74	207.74	521.0
2016-07-06 04:51:00	SPY	ETF	207.73	207.73	207.73	207.73	592.0
2016-07-06 04:54:00	SPY	ETF	207.75	207.75	207.75	207.75	503.0
2016-07-06 04:55:00	SPY	ETF	207.75	207.75	207.75	207.75	300.0
2016-07-06 04:56:00	SPY	ETF	207.79	207.79	207.79	207.79	106.0
2016-07-06 04:57:00	SPY	ETF	207.78	207.78	207.78	207.78	100.0
2016-07-06 04:59:00	SPY	ETF	207.76	207.76	207.76	207.76	200.0
2016-07-06 05:00:00	SPY	ETF	207.78	207.8	207.77	207.77	1102.0
2016-07-06 05:01:00	SPY	ETF	207.73	207.73	207.73	207.73	306.0
2016-07-06 05:06:00	SPY	ETF	207.7	207.7	207.25	207.25	17678.0
2016-07-06 05:08:00	SPY	ETF	207.57	207.57	207.57	207.57	1000.0
2016-07-06 05:09:00	SPY	ETF	207.55	207.55	207.54	207.55	3271.0
2016-07-06 05:11:00	SPY	ETF	207.58	207.58	207.52	207.58	3806.0
2016-07-06 05:13:00	SPY	ETF	207.56	207.56	207.56	207.56	201.0
2016-07-06 05:14:00	SPY	ETF	207.45	207.48	207.45	207.48	2405.0
2016-07-06 05:15:00	SPY	ETF	207.5	207.57	207.5	207.57	520.0
2016-07-06 05:16:00	SPY	ETF	207.58	207.6	207.57	207.57	2365.0

> showing 50 of 152,564 rows — these rows as CSV

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