PREVIEW / etf_1min / 2020-04-30

all etf 1-min files

  file:    by_date/etf_1min/2020/2020-04-30.parquet
  size:    4.3 MB
  rows:    225,907

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-30 04:00:00	SPY	ETF	294.4	294.52	294.2	294.45	24733.0
2020-04-30 04:01:00	SPY	ETF	294.25	294.25	294.24	294.24	285.0
2020-04-30 04:02:00	SPY	ETF	294.3	294.3	294.25	294.3	7760.0
2020-04-30 04:03:00	SPY	ETF	294.32	294.32	294.32	294.32	657.0
2020-04-30 04:04:00	SPY	ETF	294.4	294.42	294.4	294.42	5900.0
2020-04-30 04:05:00	SPY	ETF	294.42	294.42	294.41	294.41	2978.0
2020-04-30 04:06:00	SPY	ETF	294.43	294.43	294.38	294.38	639.0
2020-04-30 04:07:00	SPY	ETF	294.38	294.38	294.38	294.38	105.0
2020-04-30 04:09:00	SPY	ETF	294.4	294.4	294.39	294.39	400.0
2020-04-30 04:10:00	SPY	ETF	294.39	294.66	294.39	294.6	1623.0
2020-04-30 04:11:00	SPY	ETF	294.5	294.5	294.46	294.46	607.0
2020-04-30 04:12:00	SPY	ETF	294.46	294.46	294.46	294.46	132.0
2020-04-30 04:13:00	SPY	ETF	294.37	294.39	294.36	294.36	1251.0
2020-04-30 04:14:00	SPY	ETF	294.38	294.38	294.38	294.38	522.0
2020-04-30 04:15:00	SPY	ETF	294.38	294.5	294.38	294.5	509.0
2020-04-30 04:16:00	SPY	ETF	294.56	294.56	294.56	294.56	105.0
2020-04-30 04:17:00	SPY	ETF	294.52	294.53	294.52	294.52	2000.0
2020-04-30 04:18:00	SPY	ETF	294.66	294.66	294.66	294.66	626.0
2020-04-30 04:19:00	SPY	ETF	294.51	294.51	294.51	294.51	210.0
2020-04-30 04:20:00	SPY	ETF	294.38	294.38	294.38	294.38	2124.0
2020-04-30 04:21:00	SPY	ETF	294.31	294.31	294.26	294.26	675.0
2020-04-30 04:22:00	SPY	ETF	294.13	294.14	294.11	294.14	1307.0
2020-04-30 04:23:00	SPY	ETF	294.12	294.24	294.12	294.24	1501.0
2020-04-30 04:26:00	SPY	ETF	294.16	294.16	294.16	294.16	215.0
2020-04-30 04:27:00	SPY	ETF	294.27	294.33	294.27	294.33	10925.0
2020-04-30 04:28:00	SPY	ETF	294.32	294.34	294.3	294.3	871.0
2020-04-30 04:29:00	SPY	ETF	294.4	294.4	294.4	294.4	640.0
2020-04-30 04:30:00	SPY	ETF	294.58	294.58	294.58	294.58	216.0
2020-04-30 04:31:00	SPY	ETF	294.74	295.06	294.74	295.05	17414.0
2020-04-30 04:32:00	SPY	ETF	295.05	295.08	295.03	295.05	1305.0
2020-04-30 04:33:00	SPY	ETF	295.3	295.42	295.28	295.38	14022.0
2020-04-30 04:34:00	SPY	ETF	295.3	295.3	295.06	295.06	11263.0
2020-04-30 04:35:00	SPY	ETF	295.1	295.1	295.06	295.06	11680.0
2020-04-30 04:36:00	SPY	ETF	295.02	295.02	295.0	295.0	548.0
2020-04-30 04:37:00	SPY	ETF	294.95	294.95	294.95	294.95	174.0
2020-04-30 04:38:00	SPY	ETF	295.01	295.01	295.01	295.01	750.0
2020-04-30 04:40:00	SPY	ETF	294.92	294.92	294.92	294.92	215.0
2020-04-30 04:41:00	SPY	ETF	294.87	294.87	294.81	294.81	429.0
2020-04-30 04:42:00	SPY	ETF	294.9	294.9	294.9	294.9	365.0
2020-04-30 04:47:00	SPY	ETF	295.07	295.07	295.07	295.07	200.0
2020-04-30 04:50:00	SPY	ETF	294.95	294.95	294.95	294.95	473.0
2020-04-30 04:51:00	SPY	ETF	294.88	294.88	294.88	294.88	353.0
2020-04-30 04:54:00	SPY	ETF	294.82	294.82	294.76	294.77	810.0
2020-04-30 04:56:00	SPY	ETF	294.7	294.7	294.7	294.7	210.0
2020-04-30 04:58:00	SPY	ETF	294.51	294.51	294.4	294.4	1426.0
2020-04-30 04:59:00	SPY	ETF	294.38	294.38	294.38	294.38	240.0
2020-04-30 05:00:00	SPY	ETF	294.51	294.51	294.37	294.41	486.0
2020-04-30 05:01:00	SPY	ETF	294.39	294.46	294.36	294.46	556.0
2020-04-30 05:02:00	SPY	ETF	294.41	294.41	294.41	294.41	210.0
2020-04-30 05:03:00	SPY	ETF	294.42	294.44	294.36	294.36	4002.0

> showing 50 of 225,907 rows — these rows as CSV

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