PREVIEW / etf_5min / 2023-07-07

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-07-07.parquet
  size:    2.0 MB
  rows:    96,293

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-07 04:00:00	SPY	ETF	439.02	439.02	438.7	438.71	6592.0
2023-07-07 04:05:00	SPY	ETF	438.81	438.85	438.7	438.7	4089.0
2023-07-07 04:10:00	SPY	ETF	438.69	438.85	438.69	438.85	844.0
2023-07-07 04:15:00	SPY	ETF	438.99	439.09	438.98	439.09	3348.0
2023-07-07 04:20:00	SPY	ETF	439.08	439.08	438.98	438.98	994.0
2023-07-07 04:25:00	SPY	ETF	439.14	439.14	439.12	439.12	300.0
2023-07-07 04:30:00	SPY	ETF	439.12	439.12	439.08	439.08	853.0
2023-07-07 04:35:00	SPY	ETF	438.92	438.97	438.92	438.97	300.0
2023-07-07 04:40:00	SPY	ETF	439.09	439.11	439.05	439.07	1812.0
2023-07-07 04:45:00	SPY	ETF	439.2	439.25	439.2	439.25	2553.0
2023-07-07 04:50:00	SPY	ETF	439.28	439.28	439.28	439.28	2000.0
2023-07-07 04:55:00	SPY	ETF	439.25	439.26	439.2	439.25	2700.0
2023-07-07 05:00:00	SPY	ETF	439.24	439.41	439.24	439.41	630.0
2023-07-07 05:05:00	SPY	ETF	439.42	439.53	439.42	439.53	3600.0
2023-07-07 05:10:00	SPY	ETF	439.54	439.69	439.54	439.69	2163.0
2023-07-07 05:15:00	SPY	ETF	439.67	439.73	439.66	439.73	643.0
2023-07-07 05:20:00	SPY	ETF	439.66	439.66	439.55	439.56	2206.0
2023-07-07 05:25:00	SPY	ETF	439.56	439.56	439.52	439.55	468.0
2023-07-07 05:30:00	SPY	ETF	439.56	439.56	439.4	439.45	1000.0
2023-07-07 05:35:00	SPY	ETF	439.51	439.51	439.49	439.49	400.0
2023-07-07 05:40:00	SPY	ETF	439.6	439.6	439.6	439.6	400.0
2023-07-07 05:45:00	SPY	ETF	439.52	439.52	439.52	439.52	259.0
2023-07-07 05:50:00	SPY	ETF	439.5	439.5	439.5	439.5	300.0
2023-07-07 05:55:00	SPY	ETF	439.51	439.56	439.51	439.56	259.0
2023-07-07 06:00:00	SPY	ETF	439.4	439.4	439.28	439.28	470.0
2023-07-07 06:05:00	SPY	ETF	439.17	439.39	439.17	439.39	2906.0
2023-07-07 06:10:00	SPY	ETF	439.35	439.35	439.31	439.31	403.0
2023-07-07 06:20:00	SPY	ETF	439.43	439.43	439.4	439.4	600.0
2023-07-07 06:25:00	SPY	ETF	439.5	439.5	439.47	439.47	400.0
2023-07-07 06:30:00	SPY	ETF	439.5	439.5	439.49	439.49	600.0
2023-07-07 06:35:00	SPY	ETF	439.5	439.5	439.5	439.5	500.0
2023-07-07 06:40:00	SPY	ETF	439.46	439.46	439.41	439.41	1019.0
2023-07-07 06:45:00	SPY	ETF	439.51	439.51	439.51	439.51	400.0
2023-07-07 06:50:00	SPY	ETF	439.44	439.5	439.43	439.45	1184.0
2023-07-07 06:55:00	SPY	ETF	439.46	439.46	439.46	439.46	100.0
2023-07-07 07:00:00	SPY	ETF	439.55	439.59	439.54	439.54	2914.0
2023-07-07 07:05:00	SPY	ETF	439.6	439.64	439.6	439.62	1900.0
2023-07-07 07:10:00	SPY	ETF	439.64	439.67	439.61	439.639	2021.0
2023-07-07 07:15:00	SPY	ETF	439.57	439.61	439.5	439.51	6993.0
2023-07-07 07:20:00	SPY	ETF	439.49	439.52	439.46	439.47	3050.0
2023-07-07 07:25:00	SPY	ETF	439.49	439.49	439.39	439.45	2600.0
2023-07-07 07:30:00	SPY	ETF	439.42	439.54	439.4	439.54	3400.0
2023-07-07 07:35:00	SPY	ETF	439.54	439.54	439.44	439.47	2256.0
2023-07-07 07:40:00	SPY	ETF	439.45	439.48	439.45	439.48	1943.0
2023-07-07 07:45:00	SPY	ETF	439.44	439.6	439.44	439.6	11423.0
2023-07-07 07:50:00	SPY	ETF	439.58	439.61	439.55	439.61	4079.0
2023-07-07 07:55:00	SPY	ETF	439.61	439.61	439.33	439.33	14543.0
2023-07-07 08:00:00	SPY	ETF	439.6	439.63	438.77	439.3	118635.0
2023-07-07 08:05:00	SPY	ETF	439.4	439.48	439.38	439.44	17390.0
2023-07-07 08:10:00	SPY	ETF	439.435	439.44	439.28	439.28	20058.0

> showing 50 of 96,293 rows — these rows as CSV

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