PREVIEW / etf_1min / 2023-07-14

all etf 1-min files

  file:    by_date/etf_1min/2023/2023-07-14.parquet
  size:    4.6 MB
  rows:    259,917

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-14 04:00:00	SPY	ETF	449.51	449.51	449.44	449.48	1984.0
2023-07-14 04:01:00	SPY	ETF	449.54	449.54	449.54	449.54	2156.0
2023-07-14 04:03:00	SPY	ETF	449.47	449.5	449.47	449.47	933.0
2023-07-14 04:04:00	SPY	ETF	449.47	449.47	449.41	449.43	1038.0
2023-07-14 04:05:00	SPY	ETF	449.46	449.46	449.46	449.46	126.0
2023-07-14 04:06:00	SPY	ETF	449.48	449.48	449.46	449.46	816.0
2023-07-14 04:07:00	SPY	ETF	449.48	449.53	449.48	449.53	600.0
2023-07-14 04:08:00	SPY	ETF	449.58	449.58	449.58	449.58	219.0
2023-07-14 04:09:00	SPY	ETF	449.53	449.53	449.53	449.53	141.0
2023-07-14 04:10:00	SPY	ETF	449.58	449.61	449.58	449.61	557.0
2023-07-14 04:12:00	SPY	ETF	449.58	449.58	449.58	449.58	127.0
2023-07-14 04:13:00	SPY	ETF	449.48	449.5	449.48	449.5	900.0
2023-07-14 04:17:00	SPY	ETF	449.49	449.5	449.49	449.5	600.0
2023-07-14 04:18:00	SPY	ETF	449.48	449.48	449.48	449.48	214.0
2023-07-14 04:19:00	SPY	ETF	449.51	449.51	449.51	449.51	100.0
2023-07-14 04:20:00	SPY	ETF	449.5	449.5	449.5	449.5	210.0
2023-07-14 04:22:00	SPY	ETF	449.48	449.48	449.48	449.48	551.0
2023-07-14 04:27:00	SPY	ETF	449.42	449.43	449.42	449.43	800.0
2023-07-14 04:28:00	SPY	ETF	449.4	449.4	449.4	449.4	100.0
2023-07-14 04:29:00	SPY	ETF	449.44	449.44	449.44	449.44	100.0
2023-07-14 04:30:00	SPY	ETF	449.48	449.55	449.47	449.55	2000.0
2023-07-14 04:32:00	SPY	ETF	449.5	449.5	449.5	449.5	180.0
2023-07-14 04:33:00	SPY	ETF	449.52	449.52	449.52	449.52	384.0
2023-07-14 04:34:00	SPY	ETF	449.51	449.51	449.51	449.51	100.0
2023-07-14 04:36:00	SPY	ETF	449.46	449.53	449.46	449.53	1825.0
2023-07-14 04:38:00	SPY	ETF	449.59	449.59	449.59	449.59	285.0
2023-07-14 04:40:00	SPY	ETF	449.61	449.61	449.61	449.61	400.0
2023-07-14 04:41:00	SPY	ETF	449.59	449.61	449.57	449.61	900.0
2023-07-14 04:43:00	SPY	ETF	449.62	449.62	449.62	449.62	400.0
2023-07-14 04:45:00	SPY	ETF	449.63	449.63	449.63	449.63	100.0
2023-07-14 04:47:00	SPY	ETF	449.59	449.59	449.51	449.51	1600.0
2023-07-14 04:48:00	SPY	ETF	449.56	449.56	449.52	449.52	370.0
2023-07-14 04:49:00	SPY	ETF	449.52	449.52	449.52	449.52	300.0
2023-07-14 04:50:00	SPY	ETF	449.51	449.51	449.51	449.51	174.0
2023-07-14 04:51:00	SPY	ETF	449.5	449.5	449.5	449.5	300.0
2023-07-14 04:52:00	SPY	ETF	449.52	449.52	449.52	449.52	100.0
2023-07-14 04:59:00	SPY	ETF	449.36	449.36	449.36	449.36	184.0
2023-07-14 05:00:00	SPY	ETF	449.39	449.39	449.38	449.39	1107.0
2023-07-14 05:02:00	SPY	ETF	449.31	449.31	449.31	449.31	400.0
2023-07-14 05:04:00	SPY	ETF	449.35	449.35	449.35	449.35	150.0
2023-07-14 05:05:00	SPY	ETF	449.35	449.35	449.35	449.35	148.0
2023-07-14 05:06:00	SPY	ETF	449.35	449.35	449.35	449.35	100.0
2023-07-14 05:09:00	SPY	ETF	449.36	449.36	449.36	449.36	200.0
2023-07-14 05:10:00	SPY	ETF	449.45	449.45	449.44	449.44	443.0
2023-07-14 05:12:00	SPY	ETF	449.41	449.41	449.41	449.41	104.0
2023-07-14 05:22:00	SPY	ETF	449.43	449.43	449.43	449.43	240.0
2023-07-14 05:24:00	SPY	ETF	449.39	449.39	449.39	449.39	100.0
2023-07-14 05:25:00	SPY	ETF	449.43	449.43	449.43	449.43	104.0
2023-07-14 05:28:00	SPY	ETF	449.42	449.42	449.42	449.42	100.0
2023-07-14 05:29:00	SPY	ETF	449.44	449.44	449.44	449.44	100.0

> showing 50 of 259,917 rows — these rows as CSV

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