PREVIEW / etf_1min / 2020-07-01

all etf 1-min files

  file:    by_date/etf_1min/2020/2020-07-01.parquet
  size:    3.7 MB
  rows:    209,051

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-01 04:00:00	SPY	ETF	308.74	308.74	308.74	308.74	656.0
2020-07-01 04:01:00	SPY	ETF	308.77	308.77	308.76	308.77	2594.0
2020-07-01 04:02:00	SPY	ETF	308.77	308.84	308.77	308.84	807.0
2020-07-01 04:04:00	SPY	ETF	308.84	308.89	308.84	308.89	501.0
2020-07-01 04:05:00	SPY	ETF	308.97	309.02	308.94	309.02	781.0
2020-07-01 04:09:00	SPY	ETF	309.0	309.0	308.97	308.98	11359.0
2020-07-01 04:13:00	SPY	ETF	309.04	309.12	309.04	309.12	1778.0
2020-07-01 04:14:00	SPY	ETF	309.08	309.08	309.07	309.08	3000.0
2020-07-01 04:15:00	SPY	ETF	309.0	309.0	309.0	309.0	2011.0
2020-07-01 04:16:00	SPY	ETF	308.98	308.98	308.9	308.9	360.0
2020-07-01 04:19:00	SPY	ETF	308.6	308.6	308.6	308.6	187.0
2020-07-01 04:25:00	SPY	ETF	308.6	308.6	308.6	308.6	309.0
2020-07-01 04:26:00	SPY	ETF	308.5	308.5	308.5	308.5	431.0
2020-07-01 04:30:00	SPY	ETF	308.7	308.7	308.7	308.7	250.0
2020-07-01 04:32:00	SPY	ETF	308.63	308.63	308.63	308.63	100.0
2020-07-01 04:34:00	SPY	ETF	308.65	308.65	308.65	308.65	401.0
2020-07-01 04:45:00	SPY	ETF	308.61	308.61	308.61	308.61	105.0
2020-07-01 04:50:00	SPY	ETF	308.6	308.6	308.6	308.6	100.0
2020-07-01 04:54:00	SPY	ETF	308.68	308.68	308.68	308.68	100.0
2020-07-01 04:55:00	SPY	ETF	308.68	308.68	308.68	308.68	300.0
2020-07-01 04:57:00	SPY	ETF	308.8	308.8	308.76	308.76	733.0
2020-07-01 04:59:00	SPY	ETF	308.75	308.75	308.75	308.75	500.0
2020-07-01 05:03:00	SPY	ETF	308.88	308.9	308.86	308.9	791.0
2020-07-01 05:07:00	SPY	ETF	308.94	308.96	308.94	308.96	595.0
2020-07-01 05:08:00	SPY	ETF	308.93	309.0	308.93	309.0	825.0
2020-07-01 05:11:00	SPY	ETF	309.05	309.07	309.05	309.07	560.0
2020-07-01 05:12:00	SPY	ETF	309.08	309.1	309.08	309.1	790.0
2020-07-01 05:13:00	SPY	ETF	309.03	309.03	309.03	309.03	100.0
2020-07-01 05:14:00	SPY	ETF	309.05	309.05	309.05	309.05	110.0
2020-07-01 05:15:00	SPY	ETF	309.03	309.05	309.03	309.05	540.0
2020-07-01 05:19:00	SPY	ETF	309.05	309.08	309.05	309.08	225.0
2020-07-01 05:20:00	SPY	ETF	309.08	309.08	309.08	309.08	101.0
2020-07-01 05:21:00	SPY	ETF	309.1	309.15	309.1	309.15	2711.0
2020-07-01 05:23:00	SPY	ETF	309.1	309.13	309.1	309.1	700.0
2020-07-01 05:25:00	SPY	ETF	309.05	309.05	309.05	309.05	520.0
2020-07-01 05:26:00	SPY	ETF	309.12	309.15	309.12	309.15	405.0
2020-07-01 05:28:00	SPY	ETF	309.18	309.34	309.18	309.34	1702.0
2020-07-01 05:29:00	SPY	ETF	309.34	309.34	309.34	309.34	301.0
2020-07-01 05:30:00	SPY	ETF	309.36	309.37	309.36	309.37	415.0
2020-07-01 05:31:00	SPY	ETF	309.3	309.3	309.07	309.07	708.0
2020-07-01 05:32:00	SPY	ETF	309.06	309.06	309.06	309.06	236.0
2020-07-01 05:33:00	SPY	ETF	309.1	309.1	309.1	309.1	152.0
2020-07-01 05:35:00	SPY	ETF	309.0	309.0	308.85	308.85	988.0
2020-07-01 05:37:00	SPY	ETF	308.97	308.97	308.97	308.97	401.0
2020-07-01 05:38:00	SPY	ETF	308.95	308.95	308.95	308.95	235.0
2020-07-01 05:39:00	SPY	ETF	309.02	309.02	309.02	309.02	500.0
2020-07-01 05:40:00	SPY	ETF	308.9	308.9	308.73	308.81	2608.0
2020-07-01 05:41:00	SPY	ETF	308.65	308.65	308.63	308.63	701.0
2020-07-01 05:42:00	SPY	ETF	308.6	308.6	308.5	308.5	710.0
2020-07-01 05:43:00	SPY	ETF	308.57	308.57	308.45	308.45	1100.0

> showing 50 of 209,051 rows — these rows as CSV

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