PREVIEW / etf_1min / 2020-11-06

all etf 1-min files

  file:    by_date/etf_1min/2020/2020-11-06.parquet
  size:    3.7 MB
  rows:    206,139

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-11-06 04:00:00	SPY	ETF	348.07	348.07	347.64	347.64	2957.0
2020-11-06 04:01:00	SPY	ETF	347.87	348.08	347.87	348.08	1955.0
2020-11-06 04:02:00	SPY	ETF	348.08	348.11	347.96	348.11	3490.0
2020-11-06 04:03:00	SPY	ETF	348.07	348.08	348.07	348.08	576.0
2020-11-06 04:04:00	SPY	ETF	347.75	347.75	347.75	347.75	134.0
2020-11-06 04:06:00	SPY	ETF	347.63	347.73	347.61	347.61	1414.0
2020-11-06 04:07:00	SPY	ETF	347.51	347.51	347.51	347.51	431.0
2020-11-06 04:08:00	SPY	ETF	347.45	347.46	347.36	347.36	1256.0
2020-11-06 04:09:00	SPY	ETF	347.25	347.28	347.18	347.2	3208.0
2020-11-06 04:10:00	SPY	ETF	347.18	347.31	347.17	347.27	2830.0
2020-11-06 04:11:00	SPY	ETF	347.27	347.27	347.0	347.03	5098.0
2020-11-06 04:12:00	SPY	ETF	347.11	347.12	347.05	347.07	5760.0
2020-11-06 04:13:00	SPY	ETF	347.44	347.44	347.44	347.44	627.0
2020-11-06 04:14:00	SPY	ETF	347.37	347.37	347.37	347.37	1624.0
2020-11-06 04:15:00	SPY	ETF	347.3	347.42	347.27	347.42	1071.0
2020-11-06 04:16:00	SPY	ETF	347.36	347.44	347.36	347.44	4149.0
2020-11-06 04:17:00	SPY	ETF	347.42	347.42	347.42	347.42	728.0
2020-11-06 04:19:00	SPY	ETF	347.77	347.77	347.77	347.77	1151.0
2020-11-06 04:20:00	SPY	ETF	347.72	347.76	347.59	347.59	961.0
2020-11-06 04:22:00	SPY	ETF	347.7	347.7	347.6	347.69	50610.0
2020-11-06 04:23:00	SPY	ETF	347.54	347.62	347.54	347.62	1625.0
2020-11-06 04:24:00	SPY	ETF	347.6	347.62	347.6	347.62	1220.0
2020-11-06 04:26:00	SPY	ETF	347.71	347.71	347.61	347.61	300.0
2020-11-06 04:27:00	SPY	ETF	347.65	347.65	347.65	347.65	112.0
2020-11-06 04:29:00	SPY	ETF	347.74	347.77	347.74	347.76	430.0
2020-11-06 04:30:00	SPY	ETF	347.67	347.76	347.67	347.76	775.0
2020-11-06 04:31:00	SPY	ETF	347.77	347.77	347.56	347.6	1546.0
2020-11-06 04:32:00	SPY	ETF	347.56	347.56	347.55	347.55	401.0
2020-11-06 04:33:00	SPY	ETF	347.68	347.68	347.6	347.6	1650.0
2020-11-06 04:34:00	SPY	ETF	347.72	347.72	347.58	347.58	385.0
2020-11-06 04:35:00	SPY	ETF	347.6	347.6	347.52	347.52	531.0
2020-11-06 04:38:00	SPY	ETF	347.54	347.54	347.54	347.54	128.0
2020-11-06 04:41:00	SPY	ETF	347.13	347.13	346.92	346.94	5144.0
2020-11-06 04:42:00	SPY	ETF	346.97	346.97	346.97	346.97	854.0
2020-11-06 04:43:00	SPY	ETF	347.05	347.29	347.02	347.16	3659.0
2020-11-06 04:44:00	SPY	ETF	347.27	347.48	347.26	347.26	4819.0
2020-11-06 04:45:00	SPY	ETF	347.29	347.38	347.22	347.38	3307.0
2020-11-06 04:46:00	SPY	ETF	347.41	347.41	347.41	347.41	110.0
2020-11-06 04:47:00	SPY	ETF	347.09	347.09	347.08	347.08	1285.0
2020-11-06 04:48:00	SPY	ETF	347.05	347.05	347.05	347.05	319.0
2020-11-06 04:50:00	SPY	ETF	347.14	347.14	347.12	347.12	301.0
2020-11-06 04:51:00	SPY	ETF	347.24	347.24	347.08	347.08	2450.0
2020-11-06 04:52:00	SPY	ETF	347.08	347.09	346.95	346.95	17064.0
2020-11-06 04:53:00	SPY	ETF	346.67	346.7	346.49	346.5	3403.0
2020-11-06 04:54:00	SPY	ETF	346.5	346.54	346.5	346.54	320.0
2020-11-06 04:55:00	SPY	ETF	346.5	346.5	346.14	346.22	2573.0
2020-11-06 04:56:00	SPY	ETF	346.2	346.25	346.12	346.12	2137.0
2020-11-06 04:57:00	SPY	ETF	346.12	346.15	346.12	346.15	1700.0
2020-11-06 04:58:00	SPY	ETF	346.12	346.3	346.12	346.3	1537.0
2020-11-06 05:00:00	SPY	ETF	346.3	346.39	346.3	346.3	989.0

> showing 50 of 206,139 rows — these rows as CSV

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