PREVIEW / etf_1min / 2022-07-18

all etf 1-min files

  file:    by_date/etf_1min/2022/2022-07-18.parquet
  size:    4.5 MB
  rows:    255,178

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-07-18 04:00:00	SPY	ETF	388.24	388.36	386.71	388.23	2904.0
2022-07-18 04:01:00	SPY	ETF	388.23	388.23	388.12	388.18	4070.0
2022-07-18 04:02:00	SPY	ETF	388.13	388.24	388.13	388.24	1419.0
2022-07-18 04:03:00	SPY	ETF	388.18	388.38	388.18	388.26	5710.0
2022-07-18 04:04:00	SPY	ETF	388.26	388.3	388.26	388.3	450.0
2022-07-18 04:05:00	SPY	ETF	388.31	388.31	388.31	388.31	150.0
2022-07-18 04:07:00	SPY	ETF	388.3	388.3	388.3	388.3	300.0
2022-07-18 04:09:00	SPY	ETF	388.4	388.43	388.39	388.43	599.0
2022-07-18 04:10:00	SPY	ETF	388.41	388.41	388.27	388.27	560.0
2022-07-18 04:11:00	SPY	ETF	388.25	388.33	388.25	388.33	1400.0
2022-07-18 04:13:00	SPY	ETF	388.33	388.33	388.33	388.33	100.0
2022-07-18 04:14:00	SPY	ETF	388.45	388.45	388.35	388.35	400.0
2022-07-18 04:17:00	SPY	ETF	388.35	388.35	388.35	388.35	1000.0
2022-07-18 04:19:00	SPY	ETF	388.39	388.39	388.39	388.39	100.0
2022-07-18 04:21:00	SPY	ETF	388.42	388.45	388.42	388.45	1100.0
2022-07-18 04:24:00	SPY	ETF	388.65	388.7	388.65	388.69	578.0
2022-07-18 04:25:00	SPY	ETF	388.73	388.75	388.73	388.73	500.0
2022-07-18 04:26:00	SPY	ETF	388.88	388.93	388.88	388.89	850.0
2022-07-18 04:27:00	SPY	ETF	389.01	389.14	389.01	389.14	600.0
2022-07-18 04:28:00	SPY	ETF	389.2	389.2	389.13	389.13	600.0
2022-07-18 04:29:00	SPY	ETF	389.17	389.29	389.17	389.19	2899.0
2022-07-18 04:30:00	SPY	ETF	389.27	389.32	389.27	389.32	500.0
2022-07-18 04:32:00	SPY	ETF	389.23	389.32	389.23	389.32	717.0
2022-07-18 04:33:00	SPY	ETF	389.15	389.15	389.12	389.12	1050.0
2022-07-18 04:34:00	SPY	ETF	389.1	389.21	389.09	389.21	1350.0
2022-07-18 04:36:00	SPY	ETF	389.08	389.08	389.07	389.07	600.0
2022-07-18 04:37:00	SPY	ETF	389.01	389.01	389.01	389.01	100.0
2022-07-18 04:38:00	SPY	ETF	389.05	389.05	389.05	389.05	100.0
2022-07-18 04:39:00	SPY	ETF	389.05	389.1	389.03	389.1	1578.0
2022-07-18 04:41:00	SPY	ETF	389.23	389.23	389.23	389.23	1000.0
2022-07-18 04:42:00	SPY	ETF	389.28	389.3	389.28	389.3	799.0
2022-07-18 04:47:00	SPY	ETF	389.05	389.05	389.05	389.05	300.0
2022-07-18 04:48:00	SPY	ETF	389.11	389.11	389.11	389.11	100.0
2022-07-18 04:49:00	SPY	ETF	389.14	389.14	389.14	389.14	400.0
2022-07-18 04:50:00	SPY	ETF	389.11	389.11	389.11	389.11	200.0
2022-07-18 04:51:00	SPY	ETF	389.12	389.12	389.12	389.12	100.0
2022-07-18 04:52:00	SPY	ETF	389.12	389.12	389.12	389.12	100.0
2022-07-18 04:54:00	SPY	ETF	389.3	389.3	389.25	389.25	889.0
2022-07-18 04:55:00	SPY	ETF	389.33	389.33	389.33	389.33	324.0
2022-07-18 04:56:00	SPY	ETF	389.37	389.37	389.37	389.37	500.0
2022-07-18 04:57:00	SPY	ETF	389.45	389.45	389.45	389.45	100.0
2022-07-18 04:58:00	SPY	ETF	389.35	389.35	389.35	389.35	200.0
2022-07-18 04:59:00	SPY	ETF	389.32	389.35	389.32	389.35	600.0
2022-07-18 05:01:00	SPY	ETF	389.35	389.37	389.35	389.35	430.0
2022-07-18 05:02:00	SPY	ETF	389.35	389.37	389.35	389.37	900.0
2022-07-18 05:05:00	SPY	ETF	389.25	389.25	389.25	389.25	400.0
2022-07-18 05:06:00	SPY	ETF	389.03	389.03	389.03	389.03	300.0
2022-07-18 05:07:00	SPY	ETF	389.0	389.0	388.94	388.94	900.0
2022-07-18 05:08:00	SPY	ETF	388.97	388.97	388.92	388.92	400.0
2022-07-18 05:09:00	SPY	ETF	389.01	389.01	389.01	389.01	800.0

> showing 50 of 255,178 rows — these rows as CSV

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