PREVIEW / etf_5min / 2023-10-27

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-10-27.parquet
  size:    2.1 MB
  rows:    101,180

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-10-27 04:00:00	SPY	ETF	414.5	414.78	414.4	414.74	3535.0
2023-10-27 04:05:00	SPY	ETF	414.77	414.79	414.69	414.69	1092.0
2023-10-27 04:10:00	SPY	ETF	414.62	414.67	414.5	414.67	1311.0
2023-10-27 04:15:00	SPY	ETF	414.67	414.89	414.67	414.89	2276.0
2023-10-27 04:20:00	SPY	ETF	414.86	414.96	414.8	414.92	4400.0
2023-10-27 04:25:00	SPY	ETF	414.83	414.92	414.77	414.89	5892.0
2023-10-27 04:30:00	SPY	ETF	414.95	415.09	414.87	415.07	4567.0
2023-10-27 04:35:00	SPY	ETF	415.04	415.12	414.97	415.12	2197.0
2023-10-27 04:40:00	SPY	ETF	415.14	415.2	415.04	415.19	2012.0
2023-10-27 04:45:00	SPY	ETF	415.18	415.18	415.01	415.01	3150.0
2023-10-27 04:50:00	SPY	ETF	415.08	415.14	415.02	415.14	3195.0
2023-10-27 04:55:00	SPY	ETF	415.09	415.35	415.09	415.35	754.0
2023-10-27 05:00:00	SPY	ETF	415.3	415.4	415.15	415.2	8322.0
2023-10-27 05:05:00	SPY	ETF	415.29	415.3	415.22	415.27	1641.0
2023-10-27 05:10:00	SPY	ETF	415.2	415.2	414.97	414.97	702.0
2023-10-27 05:15:00	SPY	ETF	415.04	415.08	415.0	415.0	1300.0
2023-10-27 05:20:00	SPY	ETF	414.91	414.96	414.89	414.89	703.0
2023-10-27 05:25:00	SPY	ETF	414.89	414.97	414.89	414.95	2517.0
2023-10-27 05:30:00	SPY	ETF	414.89	415.0	414.86	415.0	3148.0
2023-10-27 05:35:00	SPY	ETF	414.76	414.79	414.61	414.64	817.0
2023-10-27 05:40:00	SPY	ETF	414.72	414.72	414.61	414.61	1720.0
2023-10-27 05:45:00	SPY	ETF	414.57	414.65	414.54	414.6	14781.0
2023-10-27 05:50:00	SPY	ETF	414.65	414.7	414.6	414.66	2160.0
2023-10-27 05:55:00	SPY	ETF	414.71	414.72	414.68	414.7	3234.0
2023-10-27 06:00:00	SPY	ETF	414.72	414.82	414.72	414.79	4128.0
2023-10-27 06:05:00	SPY	ETF	414.83	414.93	414.83	414.93	455.0
2023-10-27 06:10:00	SPY	ETF	414.88	414.97	414.88	414.97	585.0
2023-10-27 06:15:00	SPY	ETF	414.9	414.94	414.9	414.94	460.0
2023-10-27 06:20:00	SPY	ETF	414.9	414.9	414.72	414.77	1204.0
2023-10-27 06:25:00	SPY	ETF	414.74	414.76	414.74	414.75	1024.0
2023-10-27 06:30:00	SPY	ETF	414.61	414.61	414.46	414.5	2131.0
2023-10-27 06:35:00	SPY	ETF	414.58	414.58	414.41	414.47	3684.0
2023-10-27 06:40:00	SPY	ETF	414.51	414.65	414.51	414.65	800.0
2023-10-27 06:45:00	SPY	ETF	414.7	414.7	414.7	414.7	346.0
2023-10-27 06:50:00	SPY	ETF	414.69	414.69	414.65	414.66	515.0
2023-10-27 06:55:00	SPY	ETF	414.46	414.46	414.22	414.27	3750.0
2023-10-27 07:00:00	SPY	ETF	414.26	414.38	414.05	414.38	27248.0
2023-10-27 07:05:00	SPY	ETF	414.2	414.27	414.09	414.09	21712.0
2023-10-27 07:10:00	SPY	ETF	414.05	414.09	413.7	413.88	28718.0
2023-10-27 07:15:00	SPY	ETF	413.85	413.85	413.53	413.58	13376.0
2023-10-27 07:20:00	SPY	ETF	413.57	413.75	413.56	413.72	7009.0
2023-10-27 07:25:00	SPY	ETF	413.75	413.75	413.49	413.57	7114.0
2023-10-27 07:30:00	SPY	ETF	413.55	413.68	413.45	413.63	6457.0
2023-10-27 07:35:00	SPY	ETF	413.56	413.58	413.34	413.4	11400.0
2023-10-27 07:40:00	SPY	ETF	413.4	413.4	413.29	413.31	4425.0
2023-10-27 07:45:00	SPY	ETF	413.46	413.55	413.34	413.35	22131.0
2023-10-27 07:50:00	SPY	ETF	413.37	413.39	413.2	413.21	15867.0
2023-10-27 07:55:00	SPY	ETF	413.19	413.27	413.11	413.2	34089.0
2023-10-27 08:00:00	SPY	ETF	414.31	415.14	413.0504	413.24	133957.0
2023-10-27 08:05:00	SPY	ETF	413.29	413.63	413.29	413.62	60412.0

> showing 50 of 101,180 rows — these rows as CSV

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