PREVIEW / etf_30min / 2024-11-14

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-11-14.parquet
  size:    905 KB
  rows:    35,912

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-11-14 04:00:00	SPY	ETF	597.74	598.17	597.7	597.7	15070.0
2024-11-14 04:30:00	SPY	ETF	597.89	597.97	597.55	597.68	4153.0
2024-11-14 05:00:00	SPY	ETF	597.61	597.85	597.57	597.85	5417.0
2024-11-14 05:30:00	SPY	ETF	597.95	598.07	597.63	597.66	17580.0
2024-11-14 06:00:00	SPY	ETF	597.78	597.91	597.66	597.91	16989.0
2024-11-14 06:30:00	SPY	ETF	597.91	598.2	597.7	598.15	28767.0
2024-11-14 07:00:00	SPY	ETF	598.14	598.26	597.76	597.93	130751.0
2024-11-14 07:30:00	SPY	ETF	597.96	598.08	597.56	597.65	34952.0
2024-11-14 08:00:00	SPY	ETF	597.93	598.25	596.27	598.0999	125643.0
2024-11-14 08:30:00	SPY	ETF	597.9	598.17	596.73	597.16	184804.0
2024-11-14 09:00:00	SPY	ETF	597.07	597.4799	596.91	597.31	141152.0
2024-11-14 09:30:00	SPY	ETF	597.32	597.81	595.7901	596.41	2729267.0
2024-11-14 10:00:00	SPY	ETF	596.415	596.5601	595.1248	596.42	1711198.0
2024-11-14 10:30:00	SPY	ETF	596.41	596.94	596.0	596.1401	1248037.0
2024-11-14 11:00:00	SPY	ETF	596.165	596.72	595.86	596.46	878644.0
2024-11-14 11:30:00	SPY	ETF	596.49	596.93	595.5001	595.6601	784806.0
2024-11-14 12:00:00	SPY	ETF	595.67	595.86	594.7	594.8299	1225549.0
2024-11-14 12:30:00	SPY	ETF	594.82	595.37	593.75	595.0548	1779483.0
2024-11-14 13:00:00	SPY	ETF	595.03	595.7201	594.76	595.1399	884500.0
2024-11-14 13:30:00	SPY	ETF	595.12	595.21	593.77	593.9	1073030.0
2024-11-14 14:00:00	SPY	ETF	593.88	595.31	593.8698	595.15	1003136.0
2024-11-14 14:30:00	SPY	ETF	595.13	595.79	594.9	595.295	1200679.0
2024-11-14 15:00:00	SPY	ETF	595.28	595.31	593.02	594.14	2824921.0
2024-11-14 15:30:00	SPY	ETF	594.15	594.37	592.65	593.37	6156267.0
2024-11-14 16:00:00	SPY	ETF	593.39	593.48	592.12	592.85	3299970.0
2024-11-14 16:30:00	SPY	ETF	592.81	593.16	592.81	593.1	255113.0
2024-11-14 17:00:00	SPY	ETF	593.1	593.35	592.72	592.72	28365.0
2024-11-14 17:30:00	SPY	ETF	592.88	592.9	592.66	592.9	36961.0
2024-11-14 18:00:00	SPY	ETF	592.96	593.1	592.24	592.27	60612.0
2024-11-14 18:30:00	SPY	ETF	592.31	592.63	592.27	592.421	11450.0
2024-11-14 19:00:00	SPY	ETF	592.36	592.48	592.17	592.23	9690.0
2024-11-14 19:30:00	SPY	ETF	592.19	592.3	591.7	591.93	72213.0
2024-11-14 04:00:00	QQQ	ETF	512.51	513.1	512.42	512.42	28173.0
2024-11-14 04:30:00	QQQ	ETF	512.59	512.65	512.28	512.36	20849.0
2024-11-14 05:00:00	QQQ	ETF	512.27	512.7	512.2	512.52	7432.0
2024-11-14 05:30:00	QQQ	ETF	512.76	512.91	512.43	512.43	11775.0
2024-11-14 06:00:00	QQQ	ETF	512.55	512.73	512.53	512.69	4709.0
2024-11-14 06:30:00	QQQ	ETF	512.75	512.89	512.51	512.89	36506.0
2024-11-14 07:00:00	QQQ	ETF	512.93	512.98	512.56	512.58	13023.0
2024-11-14 07:30:00	QQQ	ETF	512.66	512.85	512.27	512.35	20518.0
2024-11-14 08:00:00	QQQ	ETF	512.36	512.94	510.94	512.77	120407.0
2024-11-14 08:30:00	QQQ	ETF	512.76	512.76	511.3	511.86	289594.0
2024-11-14 09:00:00	QQQ	ETF	511.79	512.0	511.44	511.89	155524.0
2024-11-14 09:30:00	QQQ	ETF	511.91	512.79	510.1397	510.81	2185567.0
2024-11-14 10:00:00	QQQ	ETF	510.75	511.4	509.56	510.97	1167579.0
2024-11-14 10:30:00	QQQ	ETF	510.93	511.91	510.38	510.78	1031857.0
2024-11-14 11:00:00	QQQ	ETF	510.75	511.42	510.67	511.237	556605.0
2024-11-14 11:30:00	QQQ	ETF	511.25	511.95	510.8646	510.99	609273.0
2024-11-14 12:00:00	QQQ	ETF	511.0	511.2499	509.88	510.08	695596.0
2024-11-14 12:30:00	QQQ	ETF	510.08	510.74	508.96	510.55	1540458.0

> showing 50 of 35,912 rows — these rows as CSV

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