PREVIEW / etf_5min / 2023-06-07

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-06-07.parquet
  size:    2.0 MB
  rows:    98,906

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-06-07 04:00:00	SPY	ETF	427.71	427.71	427.46	427.56	5859.0
2023-06-07 04:05:00	SPY	ETF	427.58	427.58	427.44	427.5	2449.0
2023-06-07 04:10:00	SPY	ETF	427.46	427.61	427.4	427.61	4499.0
2023-06-07 04:15:00	SPY	ETF	427.66	427.66	427.56	427.57	2500.0
2023-06-07 04:20:00	SPY	ETF	427.66	427.69	427.58	427.58	2531.0
2023-06-07 04:25:00	SPY	ETF	427.51	427.54	427.51	427.52	630.0
2023-06-07 04:30:00	SPY	ETF	427.62	427.63	427.58	427.62	1575.0
2023-06-07 04:35:00	SPY	ETF	427.55	427.64	427.53	427.64	1200.0
2023-06-07 04:40:00	SPY	ETF	427.59	427.75	427.59	427.71	960.0
2023-06-07 04:45:00	SPY	ETF	427.63	427.69	427.63	427.69	800.0
2023-06-07 04:50:00	SPY	ETF	427.72	427.72	427.69	427.69	800.0
2023-06-07 05:00:00	SPY	ETF	427.72	427.72	427.72	427.72	100.0
2023-06-07 05:05:00	SPY	ETF	427.7	427.7	427.56	427.56	400.0
2023-06-07 05:10:00	SPY	ETF	427.7	427.74	427.62	427.74	834.0
2023-06-07 05:20:00	SPY	ETF	427.83	427.83	427.83	427.83	826.0
2023-06-07 05:25:00	SPY	ETF	427.85	427.86	427.79	427.84	2093.0
2023-06-07 05:30:00	SPY	ETF	427.9	427.91	427.86	427.86	1024.0
2023-06-07 05:40:00	SPY	ETF	427.8	427.8	427.74	427.79	2100.0
2023-06-07 05:45:00	SPY	ETF	427.81	427.81	427.78	427.78	664.0
2023-06-07 05:50:00	SPY	ETF	427.75	427.76	427.7	427.76	700.0
2023-06-07 06:00:00	SPY	ETF	427.81	427.88	427.81	427.85	3622.0
2023-06-07 06:05:00	SPY	ETF	427.84	427.99	427.84	427.98	400.0
2023-06-07 06:10:00	SPY	ETF	427.91	427.91	427.86	427.87	1974.0
2023-06-07 06:15:00	SPY	ETF	427.93	428.02	427.93	428.02	1025.0
2023-06-07 06:20:00	SPY	ETF	428.15	428.19	428.1	428.16	1322.0
2023-06-07 06:25:00	SPY	ETF	428.15	428.18	428.15	428.18	300.0
2023-06-07 06:35:00	SPY	ETF	428.1	428.22	428.1	428.22	785.0
2023-06-07 06:40:00	SPY	ETF	428.25	428.25	428.25	428.25	117.0
2023-06-07 06:45:00	SPY	ETF	428.27	428.27	428.27	428.27	134.0
2023-06-07 06:50:00	SPY	ETF	428.23	428.35	428.23	428.35	995.0
2023-06-07 06:55:00	SPY	ETF	428.38	428.38	428.35	428.35	1092.0
2023-06-07 07:00:00	SPY	ETF	428.32	428.38	428.3	428.31	9402.0
2023-06-07 07:05:00	SPY	ETF	428.36	428.42	428.33	428.42	5804.0
2023-06-07 07:10:00	SPY	ETF	428.43	428.46	428.32	428.32	12113.0
2023-06-07 07:15:00	SPY	ETF	428.32	428.32	428.28	428.29	3559.0
2023-06-07 07:20:00	SPY	ETF	428.28	428.29	428.25	428.29	7456.0
2023-06-07 07:25:00	SPY	ETF	428.29	428.3	428.27	428.27	13866.0
2023-06-07 07:30:00	SPY	ETF	428.26	428.36	428.26	428.36	1193.0
2023-06-07 07:35:00	SPY	ETF	428.36	428.57	428.34	428.57	6813.0
2023-06-07 07:40:00	SPY	ETF	428.54	428.61	428.5	428.56	37876.0
2023-06-07 07:45:00	SPY	ETF	428.55	428.8	428.52	428.76	6805.0
2023-06-07 07:50:00	SPY	ETF	428.721	428.77	428.7	428.73	4650.0
2023-06-07 07:55:00	SPY	ETF	428.73	428.83	428.72	428.83	7083.0
2023-06-07 08:00:00	SPY	ETF	428.3499	428.81	427.5604	428.79	41849.0
2023-06-07 08:05:00	SPY	ETF	428.83	428.83	428.5	428.68	66081.0
2023-06-07 08:10:00	SPY	ETF	428.65	428.65	428.6	428.6	16900.0
2023-06-07 08:15:00	SPY	ETF	428.58	428.8	427.95	428.71	92024.0
2023-06-07 08:20:00	SPY	ETF	427.76	428.78	427.76	428.71	34693.0
2023-06-07 08:25:00	SPY	ETF	428.75	428.77	428.5	428.51	13571.0
2023-06-07 08:30:00	SPY	ETF	428.51	428.57	428.38	428.57	23464.0

> showing 50 of 98,906 rows — these rows as CSV

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