PREVIEW / etf_5min / 2024-09-16

all etf 5-min files

  file:    by_date/etf_5min/2024/2024-09-16.parquet
  size:    2.2 MB
  rows:    111,593

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-09-16 04:00:00	SPY	ETF	562.21	562.55	562.12	562.55	6504.0
2024-09-16 04:05:00	SPY	ETF	562.55	562.55	562.45	562.5	713.0
2024-09-16 04:10:00	SPY	ETF	562.39	562.46	562.3	562.36	2484.0
2024-09-16 04:15:00	SPY	ETF	562.39	562.39	562.37	562.37	229.0
2024-09-16 04:20:00	SPY	ETF	562.5	562.54	562.48	562.54	616.0
2024-09-16 04:25:00	SPY	ETF	562.6	562.6	562.54	562.57	324.0
2024-09-16 04:30:00	SPY	ETF	562.51	562.51	562.49	562.49	300.0
2024-09-16 04:35:00	SPY	ETF	562.32	562.39	562.27	562.39	912.0
2024-09-16 04:45:00	SPY	ETF	562.4	562.41	562.33	562.33	800.0
2024-09-16 04:50:00	SPY	ETF	562.42	562.42	562.42	562.42	100.0
2024-09-16 04:55:00	SPY	ETF	562.45	562.56	562.45	562.56	1134.0
2024-09-16 05:00:00	SPY	ETF	562.52	562.56	562.52	562.56	448.0
2024-09-16 05:05:00	SPY	ETF	562.5	562.5	562.46	562.49	850.0
2024-09-16 05:10:00	SPY	ETF	562.58	562.65	562.58	562.62	400.0
2024-09-16 05:15:00	SPY	ETF	562.74	562.74	562.65	562.65	783.0
2024-09-16 05:20:00	SPY	ETF	562.65	562.65	562.64	562.64	677.0
2024-09-16 05:25:00	SPY	ETF	562.59	562.59	562.59	562.59	403.0
2024-09-16 05:30:00	SPY	ETF	562.59	562.59	562.59	562.59	200.0
2024-09-16 05:35:00	SPY	ETF	562.62	562.62	562.57	562.57	990.0
2024-09-16 05:40:00	SPY	ETF	562.55	562.55	562.53	562.53	700.0
2024-09-16 05:45:00	SPY	ETF	562.4	562.4	562.35	562.35	318.0
2024-09-16 05:55:00	SPY	ETF	562.37	562.37	562.3	562.3	403.0
2024-09-16 06:00:00	SPY	ETF	562.34	562.34	562.08	562.08	610.0
2024-09-16 06:05:00	SPY	ETF	562.12	562.12	562.0	562.0	5800.0
2024-09-16 06:10:00	SPY	ETF	562.02	562.05	562.02	562.05	4001.0
2024-09-16 06:15:00	SPY	ETF	562.12	562.14	562.12	562.14	800.0
2024-09-16 06:20:00	SPY	ETF	562.1	562.1	562.1	562.1	200.0
2024-09-16 06:25:00	SPY	ETF	561.77	561.77	561.77	561.77	100.0
2024-09-16 06:35:00	SPY	ETF	561.72	561.72	561.71	561.71	369.0
2024-09-16 06:40:00	SPY	ETF	561.79	561.97	561.79	561.97	3805.0
2024-09-16 06:50:00	SPY	ETF	562.21	562.21	562.21	562.21	100.0
2024-09-16 06:55:00	SPY	ETF	562.11	562.11	562.11	562.11	250.0
2024-09-16 07:00:00	SPY	ETF	562.14	562.18	562.12	562.12	3445.0
2024-09-16 07:05:00	SPY	ETF	562.0	562.07	562.0	562.01	1844.0
2024-09-16 07:10:00	SPY	ETF	562.01	562.01	562.01	562.01	126.0
2024-09-16 07:15:00	SPY	ETF	561.88	561.88	561.77	561.81	1094.0
2024-09-16 07:20:00	SPY	ETF	561.76	561.8	561.6	561.6	18450.0
2024-09-16 07:25:00	SPY	ETF	561.6	561.65	561.52	561.61	4499.0
2024-09-16 07:30:00	SPY	ETF	561.7	561.7	561.6	561.64	13947.0
2024-09-16 07:35:00	SPY	ETF	561.66	561.74	561.66	561.7	7877.0
2024-09-16 07:40:00	SPY	ETF	561.7	561.82	561.62	561.66	17307.0
2024-09-16 07:45:00	SPY	ETF	561.7	561.9	561.7	561.89	4652.0
2024-09-16 07:50:00	SPY	ETF	561.8	561.84	561.65	561.65	2765.0
2024-09-16 07:55:00	SPY	ETF	561.7	561.73	561.58	561.71	1684.0
2024-09-16 08:00:00	SPY	ETF	562.14	562.3	561.51	561.51	29150.0
2024-09-16 08:05:00	SPY	ETF	561.52	561.82	561.43	561.82	29653.0
2024-09-16 08:10:00	SPY	ETF	561.82	561.8898	561.67	561.72	8268.0
2024-09-16 08:15:00	SPY	ETF	561.66	561.6615	561.47	561.5	61176.0
2024-09-16 08:20:00	SPY	ETF	561.48	561.49	561.42	561.43	8020.0
2024-09-16 08:25:00	SPY	ETF	561.432	561.54	561.432	561.53	4611.0

> showing 50 of 111,593 rows — these rows as CSV

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