PREVIEW / etf_1min / 2017-01-19

all etf 1-min files

  file:    by_date/etf_1min/2017/2017-01-19.parquet
  size:    2.8 MB
  rows:    148,004

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-01-19 04:09:00	SPY	ETF	226.58	226.58	226.57	226.57	600.0
2017-01-19 04:22:00	SPY	ETF	226.56	226.56	226.56	226.56	100.0
2017-01-19 04:53:00	SPY	ETF	226.39	226.39	226.39	226.39	501.0
2017-01-19 04:58:00	SPY	ETF	226.41	226.41	226.41	226.41	300.0
2017-01-19 05:02:00	SPY	ETF	226.33	226.33	226.33	226.33	300.0
2017-01-19 05:03:00	SPY	ETF	226.32	226.32	226.32	226.32	150.0
2017-01-19 05:06:00	SPY	ETF	226.28	226.28	226.25	226.25	314.0
2017-01-19 05:11:00	SPY	ETF	226.25	226.25	226.25	226.25	301.0
2017-01-19 05:13:00	SPY	ETF	226.27	226.27	226.27	226.27	502.0
2017-01-19 05:33:00	SPY	ETF	226.32	226.32	226.32	226.32	250.0
2017-01-19 05:38:00	SPY	ETF	226.34	226.34	226.34	226.34	2500.0
2017-01-19 05:58:00	SPY	ETF	226.36	226.36	226.36	226.36	1000.0
2017-01-19 06:01:00	SPY	ETF	226.35	226.35	226.35	226.35	302.0
2017-01-19 06:02:00	SPY	ETF	226.35	226.35	226.35	226.35	1000.0
2017-01-19 06:03:00	SPY	ETF	226.35	226.36	226.35	226.36	201.0
2017-01-19 06:05:00	SPY	ETF	226.4	226.42	226.4	226.42	1738.0
2017-01-19 06:11:00	SPY	ETF	226.49	226.5	226.49	226.5	2703.0
2017-01-19 06:13:00	SPY	ETF	226.52	226.52	226.52	226.52	300.0
2017-01-19 06:16:00	SPY	ETF	226.5	226.5	226.49	226.49	1500.0
2017-01-19 06:25:00	SPY	ETF	226.55	226.56	226.55	226.56	18301.0
2017-01-19 06:29:00	SPY	ETF	226.56	226.56	226.56	226.56	250.0
2017-01-19 06:31:00	SPY	ETF	226.56	226.56	226.55	226.55	500.0
2017-01-19 06:33:00	SPY	ETF	226.56	226.56	226.56	226.56	100.0
2017-01-19 06:36:00	SPY	ETF	226.56	226.56	226.56	226.56	250.0
2017-01-19 06:43:00	SPY	ETF	226.56	226.56	226.56	226.56	500.0
2017-01-19 06:45:00	SPY	ETF	226.56	226.56	226.56	226.56	351.0
2017-01-19 06:48:00	SPY	ETF	226.56	226.56	226.56	226.56	1160.0
2017-01-19 06:51:00	SPY	ETF	226.53	226.53	226.53	226.53	102.0
2017-01-19 07:00:00	SPY	ETF	226.58	226.59	226.57	226.57	6800.0
2017-01-19 07:01:00	SPY	ETF	226.59	226.59	226.56	226.56	1900.0
2017-01-19 07:02:00	SPY	ETF	226.59	226.59	226.59	226.59	600.0
2017-01-19 07:03:00	SPY	ETF	226.57	226.57	226.56	226.56	10000.0
2017-01-19 07:05:00	SPY	ETF	226.59	226.59	226.59	226.59	2250.0
2017-01-19 07:08:00	SPY	ETF	226.59	226.59	226.59	226.59	1000.0
2017-01-19 07:09:00	SPY	ETF	226.57	226.57	226.56	226.56	600.0
2017-01-19 07:10:00	SPY	ETF	226.55	226.55	226.55	226.55	125.0
2017-01-19 07:11:00	SPY	ETF	226.56	226.56	226.55	226.56	804.0
2017-01-19 07:12:00	SPY	ETF	226.55	226.55	226.55	226.55	500.0
2017-01-19 07:14:00	SPY	ETF	226.56	226.56	226.56	226.56	2103.0
2017-01-19 07:16:00	SPY	ETF	226.56	226.56	226.56	226.56	100.0
2017-01-19 07:17:00	SPY	ETF	226.55	226.55	226.55	226.55	601.0
2017-01-19 07:23:00	SPY	ETF	226.55	226.55	226.55	226.55	400.0
2017-01-19 07:27:00	SPY	ETF	226.56	226.56	226.56	226.56	3781.0
2017-01-19 07:30:00	SPY	ETF	226.52	226.52	226.52	226.52	200.0
2017-01-19 07:31:00	SPY	ETF	226.52	226.52	226.52	226.52	1600.0
2017-01-19 07:32:00	SPY	ETF	226.53	226.53	226.53	226.53	1000.0
2017-01-19 07:33:00	SPY	ETF	226.53	226.53	226.53	226.53	880.0
2017-01-19 07:36:00	SPY	ETF	226.51	226.51	226.5	226.5	2500.0
2017-01-19 07:38:00	SPY	ETF	226.5	226.5	226.5	226.5	3000.0
2017-01-19 07:42:00	SPY	ETF	226.56	226.56	226.56	226.56	3000.0

> showing 50 of 148,004 rows — these rows as CSV

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