PREVIEW / etf_5min / 2022-01-20

all etf 5-min files

  file:    by_date/etf_5min/2022/2022-01-20.parquet
  size:    2.1 MB
  rows:    99,764

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
2022-01-20 04:00:00	SPY	ETF	453.15	453.38	452.96	453.01	3162.0
2022-01-20 04:05:00	SPY	ETF	452.9	452.97	452.51	452.56	13977.0
2022-01-20 04:10:00	SPY	ETF	452.55	452.78	452.34	452.78	4593.0
2022-01-20 04:15:00	SPY	ETF	452.77	452.89	452.4	452.4	1161.0
2022-01-20 04:20:00	SPY	ETF	452.51	452.69	452.47	452.47	1351.0
2022-01-20 04:25:00	SPY	ETF	452.56	452.95	452.56	452.91	8187.0
2022-01-20 04:30:00	SPY	ETF	452.94	453.43	452.86	453.38	12354.0
2022-01-20 04:35:00	SPY	ETF	453.39	453.57	453.3	453.5	21751.0
2022-01-20 04:40:00	SPY	ETF	453.58	453.64	453.53	453.53	10122.0
2022-01-20 04:45:00	SPY	ETF	453.44	453.45	453.26	453.29	1029.0
2022-01-20 04:50:00	SPY	ETF	453.37	453.65	453.37	453.53	4596.0
2022-01-20 04:55:00	SPY	ETF	453.62	453.62	453.38	453.38	2360.0
2022-01-20 05:00:00	SPY	ETF	453.46	453.56	453.42	453.53	9158.0
2022-01-20 05:05:00	SPY	ETF	453.36	453.44	453.19	453.44	1440.0
2022-01-20 05:10:00	SPY	ETF	453.53	453.57	453.53	453.55	1665.0
2022-01-20 05:15:00	SPY	ETF	453.4	453.52	453.4	453.52	2426.0
2022-01-20 05:20:00	SPY	ETF	453.64	453.86	453.64	453.86	11670.0
2022-01-20 05:25:00	SPY	ETF	453.86	453.86	453.7	453.73	1515.0
2022-01-20 05:30:00	SPY	ETF	453.58	453.58	453.49	453.5	955.0
2022-01-20 05:35:00	SPY	ETF	453.64	453.64	453.64	453.64	100.0
2022-01-20 05:40:00	SPY	ETF	453.61	453.7	453.61	453.67	1926.0
2022-01-20 05:45:00	SPY	ETF	453.66	453.75	453.62	453.72	1611.0
2022-01-20 05:50:00	SPY	ETF	453.67	453.78	453.67	453.78	200.0
2022-01-20 05:55:00	SPY	ETF	453.78	453.82	453.65	453.65	568.0
2022-01-20 06:00:00	SPY	ETF	453.89	454.07	453.89	454.05	3313.0
2022-01-20 06:05:00	SPY	ETF	454.16	454.24	454.13	454.21	3453.0
2022-01-20 06:10:00	SPY	ETF	454.17	454.26	454.04	454.08	11556.0
2022-01-20 06:15:00	SPY	ETF	454.08	454.46	454.08	454.39	26942.0
2022-01-20 06:20:00	SPY	ETF	454.44	454.44	454.24	454.32	24990.0
2022-01-20 06:25:00	SPY	ETF	454.31	454.39	454.24	454.34	26450.0
2022-01-20 06:30:00	SPY	ETF	454.29	454.29	453.97	453.97	32087.0
2022-01-20 06:35:00	SPY	ETF	454.0	454.12	454.0	454.12	5986.0
2022-01-20 06:40:00	SPY	ETF	454.17	454.17	454.0	454.0	3100.0
2022-01-20 06:45:00	SPY	ETF	453.86	453.86	453.64	453.77	2259.0
2022-01-20 06:50:00	SPY	ETF	454.04	454.08	454.04	454.07	496.0
2022-01-20 06:55:00	SPY	ETF	453.95	454.19	453.95	454.11	3661.0
2022-01-20 07:00:00	SPY	ETF	454.07	454.19	453.79	454.13	51421.0
2022-01-20 07:05:00	SPY	ETF	454.151	454.151	453.92	453.98	27157.0
2022-01-20 07:10:00	SPY	ETF	454.07	454.13	454.0	454.0	5604.0
2022-01-20 07:15:00	SPY	ETF	454.0	454.03	453.81	453.81	12391.0
2022-01-20 07:20:00	SPY	ETF	453.8	454.03	453.73	453.77	11703.0
2022-01-20 07:25:00	SPY	ETF	453.72	453.78	453.61	453.75	3300.0
2022-01-20 07:30:00	SPY	ETF	453.88	453.88	453.4	453.4	24011.0
2022-01-20 07:35:00	SPY	ETF	453.39	453.5	453.32	453.41	16830.0
2022-01-20 07:40:00	SPY	ETF	453.34	453.34	453.03	453.1	6809.0
2022-01-20 07:45:00	SPY	ETF	453.12	453.36	453.1	453.35	8983.0
2022-01-20 07:50:00	SPY	ETF	453.28	453.41	453.23	453.36	80842.0
2022-01-20 07:55:00	SPY	ETF	453.38	453.61	453.35	453.52	62746.0
2022-01-20 08:00:00	SPY	ETF	453.52	454.48	452.088	453.45	79531.0
2022-01-20 08:05:00	SPY	ETF	453.46	453.48	452.39	453.43	168525.0

> showing 50 of 99,764 rows — these rows as CSV

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