PREVIEW / etf_30min / 2023-06-21

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-06-21.parquet
  size:    695 KB
  rows:    27,750

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-21 04:00:00	SPY	ETF	437.01	437.31	436.96	437.22	20099.0
2023-06-21 04:30:00	SPY	ETF	437.36	437.55	437.25	437.3	8902.0
2023-06-21 05:00:00	SPY	ETF	437.34	437.34	437.03	437.24	12296.0
2023-06-21 05:30:00	SPY	ETF	437.26	437.56	437.21	437.48	10464.0
2023-06-21 06:00:00	SPY	ETF	437.44	437.61	437.44	437.55	5050.0
2023-06-21 06:30:00	SPY	ETF	437.51	437.64	437.27	437.27	7472.0
2023-06-21 07:00:00	SPY	ETF	437.34	437.36	436.99	437.11	27900.0
2023-06-21 07:30:00	SPY	ETF	437.03	437.16	436.94	437.09	29209.0
2023-06-21 08:00:00	SPY	ETF	437.07	437.5696	436.2	436.21	160166.0
2023-06-21 08:30:00	SPY	ETF	436.25	436.61	435.95	436.15	341009.0
2023-06-21 09:00:00	SPY	ETF	436.15	436.31	435.84	436.15	245152.0
2023-06-21 09:30:00	SPY	ETF	436.19	436.28	434.84	435.24	4847619.0
2023-06-21 10:00:00	SPY	ETF	435.23	435.8106	434.38	435.3401	4887786.0
2023-06-21 10:30:00	SPY	ETF	435.35	435.6778	434.33	435.2616	4105646.0
2023-06-21 11:00:00	SPY	ETF	435.265	435.52	434.41	435.32	3984625.0
2023-06-21 11:30:00	SPY	ETF	435.33	436.02	435.08	435.115	2982870.0
2023-06-21 12:00:00	SPY	ETF	435.11	436.21	435.05	435.88	3077289.0
2023-06-21 12:30:00	SPY	ETF	435.89	436.17	435.16	435.315	2720320.0
2023-06-21 13:00:00	SPY	ETF	435.33	435.64	434.87	435.11	2713016.0
2023-06-21 13:30:00	SPY	ETF	435.105	435.89	435.01	435.8799	2100524.0
2023-06-21 14:00:00	SPY	ETF	435.88	436.7	435.7501	436.6799	3741844.0
2023-06-21 14:30:00	SPY	ETF	436.67	436.99	436.3	436.515	3148993.0
2023-06-21 15:00:00	SPY	ETF	436.52	436.52	435.71	435.72	3565424.0
2023-06-21 15:30:00	SPY	ETF	435.72	435.819	434.625	434.93	11713246.0
2023-06-21 16:00:00	SPY	ETF	434.93	435.23	434.79	434.95	2648484.0
2023-06-21 16:30:00	SPY	ETF	434.96	435.01	434.0	434.93	324058.0
2023-06-21 17:00:00	SPY	ETF	434.94	434.99	434.9	434.94	29573.0
2023-06-21 17:30:00	SPY	ETF	434.94	435.01	434.86	434.9	15983.0
2023-06-21 18:00:00	SPY	ETF	434.97	435.18	434.76	434.81	46956.0
2023-06-21 18:30:00	SPY	ETF	434.8899	434.8901	434.79	434.89	6273.0
2023-06-21 19:00:00	SPY	ETF	434.93	435.13	434.92	435.09	19609.0
2023-06-21 19:30:00	SPY	ETF	435.05	435.1	434.95	435.0	13116.0
2023-06-21 04:00:00	QQQ	ETF	366.38	366.82	366.34	366.79	38399.0
2023-06-21 04:30:00	QQQ	ETF	366.85	367.17	366.83	366.88	21054.0
2023-06-21 05:00:00	QQQ	ETF	366.85	366.87	366.54	366.74	10395.0
2023-06-21 05:30:00	QQQ	ETF	366.76	367.02	366.65	366.9	8428.0
2023-06-21 06:00:00	QQQ	ETF	366.97	367.14	366.91	366.95	41284.0
2023-06-21 06:30:00	QQQ	ETF	366.96	367.08	366.64	366.67	12936.0
2023-06-21 07:00:00	QQQ	ETF	366.76	366.83	366.45	366.45	42372.0
2023-06-21 07:30:00	QQQ	ETF	366.42	366.57	366.26	366.41	46996.0
2023-06-21 08:00:00	QQQ	ETF	366.8082	367.18	365.57	365.63	192467.0
2023-06-21 08:30:00	QQQ	ETF	365.62	366.1	362.3	365.7	275419.0
2023-06-21 09:00:00	QQQ	ETF	365.69	365.78	365.29	365.73	206791.0
2023-06-21 09:30:00	QQQ	ETF	365.74	366.18	363.71	363.98	3868488.0
2023-06-21 10:00:00	QQQ	ETF	363.975	364.21	362.76	363.3716	3679210.0
2023-06-21 10:30:00	QQQ	ETF	363.383	363.7279	361.82	362.275	3188967.0
2023-06-21 11:00:00	QQQ	ETF	362.26	362.48	360.96	362.022	3566725.0
2023-06-21 11:30:00	QQQ	ETF	362.01	362.99	361.57	361.61	2297376.0
2023-06-21 12:00:00	QQQ	ETF	361.61	363.1	361.53	362.63	2264682.0
2023-06-21 12:30:00	QQQ	ETF	362.65	363.03	362.11	362.39	1982690.0

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

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