PREVIEW / etf_1min / 2020-08-17

all etf 1-min files

  file:    by_date/etf_1min/2020/2020-08-17.parquet
  size:    3.5 MB
  rows:    193,377

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
2020-08-17 04:00:00	SPY	ETF	337.44	337.54	337.44	337.54	693.0
2020-08-17 04:01:00	SPY	ETF	337.47	337.47	337.47	337.47	150.0
2020-08-17 04:04:00	SPY	ETF	337.01	337.01	337.01	337.01	273.0
2020-08-17 04:11:00	SPY	ETF	337.26	337.26	337.26	337.26	267.0
2020-08-17 04:15:00	SPY	ETF	337.15	337.15	337.15	337.15	425.0
2020-08-17 04:16:00	SPY	ETF	337.1	337.1	337.1	337.1	106.0
2020-08-17 04:24:00	SPY	ETF	337.18	337.18	337.18	337.18	100.0
2020-08-17 04:30:00	SPY	ETF	337.05	337.05	337.05	337.05	205.0
2020-08-17 04:39:00	SPY	ETF	337.1	337.1	337.1	337.1	700.0
2020-08-17 04:40:00	SPY	ETF	337.06	337.06	337.0	337.0	1320.0
2020-08-17 04:42:00	SPY	ETF	337.07	337.1	337.07	337.1	1650.0
2020-08-17 04:43:00	SPY	ETF	337.3	337.3	337.3	337.3	981.0
2020-08-17 04:48:00	SPY	ETF	337.3	337.3	337.3	337.3	851.0
2020-08-17 04:50:00	SPY	ETF	337.3	337.3	337.3	337.3	300.0
2020-08-17 04:51:00	SPY	ETF	337.26	337.29	337.26	337.29	15000.0
2020-08-17 04:52:00	SPY	ETF	337.3	337.3	337.3	337.3	300.0
2020-08-17 04:53:00	SPY	ETF	337.25	337.26	337.25	337.26	1150.0
2020-08-17 04:57:00	SPY	ETF	337.32	337.32	337.32	337.32	100.0
2020-08-17 04:58:00	SPY	ETF	337.32	337.32	337.32	337.32	100.0
2020-08-17 05:03:00	SPY	ETF	337.48	337.48	337.48	337.48	202.0
2020-08-17 05:04:00	SPY	ETF	337.46	337.46	337.46	337.46	106.0
2020-08-17 05:05:00	SPY	ETF	337.4	337.4	337.4	337.4	101.0
2020-08-17 05:08:00	SPY	ETF	337.45	337.45	337.45	337.45	330.0
2020-08-17 05:11:00	SPY	ETF	337.5	337.51	337.5	337.51	700.0
2020-08-17 05:19:00	SPY	ETF	337.57	337.63	337.57	337.63	405.0
2020-08-17 05:20:00	SPY	ETF	337.68	337.68	337.68	337.68	300.0
2020-08-17 05:21:00	SPY	ETF	337.7	337.7	337.65	337.68	400.0
2020-08-17 05:24:00	SPY	ETF	337.6	337.6	337.6	337.6	100.0
2020-08-17 05:26:00	SPY	ETF	337.56	337.56	337.56	337.56	130.0
2020-08-17 05:33:00	SPY	ETF	337.46	337.47	337.46	337.47	1250.0
2020-08-17 05:36:00	SPY	ETF	337.38	337.38	337.38	337.38	298.0
2020-08-17 05:39:00	SPY	ETF	337.34	337.34	337.34	337.34	121.0
2020-08-17 05:41:00	SPY	ETF	337.35	337.35	337.35	337.35	200.0
2020-08-17 05:44:00	SPY	ETF	337.39	337.39	337.39	337.39	107.0
2020-08-17 05:46:00	SPY	ETF	337.39	337.41	337.39	337.41	300.0
2020-08-17 05:47:00	SPY	ETF	337.37	337.42	337.37	337.42	201.0
2020-08-17 05:51:00	SPY	ETF	337.28	337.28	337.2	337.2	670.0
2020-08-17 05:52:00	SPY	ETF	337.26	337.26	337.26	337.26	100.0
2020-08-17 05:59:00	SPY	ETF	337.31	337.31	337.31	337.31	675.0
2020-08-17 06:00:00	SPY	ETF	337.31	337.32	337.31	337.32	900.0
2020-08-17 06:03:00	SPY	ETF	337.34	337.36	337.34	337.36	3910.0
2020-08-17 06:06:00	SPY	ETF	337.28	337.28	337.28	337.28	501.0
2020-08-17 06:11:00	SPY	ETF	337.41	337.41	337.41	337.41	600.0
2020-08-17 06:13:00	SPY	ETF	337.37	337.37	337.37	337.37	2000.0
2020-08-17 06:15:00	SPY	ETF	337.31	337.31	337.31	337.31	600.0
2020-08-17 06:16:00	SPY	ETF	337.27	337.29	337.27	337.27	550.0
2020-08-17 06:18:00	SPY	ETF	337.29	337.29	337.29	337.29	210.0
2020-08-17 06:21:00	SPY	ETF	337.22	337.22	337.21	337.22	2004.0
2020-08-17 06:25:00	SPY	ETF	337.2	337.2	337.2	337.2	300.0
2020-08-17 06:26:00	SPY	ETF	337.26	337.26	337.26	337.26	200.0

> showing 50 of 193,377 rows — these rows as CSV

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