PREVIEW / etf_1min / 2023-01-31

all etf 1-min files

  file:    by_date/etf_1min/2023/2023-01-31.parquet
  size:    4.7 MB
  rows:    264,778

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-01-31 04:00:00	SPY	ETF	399.95	400.0	399.74	399.77	2353.0
2023-01-31 04:01:00	SPY	ETF	399.85	399.85	399.85	399.85	150.0
2023-01-31 04:02:00	SPY	ETF	399.89	399.89	399.89	399.89	100.0
2023-01-31 04:03:00	SPY	ETF	399.78	399.78	399.71	399.71	2800.0
2023-01-31 04:05:00	SPY	ETF	399.74	399.76	399.74	399.76	500.0
2023-01-31 04:06:00	SPY	ETF	399.7	399.7	399.69	399.7	1122.0
2023-01-31 04:07:00	SPY	ETF	399.76	399.78	399.76	399.78	597.0
2023-01-31 04:08:00	SPY	ETF	399.69	399.69	399.68	399.68	337.0
2023-01-31 04:09:00	SPY	ETF	399.58	399.7	399.58	399.7	1601.0
2023-01-31 04:10:00	SPY	ETF	399.72	399.78	399.72	399.78	202.0
2023-01-31 04:12:00	SPY	ETF	399.64	399.66	399.64	399.66	300.0
2023-01-31 04:13:00	SPY	ETF	399.67	399.68	399.67	399.68	1000.0
2023-01-31 04:14:00	SPY	ETF	399.62	399.62	399.62	399.62	2000.0
2023-01-31 04:15:00	SPY	ETF	399.6	399.6	399.51	399.55	1369.0
2023-01-31 04:16:00	SPY	ETF	399.57	399.57	399.47	399.47	789.0
2023-01-31 04:17:00	SPY	ETF	399.47	399.47	399.37	399.38	613.0
2023-01-31 04:19:00	SPY	ETF	399.31	399.32	399.21	399.21	6675.0
2023-01-31 04:20:00	SPY	ETF	399.27	399.27	399.27	399.27	200.0
2023-01-31 04:21:00	SPY	ETF	399.3	399.32	399.3	399.31	443.0
2023-01-31 04:22:00	SPY	ETF	399.37	399.37	399.37	399.37	400.0
2023-01-31 04:23:00	SPY	ETF	399.4	399.55	399.4	399.55	1600.0
2023-01-31 04:26:00	SPY	ETF	399.55	399.55	399.5	399.5	200.0
2023-01-31 04:27:00	SPY	ETF	399.53	399.53	399.52	399.52	200.0
2023-01-31 04:29:00	SPY	ETF	399.51	399.51	399.51	399.51	1800.0
2023-01-31 04:30:00	SPY	ETF	399.44	399.44	399.42	399.42	400.0
2023-01-31 04:34:00	SPY	ETF	399.57	399.57	399.45	399.45	1943.0
2023-01-31 04:35:00	SPY	ETF	399.43	399.52	399.43	399.52	200.0
2023-01-31 04:36:00	SPY	ETF	399.5	399.55	399.5	399.55	301.0
2023-01-31 04:37:00	SPY	ETF	399.59	399.59	399.59	399.59	1100.0
2023-01-31 04:38:00	SPY	ETF	399.53	399.63	399.53	399.62	800.0
2023-01-31 04:39:00	SPY	ETF	399.55	399.56	399.5	399.5	693.0
2023-01-31 04:40:00	SPY	ETF	399.5	399.5	399.47	399.47	1000.0
2023-01-31 04:41:00	SPY	ETF	399.47	399.48	399.45	399.48	600.0
2023-01-31 04:43:00	SPY	ETF	399.46	399.46	399.46	399.46	100.0
2023-01-31 04:44:00	SPY	ETF	399.5	399.62	399.5	399.62	520.0
2023-01-31 04:45:00	SPY	ETF	399.63	399.63	399.59	399.59	200.0
2023-01-31 04:47:00	SPY	ETF	399.68	399.68	399.62	399.67	432.0
2023-01-31 04:48:00	SPY	ETF	399.71	399.71	399.71	399.71	500.0
2023-01-31 04:52:00	SPY	ETF	399.51	399.51	399.47	399.47	901.0
2023-01-31 04:53:00	SPY	ETF	399.44	399.44	399.44	399.44	100.0
2023-01-31 04:54:00	SPY	ETF	399.43	399.43	399.43	399.43	700.0
2023-01-31 04:55:00	SPY	ETF	399.48	399.48	399.48	399.48	100.0
2023-01-31 04:57:00	SPY	ETF	399.5	399.5	399.5	399.5	300.0
2023-01-31 05:00:00	SPY	ETF	399.31	399.31	399.31	399.31	100.0
2023-01-31 05:01:00	SPY	ETF	399.25	399.25	399.21	399.21	200.0
2023-01-31 05:02:00	SPY	ETF	399.25	399.26	399.25	399.26	400.0
2023-01-31 05:03:00	SPY	ETF	399.35	399.35	399.3	399.3	550.0
2023-01-31 05:04:00	SPY	ETF	399.31	399.31	399.31	399.31	125.0
2023-01-31 05:05:00	SPY	ETF	399.36	399.36	399.36	399.36	237.0
2023-01-31 05:06:00	SPY	ETF	399.22	399.22	399.21	399.21	999.0

> showing 50 of 264,778 rows — these rows as CSV

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