PREVIEW / etf_1min / 2020-06-03

all etf 1-min files

  file:    by_date/etf_1min/2020/2020-06-03.parquet
  size:    4.1 MB
  rows:    226,601

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-06-03 04:00:00	SPY	ETF	309.25	309.35	309.25	309.35	1391.0
2020-06-03 04:02:00	SPY	ETF	309.16	309.17	309.12	309.17	591.0
2020-06-03 04:03:00	SPY	ETF	309.29	309.32	309.29	309.32	1909.0
2020-06-03 04:05:00	SPY	ETF	309.33	309.33	309.33	309.33	280.0
2020-06-03 04:06:00	SPY	ETF	309.23	309.23	309.18	309.18	530.0
2020-06-03 04:07:00	SPY	ETF	309.09	309.09	309.06	309.08	512.0
2020-06-03 04:08:00	SPY	ETF	309.08	309.08	309.03	309.03	1557.0
2020-06-03 04:10:00	SPY	ETF	309.02	309.02	309.02	309.02	101.0
2020-06-03 04:13:00	SPY	ETF	308.92	308.98	308.9	308.98	3965.0
2020-06-03 04:16:00	SPY	ETF	308.86	308.86	308.86	308.86	502.0
2020-06-03 04:18:00	SPY	ETF	308.84	308.84	308.84	308.84	1570.0
2020-06-03 04:20:00	SPY	ETF	309.03	309.03	309.03	309.03	892.0
2020-06-03 04:21:00	SPY	ETF	309.08	309.08	309.08	309.08	700.0
2020-06-03 04:22:00	SPY	ETF	309.0	309.01	309.0	309.01	300.0
2020-06-03 04:23:00	SPY	ETF	309.0	309.0	309.0	309.0	324.0
2020-06-03 04:24:00	SPY	ETF	309.13	309.13	309.13	309.13	101.0
2020-06-03 04:30:00	SPY	ETF	309.13	309.13	309.08	309.08	856.0
2020-06-03 04:31:00	SPY	ETF	309.23	309.23	309.23	309.23	301.0
2020-06-03 04:32:00	SPY	ETF	309.33	309.33	309.33	309.33	502.0
2020-06-03 04:33:00	SPY	ETF	309.41	309.41	309.41	309.41	253.0
2020-06-03 04:36:00	SPY	ETF	309.36	309.36	309.36	309.36	340.0
2020-06-03 04:38:00	SPY	ETF	309.1	309.1	309.09	309.09	5310.0
2020-06-03 04:39:00	SPY	ETF	309.06	309.08	309.06	309.08	438.0
2020-06-03 04:40:00	SPY	ETF	309.13	309.13	309.08	309.08	600.0
2020-06-03 04:45:00	SPY	ETF	309.16	309.16	309.15	309.15	800.0
2020-06-03 04:46:00	SPY	ETF	309.22	309.22	309.22	309.22	506.0
2020-06-03 04:47:00	SPY	ETF	309.2	309.2	309.18	309.18	1500.0
2020-06-03 04:48:00	SPY	ETF	309.05	309.05	309.03	309.03	743.0
2020-06-03 04:49:00	SPY	ETF	309.03	309.06	309.03	309.06	601.0
2020-06-03 04:51:00	SPY	ETF	309.11	309.11	309.11	309.11	190.0
2020-06-03 04:53:00	SPY	ETF	309.13	309.13	309.13	309.13	1000.0
2020-06-03 04:55:00	SPY	ETF	309.25	309.25	309.25	309.25	600.0
2020-06-03 04:58:00	SPY	ETF	309.28	309.28	309.28	309.28	300.0
2020-06-03 04:59:00	SPY	ETF	309.36	309.36	309.36	309.36	100.0
2020-06-03 05:03:00	SPY	ETF	309.17	309.17	309.17	309.17	109.0
2020-06-03 05:07:00	SPY	ETF	309.21	309.21	309.21	309.21	100.0
2020-06-03 05:08:00	SPY	ETF	309.27	309.27	309.26	309.26	230.0
2020-06-03 05:11:00	SPY	ETF	309.28	309.3	309.28	309.3	1500.0
2020-06-03 05:12:00	SPY	ETF	309.3	309.35	309.3	309.35	1060.0
2020-06-03 05:17:00	SPY	ETF	309.35	309.35	309.35	309.35	324.0
2020-06-03 05:18:00	SPY	ETF	309.3	309.3	309.3	309.3	615.0
2020-06-03 05:21:00	SPY	ETF	309.23	309.23	309.23	309.23	109.0
2020-06-03 05:23:00	SPY	ETF	309.38	309.38	309.38	309.38	252.0
2020-06-03 05:24:00	SPY	ETF	309.4	309.49	309.4	309.49	3861.0
2020-06-03 05:25:00	SPY	ETF	309.43	309.54	309.43	309.46	5766.0
2020-06-03 05:27:00	SPY	ETF	309.43	309.43	309.43	309.43	309.0
2020-06-03 05:29:00	SPY	ETF	309.46	309.46	309.46	309.46	2500.0
2020-06-03 05:30:00	SPY	ETF	309.74	309.8	309.73	309.8	13615.0
2020-06-03 05:31:00	SPY	ETF	309.76	309.76	309.75	309.75	871.0
2020-06-03 05:32:00	SPY	ETF	309.64	309.64	309.64	309.64	200.0

> showing 50 of 226,601 rows — these rows as CSV

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