PREVIEW / etf_30min / 2022-10-20

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-10-20.parquet
  size:    668 KB
  rows:    26,604

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-20 04:00:00	SPY	ETF	367.49	367.49	366.13	366.4	28700.0
2022-10-20 04:30:00	SPY	ETF	366.57	367.23	366.57	366.7	5259.0
2022-10-20 05:00:00	SPY	ETF	366.71	367.41	366.7	367.1	62288.0
2022-10-20 05:30:00	SPY	ETF	367.3	367.99	367.22	367.59	16905.0
2022-10-20 06:00:00	SPY	ETF	367.55	367.9	367.27	367.75	60669.0
2022-10-20 06:30:00	SPY	ETF	367.85	370.07	367.83	369.54	127773.0
2022-10-20 07:00:00	SPY	ETF	369.54	370.45	369.29	369.54	209650.0
2022-10-20 07:30:00	SPY	ETF	369.55	369.74	368.77	369.44	145307.0
2022-10-20 08:00:00	SPY	ETF	369.7598	370.78	366.18	370.2	585759.0
2022-10-20 08:30:00	SPY	ETF	370.25	370.89	367.49	367.53	1120128.0
2022-10-20 09:00:00	SPY	ETF	367.53	368.75	367.37	368.04	301576.0
2022-10-20 09:30:00	SPY	ETF	368.01	369.82	367.0	369.1	6722607.0
2022-10-20 10:00:00	SPY	ETF	369.11	372.67	368.975	372.14	5912882.0
2022-10-20 10:30:00	SPY	ETF	372.19	372.48	370.67	371.96	4032309.0
2022-10-20 11:00:00	SPY	ETF	371.97	372.16	369.85	370.2901	4119360.0
2022-10-20 11:30:00	SPY	ETF	370.3	371.46	370.17	370.2201	2932688.0
2022-10-20 12:00:00	SPY	ETF	370.2499	370.3786	367.85	368.17	4816518.0
2022-10-20 12:30:00	SPY	ETF	368.16	368.49	367.19	367.939	3894890.0
2022-10-20 13:00:00	SPY	ETF	367.9219	368.05	366.36	367.14	4150009.0
2022-10-20 13:30:00	SPY	ETF	367.11	367.1999	365.3764	366.11	3963805.0
2022-10-20 14:00:00	SPY	ETF	366.09	366.23	364.67	364.76	3912389.0
2022-10-20 14:30:00	SPY	ETF	364.75	366.22	364.66	365.61	4132893.0
2022-10-20 15:00:00	SPY	ETF	365.6015	366.6199	364.9	365.29	4301116.0
2022-10-20 15:30:00	SPY	ETF	365.28	366.54	364.61	365.43	9181275.0
2022-10-20 16:00:00	SPY	ETF	365.43	366.26	365.25	365.52	3621200.0
2022-10-20 16:30:00	SPY	ETF	365.54	365.87	365.25	365.6	415370.0
2022-10-20 17:00:00	SPY	ETF	365.53	365.8	365.49	365.7	83347.0
2022-10-20 17:30:00	SPY	ETF	365.71	365.8	365.55	365.59	25755.0
2022-10-20 18:00:00	SPY	ETF	365.64	365.68	364.79	364.81	109022.0
2022-10-20 18:30:00	SPY	ETF	364.82	364.82	364.05	364.25	50687.0
2022-10-20 19:00:00	SPY	ETF	364.25	364.35	363.63	363.72	29591.0
2022-10-20 19:30:00	SPY	ETF	363.71	364.19	363.68	364.13	63409.0
2022-10-20 04:00:00	QQQ	ETF	267.93	268.48	267.73	268.09	58693.0
2022-10-20 04:30:00	QQQ	ETF	267.93	268.7	267.93	268.2	15646.0
2022-10-20 05:00:00	QQQ	ETF	268.31	268.79	268.27	268.53	12244.0
2022-10-20 05:30:00	QQQ	ETF	268.67	269.32	268.67	269.0	27805.0
2022-10-20 06:00:00	QQQ	ETF	269.01	269.3	268.67	269.18	25116.0
2022-10-20 06:30:00	QQQ	ETF	269.19	271.2	269.19	270.8	287207.0
2022-10-20 07:00:00	QQQ	ETF	270.8	271.42	270.58	270.6	257607.0
2022-10-20 07:30:00	QQQ	ETF	270.6	270.83	269.94	270.74	249026.0
2022-10-20 08:00:00	QQQ	ETF	271.25	271.83	267.64	271.43	455845.0
2022-10-20 08:30:00	QQQ	ETF	271.41	272.21	268.93	268.95	931075.0
2022-10-20 09:00:00	QQQ	ETF	269.0	270.0	268.91	269.59	296630.0
2022-10-20 09:30:00	QQQ	ETF	269.58	272.46	269.1132	271.79	5646709.0
2022-10-20 10:00:00	QQQ	ETF	271.82	274.84	271.6	274.42	5126435.0
2022-10-20 10:30:00	QQQ	ETF	274.45	274.7	273.24	274.59	2592746.0
2022-10-20 11:00:00	QQQ	ETF	274.6	274.75	272.85	273.28	2520066.0
2022-10-20 11:30:00	QQQ	ETF	273.29	274.42	273.26	273.44	1836568.0
2022-10-20 12:00:00	QQQ	ETF	273.462	273.53	271.18	271.485	3072165.0
2022-10-20 12:30:00	QQQ	ETF	271.48	271.79	270.401	271.14	2667281.0

> showing 50 of 26,604 rows — these rows as CSV

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