PREVIEW / etf_1min / 2020-06-04

all etf 1-min files

  file:    by_date/etf_1min/2020/2020-06-04.parquet
  size:    3.9 MB
  rows:    217,268

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-04 04:00:00	SPY	ETF	311.5	311.5	311.32	311.32	1138.0
2020-06-04 04:01:00	SPY	ETF	311.29	311.29	311.17	311.17	3352.0
2020-06-04 04:02:00	SPY	ETF	311.24	311.24	311.18	311.21	1452.0
2020-06-04 04:03:00	SPY	ETF	311.24	311.24	311.14	311.2	6315.0
2020-06-04 04:04:00	SPY	ETF	311.2	311.2	311.1	311.1	2335.0
2020-06-04 04:05:00	SPY	ETF	311.12	311.12	311.05	311.08	2706.0
2020-06-04 04:06:00	SPY	ETF	311.09	311.18	311.09	311.12	2714.0
2020-06-04 04:07:00	SPY	ETF	311.17	311.17	311.15	311.15	1450.0
2020-06-04 04:08:00	SPY	ETF	311.17	311.45	311.17	311.34	3111.0
2020-06-04 04:09:00	SPY	ETF	311.35	311.39	311.34	311.34	690.0
2020-06-04 04:10:00	SPY	ETF	311.37	311.39	311.37	311.39	700.0
2020-06-04 04:11:00	SPY	ETF	311.47	311.47	311.47	311.47	1574.0
2020-06-04 04:12:00	SPY	ETF	311.53	311.57	311.44	311.44	500.0
2020-06-04 04:13:00	SPY	ETF	311.36	311.36	311.36	311.36	137.0
2020-06-04 04:14:00	SPY	ETF	311.3	311.3	311.23	311.23	1500.0
2020-06-04 04:15:00	SPY	ETF	311.22	311.22	311.22	311.22	700.0
2020-06-04 04:17:00	SPY	ETF	311.24	311.24	311.24	311.24	402.0
2020-06-04 04:18:00	SPY	ETF	311.24	311.24	311.24	311.24	245.0
2020-06-04 04:19:00	SPY	ETF	311.22	311.23	311.22	311.22	1250.0
2020-06-04 04:20:00	SPY	ETF	311.3	311.34	311.3	311.34	281.0
2020-06-04 04:21:00	SPY	ETF	311.37	311.39	311.37	311.39	300.0
2020-06-04 04:22:00	SPY	ETF	311.35	311.35	311.29	311.29	800.0
2020-06-04 04:23:00	SPY	ETF	311.28	311.28	311.28	311.28	200.0
2020-06-04 04:26:00	SPY	ETF	311.32	311.32	311.17	311.17	1049.0
2020-06-04 04:27:00	SPY	ETF	311.17	311.17	311.12	311.12	1031.0
2020-06-04 04:29:00	SPY	ETF	311.17	311.17	311.17	311.17	340.0
2020-06-04 04:32:00	SPY	ETF	311.22	311.22	311.2	311.2	371.0
2020-06-04 04:36:00	SPY	ETF	311.15	311.15	311.15	311.15	100.0
2020-06-04 04:37:00	SPY	ETF	311.04	311.04	311.04	311.04	391.0
2020-06-04 04:38:00	SPY	ETF	311.01	311.01	311.01	311.01	335.0
2020-06-04 04:39:00	SPY	ETF	311.03	311.03	311.0	311.0	2041.0
2020-06-04 04:40:00	SPY	ETF	311.0	311.0	311.0	311.0	380.0
2020-06-04 04:42:00	SPY	ETF	311.0	311.02	310.98	311.02	600.0
2020-06-04 04:44:00	SPY	ETF	311.1	311.1	311.05	311.1	988.0
2020-06-04 04:45:00	SPY	ETF	311.03	311.03	311.03	311.03	322.0
2020-06-04 04:47:00	SPY	ETF	310.97	310.97	310.97	310.97	101.0
2020-06-04 04:48:00	SPY	ETF	310.97	310.97	310.97	310.97	300.0
2020-06-04 04:52:00	SPY	ETF	311.0	311.0	311.0	311.0	130.0
2020-06-04 04:54:00	SPY	ETF	311.0	311.0	311.0	311.0	200.0
2020-06-04 04:55:00	SPY	ETF	311.02	311.02	311.02	311.02	583.0
2020-06-04 04:56:00	SPY	ETF	311.05	311.05	310.97	310.97	813.0
2020-06-04 04:59:00	SPY	ETF	310.95	310.95	310.95	310.95	400.0
2020-06-04 05:00:00	SPY	ETF	310.95	310.95	310.95	310.95	353.0
2020-06-04 05:01:00	SPY	ETF	310.87	310.87	310.87	310.87	446.0
2020-06-04 05:03:00	SPY	ETF	310.86	310.86	310.86	310.86	202.0
2020-06-04 05:04:00	SPY	ETF	310.88	310.93	310.86	310.9	2048.0
2020-06-04 05:05:00	SPY	ETF	310.86	310.86	310.86	310.86	356.0
2020-06-04 05:07:00	SPY	ETF	310.9	310.98	310.9	310.98	2129.0
2020-06-04 05:08:00	SPY	ETF	310.95	310.95	310.95	310.95	233.0
2020-06-04 05:09:00	SPY	ETF	310.98	310.98	310.98	310.98	390.0

> showing 50 of 217,268 rows — these rows as CSV

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