PREVIEW / etf_1min / 2023-01-06

all etf 1-min files

  file:    by_date/etf_1min/2023/2023-01-06.parquet
  size:    4.8 MB
  rows:    268,931

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-06 04:00:00	SPY	ETF	380.0	380.0	380.0	380.0	100.0
2023-01-06 04:01:00	SPY	ETF	379.98	379.98	379.82	379.9	3200.0
2023-01-06 04:02:00	SPY	ETF	379.76	379.85	379.75	379.85	3600.0
2023-01-06 04:04:00	SPY	ETF	379.87	379.87	379.79	379.79	700.0
2023-01-06 04:05:00	SPY	ETF	379.77	379.81	379.77	379.81	900.0
2023-01-06 04:06:00	SPY	ETF	379.79	379.79	379.79	379.79	165.0
2023-01-06 04:08:00	SPY	ETF	379.72	379.72	379.53	379.53	3700.0
2023-01-06 04:09:00	SPY	ETF	379.5	379.5	379.5	379.5	100.0
2023-01-06 04:10:00	SPY	ETF	379.6	379.6	379.6	379.6	302.0
2023-01-06 04:11:00	SPY	ETF	379.4	379.4	379.37	379.37	441.0
2023-01-06 04:13:00	SPY	ETF	379.33	379.36	379.33	379.36	206.0
2023-01-06 04:14:00	SPY	ETF	379.3	379.3	379.28	379.28	400.0
2023-01-06 04:15:00	SPY	ETF	379.38	379.38	379.38	379.38	500.0
2023-01-06 04:17:00	SPY	ETF	379.56	379.56	379.56	379.56	100.0
2023-01-06 04:19:00	SPY	ETF	379.53	379.56	379.53	379.54	765.0
2023-01-06 04:20:00	SPY	ETF	379.43	379.43	379.43	379.43	1000.0
2023-01-06 04:21:00	SPY	ETF	379.33	379.33	379.2	379.2	4368.0
2023-01-06 04:22:00	SPY	ETF	379.18	379.18	379.18	379.18	200.0
2023-01-06 04:23:00	SPY	ETF	379.3	379.3	379.3	379.3	150.0
2023-01-06 04:24:00	SPY	ETF	379.29	379.3	379.29	379.3	472.0
2023-01-06 04:26:00	SPY	ETF	379.25	379.25	379.25	379.25	200.0
2023-01-06 04:29:00	SPY	ETF	379.25	379.25	379.25	379.25	100.0
2023-01-06 04:30:00	SPY	ETF	379.2	379.23	379.2	379.23	800.0
2023-01-06 04:31:00	SPY	ETF	379.2	379.2	379.12	379.13	2600.0
2023-01-06 04:32:00	SPY	ETF	379.13	379.13	379.11	379.11	2500.0
2023-01-06 04:33:00	SPY	ETF	379.09	379.18	379.09	379.18	850.0
2023-01-06 04:34:00	SPY	ETF	379.13	379.15	379.13	379.15	900.0
2023-01-06 04:35:00	SPY	ETF	379.13	379.13	379.1	379.11	534.0
2023-01-06 04:36:00	SPY	ETF	379.06	379.06	378.99	378.99	200.0
2023-01-06 04:37:00	SPY	ETF	379.02	379.02	379.02	379.02	100.0
2023-01-06 04:38:00	SPY	ETF	379.09	379.09	379.08	379.08	303.0
2023-01-06 04:41:00	SPY	ETF	379.08	379.08	379.08	379.08	100.0
2023-01-06 04:42:00	SPY	ETF	379.1	379.19	379.1	379.19	900.0
2023-01-06 04:43:00	SPY	ETF	379.37	379.44	379.37	379.44	1995.0
2023-01-06 04:44:00	SPY	ETF	379.45	379.45	379.38	379.38	1300.0
2023-01-06 04:47:00	SPY	ETF	379.32	379.32	379.32	379.32	100.0
2023-01-06 04:49:00	SPY	ETF	379.42	379.42	379.42	379.42	100.0
2023-01-06 04:50:00	SPY	ETF	379.38	379.38	379.37	379.37	1100.0
2023-01-06 04:52:00	SPY	ETF	379.3	379.3	379.3	379.3	100.0
2023-01-06 04:56:00	SPY	ETF	379.45	379.45	379.41	379.41	419.0
2023-01-06 04:58:00	SPY	ETF	379.44	379.45	379.44	379.45	1100.0
2023-01-06 04:59:00	SPY	ETF	379.48	379.49	379.48	379.48	1000.0
2023-01-06 05:00:00	SPY	ETF	379.38	379.38	379.25	379.25	1350.0
2023-01-06 05:01:00	SPY	ETF	379.18	379.23	379.17	379.18	2162.0
2023-01-06 05:06:00	SPY	ETF	379.44	379.44	379.44	379.44	106.0
2023-01-06 05:08:00	SPY	ETF	379.34	379.34	379.34	379.34	134.0
2023-01-06 05:11:00	SPY	ETF	379.55	379.58	379.55	379.58	600.0
2023-01-06 05:13:00	SPY	ETF	379.67	379.68	379.67	379.68	600.0
2023-01-06 05:14:00	SPY	ETF	379.69	379.69	379.69	379.69	300.0
2023-01-06 05:16:00	SPY	ETF	379.68	379.68	379.68	379.68	100.0

> showing 50 of 268,931 rows — these rows as CSV

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