PREVIEW / etf_1min / 2020-04-03

all etf 1-min files

  file:    by_date/etf_1min/2020/2020-04-03.parquet
  size:    4.2 MB
  rows:    216,598

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-04-03 04:00:00	SPY	ETF	250.0	250.02	249.88	250.0	5422.0
2020-04-03 04:01:00	SPY	ETF	250.0	250.0	250.0	250.0	269.0
2020-04-03 04:02:00	SPY	ETF	249.85	249.86	249.76	249.86	1418.0
2020-04-03 04:03:00	SPY	ETF	249.75	249.75	249.73	249.73	720.0
2020-04-03 04:04:00	SPY	ETF	249.83	249.83	249.83	249.83	278.0
2020-04-03 04:05:00	SPY	ETF	249.83	250.12	249.83	250.07	2600.0
2020-04-03 04:06:00	SPY	ETF	250.13	250.13	250.13	250.13	121.0
2020-04-03 04:07:00	SPY	ETF	250.04	250.04	250.03	250.03	452.0
2020-04-03 04:08:00	SPY	ETF	250.15	250.2	250.15	250.2	1128.0
2020-04-03 04:09:00	SPY	ETF	250.18	250.26	250.18	250.26	1250.0
2020-04-03 04:10:00	SPY	ETF	250.0	250.0	250.0	250.0	451.0
2020-04-03 04:11:00	SPY	ETF	250.16	250.16	250.16	250.16	230.0
2020-04-03 04:12:00	SPY	ETF	250.1	250.1	250.1	250.1	100.0
2020-04-03 04:14:00	SPY	ETF	250.06	250.06	250.06	250.06	100.0
2020-04-03 04:19:00	SPY	ETF	249.92	249.92	249.92	249.92	279.0
2020-04-03 04:20:00	SPY	ETF	249.73	249.73	249.58	249.59	1845.0
2020-04-03 04:21:00	SPY	ETF	249.61	249.61	249.45	249.46	726.0
2020-04-03 04:22:00	SPY	ETF	249.41	249.46	249.3	249.38	12210.0
2020-04-03 04:23:00	SPY	ETF	249.38	249.53	249.38	249.53	1465.0
2020-04-03 04:24:00	SPY	ETF	249.41	249.41	249.41	249.41	560.0
2020-04-03 04:26:00	SPY	ETF	249.28	249.28	249.28	249.28	120.0
2020-04-03 04:27:00	SPY	ETF	249.22	249.22	249.14	249.14	720.0
2020-04-03 04:28:00	SPY	ETF	249.1	249.1	249.0	249.0	3835.0
2020-04-03 04:29:00	SPY	ETF	249.05	249.05	249.05	249.05	1000.0
2020-04-03 04:30:00	SPY	ETF	249.29	249.29	249.29	249.29	250.0
2020-04-03 04:31:00	SPY	ETF	249.21	249.21	249.15	249.18	3940.0
2020-04-03 04:32:00	SPY	ETF	249.14	249.18	248.8	248.8	4103.0
2020-04-03 04:33:00	SPY	ETF	248.96	248.98	248.68	248.68	4830.0
2020-04-03 04:34:00	SPY	ETF	248.79	248.83	248.79	248.83	1525.0
2020-04-03 04:35:00	SPY	ETF	248.75	248.75	248.75	248.75	545.0
2020-04-03 04:36:00	SPY	ETF	248.67	248.67	248.67	248.67	678.0
2020-04-03 04:37:00	SPY	ETF	248.6	248.88	248.6	248.88	4632.0
2020-04-03 04:38:00	SPY	ETF	248.89	248.89	248.89	248.89	472.0
2020-04-03 04:39:00	SPY	ETF	248.97	248.97	248.97	248.97	548.0
2020-04-03 04:40:00	SPY	ETF	248.72	248.72	248.62	248.68	1850.0
2020-04-03 04:41:00	SPY	ETF	248.7	248.72	248.44	248.45	2172.0
2020-04-03 04:42:00	SPY	ETF	248.45	248.45	248.45	248.45	630.0
2020-04-03 04:43:00	SPY	ETF	248.69	248.69	248.64	248.64	346.0
2020-04-03 04:45:00	SPY	ETF	248.94	248.94	248.92	248.92	1600.0
2020-04-03 04:46:00	SPY	ETF	248.7	248.85	248.7	248.85	500.0
2020-04-03 04:48:00	SPY	ETF	248.85	248.85	248.77	248.77	210.0
2020-04-03 04:49:00	SPY	ETF	248.9	249.14	248.9	249.14	2570.0
2020-04-03 04:50:00	SPY	ETF	249.06	249.06	249.06	249.06	190.0
2020-04-03 04:54:00	SPY	ETF	249.06	249.06	249.02	249.02	886.0
2020-04-03 04:57:00	SPY	ETF	248.97	248.97	248.97	248.97	100.0
2020-04-03 04:58:00	SPY	ETF	249.02	249.02	249.02	249.02	600.0
2020-04-03 04:59:00	SPY	ETF	249.13	249.14	249.13	249.14	564.0
2020-04-03 05:00:00	SPY	ETF	249.14	249.14	249.14	249.14	254.0
2020-04-03 05:01:00	SPY	ETF	249.45	249.45	249.35	249.35	2286.0
2020-04-03 05:02:00	SPY	ETF	249.38	249.38	249.19	249.19	200.0

> showing 50 of 216,598 rows — these rows as CSV

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