PREVIEW / etf_5min / 2023-11-09

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-11-09.parquet
  size:    2.1 MB
  rows:    101,844

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-09 04:00:00	SPY	ETF	437.58	437.62	437.36	437.45	3146.0
2023-11-09 04:05:00	SPY	ETF	437.43	437.46	437.31	437.46	1315.0
2023-11-09 04:10:00	SPY	ETF	437.44	437.44	437.3	437.4	1471.0
2023-11-09 04:15:00	SPY	ETF	437.39	437.54	437.39	437.54	520.0
2023-11-09 04:20:00	SPY	ETF	437.49	437.56	437.49	437.56	600.0
2023-11-09 04:25:00	SPY	ETF	437.68	437.73	437.65	437.73	431.0
2023-11-09 04:30:00	SPY	ETF	437.69	437.73	437.65	437.65	1610.0
2023-11-09 04:35:00	SPY	ETF	437.65	437.65	437.59	437.59	910.0
2023-11-09 04:40:00	SPY	ETF	437.48	437.49	437.48	437.49	400.0
2023-11-09 04:45:00	SPY	ETF	437.46	437.46	437.46	437.46	246.0
2023-11-09 04:55:00	SPY	ETF	437.44	437.6	437.44	437.59	1600.0
2023-11-09 05:00:00	SPY	ETF	437.6	437.7	437.6	437.7	5060.0
2023-11-09 05:05:00	SPY	ETF	437.75	437.8	437.75	437.77	1500.0
2023-11-09 05:15:00	SPY	ETF	437.75	437.84	437.75	437.83	1253.0
2023-11-09 05:20:00	SPY	ETF	437.88	437.92	437.88	437.92	2322.0
2023-11-09 05:25:00	SPY	ETF	438.07	438.07	437.99	437.99	464.0
2023-11-09 05:30:00	SPY	ETF	437.93	438.05	437.93	438.05	1200.0
2023-11-09 05:35:00	SPY	ETF	438.03	438.23	438.03	438.23	3049.0
2023-11-09 05:40:00	SPY	ETF	438.24	438.49	438.24	438.49	9002.0
2023-11-09 05:45:00	SPY	ETF	438.5	438.53	438.36	438.44	22820.0
2023-11-09 05:50:00	SPY	ETF	438.4	438.42	438.34	438.34	3500.0
2023-11-09 05:55:00	SPY	ETF	438.42	438.45	438.33	438.45	2303.0
2023-11-09 06:00:00	SPY	ETF	438.4	438.4	438.33	438.33	1148.0
2023-11-09 06:05:00	SPY	ETF	438.32	438.35	438.23	438.23	1200.0
2023-11-09 06:10:00	SPY	ETF	438.2	438.2	438.12	438.12	1151.0
2023-11-09 06:15:00	SPY	ETF	438.1	438.12	438.01	438.01	1707.0
2023-11-09 06:20:00	SPY	ETF	438.0	438.0	437.8	437.84	5529.0
2023-11-09 06:25:00	SPY	ETF	437.79	437.88	437.79	437.85	465.0
2023-11-09 06:30:00	SPY	ETF	437.86	437.86	437.8	437.8	11142.0
2023-11-09 06:35:00	SPY	ETF	437.71	437.92	437.71	437.9	500.0
2023-11-09 06:40:00	SPY	ETF	437.93	437.93	437.87	437.87	12251.0
2023-11-09 06:45:00	SPY	ETF	437.86	437.89	437.84	437.85	1539.0
2023-11-09 06:50:00	SPY	ETF	437.81	437.82	437.8	437.8	450.0
2023-11-09 06:55:00	SPY	ETF	437.74	437.74	437.74	437.74	900.0
2023-11-09 07:00:00	SPY	ETF	437.74	437.88	437.74	437.87	2357.0
2023-11-09 07:05:00	SPY	ETF	437.94	438.0	437.9	437.93	44308.0
2023-11-09 07:10:00	SPY	ETF	437.94	437.94	437.9	437.9	7741.0
2023-11-09 07:15:00	SPY	ETF	437.92	437.96	437.92	437.96	1414.0
2023-11-09 07:20:00	SPY	ETF	437.93	437.95	437.92	437.95	1335.0
2023-11-09 07:25:00	SPY	ETF	437.93	437.98	437.8	437.85	49769.0
2023-11-09 07:30:00	SPY	ETF	437.85	438.04	437.85	438.04	29349.0
2023-11-09 07:35:00	SPY	ETF	437.99	438.01	437.91	437.94	25182.0
2023-11-09 07:40:00	SPY	ETF	437.94	437.94	437.9	437.93	3680.0
2023-11-09 07:45:00	SPY	ETF	437.93	438.07	437.91	438.07	13446.0
2023-11-09 07:50:00	SPY	ETF	438.06	438.1	438.04	438.1	10809.0
2023-11-09 07:55:00	SPY	ETF	438.09	438.12	438.05	438.12	1041.0
2023-11-09 08:00:00	SPY	ETF	437.9503	438.4904	437.12	438.26	71104.0
2023-11-09 08:05:00	SPY	ETF	438.28	438.35	438.24	438.35	7461.0
2023-11-09 08:10:00	SPY	ETF	438.35	438.35	438.21	438.3	7919.0
2023-11-09 08:15:00	SPY	ETF	438.32	438.35	438.19	438.35	20048.0

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

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