PREVIEW / etf_5min / 2023-10-18

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-10-18.parquet
  size:    2.0 MB
  rows:    99,340

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-10-18 04:00:00	SPY	ETF	435.18	435.18	434.96	435.05	2040.0
2023-10-18 04:05:00	SPY	ETF	435.03	435.06	434.96	435.0	2130.0
2023-10-18 04:10:00	SPY	ETF	435.09	435.14	434.89	434.96	3370.0
2023-10-18 04:15:00	SPY	ETF	434.96	435.1	434.72	434.76	2002.0
2023-10-18 04:20:00	SPY	ETF	434.93	435.2	434.93	435.2	2297.0
2023-10-18 04:25:00	SPY	ETF	435.09	435.15	435.04	435.11	2210.0
2023-10-18 04:30:00	SPY	ETF	435.13	435.23	435.05	435.05	1200.0
2023-10-18 04:35:00	SPY	ETF	435.09	435.3	435.08	435.3	1973.0
2023-10-18 04:40:00	SPY	ETF	435.28	435.33	435.28	435.31	648.0
2023-10-18 04:45:00	SPY	ETF	435.32	435.6	435.23	435.6	1673.0
2023-10-18 04:50:00	SPY	ETF	435.53	435.53	435.41	435.41	479.0
2023-10-18 04:55:00	SPY	ETF	435.45	435.45	435.39	435.39	434.0
2023-10-18 05:00:00	SPY	ETF	435.33	435.38	435.33	435.33	974.0
2023-10-18 05:05:00	SPY	ETF	435.38	435.42	435.34	435.35	4355.0
2023-10-18 05:10:00	SPY	ETF	435.52	435.52	435.44	435.48	1300.0
2023-10-18 05:15:00	SPY	ETF	435.45	435.6	435.43	435.52	2131.0
2023-10-18 05:20:00	SPY	ETF	435.42	435.42	435.42	435.42	150.0
2023-10-18 05:25:00	SPY	ETF	435.4	435.4	434.89	434.89	2946.0
2023-10-18 05:30:00	SPY	ETF	434.71	434.71	434.53	434.55	3116.0
2023-10-18 05:35:00	SPY	ETF	434.69	434.75	434.67	434.67	1797.0
2023-10-18 05:40:00	SPY	ETF	434.66	434.67	434.54	434.55	13544.0
2023-10-18 05:45:00	SPY	ETF	434.7	434.76	434.68	434.68	1225.0
2023-10-18 05:50:00	SPY	ETF	434.67	434.7	434.56	434.7	1746.0
2023-10-18 05:55:00	SPY	ETF	434.65	434.67	434.57	434.59	7201.0
2023-10-18 06:00:00	SPY	ETF	434.53	434.65	434.5	434.64	1803.0
2023-10-18 06:05:00	SPY	ETF	434.59	434.7	434.53	434.7	650.0
2023-10-18 06:10:00	SPY	ETF	434.58	434.58	434.52	434.52	401.0
2023-10-18 06:15:00	SPY	ETF	434.51	434.63	434.51	434.63	6375.0
2023-10-18 06:20:00	SPY	ETF	434.69	434.69	434.16	434.16	3920.0
2023-10-18 06:25:00	SPY	ETF	434.19	434.21	433.92	434.12	6487.0
2023-10-18 06:30:00	SPY	ETF	434.12	434.21	434.01	434.17	12641.0
2023-10-18 06:35:00	SPY	ETF	434.16	434.16	434.04	434.04	5104.0
2023-10-18 06:40:00	SPY	ETF	434.01	434.01	433.91	433.96	16622.0
2023-10-18 06:45:00	SPY	ETF	434.01	434.08	433.81	433.83	7892.0
2023-10-18 06:50:00	SPY	ETF	433.97	434.03	433.97	434.03	1300.0
2023-10-18 06:55:00	SPY	ETF	434.09	434.11	433.99	434.08	4103.0
2023-10-18 07:00:00	SPY	ETF	434.1	434.36	434.05	434.36	29692.0
2023-10-18 07:05:00	SPY	ETF	434.3	434.42	434.3	434.42	17833.0
2023-10-18 07:10:00	SPY	ETF	434.4	434.4	434.11	434.15	41185.0
2023-10-18 07:15:00	SPY	ETF	434.18	434.29	434.18	434.23	26200.0
2023-10-18 07:20:00	SPY	ETF	434.21	434.21	434.01	434.01	6496.0
2023-10-18 07:25:00	SPY	ETF	434.05	434.37	434.05	434.32	5686.0
2023-10-18 07:30:00	SPY	ETF	434.29	434.46	434.2	434.42	12972.0
2023-10-18 07:35:00	SPY	ETF	434.46	434.54	434.35	434.4	10925.0
2023-10-18 07:40:00	SPY	ETF	434.33	434.33	434.22	434.27	3547.0
2023-10-18 07:45:00	SPY	ETF	434.26	434.29	434.18	434.21	9472.0
2023-10-18 07:50:00	SPY	ETF	434.28	434.41	434.24	434.32	5289.0
2023-10-18 07:55:00	SPY	ETF	434.38	434.42	434.28	434.36	8461.0
2023-10-18 08:00:00	SPY	ETF	434.24	435.57	434.04	434.21	65041.0
2023-10-18 08:05:00	SPY	ETF	434.26	434.55	434.25	434.55	15054.0

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

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