PREVIEW / etf_1min / 2021-07-27

all etf 1-min files

  file:    by_date/etf_1min/2021/2021-07-27.parquet
  size:    3.9 MB
  rows:    221,294

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
2021-07-27 04:00:00	SPY	ETF	439.38	439.69	439.13	439.13	2789.0
2021-07-27 04:01:00	SPY	ETF	439.18	439.28	439.15	439.28	3407.0
2021-07-27 04:02:00	SPY	ETF	439.21	439.26	439.2	439.2	1100.0
2021-07-27 04:03:00	SPY	ETF	439.23	439.23	439.23	439.23	219.0
2021-07-27 04:04:00	SPY	ETF	439.21	439.21	439.21	439.21	200.0
2021-07-27 04:05:00	SPY	ETF	439.46	439.48	439.45	439.48	450.0
2021-07-27 04:06:00	SPY	ETF	439.41	439.43	439.41	439.43	600.0
2021-07-27 04:07:00	SPY	ETF	439.56	439.65	439.56	439.65	900.0
2021-07-27 04:08:00	SPY	ETF	439.61	439.61	439.53	439.53	700.0
2021-07-27 04:09:00	SPY	ETF	439.61	439.61	439.61	439.61	100.0
2021-07-27 04:10:00	SPY	ETF	439.79	439.8	439.61	439.61	2100.0
2021-07-27 04:11:00	SPY	ETF	439.59	439.64	439.53	439.64	5625.0
2021-07-27 04:12:00	SPY	ETF	439.6	439.6	439.59	439.59	950.0
2021-07-27 04:13:00	SPY	ETF	439.51	439.54	439.51	439.54	1800.0
2021-07-27 04:14:00	SPY	ETF	439.6	439.6	439.5	439.52	4279.0
2021-07-27 04:15:00	SPY	ETF	439.47	439.47	439.47	439.47	300.0
2021-07-27 04:19:00	SPY	ETF	439.12	439.12	439.09	439.09	200.0
2021-07-27 04:20:00	SPY	ETF	439.04	439.04	438.94	438.94	200.0
2021-07-27 04:21:00	SPY	ETF	438.86	439.03	438.85	438.98	3200.0
2021-07-27 04:22:00	SPY	ETF	439.02	439.02	438.82	438.82	2300.0
2021-07-27 04:23:00	SPY	ETF	438.9	438.94	438.9	438.93	800.0
2021-07-27 04:24:00	SPY	ETF	439.02	439.02	439.0	439.0	1000.0
2021-07-27 04:28:00	SPY	ETF	438.82	438.82	438.72	438.72	1390.0
2021-07-27 04:30:00	SPY	ETF	438.77	438.77	438.77	438.77	100.0
2021-07-27 04:31:00	SPY	ETF	439.0	439.0	439.0	439.0	150.0
2021-07-27 04:35:00	SPY	ETF	439.19	439.19	439.18	439.18	600.0
2021-07-27 04:37:00	SPY	ETF	439.07	439.07	439.07	439.07	400.0
2021-07-27 04:39:00	SPY	ETF	439.0	439.0	439.0	439.0	1700.0
2021-07-27 04:40:00	SPY	ETF	439.0	439.0	439.0	439.0	300.0
2021-07-27 04:41:00	SPY	ETF	439.18	439.18	439.18	439.18	400.0
2021-07-27 04:45:00	SPY	ETF	439.32	439.32	439.32	439.32	2000.0
2021-07-27 04:47:00	SPY	ETF	439.18	439.2	439.18	439.19	2800.0
2021-07-27 04:48:00	SPY	ETF	439.2	439.2	439.19	439.19	1000.0
2021-07-27 04:52:00	SPY	ETF	439.25	439.25	439.24	439.24	400.0
2021-07-27 04:56:00	SPY	ETF	439.32	439.32	439.32	439.32	200.0
2021-07-27 04:57:00	SPY	ETF	439.29	439.3	439.29	439.3	437.0
2021-07-27 05:00:00	SPY	ETF	439.25	439.25	439.22	439.22	700.0
2021-07-27 05:01:00	SPY	ETF	439.11	439.11	439.1	439.1	700.0
2021-07-27 05:02:00	SPY	ETF	439.11	439.11	439.07	439.07	1700.0
2021-07-27 05:03:00	SPY	ETF	439.08	439.08	439.08	439.08	200.0
2021-07-27 05:04:00	SPY	ETF	438.99	438.99	438.95	438.95	900.0
2021-07-27 05:08:00	SPY	ETF	439.06	439.06	439.03	439.04	700.0
2021-07-27 05:09:00	SPY	ETF	439.15	439.16	439.15	439.16	800.0
2021-07-27 05:11:00	SPY	ETF	439.12	439.13	439.1	439.13	4575.0
2021-07-27 05:12:00	SPY	ETF	439.08	439.08	438.97	438.97	2300.0
2021-07-27 05:13:00	SPY	ETF	438.9	438.9	438.87	438.87	500.0
2021-07-27 05:14:00	SPY	ETF	438.85	438.85	438.85	438.85	500.0
2021-07-27 05:15:00	SPY	ETF	438.8	438.85	438.8	438.85	1312.0
2021-07-27 05:18:00	SPY	ETF	438.95	438.95	438.95	438.95	500.0
2021-07-27 05:19:00	SPY	ETF	439.0	439.12	439.0	439.11	3844.0

> showing 50 of 221,294 rows — these rows as CSV

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