PREVIEW / etf_30min / 2023-10-10

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-10-10.parquet
  size:    712 KB
  rows:    28,267

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-10-10 04:00:00	SPY	ETF	432.64	433.25	432.32	433.12	44408.0
2023-10-10 04:30:00	SPY	ETF	433.21	433.43	432.94	433.32	31986.0
2023-10-10 05:00:00	SPY	ETF	433.34	433.34	432.87	433.15	28186.0
2023-10-10 05:30:00	SPY	ETF	433.16	433.22	432.94	433.09	11996.0
2023-10-10 06:00:00	SPY	ETF	433.07	433.34	432.98	433.34	7645.0
2023-10-10 06:30:00	SPY	ETF	433.33	433.44	433.0	433.0	21602.0
2023-10-10 07:00:00	SPY	ETF	432.97	433.1	432.35	432.35	160354.0
2023-10-10 07:30:00	SPY	ETF	432.47	432.84	432.07	432.16	91641.0
2023-10-10 08:00:00	SPY	ETF	433.04	433.28	432.02	432.4	215821.0
2023-10-10 08:30:00	SPY	ETF	432.4	432.88	432.32	432.82	221077.0
2023-10-10 09:00:00	SPY	ETF	432.82	433.06	432.5	432.95	262043.0
2023-10-10 09:30:00	SPY	ETF	432.94	433.65	432.53	433.64	5443600.0
2023-10-10 10:00:00	SPY	ETF	433.64	435.25	433.63	435.04	6009963.0
2023-10-10 10:30:00	SPY	ETF	435.05	435.7	434.9	435.3076	5789840.0
2023-10-10 11:00:00	SPY	ETF	435.33	436.64	435.14	436.38	5070918.0
2023-10-10 11:30:00	SPY	ETF	436.38	437.1	436.24	436.98	3747950.0
2023-10-10 12:00:00	SPY	ETF	437.0	437.22	436.66	437.04	2690685.0
2023-10-10 12:30:00	SPY	ETF	437.06	437.14	436.5762	436.825	2168316.0
2023-10-10 13:00:00	SPY	ETF	436.83	436.835	434.66	435.38	6815423.0
2023-10-10 13:30:00	SPY	ETF	435.41	435.705	434.825	435.43	3410787.0
2023-10-10 14:00:00	SPY	ETF	435.4399	435.645	434.5	434.767	3320131.0
2023-10-10 14:30:00	SPY	ETF	434.79	435.73	434.29	434.6022	3721592.0
2023-10-10 15:00:00	SPY	ETF	434.61	435.16	434.465	434.7414	3061845.0
2023-10-10 15:30:00	SPY	ETF	434.745	435.14	434.325	434.48	10397894.0
2023-10-10 16:00:00	SPY	ETF	434.48	436.8409	433.6264	434.52	2157007.0
2023-10-10 16:30:00	SPY	ETF	434.52	434.56	434.47	434.48	115654.0
2023-10-10 17:00:00	SPY	ETF	434.45	434.57	434.45	434.47	20238.0
2023-10-10 17:30:00	SPY	ETF	434.55	434.55	434.36	434.47	21542.0
2023-10-10 18:00:00	SPY	ETF	434.45	434.5899	434.31	434.46	15626.0
2023-10-10 18:30:00	SPY	ETF	434.46	434.58	434.46	434.5	12951.0
2023-10-10 19:00:00	SPY	ETF	434.55	434.69	434.55	434.68	12071.0
2023-10-10 19:30:00	SPY	ETF	434.68	434.69	434.59	434.65	30432.0
2023-10-10 04:00:00	QQQ	ETF	367.2	367.7	366.75	367.7	52159.0
2023-10-10 04:30:00	QQQ	ETF	367.67	367.79	367.31	367.58	16092.0
2023-10-10 05:00:00	QQQ	ETF	367.52	367.52	367.16	367.45	12825.0
2023-10-10 05:30:00	QQQ	ETF	367.29	367.52	367.25	367.39	6449.0
2023-10-10 06:00:00	QQQ	ETF	367.29	367.77	367.26	367.76	5914.0
2023-10-10 06:30:00	QQQ	ETF	367.73	367.77	367.32	367.33	23092.0
2023-10-10 07:00:00	QQQ	ETF	367.31	367.42	366.44	366.46	110434.0
2023-10-10 07:30:00	QQQ	ETF	366.52	367.07	366.24	366.4	59696.0
2023-10-10 08:00:00	QQQ	ETF	367.29	367.72	366.35	366.65	224916.0
2023-10-10 08:30:00	QQQ	ETF	366.68	367.0	366.37	366.729	104840.0
2023-10-10 09:00:00	QQQ	ETF	366.7	367.01	366.46	366.9	150202.0
2023-10-10 09:30:00	QQQ	ETF	366.91	367.88	366.39	367.86	3614017.0
2023-10-10 10:00:00	QQQ	ETF	367.86	369.16	367.7988	369.02	3858497.0
2023-10-10 10:30:00	QQQ	ETF	369.05	369.91	368.95	369.678	3173049.0
2023-10-10 11:00:00	QQQ	ETF	369.68	370.695	369.5	370.51	3122061.0
2023-10-10 11:30:00	QQQ	ETF	370.51	371.28	370.44	371.0099	2271143.0
2023-10-10 12:00:00	QQQ	ETF	371.0	371.09	370.4903	370.96	1857601.0
2023-10-10 12:30:00	QQQ	ETF	370.96	371.05	370.525	370.715	1427972.0

> showing 50 of 28,267 rows — these rows as CSV

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