PREVIEW / etf_1min / 2020-03-26

all etf 1-min files

  file:    by_date/etf_1min/2020/2020-03-26.parquet
  size:    5.1 MB
  rows:    264,277

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-26 04:00:00	SPY	ETF	242.23	242.54	241.12	241.12	18373.0
2020-03-26 04:01:00	SPY	ETF	242.25	242.52	242.25	242.41	3595.0
2020-03-26 04:02:00	SPY	ETF	242.35	242.55	242.35	242.52	5751.0
2020-03-26 04:03:00	SPY	ETF	242.61	242.86	242.5	242.82	12241.0
2020-03-26 04:04:00	SPY	ETF	242.93	243.06	242.82	242.87	6175.0
2020-03-26 04:05:00	SPY	ETF	242.99	243.31	242.99	243.31	8722.0
2020-03-26 04:06:00	SPY	ETF	243.23	243.41	243.21	243.41	3546.0
2020-03-26 04:07:00	SPY	ETF	243.85	243.85	243.71	243.71	843.0
2020-03-26 04:08:00	SPY	ETF	243.51	243.62	243.51	243.62	467.0
2020-03-26 04:09:00	SPY	ETF	243.64	243.75	243.35	243.35	2450.0
2020-03-26 04:10:00	SPY	ETF	243.14	243.34	243.14	243.34	7928.0
2020-03-26 04:11:00	SPY	ETF	242.94	242.95	242.81	242.95	4583.0
2020-03-26 04:12:00	SPY	ETF	243.0	243.05	242.9	242.9	630.0
2020-03-26 04:13:00	SPY	ETF	242.71	242.71	242.46	242.5	2662.0
2020-03-26 04:14:00	SPY	ETF	242.36	242.36	242.18	242.19	39830.0
2020-03-26 04:15:00	SPY	ETF	242.48	242.67	242.48	242.56	3027.0
2020-03-26 04:16:00	SPY	ETF	242.25	242.25	242.11	242.13	2626.0
2020-03-26 04:17:00	SPY	ETF	242.26	242.26	241.88	242.0	4640.0
2020-03-26 04:18:00	SPY	ETF	242.0	242.0	241.73	241.73	11221.0
2020-03-26 04:19:00	SPY	ETF	241.87	241.87	241.71	241.78	11820.0
2020-03-26 04:20:00	SPY	ETF	241.83	241.83	241.78	241.81	1740.0
2020-03-26 04:21:00	SPY	ETF	242.18	242.18	242.18	242.18	963.0
2020-03-26 04:22:00	SPY	ETF	242.41	242.41	242.3	242.3	335.0
2020-03-26 04:23:00	SPY	ETF	241.76	241.76	241.52	241.61	5210.0
2020-03-26 04:24:00	SPY	ETF	241.59	241.86	241.56	241.86	11660.0
2020-03-26 04:25:00	SPY	ETF	242.0	242.07	241.98	241.98	1525.0
2020-03-26 04:26:00	SPY	ETF	242.22	242.5	242.22	242.35	3951.0
2020-03-26 04:27:00	SPY	ETF	241.91	241.91	241.75	241.75	2720.0
2020-03-26 04:28:00	SPY	ETF	241.54	241.87	241.54	241.87	1992.0
2020-03-26 04:29:00	SPY	ETF	241.8	241.88	241.8	241.88	5312.0
2020-03-26 04:30:00	SPY	ETF	241.89	242.59	241.87	242.57	5284.0
2020-03-26 04:31:00	SPY	ETF	242.51	242.61	242.42	242.54	3488.0
2020-03-26 04:33:00	SPY	ETF	242.38	242.48	242.38	242.39	11275.0
2020-03-26 04:34:00	SPY	ETF	242.26	242.64	242.18	242.64	3612.0
2020-03-26 04:35:00	SPY	ETF	242.72	242.72	242.35	242.35	605.0
2020-03-26 04:36:00	SPY	ETF	242.5	242.5	242.15	242.15	2700.0
2020-03-26 04:37:00	SPY	ETF	242.04	242.1	241.98	242.1	1024.0
2020-03-26 04:38:00	SPY	ETF	242.15	242.15	241.91	241.91	2001.0
2020-03-26 04:40:00	SPY	ETF	241.76	242.0	241.75	242.0	755.0
2020-03-26 04:41:00	SPY	ETF	241.7	241.7	241.5	241.5	2486.0
2020-03-26 04:42:00	SPY	ETF	241.5	241.5	241.43	241.44	4364.0
2020-03-26 04:43:00	SPY	ETF	241.59	241.59	241.5	241.5	930.0
2020-03-26 04:44:00	SPY	ETF	241.66	241.77	241.66	241.77	620.0
2020-03-26 04:45:00	SPY	ETF	241.66	241.86	241.66	241.86	2220.0
2020-03-26 04:47:00	SPY	ETF	241.91	242.09	241.91	242.09	6255.0
2020-03-26 04:48:00	SPY	ETF	242.06	242.25	242.06	242.25	11830.0
2020-03-26 04:49:00	SPY	ETF	242.24	242.41	242.24	242.41	5377.0
2020-03-26 04:50:00	SPY	ETF	242.33	242.35	242.23	242.29	3715.0
2020-03-26 04:51:00	SPY	ETF	242.34	242.34	242.21	242.21	968.0
2020-03-26 04:52:00	SPY	ETF	241.77	241.83	241.76	241.83	3101.0

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

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