PREVIEW / etf_5min / 2021-06-23

all etf 5-min files

  file:    by_date/etf_5min/2021/2021-06-23.parquet
  size:    1.7 MB
  rows:    79,243

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-06-23 04:00:00	SPY	ETF	423.32	423.5	423.32	423.49	600.0
2021-06-23 04:10:00	SPY	ETF	423.41	423.41	423.36	423.36	286.0
2021-06-23 04:15:00	SPY	ETF	423.57	423.57	423.57	423.57	624.0
2021-06-23 04:20:00	SPY	ETF	423.6	423.6	423.56	423.56	1100.0
2021-06-23 04:30:00	SPY	ETF	423.4	423.4	423.4	423.4	1181.0
2021-06-23 04:45:00	SPY	ETF	423.48	423.52	423.46	423.46	5900.0
2021-06-23 04:50:00	SPY	ETF	423.44	423.44	423.44	423.44	200.0
2021-06-23 04:55:00	SPY	ETF	423.45	423.45	423.28	423.4	1100.0
2021-06-23 05:00:00	SPY	ETF	423.4	423.4	423.14	423.16	1617.0
2021-06-23 05:05:00	SPY	ETF	423.13	423.24	423.05	423.24	945.0
2021-06-23 05:10:00	SPY	ETF	423.21	423.3	423.13	423.3	400.0
2021-06-23 05:15:00	SPY	ETF	423.3	423.3	423.2	423.25	3000.0
2021-06-23 05:20:00	SPY	ETF	423.23	423.23	423.11	423.13	3300.0
2021-06-23 05:25:00	SPY	ETF	423.11	423.25	423.03	423.25	700.0
2021-06-23 05:30:00	SPY	ETF	423.21	423.21	423.21	423.21	100.0
2021-06-23 05:35:00	SPY	ETF	423.3	423.32	423.29	423.3	1100.0
2021-06-23 05:40:00	SPY	ETF	423.29	423.37	423.28	423.35	1900.0
2021-06-23 05:45:00	SPY	ETF	423.35	423.4	423.35	423.38	1300.0
2021-06-23 05:50:00	SPY	ETF	423.4	423.44	423.33	423.33	5182.0
2021-06-23 05:55:00	SPY	ETF	423.31	423.33	423.31	423.31	300.0
2021-06-23 06:00:00	SPY	ETF	423.23	423.23	423.14	423.14	1172.0
2021-06-23 06:05:00	SPY	ETF	423.13	423.2	423.07	423.18	1900.0
2021-06-23 06:10:00	SPY	ETF	423.21	423.23	423.21	423.23	300.0
2021-06-23 06:15:00	SPY	ETF	423.3	423.43	423.3	423.4	1600.0
2021-06-23 06:20:00	SPY	ETF	423.43	423.5	423.43	423.5	3300.0
2021-06-23 06:25:00	SPY	ETF	423.54	423.55	423.48	423.49	2800.0
2021-06-23 06:30:00	SPY	ETF	423.44	423.44	423.43	423.43	200.0
2021-06-23 06:35:00	SPY	ETF	423.33	423.35	423.33	423.35	600.0
2021-06-23 06:40:00	SPY	ETF	423.38	423.4	423.38	423.4	200.0
2021-06-23 06:45:00	SPY	ETF	423.35	423.37	423.35	423.37	300.0
2021-06-23 06:50:00	SPY	ETF	423.31	423.31	423.31	423.31	100.0
2021-06-23 06:55:00	SPY	ETF	423.23	423.23	423.06	423.06	2585.0
2021-06-23 07:00:00	SPY	ETF	423.2	423.21	423.0	423.0	17868.0
2021-06-23 07:05:00	SPY	ETF	423.0	423.18	423.0	423.18	10040.0
2021-06-23 07:10:00	SPY	ETF	423.11	423.11	422.9	422.96	17826.0
2021-06-23 07:15:00	SPY	ETF	422.95	423.1	422.94	423.03	6157.0
2021-06-23 07:20:00	SPY	ETF	422.99	422.99	422.64	422.71	21764.0
2021-06-23 07:25:00	SPY	ETF	422.74	422.74	422.5	422.73	6220.0
2021-06-23 07:30:00	SPY	ETF	422.71	422.9	422.7	422.9	5164.0
2021-06-23 07:35:00	SPY	ETF	422.95	422.97	422.73	422.85	4793.0
2021-06-23 07:40:00	SPY	ETF	422.85	423.0	422.83	423.0	3100.0
2021-06-23 07:45:00	SPY	ETF	423.04	423.04	422.93	422.99	8531.0
2021-06-23 07:50:00	SPY	ETF	422.99	423.12	422.99	423.11	4248.0
2021-06-23 07:55:00	SPY	ETF	423.11	423.17	423.09	423.11	8634.0
2021-06-23 08:00:00	SPY	ETF	423.07	423.97	422.54	423.06	47114.0
2021-06-23 08:05:00	SPY	ETF	423.03	423.2	423.02	423.19	21897.0
2021-06-23 08:10:00	SPY	ETF	423.24	423.57	423.24	423.54	24943.0
2021-06-23 08:15:00	SPY	ETF	423.5	423.5	423.36	423.41	103337.0
2021-06-23 08:20:00	SPY	ETF	423.4	423.55	423.36	423.5	9957.0
2021-06-23 08:25:00	SPY	ETF	423.49	423.5	423.47	423.47	11731.0

> showing 50 of 79,243 rows — these rows as CSV

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