PREVIEW / etf_1min / 2022-04-29

all etf 1-min files

  file:    by_date/etf_1min/2022/2022-04-29.parquet
  size:    4.9 MB
  rows:    274,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
2022-04-29 04:00:00	SPY	ETF	425.51	426.15	425.51	426.08	735.0
2022-04-29 04:01:00	SPY	ETF	426.1	426.18	426.1	426.18	580.0
2022-04-29 04:02:00	SPY	ETF	425.93	425.93	425.93	425.93	200.0
2022-04-29 04:03:00	SPY	ETF	426.28	426.28	426.12	426.21	940.0
2022-04-29 04:04:00	SPY	ETF	426.22	426.22	426.22	426.22	100.0
2022-04-29 04:06:00	SPY	ETF	426.27	426.27	426.18	426.18	300.0
2022-04-29 04:07:00	SPY	ETF	426.0	426.0	426.0	426.0	100.0
2022-04-29 04:09:00	SPY	ETF	426.27	426.27	426.27	426.27	100.0
2022-04-29 04:10:00	SPY	ETF	426.29	426.29	426.28	426.28	399.0
2022-04-29 04:11:00	SPY	ETF	426.3	426.3	426.3	426.3	500.0
2022-04-29 04:12:00	SPY	ETF	426.39	426.39	426.35	426.35	3800.0
2022-04-29 04:13:00	SPY	ETF	426.35	426.39	426.35	426.39	3150.0
2022-04-29 04:14:00	SPY	ETF	426.3	426.34	426.3	426.34	200.0
2022-04-29 04:15:00	SPY	ETF	426.39	426.4	426.39	426.4	200.0
2022-04-29 04:16:00	SPY	ETF	426.39	426.39	426.39	426.39	700.0
2022-04-29 04:18:00	SPY	ETF	426.32	426.48	426.32	426.4	600.0
2022-04-29 04:20:00	SPY	ETF	426.21	426.24	426.21	426.24	500.0
2022-04-29 04:21:00	SPY	ETF	426.17	426.17	426.17	426.17	100.0
2022-04-29 04:22:00	SPY	ETF	426.0	426.0	426.0	426.0	2500.0
2022-04-29 04:24:00	SPY	ETF	425.91	425.92	425.91	425.92	6673.0
2022-04-29 04:25:00	SPY	ETF	425.81	425.83	425.78	425.78	600.0
2022-04-29 04:28:00	SPY	ETF	425.8	425.8	425.8	425.8	100.0
2022-04-29 04:31:00	SPY	ETF	426.23	426.32	426.23	426.32	200.0
2022-04-29 04:33:00	SPY	ETF	426.39	426.39	426.28	426.28	600.0
2022-04-29 04:36:00	SPY	ETF	425.72	425.73	425.71	425.73	500.0
2022-04-29 04:37:00	SPY	ETF	425.65	425.65	425.47	425.47	900.0
2022-04-29 04:38:00	SPY	ETF	425.5	425.5	425.47	425.47	315.0
2022-04-29 04:41:00	SPY	ETF	425.48	425.48	425.48	425.48	250.0
2022-04-29 04:45:00	SPY	ETF	425.65	425.65	425.65	425.65	100.0
2022-04-29 04:47:00	SPY	ETF	425.89	425.89	425.89	425.89	200.0
2022-04-29 04:49:00	SPY	ETF	425.73	425.73	425.73	425.73	100.0
2022-04-29 04:51:00	SPY	ETF	425.66	425.66	425.66	425.66	200.0
2022-04-29 04:53:00	SPY	ETF	425.56	425.56	425.56	425.56	100.0
2022-04-29 05:01:00	SPY	ETF	425.3	425.3	425.3	425.3	100.0
2022-04-29 05:03:00	SPY	ETF	425.45	425.47	425.45	425.47	1700.0
2022-04-29 05:04:00	SPY	ETF	425.39	425.39	425.39	425.39	200.0
2022-04-29 05:05:00	SPY	ETF	425.42	425.42	425.42	425.42	100.0
2022-04-29 05:06:00	SPY	ETF	425.07	425.09	425.04	425.09	4200.0
2022-04-29 05:07:00	SPY	ETF	425.17	425.21	425.07	425.07	1667.0
2022-04-29 05:08:00	SPY	ETF	424.97	425.0	424.89	424.92	1436.0
2022-04-29 05:10:00	SPY	ETF	424.98	424.98	424.98	424.98	102.0
2022-04-29 05:11:00	SPY	ETF	424.89	424.97	424.88	424.97	1200.0
2022-04-29 05:12:00	SPY	ETF	425.05	425.05	425.05	425.05	482.0
2022-04-29 05:15:00	SPY	ETF	424.9	424.9	424.81	424.81	700.0
2022-04-29 05:16:00	SPY	ETF	424.68	424.78	424.66	424.78	800.0
2022-04-29 05:19:00	SPY	ETF	424.77	424.77	424.77	424.77	100.0
2022-04-29 05:20:00	SPY	ETF	424.94	424.94	424.86	424.86	200.0
2022-04-29 05:22:00	SPY	ETF	425.09	425.09	425.09	425.09	100.0
2022-04-29 05:23:00	SPY	ETF	425.22	425.22	425.2	425.2	500.0
2022-04-29 05:24:00	SPY	ETF	425.16	425.19	425.16	425.19	2845.0

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

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