PREVIEW / etf_1min / 2019-12-31

all etf 1-min files

  file:    by_date/etf_1min/2019/2019-12-31.parquet
  size:    3.2 MB
  rows:    168,988

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-12-31 04:07:00	SPY	ETF	321.42	321.42	321.42	321.42	100.0
2019-12-31 04:16:00	SPY	ETF	321.42	321.42	321.42	321.42	890.0
2019-12-31 04:20:00	SPY	ETF	321.41	321.41	321.4	321.4	2010.0
2019-12-31 04:21:00	SPY	ETF	321.42	321.43	321.42	321.43	1050.0
2019-12-31 04:35:00	SPY	ETF	321.44	321.44	321.44	321.44	100.0
2019-12-31 04:37:00	SPY	ETF	321.42	321.42	321.42	321.42	500.0
2019-12-31 04:40:00	SPY	ETF	321.37	321.37	321.37	321.37	1000.0
2019-12-31 04:55:00	SPY	ETF	321.39	321.39	321.39	321.39	400.0
2019-12-31 04:57:00	SPY	ETF	321.4	321.4	321.4	321.4	500.0
2019-12-31 05:00:00	SPY	ETF	321.4	321.4	321.4	321.4	200.0
2019-12-31 05:01:00	SPY	ETF	321.36	321.36	321.35	321.35	900.0
2019-12-31 05:02:00	SPY	ETF	321.43	321.46	321.43	321.46	600.0
2019-12-31 05:17:00	SPY	ETF	321.51	321.51	321.51	321.51	315.0
2019-12-31 05:23:00	SPY	ETF	321.51	321.51	321.51	321.51	100.0
2019-12-31 05:33:00	SPY	ETF	321.6	321.6	321.6	321.6	500.0
2019-12-31 05:39:00	SPY	ETF	321.65	321.65	321.65	321.65	300.0
2019-12-31 05:40:00	SPY	ETF	321.65	321.65	321.65	321.65	300.0
2019-12-31 05:41:00	SPY	ETF	321.63	321.63	321.63	321.63	100.0
2019-12-31 05:46:00	SPY	ETF	321.56	321.56	321.56	321.56	200.0
2019-12-31 05:48:00	SPY	ETF	321.57	321.6	321.57	321.6	600.0
2019-12-31 06:06:00	SPY	ETF	321.6	321.6	321.6	321.6	300.0
2019-12-31 06:15:00	SPY	ETF	321.48	321.48	321.48	321.48	500.0
2019-12-31 06:17:00	SPY	ETF	321.45	321.45	321.43	321.43	801.0
2019-12-31 06:21:00	SPY	ETF	321.41	321.41	321.41	321.41	300.0
2019-12-31 06:22:00	SPY	ETF	321.37	321.37	321.37	321.37	100.0
2019-12-31 06:23:00	SPY	ETF	321.36	321.36	321.34	321.34	600.0
2019-12-31 06:31:00	SPY	ETF	321.39	321.39	321.39	321.39	130.0
2019-12-31 06:38:00	SPY	ETF	321.39	321.39	321.39	321.39	226.0
2019-12-31 06:40:00	SPY	ETF	321.36	321.36	321.36	321.36	100.0
2019-12-31 06:45:00	SPY	ETF	321.36	321.37	321.36	321.37	1100.0
2019-12-31 06:46:00	SPY	ETF	321.36	321.36	321.36	321.36	600.0
2019-12-31 06:47:00	SPY	ETF	321.34	321.34	321.34	321.34	198.0
2019-12-31 06:48:00	SPY	ETF	321.31	321.31	321.31	321.31	1000.0
2019-12-31 06:51:00	SPY	ETF	321.35	321.35	321.35	321.35	500.0
2019-12-31 06:53:00	SPY	ETF	321.29	321.29	321.29	321.29	200.0
2019-12-31 06:57:00	SPY	ETF	321.2	321.2	321.2	321.2	100.0
2019-12-31 06:59:00	SPY	ETF	321.23	321.23	321.23	321.23	1000.0
2019-12-31 07:00:00	SPY	ETF	321.3	321.3	321.3	321.3	506.0
2019-12-31 07:01:00	SPY	ETF	321.3	321.3	321.26	321.27	5600.0
2019-12-31 07:02:00	SPY	ETF	321.27	321.28	321.27	321.28	7900.0
2019-12-31 07:04:00	SPY	ETF	321.27	321.27	321.27	321.27	423.0
2019-12-31 07:05:00	SPY	ETF	321.26	321.26	321.26	321.26	3000.0
2019-12-31 07:06:00	SPY	ETF	321.21	321.21	321.21	321.21	100.0
2019-12-31 07:07:00	SPY	ETF	321.17	321.17	321.07	321.09	3608.0
2019-12-31 07:08:00	SPY	ETF	321.01	321.01	321.0	321.0	1741.0
2019-12-31 07:09:00	SPY	ETF	321.0	321.0	321.0	321.0	787.0
2019-12-31 07:10:00	SPY	ETF	321.03	321.08	321.03	321.08	3250.0
2019-12-31 07:14:00	SPY	ETF	321.05	321.05	321.05	321.05	500.0
2019-12-31 07:15:00	SPY	ETF	321.0	321.01	320.99	321.01	1000.0
2019-12-31 07:16:00	SPY	ETF	321.0	321.0	320.99	320.99	1500.0

> showing 50 of 168,988 rows — these rows as CSV

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