PREVIEW / etf_1min / 2019-07-09

all etf 1-min files

  file:    by_date/etf_1min/2019/2019-07-09.parquet
  size:    2.9 MB
  rows:    156,533

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-07-09 04:00:00	SPY	ETF	295.39	295.39	295.39	295.39	700.0
2019-07-09 04:02:00	SPY	ETF	295.45	295.48	295.45	295.48	700.0
2019-07-09 04:03:00	SPY	ETF	295.48	295.48	295.48	295.48	150.0
2019-07-09 04:05:00	SPY	ETF	295.38	295.38	295.38	295.38	150.0
2019-07-09 04:06:00	SPY	ETF	295.37	295.37	295.35	295.35	300.0
2019-07-09 04:07:00	SPY	ETF	295.33	295.33	295.33	295.33	100.0
2019-07-09 04:10:00	SPY	ETF	295.31	295.31	295.31	295.31	200.0
2019-07-09 04:21:00	SPY	ETF	295.4	295.4	295.4	295.4	2300.0
2019-07-09 04:26:00	SPY	ETF	295.48	295.5	295.48	295.5	400.0
2019-07-09 04:32:00	SPY	ETF	295.45	295.45	295.45	295.45	300.0
2019-07-09 04:38:00	SPY	ETF	295.45	295.45	295.45	295.45	100.0
2019-07-09 04:43:00	SPY	ETF	295.45	295.45	295.45	295.45	100.0
2019-07-09 04:44:00	SPY	ETF	295.33	295.33	295.33	295.33	100.0
2019-07-09 04:46:00	SPY	ETF	295.3	295.38	295.3	295.32	1003.0
2019-07-09 04:52:00	SPY	ETF	295.5	295.5	295.5	295.5	377.0
2019-07-09 04:59:00	SPY	ETF	295.5	295.51	295.5	295.5	2475.0
2019-07-09 05:00:00	SPY	ETF	295.5	295.5	295.5	295.5	407.0
2019-07-09 05:02:00	SPY	ETF	295.49	295.49	295.48	295.48	1001.0
2019-07-09 05:07:00	SPY	ETF	295.53	295.55	295.47	295.47	11038.0
2019-07-09 05:10:00	SPY	ETF	295.48	295.48	295.46	295.46	438.0
2019-07-09 05:11:00	SPY	ETF	295.4	295.4	295.35	295.35	369.0
2019-07-09 05:12:00	SPY	ETF	295.31	295.31	295.31	295.31	169.0
2019-07-09 05:15:00	SPY	ETF	295.36	295.36	295.36	295.36	169.0
2019-07-09 05:17:00	SPY	ETF	295.38	295.38	295.38	295.38	121.0
2019-07-09 05:20:00	SPY	ETF	295.38	295.38	295.38	295.38	100.0
2019-07-09 05:26:00	SPY	ETF	295.4	295.4	295.4	295.4	220.0
2019-07-09 05:27:00	SPY	ETF	295.4	295.4	295.4	295.4	100.0
2019-07-09 05:28:00	SPY	ETF	295.4	295.4	295.38	295.38	800.0
2019-07-09 05:31:00	SPY	ETF	295.35	295.35	295.33	295.33	2000.0
2019-07-09 05:32:00	SPY	ETF	295.34	295.34	295.34	295.34	1000.0
2019-07-09 05:33:00	SPY	ETF	295.31	295.31	295.31	295.31	300.0
2019-07-09 05:51:00	SPY	ETF	295.35	295.35	295.33	295.33	800.0
2019-07-09 05:52:00	SPY	ETF	295.41	295.41	295.41	295.41	600.0
2019-07-09 05:53:00	SPY	ETF	295.4	295.4	295.4	295.4	200.0
2019-07-09 05:59:00	SPY	ETF	295.48	295.48	295.41	295.43	2443.0
2019-07-09 06:01:00	SPY	ETF	295.41	295.41	295.33	295.33	2951.0
2019-07-09 06:08:00	SPY	ETF	295.51	295.51	295.51	295.51	2500.0
2019-07-09 06:09:00	SPY	ETF	295.48	295.53	295.48	295.53	600.0
2019-07-09 06:13:00	SPY	ETF	295.58	295.58	295.5	295.5	1900.0
2019-07-09 06:15:00	SPY	ETF	295.53	295.53	295.53	295.53	970.0
2019-07-09 06:20:00	SPY	ETF	295.46	295.46	295.46	295.46	323.0
2019-07-09 06:24:00	SPY	ETF	295.55	295.56	295.55	295.56	1200.0
2019-07-09 06:26:00	SPY	ETF	295.55	295.58	295.5	295.53	4000.0
2019-07-09 06:31:00	SPY	ETF	295.62	295.69	295.62	295.69	1760.0
2019-07-09 06:33:00	SPY	ETF	295.66	295.66	295.66	295.66	300.0
2019-07-09 06:34:00	SPY	ETF	295.63	295.63	295.63	295.63	600.0
2019-07-09 06:35:00	SPY	ETF	295.63	295.71	295.63	295.71	1100.0
2019-07-09 06:36:00	SPY	ETF	295.71	295.71	295.66	295.66	1519.0
2019-07-09 06:38:00	SPY	ETF	295.71	295.71	295.68	295.68	450.0
2019-07-09 06:39:00	SPY	ETF	295.71	295.71	295.71	295.71	500.0

> showing 50 of 156,533 rows — these rows as CSV

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