PREVIEW / etf_5min / 2024-07-16

all etf 5-min files

  file:    by_date/etf_5min/2024/2024-07-16.parquet
  size:    2.4 MB
  rows:    117,553

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-07-16 04:00:00	SPY	ETF	561.5	561.5	560.7	560.7	19154.0
2024-07-16 04:05:00	SPY	ETF	560.71	560.71	560.59	560.61	2832.0
2024-07-16 04:10:00	SPY	ETF	560.66	560.67	560.51	560.67	4120.0
2024-07-16 04:15:00	SPY	ETF	560.63	560.65	560.54	560.65	3830.0
2024-07-16 04:20:00	SPY	ETF	560.66	561.2	560.66	561.17	9276.0
2024-07-16 04:25:00	SPY	ETF	561.05	561.08	560.91	560.91	569.0
2024-07-16 04:35:00	SPY	ETF	560.99	560.99	560.99	560.99	150.0
2024-07-16 04:40:00	SPY	ETF	561.06	561.06	561.05	561.05	250.0
2024-07-16 04:50:00	SPY	ETF	561.29	561.46	561.29	561.46	400.0
2024-07-16 04:55:00	SPY	ETF	561.5	561.73	561.5	561.73	1635.0
2024-07-16 05:00:00	SPY	ETF	561.71	561.71	561.66	561.66	300.0
2024-07-16 05:05:00	SPY	ETF	561.67	561.67	561.53	561.53	821.0
2024-07-16 05:10:00	SPY	ETF	561.55	561.62	561.55	561.62	310.0
2024-07-16 05:15:00	SPY	ETF	561.69	561.84	561.69	561.76	3590.0
2024-07-16 05:20:00	SPY	ETF	561.81	561.81	561.81	561.81	141.0
2024-07-16 05:25:00	SPY	ETF	561.75	561.76	561.75	561.76	645.0
2024-07-16 05:30:00	SPY	ETF	561.62	561.62	561.53	561.56	1100.0
2024-07-16 05:35:00	SPY	ETF	561.62	561.62	561.5	561.5	818.0
2024-07-16 05:40:00	SPY	ETF	561.56	561.56	561.56	561.56	200.0
2024-07-16 05:55:00	SPY	ETF	561.7	561.8	561.7	561.8	1200.0
2024-07-16 06:00:00	SPY	ETF	561.8	561.84	561.8	561.84	859.0
2024-07-16 06:10:00	SPY	ETF	561.87	561.89	561.87	561.89	555.0
2024-07-16 06:15:00	SPY	ETF	562.0	562.0	561.98	561.98	315.0
2024-07-16 06:20:00	SPY	ETF	561.99	562.16	561.99	562.11	805.0
2024-07-16 06:25:00	SPY	ETF	562.22	562.22	562.22	562.22	966.0
2024-07-16 06:30:00	SPY	ETF	562.16	562.32	562.16	562.31	8920.0
2024-07-16 06:35:00	SPY	ETF	562.19	562.19	562.12	562.12	1000.0
2024-07-16 06:40:00	SPY	ETF	562.29	562.29	562.29	562.29	100.0
2024-07-16 06:45:00	SPY	ETF	562.25	562.25	562.25	562.25	101.0
2024-07-16 06:50:00	SPY	ETF	562.22	562.22	562.17	562.21	611.0
2024-07-16 07:00:00	SPY	ETF	562.16	562.16	562.16	562.16	320.0
2024-07-16 07:05:00	SPY	ETF	562.25	562.27	562.22	562.27	1221.0
2024-07-16 07:10:00	SPY	ETF	562.27	562.27	562.18	562.18	1464.0
2024-07-16 07:15:00	SPY	ETF	562.2	562.29	562.2	562.2	23135.0
2024-07-16 07:20:00	SPY	ETF	562.14	562.14	561.95	561.95	4263.0
2024-07-16 07:25:00	SPY	ETF	562.14	562.14	562.1	562.1	5737.0
2024-07-16 07:30:00	SPY	ETF	562.1	562.2	562.08	562.2	20054.0
2024-07-16 07:35:00	SPY	ETF	562.2	562.29	562.08	562.08	2303.0
2024-07-16 07:40:00	SPY	ETF	562.02	562.15	561.99	562.15	1189.0
2024-07-16 07:45:00	SPY	ETF	562.14	562.14	562.14	562.14	260.0
2024-07-16 07:50:00	SPY	ETF	562.21	562.21	562.2	562.2	253.0
2024-07-16 08:00:00	SPY	ETF	562.32	562.48	561.42	561.52	16887.0
2024-07-16 08:05:00	SPY	ETF	562.31	562.32	562.28	562.28	2815.0
2024-07-16 08:10:00	SPY	ETF	562.1609	562.29	562.12	562.28	3843.0
2024-07-16 08:15:00	SPY	ETF	562.2096	562.21	562.16	562.21	2690.0
2024-07-16 08:20:00	SPY	ETF	562.23	562.32	562.23	562.23	3768.0
2024-07-16 08:25:00	SPY	ETF	562.26	562.27	562.14	562.14	2840.0
2024-07-16 08:30:00	SPY	ETF	562.14	562.72	561.61	562.6	128033.0
2024-07-16 08:35:00	SPY	ETF	562.6	562.77	562.45	562.5	47548.0
2024-07-16 08:40:00	SPY	ETF	562.54	562.85	562.46	562.8	40856.0

> showing 50 of 117,553 rows — these rows as CSV

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