PREVIEW / etf_5min / 2024-09-19

all etf 5-min files

  file:    by_date/etf_5min/2024/2024-09-19.parquet
  size:    2.4 MB
  rows:    120,624

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-19 04:00:00	SPY	ETF	567.22	568.33	566.22	568.28	9207.0
2024-09-19 04:05:00	SPY	ETF	568.26	568.57	568.21	568.25	8318.0
2024-09-19 04:10:00	SPY	ETF	568.27	568.74	568.26	568.7	3609.0
2024-09-19 04:15:00	SPY	ETF	568.66	568.66	568.32	568.4	4071.0
2024-09-19 04:20:00	SPY	ETF	568.52	568.52	568.25	568.25	7351.0
2024-09-19 04:25:00	SPY	ETF	568.24	568.45	568.22	568.45	1238.0
2024-09-19 04:30:00	SPY	ETF	568.44	568.75	568.44	568.71	2507.0
2024-09-19 04:35:00	SPY	ETF	568.64	568.74	568.54	568.67	5544.0
2024-09-19 04:40:00	SPY	ETF	568.77	569.0	568.77	568.83	6961.0
2024-09-19 04:45:00	SPY	ETF	568.84	568.93	568.74	568.81	8256.0
2024-09-19 04:50:00	SPY	ETF	568.95	568.97	568.9	568.92	3946.0
2024-09-19 04:55:00	SPY	ETF	569.01	569.02	568.87	568.87	4350.0
2024-09-19 05:00:00	SPY	ETF	568.9	569.23	568.86	569.23	8860.0
2024-09-19 05:05:00	SPY	ETF	569.39	569.55	569.39	569.45	3353.0
2024-09-19 05:10:00	SPY	ETF	569.47	569.73	569.44	569.63	7040.0
2024-09-19 05:15:00	SPY	ETF	569.65	569.8	569.6	569.7	8128.0
2024-09-19 05:20:00	SPY	ETF	569.78	569.94	569.78	569.87	14636.0
2024-09-19 05:25:00	SPY	ETF	569.86	569.86	569.73	569.73	6665.0
2024-09-19 05:30:00	SPY	ETF	569.75	569.81	569.64	569.81	7878.0
2024-09-19 05:35:00	SPY	ETF	569.95	570.05	569.95	570.02	5893.0
2024-09-19 05:40:00	SPY	ETF	569.93	570.0	569.88	569.92	13420.0
2024-09-19 05:45:00	SPY	ETF	569.95	570.04	569.88	569.93	698.0
2024-09-19 05:50:00	SPY	ETF	569.88	569.95	569.85	569.93	1588.0
2024-09-19 05:55:00	SPY	ETF	569.92	569.92	569.87	569.87	1294.0
2024-09-19 06:00:00	SPY	ETF	569.95	569.95	569.75	569.8	4500.0
2024-09-19 06:05:00	SPY	ETF	569.78	570.25	569.78	570.08	74624.0
2024-09-19 06:10:00	SPY	ETF	570.1	570.2	570.05	570.06	5005.0
2024-09-19 06:15:00	SPY	ETF	570.0	570.25	570.0	570.22	12867.0
2024-09-19 06:20:00	SPY	ETF	570.18	570.32	570.18	570.29	8026.0
2024-09-19 06:25:00	SPY	ETF	570.25	570.45	570.25	570.44	26360.0
2024-09-19 06:30:00	SPY	ETF	570.44	570.61	570.44	570.61	10668.0
2024-09-19 06:35:00	SPY	ETF	570.64	570.65	570.57	570.65	9051.0
2024-09-19 06:40:00	SPY	ETF	570.58	570.65	570.42	570.44	8003.0
2024-09-19 06:45:00	SPY	ETF	570.51	570.54	570.34	570.43	20654.0
2024-09-19 06:50:00	SPY	ETF	570.42	570.65	570.4	570.65	12301.0
2024-09-19 06:55:00	SPY	ETF	570.65	570.65	570.46	570.47	6717.0
2024-09-19 07:00:00	SPY	ETF	570.47	570.65	570.32	570.32	33084.0
2024-09-19 07:05:00	SPY	ETF	570.36	570.45	570.27	570.43	45942.0
2024-09-19 07:10:00	SPY	ETF	570.45	570.54	570.24	570.271	20354.0
2024-09-19 07:15:00	SPY	ETF	570.25	570.34	570.2	570.33	18391.0
2024-09-19 07:20:00	SPY	ETF	570.36	570.45	570.33	570.34	19497.0
2024-09-19 07:25:00	SPY	ETF	570.38	570.42	570.32	570.42	5800.0
2024-09-19 07:30:00	SPY	ETF	570.38	570.7	570.3	570.66	29852.0
2024-09-19 07:35:00	SPY	ETF	570.63	570.72	570.53	570.65	33002.0
2024-09-19 07:40:00	SPY	ETF	570.66	571.05	570.66	570.85	66319.0
2024-09-19 07:45:00	SPY	ETF	570.79	570.8	570.52	570.59	49273.0
2024-09-19 07:50:00	SPY	ETF	570.62	570.65	570.46	570.46	20289.0
2024-09-19 07:55:00	SPY	ETF	570.441	570.57	570.41	570.54	17375.0
2024-09-19 08:00:00	SPY	ETF	570.48	571.02	566.6	570.49	73317.0
2024-09-19 08:05:00	SPY	ETF	570.5	570.5	570.37	570.4	30807.0

> showing 50 of 120,624 rows — these rows as CSV

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