PREVIEW / etf_1min / 2019-06-28

all etf 1-min files

  file:    by_date/etf_1min/2019/2019-06-28.parquet
  size:    3.1 MB
  rows:    165,040

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
2019-06-28 04:00:00	SPY	ETF	292.37	292.37	292.36	292.36	453.0
2019-06-28 04:08:00	SPY	ETF	292.35	292.35	292.35	292.35	100.0
2019-06-28 04:12:00	SPY	ETF	292.41	292.41	292.38	292.38	700.0
2019-06-28 04:13:00	SPY	ETF	292.41	292.46	292.41	292.46	507.0
2019-06-28 04:14:00	SPY	ETF	292.46	292.46	292.46	292.46	338.0
2019-06-28 04:15:00	SPY	ETF	292.48	292.53	292.48	292.53	1006.0
2019-06-28 04:16:00	SPY	ETF	292.54	292.58	292.54	292.56	1150.0
2019-06-28 04:17:00	SPY	ETF	292.58	292.58	292.56	292.56	2469.0
2019-06-28 04:19:00	SPY	ETF	292.53	292.53	292.53	292.53	320.0
2019-06-28 04:24:00	SPY	ETF	292.54	292.54	292.53	292.53	338.0
2019-06-28 04:25:00	SPY	ETF	292.56	292.56	292.56	292.56	169.0
2019-06-28 04:26:00	SPY	ETF	292.58	292.59	292.58	292.59	369.0
2019-06-28 04:29:00	SPY	ETF	292.56	292.56	292.56	292.56	200.0
2019-06-28 04:30:00	SPY	ETF	292.59	292.61	292.59	292.61	638.0
2019-06-28 04:31:00	SPY	ETF	292.61	292.61	292.61	292.61	150.0
2019-06-28 04:37:00	SPY	ETF	292.61	292.61	292.61	292.61	169.0
2019-06-28 04:42:00	SPY	ETF	292.64	292.68	292.64	292.68	338.0
2019-06-28 04:46:00	SPY	ETF	292.61	292.61	292.61	292.61	2000.0
2019-06-28 04:57:00	SPY	ETF	292.53	292.53	292.53	292.53	300.0
2019-06-28 04:58:00	SPY	ETF	292.54	292.54	292.53	292.53	369.0
2019-06-28 05:01:00	SPY	ETF	292.58	292.58	292.58	292.58	1000.0
2019-06-28 05:02:00	SPY	ETF	292.53	292.53	292.53	292.53	300.0
2019-06-28 05:03:00	SPY	ETF	292.53	292.53	292.53	292.53	300.0
2019-06-28 05:05:00	SPY	ETF	292.55	292.55	292.5	292.5	1069.0
2019-06-28 05:11:00	SPY	ETF	292.55	292.55	292.55	292.55	400.0
2019-06-28 05:12:00	SPY	ETF	292.55	292.55	292.55	292.55	600.0
2019-06-28 05:14:00	SPY	ETF	292.63	292.65	292.63	292.64	1100.0
2019-06-28 05:15:00	SPY	ETF	292.66	292.66	292.66	292.66	169.0
2019-06-28 05:17:00	SPY	ETF	292.65	292.65	292.65	292.65	300.0
2019-06-28 05:18:00	SPY	ETF	292.65	292.65	292.65	292.65	1000.0
2019-06-28 05:21:00	SPY	ETF	292.6	292.6	292.6	292.6	1000.0
2019-06-28 05:22:00	SPY	ETF	292.62	292.62	292.58	292.58	1017.0
2019-06-28 05:24:00	SPY	ETF	292.63	292.63	292.58	292.58	2200.0
2019-06-28 05:30:00	SPY	ETF	292.6	292.6	292.6	292.6	300.0
2019-06-28 05:32:00	SPY	ETF	292.6	292.6	292.6	292.6	1705.0
2019-06-28 05:35:00	SPY	ETF	292.58	292.59	292.58	292.58	1400.0
2019-06-28 05:37:00	SPY	ETF	292.63	292.63	292.63	292.63	100.0
2019-06-28 05:39:00	SPY	ETF	292.58	292.58	292.58	292.58	400.0
2019-06-28 05:44:00	SPY	ETF	292.58	292.58	292.53	292.58	1500.0
2019-06-28 05:45:00	SPY	ETF	292.56	292.56	292.55	292.55	1300.0
2019-06-28 05:46:00	SPY	ETF	292.55	292.55	292.55	292.55	300.0
2019-06-28 05:50:00	SPY	ETF	292.56	292.63	292.56	292.63	1000.0
2019-06-28 05:51:00	SPY	ETF	292.68	292.68	292.68	292.68	600.0
2019-06-28 05:52:00	SPY	ETF	292.63	292.71	292.63	292.71	600.0
2019-06-28 05:53:00	SPY	ETF	292.72	292.73	292.72	292.73	600.0
2019-06-28 05:54:00	SPY	ETF	292.73	292.73	292.68	292.73	3100.0
2019-06-28 05:56:00	SPY	ETF	292.69	292.69	292.63	292.63	1600.0
2019-06-28 06:01:00	SPY	ETF	292.63	292.63	292.63	292.63	1000.0
2019-06-28 06:02:00	SPY	ETF	292.61	292.61	292.61	292.61	1000.0
2019-06-28 06:06:00	SPY	ETF	292.61	292.61	292.6	292.6	1300.0

> showing 50 of 165,040 rows — these rows as CSV

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