PREVIEW / etf_30min / 2024-03-18

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-03-18.parquet
  size:    806 KB
  rows:    32,039

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-03-18 04:00:00	SPY	ETF	511.41	511.41	511.0	511.17	4157.0
2024-03-18 04:30:00	SPY	ETF	510.76	511.7	510.76	511.7	3163.0
2024-03-18 05:00:00	SPY	ETF	511.81	511.89	511.35	511.55	3916.0
2024-03-18 05:30:00	SPY	ETF	511.46	511.73	511.46	511.58	896.0
2024-03-18 06:00:00	SPY	ETF	511.56	511.66	511.45	511.62	3298.0
2024-03-18 06:30:00	SPY	ETF	511.75	511.91	511.62	511.77	7255.0
2024-03-18 07:00:00	SPY	ETF	511.77	512.91	511.47	512.87	129368.0
2024-03-18 07:30:00	SPY	ETF	512.87	513.54	512.87	513.34	120548.0
2024-03-18 08:00:00	SPY	ETF	512.07	513.99	510.9	513.81	227652.0
2024-03-18 08:30:00	SPY	ETF	513.82	513.82	509.83	513.49	210188.0
2024-03-18 09:00:00	SPY	ETF	513.52	514.09	513.49	513.98	268074.0
2024-03-18 09:30:00	SPY	ETF	513.98	514.83	513.26	513.835	7404325.0
2024-03-18 10:00:00	SPY	ETF	513.84	515.48	513.81	515.18	4217248.0
2024-03-18 10:30:00	SPY	ETF	515.18	515.26	514.77	515.14	2652310.0
2024-03-18 11:00:00	SPY	ETF	515.14	515.225	514.255	514.68	2747662.0
2024-03-18 11:30:00	SPY	ETF	514.69	514.705	513.905	514.225	2070628.0
2024-03-18 12:00:00	SPY	ETF	514.22	514.515	513.8	514.17	2013457.0
2024-03-18 12:30:00	SPY	ETF	514.18	514.29	513.47	513.5134	2028486.0
2024-03-18 13:00:00	SPY	ETF	513.52	514.215	513.41	514.2	2176452.0
2024-03-18 13:30:00	SPY	ETF	514.21	514.25	513.2901	513.8	2186034.0
2024-03-18 14:00:00	SPY	ETF	513.81	514.38	513.65	514.3402	2498734.0
2024-03-18 14:30:00	SPY	ETF	514.345	514.4	513.21	513.79	2466279.0
2024-03-18 15:00:00	SPY	ETF	513.79	514.145	513.61	513.855	2295905.0
2024-03-18 15:30:00	SPY	ETF	513.86	514.12	512.44	512.87	15695005.0
2024-03-18 16:00:00	SPY	ETF	512.86	513.15	512.58	512.95	5001434.0
2024-03-18 16:30:00	SPY	ETF	512.98	513.11	512.8202	512.9	120077.0
2024-03-18 17:00:00	SPY	ETF	512.98	513.05	512.61	512.95	58724.0
2024-03-18 17:30:00	SPY	ETF	512.98	512.98	512.4	512.8	31011.0
2024-03-18 18:00:00	SPY	ETF	512.9	513.04	512.57	512.85	67927.0
2024-03-18 18:30:00	SPY	ETF	512.85	512.86	512.24	512.3	123729.0
2024-03-18 19:00:00	SPY	ETF	512.26	512.5099	512.1	512.41	21088.0
2024-03-18 19:30:00	SPY	ETF	512.4207	512.47	512.36	512.47	30162.0
2024-03-18 04:00:00	QQQ	ETF	435.12	436.14	435.0	435.52	30969.0
2024-03-18 04:30:00	QQQ	ETF	435.42	436.53	435.42	436.5	25291.0
2024-03-18 05:00:00	QQQ	ETF	436.5	436.71	436.04	436.2	14334.0
2024-03-18 05:30:00	QQQ	ETF	436.23	436.36	436.08	436.25	6190.0
2024-03-18 06:00:00	QQQ	ETF	436.18	436.57	436.18	436.44	18697.0
2024-03-18 06:30:00	QQQ	ETF	436.58	436.91	436.5	436.74	44148.0
2024-03-18 07:00:00	QQQ	ETF	436.75	437.93	436.57	437.91	96846.0
2024-03-18 07:30:00	QQQ	ETF	437.9	438.38	437.86	438.31	85456.0
2024-03-18 08:00:00	QQQ	ETF	436.57	438.79	433.614	438.72	205861.0
2024-03-18 08:30:00	QQQ	ETF	438.8	438.87	438.23	438.51	155096.0
2024-03-18 09:00:00	QQQ	ETF	438.53	438.99	438.4	438.7	249722.0
2024-03-18 09:30:00	QQQ	ETF	438.73	440.58	438.57	438.82	6708453.0
2024-03-18 10:00:00	QQQ	ETF	438.83	441.04	438.78	440.8201	3506725.0
2024-03-18 10:30:00	QQQ	ETF	440.83	441.01	440.1902	440.48	2021015.0
2024-03-18 11:00:00	QQQ	ETF	440.5	440.67	439.09	439.61	2104984.0
2024-03-18 11:30:00	QQQ	ETF	439.61	439.63	438.58	439.02	1669658.0
2024-03-18 12:00:00	QQQ	ETF	439.02	439.48	438.43	438.94	1536102.0
2024-03-18 12:30:00	QQQ	ETF	438.95	439.19	437.845	437.92	1476366.0

> showing 50 of 32,039 rows — these rows as CSV

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