PREVIEW / etf_30min / 2023-06-20

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-06-20.parquet
  size:    718 KB
  rows:    28,564

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-20 04:00:00	SPY	ETF	438.66	438.7	437.83	437.84	37619.0
2023-06-20 04:30:00	SPY	ETF	437.8	437.83	437.2	437.33	27851.0
2023-06-20 05:00:00	SPY	ETF	437.29	437.48	437.22	437.31	23358.0
2023-06-20 05:30:00	SPY	ETF	437.29	437.56	437.26	437.56	6331.0
2023-06-20 06:00:00	SPY	ETF	437.5	437.78	437.49	437.62	110879.0
2023-06-20 06:30:00	SPY	ETF	437.6	437.81	437.46	437.81	13430.0
2023-06-20 07:00:00	SPY	ETF	437.84	437.96	437.72	437.79	67333.0
2023-06-20 07:30:00	SPY	ETF	437.96	438.12	437.6	438.0	55111.0
2023-06-20 08:00:00	SPY	ETF	437.9101	438.76	437.71	438.1499	214243.0
2023-06-20 08:30:00	SPY	ETF	438.11	439.46	437.83	438.33	114241.0
2023-06-20 09:00:00	SPY	ETF	438.35	438.44	437.43	437.46	178838.0
2023-06-20 09:30:00	SPY	ETF	437.46	438.17	437.09	437.27	6050434.0
2023-06-20 10:00:00	SPY	ETF	437.275	437.39	435.0631	435.28	6869910.0
2023-06-20 10:30:00	SPY	ETF	435.3	436.015	435.03	435.76	4878028.0
2023-06-20 11:00:00	SPY	ETF	435.77	436.37	435.69	435.8814	2934426.0
2023-06-20 11:30:00	SPY	ETF	435.9	436.42	435.875	436.06	2650916.0
2023-06-20 12:00:00	SPY	ETF	436.06	437.36	435.85	437.2	2924557.0
2023-06-20 12:30:00	SPY	ETF	437.2	437.98	437.06	437.825	4272634.0
2023-06-20 13:00:00	SPY	ETF	437.83	438.37	437.4	438.056	3192256.0
2023-06-20 13:30:00	SPY	ETF	438.055	438.235	437.3	437.44	2405631.0
2023-06-20 14:00:00	SPY	ETF	437.44	438.02	437.335	437.985	2183659.0
2023-06-20 14:30:00	SPY	ETF	437.995	438.025	437.22	437.5801	2027557.0
2023-06-20 15:00:00	SPY	ETF	437.6	437.7366	437.17	437.45	2515852.0
2023-06-20 15:30:00	SPY	ETF	437.46	438.0	437.1	437.23	9980770.0
2023-06-20 16:00:00	SPY	ETF	437.23	437.38	436.69	437.13	2898313.0
2023-06-20 16:30:00	SPY	ETF	437.13	437.13	436.95	436.98	107406.0
2023-06-20 17:00:00	SPY	ETF	436.98	437.18	436.95	437.05	437752.0
2023-06-20 17:30:00	SPY	ETF	437.05	437.18	436.91	436.95	519960.0
2023-06-20 18:00:00	SPY	ETF	436.94	437.11	436.94	437.11	30501.0
2023-06-20 18:30:00	SPY	ETF	437.14	437.2	436.99	437.01	23998.0
2023-06-20 19:00:00	SPY	ETF	437.04	437.2	437.04	437.19	15083.0
2023-06-20 19:30:00	SPY	ETF	437.22	437.46	437.2	437.39	28154.0
2023-06-20 04:00:00	QQQ	ETF	367.07	367.83	365.5	365.5	56623.0
2023-06-20 04:30:00	QQQ	ETF	365.53	365.55	364.95	365.17	32961.0
2023-06-20 05:00:00	QQQ	ETF	365.23	365.38	365.05	365.05	16635.0
2023-06-20 05:30:00	QQQ	ETF	365.2	365.53	365.13	365.49	36200.0
2023-06-20 06:00:00	QQQ	ETF	365.39	365.81	365.39	365.62	84646.0
2023-06-20 06:30:00	QQQ	ETF	365.67	366.01	365.53	365.98	25697.0
2023-06-20 07:00:00	QQQ	ETF	365.99	366.17	365.93	366.09	57089.0
2023-06-20 07:30:00	QQQ	ETF	366.1	366.49	365.87	366.27	80910.0
2023-06-20 08:00:00	QQQ	ETF	365.9882	366.83	365.1004	366.63	180417.0
2023-06-20 08:30:00	QQQ	ETF	366.57	367.4261	366.24	366.92	156425.0
2023-06-20 09:00:00	QQQ	ETF	366.94	366.99	365.9	365.99	307335.0
2023-06-20 09:30:00	QQQ	ETF	365.98	368.32	365.8	366.2795	5102977.0
2023-06-20 10:00:00	QQQ	ETF	366.27	366.87	363.98	364.2499	3720817.0
2023-06-20 10:30:00	QQQ	ETF	364.25	365.0	363.8899	364.42	3381411.0
2023-06-20 11:00:00	QQQ	ETF	364.435	365.4	364.428	365.07	2034316.0
2023-06-20 11:30:00	QQQ	ETF	365.08	365.54	364.78	364.82	1809433.0
2023-06-20 12:00:00	QQQ	ETF	364.81	366.73	364.66	366.65	2176644.0
2023-06-20 12:30:00	QQQ	ETF	366.66	367.41	366.4908	367.065	1784848.0

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

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