PREVIEW / etf_30min / 2023-01-23

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-01-23.parquet
  size:    721 KB
  rows:    28,578

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-01-23 04:00:00	SPY	ETF	389.05	395.7	389.05	395.59	19647.0
2023-01-23 04:30:00	SPY	ETF	395.56	395.91	395.56	395.76	6359.0
2023-01-23 05:00:00	SPY	ETF	395.9	395.91	395.26	395.41	17734.0
2023-01-23 05:30:00	SPY	ETF	395.37	395.85	395.3	395.7	37222.0
2023-01-23 06:00:00	SPY	ETF	395.6	395.85	395.35	395.43	64259.0
2023-01-23 06:30:00	SPY	ETF	395.52	395.52	395.16	395.38	29623.0
2023-01-23 07:00:00	SPY	ETF	395.43	395.75	395.43	395.61	55836.0
2023-01-23 07:30:00	SPY	ETF	395.69	396.44	395.69	395.86	120317.0
2023-01-23 08:00:00	SPY	ETF	395.5	397.13	395.5	396.679	434051.0
2023-01-23 08:30:00	SPY	ETF	396.679	396.78	396.28	396.58	210183.0
2023-01-23 09:00:00	SPY	ETF	396.57	396.88	396.07	396.74	291564.0
2023-01-23 09:30:00	SPY	ETF	396.72	398.3	395.72	397.855	5989484.0
2023-01-23 10:00:00	SPY	ETF	397.87	399.46	397.62	399.24	5278148.0
2023-01-23 10:30:00	SPY	ETF	399.235	400.28	399.08	399.88	4790901.0
2023-01-23 11:00:00	SPY	ETF	399.9	402.11	399.89	400.86	6217526.0
2023-01-23 11:30:00	SPY	ETF	400.89	401.6001	400.68	401.53	3071190.0
2023-01-23 12:00:00	SPY	ETF	401.55	401.55	400.375	401.06	2381482.0
2023-01-23 12:30:00	SPY	ETF	401.065	401.63	400.72	401.5	2038179.0
2023-01-23 13:00:00	SPY	ETF	401.475	402.05	401.4	401.88	2112329.0
2023-01-23 13:30:00	SPY	ETF	401.88	402.645	401.82	402.005	2601509.0
2023-01-23 14:00:00	SPY	ETF	402.03	402.03	400.485	400.65	3077205.0
2023-01-23 14:30:00	SPY	ETF	400.6601	401.07	398.7201	399.53	6120178.0
2023-01-23 15:00:00	SPY	ETF	399.54	400.26	399.06	399.82	4274806.0
2023-01-23 15:30:00	SPY	ETF	399.83	401.0	399.47	400.59	9054859.0
2023-01-23 16:00:00	SPY	ETF	400.59	400.7	400.11	400.35	5777621.0
2023-01-23 16:30:00	SPY	ETF	400.38	400.74	400.38	400.72	119031.0
2023-01-23 17:00:00	SPY	ETF	400.72	400.75	400.54	400.71	62784.0
2023-01-23 17:30:00	SPY	ETF	400.62	400.79	400.36	400.66	57549.0
2023-01-23 18:00:00	SPY	ETF	400.73	400.73	400.35	400.35	66787.0
2023-01-23 18:30:00	SPY	ETF	400.34	400.41	400.16	400.3	32715.0
2023-01-23 19:00:00	SPY	ETF	400.25	400.41	400.21	400.38	8378.0
2023-01-23 19:30:00	SPY	ETF	400.38	400.47	400.37	400.4	36398.0
2023-01-23 04:00:00	QQQ	ETF	282.56	282.8	282.31	282.68	53409.0
2023-01-23 04:30:00	QQQ	ETF	282.62	282.97	282.62	282.87	9923.0
2023-01-23 05:00:00	QQQ	ETF	282.99	282.99	282.34	282.53	38218.0
2023-01-23 05:30:00	QQQ	ETF	282.45	282.76	282.35	282.68	20699.0
2023-01-23 06:00:00	QQQ	ETF	282.62	282.72	282.4	282.48	19517.0
2023-01-23 06:30:00	QQQ	ETF	282.58	282.63	282.31	282.44	21532.0
2023-01-23 07:00:00	QQQ	ETF	282.47	282.81	282.46	282.8	46677.0
2023-01-23 07:30:00	QQQ	ETF	282.75	283.47	282.7	283.06	62357.0
2023-01-23 08:00:00	QQQ	ETF	282.6299	283.96	282.3504	283.63	157599.0
2023-01-23 08:30:00	QQQ	ETF	283.6	283.69	283.08	283.35	258046.0
2023-01-23 09:00:00	QQQ	ETF	283.32	283.64	282.68	283.56	1240206.0
2023-01-23 09:30:00	QQQ	ETF	283.51	286.35	282.73	285.85	5253074.0
2023-01-23 10:00:00	QQQ	ETF	285.87	287.26	285.64	287.04	3449113.0
2023-01-23 10:30:00	QQQ	ETF	287.055	287.82	286.87	287.49	2738712.0
2023-01-23 11:00:00	QQQ	ETF	287.5	289.6	287.5	288.49	3431448.0
2023-01-23 11:30:00	QQQ	ETF	288.4999	289.38	288.34	289.31	1698271.0
2023-01-23 12:00:00	QQQ	ETF	289.315	289.33	288.4	288.94	1898834.0
2023-01-23 12:30:00	QQQ	ETF	288.96	289.34	288.62	289.23	1150017.0

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

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