PREVIEW / etf_30min / 2023-11-07

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-11-07.parquet
  size:    729 KB
  rows:    29,281

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-11-07 04:00:00	SPY	ETF	434.96	435.0	434.58	434.64	8145.0
2023-11-07 04:30:00	SPY	ETF	434.61	434.8	434.49	434.52	6867.0
2023-11-07 05:00:00	SPY	ETF	434.44	434.96	434.41	434.96	10065.0
2023-11-07 05:30:00	SPY	ETF	434.98	434.98	434.73	434.73	3882.0
2023-11-07 06:00:00	SPY	ETF	434.71	434.72	434.44	434.44	25413.0
2023-11-07 06:30:00	SPY	ETF	434.44	434.44	433.94	434.36	127987.0
2023-11-07 07:00:00	SPY	ETF	434.4	434.77	434.36	434.56	91946.0
2023-11-07 07:30:00	SPY	ETF	434.57	434.76	434.34	434.76	161610.0
2023-11-07 08:00:00	SPY	ETF	434.6	435.2	434.15	434.74	208372.0
2023-11-07 08:30:00	SPY	ETF	434.82	435.35	434.77	435.34	61288.0
2023-11-07 09:00:00	SPY	ETF	435.35	435.8	434.96	435.69	355770.0
2023-11-07 09:30:00	SPY	ETF	435.69	435.73	434.51	435.555	5420638.0
2023-11-07 10:00:00	SPY	ETF	435.55	436.48	435.39	436.45	4595786.0
2023-11-07 10:30:00	SPY	ETF	436.44	437.44	436.335	437.17	4205403.0
2023-11-07 11:00:00	SPY	ETF	437.17	437.22	436.8	437.035	2912068.0
2023-11-07 11:30:00	SPY	ETF	437.04	437.51	436.62	436.87	2998382.0
2023-11-07 12:00:00	SPY	ETF	436.885	436.8899	436.04	436.29	2528951.0
2023-11-07 12:30:00	SPY	ETF	436.3	436.78	435.86	436.7	2638657.0
2023-11-07 13:00:00	SPY	ETF	436.7	437.24	436.56	437.04	2348037.0
2023-11-07 13:30:00	SPY	ETF	437.035	437.47	436.94	437.225	2841204.0
2023-11-07 14:00:00	SPY	ETF	437.22	437.46	437.06	437.32	1902984.0
2023-11-07 14:30:00	SPY	ETF	437.33	437.44	436.81	436.88	2334449.0
2023-11-07 15:00:00	SPY	ETF	436.9	437.25	436.64	437.2	2887851.0
2023-11-07 15:30:00	SPY	ETF	437.21	437.585	436.21	436.87	9629029.0
2023-11-07 16:00:00	SPY	ETF	436.86	437.0467	436.7576	437.0	2282561.0
2023-11-07 16:30:00	SPY	ETF	437.0	437.04	436.87	437.02	119585.0
2023-11-07 17:00:00	SPY	ETF	437.02	437.04	436.96	437.03	60095.0
2023-11-07 17:30:00	SPY	ETF	437.0	437.05	436.96	437.0	13633.0
2023-11-07 18:00:00	SPY	ETF	437.0	437.0	436.78	436.83	39841.0
2023-11-07 18:30:00	SPY	ETF	436.84	436.84	436.75	436.7705	4828.0
2023-11-07 19:00:00	SPY	ETF	436.79	436.91	436.76	436.89	10617.0
2023-11-07 19:30:00	SPY	ETF	436.89	436.9	436.68	436.71	14631.0
2023-11-07 04:00:00	QQQ	ETF	369.0	369.02	368.36	368.49	15905.0
2023-11-07 04:30:00	QQQ	ETF	368.42	368.6	368.29	368.29	4805.0
2023-11-07 05:00:00	QQQ	ETF	368.32	368.8	368.2	368.77	28768.0
2023-11-07 05:30:00	QQQ	ETF	368.74	368.76	368.5	368.5	3045.0
2023-11-07 06:00:00	QQQ	ETF	368.58	368.58	368.29	368.32	9034.0
2023-11-07 06:30:00	QQQ	ETF	368.29	368.3	367.99	368.3	24986.0
2023-11-07 07:00:00	QQQ	ETF	368.31	369.05	368.31	368.9	85051.0
2023-11-07 07:30:00	QQQ	ETF	368.87	369.0	368.66	369.0	82403.0
2023-11-07 08:00:00	QQQ	ETF	368.89	369.49	367.9196	369.13	186962.0
2023-11-07 08:30:00	QQQ	ETF	369.13	369.75	369.11	369.75	181795.0
2023-11-07 09:00:00	QQQ	ETF	369.74	370.48	369.53	370.25	466926.0
2023-11-07 09:30:00	QQQ	ETF	370.27	370.945	369.045	370.8101	4914348.0
2023-11-07 10:00:00	QQQ	ETF	370.82	371.93	370.225	371.8	3889586.0
2023-11-07 10:30:00	QQQ	ETF	371.79	373.1872	371.73	372.9709	3665869.0
2023-11-07 11:00:00	QQQ	ETF	372.98	373.1	372.61	372.93	2333691.0
2023-11-07 11:30:00	QQQ	ETF	372.93	373.35	372.21	372.68	2770443.0
2023-11-07 12:00:00	QQQ	ETF	372.68	372.69	371.84	371.99	2252343.0
2023-11-07 12:30:00	QQQ	ETF	372.0	372.73	371.6	372.6205	2137384.0

> showing 50 of 29,281 rows — these rows as CSV

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