PREVIEW / etf_1min / 2021-06-16

all etf 1-min files

  file:    by_date/etf_1min/2021/2021-06-16.parquet
  size:    3.9 MB
  rows:    219,141

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
2021-06-16 04:00:00	SPY	ETF	424.22	424.22	424.18	424.18	785.0
2021-06-16 04:01:00	SPY	ETF	424.15	424.18	424.15	424.18	600.0
2021-06-16 04:11:00	SPY	ETF	424.15	424.15	424.15	424.15	100.0
2021-06-16 04:16:00	SPY	ETF	424.1	424.1	424.1	424.1	100.0
2021-06-16 04:25:00	SPY	ETF	424.07	424.07	424.07	424.07	100.0
2021-06-16 04:26:00	SPY	ETF	424.05	424.05	424.05	424.05	100.0
2021-06-16 04:27:00	SPY	ETF	424.0	424.0	424.0	424.0	1130.0
2021-06-16 04:30:00	SPY	ETF	423.88	423.88	423.88	423.88	699.0
2021-06-16 04:33:00	SPY	ETF	423.91	423.91	423.91	423.91	300.0
2021-06-16 04:39:00	SPY	ETF	424.02	424.02	424.02	424.02	120.0
2021-06-16 04:45:00	SPY	ETF	424.11	424.11	424.11	424.11	200.0
2021-06-16 04:46:00	SPY	ETF	424.16	424.17	424.16	424.17	400.0
2021-06-16 04:48:00	SPY	ETF	424.17	424.17	424.17	424.17	400.0
2021-06-16 04:55:00	SPY	ETF	424.23	424.23	424.23	424.23	100.0
2021-06-16 04:57:00	SPY	ETF	424.23	424.23	424.23	424.23	4000.0
2021-06-16 04:58:00	SPY	ETF	424.22	424.22	424.22	424.22	300.0
2021-06-16 05:01:00	SPY	ETF	424.3	424.3	424.3	424.3	200.0
2021-06-16 05:05:00	SPY	ETF	424.32	424.32	424.32	424.32	100.0
2021-06-16 05:06:00	SPY	ETF	424.27	424.27	424.27	424.27	100.0
2021-06-16 05:07:00	SPY	ETF	424.22	424.22	424.21	424.21	2000.0
2021-06-16 05:10:00	SPY	ETF	424.25	424.25	424.25	424.25	1000.0
2021-06-16 05:13:00	SPY	ETF	424.19	424.19	424.18	424.18	1995.0
2021-06-16 05:15:00	SPY	ETF	424.1	424.1	424.1	424.1	200.0
2021-06-16 05:19:00	SPY	ETF	424.13	424.13	424.09	424.09	1200.0
2021-06-16 05:24:00	SPY	ETF	424.1	424.1	424.1	424.1	106.0
2021-06-16 05:25:00	SPY	ETF	424.0	424.0	424.0	424.0	100.0
2021-06-16 05:26:00	SPY	ETF	424.01	424.01	423.93	423.93	4700.0
2021-06-16 05:27:00	SPY	ETF	423.98	424.01	423.98	424.01	300.0
2021-06-16 05:30:00	SPY	ETF	423.98	423.98	423.98	423.98	100.0
2021-06-16 05:33:00	SPY	ETF	424.05	424.05	424.05	424.05	414.0
2021-06-16 05:38:00	SPY	ETF	424.18	424.18	424.18	424.18	300.0
2021-06-16 05:43:00	SPY	ETF	424.09	424.09	424.09	424.09	100.0
2021-06-16 05:54:00	SPY	ETF	424.16	424.16	424.16	424.16	500.0
2021-06-16 05:57:00	SPY	ETF	424.14	424.14	424.14	424.14	197.0
2021-06-16 06:01:00	SPY	ETF	424.15	424.17	424.06	424.17	3500.0
2021-06-16 06:09:00	SPY	ETF	424.31	424.31	424.31	424.31	100.0
2021-06-16 06:13:00	SPY	ETF	424.33	424.33	424.29	424.29	495.0
2021-06-16 06:15:00	SPY	ETF	424.35	424.35	424.35	424.35	100.0
2021-06-16 06:16:00	SPY	ETF	424.41	424.41	424.41	424.41	100.0
2021-06-16 06:19:00	SPY	ETF	424.39	424.39	424.39	424.39	500.0
2021-06-16 06:20:00	SPY	ETF	424.4	424.44	424.4	424.44	900.0
2021-06-16 06:21:00	SPY	ETF	424.45	424.46	424.45	424.46	700.0
2021-06-16 06:22:00	SPY	ETF	424.48	424.48	424.48	424.48	354.0
2021-06-16 06:24:00	SPY	ETF	424.48	424.48	424.48	424.48	100.0
2021-06-16 06:27:00	SPY	ETF	424.59	424.59	424.59	424.59	1065.0
2021-06-16 06:28:00	SPY	ETF	424.54	424.54	424.54	424.54	500.0
2021-06-16 06:30:00	SPY	ETF	424.63	424.69	424.63	424.65	2987.0
2021-06-16 06:31:00	SPY	ETF	424.64	424.67	424.64	424.67	1000.0
2021-06-16 06:32:00	SPY	ETF	424.63	424.63	424.63	424.63	354.0
2021-06-16 06:35:00	SPY	ETF	424.64	424.64	424.64	424.64	298.0

> showing 50 of 219,141 rows — these rows as CSV

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