PREVIEW / etf_5min / 2023-07-13

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-07-13.parquet
  size:    2.1 MB
  rows:    99,326

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-13 04:00:00	SPY	ETF	447.32	447.36	447.27	447.3	6907.0
2023-07-13 04:05:00	SPY	ETF	447.29	447.39	447.285	447.38	20543.0
2023-07-13 04:10:00	SPY	ETF	447.39	447.52	447.39	447.5	2419.0
2023-07-13 04:15:00	SPY	ETF	447.53	447.53	447.48	447.52	1566.0
2023-07-13 04:20:00	SPY	ETF	447.5	447.55	447.49	447.53	6532.0
2023-07-13 04:25:00	SPY	ETF	447.55	447.61	447.49	447.49	3115.0
2023-07-13 04:30:00	SPY	ETF	447.48	447.56	447.46	447.56	3899.0
2023-07-13 04:35:00	SPY	ETF	447.54	447.57	447.54	447.57	1200.0
2023-07-13 04:40:00	SPY	ETF	447.57	447.61	447.57	447.61	370.0
2023-07-13 04:45:00	SPY	ETF	447.58	447.66	447.57	447.57	600.0
2023-07-13 04:50:00	SPY	ETF	447.66	447.68	447.65	447.65	848.0
2023-07-13 04:55:00	SPY	ETF	447.7	447.7	447.58	447.58	813.0
2023-07-13 05:00:00	SPY	ETF	447.63	447.71	447.63	447.71	2624.0
2023-07-13 05:05:00	SPY	ETF	447.64	447.65	447.63	447.65	2939.0
2023-07-13 05:10:00	SPY	ETF	447.68	447.74	447.67	447.72	5849.0
2023-07-13 05:15:00	SPY	ETF	447.75	447.85	447.73	447.79	4355.0
2023-07-13 05:20:00	SPY	ETF	447.81	447.88	447.8	447.8	44803.0
2023-07-13 05:25:00	SPY	ETF	447.77	447.77	447.7	447.7	79100.0
2023-07-13 05:30:00	SPY	ETF	447.69	447.69	447.55	447.63	85179.0
2023-07-13 05:35:00	SPY	ETF	447.63	447.63	447.56	447.57	2227.0
2023-07-13 05:40:00	SPY	ETF	447.55	447.56	447.36	447.43	1217.0
2023-07-13 05:45:00	SPY	ETF	447.41	447.41	447.33	447.33	3726.0
2023-07-13 05:50:00	SPY	ETF	447.42	447.42	447.36	447.36	750.0
2023-07-13 05:55:00	SPY	ETF	447.4	447.4	447.4	447.4	100.0
2023-07-13 06:00:00	SPY	ETF	447.44	447.44	447.43	447.43	700.0
2023-07-13 06:05:00	SPY	ETF	447.4	447.41	447.29	447.29	3629.0
2023-07-13 06:10:00	SPY	ETF	447.22	447.33	447.16	447.33	2042.0
2023-07-13 06:15:00	SPY	ETF	447.36	447.42	447.36	447.41	1424.0
2023-07-13 06:20:00	SPY	ETF	447.43	447.51	447.42	447.42	2220.0
2023-07-13 06:25:00	SPY	ETF	447.41	447.41	447.39	447.39	801.0
2023-07-13 06:30:00	SPY	ETF	447.39	447.54	447.39	447.5	7097.0
2023-07-13 06:35:00	SPY	ETF	447.5	447.53	447.48	447.51	2859.0
2023-07-13 06:40:00	SPY	ETF	447.57	447.57	447.57	447.57	100.0
2023-07-13 06:45:00	SPY	ETF	447.62	447.62	447.54	447.54	1387.0
2023-07-13 06:50:00	SPY	ETF	447.57	447.62	447.57	447.62	408.0
2023-07-13 06:55:00	SPY	ETF	447.57	447.6	447.56	447.56	1641.0
2023-07-13 07:00:00	SPY	ETF	447.51	447.56	447.42	447.52	23421.0
2023-07-13 07:05:00	SPY	ETF	447.47	447.53	447.45	447.45	4085.0
2023-07-13 07:10:00	SPY	ETF	447.45	447.45	447.33	447.34	15067.0
2023-07-13 07:15:00	SPY	ETF	447.29	447.34	447.28	447.34	8425.0
2023-07-13 07:20:00	SPY	ETF	447.36	447.37	447.32	447.32	6068.0
2023-07-13 07:25:00	SPY	ETF	447.31	447.42	447.31	447.4	5777.0
2023-07-13 07:30:00	SPY	ETF	447.43	447.55	447.43	447.55	33003.0
2023-07-13 07:35:00	SPY	ETF	447.52	447.65	447.52	447.62	61961.0
2023-07-13 07:40:00	SPY	ETF	447.62	447.65	447.52	447.57	16704.0
2023-07-13 07:45:00	SPY	ETF	447.55	447.68	447.55	447.61	21588.0
2023-07-13 07:50:00	SPY	ETF	447.55	447.61	447.55	447.61	9502.0
2023-07-13 07:55:00	SPY	ETF	447.615	447.71	447.59	447.71	30636.0
2023-07-13 08:00:00	SPY	ETF	447.73	447.77	447.1404	447.73	66449.0
2023-07-13 08:05:00	SPY	ETF	447.74	447.74	447.63	447.67	6289.0

> showing 50 of 99,326 rows — these rows as CSV

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