PREVIEW / etf_1min / 2023-01-17

all etf 1-min files

  file:    by_date/etf_1min/2023/2023-01-17.parquet
  size:    4.7 MB
  rows:    274,444

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-01-17 04:00:00	SPY	ETF	397.95	397.95	397.43	397.46	2729.0
2023-01-17 04:01:00	SPY	ETF	397.47	397.47	397.47	397.47	300.0
2023-01-17 04:02:00	SPY	ETF	397.43	397.46	397.43	397.46	1090.0
2023-01-17 04:03:00	SPY	ETF	397.56	397.6	397.55	397.57	1265.0
2023-01-17 04:04:00	SPY	ETF	397.58	397.58	397.57	397.57	2600.0
2023-01-17 04:05:00	SPY	ETF	397.58	397.75	397.58	397.69	876.0
2023-01-17 04:07:00	SPY	ETF	397.68	397.69	397.68	397.69	250.0
2023-01-17 04:08:00	SPY	ETF	397.65	397.65	397.57	397.57	790.0
2023-01-17 04:09:00	SPY	ETF	397.62	397.62	397.62	397.62	700.0
2023-01-17 04:10:00	SPY	ETF	397.64	397.64	397.58	397.58	400.0
2023-01-17 04:11:00	SPY	ETF	397.62	397.62	397.56	397.56	801.0
2023-01-17 04:13:00	SPY	ETF	397.46	397.48	397.46	397.48	1000.0
2023-01-17 04:14:00	SPY	ETF	397.38	397.4	397.36	397.37	2497.0
2023-01-17 04:16:00	SPY	ETF	397.4	397.4	397.4	397.4	1000.0
2023-01-17 04:17:00	SPY	ETF	397.38	397.38	397.34	397.35	1522.0
2023-01-17 04:18:00	SPY	ETF	397.34	397.34	397.34	397.34	845.0
2023-01-17 04:19:00	SPY	ETF	397.36	397.36	397.36	397.36	100.0
2023-01-17 04:20:00	SPY	ETF	397.32	397.32	397.25	397.25	1540.0
2023-01-17 04:21:00	SPY	ETF	397.2	397.21	397.2	397.21	700.0
2023-01-17 04:22:00	SPY	ETF	397.15	397.15	397.09	397.1	3036.0
2023-01-17 04:23:00	SPY	ETF	397.0	397.0	396.98	396.98	1800.0
2023-01-17 04:24:00	SPY	ETF	396.9	397.01	396.9	396.98	2690.0
2023-01-17 04:25:00	SPY	ETF	396.95	396.99	396.88	396.99	1620.0
2023-01-17 04:26:00	SPY	ETF	396.97	397.03	396.97	397.0	8100.0
2023-01-17 04:27:00	SPY	ETF	397.0	397.07	397.0	397.06	4170.0
2023-01-17 04:28:00	SPY	ETF	397.17	397.17	397.17	397.17	110.0
2023-01-17 04:29:00	SPY	ETF	397.17	397.17	397.13	397.13	686.0
2023-01-17 04:30:00	SPY	ETF	397.14	397.17	397.14	397.16	1088.0
2023-01-17 04:31:00	SPY	ETF	397.27	397.27	397.27	397.27	236.0
2023-01-17 04:32:00	SPY	ETF	397.29	397.34	397.29	397.34	400.0
2023-01-17 04:33:00	SPY	ETF	397.36	397.36	397.36	397.36	100.0
2023-01-17 04:34:00	SPY	ETF	397.48	397.48	397.48	397.48	100.0
2023-01-17 04:36:00	SPY	ETF	397.64	397.64	397.53	397.53	546.0
2023-01-17 04:37:00	SPY	ETF	397.51	397.51	397.51	397.51	100.0
2023-01-17 04:42:00	SPY	ETF	397.68	397.68	397.68	397.68	500.0
2023-01-17 04:43:00	SPY	ETF	397.63	397.63	397.63	397.63	124.0
2023-01-17 04:44:00	SPY	ETF	397.68	397.68	397.68	397.68	300.0
2023-01-17 04:45:00	SPY	ETF	397.69	397.69	397.69	397.69	2375.0
2023-01-17 04:47:00	SPY	ETF	397.63	397.63	397.56	397.57	3310.0
2023-01-17 04:49:00	SPY	ETF	397.5	397.5	397.5	397.5	250.0
2023-01-17 04:50:00	SPY	ETF	397.55	397.55	397.54	397.54	208.0
2023-01-17 04:52:00	SPY	ETF	397.58	397.58	397.58	397.58	250.0
2023-01-17 04:53:00	SPY	ETF	397.57	397.57	397.55	397.55	3454.0
2023-01-17 04:55:00	SPY	ETF	397.49	397.49	397.41	397.41	450.0
2023-01-17 04:56:00	SPY	ETF	397.41	397.41	397.41	397.41	100.0
2023-01-17 04:57:00	SPY	ETF	397.36	397.36	397.36	397.36	113.0
2023-01-17 04:58:00	SPY	ETF	397.34	397.34	397.34	397.34	250.0
2023-01-17 04:59:00	SPY	ETF	397.35	397.35	397.31	397.31	1100.0
2023-01-17 05:01:00	SPY	ETF	397.33	397.33	397.33	397.33	223.0
2023-01-17 05:02:00	SPY	ETF	397.36	397.36	397.35	397.36	1344.0

> showing 50 of 274,444 rows — these rows as CSV

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