PREVIEW / etf_30min / 2022-10-17

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-10-17.parquet
  size:    666 KB
  rows:    26,875

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-17 04:00:00	SPY	ETF	360.02	361.46	360.02	360.7	66354.0
2022-10-17 04:30:00	SPY	ETF	360.42	361.1	360.25	360.76	17191.0
2022-10-17 05:00:00	SPY	ETF	361.01	361.37	360.72	361.37	22305.0
2022-10-17 05:30:00	SPY	ETF	361.35	361.76	361.35	361.67	22617.0
2022-10-17 06:00:00	SPY	ETF	361.64	362.61	361.63	361.98	55128.0
2022-10-17 06:30:00	SPY	ETF	361.91	362.33	361.5	362.17	89190.0
2022-10-17 07:00:00	SPY	ETF	362.19	362.29	361.38	361.78	421711.0
2022-10-17 07:30:00	SPY	ETF	361.78	362.02	361.58	361.95	163409.0
2022-10-17 08:00:00	SPY	ETF	362.08	362.4	358.88	361.94	444834.0
2022-10-17 08:30:00	SPY	ETF	361.92	362.84	361.58	362.65	537158.0
2022-10-17 09:00:00	SPY	ETF	362.69	364.1	362.69	364.02	676540.0
2022-10-17 09:30:00	SPY	ETF	364.0	367.38	363.97	365.87	11336430.0
2022-10-17 10:00:00	SPY	ETF	365.85	367.9799	365.58	366.725	6724883.0
2022-10-17 10:30:00	SPY	ETF	366.72	367.14	364.8895	365.45	5223375.0
2022-10-17 11:00:00	SPY	ETF	365.45	366.45	364.6	366.37	3915758.0
2022-10-17 11:30:00	SPY	ETF	366.38	367.48	366.0901	366.905	3840224.0
2022-10-17 12:00:00	SPY	ETF	366.9	367.6	366.16	366.84	2971488.0
2022-10-17 12:30:00	SPY	ETF	366.8474	367.39	365.96	366.5137	2836248.0
2022-10-17 13:00:00	SPY	ETF	366.515	367.3105	365.91	367.0394	3123598.0
2022-10-17 13:30:00	SPY	ETF	367.03	367.69	366.9	367.41	2803213.0
2022-10-17 14:00:00	SPY	ETF	367.4	367.92	366.25	366.74	2859462.0
2022-10-17 14:30:00	SPY	ETF	366.74	367.37	366.38	366.82	2746982.0
2022-10-17 15:00:00	SPY	ETF	366.81	367.07	366.22	366.98	4044464.0
2022-10-17 15:30:00	SPY	ETF	366.98	367.61	366.34	366.8	11799565.0
2022-10-17 16:00:00	SPY	ETF	366.8	367.8	366.61	367.67	4835118.0
2022-10-17 16:30:00	SPY	ETF	367.61	368.0	367.5	367.69	361592.0
2022-10-17 17:00:00	SPY	ETF	367.69	368.0	367.6	368.0	126710.0
2022-10-17 17:30:00	SPY	ETF	368.0	368.24	367.93	368.2	67190.0
2022-10-17 18:00:00	SPY	ETF	368.2	369.48	368.2	369.29	406813.0
2022-10-17 18:30:00	SPY	ETF	369.2	369.28	366.82	369.22	63288.0
2022-10-17 19:00:00	SPY	ETF	369.22	369.68	369.12	369.65	65811.0
2022-10-17 19:30:00	SPY	ETF	369.57	370.02	369.47	369.78	166159.0
2022-10-17 04:00:00	QQQ	ETF	263.16	263.99	263.0	263.02	101100.0
2022-10-17 04:30:00	QQQ	ETF	262.96	263.64	262.96	263.51	14936.0
2022-10-17 05:00:00	QQQ	ETF	263.61	263.84	263.31	263.84	39211.0
2022-10-17 05:30:00	QQQ	ETF	263.88	264.05	263.78	263.95	47618.0
2022-10-17 06:00:00	QQQ	ETF	263.82	264.69	263.8	264.14	71089.0
2022-10-17 06:30:00	QQQ	ETF	264.09	264.55	263.76	264.48	61873.0
2022-10-17 07:00:00	QQQ	ETF	264.43	264.57	263.85	264.17	190185.0
2022-10-17 07:30:00	QQQ	ETF	264.19	264.42	264.0	264.4	96068.0
2022-10-17 08:00:00	QQQ	ETF	264.39	264.61	260.935	264.54	393481.0
2022-10-17 08:30:00	QQQ	ETF	264.52	265.55	264.31	265.42	741306.0
2022-10-17 09:00:00	QQQ	ETF	265.42	266.97	265.42	266.88	1314833.0
2022-10-17 09:30:00	QQQ	ETF	266.79	269.56	266.74	268.52	9651724.0
2022-10-17 10:00:00	QQQ	ETF	268.52	269.96	268.15	268.92	3937431.0
2022-10-17 10:30:00	QQQ	ETF	268.925	269.3799	267.4	267.85	3860189.0
2022-10-17 11:00:00	QQQ	ETF	267.85	268.97	267.2709	268.93	2513443.0
2022-10-17 11:30:00	QQQ	ETF	268.92	270.0	268.64	269.5	2810173.0
2022-10-17 12:00:00	QQQ	ETF	269.49	269.91	268.71	269.21	2131868.0
2022-10-17 12:30:00	QQQ	ETF	269.23	269.705	268.6	269.03	1987925.0

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

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