PREVIEW / etf_1min / 2020-03-23

all etf 1-min files

  file:    by_date/etf_1min/2020/2020-03-23.parquet
  size:    5.3 MB
  rows:    277,588

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-23 04:00:00	SPY	ETF	221.14	222.0	221.14	221.8	34153.0
2020-03-23 04:01:00	SPY	ETF	221.8	221.95	221.8	221.85	14431.0
2020-03-23 04:02:00	SPY	ETF	221.85	221.94	221.49	221.49	12081.0
2020-03-23 04:03:00	SPY	ETF	221.5	221.5	221.09	221.27	3486.0
2020-03-23 04:04:00	SPY	ETF	221.2	221.2	220.7	220.71	3460.0
2020-03-23 04:05:00	SPY	ETF	220.69	220.92	220.42	220.92	10771.0
2020-03-23 04:06:00	SPY	ETF	220.82	221.13	220.51	221.13	8470.0
2020-03-23 04:07:00	SPY	ETF	221.1	221.45	221.1	221.3	3991.0
2020-03-23 04:08:00	SPY	ETF	221.35	221.71	221.01	221.58	7885.0
2020-03-23 04:09:00	SPY	ETF	221.13	221.5	220.9	221.5	7632.0
2020-03-23 04:10:00	SPY	ETF	221.5	221.63	221.37	221.37	2072.0
2020-03-23 04:11:00	SPY	ETF	221.5	221.5	221.38	221.38	1670.0
2020-03-23 04:12:00	SPY	ETF	221.11	221.11	220.82	220.99	3292.0
2020-03-23 04:13:00	SPY	ETF	220.84	220.86	220.44	220.51	12605.0
2020-03-23 04:14:00	SPY	ETF	220.79	220.8	220.6	220.75	3119.0
2020-03-23 04:15:00	SPY	ETF	220.6	220.6	220.0	220.0	12549.0
2020-03-23 04:16:00	SPY	ETF	220.32	220.39	220.3	220.39	871.0
2020-03-23 04:17:00	SPY	ETF	219.9	220.24	219.79	220.17	8597.0
2020-03-23 04:18:00	SPY	ETF	220.15	220.39	220.06	220.39	6187.0
2020-03-23 04:19:00	SPY	ETF	220.64	221.2	220.53	220.92	3340.0
2020-03-23 04:20:00	SPY	ETF	220.98	220.98	220.57	220.57	1281.0
2020-03-23 04:21:00	SPY	ETF	220.58	220.72	220.2	220.7	3911.0
2020-03-23 04:22:00	SPY	ETF	220.22	220.26	220.0	220.26	963.0
2020-03-23 04:23:00	SPY	ETF	220.05	220.05	219.89	219.89	4000.0
2020-03-23 04:24:00	SPY	ETF	219.87	219.96	219.87	219.92	1800.0
2020-03-23 04:25:00	SPY	ETF	220.0	220.18	220.0	220.01	1946.0
2020-03-23 04:26:00	SPY	ETF	220.06	220.06	220.05	220.06	1462.0
2020-03-23 04:27:00	SPY	ETF	220.26	220.7	220.26	220.7	3801.0
2020-03-23 04:28:00	SPY	ETF	220.5	220.78	220.5	220.5	926.0
2020-03-23 04:29:00	SPY	ETF	220.7	221.21	220.7	220.94	3186.0
2020-03-23 04:30:00	SPY	ETF	221.2	221.35	221.01	221.01	16668.0
2020-03-23 04:31:00	SPY	ETF	220.88	221.04	220.88	221.0	900.0
2020-03-23 04:32:00	SPY	ETF	220.94	220.94	220.94	220.94	100.0
2020-03-23 04:33:00	SPY	ETF	220.6	220.63	220.5	220.63	2780.0
2020-03-23 04:34:00	SPY	ETF	220.7	221.03	220.7	221.03	2129.0
2020-03-23 04:35:00	SPY	ETF	221.35	221.8	221.24	221.76	7639.0
2020-03-23 04:36:00	SPY	ETF	221.64	221.7	221.51	221.7	3715.0
2020-03-23 04:37:00	SPY	ETF	221.63	221.63	220.8	220.8	1126.0
2020-03-23 04:38:00	SPY	ETF	221.02	221.36	220.99	220.99	2008.0
2020-03-23 04:39:00	SPY	ETF	221.01	221.01	220.8	220.84	8941.0
2020-03-23 04:40:00	SPY	ETF	221.0	221.23	220.9	221.23	5795.0
2020-03-23 04:41:00	SPY	ETF	221.31	221.31	221.31	221.31	211.0
2020-03-23 04:42:00	SPY	ETF	221.2	221.35	221.2	221.35	1478.0
2020-03-23 04:44:00	SPY	ETF	221.4	221.4	221.15	221.26	4624.0
2020-03-23 04:45:00	SPY	ETF	221.35	221.86	221.33	221.74	3653.0
2020-03-23 04:46:00	SPY	ETF	221.85	221.85	221.5	221.64	1720.0
2020-03-23 04:47:00	SPY	ETF	221.75	221.87	221.59	221.61	2235.0
2020-03-23 04:48:00	SPY	ETF	221.5	221.55	221.5	221.55	745.0
2020-03-23 04:49:00	SPY	ETF	221.64	221.9	221.55	221.55	2348.0
2020-03-23 04:50:00	SPY	ETF	221.31	221.31	221.15	221.26	1196.0

> showing 50 of 277,588 rows — these rows as CSV

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