PREVIEW / etf_1min / 2020-05-19

all etf 1-min files

  file:    by_date/etf_1min/2020/2020-05-19.parquet
  size:    3.7 MB
  rows:    212,873

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-05-19 04:00:00	SPY	ETF	295.43	295.45	295.25	295.45	3381.0
2020-05-19 04:01:00	SPY	ETF	295.63	295.64	295.57	295.58	7370.0
2020-05-19 04:02:00	SPY	ETF	295.58	295.58	295.39	295.39	11924.0
2020-05-19 04:03:00	SPY	ETF	295.36	295.36	295.0	295.06	4202.0
2020-05-19 04:04:00	SPY	ETF	295.11	295.11	295.11	295.11	455.0
2020-05-19 04:05:00	SPY	ETF	295.13	295.16	295.13	295.16	472.0
2020-05-19 04:06:00	SPY	ETF	294.91	294.91	294.91	294.91	232.0
2020-05-19 04:07:00	SPY	ETF	294.85	294.85	294.41	294.47	4201.0
2020-05-19 04:08:00	SPY	ETF	294.62	294.69	294.59	294.69	1500.0
2020-05-19 04:09:00	SPY	ETF	294.68	294.8	294.64	294.8	3508.0
2020-05-19 04:10:00	SPY	ETF	294.75	294.75	294.7	294.7	392.0
2020-05-19 04:11:00	SPY	ETF	294.7	294.78	294.7	294.78	383.0
2020-05-19 04:12:00	SPY	ETF	294.51	294.63	294.4	294.6	3609.0
2020-05-19 04:13:00	SPY	ETF	294.59	294.73	294.59	294.68	656.0
2020-05-19 04:14:00	SPY	ETF	294.6	294.73	294.6	294.73	650.0
2020-05-19 04:15:00	SPY	ETF	294.67	294.68	294.64	294.64	1350.0
2020-05-19 04:16:00	SPY	ETF	294.48	294.6	294.48	294.6	445.0
2020-05-19 04:17:00	SPY	ETF	294.79	294.79	294.72	294.72	203.0
2020-05-19 04:18:00	SPY	ETF	294.75	294.88	294.75	294.88	1830.0
2020-05-19 04:19:00	SPY	ETF	294.86	294.94	294.86	294.94	4820.0
2020-05-19 04:20:00	SPY	ETF	294.96	294.96	294.92	294.92	726.0
2020-05-19 04:21:00	SPY	ETF	294.79	294.83	294.72	294.72	910.0
2020-05-19 04:22:00	SPY	ETF	294.26	294.26	294.23	294.25	2131.0
2020-05-19 04:23:00	SPY	ETF	294.37	294.37	294.26	294.26	3495.0
2020-05-19 04:24:00	SPY	ETF	294.15	294.15	294.08	294.08	1907.0
2020-05-19 04:25:00	SPY	ETF	294.04	294.07	293.97	294.02	7119.0
2020-05-19 04:26:00	SPY	ETF	294.08	294.19	294.08	294.19	360.0
2020-05-19 04:27:00	SPY	ETF	294.24	294.24	294.24	294.24	1000.0
2020-05-19 04:28:00	SPY	ETF	294.29	294.33	294.1	294.1	3149.0
2020-05-19 04:29:00	SPY	ETF	293.99	293.99	293.95	293.99	714.0
2020-05-19 04:30:00	SPY	ETF	294.02	294.02	294.02	294.02	160.0
2020-05-19 04:31:00	SPY	ETF	294.1	294.1	294.1	294.1	300.0
2020-05-19 04:32:00	SPY	ETF	294.08	294.08	294.03	294.03	1310.0
2020-05-19 04:33:00	SPY	ETF	293.98	293.98	293.98	293.98	1083.0
2020-05-19 04:35:00	SPY	ETF	293.99	294.01	293.99	294.01	821.0
2020-05-19 04:36:00	SPY	ETF	293.92	293.92	293.56	293.69	2411.0
2020-05-19 04:37:00	SPY	ETF	293.78	294.07	293.78	294.07	525.0
2020-05-19 04:38:00	SPY	ETF	294.09	294.09	294.09	294.09	200.0
2020-05-19 04:40:00	SPY	ETF	293.91	293.91	293.91	293.91	110.0
2020-05-19 04:41:00	SPY	ETF	294.26	294.26	294.26	294.26	100.0
2020-05-19 04:42:00	SPY	ETF	294.35	294.44	294.35	294.36	3220.0
2020-05-19 04:43:00	SPY	ETF	294.56	294.56	294.5	294.51	374.0
2020-05-19 04:44:00	SPY	ETF	294.4	294.4	294.4	294.4	1000.0
2020-05-19 04:45:00	SPY	ETF	294.34	294.43	294.3	294.43	640.0
2020-05-19 04:46:00	SPY	ETF	294.58	294.6	294.58	294.6	438.0
2020-05-19 04:47:00	SPY	ETF	294.65	294.65	294.65	294.65	123.0
2020-05-19 04:48:00	SPY	ETF	294.57	294.57	294.57	294.57	210.0
2020-05-19 04:49:00	SPY	ETF	294.62	294.65	294.62	294.62	650.0
2020-05-19 04:50:00	SPY	ETF	294.53	294.53	294.53	294.53	850.0
2020-05-19 04:51:00	SPY	ETF	294.37	294.4	294.37	294.4	720.0

> showing 50 of 212,873 rows — these rows as CSV

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