PREVIEW / etf_1min / 2020-03-09

all etf 1-min files

  file:    by_date/etf_1min/2020/2020-03-09.parquet
  size:    5.1 MB
  rows:    265,780

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-03-09 04:00:00	SPY	ETF	280.2	289.4	279.45	279.5	20908.0
2020-03-09 04:01:00	SPY	ETF	279.58	279.58	277.22	279.0	11438.0
2020-03-09 04:02:00	SPY	ETF	278.55	278.79	278.37	278.4	15135.0
2020-03-09 04:03:00	SPY	ETF	278.5	279.4	278.39	279.39	11915.0
2020-03-09 04:04:00	SPY	ETF	279.39	279.39	279.0	279.0	1022.0
2020-03-09 04:05:00	SPY	ETF	279.4	279.4	279.0	279.38	3618.0
2020-03-09 04:06:00	SPY	ETF	279.38	279.94	279.38	279.8	2442.0
2020-03-09 04:07:00	SPY	ETF	279.92	279.98	279.91	279.98	3143.0
2020-03-09 04:08:00	SPY	ETF	279.93	279.96	279.7	279.96	3935.0
2020-03-09 04:10:00	SPY	ETF	279.5	279.5	279.5	279.5	453.0
2020-03-09 04:11:00	SPY	ETF	279.84	279.89	279.69	279.71	7033.0
2020-03-09 04:12:00	SPY	ETF	279.79	279.8	279.7	279.7	4899.0
2020-03-09 04:13:00	SPY	ETF	279.7	279.7	279.01	279.01	4342.0
2020-03-09 04:14:00	SPY	ETF	279.05	279.05	278.57	278.57	9146.0
2020-03-09 04:15:00	SPY	ETF	278.6	279.35	278.57	279.35	4562.0
2020-03-09 04:16:00	SPY	ETF	278.98	278.99	278.98	278.99	493.0
2020-03-09 04:17:00	SPY	ETF	278.78	278.78	278.6	278.6	3230.0
2020-03-09 04:18:00	SPY	ETF	278.68	278.68	278.4	278.4	7678.0
2020-03-09 04:19:00	SPY	ETF	278.4	278.6	278.4	278.45	11114.0
2020-03-09 04:20:00	SPY	ETF	278.27	278.45	278.27	278.45	6101.0
2020-03-09 04:21:00	SPY	ETF	278.45	278.61	278.32	278.32	6052.0
2020-03-09 04:22:00	SPY	ETF	278.55	278.6	278.55	278.6	5276.0
2020-03-09 04:23:00	SPY	ETF	278.6	278.6	278.0	278.38	12587.0
2020-03-09 04:24:00	SPY	ETF	277.98	278.38	277.61	277.61	14261.0
2020-03-09 04:25:00	SPY	ETF	277.81	277.98	277.02	277.49	26704.0
2020-03-09 04:26:00	SPY	ETF	277.5	277.93	277.01	277.01	12847.0
2020-03-09 04:27:00	SPY	ETF	277.19	277.2	277.03	277.2	2370.0
2020-03-09 04:28:00	SPY	ETF	277.2	277.46	277.15	277.46	4998.0
2020-03-09 04:29:00	SPY	ETF	277.43	277.78	277.43	277.78	1300.0
2020-03-09 04:30:00	SPY	ETF	277.48	277.48	277.14	277.14	6435.0
2020-03-09 04:31:00	SPY	ETF	277.01	277.07	276.99	277.07	9217.0
2020-03-09 04:32:00	SPY	ETF	277.0	277.26	276.99	276.99	1506.0
2020-03-09 04:33:00	SPY	ETF	276.78	276.9	276.78	276.78	1239.0
2020-03-09 04:34:00	SPY	ETF	276.54	276.78	276.54	276.78	389.0
2020-03-09 04:35:00	SPY	ETF	276.79	277.96	276.73	277.96	13582.0
2020-03-09 04:36:00	SPY	ETF	277.24	277.24	277.1	277.1	2049.0
2020-03-09 04:37:00	SPY	ETF	277.1	277.1	276.78	276.85	5881.0
2020-03-09 04:38:00	SPY	ETF	276.86	276.98	276.86	276.98	1335.0
2020-03-09 04:39:00	SPY	ETF	276.99	277.09	276.99	277.0	6868.0
2020-03-09 04:40:00	SPY	ETF	276.99	276.99	276.69	276.71	1364.0
2020-03-09 04:41:00	SPY	ETF	276.72	276.8	276.69	276.71	1336.0
2020-03-09 04:42:00	SPY	ETF	276.71	276.71	276.69	276.69	2129.0
2020-03-09 04:43:00	SPY	ETF	276.69	277.3	276.69	277.3	8184.0
2020-03-09 04:44:00	SPY	ETF	277.45	278.2	277.45	278.2	6034.0
2020-03-09 04:45:00	SPY	ETF	278.0	278.88	278.0	278.88	3103.0
2020-03-09 04:46:00	SPY	ETF	278.88	279.7	278.88	279.0	5464.0
2020-03-09 04:47:00	SPY	ETF	279.2	279.2	279.2	279.2	381.0
2020-03-09 04:48:00	SPY	ETF	279.13	279.13	279.13	279.13	3457.0
2020-03-09 04:49:00	SPY	ETF	279.3	279.3	279.13	279.13	2261.0
2020-03-09 04:50:00	SPY	ETF	278.9	279.13	278.9	279.13	275.0

> showing 50 of 265,780 rows — these rows as CSV

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