PREVIEW / etf_30min / 2022-10-21

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-10-21.parquet
  size:    674 KB
  rows:    27,108

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-21 04:00:00	SPY	ETF	364.0	364.22	363.23	363.3	36943.0
2022-10-21 04:30:00	SPY	ETF	363.26	363.4	363.07	363.18	7075.0
2022-10-21 05:00:00	SPY	ETF	363.36	363.51	362.75	363.0	22819.0
2022-10-21 05:30:00	SPY	ETF	363.39	363.79	362.9	363.69	72074.0
2022-10-21 06:00:00	SPY	ETF	363.63	363.83	363.14	363.14	11924.0
2022-10-21 06:30:00	SPY	ETF	363.29	364.1	363.12	363.92	46383.0
2022-10-21 07:00:00	SPY	ETF	363.91	364.45	363.5	364.23	141915.0
2022-10-21 07:30:00	SPY	ETF	364.25	364.49	363.3	363.35	304687.0
2022-10-21 08:00:00	SPY	ETF	363.66	365.67	362.25	362.6201	634774.0
2022-10-21 08:30:00	SPY	ETF	362.62	363.74	362.2	363.59	829235.0
2022-10-21 09:00:00	SPY	ETF	363.59	366.92	363.42	365.12	3501481.0
2022-10-21 09:30:00	SPY	ETF	365.12	369.125	363.54	369.08	10483117.0
2022-10-21 10:00:00	SPY	ETF	369.11	370.63	367.27	367.35	7691202.0
2022-10-21 10:30:00	SPY	ETF	367.36	368.47	366.285	366.784	5559739.0
2022-10-21 11:00:00	SPY	ETF	366.79	368.1	365.79	367.75	3808102.0
2022-10-21 11:30:00	SPY	ETF	367.8	370.0378	367.6	370.0299	4505435.0
2022-10-21 12:00:00	SPY	ETF	370.03	371.21	369.25	369.4	5003035.0
2022-10-21 12:30:00	SPY	ETF	369.41	371.92	369.24	371.29	4581649.0
2022-10-21 13:00:00	SPY	ETF	371.32	371.97	370.71	371.3399	3464519.0
2022-10-21 13:30:00	SPY	ETF	371.34	372.66	371.225	372.6	3558613.0
2022-10-21 14:00:00	SPY	ETF	372.62	373.36	372.04	372.61	4283090.0
2022-10-21 14:30:00	SPY	ETF	372.58	373.03	372.14	372.9	3213305.0
2022-10-21 15:00:00	SPY	ETF	372.9	374.665	372.73	374.64	4732199.0
2022-10-21 15:30:00	SPY	ETF	374.63	374.8	373.875	374.28	12297091.0
2022-10-21 16:00:00	SPY	ETF	374.285	375.05	374.1	375.0	6816003.0
2022-10-21 16:30:00	SPY	ETF	375.0	375.15	374.27	375.02	713744.0
2022-10-21 17:00:00	SPY	ETF	375.0	375.1	374.29	375.03	88809.0
2022-10-21 17:30:00	SPY	ETF	375.05	375.4	374.95	375.16	56284.0
2022-10-21 18:00:00	SPY	ETF	375.19	375.4	375.11	375.4	22609.0
2022-10-21 18:30:00	SPY	ETF	375.4	375.6	375.38	375.5	28202.0
2022-10-21 19:00:00	SPY	ETF	375.48	375.5	375.28	375.41	34185.0
2022-10-21 19:30:00	SPY	ETF	375.44	375.6	375.3	375.45	41009.0
2022-10-21 04:00:00	QQQ	ETF	267.02	267.48	266.73	266.82	55213.0
2022-10-21 04:30:00	QQQ	ETF	266.65	266.78	266.39	266.58	19597.0
2022-10-21 05:00:00	QQQ	ETF	266.74	266.9	266.16	266.49	27442.0
2022-10-21 05:30:00	QQQ	ETF	266.71	267.09	266.37	266.94	85678.0
2022-10-21 06:00:00	QQQ	ETF	266.92	267.1	266.52	266.73	29776.0
2022-10-21 06:30:00	QQQ	ETF	266.71	267.14	266.52	267.0	50936.0
2022-10-21 07:00:00	QQQ	ETF	266.97	267.56	266.66	267.39	118987.0
2022-10-21 07:30:00	QQQ	ETF	267.37	267.57	266.47	266.51	273174.0
2022-10-21 08:00:00	QQQ	ETF	266.9	269.311	265.49	265.74	564354.0
2022-10-21 08:30:00	QQQ	ETF	265.69	266.78	265.43	266.53	584684.0
2022-10-21 09:00:00	QQQ	ETF	266.5	269.41	266.5	268.0	3187600.0
2022-10-21 09:30:00	QQQ	ETF	267.98	270.75	266.8236	270.75	9178484.0
2022-10-21 10:00:00	QQQ	ETF	270.75	272.38	269.54	269.58	5568604.0
2022-10-21 10:30:00	QQQ	ETF	269.585	270.715	268.85	269.1	4176197.0
2022-10-21 11:00:00	QQQ	ETF	269.11	270.1237	268.19	269.87	3241855.0
2022-10-21 11:30:00	QQQ	ETF	269.93	272.1	269.77	272.07	2611020.0
2022-10-21 12:00:00	QQQ	ETF	272.1	272.96	271.33	271.46	3219251.0
2022-10-21 12:30:00	QQQ	ETF	271.44	273.15	271.28	272.58	2708025.0

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

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