PREVIEW / etf_5min / 2023-04-27

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-04-27.parquet
  size:    2.0 MB
  rows:    93,335

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-04-27 04:00:00	SPY	ETF	406.06	406.63	406.06	406.45	3452.0
2023-04-27 04:05:00	SPY	ETF	406.38	406.43	406.31	406.31	2017.0
2023-04-27 04:10:00	SPY	ETF	406.31	406.37	406.3	406.36	1761.0
2023-04-27 04:15:00	SPY	ETF	406.4	406.55	406.37	406.55	1300.0
2023-04-27 04:20:00	SPY	ETF	406.6	406.6	406.6	406.6	100.0
2023-04-27 04:25:00	SPY	ETF	406.57	406.57	406.51	406.51	1153.0
2023-04-27 04:30:00	SPY	ETF	406.6	406.63	406.59	406.63	1260.0
2023-04-27 04:35:00	SPY	ETF	406.65	406.7	406.6	406.6	1945.0
2023-04-27 04:40:00	SPY	ETF	406.5	406.5	406.5	406.5	500.0
2023-04-27 04:45:00	SPY	ETF	406.55	406.55	406.5	406.5	4545.0
2023-04-27 04:50:00	SPY	ETF	406.61	406.65	406.53	406.65	3210.0
2023-04-27 04:55:00	SPY	ETF	406.7	406.7	406.65	406.65	546.0
2023-04-27 05:00:00	SPY	ETF	406.63	406.63	406.63	406.63	100.0
2023-04-27 05:05:00	SPY	ETF	406.58	406.71	406.58	406.67	905.0
2023-04-27 05:10:00	SPY	ETF	406.64	406.64	406.61	406.61	345.0
2023-04-27 05:15:00	SPY	ETF	406.71	406.71	406.59	406.59	632.0
2023-04-27 05:20:00	SPY	ETF	406.52	406.52	406.45	406.45	1764.0
2023-04-27 05:25:00	SPY	ETF	406.57	406.57	406.57	406.57	100.0
2023-04-27 05:30:00	SPY	ETF	406.5	406.5	406.5	406.5	1300.0
2023-04-27 05:35:00	SPY	ETF	406.58	406.66	406.58	406.66	396.0
2023-04-27 05:40:00	SPY	ETF	406.71	406.72	406.66	406.72	2072.0
2023-04-27 05:45:00	SPY	ETF	406.63	406.63	406.6	406.62	5200.0
2023-04-27 05:50:00	SPY	ETF	406.69	406.69	406.6	406.6	3200.0
2023-04-27 05:55:00	SPY	ETF	406.6	406.6	406.45	406.45	4184.0
2023-04-27 06:00:00	SPY	ETF	406.56	406.56	406.46	406.46	4470.0
2023-04-27 06:05:00	SPY	ETF	406.48	406.48	406.38	406.4	2500.0
2023-04-27 06:10:00	SPY	ETF	406.35	406.47	406.35	406.45	2622.0
2023-04-27 06:15:00	SPY	ETF	406.42	406.42	406.4	406.4	400.0
2023-04-27 06:20:00	SPY	ETF	406.42	406.42	406.39	406.39	600.0
2023-04-27 06:25:00	SPY	ETF	406.43	406.43	406.42	406.43	2180.0
2023-04-27 06:30:00	SPY	ETF	406.52	406.55	406.52	406.54	3406.0
2023-04-27 06:35:00	SPY	ETF	406.64	406.69	406.6	406.69	9984.0
2023-04-27 06:40:00	SPY	ETF	406.59	406.6	406.5	406.6	6760.0
2023-04-27 06:45:00	SPY	ETF	406.54	406.7	406.54	406.7	1415.0
2023-04-27 06:50:00	SPY	ETF	406.72	406.75	406.71	406.72	4147.0
2023-04-27 06:55:00	SPY	ETF	406.81	406.82	406.8	406.8	2100.0
2023-04-27 07:00:00	SPY	ETF	406.83	406.94	406.4	406.82	71830.0
2023-04-27 07:05:00	SPY	ETF	406.81	407.11	406.75	407.1	23470.0
2023-04-27 07:10:00	SPY	ETF	407.1	407.11	406.85	406.91	26111.0
2023-04-27 07:15:00	SPY	ETF	406.82	406.94	406.81	406.9	15762.0
2023-04-27 07:20:00	SPY	ETF	406.9	406.9	406.8	406.85	7526.0
2023-04-27 07:25:00	SPY	ETF	406.85	406.94	406.78	406.93	12061.0
2023-04-27 07:30:00	SPY	ETF	406.95	407.03	406.9	406.93	11710.0
2023-04-27 07:35:00	SPY	ETF	406.89	406.89	406.71	406.77	37123.0
2023-04-27 07:40:00	SPY	ETF	406.78	406.87	406.73	406.73	6067.0
2023-04-27 07:45:00	SPY	ETF	406.68	406.77	406.65	406.77	25779.0
2023-04-27 07:50:00	SPY	ETF	406.77	406.88	406.77	406.83	12176.0
2023-04-27 07:55:00	SPY	ETF	406.76	406.91	406.72	406.91	6043.0
2023-04-27 08:00:00	SPY	ETF	406.88	407.3	405.73	407.3	60532.0
2023-04-27 08:05:00	SPY	ETF	407.25	407.3	407.13	407.16	33296.0

> showing 50 of 93,335 rows — these rows as CSV

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