PREVIEW / etf_5min / 2024-05-01

all etf 5-min files

  file:    by_date/etf_5min/2024/2024-05-01.parquet
  size:    2.3 MB
  rows:    112,961

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
2024-05-01 04:00:00	SPY	ETF	500.76	501.0	500.65	500.8	3771.0
2024-05-01 04:05:00	SPY	ETF	501.0	501.09	501.0	501.07	2483.0
2024-05-01 04:10:00	SPY	ETF	500.91	500.91	500.85	500.85	1525.0
2024-05-01 04:15:00	SPY	ETF	500.85	500.86	500.71	500.71	3449.0
2024-05-01 04:20:00	SPY	ETF	500.67	500.89	500.67	500.89	3846.0
2024-05-01 04:25:00	SPY	ETF	501.0	501.0	500.86	500.86	400.0
2024-05-01 04:30:00	SPY	ETF	500.85	500.9	500.85	500.9	497.0
2024-05-01 04:35:00	SPY	ETF	500.84	500.84	500.84	500.84	2406.0
2024-05-01 04:40:00	SPY	ETF	500.65	500.67	500.64	500.64	2301.0
2024-05-01 05:00:00	SPY	ETF	500.75	500.75	500.66	500.66	1645.0
2024-05-01 05:05:00	SPY	ETF	500.56	500.56	500.0	500.04	1582.0
2024-05-01 05:10:00	SPY	ETF	500.06	500.11	500.0	500.0	900.0
2024-05-01 05:15:00	SPY	ETF	500.21	500.23	500.21	500.22	748.0
2024-05-01 05:20:00	SPY	ETF	500.2	500.21	500.09	500.21	1000.0
2024-05-01 05:25:00	SPY	ETF	500.12	500.14	500.0	500.0	2000.0
2024-05-01 05:30:00	SPY	ETF	499.97	499.97	499.64	499.71	2307.0
2024-05-01 05:35:00	SPY	ETF	499.82	499.92	499.79	499.82	2500.0
2024-05-01 05:40:00	SPY	ETF	499.84	499.91	499.83	499.89	2700.0
2024-05-01 05:45:00	SPY	ETF	500.0	500.15	500.0	500.15	2450.0
2024-05-01 05:50:00	SPY	ETF	500.11	500.26	500.11	500.12	2598.0
2024-05-01 06:00:00	SPY	ETF	499.95	500.04	499.95	500.04	3336.0
2024-05-01 06:05:00	SPY	ETF	499.97	499.98	499.97	499.98	750.0
2024-05-01 06:10:00	SPY	ETF	499.95	500.01	499.79	499.79	3690.0
2024-05-01 06:15:00	SPY	ETF	499.8	499.84	499.8	499.82	3000.0
2024-05-01 06:20:00	SPY	ETF	499.9	499.9	499.73	499.73	624.0
2024-05-01 06:25:00	SPY	ETF	499.78	499.8	499.66	499.66	14736.0
2024-05-01 06:30:00	SPY	ETF	499.61	499.73	499.5	499.59	2277.0
2024-05-01 06:35:00	SPY	ETF	499.63	499.89	499.56	499.85	5300.0
2024-05-01 06:40:00	SPY	ETF	499.84	499.95	499.84	499.95	31424.0
2024-05-01 06:45:00	SPY	ETF	499.95	500.09	499.95	500.09	19160.0
2024-05-01 06:50:00	SPY	ETF	499.99	500.03	499.91	500.02	6926.0
2024-05-01 06:55:00	SPY	ETF	500.05	500.34	500.05	500.34	1937.0
2024-05-01 07:00:00	SPY	ETF	500.28	500.36	500.14	500.289	35373.0
2024-05-01 07:05:00	SPY	ETF	500.27	500.41	500.27	500.3	3635.0
2024-05-01 07:10:00	SPY	ETF	500.35	500.429	500.35	500.429	3770.0
2024-05-01 07:15:00	SPY	ETF	500.45	500.45	500.36	500.4	11344.0
2024-05-01 07:20:00	SPY	ETF	500.41	500.65	500.41	500.54	7464.0
2024-05-01 07:25:00	SPY	ETF	500.58	500.65	500.365	500.39	44778.0
2024-05-01 07:30:00	SPY	ETF	500.37	500.509	500.37	500.39	6003.0
2024-05-01 07:35:00	SPY	ETF	500.37	500.39	500.32	500.37	3432.0
2024-05-01 07:40:00	SPY	ETF	500.35	500.41	500.3	500.39	10542.0
2024-05-01 07:45:00	SPY	ETF	500.39	500.42	500.37	500.42	8440.0
2024-05-01 07:50:00	SPY	ETF	500.28	500.28	499.91	499.96	23305.0
2024-05-01 07:55:00	SPY	ETF	499.96	500.09	499.95	500.08	9887.0
2024-05-01 08:00:00	SPY	ETF	500.27	502.1	499.4896	502.08	85524.0
2024-05-01 08:05:00	SPY	ETF	501.2	501.88	500.1	500.21	39240.0
2024-05-01 08:10:00	SPY	ETF	500.26	500.37	500.16	500.16	35916.0
2024-05-01 08:15:00	SPY	ETF	500.3	500.58	500.0	500.58	32147.0
2024-05-01 08:20:00	SPY	ETF	500.55	500.61	500.35	500.41	142590.0
2024-05-01 08:25:00	SPY	ETF	500.43	500.5	500.31	500.33	15507.0

> showing 50 of 112,961 rows — these rows as CSV

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