PREVIEW / etf_1min / 2020-11-05

all etf 1-min files

  file:    by_date/etf_1min/2020/2020-11-05.parquet
  size:    4.2 MB
  rows:    225,464

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-05 04:00:00	SPY	ETF	347.87	348.15	347.87	348.14	6208.0
2020-11-05 04:01:00	SPY	ETF	347.97	347.97	347.73	347.73	1307.0
2020-11-05 04:02:00	SPY	ETF	347.73	347.73	347.71	347.71	1042.0
2020-11-05 04:03:00	SPY	ETF	347.6	347.65	347.6	347.65	1462.0
2020-11-05 04:04:00	SPY	ETF	347.65	347.66	347.65	347.66	1348.0
2020-11-05 04:05:00	SPY	ETF	347.66	347.66	347.51	347.51	460.0
2020-11-05 04:06:00	SPY	ETF	347.56	347.59	347.56	347.59	407.0
2020-11-05 04:07:00	SPY	ETF	347.58	347.73	347.58	347.71	900.0
2020-11-05 04:08:00	SPY	ETF	347.6	347.6	347.6	347.6	311.0
2020-11-05 04:10:00	SPY	ETF	347.5	347.5	347.28	347.28	2781.0
2020-11-05 04:12:00	SPY	ETF	347.4	347.4	347.4	347.4	160.0
2020-11-05 04:13:00	SPY	ETF	347.42	347.5	347.42	347.5	700.0
2020-11-05 04:14:00	SPY	ETF	347.49	347.5	347.49	347.5	1430.0
2020-11-05 04:15:00	SPY	ETF	347.58	347.6	347.53	347.55	1601.0
2020-11-05 04:16:00	SPY	ETF	347.68	347.7	347.67	347.68	1999.0
2020-11-05 04:17:00	SPY	ETF	347.81	347.81	347.73	347.73	1100.0
2020-11-05 04:18:00	SPY	ETF	347.69	347.78	347.65	347.72	14014.0
2020-11-05 04:19:00	SPY	ETF	347.73	347.73	347.73	347.73	100.0
2020-11-05 04:20:00	SPY	ETF	347.57	347.57	347.57	347.57	100.0
2020-11-05 04:21:00	SPY	ETF	347.65	347.73	347.65	347.73	200.0
2020-11-05 04:22:00	SPY	ETF	347.83	347.83	347.83	347.83	106.0
2020-11-05 04:23:00	SPY	ETF	347.8	347.8	347.8	347.8	1000.0
2020-11-05 04:24:00	SPY	ETF	347.86	347.97	347.86	347.97	1101.0
2020-11-05 04:25:00	SPY	ETF	347.94	347.94	347.87	347.87	756.0
2020-11-05 04:26:00	SPY	ETF	347.77	347.78	347.77	347.78	201.0
2020-11-05 04:28:00	SPY	ETF	347.8	347.8	347.63	347.63	930.0
2020-11-05 04:29:00	SPY	ETF	347.78	347.78	347.76	347.76	1238.0
2020-11-05 04:30:00	SPY	ETF	347.7	347.77	347.69	347.77	1410.0
2020-11-05 04:32:00	SPY	ETF	347.5	347.51	347.5	347.5	1610.0
2020-11-05 04:33:00	SPY	ETF	347.65	347.77	347.65	347.74	1013.0
2020-11-05 04:35:00	SPY	ETF	347.85	347.91	347.83	347.91	372.0
2020-11-05 04:36:00	SPY	ETF	347.87	348.11	347.87	348.08	607.0
2020-11-05 04:37:00	SPY	ETF	348.14	348.23	348.14	348.19	406.0
2020-11-05 04:38:00	SPY	ETF	348.17	348.32	348.17	348.32	1516.0
2020-11-05 04:39:00	SPY	ETF	348.34	348.34	348.34	348.34	221.0
2020-11-05 04:40:00	SPY	ETF	348.4	348.52	348.4	348.51	625.0
2020-11-05 04:41:00	SPY	ETF	348.6	348.6	348.6	348.6	1151.0
2020-11-05 04:42:00	SPY	ETF	348.71	348.95	348.71	348.95	2010.0
2020-11-05 04:43:00	SPY	ETF	348.83	348.83	348.75	348.75	2100.0
2020-11-05 04:44:00	SPY	ETF	348.75	348.75	348.75	348.75	1060.0
2020-11-05 04:46:00	SPY	ETF	348.68	348.71	348.68	348.71	300.0
2020-11-05 04:49:00	SPY	ETF	348.6	348.64	348.6	348.6	701.0
2020-11-05 04:50:00	SPY	ETF	348.59	348.59	348.59	348.59	304.0
2020-11-05 04:51:00	SPY	ETF	348.85	348.85	348.81	348.81	900.0
2020-11-05 04:52:00	SPY	ETF	348.8	348.8	348.6	348.6	629.0
2020-11-05 04:54:00	SPY	ETF	348.92	349.05	348.89	349.05	6680.0
2020-11-05 04:55:00	SPY	ETF	348.97	348.97	348.97	348.97	782.0
2020-11-05 04:56:00	SPY	ETF	349.01	349.02	348.97	348.99	9314.0
2020-11-05 04:57:00	SPY	ETF	348.8	348.96	348.8	348.96	910.0
2020-11-05 04:59:00	SPY	ETF	348.91	349.0	348.88	349.0	3555.0

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

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