PREVIEW / etf_1min / 2020-03-18

all etf 1-min files

  file:    by_date/etf_1min/2020/2020-03-18.parquet
  size:    5.3 MB
  rows:    267,639

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-03-18 04:00:00	SPY	ETF	240.5	240.5	239.4	239.75	10518.0
2020-03-18 04:01:00	SPY	ETF	239.6	239.76	239.5	239.52	11139.0
2020-03-18 04:02:00	SPY	ETF	239.62	240.1	239.51	240.1	7529.0
2020-03-18 04:03:00	SPY	ETF	240.1	240.14	239.91	239.95	7795.0
2020-03-18 04:04:00	SPY	ETF	239.6	240.61	239.5	239.5	11386.0
2020-03-18 04:05:00	SPY	ETF	239.96	239.98	239.08	239.94	6461.0
2020-03-18 04:06:00	SPY	ETF	239.36	239.51	238.5	238.95	9058.0
2020-03-18 04:07:00	SPY	ETF	238.95	239.31	238.75	239.0	9866.0
2020-03-18 04:08:00	SPY	ETF	239.01	239.01	238.9	239.0	2440.0
2020-03-18 04:09:00	SPY	ETF	239.0	239.18	238.62	238.7	1418.0
2020-03-18 04:10:00	SPY	ETF	238.71	239.0	238.62	238.99	8759.0
2020-03-18 04:11:00	SPY	ETF	238.65	239.18	238.65	239.18	4736.0
2020-03-18 04:12:00	SPY	ETF	239.18	239.62	239.18	239.62	557.0
2020-03-18 04:13:00	SPY	ETF	239.29	239.29	239.08	239.08	404.0
2020-03-18 04:14:00	SPY	ETF	239.08	239.08	238.99	238.99	418.0
2020-03-18 04:16:00	SPY	ETF	238.8	239.0	238.61	238.75	3613.0
2020-03-18 04:17:00	SPY	ETF	238.61	239.0	238.61	238.61	5305.0
2020-03-18 04:18:00	SPY	ETF	238.79	239.08	238.66	239.08	3078.0
2020-03-18 04:19:00	SPY	ETF	239.08	239.23	239.08	239.23	501.0
2020-03-18 04:20:00	SPY	ETF	238.8	238.93	238.78	238.9	822.0
2020-03-18 04:21:00	SPY	ETF	238.9	239.45	238.9	239.45	2095.0
2020-03-18 04:22:00	SPY	ETF	239.5	239.75	239.36	239.75	2870.0
2020-03-18 04:23:00	SPY	ETF	239.52	239.88	239.3	239.88	1182.0
2020-03-18 04:24:00	SPY	ETF	239.85	239.89	239.83	239.83	2860.0
2020-03-18 04:25:00	SPY	ETF	239.89	239.89	239.4	239.4	3882.0
2020-03-18 04:26:00	SPY	ETF	239.48	239.64	239.0	239.0	3870.0
2020-03-18 04:27:00	SPY	ETF	239.4	239.4	239.4	239.4	295.0
2020-03-18 04:28:00	SPY	ETF	239.15	239.3	239.15	239.15	1677.0
2020-03-18 04:29:00	SPY	ETF	239.15	239.3	238.79	239.3	4710.0
2020-03-18 04:30:00	SPY	ETF	238.55	238.55	238.55	238.55	351.0
2020-03-18 04:31:00	SPY	ETF	238.7	238.7	238.66	238.66	470.0
2020-03-18 04:32:00	SPY	ETF	238.53	239.18	238.53	239.18	2371.0
2020-03-18 04:33:00	SPY	ETF	239.18	239.2	238.77	239.01	4750.0
2020-03-18 04:34:00	SPY	ETF	238.9	238.9	238.63	238.75	3265.0
2020-03-18 04:35:00	SPY	ETF	238.66	238.66	238.5	238.56	4951.0
2020-03-18 04:36:00	SPY	ETF	238.56	239.0	238.5	239.0	1960.0
2020-03-18 04:37:00	SPY	ETF	239.15	239.2	239.0	239.2	1150.0
2020-03-18 04:38:00	SPY	ETF	239.18	239.2	239.0	239.0	1009.0
2020-03-18 04:39:00	SPY	ETF	239.07	239.18	239.04	239.18	7605.0
2020-03-18 04:40:00	SPY	ETF	239.18	239.3	239.17	239.29	5455.0
2020-03-18 04:41:00	SPY	ETF	239.29	239.29	239.0	239.1	4770.0
2020-03-18 04:42:00	SPY	ETF	239.29	239.49	239.27	239.49	2268.0
2020-03-18 04:43:00	SPY	ETF	239.48	239.48	239.48	239.48	272.0
2020-03-18 04:44:00	SPY	ETF	239.1	239.95	239.1	239.95	5607.0
2020-03-18 04:45:00	SPY	ETF	239.98	240.0	239.98	240.0	3258.0
2020-03-18 04:46:00	SPY	ETF	239.98	239.98	239.98	239.98	525.0
2020-03-18 04:48:00	SPY	ETF	239.78	239.78	239.78	239.78	304.0
2020-03-18 04:50:00	SPY	ETF	239.77	239.98	239.28	239.98	2684.0
2020-03-18 04:51:00	SPY	ETF	239.33	239.33	239.33	239.33	308.0
2020-03-18 04:53:00	SPY	ETF	239.4	239.49	239.28	239.49	2698.0

> showing 50 of 267,639 rows — these rows as CSV

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