PREVIEW / etf_5min / 2023-01-18

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-01-18.parquet
  size:    2.1 MB
  rows:    101,033

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
2023-01-18 04:00:00	SPY	ETF	398.22	398.33	397.77	398.08	4360.0
2023-01-18 04:05:00	SPY	ETF	398.05	398.12	397.9	397.99	3531.0
2023-01-18 04:10:00	SPY	ETF	398.04	398.04	397.89	397.89	960.0
2023-01-18 04:15:00	SPY	ETF	398.0	398.09	397.89	398.09	1131.0
2023-01-18 04:20:00	SPY	ETF	398.09	398.09	398.09	398.09	100.0
2023-01-18 04:25:00	SPY	ETF	398.14	398.21	397.99	398.02	4448.0
2023-01-18 04:30:00	SPY	ETF	397.91	397.94	397.91	397.94	300.0
2023-01-18 04:35:00	SPY	ETF	397.97	397.97	397.82	397.83	1244.0
2023-01-18 04:40:00	SPY	ETF	397.94	397.94	397.94	397.94	133.0
2023-01-18 04:45:00	SPY	ETF	397.96	397.96	397.96	397.96	300.0
2023-01-18 04:50:00	SPY	ETF	397.96	398.02	397.96	398.02	1555.0
2023-01-18 04:55:00	SPY	ETF	398.08	398.08	398.08	398.08	500.0
2023-01-18 05:00:00	SPY	ETF	397.95	398.1	397.91	398.1	1233.0
2023-01-18 05:05:00	SPY	ETF	397.99	397.99	397.98	397.98	204.0
2023-01-18 05:10:00	SPY	ETF	397.92	397.98	397.92	397.94	598.0
2023-01-18 05:15:00	SPY	ETF	398.07	398.07	398.07	398.07	100.0
2023-01-18 05:20:00	SPY	ETF	398.06	398.12	398.0	398.09	2403.0
2023-01-18 05:25:00	SPY	ETF	398.13	398.14	397.85	397.85	1240.0
2023-01-18 05:30:00	SPY	ETF	397.73	397.8	397.72	397.8	432.0
2023-01-18 05:35:00	SPY	ETF	397.74	397.94	397.73	397.86	20721.0
2023-01-18 05:45:00	SPY	ETF	397.98	398.19	397.98	398.19	1100.0
2023-01-18 05:50:00	SPY	ETF	398.15	398.31	398.15	398.31	1920.0
2023-01-18 05:55:00	SPY	ETF	398.31	398.36	398.19	398.19	1744.0
2023-01-18 06:00:00	SPY	ETF	398.15	398.26	398.15	398.26	1000.0
2023-01-18 06:05:00	SPY	ETF	398.24	398.39	398.24	398.38	1425.0
2023-01-18 06:10:00	SPY	ETF	398.26	398.35	398.25	398.35	8060.0
2023-01-18 06:15:00	SPY	ETF	398.4	398.4	398.31	398.33	42434.0
2023-01-18 06:20:00	SPY	ETF	398.3	398.34	398.28	398.34	25970.0
2023-01-18 06:25:00	SPY	ETF	398.33	398.34	398.29	398.31	10000.0
2023-01-18 06:30:00	SPY	ETF	398.16	398.18	398.1	398.18	417.0
2023-01-18 06:35:00	SPY	ETF	398.18	398.41	398.18	398.38	8246.0
2023-01-18 06:40:00	SPY	ETF	398.37	398.4	398.36	398.38	2350.0
2023-01-18 06:45:00	SPY	ETF	398.39	398.41	398.23	398.25	2732.0
2023-01-18 06:50:00	SPY	ETF	398.3	398.47	398.3	398.47	900.0
2023-01-18 06:55:00	SPY	ETF	398.5	398.5	398.42	398.42	470.0
2023-01-18 07:00:00	SPY	ETF	398.39	398.59	398.39	398.55	11642.0
2023-01-18 07:05:00	SPY	ETF	398.57	398.6	398.4	398.42	17072.0
2023-01-18 07:10:00	SPY	ETF	398.47	398.5	398.44	398.49	20629.0
2023-01-18 07:15:00	SPY	ETF	398.48	398.57	398.48	398.57	16924.0
2023-01-18 07:20:00	SPY	ETF	398.54	398.64	398.53	398.59	7512.0
2023-01-18 07:25:00	SPY	ETF	398.52	398.65	398.52	398.65	4864.0
2023-01-18 07:30:00	SPY	ETF	398.67	398.74	398.64	398.71	81551.0
2023-01-18 07:35:00	SPY	ETF	398.72	398.74	398.68	398.72	52358.0
2023-01-18 07:40:00	SPY	ETF	398.72	398.9	398.65	398.84	50388.0
2023-01-18 07:45:00	SPY	ETF	398.84	399.0	398.84	398.95	18185.0
2023-01-18 07:50:00	SPY	ETF	398.9	399.09	398.9	399.09	9866.0
2023-01-18 07:55:00	SPY	ETF	399.06	399.14	399.05	399.11	11428.0
2023-01-18 08:00:00	SPY	ETF	398.92	399.15	398.01	398.88	66589.0
2023-01-18 08:05:00	SPY	ETF	398.88	398.88	398.71	398.71	35776.0
2023-01-18 08:10:00	SPY	ETF	398.73	398.9	398.73	398.88	29110.0

> showing 50 of 101,033 rows — these rows as CSV

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