PREVIEW / etf_1min / 2023-07-13

all etf 1-min files

  file:    by_date/etf_1min/2023/2023-07-13.parquet
  size:    4.7 MB
  rows:    264,100

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.32	447.34	1500.0
2023-07-13 04:02:00	SPY	ETF	447.33	447.33	447.33	447.33	110.0
2023-07-13 04:03:00	SPY	ETF	447.32	447.33	447.27	447.32	1030.0
2023-07-13 04:04:00	SPY	ETF	447.3	447.31	447.29	447.3	4267.0
2023-07-13 04:05:00	SPY	ETF	447.29	447.31	447.285	447.29	16853.0
2023-07-13 04:06:00	SPY	ETF	447.31	447.36	447.31	447.36	867.0
2023-07-13 04:07:00	SPY	ETF	447.31	447.34	447.31	447.34	1247.0
2023-07-13 04:08:00	SPY	ETF	447.33	447.33	447.3	447.31	1149.0
2023-07-13 04:09:00	SPY	ETF	447.32	447.39	447.32	447.38	427.0
2023-07-13 04:10:00	SPY	ETF	447.39	447.39	447.39	447.39	107.0
2023-07-13 04:11:00	SPY	ETF	447.41	447.41	447.41	447.41	129.0
2023-07-13 04:12:00	SPY	ETF	447.46	447.5	447.46	447.5	600.0
2023-07-13 04:13:00	SPY	ETF	447.5	447.5	447.5	447.5	1323.0
2023-07-13 04:14:00	SPY	ETF	447.52	447.52	447.5	447.5	260.0
2023-07-13 04:15:00	SPY	ETF	447.53	447.53	447.53	447.53	106.0
2023-07-13 04:16:00	SPY	ETF	447.52	447.52	447.52	447.52	103.0
2023-07-13 04:17:00	SPY	ETF	447.49	447.52	447.48	447.52	1357.0
2023-07-13 04:20:00	SPY	ETF	447.5	447.5	447.49	447.49	825.0
2023-07-13 04:21:00	SPY	ETF	447.54	447.55	447.54	447.55	583.0
2023-07-13 04:22:00	SPY	ETF	447.54	447.54	447.5	447.5	1215.0
2023-07-13 04:23:00	SPY	ETF	447.52	447.53	447.52	447.53	3809.0
2023-07-13 04:24:00	SPY	ETF	447.53	447.53	447.53	447.53	100.0
2023-07-13 04:26:00	SPY	ETF	447.55	447.55	447.55	447.55	500.0
2023-07-13 04:27:00	SPY	ETF	447.59	447.61	447.59	447.61	381.0
2023-07-13 04:28:00	SPY	ETF	447.6	447.6	447.6	447.6	100.0
2023-07-13 04:29:00	SPY	ETF	447.52	447.53	447.49	447.49	2134.0
2023-07-13 04:30:00	SPY	ETF	447.48	447.48	447.48	447.48	1300.0
2023-07-13 04:31:00	SPY	ETF	447.46	447.46	447.46	447.46	1499.0
2023-07-13 04:32:00	SPY	ETF	447.46	447.46	447.46	447.46	600.0
2023-07-13 04:33:00	SPY	ETF	447.54	447.56	447.54	447.56	500.0
2023-07-13 04:37:00	SPY	ETF	447.54	447.55	447.54	447.55	700.0
2023-07-13 04:39:00	SPY	ETF	447.57	447.57	447.57	447.57	500.0
2023-07-13 04:40:00	SPY	ETF	447.57	447.57	447.57	447.57	270.0
2023-07-13 04:43:00	SPY	ETF	447.61	447.61	447.61	447.61	100.0
2023-07-13 04:45:00	SPY	ETF	447.58	447.66	447.58	447.66	400.0
2023-07-13 04:46:00	SPY	ETF	447.6	447.6	447.6	447.6	100.0
2023-07-13 04:47:00	SPY	ETF	447.57	447.57	447.57	447.57	100.0
2023-07-13 04:50:00	SPY	ETF	447.66	447.66	447.66	447.66	192.0
2023-07-13 04:51:00	SPY	ETF	447.68	447.68	447.68	447.68	267.0
2023-07-13 04:52:00	SPY	ETF	447.65	447.65	447.65	447.65	389.0
2023-07-13 04:55:00	SPY	ETF	447.7	447.7	447.7	447.7	113.0
2023-07-13 04:56:00	SPY	ETF	447.68	447.68	447.68	447.68	100.0
2023-07-13 04:57:00	SPY	ETF	447.6	447.6	447.58	447.58	600.0
2023-07-13 05:00:00	SPY	ETF	447.63	447.63	447.63	447.63	500.0
2023-07-13 05:01:00	SPY	ETF	447.65	447.65	447.65	447.65	100.0
2023-07-13 05:02:00	SPY	ETF	447.68	447.71	447.67	447.71	1224.0
2023-07-13 05:03:00	SPY	ETF	447.71	447.71	447.71	447.71	800.0
2023-07-13 05:06:00	SPY	ETF	447.64	447.64	447.63	447.63	2250.0
2023-07-13 05:08:00	SPY	ETF	447.65	447.65	447.65	447.65	689.0
2023-07-13 05:10:00	SPY	ETF	447.68	447.68	447.68	447.68	106.0

> showing 50 of 264,100 rows — these rows as CSV

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