PREVIEW / etf_1min / 2020-04-23

all etf 1-min files

  file:    by_date/etf_1min/2020/2020-04-23.parquet
  size:    4.1 MB
  rows:    214,225

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-23 04:00:00	SPY	ETF	278.25	278.49	278.2	278.25	1844.0
2020-04-23 04:01:00	SPY	ETF	278.33	278.55	278.33	278.55	1850.0
2020-04-23 04:02:00	SPY	ETF	278.55	278.6	278.55	278.6	498.0
2020-04-23 04:04:00	SPY	ETF	278.55	278.55	278.5	278.5	1947.0
2020-04-23 04:05:00	SPY	ETF	278.4	278.41	278.35	278.38	1820.0
2020-04-23 04:06:00	SPY	ETF	278.32	278.32	278.1	278.1	615.0
2020-04-23 04:07:00	SPY	ETF	278.08	278.08	278.0	278.0	303.0
2020-04-23 04:08:00	SPY	ETF	278.11	278.2	278.11	278.2	1400.0
2020-04-23 04:09:00	SPY	ETF	278.26	278.27	278.26	278.27	1425.0
2020-04-23 04:10:00	SPY	ETF	278.24	278.4	278.24	278.4	8545.0
2020-04-23 04:11:00	SPY	ETF	278.4	278.5	278.35	278.5	13435.0
2020-04-23 04:12:00	SPY	ETF	278.55	278.6	278.55	278.6	3158.0
2020-04-23 04:13:00	SPY	ETF	278.67	278.67	278.67	278.67	125.0
2020-04-23 04:14:00	SPY	ETF	278.52	278.52	278.52	278.52	246.0
2020-04-23 04:15:00	SPY	ETF	278.69	278.74	278.69	278.74	5298.0
2020-04-23 04:17:00	SPY	ETF	278.6	278.72	278.6	278.72	1115.0
2020-04-23 04:20:00	SPY	ETF	278.75	279.0	278.75	279.0	719.0
2020-04-23 04:21:00	SPY	ETF	279.0	279.02	279.0	279.02	2670.0
2020-04-23 04:22:00	SPY	ETF	279.07	279.07	279.07	279.07	215.0
2020-04-23 04:24:00	SPY	ETF	278.99	279.08	278.99	279.08	261.0
2020-04-23 04:25:00	SPY	ETF	278.88	279.1	278.88	279.1	300.0
2020-04-23 04:26:00	SPY	ETF	279.04	279.04	278.89	278.89	407.0
2020-04-23 04:27:00	SPY	ETF	278.87	278.87	278.87	278.87	121.0
2020-04-23 04:29:00	SPY	ETF	278.94	279.07	278.94	279.07	670.0
2020-04-23 04:30:00	SPY	ETF	279.05	279.05	279.05	279.05	553.0
2020-04-23 04:31:00	SPY	ETF	279.1	279.1	279.1	279.1	245.0
2020-04-23 04:33:00	SPY	ETF	279.14	279.14	279.14	279.14	329.0
2020-04-23 04:36:00	SPY	ETF	279.05	279.05	279.05	279.05	2550.0
2020-04-23 04:37:00	SPY	ETF	279.07	279.07	279.06	279.06	810.0
2020-04-23 04:38:00	SPY	ETF	279.09	279.09	279.09	279.09	281.0
2020-04-23 04:42:00	SPY	ETF	279.1	279.1	279.1	279.1	648.0
2020-04-23 04:43:00	SPY	ETF	279.0	279.13	279.0	279.13	4100.0
2020-04-23 04:44:00	SPY	ETF	279.02	279.02	279.02	279.02	147.0
2020-04-23 04:45:00	SPY	ETF	279.07	279.07	279.07	279.07	560.0
2020-04-23 04:46:00	SPY	ETF	279.07	279.07	279.07	279.07	100.0
2020-04-23 04:49:00	SPY	ETF	278.7	278.7	278.6	278.6	5005.0
2020-04-23 04:50:00	SPY	ETF	278.68	278.75	278.65	278.75	1103.0
2020-04-23 04:51:00	SPY	ETF	278.65	278.65	278.65	278.65	100.0
2020-04-23 04:52:00	SPY	ETF	278.78	278.78	278.78	278.78	200.0
2020-04-23 04:54:00	SPY	ETF	278.58	278.58	278.58	278.58	500.0
2020-04-23 04:57:00	SPY	ETF	278.66	278.66	278.65	278.65	303.0
2020-04-23 04:58:00	SPY	ETF	278.7	278.72	278.7	278.72	2103.0
2020-04-23 05:00:00	SPY	ETF	278.58	278.58	278.58	278.58	174.0
2020-04-23 05:01:00	SPY	ETF	278.58	278.67	278.58	278.67	609.0
2020-04-23 05:03:00	SPY	ETF	278.82	278.82	278.82	278.82	200.0
2020-04-23 05:04:00	SPY	ETF	278.9	278.9	278.9	278.9	470.0
2020-04-23 05:05:00	SPY	ETF	278.88	278.9	278.88	278.9	2200.0
2020-04-23 05:08:00	SPY	ETF	278.99	279.05	278.99	279.05	400.0
2020-04-23 05:09:00	SPY	ETF	279.15	279.19	279.15	279.19	2010.0
2020-04-23 05:10:00	SPY	ETF	279.25	279.25	279.25	279.25	150.0

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

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