PREVIEW / etf_30min / 2023-10-16

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-10-16.parquet
  size:    702 KB
  rows:    28,243

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-10-16 04:00:00	SPY	ETF	432.09	432.14	431.3	432.1	20795.0
2023-10-16 04:30:00	SPY	ETF	432.1	432.65	432.1	432.34	21399.0
2023-10-16 05:00:00	SPY	ETF	432.29	432.5	432.18	432.19	3363.0
2023-10-16 05:30:00	SPY	ETF	432.3	432.53	432.3	432.45	2618.0
2023-10-16 06:00:00	SPY	ETF	432.33	432.38	431.89	432.2	17985.0
2023-10-16 06:30:00	SPY	ETF	432.24	432.73	432.24	432.73	27320.0
2023-10-16 07:00:00	SPY	ETF	432.73	432.8	432.35	432.72	122157.0
2023-10-16 07:30:00	SPY	ETF	432.75	433.38	432.6	433.0	174956.0
2023-10-16 08:00:00	SPY	ETF	432.59	433.34	431.95	432.66	241940.0
2023-10-16 08:30:00	SPY	ETF	432.66	434.01	432.66	433.88	320599.0
2023-10-16 09:00:00	SPY	ETF	433.9	434.14	433.6	433.81	444909.0
2023-10-16 09:30:00	SPY	ETF	433.81	434.76	433.57	434.3	5936343.0
2023-10-16 10:00:00	SPY	ETF	434.3	435.95	433.81	435.925	5360340.0
2023-10-16 10:30:00	SPY	ETF	435.92	436.85	435.87	436.82	5870781.0
2023-10-16 11:00:00	SPY	ETF	436.82	437.14	436.25	436.57	3691488.0
2023-10-16 11:30:00	SPY	ETF	436.57	436.7	435.485	435.955	3133314.0
2023-10-16 12:00:00	SPY	ETF	435.96	436.23	435.67	436.09	2365852.0
2023-10-16 12:30:00	SPY	ETF	436.07	436.22	435.47	435.975	1847203.0
2023-10-16 13:00:00	SPY	ETF	435.98	436.86	434.32	435.64	5026024.0
2023-10-16 13:30:00	SPY	ETF	435.65	436.58	435.45	436.46	3080642.0
2023-10-16 14:00:00	SPY	ETF	436.47	436.72	435.88	435.95	2518361.0
2023-10-16 14:30:00	SPY	ETF	435.95	436.55	435.605	436.51	2495430.0
2023-10-16 15:00:00	SPY	ETF	436.5101	436.92	436.08	436.88	3179949.0
2023-10-16 15:30:00	SPY	ETF	436.89	436.96	435.77	436.01	13041958.0
2023-10-16 16:00:00	SPY	ETF	436.01	437.0	434.4177	436.45	3329152.0
2023-10-16 16:30:00	SPY	ETF	436.45	436.47	436.27	436.39	119834.0
2023-10-16 17:00:00	SPY	ETF	436.33	436.53	436.33	436.49	51347.0
2023-10-16 17:30:00	SPY	ETF	436.47	436.49	436.4313	436.45	18832.0
2023-10-16 18:00:00	SPY	ETF	436.45	436.45	436.19	436.23	56799.0
2023-10-16 18:30:00	SPY	ETF	436.17	436.19	435.93	435.93	25642.0
2023-10-16 19:00:00	SPY	ETF	435.94	435.98	435.57	435.81	42488.0
2023-10-16 19:30:00	SPY	ETF	435.82	436.1	435.82	436.03	27295.0
2023-10-16 04:00:00	QQQ	ETF	365.0	365.42	364.42	365.42	98945.0
2023-10-16 04:30:00	QQQ	ETF	365.36	365.85	365.36	365.6	26490.0
2023-10-16 05:00:00	QQQ	ETF	365.58	365.63	365.29	365.38	28461.0
2023-10-16 05:30:00	QQQ	ETF	365.35	365.65	365.29	365.34	78852.0
2023-10-16 06:00:00	QQQ	ETF	365.32	365.32	364.58	364.99	90703.0
2023-10-16 06:30:00	QQQ	ETF	365.2	365.52	365.1	365.5	39273.0
2023-10-16 07:00:00	QQQ	ETF	365.49	365.6	365.13	365.54	72041.0
2023-10-16 07:30:00	QQQ	ETF	365.59	366.13	365.4	365.86	232217.0
2023-10-16 08:00:00	QQQ	ETF	366.21	366.8	365.1196	365.59	334699.0
2023-10-16 08:30:00	QQQ	ETF	365.68	366.71	365.64	366.55	248376.0
2023-10-16 09:00:00	QQQ	ETF	366.57	366.92	366.38	366.63	286404.0
2023-10-16 09:30:00	QQQ	ETF	366.63	368.66	366.47	367.87	5480961.0
2023-10-16 10:00:00	QQQ	ETF	367.88	369.62	367.45	369.57	3576812.0
2023-10-16 10:30:00	QQQ	ETF	369.57	370.22	369.25	369.8092	2937611.0
2023-10-16 11:00:00	QQQ	ETF	369.81	370.135	369.09	369.66	1964192.0
2023-10-16 11:30:00	QQQ	ETF	369.66	369.83	368.78	368.9	1691176.0
2023-10-16 12:00:00	QQQ	ETF	368.9	369.24	368.57	369.1701	1222033.0
2023-10-16 12:30:00	QQQ	ETF	369.17	369.355	368.64	369.17	1126194.0

> showing 50 of 28,243 rows — these rows as CSV

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