PREVIEW / etf_1min / 2020-03-19

all etf 1-min files

  file:    by_date/etf_1min/2020/2020-03-19.parquet
  size:    5.2 MB
  rows:    264,474

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-19 04:00:00	SPY	ETF	240.23	240.23	236.01	237.82	24582.0
2020-03-19 04:01:00	SPY	ETF	237.52	238.69	237.52	238.38	7884.0
2020-03-19 04:02:00	SPY	ETF	238.56	239.4	238.5	238.89	10457.0
2020-03-19 04:03:00	SPY	ETF	238.98	239.76	238.79	239.5	5859.0
2020-03-19 04:04:00	SPY	ETF	239.4	239.4	239.03	239.03	923.0
2020-03-19 04:05:00	SPY	ETF	239.12	239.13	238.23	238.48	5428.0
2020-03-19 04:06:00	SPY	ETF	238.5	238.5	237.77	237.77	4568.0
2020-03-19 04:07:00	SPY	ETF	237.75	237.9	237.45	237.82	3553.0
2020-03-19 04:08:00	SPY	ETF	237.62	237.62	237.61	237.61	967.0
2020-03-19 04:09:00	SPY	ETF	237.2	237.63	237.2	237.43	754.0
2020-03-19 04:10:00	SPY	ETF	238.03	238.08	237.74	238.08	2750.0
2020-03-19 04:12:00	SPY	ETF	239.05	239.05	239.0	239.0	1714.0
2020-03-19 04:13:00	SPY	ETF	238.87	238.88	238.2	238.26	3472.0
2020-03-19 04:14:00	SPY	ETF	238.31	238.31	237.66	237.73	1477.0
2020-03-19 04:15:00	SPY	ETF	238.69	238.96	238.3	238.39	700.0
2020-03-19 04:16:00	SPY	ETF	238.82	239.19	238.48	239.19	1625.0
2020-03-19 04:17:00	SPY	ETF	239.55	239.61	238.95	238.96	6020.0
2020-03-19 04:18:00	SPY	ETF	239.28	239.52	239.28	239.4	5498.0
2020-03-19 04:19:00	SPY	ETF	239.5	240.15	239.5	240.03	3940.0
2020-03-19 04:20:00	SPY	ETF	239.98	239.98	239.98	239.98	460.0
2020-03-19 04:21:00	SPY	ETF	240.6	240.79	240.49	240.66	2508.0
2020-03-19 04:22:00	SPY	ETF	240.63	241.17	240.63	241.17	6752.0
2020-03-19 04:23:00	SPY	ETF	240.74	241.25	240.74	241.25	3995.0
2020-03-19 04:24:00	SPY	ETF	241.2	241.2	240.99	241.13	1073.0
2020-03-19 04:25:00	SPY	ETF	240.97	241.02	240.56	240.92	1855.0
2020-03-19 04:26:00	SPY	ETF	241.03	241.33	241.03	241.33	1250.0
2020-03-19 04:27:00	SPY	ETF	241.22	241.4	241.22	241.4	610.0
2020-03-19 04:28:00	SPY	ETF	241.46	241.59	241.45	241.51	4121.0
2020-03-19 04:29:00	SPY	ETF	241.65	241.85	241.53	241.81	5327.0
2020-03-19 04:30:00	SPY	ETF	241.89	242.19	241.81	242.19	1128.0
2020-03-19 04:31:00	SPY	ETF	241.74	242.34	241.55	242.31	75622.0
2020-03-19 04:32:00	SPY	ETF	242.34	242.75	242.08	242.74	65009.0
2020-03-19 04:33:00	SPY	ETF	242.85	243.17	242.85	243.03	7538.0
2020-03-19 04:34:00	SPY	ETF	242.83	242.95	242.5	242.8	4421.0
2020-03-19 04:35:00	SPY	ETF	242.92	242.92	242.49	242.54	3524.0
2020-03-19 04:36:00	SPY	ETF	242.94	243.06	242.76	243.06	9798.0
2020-03-19 04:37:00	SPY	ETF	242.82	242.92	242.81	242.87	15568.0
2020-03-19 04:38:00	SPY	ETF	242.74	242.94	242.53	242.6	7775.0
2020-03-19 04:39:00	SPY	ETF	242.69	242.78	242.12	242.12	24625.0
2020-03-19 04:40:00	SPY	ETF	242.12	242.15	241.32	242.02	17983.0
2020-03-19 04:41:00	SPY	ETF	242.24	242.24	242.1	242.18	3655.0
2020-03-19 04:42:00	SPY	ETF	241.93	242.14	241.93	242.14	1285.0
2020-03-19 04:43:00	SPY	ETF	241.89	242.08	241.78	242.05	1835.0
2020-03-19 04:44:00	SPY	ETF	241.96	241.99	241.96	241.99	652.0
2020-03-19 04:45:00	SPY	ETF	241.5	241.5	241.0	241.02	5314.0
2020-03-19 04:46:00	SPY	ETF	240.82	240.82	240.37	240.55	7328.0
2020-03-19 04:47:00	SPY	ETF	240.56	241.17	240.49	241.15	7045.0
2020-03-19 04:48:00	SPY	ETF	240.76	240.89	240.76	240.89	1250.0
2020-03-19 04:49:00	SPY	ETF	241.04	241.04	240.75	240.75	3258.0
2020-03-19 04:50:00	SPY	ETF	240.75	240.75	240.5	240.5	2710.0

> showing 50 of 264,474 rows — these rows as CSV

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