PREVIEW / etf_30min / 2022-10-18

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-10-18.parquet
  size:    682 KB
  rows:    27,492

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
2022-10-18 04:00:00	SPY	ETF	373.05	373.19	372.35	372.54	60666.0
2022-10-18 04:30:00	SPY	ETF	372.64	372.75	370.88	371.02	84973.0
2022-10-18 05:00:00	SPY	ETF	370.83	371.18	370.31	370.7	103411.0
2022-10-18 05:30:00	SPY	ETF	370.75	371.53	370.18	371.5	52556.0
2022-10-18 06:00:00	SPY	ETF	371.44	372.36	371.29	372.02	97199.0
2022-10-18 06:30:00	SPY	ETF	372.0	372.94	371.46	371.67	146978.0
2022-10-18 07:00:00	SPY	ETF	371.71	372.85	371.59	372.57	237621.0
2022-10-18 07:30:00	SPY	ETF	372.66	373.86	372.66	373.5	342355.0
2022-10-18 08:00:00	SPY	ETF	371.72	374.76	370.3204	374.17	875528.0
2022-10-18 08:30:00	SPY	ETF	374.25	375.3	374.25	375.14	693557.0
2022-10-18 09:00:00	SPY	ETF	375.09	375.24	373.83	375.12	728785.0
2022-10-18 09:30:00	SPY	ETF	375.13	375.45	372.45	373.1	9843236.0
2022-10-18 10:00:00	SPY	ETF	373.12	374.37	371.91	371.95	5516272.0
2022-10-18 10:30:00	SPY	ETF	371.9682	372.54	370.9654	371.5	5970214.0
2022-10-18 11:00:00	SPY	ETF	371.49	371.955	368.12	368.725	6014104.0
2022-10-18 11:30:00	SPY	ETF	368.71	369.32	367.52	369.22	5069430.0
2022-10-18 12:00:00	SPY	ETF	369.2	370.8	368.56	369.9396	4995601.0
2022-10-18 12:30:00	SPY	ETF	369.96	371.44	369.58	370.43	4157915.0
2022-10-18 13:00:00	SPY	ETF	370.44	371.3	369.18	371.22	3856035.0
2022-10-18 13:30:00	SPY	ETF	371.24	372.38	370.77	372.04	3637185.0
2022-10-18 14:00:00	SPY	ETF	372.03	372.26	371.02	371.93	2924624.0
2022-10-18 14:30:00	SPY	ETF	371.95	371.97	368.11	369.4	5690952.0
2022-10-18 15:00:00	SPY	ETF	369.4	369.8	368.39	369.674	4005860.0
2022-10-18 15:30:00	SPY	ETF	369.69	371.3	369.47	371.14	9493280.0
2022-10-18 16:00:00	SPY	ETF	371.13	373.39	370.1	373.32	3665272.0
2022-10-18 16:30:00	SPY	ETF	373.3	373.92	373.15	373.55	585671.0
2022-10-18 17:00:00	SPY	ETF	373.67	374.0	371.13	373.87	114192.0
2022-10-18 17:30:00	SPY	ETF	373.94	374.0	373.74	373.79	83608.0
2022-10-18 18:00:00	SPY	ETF	373.76	373.76	372.94	373.33	80842.0
2022-10-18 18:30:00	SPY	ETF	373.25	373.8	373.24	373.7	25970.0
2022-10-18 19:00:00	SPY	ETF	373.75	375.02	373.71	374.58	90225.0
2022-10-18 19:30:00	SPY	ETF	374.53	374.84	373.97	374.1	79679.0
2022-10-18 04:00:00	QQQ	ETF	274.11	274.85	274.03	274.41	102922.0
2022-10-18 04:30:00	QQQ	ETF	274.45	274.59	273.01	273.01	112991.0
2022-10-18 05:00:00	QQQ	ETF	273.01	273.29	272.55	272.97	156966.0
2022-10-18 05:30:00	QQQ	ETF	273.01	273.76	272.65	273.76	82359.0
2022-10-18 06:00:00	QQQ	ETF	273.75	274.29	273.59	273.94	98186.0
2022-10-18 06:30:00	QQQ	ETF	273.92	274.66	273.62	273.7	87248.0
2022-10-18 07:00:00	QQQ	ETF	273.69	274.62	273.67	274.4	157480.0
2022-10-18 07:30:00	QQQ	ETF	274.46	275.35	274.46	275.0	319565.0
2022-10-18 08:00:00	QQQ	ETF	273.75	275.96	269.552	275.53	513349.0
2022-10-18 08:30:00	QQQ	ETF	275.54	276.38	275.53	276.24	641358.0
2022-10-18 09:00:00	QQQ	ETF	276.21	276.68	275.44	276.5	713110.0
2022-10-18 09:30:00	QQQ	ETF	276.54	277.21	273.85	274.1989	7612956.0
2022-10-18 10:00:00	QQQ	ETF	274.2	275.1	273.01	273.05	3571846.0
2022-10-18 10:30:00	QQQ	ETF	273.06	273.5799	271.93	272.68	3688400.0
2022-10-18 11:00:00	QQQ	ETF	272.65	272.96	269.41	269.89	4818623.0
2022-10-18 11:30:00	QQQ	ETF	269.89	270.6518	268.7955	270.59	4256241.0
2022-10-18 12:00:00	QQQ	ETF	270.57	272.13	269.9	271.29	3311782.0
2022-10-18 12:30:00	QQQ	ETF	271.32	272.77	270.95	271.48	2465261.0

> showing 50 of 27,492 rows — these rows as CSV

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