PREVIEW / etf_30min / 2022-06-16

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-06-16.parquet
  size:    706 KB
  rows:    28,529

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-06-16 04:00:00	SPY	ETF	371.83	378.45	371.57	372.54	94884.0
2022-06-16 04:30:00	SPY	ETF	372.26	372.33	370.5	370.5	50808.0
2022-06-16 05:00:00	SPY	ETF	370.46	370.69	369.44	370.6	143086.0
2022-06-16 05:30:00	SPY	ETF	370.6	371.0	369.82	370.93	88183.0
2022-06-16 06:00:00	SPY	ETF	370.85	371.6	370.34	370.35	110795.0
2022-06-16 06:30:00	SPY	ETF	370.36	370.65	369.78	370.1	191580.0
2022-06-16 07:00:00	SPY	ETF	370.03	371.2	369.99	371.0	407182.0
2022-06-16 07:30:00	SPY	ETF	371.0	371.21	369.76	370.8	380284.0
2022-06-16 08:00:00	SPY	ETF	370.12	380.59	369.8096	371.9	707397.0
2022-06-16 08:30:00	SPY	ETF	371.9	373.06	371.19	371.36	454763.0
2022-06-16 09:00:00	SPY	ETF	371.35	371.94	370.39	370.46	631002.0
2022-06-16 09:30:00	SPY	ETF	370.51	370.94	368.01	368.8181	11066971.0
2022-06-16 10:00:00	SPY	ETF	368.81	369.15	367.39	368.93	7739626.0
2022-06-16 10:30:00	SPY	ETF	368.94	369.12	365.76	366.06	6598326.0
2022-06-16 11:00:00	SPY	ETF	366.07	368.78	365.96	368.16	5290407.0
2022-06-16 11:30:00	SPY	ETF	368.15	368.2699	366.58	367.885	3699041.0
2022-06-16 12:00:00	SPY	ETF	367.87	368.0	366.25	367.63	3760347.0
2022-06-16 12:30:00	SPY	ETF	367.64	368.11	366.62	367.6737	4518571.0
2022-06-16 13:00:00	SPY	ETF	367.69	368.95	367.02	368.45	4671960.0
2022-06-16 13:30:00	SPY	ETF	368.45	368.74	365.8	365.8265	4194850.0
2022-06-16 14:00:00	SPY	ETF	365.83	366.39	365.2	365.2199	4733377.0
2022-06-16 14:30:00	SPY	ETF	365.17	366.37	364.0799	364.82	5570353.0
2022-06-16 15:00:00	SPY	ETF	364.8	367.45	364.65	366.94	8020979.0
2022-06-16 15:30:00	SPY	ETF	366.92	367.17	364.79	366.93	19636661.0
2022-06-16 16:00:00	SPY	ETF	366.9001	367.7	366.35	367.24	7657908.0
2022-06-16 16:30:00	SPY	ETF	367.3	367.91	367.02	367.7	214992.0
2022-06-16 17:00:00	SPY	ETF	367.71	368.0	367.71	367.85	49766.0
2022-06-16 17:30:00	SPY	ETF	367.85	367.9	367.58	367.74	76335.0
2022-06-16 18:00:00	SPY	ETF	367.74	368.35	367.5	368.14	128704.0
2022-06-16 18:30:00	SPY	ETF	368.21	368.21	367.59	367.59	29756.0
2022-06-16 19:00:00	SPY	ETF	367.65	367.91	366.83	367.17	44813.0
2022-06-16 19:30:00	SPY	ETF	367.0	368.44	366.93	367.67	72329.0
2022-06-16 04:00:00	QQQ	ETF	280.96	280.96	276.29	276.71	288803.0
2022-06-16 04:30:00	QQQ	ETF	276.64	276.69	274.85	274.88	199141.0
2022-06-16 05:00:00	QQQ	ETF	274.75	275.44	274.15	275.23	323500.0
2022-06-16 05:30:00	QQQ	ETF	275.29	275.58	274.64	275.43	156528.0
2022-06-16 06:00:00	QQQ	ETF	275.47	276.13	274.93	274.94	201706.0
2022-06-16 06:30:00	QQQ	ETF	275.08	275.41	274.71	275.01	117877.0
2022-06-16 07:00:00	QQQ	ETF	275.05	275.87	274.87	275.53	522678.0
2022-06-16 07:30:00	QQQ	ETF	275.6	275.74	274.47	275.41	596697.0
2022-06-16 08:00:00	QQQ	ETF	275.42	284.73	274.4996	276.66	809943.0
2022-06-16 08:30:00	QQQ	ETF	276.55	277.84	276.09	276.24	626498.0
2022-06-16 09:00:00	QQQ	ETF	276.27	276.61	275.35	275.6	572419.0
2022-06-16 09:30:00	QQQ	ETF	275.59	276.06	273.71	274.06	8910287.0
2022-06-16 10:00:00	QQQ	ETF	274.06	274.09	272.53	273.41	4790540.0
2022-06-16 10:30:00	QQQ	ETF	273.42	273.55	270.74	271.1	4491732.0
2022-06-16 11:00:00	QQQ	ETF	271.11	273.4401	271.02	272.88	3898955.0
2022-06-16 11:30:00	QQQ	ETF	272.87	272.97	271.2098	272.29	2905285.0
2022-06-16 12:00:00	QQQ	ETF	272.28	272.46	271.11	272.32	2297807.0
2022-06-16 12:30:00	QQQ	ETF	272.33	272.809	271.394	272.35	2244920.0

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

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