PREVIEW / etf_1min / 2023-04-27

all etf 1-min files

  file:    by_date/etf_1min/2023/2023-04-27.parquet
  size:    4.4 MB
  rows:    246,086

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-04-27 04:00:00	SPY	ETF	406.06	406.63	406.06	406.62	1402.0
2023-04-27 04:01:00	SPY	ETF	406.57	406.57	406.51	406.53	1350.0
2023-04-27 04:02:00	SPY	ETF	406.47	406.47	406.47	406.47	500.0
2023-04-27 04:04:00	SPY	ETF	406.45	406.45	406.45	406.45	200.0
2023-04-27 04:05:00	SPY	ETF	406.38	406.38	406.38	406.38	600.0
2023-04-27 04:06:00	SPY	ETF	406.39	406.43	406.39	406.42	931.0
2023-04-27 04:08:00	SPY	ETF	406.37	406.37	406.37	406.37	100.0
2023-04-27 04:09:00	SPY	ETF	406.31	406.31	406.31	406.31	386.0
2023-04-27 04:10:00	SPY	ETF	406.31	406.31	406.31	406.31	100.0
2023-04-27 04:11:00	SPY	ETF	406.3	406.3	406.3	406.3	450.0
2023-04-27 04:12:00	SPY	ETF	406.37	406.37	406.36	406.36	1211.0
2023-04-27 04:16:00	SPY	ETF	406.4	406.4	406.4	406.4	300.0
2023-04-27 04:17:00	SPY	ETF	406.38	406.38	406.37	406.37	600.0
2023-04-27 04:18:00	SPY	ETF	406.49	406.55	406.49	406.55	400.0
2023-04-27 04:24:00	SPY	ETF	406.6	406.6	406.6	406.6	100.0
2023-04-27 04:25:00	SPY	ETF	406.57	406.57	406.55	406.55	653.0
2023-04-27 04:28:00	SPY	ETF	406.51	406.51	406.51	406.51	500.0
2023-04-27 04:32:00	SPY	ETF	406.6	406.6	406.59	406.59	1100.0
2023-04-27 04:34:00	SPY	ETF	406.63	406.63	406.63	406.63	160.0
2023-04-27 04:35:00	SPY	ETF	406.65	406.66	406.65	406.66	578.0
2023-04-27 04:36:00	SPY	ETF	406.69	406.69	406.69	406.69	168.0
2023-04-27 04:37:00	SPY	ETF	406.7	406.7	406.7	406.7	499.0
2023-04-27 04:38:00	SPY	ETF	406.67	406.67	406.67	406.67	600.0
2023-04-27 04:39:00	SPY	ETF	406.6	406.6	406.6	406.6	100.0
2023-04-27 04:40:00	SPY	ETF	406.5	406.5	406.5	406.5	100.0
2023-04-27 04:41:00	SPY	ETF	406.5	406.5	406.5	406.5	100.0
2023-04-27 04:42:00	SPY	ETF	406.5	406.5	406.5	406.5	300.0
2023-04-27 04:45:00	SPY	ETF	406.55	406.55	406.5	406.5	1250.0
2023-04-27 04:46:00	SPY	ETF	406.54	406.54	406.5	406.5	3295.0
2023-04-27 04:50:00	SPY	ETF	406.61	406.61	406.61	406.61	100.0
2023-04-27 04:51:00	SPY	ETF	406.61	406.61	406.61	406.61	500.0
2023-04-27 04:52:00	SPY	ETF	406.63	406.64	406.55	406.55	2000.0
2023-04-27 04:53:00	SPY	ETF	406.53	406.53	406.53	406.53	500.0
2023-04-27 04:54:00	SPY	ETF	406.65	406.65	406.65	406.65	110.0
2023-04-27 04:59:00	SPY	ETF	406.7	406.7	406.65	406.65	546.0
2023-04-27 05:04:00	SPY	ETF	406.63	406.63	406.63	406.63	100.0
2023-04-27 05:05:00	SPY	ETF	406.58	406.58	406.58	406.58	100.0
2023-04-27 05:06:00	SPY	ETF	406.63	406.65	406.63	406.65	400.0
2023-04-27 05:07:00	SPY	ETF	406.71	406.71	406.68	406.68	305.0
2023-04-27 05:09:00	SPY	ETF	406.67	406.67	406.67	406.67	100.0
2023-04-27 05:13:00	SPY	ETF	406.64	406.64	406.64	406.64	235.0
2023-04-27 05:14:00	SPY	ETF	406.61	406.61	406.61	406.61	110.0
2023-04-27 05:15:00	SPY	ETF	406.71	406.71	406.7	406.7	200.0
2023-04-27 05:17:00	SPY	ETF	406.59	406.59	406.59	406.59	432.0
2023-04-27 05:22:00	SPY	ETF	406.52	406.52	406.52	406.52	500.0
2023-04-27 05:24:00	SPY	ETF	406.5	406.5	406.45	406.45	1264.0
2023-04-27 05:28:00	SPY	ETF	406.57	406.57	406.57	406.57	100.0
2023-04-27 05:32:00	SPY	ETF	406.5	406.5	406.5	406.5	1300.0
2023-04-27 05:35:00	SPY	ETF	406.58	406.58	406.58	406.58	100.0
2023-04-27 05:38:00	SPY	ETF	406.62	406.66	406.62	406.66	296.0

> showing 50 of 246,086 rows — these rows as CSV

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