PREVIEW / etf_5min / 2023-09-12

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-09-12.parquet
  size:    1.9 MB
  rows:    91,832

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-09-12 04:00:00	SPY	ETF	447.6	447.6	447.2	447.32	16258.0
2023-09-12 04:05:00	SPY	ETF	447.34	447.35	447.24	447.34	1550.0
2023-09-12 04:10:00	SPY	ETF	447.33	447.33	447.33	447.33	100.0
2023-09-12 04:15:00	SPY	ETF	447.42	447.57	447.42	447.57	1820.0
2023-09-12 04:20:00	SPY	ETF	447.56	447.6	447.56	447.58	1500.0
2023-09-12 04:25:00	SPY	ETF	447.69	447.76	447.6	447.6	2950.0
2023-09-12 04:30:00	SPY	ETF	447.42	447.42	447.42	447.42	102.0
2023-09-12 04:40:00	SPY	ETF	447.38	447.38	447.38	447.38	500.0
2023-09-12 04:45:00	SPY	ETF	447.36	447.36	447.29	447.29	1000.0
2023-09-12 04:50:00	SPY	ETF	447.5	447.5	447.5	447.5	100.0
2023-09-12 04:55:00	SPY	ETF	447.39	447.39	447.39	447.39	100.0
2023-09-12 05:00:00	SPY	ETF	447.39	447.58	447.36	447.58	652.0
2023-09-12 05:10:00	SPY	ETF	447.41	447.41	447.33	447.33	303.0
2023-09-12 05:20:00	SPY	ETF	447.33	447.33	447.33	447.33	200.0
2023-09-12 05:25:00	SPY	ETF	447.47	447.47	447.47	447.47	125.0
2023-09-12 05:30:00	SPY	ETF	447.46	447.46	447.15	447.22	3963.0
2023-09-12 05:35:00	SPY	ETF	447.32	447.36	447.32	447.36	300.0
2023-09-12 05:40:00	SPY	ETF	447.4	447.45	447.37	447.45	400.0
2023-09-12 05:45:00	SPY	ETF	447.38	447.61	447.38	447.61	424.0
2023-09-12 05:50:00	SPY	ETF	447.5	447.51	447.5	447.51	305.0
2023-09-12 05:55:00	SPY	ETF	447.59	447.63	447.59	447.63	402.0
2023-09-12 06:00:00	SPY	ETF	447.53	447.61	447.53	447.61	1725.0
2023-09-12 06:05:00	SPY	ETF	447.68	447.68	447.68	447.68	500.0
2023-09-12 06:10:00	SPY	ETF	447.53	447.53	447.53	447.53	232.0
2023-09-12 06:20:00	SPY	ETF	447.56	447.56	447.49	447.49	449.0
2023-09-12 06:30:00	SPY	ETF	447.61	447.83	447.61	447.76	2650.0
2023-09-12 06:35:00	SPY	ETF	447.68	447.68	447.68	447.68	100.0
2023-09-12 06:40:00	SPY	ETF	447.56	447.63	447.53	447.63	575.0
2023-09-12 06:45:00	SPY	ETF	447.51	447.51	447.42	447.44	4050.0
2023-09-12 06:50:00	SPY	ETF	447.53	447.58	447.53	447.58	2500.0
2023-09-12 06:55:00	SPY	ETF	447.59	447.72	447.59	447.7	2325.0
2023-09-12 07:00:00	SPY	ETF	447.72	447.74	447.5	447.64	5668.0
2023-09-12 07:05:00	SPY	ETF	447.7	447.72	447.7	447.72	4550.0
2023-09-12 07:10:00	SPY	ETF	447.74	447.74	447.65	447.709	761.0
2023-09-12 07:15:00	SPY	ETF	447.66	447.67	447.5	447.5	44446.0
2023-09-12 07:20:00	SPY	ETF	447.5	447.5	447.18	447.18	32818.0
2023-09-12 07:25:00	SPY	ETF	447.18	447.41	447.15	447.39	27649.0
2023-09-12 07:30:00	SPY	ETF	447.34	447.34	447.26	447.31	13549.0
2023-09-12 07:35:00	SPY	ETF	447.28	447.35	447.24	447.29	3650.0
2023-09-12 07:40:00	SPY	ETF	447.41	447.41	447.35	447.38	400.0
2023-09-12 07:45:00	SPY	ETF	447.3	447.3	447.14	447.219	15188.0
2023-09-12 07:50:00	SPY	ETF	447.15	447.17	447.07	447.07	8262.0
2023-09-12 07:55:00	SPY	ETF	447.15	447.18	447.09	447.14	8700.0
2023-09-12 08:00:00	SPY	ETF	447.7203	448.22	447.05	447.18	27995.0
2023-09-12 08:05:00	SPY	ETF	447.17	447.3	447.15	447.21	16400.0
2023-09-12 08:10:00	SPY	ETF	447.22	447.34	447.21	447.25	3024.0
2023-09-12 08:15:00	SPY	ETF	447.29	447.4	447.27	447.32	17424.0
2023-09-12 08:20:00	SPY	ETF	447.33	447.42	447.33	447.37	8527.0
2023-09-12 08:25:00	SPY	ETF	447.45	447.55	447.41	447.53	11039.0
2023-09-12 08:30:00	SPY	ETF	447.48	447.63	447.37	447.61	21960.0

> showing 50 of 91,832 rows — these rows as CSV

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