PREVIEW / etf_1min / 2023-05-19

all etf 1-min files

  file:    by_date/etf_1min/2023/2023-05-19.parquet
  size:    4.1 MB
  rows:    243,553

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-05-19 04:00:00	SPY	ETF	419.74	419.74	419.74	419.74	800.0
2023-05-19 04:01:00	SPY	ETF	419.86	419.89	419.85	419.89	4500.0
2023-05-19 04:02:00	SPY	ETF	419.88	419.9	419.86	419.86	1552.0
2023-05-19 04:03:00	SPY	ETF	419.81	419.81	419.7	419.7	5700.0
2023-05-19 04:04:00	SPY	ETF	419.7	419.76	419.68	419.73	979.0
2023-05-19 04:05:00	SPY	ETF	419.8	419.8	419.75	419.75	500.0
2023-05-19 04:06:00	SPY	ETF	419.8	419.82	419.8	419.8	2613.0
2023-05-19 04:07:00	SPY	ETF	419.82	419.82	419.82	419.82	133.0
2023-05-19 04:08:00	SPY	ETF	419.76	419.76	419.76	419.76	100.0
2023-05-19 04:09:00	SPY	ETF	419.74	419.74	419.74	419.74	400.0
2023-05-19 04:11:00	SPY	ETF	419.7	419.7	419.7	419.7	100.0
2023-05-19 04:13:00	SPY	ETF	419.79	419.8	419.75	419.8	4100.0
2023-05-19 04:15:00	SPY	ETF	419.74	419.74	419.74	419.74	137.0
2023-05-19 04:16:00	SPY	ETF	419.59	419.59	419.57	419.57	440.0
2023-05-19 04:19:00	SPY	ETF	419.67	419.72	419.67	419.71	2719.0
2023-05-19 04:25:00	SPY	ETF	419.64	419.64	419.63	419.63	1000.0
2023-05-19 04:26:00	SPY	ETF	419.66	419.66	419.66	419.66	1000.0
2023-05-19 04:29:00	SPY	ETF	419.79	419.79	419.79	419.79	1000.0
2023-05-19 04:31:00	SPY	ETF	420.0	420.0	419.99	419.99	1170.0
2023-05-19 04:32:00	SPY	ETF	420.05	420.05	420.05	420.05	200.0
2023-05-19 04:33:00	SPY	ETF	420.09	420.09	419.99	419.99	5500.0
2023-05-19 04:34:00	SPY	ETF	420.11	420.11	420.1	420.1	3000.0
2023-05-19 04:35:00	SPY	ETF	420.12	420.2	420.12	420.2	5705.0
2023-05-19 04:37:00	SPY	ETF	420.15	420.25	420.15	420.25	376.0
2023-05-19 04:38:00	SPY	ETF	420.31	420.31	420.31	420.31	192.0
2023-05-19 04:39:00	SPY	ETF	420.15	420.15	420.15	420.15	100.0
2023-05-19 04:41:00	SPY	ETF	420.09	420.09	420.09	420.09	400.0
2023-05-19 04:42:00	SPY	ETF	420.01	420.01	420.01	420.01	400.0
2023-05-19 04:43:00	SPY	ETF	419.97	419.97	419.97	419.97	100.0
2023-05-19 04:44:00	SPY	ETF	419.97	419.97	419.97	419.97	100.0
2023-05-19 04:53:00	SPY	ETF	420.14	420.14	420.14	420.14	4800.0
2023-05-19 04:56:00	SPY	ETF	420.29	420.29	420.29	420.29	212.0
2023-05-19 04:57:00	SPY	ETF	420.33	420.34	420.31	420.33	1400.0
2023-05-19 04:58:00	SPY	ETF	420.3	420.3	420.2	420.2	2151.0
2023-05-19 05:00:00	SPY	ETF	420.19	420.19	420.19	420.19	300.0
2023-05-19 05:01:00	SPY	ETF	420.1	420.1	420.1	420.1	100.0
2023-05-19 05:03:00	SPY	ETF	420.12	420.12	420.11	420.11	597.0
2023-05-19 05:04:00	SPY	ETF	420.1	420.12	420.07	420.07	800.0
2023-05-19 05:07:00	SPY	ETF	420.07	420.07	420.07	420.07	100.0
2023-05-19 05:08:00	SPY	ETF	420.06	420.06	420.06	420.06	100.0
2023-05-19 05:10:00	SPY	ETF	420.12	420.12	420.12	420.12	100.0
2023-05-19 05:11:00	SPY	ETF	420.12	420.12	420.09	420.09	400.0
2023-05-19 05:12:00	SPY	ETF	420.11	420.11	420.11	420.11	100.0
2023-05-19 05:18:00	SPY	ETF	420.11	420.11	420.11	420.11	195.0
2023-05-19 05:19:00	SPY	ETF	420.13	420.13	420.13	420.13	104.0
2023-05-19 05:20:00	SPY	ETF	420.02	420.02	420.02	420.02	300.0
2023-05-19 05:22:00	SPY	ETF	420.0	420.0	420.0	420.0	500.0
2023-05-19 05:23:00	SPY	ETF	420.0	420.0	420.0	420.0	500.0
2023-05-19 05:25:00	SPY	ETF	419.88	419.88	419.88	419.88	120.0
2023-05-19 05:26:00	SPY	ETF	419.89	419.89	419.89	419.89	200.0

> showing 50 of 243,553 rows — these rows as CSV

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