PREVIEW / etf_1min / 2020-05-04

all etf 1-min files

  file:    by_date/etf_1min/2020/2020-05-04.parquet
  size:    3.9 MB
  rows:    209,111

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-05-04 04:00:00	SPY	ETF	280.56	280.69	280.44	280.55	7052.0
2020-05-04 04:01:00	SPY	ETF	280.53	280.55	280.44	280.45	2984.0
2020-05-04 04:02:00	SPY	ETF	280.38	280.49	280.37	280.49	8402.0
2020-05-04 04:03:00	SPY	ETF	280.73	281.0	280.73	281.0	1401.0
2020-05-04 04:04:00	SPY	ETF	281.05	281.05	280.92	281.01	1270.0
2020-05-04 04:05:00	SPY	ETF	281.06	281.09	280.99	281.05	2349.0
2020-05-04 04:06:00	SPY	ETF	281.08	281.12	281.07	281.12	1075.0
2020-05-04 04:07:00	SPY	ETF	280.87	280.87	280.79	280.79	750.0
2020-05-04 04:08:00	SPY	ETF	281.03	281.03	280.94	280.94	1003.0
2020-05-04 04:09:00	SPY	ETF	280.83	280.94	280.82	280.83	4105.0
2020-05-04 04:10:00	SPY	ETF	280.82	280.82	280.82	280.82	470.0
2020-05-04 04:11:00	SPY	ETF	280.46	280.46	280.46	280.46	145.0
2020-05-04 04:12:00	SPY	ETF	280.5	280.62	280.5	280.5	7321.0
2020-05-04 04:13:00	SPY	ETF	280.5	280.5	280.5	280.5	1883.0
2020-05-04 04:14:00	SPY	ETF	280.45	280.45	280.39	280.45	770.0
2020-05-04 04:15:00	SPY	ETF	280.39	280.39	280.39	280.39	400.0
2020-05-04 04:16:00	SPY	ETF	280.29	280.29	280.04	280.04	13342.0
2020-05-04 04:17:00	SPY	ETF	280.0	280.14	280.0	280.14	4099.0
2020-05-04 04:18:00	SPY	ETF	280.21	280.21	280.1	280.1	9143.0
2020-05-04 04:19:00	SPY	ETF	280.01	280.01	280.01	280.01	664.0
2020-05-04 04:20:00	SPY	ETF	279.92	280.08	279.92	280.08	2595.0
2020-05-04 04:21:00	SPY	ETF	280.11	280.11	280.11	280.11	1167.0
2020-05-04 04:22:00	SPY	ETF	280.13	280.17	280.13	280.17	1720.0
2020-05-04 04:23:00	SPY	ETF	280.25	280.25	280.25	280.25	2625.0
2020-05-04 04:24:00	SPY	ETF	280.14	280.14	280.06	280.06	650.0
2020-05-04 04:25:00	SPY	ETF	280.05	280.05	279.95	279.95	2616.0
2020-05-04 04:26:00	SPY	ETF	280.11	280.29	280.11	280.29	3262.0
2020-05-04 04:27:00	SPY	ETF	280.23	280.24	280.2	280.2	350.0
2020-05-04 04:29:00	SPY	ETF	280.18	280.18	280.18	280.18	120.0
2020-05-04 04:32:00	SPY	ETF	280.07	280.09	280.07	280.09	205.0
2020-05-04 04:33:00	SPY	ETF	280.08	280.08	280.0	280.0	1282.0
2020-05-04 04:34:00	SPY	ETF	279.85	279.87	279.79	279.79	1180.0
2020-05-04 04:35:00	SPY	ETF	279.77	279.77	279.74	279.74	546.0
2020-05-04 04:36:00	SPY	ETF	279.71	279.75	279.71	279.75	269.0
2020-05-04 04:37:00	SPY	ETF	279.77	279.77	279.77	279.77	150.0
2020-05-04 04:38:00	SPY	ETF	279.85	279.85	279.77	279.77	1445.0
2020-05-04 04:40:00	SPY	ETF	279.81	279.82	279.8	279.82	4301.0
2020-05-04 04:42:00	SPY	ETF	280.15	280.15	279.97	280.0	2091.0
2020-05-04 04:44:00	SPY	ETF	280.0	280.0	279.86	279.86	3227.0
2020-05-04 04:45:00	SPY	ETF	279.86	280.0	279.86	280.0	804.0
2020-05-04 04:46:00	SPY	ETF	280.07	280.07	280.03	280.03	1390.0
2020-05-04 04:47:00	SPY	ETF	280.1	280.11	280.1	280.11	828.0
2020-05-04 04:48:00	SPY	ETF	280.2	280.2	280.18	280.18	569.0
2020-05-04 04:49:00	SPY	ETF	280.16	280.16	280.15	280.15	330.0
2020-05-04 04:50:00	SPY	ETF	280.02	280.02	280.0	280.0	610.0
2020-05-04 04:51:00	SPY	ETF	279.97	279.97	279.97	279.97	525.0
2020-05-04 04:52:00	SPY	ETF	280.08	280.08	280.05	280.05	656.0
2020-05-04 04:53:00	SPY	ETF	280.0	280.0	279.97	279.97	201.0
2020-05-04 04:54:00	SPY	ETF	279.9	279.9	279.86	279.86	6200.0
2020-05-04 04:55:00	SPY	ETF	279.92	279.92	279.92	279.92	1663.0

> showing 50 of 209,111 rows — these rows as CSV

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