PREVIEW / etf_5min / 2024-05-24

all etf 5-min files

  file:    by_date/etf_5min/2024/2024-05-24.parquet
  size:    2.1 MB
  rows:    103,805

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-24 04:00:00	SPY	ETF	526.64	526.76	526.64	526.72	1583.0
2024-05-24 04:05:00	SPY	ETF	526.75	526.82	526.69	526.81	2997.0
2024-05-24 04:10:00	SPY	ETF	526.93	526.93	526.9	526.9	1196.0
2024-05-24 04:15:00	SPY	ETF	526.89	526.9	526.89	526.89	601.0
2024-05-24 04:20:00	SPY	ETF	526.85	526.85	526.85	526.85	100.0
2024-05-24 04:30:00	SPY	ETF	526.91	527.02	526.91	527.02	1613.0
2024-05-24 04:35:00	SPY	ETF	527.1	527.1	527.1	527.1	500.0
2024-05-24 04:40:00	SPY	ETF	527.11	527.21	527.11	527.21	540.0
2024-05-24 04:45:00	SPY	ETF	527.16	527.2	527.16	527.2	239.0
2024-05-24 04:50:00	SPY	ETF	527.36	527.36	527.25	527.25	642.0
2024-05-24 04:55:00	SPY	ETF	527.29	527.29	527.29	527.29	100.0
2024-05-24 05:00:00	SPY	ETF	527.14	527.16	527.11	527.16	1768.0
2024-05-24 05:05:00	SPY	ETF	527.29	527.29	527.29	527.29	800.0
2024-05-24 05:10:00	SPY	ETF	527.28	527.29	527.28	527.29	580.0
2024-05-24 05:15:00	SPY	ETF	527.28	527.28	527.28	527.28	1500.0
2024-05-24 05:20:00	SPY	ETF	527.24	527.24	527.24	527.24	100.0
2024-05-24 05:25:00	SPY	ETF	527.17	527.17	527.03	527.11	1245.0
2024-05-24 05:30:00	SPY	ETF	527.15	527.15	527.15	527.15	100.0
2024-05-24 05:35:00	SPY	ETF	527.16	527.16	527.02	527.02	600.0
2024-05-24 05:40:00	SPY	ETF	527.04	527.04	527.01	527.04	687.0
2024-05-24 05:45:00	SPY	ETF	526.95	526.95	526.95	526.95	200.0
2024-05-24 06:00:00	SPY	ETF	527.14	527.14	527.14	527.14	100.0
2024-05-24 06:05:00	SPY	ETF	527.25	527.25	527.25	527.25	111.0
2024-05-24 06:10:00	SPY	ETF	527.32	527.32	527.31	527.31	1500.0
2024-05-24 06:20:00	SPY	ETF	527.3	527.32	527.3	527.32	535.0
2024-05-24 06:25:00	SPY	ETF	527.24	527.24	527.24	527.24	123.0
2024-05-24 06:30:00	SPY	ETF	527.31	527.31	527.28	527.28	434.0
2024-05-24 06:35:00	SPY	ETF	527.28	527.29	527.28	527.29	525.0
2024-05-24 06:40:00	SPY	ETF	527.39	527.48	527.39	527.43	1900.0
2024-05-24 06:50:00	SPY	ETF	527.45	527.45	527.42	527.42	374.0
2024-05-24 07:00:00	SPY	ETF	527.35	527.45	526.55	527.37	115275.0
2024-05-24 07:05:00	SPY	ETF	527.39	527.49	527.35	527.49	19949.0
2024-05-24 07:10:00	SPY	ETF	527.45	527.5	527.35	527.35	4571.0
2024-05-24 07:15:00	SPY	ETF	527.36	527.41	527.36	527.38	13609.0
2024-05-24 07:20:00	SPY	ETF	527.37	527.401	527.3	527.33	3430.0
2024-05-24 07:25:00	SPY	ETF	527.33	527.33	527.12	527.26	24151.0
2024-05-24 07:30:00	SPY	ETF	527.33	527.33	527.23	527.27	11328.0
2024-05-24 07:35:00	SPY	ETF	527.29	527.29	527.15	527.19	8995.0
2024-05-24 07:40:00	SPY	ETF	527.36	527.38	527.34	527.34	3403.0
2024-05-24 07:45:00	SPY	ETF	527.25	527.42	527.25	527.4	5428.0
2024-05-24 07:50:00	SPY	ETF	527.41	527.6	527.41	527.6	9540.0
2024-05-24 07:55:00	SPY	ETF	527.56	527.59	527.55	527.57	4010.0
2024-05-24 08:00:00	SPY	ETF	527.37	527.64	526.16	527.36	89800.0
2024-05-24 08:05:00	SPY	ETF	526.6	527.42	526.33	527.34	20438.0
2024-05-24 08:10:00	SPY	ETF	527.34	527.4	527.23	527.23	18605.0
2024-05-24 08:15:00	SPY	ETF	527.25	527.2506	527.13	527.14	5305.0
2024-05-24 08:20:00	SPY	ETF	527.12	527.13	527.0	527.05	33611.0
2024-05-24 08:25:00	SPY	ETF	527.1	527.12	526.98	527.1	9727.0
2024-05-24 08:30:00	SPY	ETF	526.98	527.62	526.96	527.61	52987.0
2024-05-24 08:35:00	SPY	ETF	527.66	527.91	527.65	527.89	38158.0

> showing 50 of 103,805 rows — these rows as CSV

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