PREVIEW / etf_5min / 2023-08-01

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-08-01.parquet
  size:    2.1 MB
  rows:    101,068

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-08-01 04:00:00	SPY	ETF	457.3	457.3	457.15	457.18	12904.0
2023-08-01 04:05:00	SPY	ETF	457.16	457.17	456.97	457.01	4239.0
2023-08-01 04:10:00	SPY	ETF	456.95	457.04	456.95	456.98	7189.0
2023-08-01 04:15:00	SPY	ETF	456.95	456.95	456.85	456.85	6656.0
2023-08-01 04:20:00	SPY	ETF	456.9	456.91	456.71	456.71	3574.0
2023-08-01 04:25:00	SPY	ETF	456.75	456.75	456.72	456.72	352.0
2023-08-01 04:30:00	SPY	ETF	456.65	456.65	456.44	456.44	2200.0
2023-08-01 04:35:00	SPY	ETF	456.7	456.75	456.7	456.75	1650.0
2023-08-01 04:40:00	SPY	ETF	456.69	456.69	456.6	456.6	448.0
2023-08-01 04:45:00	SPY	ETF	456.61	456.61	456.31	456.31	507.0
2023-08-01 04:50:00	SPY	ETF	456.6	456.6	456.6	456.6	215.0
2023-08-01 04:55:00	SPY	ETF	456.78	456.78	456.78	456.78	100.0
2023-08-01 05:00:00	SPY	ETF	456.63	456.66	456.6	456.6	700.0
2023-08-01 05:05:00	SPY	ETF	456.61	456.64	456.54	456.56	1724.0
2023-08-01 05:10:00	SPY	ETF	456.63	456.63	456.5	456.5	3584.0
2023-08-01 05:15:00	SPY	ETF	456.39	456.5	456.39	456.44	1202.0
2023-08-01 05:20:00	SPY	ETF	456.41	456.45	456.35	456.35	2420.0
2023-08-01 05:25:00	SPY	ETF	456.34	456.38	456.3	456.38	614.0
2023-08-01 05:30:00	SPY	ETF	456.28	456.39	456.22	456.22	2400.0
2023-08-01 05:35:00	SPY	ETF	456.32	456.35	456.32	456.32	505.0
2023-08-01 05:40:00	SPY	ETF	456.34	456.34	456.27	456.27	1240.0
2023-08-01 05:45:00	SPY	ETF	456.35	456.35	456.26	456.26	1000.0
2023-08-01 05:50:00	SPY	ETF	456.32	456.32	456.32	456.32	225.0
2023-08-01 05:55:00	SPY	ETF	456.27	456.59	456.25	456.59	4795.0
2023-08-01 06:00:00	SPY	ETF	456.58	456.61	456.54	456.6	1700.0
2023-08-01 06:05:00	SPY	ETF	456.58	456.6	456.58	456.6	1400.0
2023-08-01 06:10:00	SPY	ETF	456.6	456.63	456.6	456.61	3600.0
2023-08-01 06:20:00	SPY	ETF	456.68	456.69	456.68	456.69	1150.0
2023-08-01 06:25:00	SPY	ETF	456.7	456.84	456.65	456.84	11967.0
2023-08-01 06:30:00	SPY	ETF	456.67	456.84	456.67	456.73	42420.0
2023-08-01 06:35:00	SPY	ETF	456.83	456.85	456.81	456.85	543.0
2023-08-01 06:40:00	SPY	ETF	456.78	456.85	456.78	456.85	495.0
2023-08-01 06:45:00	SPY	ETF	456.82	456.85	456.81	456.81	1949.0
2023-08-01 06:50:00	SPY	ETF	457.0	457.01	457.0	457.01	459.0
2023-08-01 06:55:00	SPY	ETF	457.1	457.14	457.07	457.1	3100.0
2023-08-01 07:00:00	SPY	ETF	457.1	457.19	457.1	457.14	15105.0
2023-08-01 07:05:00	SPY	ETF	457.15	457.16	457.01	457.07	26084.0
2023-08-01 07:10:00	SPY	ETF	457.07	457.15	457.0	457.0	3924.0
2023-08-01 07:15:00	SPY	ETF	456.96	456.96	456.88	456.94	3730.0
2023-08-01 07:20:00	SPY	ETF	456.85	456.89	456.78	456.78	4171.0
2023-08-01 07:25:00	SPY	ETF	456.77	456.78	456.69	456.69	8971.0
2023-08-01 07:30:00	SPY	ETF	456.61	456.62	456.43	456.5	4636.0
2023-08-01 07:35:00	SPY	ETF	456.5	456.51	456.44	456.49	8176.0
2023-08-01 07:40:00	SPY	ETF	456.49	456.49	456.26	456.31	10389.0
2023-08-01 07:45:00	SPY	ETF	456.39	456.7	456.39	456.5	90777.0
2023-08-01 07:50:00	SPY	ETF	456.51	456.54	456.39	456.43	121290.0
2023-08-01 07:55:00	SPY	ETF	456.34	456.35	456.31	456.35	17618.0
2023-08-01 08:00:00	SPY	ETF	457.18	458.15	456.29	456.43	50707.0
2023-08-01 08:05:00	SPY	ETF	456.44	456.49	456.22	456.23	26276.0
2023-08-01 08:10:00	SPY	ETF	456.27	456.35	456.2	456.25	16367.0

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

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