PREVIEW / etf_1min / 2023-09-12

all etf 1-min files

  file:    by_date/etf_1min/2023/2023-09-12.parquet
  size:    4.3 MB
  rows:    239,747

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-09-12 04:00:00	SPY	ETF	447.6	447.6	447.42	447.5	7525.0
2023-09-12 04:01:00	SPY	ETF	447.47	447.47	447.44	447.46	3800.0
2023-09-12 04:02:00	SPY	ETF	447.26	447.43	447.26	447.33	1832.0
2023-09-12 04:03:00	SPY	ETF	447.3	447.3	447.2	447.22	1995.0
2023-09-12 04:04:00	SPY	ETF	447.32	447.32	447.32	447.32	1106.0
2023-09-12 04:05:00	SPY	ETF	447.34	447.35	447.34	447.35	1100.0
2023-09-12 04:07:00	SPY	ETF	447.24	447.24	447.24	447.24	250.0
2023-09-12 04:08:00	SPY	ETF	447.34	447.34	447.34	447.34	200.0
2023-09-12 04:12:00	SPY	ETF	447.33	447.33	447.33	447.33	100.0
2023-09-12 04:15:00	SPY	ETF	447.42	447.42	447.42	447.42	170.0
2023-09-12 04:18:00	SPY	ETF	447.54	447.54	447.5	447.5	1350.0
2023-09-12 04:19:00	SPY	ETF	447.57	447.57	447.57	447.57	300.0
2023-09-12 04:20:00	SPY	ETF	447.56	447.56	447.56	447.56	300.0
2023-09-12 04:21:00	SPY	ETF	447.6	447.6	447.6	447.6	200.0
2023-09-12 04:22:00	SPY	ETF	447.58	447.58	447.58	447.58	1000.0
2023-09-12 04:25:00	SPY	ETF	447.69	447.69	447.69	447.69	1000.0
2023-09-12 04:27:00	SPY	ETF	447.76	447.76	447.69	447.69	1500.0
2023-09-12 04:28:00	SPY	ETF	447.68	447.68	447.6	447.6	450.0
2023-09-12 04:34:00	SPY	ETF	447.42	447.42	447.42	447.42	102.0
2023-09-12 04:40:00	SPY	ETF	447.38	447.38	447.38	447.38	500.0
2023-09-12 04:45:00	SPY	ETF	447.36	447.36	447.34	447.34	600.0
2023-09-12 04:46:00	SPY	ETF	447.29	447.29	447.29	447.29	400.0
2023-09-12 04:53:00	SPY	ETF	447.5	447.5	447.5	447.5	100.0
2023-09-12 04:58:00	SPY	ETF	447.39	447.39	447.39	447.39	100.0
2023-09-12 05:00:00	SPY	ETF	447.39	447.4	447.36	447.36	353.0
2023-09-12 05:01:00	SPY	ETF	447.42	447.42	447.42	447.42	149.0
2023-09-12 05:02:00	SPY	ETF	447.58	447.58	447.58	447.58	150.0
2023-09-12 05:11:00	SPY	ETF	447.41	447.41	447.41	447.41	200.0
2023-09-12 05:12:00	SPY	ETF	447.33	447.33	447.33	447.33	103.0
2023-09-12 05:22:00	SPY	ETF	447.33	447.33	447.33	447.33	100.0
2023-09-12 05:23:00	SPY	ETF	447.33	447.33	447.33	447.33	100.0
2023-09-12 05:29:00	SPY	ETF	447.47	447.47	447.47	447.47	125.0
2023-09-12 05:30:00	SPY	ETF	447.46	447.46	447.46	447.46	113.0
2023-09-12 05:33:00	SPY	ETF	447.2	447.2	447.19	447.2	3000.0
2023-09-12 05:34:00	SPY	ETF	447.15	447.22	447.15	447.22	850.0
2023-09-12 05:35:00	SPY	ETF	447.32	447.35	447.32	447.35	200.0
2023-09-12 05:39:00	SPY	ETF	447.36	447.36	447.36	447.36	100.0
2023-09-12 05:41:00	SPY	ETF	447.4	447.4	447.37	447.37	300.0
2023-09-12 05:44:00	SPY	ETF	447.45	447.45	447.45	447.45	100.0
2023-09-12 05:46:00	SPY	ETF	447.38	447.38	447.38	447.38	200.0
2023-09-12 05:49:00	SPY	ETF	447.55	447.61	447.55	447.61	224.0
2023-09-12 05:52:00	SPY	ETF	447.5	447.5	447.5	447.5	100.0
2023-09-12 05:53:00	SPY	ETF	447.51	447.51	447.51	447.51	205.0
2023-09-12 05:57:00	SPY	ETF	447.59	447.59	447.59	447.59	202.0
2023-09-12 05:58:00	SPY	ETF	447.61	447.63	447.61	447.63	200.0
2023-09-12 06:00:00	SPY	ETF	447.53	447.55	447.53	447.55	850.0
2023-09-12 06:01:00	SPY	ETF	447.6	447.6	447.6	447.6	500.0
2023-09-12 06:03:00	SPY	ETF	447.6	447.6	447.6	447.6	200.0
2023-09-12 06:04:00	SPY	ETF	447.61	447.61	447.61	447.61	175.0
2023-09-12 06:06:00	SPY	ETF	447.68	447.68	447.68	447.68	500.0

> showing 50 of 239,747 rows — these rows as CSV

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