PREVIEW / etf_1min / 2020-07-22

all etf 1-min files

  file:    by_date/etf_1min/2020/2020-07-22.parquet
  size:    3.6 MB
  rows:    202,076

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-07-22 04:00:00	SPY	ETF	324.5	324.5	324.42	324.48	1931.0
2020-07-22 04:01:00	SPY	ETF	324.37	324.38	324.37	324.38	466.0
2020-07-22 04:02:00	SPY	ETF	324.36	324.36	324.28	324.28	1145.0
2020-07-22 04:03:00	SPY	ETF	324.4	324.4	324.35	324.35	1576.0
2020-07-22 04:04:00	SPY	ETF	324.26	324.26	324.26	324.26	132.0
2020-07-22 04:05:00	SPY	ETF	324.21	324.21	324.21	324.21	181.0
2020-07-22 04:06:00	SPY	ETF	324.14	324.14	324.14	324.14	1570.0
2020-07-22 04:07:00	SPY	ETF	324.16	324.16	324.13	324.13	745.0
2020-07-22 04:08:00	SPY	ETF	324.23	324.24	324.23	324.24	722.0
2020-07-22 04:10:00	SPY	ETF	324.24	324.24	324.22	324.22	1700.0
2020-07-22 04:11:00	SPY	ETF	324.1	324.19	324.1	324.19	837.0
2020-07-22 04:12:00	SPY	ETF	324.29	324.29	324.29	324.29	1001.0
2020-07-22 04:13:00	SPY	ETF	324.46	324.46	324.46	324.46	100.0
2020-07-22 04:16:00	SPY	ETF	324.16	324.18	324.16	324.18	300.0
2020-07-22 04:17:00	SPY	ETF	324.24	324.24	324.24	324.24	130.0
2020-07-22 04:18:00	SPY	ETF	324.28	324.28	324.2	324.2	500.0
2020-07-22 04:19:00	SPY	ETF	324.26	324.26	324.26	324.26	350.0
2020-07-22 04:20:00	SPY	ETF	324.26	324.26	324.26	324.26	103.0
2020-07-22 04:22:00	SPY	ETF	324.35	324.35	324.35	324.35	100.0
2020-07-22 04:23:00	SPY	ETF	324.36	324.36	324.36	324.36	100.0
2020-07-22 04:29:00	SPY	ETF	324.29	324.29	324.29	324.29	259.0
2020-07-22 04:30:00	SPY	ETF	324.34	324.34	324.16	324.16	963.0
2020-07-22 04:31:00	SPY	ETF	324.14	324.14	324.14	324.14	100.0
2020-07-22 04:32:00	SPY	ETF	324.14	324.14	324.01	324.01	742.0
2020-07-22 04:34:00	SPY	ETF	324.1	324.1	324.1	324.1	235.0
2020-07-22 04:35:00	SPY	ETF	324.04	324.04	323.7	323.75	5141.0
2020-07-22 04:36:00	SPY	ETF	323.7	323.7	323.7	323.7	400.0
2020-07-22 04:38:00	SPY	ETF	323.69	323.69	323.69	323.69	432.0
2020-07-22 04:39:00	SPY	ETF	323.66	323.68	323.66	323.68	2501.0
2020-07-22 04:40:00	SPY	ETF	323.64	323.68	323.64	323.68	420.0
2020-07-22 04:41:00	SPY	ETF	323.69	323.69	323.69	323.69	516.0
2020-07-22 04:42:00	SPY	ETF	323.7	323.71	323.69	323.71	1511.0
2020-07-22 04:43:00	SPY	ETF	323.66	323.66	323.6	323.6	4100.0
2020-07-22 04:44:00	SPY	ETF	323.59	323.59	323.49	323.5	5957.0
2020-07-22 04:45:00	SPY	ETF	323.36	323.36	323.36	323.36	232.0
2020-07-22 04:46:00	SPY	ETF	323.38	323.38	323.33	323.33	770.0
2020-07-22 04:47:00	SPY	ETF	323.36	323.36	323.36	323.36	1100.0
2020-07-22 04:48:00	SPY	ETF	323.51	323.51	323.51	323.51	557.0
2020-07-22 04:49:00	SPY	ETF	323.54	323.54	323.48	323.51	5455.0
2020-07-22 04:50:00	SPY	ETF	323.41	323.41	323.36	323.37	4940.0
2020-07-22 04:51:00	SPY	ETF	323.38	323.46	323.38	323.46	1201.0
2020-07-22 04:52:00	SPY	ETF	323.43	323.43	323.43	323.43	100.0
2020-07-22 04:53:00	SPY	ETF	323.41	323.41	323.38	323.38	1263.0
2020-07-22 04:55:00	SPY	ETF	323.61	323.61	323.61	323.61	520.0
2020-07-22 04:57:00	SPY	ETF	323.65	323.66	323.61	323.61	1380.0
2020-07-22 04:58:00	SPY	ETF	323.65	323.66	323.65	323.66	1136.0
2020-07-22 04:59:00	SPY	ETF	323.57	323.61	323.56	323.57	1300.0
2020-07-22 05:00:00	SPY	ETF	323.61	323.61	323.49	323.49	1855.0
2020-07-22 05:01:00	SPY	ETF	323.46	323.49	323.46	323.49	1658.0
2020-07-22 05:03:00	SPY	ETF	323.49	323.49	323.36	323.36	387.0

> showing 50 of 202,076 rows — these rows as CSV

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