PREVIEW / etf_1min / 2023-05-05

all etf 1-min files

  file:    by_date/etf_1min/2023/2023-05-05.parquet
  size:    4.3 MB
  rows:    247,017

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-05 04:00:00	SPY	ETF	406.48	406.54	406.25	406.54	1300.0
2023-05-05 04:01:00	SPY	ETF	406.57	406.59	406.57	406.59	700.0
2023-05-05 04:02:00	SPY	ETF	406.62	406.62	406.57	406.57	200.0
2023-05-05 04:03:00	SPY	ETF	406.61	406.61	406.6	406.6	1100.0
2023-05-05 04:05:00	SPY	ETF	406.61	406.64	406.61	406.64	211.0
2023-05-05 04:06:00	SPY	ETF	406.65	406.67	406.65	406.67	6200.0
2023-05-05 04:07:00	SPY	ETF	406.67	406.67	406.6	406.6	4462.0
2023-05-05 04:11:00	SPY	ETF	406.52	406.52	406.52	406.52	142.0
2023-05-05 04:15:00	SPY	ETF	406.56	406.56	406.56	406.56	500.0
2023-05-05 04:18:00	SPY	ETF	406.6	406.6	406.6	406.6	100.0
2023-05-05 04:19:00	SPY	ETF	406.4	406.4	406.4	406.4	200.0
2023-05-05 04:21:00	SPY	ETF	406.4	406.4	406.38	406.38	950.0
2023-05-05 04:22:00	SPY	ETF	406.37	406.37	406.37	406.37	500.0
2023-05-05 04:23:00	SPY	ETF	406.3	406.3	406.25	406.25	3314.0
2023-05-05 04:28:00	SPY	ETF	406.36	406.49	406.36	406.49	700.0
2023-05-05 04:30:00	SPY	ETF	406.46	406.46	406.46	406.46	100.0
2023-05-05 04:32:00	SPY	ETF	406.47	406.47	406.47	406.47	100.0
2023-05-05 04:33:00	SPY	ETF	406.59	406.59	406.58	406.58	613.0
2023-05-05 04:34:00	SPY	ETF	406.43	406.43	406.43	406.43	400.0
2023-05-05 04:35:00	SPY	ETF	406.48	406.49	406.48	406.49	200.0
2023-05-05 04:38:00	SPY	ETF	406.43	406.48	406.43	406.48	403.0
2023-05-05 04:39:00	SPY	ETF	406.41	406.41	406.4	406.4	1100.0
2023-05-05 04:42:00	SPY	ETF	406.44	406.51	406.44	406.51	750.0
2023-05-05 04:45:00	SPY	ETF	406.67	406.67	406.67	406.67	300.0
2023-05-05 04:46:00	SPY	ETF	406.68	406.68	406.68	406.68	200.0
2023-05-05 04:49:00	SPY	ETF	406.72	406.72	406.72	406.72	100.0
2023-05-05 04:52:00	SPY	ETF	407.0	407.0	407.0	407.0	1200.0
2023-05-05 04:53:00	SPY	ETF	407.06	407.06	407.06	407.06	251.0
2023-05-05 04:54:00	SPY	ETF	407.1	407.11	407.1	407.11	1000.0
2023-05-05 04:55:00	SPY	ETF	407.08	407.08	407.08	407.08	1400.0
2023-05-05 04:57:00	SPY	ETF	407.05	407.05	407.05	407.05	100.0
2023-05-05 05:01:00	SPY	ETF	407.02	407.02	407.02	407.02	124.0
2023-05-05 05:04:00	SPY	ETF	406.86	406.86	406.86	406.86	200.0
2023-05-05 05:06:00	SPY	ETF	406.8	406.8	406.8	406.8	100.0
2023-05-05 05:07:00	SPY	ETF	406.82	406.82	406.82	406.82	1200.0
2023-05-05 05:10:00	SPY	ETF	407.0	407.0	407.0	407.0	500.0
2023-05-05 05:12:00	SPY	ETF	407.01	407.01	407.0	407.01	3500.0
2023-05-05 05:13:00	SPY	ETF	406.93	406.93	406.92	406.92	2500.0
2023-05-05 05:16:00	SPY	ETF	406.76	406.76	406.76	406.76	250.0
2023-05-05 05:18:00	SPY	ETF	406.8	406.8	406.8	406.8	300.0
2023-05-05 05:20:00	SPY	ETF	406.89	406.89	406.89	406.89	100.0
2023-05-05 05:23:00	SPY	ETF	406.88	406.88	406.88	406.88	100.0
2023-05-05 05:27:00	SPY	ETF	406.92	406.92	406.92	406.92	396.0
2023-05-05 05:28:00	SPY	ETF	406.92	406.97	406.92	406.97	500.0
2023-05-05 05:30:00	SPY	ETF	406.96	406.97	406.96	406.96	1300.0
2023-05-05 05:33:00	SPY	ETF	406.92	406.92	406.92	406.92	100.0
2023-05-05 05:35:00	SPY	ETF	406.96	406.96	406.96	406.96	100.0
2023-05-05 05:36:00	SPY	ETF	406.96	406.96	406.96	406.96	100.0
2023-05-05 05:40:00	SPY	ETF	406.99	406.99	406.99	406.99	370.0
2023-05-05 05:43:00	SPY	ETF	407.0	407.0	407.0	407.0	100.0

> showing 50 of 247,017 rows — these rows as CSV

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