PREVIEW / etf_30min / 2023-05-31

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-05-31.parquet
  size:    703 KB
  rows:    28,073

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-05-31 04:00:00	SPY	ETF	419.23	419.51	419.0	419.33	16166.0
2023-05-31 04:30:00	SPY	ETF	419.22	419.39	418.85	419.39	7172.0
2023-05-31 05:00:00	SPY	ETF	419.59	419.78	419.48	419.64	9484.0
2023-05-31 05:30:00	SPY	ETF	419.55	419.8	419.2	419.2	7079.0
2023-05-31 06:00:00	SPY	ETF	419.29	419.36	418.86	418.9	114091.0
2023-05-31 06:30:00	SPY	ETF	418.9	419.44	418.9	419.38	72991.0
2023-05-31 07:00:00	SPY	ETF	419.41	419.49	418.95	419.07	153123.0
2023-05-31 07:30:00	SPY	ETF	419.18	419.24	418.44	418.5	178481.0
2023-05-31 08:00:00	SPY	ETF	419.39	420.31	418.24	418.33	119081.0
2023-05-31 08:30:00	SPY	ETF	418.37	418.51	418.1	418.2	112549.0
2023-05-31 09:00:00	SPY	ETF	418.22	418.44	418.03	418.25	229670.0
2023-05-31 09:30:00	SPY	ETF	418.28	419.22	418.06	418.1391	5571078.0
2023-05-31 10:00:00	SPY	ETF	418.17	418.3	416.46	416.87	6610942.0
2023-05-31 10:30:00	SPY	ETF	416.88	417.21	416.322	416.84	4727632.0
2023-05-31 11:00:00	SPY	ETF	416.86	417.05	416.27	416.28	3045609.0
2023-05-31 11:30:00	SPY	ETF	416.295	417.08	416.22	416.75	2999729.0
2023-05-31 12:00:00	SPY	ETF	416.755	417.19	416.55	416.7701	1796938.0
2023-05-31 12:30:00	SPY	ETF	416.78	417.41	416.44	417.05	2515133.0
2023-05-31 13:00:00	SPY	ETF	417.05	417.62	416.9	417.62	1993669.0
2023-05-31 13:30:00	SPY	ETF	417.62	418.49	417.39	418.31	3915110.0
2023-05-31 14:00:00	SPY	ETF	418.31	418.72	418.0	418.57	2714186.0
2023-05-31 14:30:00	SPY	ETF	418.58	418.68	417.58	418.13	3814496.0
2023-05-31 15:00:00	SPY	ETF	418.13	418.26	417.7207	418.21	3177019.0
2023-05-31 15:30:00	SPY	ETF	418.21	419.13	417.57	417.83	21576246.0
2023-05-31 16:00:00	SPY	ETF	417.82	418.15	417.34	417.95	8199045.0
2023-05-31 16:30:00	SPY	ETF	417.96	418.07	417.64	417.64	361442.0
2023-05-31 17:00:00	SPY	ETF	417.6999	417.8	417.64	417.79	82616.0
2023-05-31 17:30:00	SPY	ETF	417.79	417.8	417.62	417.66	63715.0
2023-05-31 18:00:00	SPY	ETF	417.74	417.88	417.67	417.8	145080.0
2023-05-31 18:30:00	SPY	ETF	417.79	418.08	417.75	418.08	19753.0
2023-05-31 19:00:00	SPY	ETF	418.1	418.17	417.97	418.02	17772.0
2023-05-31 19:30:00	SPY	ETF	418.05	418.45	418.05	418.4	45425.0
2023-05-31 04:00:00	QQQ	ETF	349.11	349.24	348.79	349.13	85853.0
2023-05-31 04:30:00	QQQ	ETF	349.05	349.25	348.75	349.25	9786.0
2023-05-31 05:00:00	QQQ	ETF	349.27	349.52	349.26	349.38	15926.0
2023-05-31 05:30:00	QQQ	ETF	349.4	349.73	349.37	349.38	22234.0
2023-05-31 06:00:00	QQQ	ETF	349.47	349.56	348.93	348.98	19964.0
2023-05-31 06:30:00	QQQ	ETF	349.01	349.5	348.96	349.5	35920.0
2023-05-31 07:00:00	QQQ	ETF	349.51	349.65	349.15	349.24	84009.0
2023-05-31 07:30:00	QQQ	ETF	349.25	349.34	348.42	348.61	77192.0
2023-05-31 08:00:00	QQQ	ETF	349.55	350.242	348.26	348.31	258813.0
2023-05-31 08:30:00	QQQ	ETF	348.291	348.55	348.08	348.16	172004.0
2023-05-31 09:00:00	QQQ	ETF	348.16	348.59	348.06	348.37	235160.0
2023-05-31 09:30:00	QQQ	ETF	348.37	350.6	348.24	349.51	6197761.0
2023-05-31 10:00:00	QQQ	ETF	349.52	349.91	347.04	347.615	4657722.0
2023-05-31 10:30:00	QQQ	ETF	347.615	348.49	347.34	347.92	3549410.0
2023-05-31 11:00:00	QQQ	ETF	347.92	348.01	346.84	346.9	2185528.0
2023-05-31 11:30:00	QQQ	ETF	346.89	347.79	346.51	347.45	2236541.0
2023-05-31 12:00:00	QQQ	ETF	347.46	347.9	346.7901	346.8096	1861738.0
2023-05-31 12:30:00	QQQ	ETF	346.81	347.41	346.53	347.155	1872927.0

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

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