PREVIEW / etf_1min / 2020-07-20

all etf 1-min files

  file:    by_date/etf_1min/2020/2020-07-20.parquet
  size:    3.6 MB
  rows:    200,138

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-07-20 04:00:00	SPY	ETF	319.92	320.06	319.9	320.04	2868.0
2020-07-20 04:01:00	SPY	ETF	319.99	319.99	319.96	319.96	901.0
2020-07-20 04:02:00	SPY	ETF	319.97	319.97	319.96	319.96	472.0
2020-07-20 04:03:00	SPY	ETF	319.93	319.94	319.93	319.94	433.0
2020-07-20 04:04:00	SPY	ETF	319.87	319.87	319.87	319.87	1179.0
2020-07-20 04:05:00	SPY	ETF	319.9	319.94	319.89	319.94	871.0
2020-07-20 04:06:00	SPY	ETF	319.87	319.87	319.84	319.84	427.0
2020-07-20 04:07:00	SPY	ETF	319.81	319.81	319.78	319.78	790.0
2020-07-20 04:09:00	SPY	ETF	319.76	319.82	319.75	319.75	548.0
2020-07-20 04:12:00	SPY	ETF	319.8	319.8	319.69	319.69	736.0
2020-07-20 04:14:00	SPY	ETF	319.64	319.69	319.62	319.69	415.0
2020-07-20 04:15:00	SPY	ETF	319.69	319.69	319.69	319.69	313.0
2020-07-20 04:16:00	SPY	ETF	319.67	319.67	319.67	319.67	2500.0
2020-07-20 04:17:00	SPY	ETF	319.96	319.96	319.96	319.96	325.0
2020-07-20 04:18:00	SPY	ETF	319.88	319.88	319.88	319.88	200.0
2020-07-20 04:21:00	SPY	ETF	319.87	319.87	319.87	319.87	500.0
2020-07-20 04:22:00	SPY	ETF	319.8	319.8	319.8	319.8	430.0
2020-07-20 04:25:00	SPY	ETF	319.84	319.88	319.84	319.88	200.0
2020-07-20 04:26:00	SPY	ETF	319.89	319.89	319.89	319.89	130.0
2020-07-20 04:30:00	SPY	ETF	319.95	319.95	319.87	319.87	456.0
2020-07-20 04:31:00	SPY	ETF	319.82	319.82	319.82	319.82	370.0
2020-07-20 04:32:00	SPY	ETF	319.81	319.81	319.81	319.81	120.0
2020-07-20 04:33:00	SPY	ETF	319.78	319.78	319.78	319.78	166.0
2020-07-20 04:34:00	SPY	ETF	319.95	319.99	319.95	319.99	762.0
2020-07-20 04:36:00	SPY	ETF	320.04	320.04	320.04	320.04	101.0
2020-07-20 04:37:00	SPY	ETF	320.06	320.06	320.06	320.06	110.0
2020-07-20 04:38:00	SPY	ETF	320.07	320.09	320.07	320.09	500.0
2020-07-20 04:39:00	SPY	ETF	320.14	320.14	320.14	320.14	280.0
2020-07-20 04:40:00	SPY	ETF	320.26	320.26	320.26	320.26	631.0
2020-07-20 04:41:00	SPY	ETF	320.42	320.42	320.37	320.37	530.0
2020-07-20 04:42:00	SPY	ETF	320.36	320.39	320.36	320.39	1214.0
2020-07-20 04:43:00	SPY	ETF	320.49	320.49	320.48	320.48	300.0
2020-07-20 04:44:00	SPY	ETF	320.56	320.67	320.55	320.67	3235.0
2020-07-20 04:45:00	SPY	ETF	320.77	320.77	320.77	320.77	145.0
2020-07-20 04:46:00	SPY	ETF	320.7	320.7	320.7	320.7	114.0
2020-07-20 04:47:00	SPY	ETF	320.75	320.75	320.75	320.75	505.0
2020-07-20 04:52:00	SPY	ETF	320.86	320.87	320.85	320.87	1255.0
2020-07-20 04:55:00	SPY	ETF	320.81	320.81	320.81	320.81	250.0
2020-07-20 04:56:00	SPY	ETF	320.85	320.85	320.85	320.85	2500.0
2020-07-20 04:57:00	SPY	ETF	320.9	320.91	320.9	320.91	2000.0
2020-07-20 04:59:00	SPY	ETF	320.86	320.86	320.85	320.85	300.0
2020-07-20 05:00:00	SPY	ETF	321.0	321.0	321.0	321.0	612.0
2020-07-20 05:01:00	SPY	ETF	321.03	321.03	321.03	321.03	130.0
2020-07-20 05:02:00	SPY	ETF	321.21	321.22	321.21	321.22	1115.0
2020-07-20 05:03:00	SPY	ETF	321.26	321.27	321.15	321.15	1410.0
2020-07-20 05:05:00	SPY	ETF	321.03	321.03	321.03	321.03	210.0
2020-07-20 05:09:00	SPY	ETF	321.05	321.05	321.05	321.05	501.0
2020-07-20 05:11:00	SPY	ETF	321.16	321.27	321.16	321.27	2099.0
2020-07-20 05:12:00	SPY	ETF	321.2	321.2	321.2	321.2	3200.0
2020-07-20 05:13:00	SPY	ETF	321.17	321.2	321.16	321.2	2299.0

> showing 50 of 200,138 rows — these rows as CSV

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