PREVIEW / etf_5min / 2023-07-19

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-07-19.parquet
  size:    2.1 MB
  rows:    100,974

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-07-19 04:00:00	SPY	ETF	454.09	454.25	454.09	454.25	34142.0
2023-07-19 04:05:00	SPY	ETF	454.24	454.31	454.24	454.25	1430.0
2023-07-19 04:10:00	SPY	ETF	454.15	454.26	454.15	454.25	1612.0
2023-07-19 04:15:00	SPY	ETF	454.33	454.33	454.33	454.33	1000.0
2023-07-19 04:20:00	SPY	ETF	454.37	454.45	454.33	454.38	4737.0
2023-07-19 04:25:00	SPY	ETF	454.49	454.5	454.49	454.5	350.0
2023-07-19 04:30:00	SPY	ETF	454.43	454.44	454.4	454.43	1028.0
2023-07-19 04:35:00	SPY	ETF	454.46	454.51	454.46	454.5	700.0
2023-07-19 04:40:00	SPY	ETF	454.6	454.6	454.55	454.55	700.0
2023-07-19 04:45:00	SPY	ETF	454.55	454.61	454.52	454.61	1300.0
2023-07-19 04:50:00	SPY	ETF	454.59	454.59	454.53	454.53	450.0
2023-07-19 04:55:00	SPY	ETF	454.55	454.55	454.55	454.55	222.0
2023-07-19 05:00:00	SPY	ETF	454.42	454.45	454.42	454.45	421.0
2023-07-19 05:05:00	SPY	ETF	454.51	454.54	454.51	454.53	3900.0
2023-07-19 05:10:00	SPY	ETF	454.51	454.56	454.49	454.56	800.0
2023-07-19 05:15:00	SPY	ETF	454.54	454.54	454.45	454.5	797.0
2023-07-19 05:20:00	SPY	ETF	454.59	454.6	454.59	454.6	600.0
2023-07-19 05:25:00	SPY	ETF	454.51	454.51	454.47	454.47	924.0
2023-07-19 05:30:00	SPY	ETF	454.45	454.45	454.45	454.45	100.0
2023-07-19 05:35:00	SPY	ETF	454.53	454.61	454.53	454.61	817.0
2023-07-19 05:40:00	SPY	ETF	454.54	454.62	454.54	454.55	3579.0
2023-07-19 05:45:00	SPY	ETF	454.59	454.59	454.55	454.55	800.0
2023-07-19 05:50:00	SPY	ETF	454.59	454.64	454.56	454.56	5719.0
2023-07-19 05:55:00	SPY	ETF	454.54	454.54	454.5	454.5	12963.0
2023-07-19 06:00:00	SPY	ETF	454.47	454.54	454.47	454.5	844.0
2023-07-19 06:05:00	SPY	ETF	454.54	454.54	454.47	454.47	1200.0
2023-07-19 06:10:00	SPY	ETF	454.45	454.5	454.45	454.5	3864.0
2023-07-19 06:15:00	SPY	ETF	454.5	454.5	454.5	454.5	100.0
2023-07-19 06:20:00	SPY	ETF	454.43	454.43	454.4	454.42	500.0
2023-07-19 06:25:00	SPY	ETF	454.37	454.37	454.37	454.37	575.0
2023-07-19 06:30:00	SPY	ETF	454.42	454.44	454.39	454.39	3019.0
2023-07-19 06:35:00	SPY	ETF	454.4	454.41	454.4	454.41	297.0
2023-07-19 06:40:00	SPY	ETF	454.39	454.39	454.37	454.37	1100.0
2023-07-19 06:45:00	SPY	ETF	454.4	454.4	454.4	454.4	1000.0
2023-07-19 06:50:00	SPY	ETF	454.4	454.45	454.39	454.45	8857.0
2023-07-19 06:55:00	SPY	ETF	454.45	454.51	454.45	454.51	2286.0
2023-07-19 07:00:00	SPY	ETF	454.52	454.59	454.45	454.51	13288.0
2023-07-19 07:05:00	SPY	ETF	454.51	454.51	454.35	454.35	3596.0
2023-07-19 07:10:00	SPY	ETF	454.39	454.39	454.23	454.23	1469.0
2023-07-19 07:15:00	SPY	ETF	454.19	454.21	454.17	454.18	2566.0
2023-07-19 07:20:00	SPY	ETF	454.17	454.29	454.13	454.2	16292.0
2023-07-19 07:25:00	SPY	ETF	454.19	454.35	454.0	454.35	12378.0
2023-07-19 07:30:00	SPY	ETF	454.32	454.34	454.26	454.26	800.0
2023-07-19 07:35:00	SPY	ETF	454.27	454.27	454.15	454.15	8346.0
2023-07-19 07:40:00	SPY	ETF	454.13	454.15	454.01	454.1	5033.0
2023-07-19 07:45:00	SPY	ETF	454.01	454.09	454.0	454.06	10023.0
2023-07-19 07:50:00	SPY	ETF	454.13	454.2	454.11	454.15	2969.0
2023-07-19 07:55:00	SPY	ETF	454.17	454.25	454.16	454.21	2814.0
2023-07-19 08:00:00	SPY	ETF	454.26	454.71	454.02	454.34	33347.0
2023-07-19 08:05:00	SPY	ETF	454.32	454.39	454.27	454.3196	12307.0

> showing 50 of 100,974 rows — these rows as CSV

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