PREVIEW / etf_1min / 2024-09-20

all etf 1-min files

  file:    by_date/etf_1min/2024/2024-09-20.parquet
  size:    5.1 MB
  rows:    287,199

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
2024-09-20 04:00:00	SPY	ETF	568.99	568.99	568.81	568.88	3590.0
2024-09-20 04:01:00	SPY	ETF	568.88	569.0	568.88	568.91	1621.0
2024-09-20 04:02:00	SPY	ETF	568.85	568.87	568.69	568.69	672.0
2024-09-20 04:03:00	SPY	ETF	568.76	568.76	568.74	568.74	341.0
2024-09-20 04:04:00	SPY	ETF	568.6	568.65	568.58	568.65	2694.0
2024-09-20 04:05:00	SPY	ETF	568.68	568.69	568.64	568.69	1172.0
2024-09-20 04:06:00	SPY	ETF	568.7	568.83	568.69	568.74	3914.0
2024-09-20 04:07:00	SPY	ETF	568.94	568.94	568.86	568.86	738.0
2024-09-20 04:08:00	SPY	ETF	568.82	568.82	568.82	568.82	102.0
2024-09-20 04:09:00	SPY	ETF	568.92	568.92	568.85	568.85	200.0
2024-09-20 04:10:00	SPY	ETF	568.75	568.75	568.75	568.75	100.0
2024-09-20 04:11:00	SPY	ETF	568.69	568.77	568.69	568.77	574.0
2024-09-20 04:12:00	SPY	ETF	568.73	568.73	568.66	568.66	789.0
2024-09-20 04:13:00	SPY	ETF	568.72	568.72	568.72	568.72	561.0
2024-09-20 04:14:00	SPY	ETF	568.69	568.69	568.61	568.68	2020.0
2024-09-20 04:16:00	SPY	ETF	568.72	568.72	568.72	568.72	182.0
2024-09-20 04:19:00	SPY	ETF	568.61	568.61	568.61	568.61	200.0
2024-09-20 04:20:00	SPY	ETF	568.57	568.57	568.57	568.57	500.0
2024-09-20 04:22:00	SPY	ETF	568.43	568.43	568.35	568.35	2245.0
2024-09-20 04:23:00	SPY	ETF	568.4	568.4	568.4	568.4	3349.0
2024-09-20 04:24:00	SPY	ETF	568.4	568.4	568.4	568.4	1794.0
2024-09-20 04:25:00	SPY	ETF	568.32	568.32	568.32	568.32	100.0
2024-09-20 04:26:00	SPY	ETF	568.39	568.39	568.37	568.37	402.0
2024-09-20 04:28:00	SPY	ETF	568.32	568.32	568.3	568.3	2021.0
2024-09-20 04:29:00	SPY	ETF	568.15	568.16	568.15	568.16	200.0
2024-09-20 04:30:00	SPY	ETF	568.1	568.13	568.09	568.1	443.0
2024-09-20 04:32:00	SPY	ETF	568.16	568.16	568.16	568.16	100.0
2024-09-20 04:35:00	SPY	ETF	568.13	568.13	568.11	568.13	323.0
2024-09-20 04:36:00	SPY	ETF	568.23	568.25	568.23	568.25	697.0
2024-09-20 04:37:00	SPY	ETF	568.25	568.25	568.25	568.25	900.0
2024-09-20 04:38:00	SPY	ETF	568.25	568.25	568.23	568.23	246.0
2024-09-20 04:41:00	SPY	ETF	568.37	568.37	568.37	568.37	100.0
2024-09-20 04:42:00	SPY	ETF	568.35	568.35	568.33	568.33	510.0
2024-09-20 04:44:00	SPY	ETF	568.27	568.33	568.27	568.27	1008.0
2024-09-20 04:48:00	SPY	ETF	568.45	568.45	568.45	568.45	100.0
2024-09-20 04:50:00	SPY	ETF	568.33	568.34	568.29	568.29	3400.0
2024-09-20 04:52:00	SPY	ETF	568.46	568.46	568.42	568.42	640.0
2024-09-20 04:53:00	SPY	ETF	568.36	568.36	568.36	568.36	400.0
2024-09-20 04:54:00	SPY	ETF	568.27	568.27	568.27	568.27	1513.0
2024-09-20 04:55:00	SPY	ETF	568.25	568.25	568.25	568.25	105.0
2024-09-20 04:57:00	SPY	ETF	568.25	568.25	568.25	568.25	100.0
2024-09-20 05:00:00	SPY	ETF	568.34	568.34	568.3	568.31	800.0
2024-09-20 05:01:00	SPY	ETF	568.32	568.32	568.32	568.32	200.0
2024-09-20 05:02:00	SPY	ETF	568.35	568.4	568.35	568.4	200.0
2024-09-20 05:03:00	SPY	ETF	568.45	568.49	568.45	568.49	2100.0
2024-09-20 05:04:00	SPY	ETF	568.49	568.49	568.49	568.49	102.0
2024-09-20 05:05:00	SPY	ETF	568.44	568.44	568.44	568.44	100.0
2024-09-20 05:11:00	SPY	ETF	568.43	568.43	568.43	568.43	100.0
2024-09-20 05:13:00	SPY	ETF	568.56	568.56	568.56	568.56	174.0
2024-09-20 05:14:00	SPY	ETF	568.56	568.56	568.56	568.56	100.0

> showing 50 of 287,199 rows — these rows as CSV

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