PREVIEW / etf_1min / 2017-02-09

all etf 1-min files

  file:    by_date/etf_1min/2017/2017-02-09.parquet
  size:    2.8 MB
  rows:    146,518

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-02-09 04:11:00	SPY	ETF	229.2	229.2	229.2	229.2	300.0
2017-02-09 04:24:00	SPY	ETF	229.27	229.27	229.27	229.27	100.0
2017-02-09 04:25:00	SPY	ETF	229.27	229.27	229.27	229.27	900.0
2017-02-09 04:38:00	SPY	ETF	229.26	229.26	229.26	229.26	500.0
2017-02-09 05:07:00	SPY	ETF	229.24	229.24	229.24	229.24	130.0
2017-02-09 05:20:00	SPY	ETF	229.25	229.25	229.25	229.25	200.0
2017-02-09 05:28:00	SPY	ETF	229.28	229.28	229.28	229.28	100.0
2017-02-09 05:33:00	SPY	ETF	229.35	229.35	229.35	229.35	100.0
2017-02-09 05:34:00	SPY	ETF	229.35	229.35	229.33	229.33	300.0
2017-02-09 05:37:00	SPY	ETF	229.35	229.35	229.35	229.35	800.0
2017-02-09 05:48:00	SPY	ETF	229.23	229.23	229.23	229.23	2500.0
2017-02-09 06:10:00	SPY	ETF	229.39	229.43	229.39	229.43	3460.0
2017-02-09 06:12:00	SPY	ETF	229.48	229.48	229.48	229.48	1000.0
2017-02-09 06:16:00	SPY	ETF	229.49	229.55	229.49	229.55	2400.0
2017-02-09 06:17:00	SPY	ETF	229.57	229.58	229.57	229.58	2010.0
2017-02-09 06:18:00	SPY	ETF	229.58	229.58	229.58	229.58	1000.0
2017-02-09 06:19:00	SPY	ETF	229.55	229.55	229.55	229.55	6050.0
2017-02-09 06:20:00	SPY	ETF	229.55	229.55	229.55	229.55	2200.0
2017-02-09 06:24:00	SPY	ETF	229.65	229.67	229.65	229.67	4331.0
2017-02-09 06:25:00	SPY	ETF	229.68	229.73	229.68	229.72	2150.0
2017-02-09 06:26:00	SPY	ETF	229.72	229.72	229.72	229.72	1030.0
2017-02-09 06:28:00	SPY	ETF	229.78	229.8	229.77	229.8	1463.0
2017-02-09 06:29:00	SPY	ETF	229.78	229.78	229.77	229.77	1201.0
2017-02-09 06:30:00	SPY	ETF	229.77	229.79	229.77	229.79	6500.0
2017-02-09 06:31:00	SPY	ETF	229.8	229.8	229.79	229.79	3001.0
2017-02-09 06:32:00	SPY	ETF	229.79	229.79	229.77	229.77	18800.0
2017-02-09 06:33:00	SPY	ETF	229.77	229.77	229.77	229.77	2500.0
2017-02-09 06:34:00	SPY	ETF	229.76	229.76	229.76	229.76	100.0
2017-02-09 06:37:00	SPY	ETF	229.76	229.76	229.76	229.76	965.0
2017-02-09 06:38:00	SPY	ETF	229.74	229.74	229.74	229.74	1036.0
2017-02-09 06:39:00	SPY	ETF	229.76	229.76	229.76	229.76	1814.0
2017-02-09 06:40:00	SPY	ETF	229.75	229.76	229.74	229.74	4701.0
2017-02-09 06:43:00	SPY	ETF	229.74	229.74	229.74	229.74	300.0
2017-02-09 06:45:00	SPY	ETF	229.75	229.76	229.75	229.76	2607.0
2017-02-09 06:46:00	SPY	ETF	229.77	229.78	229.77	229.77	3700.0
2017-02-09 06:47:00	SPY	ETF	229.74	229.75	229.73	229.75	10500.0
2017-02-09 06:50:00	SPY	ETF	229.75	229.75	229.75	229.75	500.0
2017-02-09 06:52:00	SPY	ETF	229.74	229.74	229.74	229.74	4200.0
2017-02-09 06:53:00	SPY	ETF	229.74	229.74	229.74	229.74	4500.0
2017-02-09 06:55:00	SPY	ETF	229.71	229.71	229.71	229.71	8301.0
2017-02-09 06:58:00	SPY	ETF	229.7	229.73	229.7	229.73	15400.0
2017-02-09 07:00:00	SPY	ETF	229.7	229.7	229.7	229.7	501.0
2017-02-09 07:01:00	SPY	ETF	229.68	229.7	229.68	229.7	2001.0
2017-02-09 07:03:00	SPY	ETF	229.69	229.69	229.69	229.69	100.0
2017-02-09 07:04:00	SPY	ETF	229.69	229.71	229.69	229.71	15000.0
2017-02-09 07:06:00	SPY	ETF	229.69	229.69	229.69	229.69	520.0
2017-02-09 07:07:00	SPY	ETF	229.69	229.73	229.69	229.73	940.0
2017-02-09 07:08:00	SPY	ETF	229.68	229.7	229.68	229.7	500.0
2017-02-09 07:10:00	SPY	ETF	229.68	229.7	229.68	229.7	2202.0
2017-02-09 07:11:00	SPY	ETF	229.67	229.67	229.67	229.67	100.0

> showing 50 of 146,518 rows — these rows as CSV

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