PREVIEW / etf_1min / 2017-12-01

all etf 1-min files

  file:    by_date/etf_1min/2017/2017-12-01.parquet
  size:    3.2 MB
  rows:    163,742

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-12-01 04:04:00	SPY	ETF	264.11	264.11	264.11	264.11	2543.0
2017-12-01 04:05:00	SPY	ETF	264.15	264.16	264.15	264.16	2660.0
2017-12-01 04:08:00	SPY	ETF	264.31	264.31	264.31	264.31	100.0
2017-12-01 04:20:00	SPY	ETF	264.11	264.11	264.11	264.11	300.0
2017-12-01 04:21:00	SPY	ETF	264.05	264.05	264.05	264.05	3000.0
2017-12-01 04:22:00	SPY	ETF	264.05	264.05	264.05	264.05	2010.0
2017-12-01 04:26:00	SPY	ETF	264.12	264.12	264.12	264.12	400.0
2017-12-01 04:31:00	SPY	ETF	264.14	264.14	264.14	264.14	300.0
2017-12-01 04:33:00	SPY	ETF	264.31	264.31	264.31	264.31	200.0
2017-12-01 04:37:00	SPY	ETF	264.27	264.27	264.27	264.27	400.0
2017-12-01 04:47:00	SPY	ETF	264.26	264.26	264.26	264.26	100.0
2017-12-01 04:48:00	SPY	ETF	264.34	264.35	264.34	264.35	2100.0
2017-12-01 04:50:00	SPY	ETF	264.32	264.32	264.31	264.31	5500.0
2017-12-01 04:51:00	SPY	ETF	264.31	264.32	264.29	264.32	19500.0
2017-12-01 04:57:00	SPY	ETF	264.35	264.35	264.35	264.35	200.0
2017-12-01 05:09:00	SPY	ETF	264.43	264.43	264.43	264.43	100.0
2017-12-01 05:17:00	SPY	ETF	264.29	264.29	264.29	264.29	100.0
2017-12-01 05:32:00	SPY	ETF	264.21	264.21	264.21	264.21	1000.0
2017-12-01 05:38:00	SPY	ETF	264.12	264.12	264.12	264.12	180.0
2017-12-01 05:39:00	SPY	ETF	264.08	264.08	264.08	264.08	100.0
2017-12-01 05:40:00	SPY	ETF	264.05	264.05	264.05	264.05	1050.0
2017-12-01 05:42:00	SPY	ETF	264.0	264.0	263.91	263.91	2150.0
2017-12-01 05:43:00	SPY	ETF	263.91	263.92	263.91	263.92	1500.0
2017-12-01 05:49:00	SPY	ETF	263.8	263.8	263.8	263.8	621.0
2017-12-01 05:50:00	SPY	ETF	263.78	263.78	263.78	263.78	555.0
2017-12-01 05:51:00	SPY	ETF	263.7	263.73	263.67	263.67	1920.0
2017-12-01 05:52:00	SPY	ETF	263.55	263.55	263.55	263.55	1113.0
2017-12-01 05:53:00	SPY	ETF	263.62	263.62	263.62	263.62	514.0
2017-12-01 05:54:00	SPY	ETF	263.49	263.49	263.44	263.44	6321.0
2017-12-01 05:56:00	SPY	ETF	263.54	263.59	263.34	263.34	5966.0
2017-12-01 05:57:00	SPY	ETF	263.46	263.46	263.46	263.46	105.0
2017-12-01 05:58:00	SPY	ETF	263.58	263.58	263.58	263.58	507.0
2017-12-01 05:59:00	SPY	ETF	263.58	263.58	263.58	263.58	501.0
2017-12-01 06:00:00	SPY	ETF	263.48	263.48	263.48	263.48	109.0
2017-12-01 06:01:00	SPY	ETF	263.65	263.65	263.65	263.65	25104.0
2017-12-01 06:02:00	SPY	ETF	263.6	263.6	263.6	263.6	5104.0
2017-12-01 06:03:00	SPY	ETF	263.58	263.58	263.58	263.58	400.0
2017-12-01 06:04:00	SPY	ETF	263.59	263.63	263.59	263.6	2004.0
2017-12-01 06:05:00	SPY	ETF	263.6	263.62	263.6	263.6	5940.0
2017-12-01 06:06:00	SPY	ETF	263.56	263.67	263.56	263.67	1979.0
2017-12-01 06:07:00	SPY	ETF	263.63	263.63	263.63	263.63	2000.0
2017-12-01 06:08:00	SPY	ETF	263.58	263.58	263.57	263.57	602.0
2017-12-01 06:09:00	SPY	ETF	263.64	263.64	263.64	263.64	2030.0
2017-12-01 06:10:00	SPY	ETF	263.79	263.8	263.76	263.8	1704.0
2017-12-01 06:11:00	SPY	ETF	263.71	263.71	263.71	263.71	203.0
2017-12-01 06:12:00	SPY	ETF	263.71	263.71	263.65	263.65	934.0
2017-12-01 06:13:00	SPY	ETF	263.69	263.69	263.59	263.59	5104.0
2017-12-01 06:14:00	SPY	ETF	263.66	263.66	263.5	263.5	912.0
2017-12-01 06:16:00	SPY	ETF	263.71	263.71	263.71	263.71	240.0
2017-12-01 06:17:00	SPY	ETF	263.75	263.75	263.75	263.75	501.0

> showing 50 of 163,742 rows — these rows as CSV

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