PREVIEW / etf_5min / 2023-11-16

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-11-16.parquet
  size:    2.1 MB
  rows:    104,252

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-11-16 04:00:00	SPY	ETF	449.69	449.69	449.41	449.52	14219.0
2023-11-16 04:05:00	SPY	ETF	449.43	449.67	449.43	449.66	9607.0
2023-11-16 04:10:00	SPY	ETF	449.69	449.82	449.66	449.81	8616.0
2023-11-16 04:15:00	SPY	ETF	449.78	450.03	449.78	449.97	9691.0
2023-11-16 04:20:00	SPY	ETF	450.03	450.07	449.94	449.94	6842.0
2023-11-16 04:25:00	SPY	ETF	449.94	449.94	449.74	449.74	6109.0
2023-11-16 04:30:00	SPY	ETF	449.73	449.73	449.58	449.63	5103.0
2023-11-16 04:35:00	SPY	ETF	449.65	449.75	449.52	449.52	1112.0
2023-11-16 04:40:00	SPY	ETF	449.54	449.54	449.54	449.54	180.0
2023-11-16 04:45:00	SPY	ETF	449.55	449.56	449.55	449.56	500.0
2023-11-16 04:50:00	SPY	ETF	449.62	449.62	449.51	449.51	770.0
2023-11-16 05:05:00	SPY	ETF	449.52	449.52	449.42	449.45	538.0
2023-11-16 05:10:00	SPY	ETF	449.55	449.55	449.55	449.55	280.0
2023-11-16 05:15:00	SPY	ETF	449.65	449.7	449.64	449.7	2250.0
2023-11-16 05:20:00	SPY	ETF	449.69	449.75	449.68	449.75	1344.0
2023-11-16 05:25:00	SPY	ETF	449.8	449.88	449.8	449.88	1289.0
2023-11-16 05:30:00	SPY	ETF	449.88	449.94	449.88	449.91	1144.0
2023-11-16 05:35:00	SPY	ETF	449.88	449.88	449.79	449.79	1284.0
2023-11-16 05:40:00	SPY	ETF	449.76	449.77	449.68	449.68	1436.0
2023-11-16 05:45:00	SPY	ETF	449.69	449.8	449.69	449.8	900.0
2023-11-16 05:50:00	SPY	ETF	449.8	449.8	449.8	449.8	200.0
2023-11-16 05:55:00	SPY	ETF	449.63	449.66	449.58	449.66	474.0
2023-11-16 06:00:00	SPY	ETF	449.7	449.77	449.7	449.77	674.0
2023-11-16 06:05:00	SPY	ETF	449.68	449.74	449.68	449.74	1100.0
2023-11-16 06:10:00	SPY	ETF	449.66	449.66	449.66	449.66	900.0
2023-11-16 06:15:00	SPY	ETF	449.67	449.7	449.67	449.7	1300.0
2023-11-16 06:20:00	SPY	ETF	449.7	449.84	449.7	449.84	2273.0
2023-11-16 06:25:00	SPY	ETF	449.79	449.79	449.76	449.76	1141.0
2023-11-16 06:30:00	SPY	ETF	449.78	449.78	449.78	449.78	491.0
2023-11-16 06:35:00	SPY	ETF	449.65	449.65	449.61	449.61	1064.0
2023-11-16 06:40:00	SPY	ETF	449.6	449.6	449.49	449.51	1701.0
2023-11-16 06:45:00	SPY	ETF	449.6	449.6	449.5	449.53	4617.0
2023-11-16 06:50:00	SPY	ETF	449.54	449.6	449.54	449.6	6036.0
2023-11-16 06:55:00	SPY	ETF	449.63	449.73	449.63	449.71	1453.0
2023-11-16 07:00:00	SPY	ETF	449.78	449.78	449.43	449.43	5428.0
2023-11-16 07:05:00	SPY	ETF	449.46	449.46	449.14	449.19	24159.0
2023-11-16 07:10:00	SPY	ETF	449.15	449.19	449.01	449.08	28385.0
2023-11-16 07:15:00	SPY	ETF	449.08	449.09	448.95	448.97	26187.0
2023-11-16 07:20:00	SPY	ETF	448.94	449.01	448.87	448.94	9845.0
2023-11-16 07:25:00	SPY	ETF	448.99	449.01	448.89	448.98	24203.0
2023-11-16 07:30:00	SPY	ETF	448.99	449.2	448.94	449.17	30396.0
2023-11-16 07:35:00	SPY	ETF	449.18	449.18	448.95	448.95	45336.0
2023-11-16 07:40:00	SPY	ETF	448.97	449.15	448.93	449.06	15319.0
2023-11-16 07:45:00	SPY	ETF	449.12	449.291	449.12	449.22	5241.0
2023-11-16 07:50:00	SPY	ETF	449.23	449.26	449.05	449.05	3437.0
2023-11-16 07:55:00	SPY	ETF	449.02	449.09	448.93	448.95	22042.0
2023-11-16 08:00:00	SPY	ETF	449.4901	449.75	448.89	449.15	48085.0
2023-11-16 08:05:00	SPY	ETF	449.13	449.23	449.09	449.09	13427.0
2023-11-16 08:10:00	SPY	ETF	449.1	449.13	448.81	448.81	8034.0
2023-11-16 08:15:00	SPY	ETF	448.79	448.93	448.75	448.9	16306.0

> showing 50 of 104,252 rows — these rows as CSV

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