PREVIEW / etf_30min / 2023-11-08

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-11-08.parquet
  size:    721 KB
  rows:    29,056

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-08 04:00:00	SPY	ETF	436.64	436.73	436.5	436.66	4747.0
2023-11-08 04:30:00	SPY	ETF	436.39	436.82	436.39	436.68	13106.0
2023-11-08 05:00:00	SPY	ETF	436.71	436.72	436.48	436.53	2872.0
2023-11-08 05:30:00	SPY	ETF	436.51	436.84	436.49	436.8	4184.0
2023-11-08 06:00:00	SPY	ETF	436.81	437.12	436.81	437.12	7811.0
2023-11-08 06:30:00	SPY	ETF	437.07	437.2	437.02	437.02	9890.0
2023-11-08 07:00:00	SPY	ETF	437.01	437.06	436.78	437.04	18940.0
2023-11-08 07:30:00	SPY	ETF	437.0	437.2	436.92	437.2	33743.0
2023-11-08 08:00:00	SPY	ETF	436.9	437.44	436.22	437.14	120134.0
2023-11-08 08:30:00	SPY	ETF	437.22	437.29	437.0	437.22	42409.0
2023-11-08 09:00:00	SPY	ETF	437.28	437.73	437.25	437.53	225280.0
2023-11-08 09:30:00	SPY	ETF	437.53	438.09	437.39	437.71	5131944.0
2023-11-08 10:00:00	SPY	ETF	437.71	437.82	436.71	436.96	4059676.0
2023-11-08 10:30:00	SPY	ETF	436.95	437.14	436.51	436.585	3451826.0
2023-11-08 11:00:00	SPY	ETF	436.595	437.17	436.2	436.51	2985613.0
2023-11-08 11:30:00	SPY	ETF	436.51	436.8808	436.03	436.09	2893191.0
2023-11-08 12:00:00	SPY	ETF	436.09	436.1467	434.87	435.5	4010479.0
2023-11-08 12:30:00	SPY	ETF	435.5	435.8799	435.22	435.8188	1892920.0
2023-11-08 13:00:00	SPY	ETF	435.83	436.5	435.61	436.35	3376330.0
2023-11-08 13:30:00	SPY	ETF	436.36	436.7	436.32	436.565	2303241.0
2023-11-08 14:00:00	SPY	ETF	436.555	437.09	436.44	437.02	2181263.0
2023-11-08 14:30:00	SPY	ETF	437.02	437.2	436.44	436.51	2310533.0
2023-11-08 15:00:00	SPY	ETF	436.52	437.06	436.49	436.9404	2247029.0
2023-11-08 15:30:00	SPY	ETF	436.93	437.8	436.7203	437.2	9062575.0
2023-11-08 16:00:00	SPY	ETF	437.2	437.25	436.76	436.84	2959481.0
2023-11-08 16:30:00	SPY	ETF	436.84	436.87	436.72	436.72	150642.0
2023-11-08 17:00:00	SPY	ETF	436.72	436.85	436.68	436.81	47726.0
2023-11-08 17:30:00	SPY	ETF	436.75	436.81	436.68	436.68	10014.0
2023-11-08 18:00:00	SPY	ETF	436.63	436.63	436.37	436.52	34443.0
2023-11-08 18:30:00	SPY	ETF	436.61	436.62	436.48	436.62	81544.0
2023-11-08 19:00:00	SPY	ETF	436.65	436.74	436.52	436.58	10308.0
2023-11-08 19:30:00	SPY	ETF	436.63	436.66	436.57	436.63	22534.0
2023-11-08 04:00:00	QQQ	ETF	372.3	372.3	372.0	372.05	23395.0
2023-11-08 04:30:00	QQQ	ETF	372.09	372.54	372.06	372.39	8956.0
2023-11-08 05:00:00	QQQ	ETF	372.33	372.53	372.17	372.18	13983.0
2023-11-08 05:30:00	QQQ	ETF	372.16	372.59	372.16	372.5	6880.0
2023-11-08 06:00:00	QQQ	ETF	372.57	372.63	372.41	372.61	9964.0
2023-11-08 06:30:00	QQQ	ETF	372.58	372.79	372.5	372.57	45806.0
2023-11-08 07:00:00	QQQ	ETF	372.6	372.68	372.33	372.62	24771.0
2023-11-08 07:30:00	QQQ	ETF	372.59	372.82	372.51	372.82	54212.0
2023-11-08 08:00:00	QQQ	ETF	372.4703	373.09	371.85	372.77	138042.0
2023-11-08 08:30:00	QQQ	ETF	372.8	372.82	372.51	372.73	55924.0
2023-11-08 09:00:00	QQQ	ETF	372.72	373.12	372.68	373.09	189736.0
2023-11-08 09:30:00	QQQ	ETF	373.08	373.79	372.76	373.0993	4512882.0
2023-11-08 10:00:00	QQQ	ETF	373.11	373.2306	371.89	372.15	2983697.0
2023-11-08 10:30:00	QQQ	ETF	372.14	372.42	371.78	371.98	1945209.0
2023-11-08 11:00:00	QQQ	ETF	371.975	372.56	371.68	372.05	2161685.0
2023-11-08 11:30:00	QQQ	ETF	372.045	372.61	371.81	371.84	1865033.0
2023-11-08 12:00:00	QQQ	ETF	371.85	371.91	370.62	371.29	2083523.0
2023-11-08 12:30:00	QQQ	ETF	371.28	371.765	371.06	371.6302	1040681.0

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

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