PREVIEW / etf_30min / 2023-09-22

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-09-22.parquet
  size:    694 KB
  rows:    27,834

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-09-22 04:00:00	SPY	ETF	432.46	432.46	431.58	431.85	22703.0
2023-09-22 04:30:00	SPY	ETF	431.85	432.3	431.82	432.1	5700.0
2023-09-22 05:00:00	SPY	ETF	432.08	432.11	431.85	432.02	4980.0
2023-09-22 05:30:00	SPY	ETF	432.13	432.61	432.13	432.51	13598.0
2023-09-22 06:00:00	SPY	ETF	432.51	432.52	432.15	432.16	32186.0
2023-09-22 06:30:00	SPY	ETF	432.19	432.63	432.18	432.4	14628.0
2023-09-22 07:00:00	SPY	ETF	432.39	432.45	432.06	432.25	80428.0
2023-09-22 07:30:00	SPY	ETF	432.28	432.47	432.17	432.4	93329.0
2023-09-22 08:00:00	SPY	ETF	432.3217	433.24	431.88	433.13	485396.0
2023-09-22 08:30:00	SPY	ETF	433.14	433.23	432.78	432.85	129401.0
2023-09-22 09:00:00	SPY	ETF	432.89	433.05	432.32	432.46	469529.0
2023-09-22 09:30:00	SPY	ETF	432.46	432.64	431.67	432.4536	7181373.0
2023-09-22 10:00:00	SPY	ETF	432.465	433.1103	431.96	432.755	5640905.0
2023-09-22 10:30:00	SPY	ETF	432.765	433.81	432.75	433.66	5180452.0
2023-09-22 11:00:00	SPY	ETF	433.67	433.9	432.94	433.87	3743352.0
2023-09-22 11:30:00	SPY	ETF	433.875	434.1	432.89	432.91	3135804.0
2023-09-22 12:00:00	SPY	ETF	432.92	433.5	432.655	433.24	2748132.0
2023-09-22 12:30:00	SPY	ETF	433.26	433.76	433.13	433.4	2055189.0
2023-09-22 13:00:00	SPY	ETF	433.4082	433.46	431.96	432.14	3211546.0
2023-09-22 13:30:00	SPY	ETF	432.14	432.19	431.21	431.62	5196778.0
2023-09-22 14:00:00	SPY	ETF	431.61	431.81	430.55	431.0	4394670.0
2023-09-22 14:30:00	SPY	ETF	430.99	431.279	430.555	431.07	3653073.0
2023-09-22 15:00:00	SPY	ETF	431.05	433.21	430.95	432.59	5266389.0
2023-09-22 15:30:00	SPY	ETF	432.6	432.79	429.99	430.38	18798474.0
2023-09-22 16:00:00	SPY	ETF	430.39	433.6078	430.36	430.66	4622948.0
2023-09-22 16:30:00	SPY	ETF	430.65	430.79	430.35	430.43	242225.0
2023-09-22 17:00:00	SPY	ETF	430.41	431.18	430.41	430.7599	169351.0
2023-09-22 17:30:00	SPY	ETF	430.74	430.99	430.73	430.85	42308.0
2023-09-22 18:00:00	SPY	ETF	430.89	430.9	430.77	430.82	17827.0
2023-09-22 18:30:00	SPY	ETF	430.79	430.8	430.66	430.7	9212.0
2023-09-22 19:00:00	SPY	ETF	430.66	430.68	430.4	430.5	31356.0
2023-09-22 19:30:00	SPY	ETF	430.49	430.8	430.42	430.6	11212.0
2023-09-22 04:00:00	QQQ	ETF	358.93	359.33	358.63	359.0	143884.0
2023-09-22 04:30:00	QQQ	ETF	358.94	359.29	358.92	359.2	21064.0
2023-09-22 05:00:00	QQQ	ETF	359.16	359.21	358.91	359.05	13428.0
2023-09-22 05:30:00	QQQ	ETF	359.15	359.61	359.15	359.57	18866.0
2023-09-22 06:00:00	QQQ	ETF	359.5	359.53	359.22	359.31	13001.0
2023-09-22 06:30:00	QQQ	ETF	359.23	359.66	359.23	359.49	20696.0
2023-09-22 07:00:00	QQQ	ETF	359.38	359.42	359.05	359.23	63389.0
2023-09-22 07:30:00	QQQ	ETF	359.24	359.38	359.09	359.3	71182.0
2023-09-22 08:00:00	QQQ	ETF	358.27	360.4	358.128	360.34	771290.0
2023-09-22 08:30:00	QQQ	ETF	360.27	360.46	359.93	360.03	389567.0
2023-09-22 09:00:00	QQQ	ETF	360.06	360.21	359.51	359.64	591633.0
2023-09-22 09:30:00	QQQ	ETF	359.63	359.94	358.44	359.94	5500550.0
2023-09-22 10:00:00	QQQ	ETF	359.945	360.2809	359.03	360.0	3467573.0
2023-09-22 10:30:00	QQQ	ETF	360.005	361.51	360.0	361.38	3488453.0
2023-09-22 11:00:00	QQQ	ETF	361.39	361.56	360.73	361.4	2358505.0
2023-09-22 11:30:00	QQQ	ETF	361.41	361.8	360.565	360.5999	1949752.0
2023-09-22 12:00:00	QQQ	ETF	360.6	361.43	360.45	361.25	1387594.0
2023-09-22 12:30:00	QQQ	ETF	361.27	361.68	361.15	361.32	1136721.0

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

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