PREVIEW / etf_5min / 2023-07-11

all etf 5-min files

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

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-11 04:00:00	SPY	ETF	439.68	439.72	439.49	439.56	4133.0
2023-07-11 04:05:00	SPY	ETF	439.66	439.86	439.66	439.86	1401.0
2023-07-11 04:10:00	SPY	ETF	439.87	439.87	439.74	439.77	2376.0
2023-07-11 04:15:00	SPY	ETF	439.64	439.64	439.64	439.64	100.0
2023-07-11 04:20:00	SPY	ETF	439.59	439.65	439.59	439.65	500.0
2023-07-11 04:25:00	SPY	ETF	439.7	439.7	439.56	439.63	1527.0
2023-07-11 04:30:00	SPY	ETF	439.56	439.6	439.5	439.6	3488.0
2023-07-11 04:35:00	SPY	ETF	439.59	439.59	439.34	439.34	2559.0
2023-07-11 04:40:00	SPY	ETF	439.37	439.37	439.22	439.24	4699.0
2023-07-11 04:45:00	SPY	ETF	439.24	439.24	439.14	439.2	2385.0
2023-07-11 04:50:00	SPY	ETF	439.3	439.3	439.13	439.21	2300.0
2023-07-11 04:55:00	SPY	ETF	439.29	439.47	439.29	439.44	2680.0
2023-07-11 05:00:00	SPY	ETF	439.42	439.42	439.38	439.38	500.0
2023-07-11 05:05:00	SPY	ETF	439.47	439.47	439.46	439.46	900.0
2023-07-11 05:10:00	SPY	ETF	439.46	439.61	439.45	439.61	400.0
2023-07-11 05:15:00	SPY	ETF	439.5	439.5	439.5	439.5	100.0
2023-07-11 05:20:00	SPY	ETF	439.4	439.63	439.4	439.63	4800.0
2023-07-11 05:25:00	SPY	ETF	439.59	439.76	439.59	439.76	2919.0
2023-07-11 05:30:00	SPY	ETF	439.78	439.82	439.77	439.82	1720.0
2023-07-11 05:35:00	SPY	ETF	439.83	439.85	439.81	439.85	1534.0
2023-07-11 05:40:00	SPY	ETF	439.89	439.89	439.89	439.89	100.0
2023-07-11 05:45:00	SPY	ETF	439.86	440.08	439.86	440.05	3238.0
2023-07-11 05:50:00	SPY	ETF	440.1	440.23	440.1	440.18	6000.0
2023-07-11 05:55:00	SPY	ETF	440.24	440.27	440.19	440.24	4800.0
2023-07-11 06:00:00	SPY	ETF	440.21	440.29	440.21	440.29	6797.0
2023-07-11 06:05:00	SPY	ETF	440.25	440.3	440.1	440.1	2832.0
2023-07-11 06:10:00	SPY	ETF	440.1	440.21	440.1	440.21	580.0
2023-07-11 06:15:00	SPY	ETF	440.18	440.18	439.93	439.99	3140.0
2023-07-11 06:20:00	SPY	ETF	440.05	440.06	440.04	440.06	3027.0
2023-07-11 06:25:00	SPY	ETF	440.09	440.12	440.09	440.11	5375.0
2023-07-11 06:30:00	SPY	ETF	440.04	440.06	440.02	440.06	468.0
2023-07-11 06:35:00	SPY	ETF	440.1	440.1	440.1	440.1	500.0
2023-07-11 06:40:00	SPY	ETF	440.12	440.12	440.12	440.12	300.0
2023-07-11 06:45:00	SPY	ETF	440.06	440.06	440.05	440.05	1845.0
2023-07-11 06:50:00	SPY	ETF	440.05	440.07	440.0	440.07	2000.0
2023-07-11 06:55:00	SPY	ETF	440.08	440.08	440.01	440.01	400.0
2023-07-11 07:00:00	SPY	ETF	439.96	440.1	439.93	440.07	14255.0
2023-07-11 07:05:00	SPY	ETF	440.1	440.16	440.1	440.13	1347.0
2023-07-11 07:10:00	SPY	ETF	440.14	440.27	440.12	440.23	11591.0
2023-07-11 07:15:00	SPY	ETF	440.23	440.26	440.2	440.26	2440.0
2023-07-11 07:20:00	SPY	ETF	440.26	440.38	440.25	440.38	9472.0
2023-07-11 07:25:00	SPY	ETF	440.37	440.43	440.35	440.43	12773.0
2023-07-11 07:30:00	SPY	ETF	440.42	440.56	440.42	440.53	18946.0
2023-07-11 07:35:00	SPY	ETF	440.53	440.57	440.42	440.444	9400.0
2023-07-11 07:40:00	SPY	ETF	440.48	440.48	440.25	440.36	11173.0
2023-07-11 07:45:00	SPY	ETF	440.34	440.37	440.3	440.37	2460.0
2023-07-11 07:50:00	SPY	ETF	440.34	440.47	440.34	440.47	5061.0
2023-07-11 07:55:00	SPY	ETF	440.49	440.55	440.41	440.55	9757.0
2023-07-11 08:00:00	SPY	ETF	440.07	440.73	439.83	440.64	50991.0
2023-07-11 08:05:00	SPY	ETF	440.64	440.71	440.45	440.45	7039.0

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

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