PREVIEW / etf_1min / 2020-08-06

all etf 1-min files

  file:    by_date/etf_1min/2020/2020-08-06.parquet
  size:    3.7 MB
  rows:    206,746

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-08-06 04:00:00	SPY	ETF	332.25	332.26	332.19	332.19	524.0
2020-08-06 04:01:00	SPY	ETF	332.16	332.16	332.16	332.16	210.0
2020-08-06 04:02:00	SPY	ETF	332.15	332.15	332.13	332.13	379.0
2020-08-06 04:03:00	SPY	ETF	332.08	332.08	332.08	332.08	115.0
2020-08-06 04:04:00	SPY	ETF	332.09	332.09	332.09	332.09	475.0
2020-08-06 04:06:00	SPY	ETF	332.08	332.1	332.08	332.1	507.0
2020-08-06 04:08:00	SPY	ETF	332.05	332.05	332.05	332.05	100.0
2020-08-06 04:09:00	SPY	ETF	332.07	332.07	332.07	332.07	334.0
2020-08-06 04:16:00	SPY	ETF	331.83	331.85	331.83	331.85	286.0
2020-08-06 04:20:00	SPY	ETF	331.9	331.9	331.9	331.9	1078.0
2020-08-06 04:21:00	SPY	ETF	331.92	331.92	331.92	331.92	100.0
2020-08-06 04:24:00	SPY	ETF	331.93	331.93	331.93	331.93	100.0
2020-08-06 04:28:00	SPY	ETF	332.06	332.06	332.06	332.06	150.0
2020-08-06 04:30:00	SPY	ETF	331.97	331.97	331.9	331.9	373.0
2020-08-06 04:31:00	SPY	ETF	332.08	332.08	332.08	332.08	200.0
2020-08-06 04:34:00	SPY	ETF	331.89	331.89	331.89	331.89	180.0
2020-08-06 04:36:00	SPY	ETF	331.91	331.91	331.91	331.91	331.0
2020-08-06 04:38:00	SPY	ETF	331.73	331.73	331.66	331.66	368.0
2020-08-06 04:40:00	SPY	ETF	331.65	331.71	331.65	331.71	530.0
2020-08-06 04:49:00	SPY	ETF	331.73	331.73	331.73	331.73	130.0
2020-08-06 04:53:00	SPY	ETF	331.83	331.83	331.83	331.83	110.0
2020-08-06 04:54:00	SPY	ETF	331.91	331.91	331.91	331.91	100.0
2020-08-06 04:59:00	SPY	ETF	331.83	331.83	331.83	331.83	700.0
2020-08-06 05:00:00	SPY	ETF	331.73	331.75	331.73	331.75	2000.0
2020-08-06 05:01:00	SPY	ETF	331.87	331.87	331.87	331.87	1060.0
2020-08-06 05:02:00	SPY	ETF	331.9	331.93	331.9	331.93	340.0
2020-08-06 05:10:00	SPY	ETF	332.01	332.02	332.01	332.02	4025.0
2020-08-06 05:11:00	SPY	ETF	332.02	332.02	332.02	332.02	985.0
2020-08-06 05:15:00	SPY	ETF	331.96	331.96	331.96	331.96	100.0
2020-08-06 05:17:00	SPY	ETF	331.87	331.87	331.87	331.87	120.0
2020-08-06 05:18:00	SPY	ETF	331.83	331.83	331.8	331.8	505.0
2020-08-06 05:26:00	SPY	ETF	332.01	332.01	332.01	332.01	323.0
2020-08-06 05:29:00	SPY	ETF	331.9	331.9	331.9	331.9	200.0
2020-08-06 05:31:00	SPY	ETF	331.9	331.9	331.9	331.9	300.0
2020-08-06 05:40:00	SPY	ETF	332.01	332.01	332.01	332.01	800.0
2020-08-06 05:42:00	SPY	ETF	332.0	332.0	331.93	331.93	482.0
2020-08-06 05:49:00	SPY	ETF	331.99	331.99	331.99	331.99	180.0
2020-08-06 05:50:00	SPY	ETF	331.96	331.96	331.93	331.93	500.0
2020-08-06 05:51:00	SPY	ETF	331.98	331.98	331.98	331.98	710.0
2020-08-06 05:53:00	SPY	ETF	331.94	331.94	331.94	331.94	500.0
2020-08-06 05:55:00	SPY	ETF	332.01	332.01	332.0	332.0	505.0
2020-08-06 05:56:00	SPY	ETF	332.08	332.08	332.08	332.08	100.0
2020-08-06 05:57:00	SPY	ETF	332.06	332.06	332.06	332.06	5000.0
2020-08-06 06:00:00	SPY	ETF	332.04	332.04	332.04	332.04	406.0
2020-08-06 06:01:00	SPY	ETF	332.01	332.01	332.01	332.01	420.0
2020-08-06 06:04:00	SPY	ETF	332.05	332.05	332.05	332.05	199.0
2020-08-06 06:11:00	SPY	ETF	331.96	331.96	331.96	331.96	100.0
2020-08-06 06:13:00	SPY	ETF	331.95	331.95	331.95	331.95	100.0
2020-08-06 06:15:00	SPY	ETF	331.92	331.92	331.92	331.92	100.0
2020-08-06 06:18:00	SPY	ETF	331.91	331.91	331.88	331.88	5100.0

> showing 50 of 206,746 rows — these rows as CSV

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