PREVIEW / etf_5min / 2023-05-24

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-05-24.parquet
  size:    2.0 MB
  rows:    99,224

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
2023-05-24 04:00:00	SPY	ETF	413.85	413.85	412.86	413.3	10451.0
2023-05-24 04:05:00	SPY	ETF	413.35	413.64	413.35	413.42	3441.0
2023-05-24 04:10:00	SPY	ETF	413.49	413.49	413.26	413.26	5298.0
2023-05-24 04:15:00	SPY	ETF	413.22	413.35	413.14	413.16	5671.0
2023-05-24 04:20:00	SPY	ETF	413.17	413.27	413.17	413.27	706.0
2023-05-24 04:25:00	SPY	ETF	413.28	413.28	413.14	413.26	1155.0
2023-05-24 04:30:00	SPY	ETF	413.25	413.46	413.25	413.37	3700.0
2023-05-24 04:35:00	SPY	ETF	413.32	413.44	413.25	413.25	1700.0
2023-05-24 04:40:00	SPY	ETF	413.4	413.58	413.4	413.49	2360.0
2023-05-24 04:45:00	SPY	ETF	413.6	413.73	413.6	413.65	1400.0
2023-05-24 04:50:00	SPY	ETF	413.7	413.77	413.7	413.77	700.0
2023-05-24 04:55:00	SPY	ETF	413.83	414.02	413.83	414.0	2841.0
2023-05-24 05:00:00	SPY	ETF	413.91	414.16	413.87	414.03	14750.0
2023-05-24 05:05:00	SPY	ETF	414.13	414.13	413.75	413.75	1000.0
2023-05-24 05:10:00	SPY	ETF	413.75	413.76	413.61	413.66	3950.0
2023-05-24 05:15:00	SPY	ETF	413.63	413.63	413.56	413.56	1400.0
2023-05-24 05:20:00	SPY	ETF	413.56	413.64	413.5	413.5	4470.0
2023-05-24 05:25:00	SPY	ETF	413.6	413.6	413.51	413.51	1100.0
2023-05-24 05:30:00	SPY	ETF	413.51	413.52	413.45	413.45	805.0
2023-05-24 05:35:00	SPY	ETF	413.42	413.43	413.33	413.42	5435.0
2023-05-24 05:40:00	SPY	ETF	413.44	413.56	413.44	413.54	1240.0
2023-05-24 05:45:00	SPY	ETF	413.44	413.44	413.44	413.44	200.0
2023-05-24 05:50:00	SPY	ETF	413.39	413.51	413.37	413.51	80450.0
2023-05-24 05:55:00	SPY	ETF	413.47	413.51	413.36	413.36	20718.0
2023-05-24 06:00:00	SPY	ETF	413.34	413.6	413.26	413.59	12367.0
2023-05-24 06:05:00	SPY	ETF	413.47	413.47	413.16	413.17	3003.0
2023-05-24 06:10:00	SPY	ETF	413.0	413.0	412.91	412.95	3936.0
2023-05-24 06:15:00	SPY	ETF	412.82	412.93	412.7	412.86	8007.0
2023-05-24 06:20:00	SPY	ETF	412.81	412.81	412.64	412.7	1850.0
2023-05-24 06:25:00	SPY	ETF	412.7	412.79	412.59	412.68	3242.0
2023-05-24 06:30:00	SPY	ETF	412.67	412.75	412.62	412.64	10400.0
2023-05-24 06:35:00	SPY	ETF	412.66	412.66	412.52	412.66	3699.0
2023-05-24 06:40:00	SPY	ETF	412.64	412.91	412.58	412.9	107744.0
2023-05-24 06:45:00	SPY	ETF	412.83	412.9	412.8	412.82	115966.0
2023-05-24 06:50:00	SPY	ETF	412.8	412.96	412.77	412.84	2100.0
2023-05-24 06:55:00	SPY	ETF	412.88	412.94	412.86	412.9	51600.0
2023-05-24 07:00:00	SPY	ETF	412.89	413.05	412.87	412.9	72300.0
2023-05-24 07:05:00	SPY	ETF	412.95	412.97	412.83	412.83	13884.0
2023-05-24 07:10:00	SPY	ETF	412.83	412.83	412.6	412.7	24059.0
2023-05-24 07:15:00	SPY	ETF	412.73	413.01	412.72	412.94	23046.0
2023-05-24 07:20:00	SPY	ETF	412.97	412.97	412.65	412.65	23774.0
2023-05-24 07:25:00	SPY	ETF	412.65	412.79	412.64	412.79	9243.0
2023-05-24 07:30:00	SPY	ETF	412.79	412.86	412.78	412.83	15738.0
2023-05-24 07:35:00	SPY	ETF	412.79	412.87	412.69	412.72	15373.0
2023-05-24 07:40:00	SPY	ETF	412.71	412.79	412.69	412.79	4024.0
2023-05-24 07:45:00	SPY	ETF	412.77	412.78	412.68	412.69	9806.0
2023-05-24 07:50:00	SPY	ETF	412.67	412.77	412.49	412.49	27771.0
2023-05-24 07:55:00	SPY	ETF	412.46	412.57	412.4	412.46	14291.0
2023-05-24 08:00:00	SPY	ETF	413.02	414.87	412.38	412.57	47688.0
2023-05-24 08:05:00	SPY	ETF	412.59	412.86	412.59	412.83	16455.0

> showing 50 of 99,224 rows — these rows as CSV

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