PREVIEW / etf_30min / 2023-10-18

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-10-18.parquet
  size:    714 KB
  rows:    28,538

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-18 04:00:00	SPY	ETF	435.18	435.2	434.72	435.11	14049.0
2023-10-18 04:30:00	SPY	ETF	435.13	435.6	435.05	435.39	6407.0
2023-10-18 05:00:00	SPY	ETF	435.33	435.6	434.89	434.89	11856.0
2023-10-18 05:30:00	SPY	ETF	434.71	434.76	434.53	434.59	28629.0
2023-10-18 06:00:00	SPY	ETF	434.53	434.7	433.92	434.12	19636.0
2023-10-18 06:30:00	SPY	ETF	434.12	434.21	433.81	434.08	47662.0
2023-10-18 07:00:00	SPY	ETF	434.1	434.42	434.01	434.32	127092.0
2023-10-18 07:30:00	SPY	ETF	434.29	434.54	434.18	434.36	50666.0
2023-10-18 08:00:00	SPY	ETF	434.24	435.57	434.04	434.5	172939.0
2023-10-18 08:30:00	SPY	ETF	434.49	434.6799	433.69	433.8	217310.0
2023-10-18 09:00:00	SPY	ETF	433.72	434.36	433.72	434.14	201745.0
2023-10-18 09:30:00	SPY	ETF	434.19	434.78	433.52	433.99	5625961.0
2023-10-18 10:00:00	SPY	ETF	433.99	435.18	433.2	433.56	6189482.0
2023-10-18 10:30:00	SPY	ETF	433.55	433.74	432.21	432.55	5975844.0
2023-10-18 11:00:00	SPY	ETF	432.572	433.58	432.23	432.87	4625223.0
2023-10-18 11:30:00	SPY	ETF	432.87	433.31	432.435	432.51	3454311.0
2023-10-18 12:00:00	SPY	ETF	432.52	433.49	431.81	432.01	4348123.0
2023-10-18 12:30:00	SPY	ETF	432.02	432.31	431.4	431.53	3677608.0
2023-10-18 13:00:00	SPY	ETF	431.51	433.81	431.09	433.02	6857583.0
2023-10-18 13:30:00	SPY	ETF	433.0	433.005	431.31	432.49	5136176.0
2023-10-18 14:00:00	SPY	ETF	432.49	433.28	431.85	432.061	3616234.0
2023-10-18 14:30:00	SPY	ETF	432.06	432.58	430.815	431.21	4243887.0
2023-10-18 15:00:00	SPY	ETF	431.21	431.215	430.29	430.47	4612005.0
2023-10-18 15:30:00	SPY	ETF	430.47	430.785	429.09	430.25	15203737.0
2023-10-18 16:00:00	SPY	ETF	430.24	435.0607	430.21	430.85	3457217.0
2023-10-18 16:30:00	SPY	ETF	430.89	430.95	430.71	430.73	283994.0
2023-10-18 17:00:00	SPY	ETF	430.79	431.0	430.79	430.96	52326.0
2023-10-18 17:30:00	SPY	ETF	430.95	430.95	430.7	430.7	33500.0
2023-10-18 18:00:00	SPY	ETF	430.7	430.7	430.17	430.4	76072.0
2023-10-18 18:30:00	SPY	ETF	430.6	430.75	430.1	430.1	32947.0
2023-10-18 19:00:00	SPY	ETF	430.14	430.28	430.03	430.24	22676.0
2023-10-18 19:30:00	SPY	ETF	430.25	430.41	430.06	430.4	43361.0
2023-10-18 04:00:00	QQQ	ETF	367.3	367.36	366.83	367.15	24564.0
2023-10-18 04:30:00	QQQ	ETF	367.1	367.65	367.02	367.45	11960.0
2023-10-18 05:00:00	QQQ	ETF	367.34	367.64	366.83	366.83	13535.0
2023-10-18 05:30:00	QQQ	ETF	366.8	366.8	366.24	366.49	55427.0
2023-10-18 06:00:00	QQQ	ETF	366.56	366.76	366.13	366.34	27054.0
2023-10-18 06:30:00	QQQ	ETF	366.34	366.34	365.87	366.0	185554.0
2023-10-18 07:00:00	QQQ	ETF	366.04	366.54	365.97	366.45	143470.0
2023-10-18 07:30:00	QQQ	ETF	366.29	366.57	366.18	366.25	64029.0
2023-10-18 08:00:00	QQQ	ETF	366.22	368.476	365.99	366.45	197399.0
2023-10-18 08:30:00	QQQ	ETF	366.49	366.63	365.55	365.6	465344.0
2023-10-18 09:00:00	QQQ	ETF	365.63	366.1	365.52	365.53	220347.0
2023-10-18 09:30:00	QQQ	ETF	365.66	367.33	365.48	366.5	4535993.0
2023-10-18 10:00:00	QQQ	ETF	366.51	367.91	365.48	366.32	3789634.0
2023-10-18 10:30:00	QQQ	ETF	366.31	366.32	364.7799	364.95	3536265.0
2023-10-18 11:00:00	QQQ	ETF	364.96	366.33	364.905	365.66	2522456.0
2023-10-18 11:30:00	QQQ	ETF	365.66	366.2934	365.3547	365.62	2055847.0
2023-10-18 12:00:00	QQQ	ETF	365.65	366.78	365.1199	365.24	2884207.0
2023-10-18 12:30:00	QQQ	ETF	365.26	365.48	364.465	364.66	2065788.0

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

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