PREVIEW / etf_5min / 2023-06-15

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-06-15.parquet
  size:    2.1 MB
  rows:    99,225

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-06-15 04:00:00	SPY	ETF	437.11	437.18	436.94	437.18	10258.0
2023-06-15 04:05:00	SPY	ETF	437.12	437.12	436.88	437.0	3018.0
2023-06-15 04:10:00	SPY	ETF	436.91	436.91	436.91	436.91	224.0
2023-06-15 04:15:00	SPY	ETF	436.95	437.12	436.95	437.07	1330.0
2023-06-15 04:20:00	SPY	ETF	437.12	437.12	436.91	436.91	2967.0
2023-06-15 04:25:00	SPY	ETF	436.94	436.94	436.9	436.9	2080.0
2023-06-15 04:30:00	SPY	ETF	436.86	436.9	436.74	436.81	7119.0
2023-06-15 04:35:00	SPY	ETF	436.75	436.8	436.71	436.8	758.0
2023-06-15 04:40:00	SPY	ETF	436.62	436.62	436.33	436.33	4666.0
2023-06-15 04:45:00	SPY	ETF	436.38	436.41	436.38	436.38	500.0
2023-06-15 04:50:00	SPY	ETF	436.37	436.55	436.37	436.53	2295.0
2023-06-15 04:55:00	SPY	ETF	436.51	436.51	436.39	436.39	3177.0
2023-06-15 05:00:00	SPY	ETF	436.39	436.48	436.39	436.48	1324.0
2023-06-15 05:05:00	SPY	ETF	436.43	436.43	436.29	436.36	3289.0
2023-06-15 05:10:00	SPY	ETF	436.49	436.51	436.45	436.48	1597.0
2023-06-15 05:15:00	SPY	ETF	436.43	436.43	436.25	436.28	4400.0
2023-06-15 05:20:00	SPY	ETF	436.26	436.26	436.02	436.02	3990.0
2023-06-15 05:25:00	SPY	ETF	436.06	436.17	436.06	436.14	2300.0
2023-06-15 05:30:00	SPY	ETF	436.27	436.3	436.27	436.3	500.0
2023-06-15 05:35:00	SPY	ETF	436.2	436.33	436.19	436.33	880.0
2023-06-15 05:40:00	SPY	ETF	436.2	436.31	436.2	436.3	768.0
2023-06-15 05:45:00	SPY	ETF	436.23	436.23	436.16	436.16	2100.0
2023-06-15 05:50:00	SPY	ETF	436.18	436.25	436.01	436.01	2914.0
2023-06-15 05:55:00	SPY	ETF	436.1	436.22	436.06	436.22	1709.0
2023-06-15 06:00:00	SPY	ETF	436.22	436.22	436.13	436.13	1700.0
2023-06-15 06:05:00	SPY	ETF	436.3	436.3	436.16	436.16	1250.0
2023-06-15 06:10:00	SPY	ETF	436.04	436.04	436.03	436.03	1100.0
2023-06-15 06:15:00	SPY	ETF	436.14	436.15	435.85	435.9	3408.0
2023-06-15 06:20:00	SPY	ETF	435.98	435.98	435.87	435.87	500.0
2023-06-15 06:25:00	SPY	ETF	435.78	435.89	435.73	435.89	14030.0
2023-06-15 06:30:00	SPY	ETF	435.9	435.9	435.5	435.5	19600.0
2023-06-15 06:35:00	SPY	ETF	435.64	435.64	435.62	435.63	3800.0
2023-06-15 06:40:00	SPY	ETF	435.59	435.59	435.54	435.59	2700.0
2023-06-15 06:45:00	SPY	ETF	435.56	435.67	435.49	435.5	2969.0
2023-06-15 06:50:00	SPY	ETF	435.5	435.59	435.5	435.59	400.0
2023-06-15 06:55:00	SPY	ETF	435.59	435.67	435.58	435.64	2877.0
2023-06-15 07:00:00	SPY	ETF	435.64	435.84	435.62	435.72	8502.0
2023-06-15 07:05:00	SPY	ETF	435.71	435.71	435.53	435.56	39404.0
2023-06-15 07:10:00	SPY	ETF	435.56	435.56	435.4	435.55	16039.0
2023-06-15 07:15:00	SPY	ETF	435.55	435.62	435.46	435.461	8017.0
2023-06-15 07:20:00	SPY	ETF	435.49	435.63	435.48	435.63	10742.0
2023-06-15 07:25:00	SPY	ETF	435.64	435.67	435.6	435.67	3500.0
2023-06-15 07:30:00	SPY	ETF	435.66	435.91	435.65	435.86	19232.0
2023-06-15 07:35:00	SPY	ETF	435.88	435.88	435.55	435.55	12039.0
2023-06-15 07:40:00	SPY	ETF	435.56	435.7	435.56	435.68	6264.0
2023-06-15 07:45:00	SPY	ETF	435.71	435.81	435.71	435.74	4800.0
2023-06-15 07:50:00	SPY	ETF	435.76	435.87	435.74	435.77	6869.0
2023-06-15 07:55:00	SPY	ETF	435.84	435.84	435.79	435.79	11240.0
2023-06-15 08:00:00	SPY	ETF	435.47	437.49	435.41	435.9001	60595.0
2023-06-15 08:05:00	SPY	ETF	435.95	435.95	435.8	435.88	12149.0

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

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