PREVIEW / etf_30min / 2022-07-25

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-07-25.parquet
  size:    639 KB
  rows:    25,070

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
2022-07-25 04:00:00	SPY	ETF	394.42	395.4	394.42	395.26	28878.0
2022-07-25 04:30:00	SPY	ETF	395.32	396.02	395.32	395.93	13071.0
2022-07-25 05:00:00	SPY	ETF	395.84	396.51	395.84	396.3	18752.0
2022-07-25 05:30:00	SPY	ETF	396.3	397.04	396.3	396.98	29943.0
2022-07-25 06:00:00	SPY	ETF	397.02	397.11	396.73	397.02	21792.0
2022-07-25 06:30:00	SPY	ETF	397.02	397.21	396.8	397.21	46133.0
2022-07-25 07:00:00	SPY	ETF	397.22	397.42	396.81	397.23	88183.0
2022-07-25 07:30:00	SPY	ETF	397.21	397.5	396.6	396.82	222842.0
2022-07-25 08:00:00	SPY	ETF	395.25	397.5	394.36	396.85	365896.0
2022-07-25 08:30:00	SPY	ETF	396.85	396.9	396.17	396.41	149771.0
2022-07-25 09:00:00	SPY	ETF	396.41	396.58	395.7	395.72	219942.0
2022-07-25 09:30:00	SPY	ETF	395.75	396.05	394.03	395.5	4281853.0
2022-07-25 10:00:00	SPY	ETF	395.53	395.88	393.74	394.63	3516712.0
2022-07-25 10:30:00	SPY	ETF	394.62	395.65	393.87	395.22	2338209.0
2022-07-25 11:00:00	SPY	ETF	395.2128	395.72	394.27	395.63	2481182.0
2022-07-25 11:30:00	SPY	ETF	395.66	396.29	395.53	395.9	2164206.0
2022-07-25 12:00:00	SPY	ETF	395.91	396.14	394.71	395.2793	2236564.0
2022-07-25 12:30:00	SPY	ETF	395.29	396.47	395.24	395.82	2415666.0
2022-07-25 13:00:00	SPY	ETF	395.82	396.31	395.42	395.4301	1423284.0
2022-07-25 13:30:00	SPY	ETF	395.43	395.6	394.47	394.485	2267133.0
2022-07-25 14:00:00	SPY	ETF	394.495	394.725	394.04	394.25	2182288.0
2022-07-25 14:30:00	SPY	ETF	394.26	394.71	393.65	393.79	2180623.0
2022-07-25 15:00:00	SPY	ETF	393.8	394.18	393.21	393.59	2983588.0
2022-07-25 15:30:00	SPY	ETF	393.59	395.75	393.47	395.55	6392492.0
2022-07-25 16:00:00	SPY	ETF	395.55	396.17	393.0	394.85	2773592.0
2022-07-25 16:30:00	SPY	ETF	394.81	395.57	394.67	394.76	742252.0
2022-07-25 17:00:00	SPY	ETF	394.61	394.82	394.55	394.58	153012.0
2022-07-25 17:30:00	SPY	ETF	394.58	394.6	394.11	394.33	164906.0
2022-07-25 18:00:00	SPY	ETF	394.33	394.44	394.1	394.19	123926.0
2022-07-25 18:30:00	SPY	ETF	394.17	394.48	394.14	394.37	23757.0
2022-07-25 19:00:00	SPY	ETF	394.35	394.38	393.91	393.91	31334.0
2022-07-25 19:30:00	SPY	ETF	393.97	394.209	393.95	394.209	94066.0
2022-07-25 04:00:00	QQQ	ETF	301.9	302.46	301.77	302.37	59467.0
2022-07-25 04:30:00	QQQ	ETF	302.38	303.05	302.3	302.79	55837.0
2022-07-25 05:00:00	QQQ	ETF	302.8	303.26	302.8	303.05	43349.0
2022-07-25 05:30:00	QQQ	ETF	303.09	303.69	303.07	303.58	27314.0
2022-07-25 06:00:00	QQQ	ETF	303.68	303.76	303.43	303.59	30978.0
2022-07-25 06:30:00	QQQ	ETF	303.54	303.59	303.3	303.59	18298.0
2022-07-25 07:00:00	QQQ	ETF	303.59	303.83	303.21	303.61	52912.0
2022-07-25 07:30:00	QQQ	ETF	303.57	303.82	303.01	303.27	103333.0
2022-07-25 08:00:00	QQQ	ETF	303.33	303.82	302.1	303.13	228703.0
2022-07-25 08:30:00	QQQ	ETF	303.14	303.15	302.38	302.64	239007.0
2022-07-25 09:00:00	QQQ	ETF	302.69	302.83	302.02	302.05	205029.0
2022-07-25 09:30:00	QQQ	ETF	302.02	302.5	300.364	301.1	5686231.0
2022-07-25 10:00:00	QQQ	ETF	301.14	301.49	298.75	299.78	4153695.0
2022-07-25 10:30:00	QQQ	ETF	299.73	300.91	299.33	300.32	2288156.0
2022-07-25 11:00:00	QQQ	ETF	300.3292	300.64	299.08	300.46	1978928.0
2022-07-25 11:30:00	QQQ	ETF	300.47	301.14	300.34	300.7388	1760809.0
2022-07-25 12:00:00	QQQ	ETF	300.73	301.05	299.76	300.3799	1235020.0
2022-07-25 12:30:00	QQQ	ETF	300.39	301.59	300.3013	300.93	1599573.0

> showing 50 of 25,070 rows — these rows as CSV

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