PREVIEW / etf_1min / 2022-08-19

all etf 1-min files

  file:    by_date/etf_1min/2022/2022-08-19.parquet
  size:    4.1 MB
  rows:    239,690

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
2022-08-19 04:00:00	SPY	ETF	426.49	426.49	425.68	425.78	1750.0
2022-08-19 04:01:00	SPY	ETF	425.74	425.83	425.74	425.83	2334.0
2022-08-19 04:02:00	SPY	ETF	425.94	425.94	425.9	425.92	1256.0
2022-08-19 04:03:00	SPY	ETF	425.8	425.84	425.8	425.84	943.0
2022-08-19 04:04:00	SPY	ETF	425.75	425.75	425.69	425.7	1373.0
2022-08-19 04:05:00	SPY	ETF	425.57	425.57	425.57	425.57	112.0
2022-08-19 04:06:00	SPY	ETF	425.61	425.61	425.59	425.59	1400.0
2022-08-19 04:07:00	SPY	ETF	425.6	425.6	425.6	425.6	500.0
2022-08-19 04:08:00	SPY	ETF	425.55	425.55	425.53	425.53	1000.0
2022-08-19 04:09:00	SPY	ETF	425.41	425.41	425.39	425.41	1608.0
2022-08-19 04:10:00	SPY	ETF	425.35	425.35	425.27	425.27	1298.0
2022-08-19 04:11:00	SPY	ETF	425.29	425.39	425.29	425.39	377.0
2022-08-19 04:12:00	SPY	ETF	425.32	425.32	425.31	425.31	533.0
2022-08-19 04:15:00	SPY	ETF	425.3	425.3	425.2	425.2	1000.0
2022-08-19 04:16:00	SPY	ETF	425.2	425.2	425.16	425.16	935.0
2022-08-19 04:17:00	SPY	ETF	425.12	425.12	424.96	424.96	1567.0
2022-08-19 04:18:00	SPY	ETF	425.0	425.0	425.0	425.0	1000.0
2022-08-19 04:19:00	SPY	ETF	425.05	425.17	425.05	425.17	1500.0
2022-08-19 04:20:00	SPY	ETF	425.17	425.17	425.06	425.06	1619.0
2022-08-19 04:21:00	SPY	ETF	425.01	425.01	424.88	424.88	3000.0
2022-08-19 04:22:00	SPY	ETF	424.81	424.81	424.7	424.72	2946.0
2022-08-19 04:23:00	SPY	ETF	424.68	424.68	424.68	424.68	500.0
2022-08-19 04:24:00	SPY	ETF	424.64	424.7	424.6	424.7	1488.0
2022-08-19 04:25:00	SPY	ETF	424.7	424.7	424.64	424.64	6925.0
2022-08-19 04:27:00	SPY	ETF	424.65	424.65	424.65	424.65	500.0
2022-08-19 04:28:00	SPY	ETF	424.65	424.68	424.65	424.68	900.0
2022-08-19 04:29:00	SPY	ETF	424.68	424.68	424.68	424.68	100.0
2022-08-19 04:30:00	SPY	ETF	424.63	424.63	424.5	424.5	2308.0
2022-08-19 04:31:00	SPY	ETF	424.47	424.5	424.47	424.47	1600.0
2022-08-19 04:32:00	SPY	ETF	424.44	424.44	424.3	424.3	1637.0
2022-08-19 04:33:00	SPY	ETF	424.25	424.26	424.1	424.1	7248.0
2022-08-19 04:34:00	SPY	ETF	424.1	424.13	424.1	424.13	300.0
2022-08-19 04:35:00	SPY	ETF	424.13	424.25	424.13	424.25	2891.0
2022-08-19 04:36:00	SPY	ETF	424.27	424.3	424.26	424.28	2054.0
2022-08-19 04:37:00	SPY	ETF	424.23	424.23	424.18	424.18	500.0
2022-08-19 04:38:00	SPY	ETF	424.18	424.18	424.14	424.14	1244.0
2022-08-19 04:39:00	SPY	ETF	424.15	424.27	424.15	424.27	2000.0
2022-08-19 04:40:00	SPY	ETF	424.23	424.26	424.23	424.26	243.0
2022-08-19 04:44:00	SPY	ETF	424.32	424.32	424.32	424.32	200.0
2022-08-19 04:45:00	SPY	ETF	424.34	424.36	424.34	424.35	2117.0
2022-08-19 04:46:00	SPY	ETF	424.4	424.51	424.4	424.5	3229.0
2022-08-19 04:49:00	SPY	ETF	424.31	424.31	424.31	424.31	200.0
2022-08-19 04:50:00	SPY	ETF	424.39	424.4	424.39	424.4	8010.0
2022-08-19 04:51:00	SPY	ETF	424.35	424.36	424.3	424.35	1799.0
2022-08-19 04:52:00	SPY	ETF	424.35	424.35	424.32	424.32	609.0
2022-08-19 04:53:00	SPY	ETF	424.25	424.25	424.25	424.25	500.0
2022-08-19 04:58:00	SPY	ETF	424.44	424.44	424.44	424.44	649.0
2022-08-19 04:59:00	SPY	ETF	424.55	424.55	424.55	424.55	900.0
2022-08-19 05:00:00	SPY	ETF	424.48	424.53	424.48	424.53	1213.0
2022-08-19 05:02:00	SPY	ETF	424.35	424.35	424.35	424.35	129.0

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

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