PREVIEW / etf_1min / 2017-06-06

all etf 1-min files

  file:    by_date/etf_1min/2017/2017-06-06.parquet
  size:    2.6 MB
  rows:    137,737

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-06-06 04:00:00	SPY	ETF	243.73	243.73	243.71	243.71	3123.0
2017-06-06 04:02:00	SPY	ETF	243.71	243.71	243.69	243.69	930.0
2017-06-06 04:03:00	SPY	ETF	243.63	243.63	243.63	243.63	240.0
2017-06-06 04:04:00	SPY	ETF	243.63	243.63	243.63	243.63	400.0
2017-06-06 04:06:00	SPY	ETF	243.68	243.68	243.63	243.63	400.0
2017-06-06 04:09:00	SPY	ETF	243.64	243.64	243.64	243.64	200.0
2017-06-06 04:10:00	SPY	ETF	243.63	243.63	243.63	243.63	377.0
2017-06-06 04:11:00	SPY	ETF	243.63	243.63	243.63	243.63	823.0
2017-06-06 04:18:00	SPY	ETF	243.51	243.53	243.51	243.53	5600.0
2017-06-06 04:19:00	SPY	ETF	243.53	243.53	243.53	243.53	34800.0
2017-06-06 04:22:00	SPY	ETF	243.52	243.52	243.5	243.5	460.0
2017-06-06 04:31:00	SPY	ETF	243.55	243.55	243.55	243.55	300.0
2017-06-06 04:32:00	SPY	ETF	243.55	243.55	243.55	243.55	200.0
2017-06-06 04:38:00	SPY	ETF	243.6	243.6	243.6	243.6	300.0
2017-06-06 04:41:00	SPY	ETF	243.68	243.68	243.68	243.68	260.0
2017-06-06 04:52:00	SPY	ETF	243.69	243.69	243.69	243.69	300.0
2017-06-06 04:55:00	SPY	ETF	243.65	243.65	243.65	243.65	300.0
2017-06-06 05:03:00	SPY	ETF	243.65	243.65	243.65	243.65	100.0
2017-06-06 05:04:00	SPY	ETF	243.67	243.67	243.59	243.59	1400.0
2017-06-06 05:10:00	SPY	ETF	243.6	243.6	243.6	243.6	300.0
2017-06-06 05:11:00	SPY	ETF	243.55	243.55	243.55	243.55	910.0
2017-06-06 05:31:00	SPY	ETF	243.6	243.6	243.6	243.6	300.0
2017-06-06 05:40:00	SPY	ETF	243.56	243.56	243.55	243.55	591.0
2017-06-06 05:47:00	SPY	ETF	243.6	243.6	243.6	243.6	400.0
2017-06-06 05:56:00	SPY	ETF	243.61	243.61	243.61	243.61	300.0
2017-06-06 05:59:00	SPY	ETF	243.57	243.57	243.57	243.57	300.0
2017-06-06 06:12:00	SPY	ETF	243.52	243.55	243.52	243.55	300.0
2017-06-06 06:13:00	SPY	ETF	243.52	243.55	243.52	243.52	500.0
2017-06-06 06:15:00	SPY	ETF	243.54	243.54	243.54	243.54	130.0
2017-06-06 06:18:00	SPY	ETF	243.56	243.56	243.56	243.56	500.0
2017-06-06 06:19:00	SPY	ETF	243.57	243.57	243.57	243.57	300.0
2017-06-06 06:28:00	SPY	ETF	243.5	243.5	243.5	243.5	200.0
2017-06-06 06:30:00	SPY	ETF	243.48	243.48	243.48	243.48	500.0
2017-06-06 06:35:00	SPY	ETF	243.44	243.44	243.43	243.43	400.0
2017-06-06 06:40:00	SPY	ETF	243.5	243.5	243.49	243.49	1300.0
2017-06-06 06:44:00	SPY	ETF	243.46	243.46	243.42	243.42	800.0
2017-06-06 06:49:00	SPY	ETF	243.4	243.4	243.4	243.4	1035.0
2017-06-06 06:50:00	SPY	ETF	243.4	243.4	243.4	243.4	100.0
2017-06-06 06:51:00	SPY	ETF	243.4	243.4	243.39	243.39	15000.0
2017-06-06 06:52:00	SPY	ETF	243.39	243.39	243.38	243.38	35100.0
2017-06-06 06:54:00	SPY	ETF	243.42	243.42	243.42	243.42	400.0
2017-06-06 06:56:00	SPY	ETF	243.42	243.42	243.42	243.42	500.0
2017-06-06 06:57:00	SPY	ETF	243.41	243.41	243.4	243.4	600.0
2017-06-06 06:58:00	SPY	ETF	243.4	243.4	243.4	243.4	100.0
2017-06-06 07:00:00	SPY	ETF	243.42	243.43	243.42	243.43	23400.0
2017-06-06 07:01:00	SPY	ETF	243.43	243.43	243.4	243.4	7110.0
2017-06-06 07:02:00	SPY	ETF	243.4	243.4	243.4	243.4	1669.0
2017-06-06 07:05:00	SPY	ETF	243.41	243.41	243.35	243.35	36400.0
2017-06-06 07:07:00	SPY	ETF	243.35	243.35	243.35	243.35	669.0
2017-06-06 07:10:00	SPY	ETF	243.35	243.37	243.35	243.37	3020.0

> showing 50 of 137,737 rows — these rows as CSV

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