PREVIEW / etf_30min / 2023-06-13

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-06-13.parquet
  size:    736 KB
  rows:    28,629

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-06-13 04:00:00	SPY	ETF	434.74	435.04	434.63	434.95	44211.0
2023-06-13 04:30:00	SPY	ETF	434.96	435.09	434.88	434.96	13424.0
2023-06-13 05:00:00	SPY	ETF	434.98	435.13	434.89	434.96	5257.0
2023-06-13 05:30:00	SPY	ETF	434.93	434.96	434.57	434.57	17793.0
2023-06-13 06:00:00	SPY	ETF	434.56	434.61	434.05	434.13	19085.0
2023-06-13 06:30:00	SPY	ETF	434.13	434.37	434.11	434.29	10259.0
2023-06-13 07:00:00	SPY	ETF	434.29	434.44	434.11	434.33	71770.0
2023-06-13 07:30:00	SPY	ETF	434.31	434.31	433.93	434.02	152888.0
2023-06-13 08:00:00	SPY	ETF	434.169	435.16	433.84	434.49	468862.0
2023-06-13 08:30:00	SPY	ETF	434.49	436.14	433.0	436.13	1157761.0
2023-06-13 09:00:00	SPY	ETF	436.12	436.57	435.23	435.29	730487.0
2023-06-13 09:30:00	SPY	ETF	435.32	437.18	435.09	435.72	8542285.0
2023-06-13 10:00:00	SPY	ETF	435.73	436.2	434.63	435.69	5645731.0
2023-06-13 10:30:00	SPY	ETF	435.7	436.395	435.11	436.0	3940986.0
2023-06-13 11:00:00	SPY	ETF	436.005	437.27	435.69	436.72	5359380.0
2023-06-13 11:30:00	SPY	ETF	436.7179	436.84	436.015	436.03	3819066.0
2023-06-13 12:00:00	SPY	ETF	436.035	436.7	435.72	436.615	3532424.0
2023-06-13 12:30:00	SPY	ETF	436.64	437.0	436.46	436.9901	3101735.0
2023-06-13 13:00:00	SPY	ETF	436.995	437.33	436.43	437.03	3652658.0
2023-06-13 13:30:00	SPY	ETF	437.04	437.205	436.59	436.845	2660495.0
2023-06-13 14:00:00	SPY	ETF	436.845	436.96	435.6201	435.86	4309933.0
2023-06-13 14:30:00	SPY	ETF	435.87	436.245	435.355	436.06	4306133.0
2023-06-13 15:00:00	SPY	ETF	436.06	436.74	436.06	436.34	3951156.0
2023-06-13 15:30:00	SPY	ETF	436.335	436.785	436.1006	436.66	8603198.0
2023-06-13 16:00:00	SPY	ETF	436.65	436.75	433.6544	436.64	2974372.0
2023-06-13 16:30:00	SPY	ETF	436.62	437.05	436.62	436.81	617662.0
2023-06-13 17:00:00	SPY	ETF	436.81	437.05	436.81	437.02	104383.0
2023-06-13 17:30:00	SPY	ETF	437.04	437.08	436.8	436.82	89137.0
2023-06-13 18:00:00	SPY	ETF	436.8	436.82	436.55	436.8	123564.0
2023-06-13 18:30:00	SPY	ETF	436.8	437.0	436.8	436.96	125664.0
2023-06-13 19:00:00	SPY	ETF	436.94	437.0	436.8	436.91	35441.0
2023-06-13 19:30:00	SPY	ETF	436.85	436.9	436.69	436.77	14612.0
2023-06-13 04:00:00	QQQ	ETF	362.46	362.8	362.31	362.71	67903.0
2023-06-13 04:30:00	QQQ	ETF	362.85	362.89	362.58	362.7	32006.0
2023-06-13 05:00:00	QQQ	ETF	362.65	362.71	362.4	362.4	11311.0
2023-06-13 05:30:00	QQQ	ETF	362.45	362.45	361.86	362.05	24714.0
2023-06-13 06:00:00	QQQ	ETF	362.03	362.22	361.46	361.61	127881.0
2023-06-13 06:30:00	QQQ	ETF	361.67	361.82	361.46	361.54	34100.0
2023-06-13 07:00:00	QQQ	ETF	361.55	361.98	361.5	361.81	126195.0
2023-06-13 07:30:00	QQQ	ETF	361.8	361.8	361.07	361.25	164406.0
2023-06-13 08:00:00	QQQ	ETF	361.5617	362.7996	360.76	361.77	301687.0
2023-06-13 08:30:00	QQQ	ETF	362.33	363.65	360.0	363.63	1529874.0
2023-06-13 09:00:00	QQQ	ETF	363.65	364.6	363.22	363.29	975607.0
2023-06-13 09:30:00	QQQ	ETF	363.29	364.11	361.24	361.49	7200587.0
2023-06-13 10:00:00	QQQ	ETF	361.515	362.1501	360.03	360.78	4205402.0
2023-06-13 10:30:00	QQQ	ETF	360.795	362.3	360.41	362.09	2558432.0
2023-06-13 11:00:00	QQQ	ETF	362.1	363.64	361.68	363.1299	2626481.0
2023-06-13 11:30:00	QQQ	ETF	363.16	363.215	362.2	362.23	1998436.0
2023-06-13 12:00:00	QQQ	ETF	362.25	363.045	361.84	362.61	1658526.0
2023-06-13 12:30:00	QQQ	ETF	362.62	363.4	362.49	363.3986	1586893.0

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

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