PREVIEW / etf_1min / 2019-07-05

all etf 1-min files

  file:    by_date/etf_1min/2019/2019-07-05.parquet
  size:    2.9 MB
  rows:    155,690

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-05 04:03:00	SPY	ETF	298.74	298.74	298.68	298.68	500.0
2019-07-05 04:04:00	SPY	ETF	298.67	298.67	298.67	298.67	160.0
2019-07-05 04:05:00	SPY	ETF	298.67	298.67	298.67	298.67	220.0
2019-07-05 04:07:00	SPY	ETF	298.63	298.63	298.57	298.57	1300.0
2019-07-05 04:08:00	SPY	ETF	298.61	298.61	298.61	298.61	100.0
2019-07-05 04:10:00	SPY	ETF	298.57	298.57	298.57	298.57	300.0
2019-07-05 04:11:00	SPY	ETF	298.59	298.59	298.59	298.59	450.0
2019-07-05 04:13:00	SPY	ETF	298.62	298.62	298.62	298.62	100.0
2019-07-05 04:14:00	SPY	ETF	298.63	298.63	298.63	298.63	1000.0
2019-07-05 04:15:00	SPY	ETF	298.63	298.63	298.53	298.53	3300.0
2019-07-05 04:18:00	SPY	ETF	298.58	298.58	298.58	298.58	300.0
2019-07-05 04:20:00	SPY	ETF	298.63	298.63	298.63	298.63	500.0
2019-07-05 04:21:00	SPY	ETF	298.56	298.56	298.56	298.56	400.0
2019-07-05 04:25:00	SPY	ETF	298.55	298.55	298.55	298.55	2500.0
2019-07-05 04:28:00	SPY	ETF	298.57	298.57	298.57	298.57	400.0
2019-07-05 04:30:00	SPY	ETF	298.57	298.57	298.57	298.57	500.0
2019-07-05 04:32:00	SPY	ETF	298.62	298.62	298.62	298.62	300.0
2019-07-05 04:33:00	SPY	ETF	298.62	298.65	298.62	298.65	900.0
2019-07-05 04:34:00	SPY	ETF	298.65	298.65	298.65	298.65	100.0
2019-07-05 04:35:00	SPY	ETF	298.63	298.63	298.63	298.63	400.0
2019-07-05 04:36:00	SPY	ETF	298.58	298.58	298.58	298.58	204.0
2019-07-05 04:38:00	SPY	ETF	298.52	298.52	298.43	298.45	1910.0
2019-07-05 04:43:00	SPY	ETF	298.5	298.5	298.5	298.5	220.0
2019-07-05 04:45:00	SPY	ETF	298.5	298.5	298.5	298.5	205.0
2019-07-05 04:53:00	SPY	ETF	298.34	298.34	298.34	298.34	500.0
2019-07-05 04:55:00	SPY	ETF	298.38	298.38	298.38	298.38	318.0
2019-07-05 04:56:00	SPY	ETF	298.38	298.38	298.38	298.38	100.0
2019-07-05 04:57:00	SPY	ETF	298.33	298.33	298.33	298.33	500.0
2019-07-05 04:59:00	SPY	ETF	298.28	298.28	298.21	298.21	1500.0
2019-07-05 05:03:00	SPY	ETF	298.33	298.35	298.33	298.35	2347.0
2019-07-05 05:06:00	SPY	ETF	298.37	298.37	298.37	298.37	247.0
2019-07-05 05:14:00	SPY	ETF	298.34	298.34	298.34	298.34	100.0
2019-07-05 05:24:00	SPY	ETF	298.43	298.43	298.43	298.43	500.0
2019-07-05 05:25:00	SPY	ETF	298.43	298.43	298.43	298.43	500.0
2019-07-05 05:27:00	SPY	ETF	298.4	298.4	298.4	298.4	300.0
2019-07-05 05:28:00	SPY	ETF	298.37	298.37	298.37	298.37	1900.0
2019-07-05 05:47:00	SPY	ETF	298.4	298.4	298.4	298.4	150.0
2019-07-05 05:48:00	SPY	ETF	298.35	298.35	298.35	298.35	669.0
2019-07-05 05:49:00	SPY	ETF	298.33	298.33	298.33	298.33	300.0
2019-07-05 05:52:00	SPY	ETF	298.35	298.35	298.35	298.35	100.0
2019-07-05 05:53:00	SPY	ETF	298.33	298.33	298.33	298.33	300.0
2019-07-05 05:55:00	SPY	ETF	298.32	298.32	298.32	298.32	369.0
2019-07-05 05:57:00	SPY	ETF	298.29	298.3	298.29	298.3	569.0
2019-07-05 05:58:00	SPY	ETF	298.25	298.25	298.23	298.25	1200.0
2019-07-05 05:59:00	SPY	ETF	298.25	298.28	298.25	298.28	800.0
2019-07-05 06:00:00	SPY	ETF	298.23	298.23	298.23	298.23	200.0
2019-07-05 06:03:00	SPY	ETF	298.35	298.35	298.35	298.35	100.0
2019-07-05 06:05:00	SPY	ETF	298.35	298.35	298.35	298.35	1070.0
2019-07-05 06:15:00	SPY	ETF	298.36	298.36	298.36	298.36	205.0
2019-07-05 06:16:00	SPY	ETF	298.35	298.35	298.35	298.35	100.0

> showing 50 of 155,690 rows — these rows as CSV

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