PREVIEW / etf_1min / 2020-10-21

all etf 1-min files

  file:    by_date/etf_1min/2020/2020-10-21.parquet
  size:    3.5 MB
  rows:    193,142

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-10-21 04:00:00	SPY	ETF	343.93	343.93	343.93	343.93	158.0
2020-10-21 04:01:00	SPY	ETF	343.93	343.93	343.93	343.93	240.0
2020-10-21 04:04:00	SPY	ETF	343.97	343.97	343.87	343.87	301.0
2020-10-21 04:05:00	SPY	ETF	343.8	343.8	343.78	343.78	1064.0
2020-10-21 04:06:00	SPY	ETF	343.87	343.87	343.87	343.87	244.0
2020-10-21 04:07:00	SPY	ETF	343.84	343.84	343.84	343.84	223.0
2020-10-21 04:12:00	SPY	ETF	343.72	343.89	343.72	343.89	1750.0
2020-10-21 04:16:00	SPY	ETF	343.8	343.8	343.8	343.8	1100.0
2020-10-21 04:17:00	SPY	ETF	343.7	343.7	343.7	343.7	200.0
2020-10-21 04:19:00	SPY	ETF	343.55	343.55	343.5	343.5	1682.0
2020-10-21 04:20:00	SPY	ETF	343.44	343.44	343.42	343.42	1471.0
2020-10-21 04:21:00	SPY	ETF	343.43	343.43	343.43	343.43	1000.0
2020-10-21 04:22:00	SPY	ETF	343.33	343.33	343.15	343.15	2790.0
2020-10-21 04:23:00	SPY	ETF	343.05	343.05	342.5	342.55	9181.0
2020-10-21 04:24:00	SPY	ETF	342.68	342.71	342.53	342.59	9223.0
2020-10-21 04:25:00	SPY	ETF	342.63	342.66	342.59	342.59	5202.0
2020-10-21 04:27:00	SPY	ETF	342.68	342.73	342.64	342.64	1318.0
2020-10-21 04:29:00	SPY	ETF	342.74	342.86	342.74	342.86	3601.0
2020-10-21 04:30:00	SPY	ETF	342.83	342.83	342.64	342.64	3279.0
2020-10-21 04:31:00	SPY	ETF	342.77	342.77	342.72	342.72	1981.0
2020-10-21 04:32:00	SPY	ETF	342.82	342.84	342.82	342.82	2236.0
2020-10-21 04:33:00	SPY	ETF	342.94	342.94	342.94	342.94	208.0
2020-10-21 04:35:00	SPY	ETF	343.04	343.07	342.99	342.99	2156.0
2020-10-21 04:36:00	SPY	ETF	343.07	343.09	343.07	343.09	900.0
2020-10-21 04:38:00	SPY	ETF	343.16	343.16	343.16	343.16	1034.0
2020-10-21 04:39:00	SPY	ETF	343.19	343.19	343.19	343.19	100.0
2020-10-21 04:40:00	SPY	ETF	343.22	343.24	343.22	343.24	1450.0
2020-10-21 04:41:00	SPY	ETF	343.06	343.06	343.06	343.06	350.0
2020-10-21 04:42:00	SPY	ETF	343.01	343.01	343.01	343.01	600.0
2020-10-21 04:46:00	SPY	ETF	342.81	342.81	342.81	342.81	100.0
2020-10-21 04:47:00	SPY	ETF	342.87	342.87	342.87	342.87	350.0
2020-10-21 04:48:00	SPY	ETF	342.88	342.88	342.88	342.88	250.0
2020-10-21 04:49:00	SPY	ETF	343.06	343.06	343.06	343.06	450.0
2020-10-21 04:53:00	SPY	ETF	342.85	342.85	342.81	342.81	3000.0
2020-10-21 04:54:00	SPY	ETF	342.8	342.8	342.75	342.75	5101.0
2020-10-21 04:55:00	SPY	ETF	342.58	342.58	342.51	342.51	706.0
2020-10-21 04:56:00	SPY	ETF	342.53	342.53	342.53	342.53	119.0
2020-10-21 04:57:00	SPY	ETF	342.49	342.49	342.49	342.49	1058.0
2020-10-21 04:58:00	SPY	ETF	342.47	342.47	342.44	342.45	2008.0
2020-10-21 04:59:00	SPY	ETF	342.36	342.36	342.22	342.24	4105.0
2020-10-21 05:00:00	SPY	ETF	342.23	342.23	342.17	342.17	1723.0
2020-10-21 05:01:00	SPY	ETF	342.1	342.1	342.05	342.05	1815.0
2020-10-21 05:02:00	SPY	ETF	342.39	342.39	342.39	342.39	1000.0
2020-10-21 05:03:00	SPY	ETF	342.39	342.39	342.34	342.39	4600.0
2020-10-21 05:04:00	SPY	ETF	342.34	342.34	342.29	342.29	2000.0
2020-10-21 05:05:00	SPY	ETF	342.34	342.42	342.34	342.41	700.0
2020-10-21 05:06:00	SPY	ETF	342.42	342.42	342.42	342.42	603.0
2020-10-21 05:08:00	SPY	ETF	342.51	342.51	342.51	342.51	775.0
2020-10-21 05:10:00	SPY	ETF	342.5	342.55	342.47	342.55	765.0
2020-10-21 05:11:00	SPY	ETF	342.5	342.5	342.47	342.47	1000.0

> showing 50 of 193,142 rows — these rows as CSV

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