PREVIEW / etf_30min / 2023-01-31

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-01-31.parquet
  size:    699 KB
  rows:    28,228

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-31 04:00:00	SPY	ETF	399.95	400.0	399.21	399.51	27351.0
2023-01-31 04:30:00	SPY	ETF	399.44	399.71	399.42	399.5	10890.0
2023-01-31 05:00:00	SPY	ETF	399.31	399.47	399.06	399.29	9519.0
2023-01-31 05:30:00	SPY	ETF	399.35	399.35	398.7	398.75	16244.0
2023-01-31 06:00:00	SPY	ETF	398.7	398.94	398.5	398.52	57383.0
2023-01-31 06:30:00	SPY	ETF	398.48	399.32	398.25	399.22	52884.0
2023-01-31 07:00:00	SPY	ETF	399.3	399.69	399.25	399.56	76647.0
2023-01-31 07:30:00	SPY	ETF	399.69	400.15	399.62	399.95	126972.0
2023-01-31 08:00:00	SPY	ETF	399.5	401.39	398.69	400.06	227387.0
2023-01-31 08:30:00	SPY	ETF	400.11	402.23	400.11	401.8	889446.0
2023-01-31 09:00:00	SPY	ETF	401.84	402.04	401.0	401.11	452109.0
2023-01-31 09:30:00	SPY	ETF	401.11	402.3401	400.88	401.2399	5263704.0
2023-01-31 10:00:00	SPY	ETF	401.23	402.76	400.77	402.68	4136207.0
2023-01-31 10:30:00	SPY	ETF	402.7	403.34	402.43	402.92	2968214.0
2023-01-31 11:00:00	SPY	ETF	402.932	403.49	402.726	403.15	2763475.0
2023-01-31 11:30:00	SPY	ETF	403.14	403.53	402.76	403.05	1923736.0
2023-01-31 12:00:00	SPY	ETF	403.05	403.65	402.5	403.44	2091003.0
2023-01-31 12:30:00	SPY	ETF	403.43	403.88	403.24	403.66	1719844.0
2023-01-31 13:00:00	SPY	ETF	403.68	403.88	403.18	403.68	1523948.0
2023-01-31 13:30:00	SPY	ETF	403.68	404.3	403.48	404.22	2052098.0
2023-01-31 14:00:00	SPY	ETF	404.24	404.54	404.09	404.33	2308004.0
2023-01-31 14:30:00	SPY	ETF	404.33	404.74	404.15	404.49	2141852.0
2023-01-31 15:00:00	SPY	ETF	404.5	404.84	403.645	403.7443	4374240.0
2023-01-31 15:30:00	SPY	ETF	403.7501	406.53	403.735	406.45	18305394.0
2023-01-31 16:00:00	SPY	ETF	406.45	406.48	405.75	405.96	7474463.0
2023-01-31 16:30:00	SPY	ETF	405.88	406.48	405.69	405.95	912776.0
2023-01-31 17:00:00	SPY	ETF	405.92	406.0169	405.79	405.99	60525.0
2023-01-31 17:30:00	SPY	ETF	405.92	406.08	405.9	406.02	53496.0
2023-01-31 18:00:00	SPY	ETF	406.02	406.02	405.52	405.52	71082.0
2023-01-31 18:30:00	SPY	ETF	405.52	405.76	405.33	405.55	39430.0
2023-01-31 19:00:00	SPY	ETF	405.51	405.95	405.1	405.19	35360.0
2023-01-31 19:30:00	SPY	ETF	405.15	405.23	405.01	405.09	49900.0
2023-01-31 04:00:00	QQQ	ETF	289.05	289.64	288.68	288.88	60204.0
2023-01-31 04:30:00	QQQ	ETF	288.86	289.14	288.82	288.88	13690.0
2023-01-31 05:00:00	QQQ	ETF	288.91	288.91	288.41	288.56	39140.0
2023-01-31 05:30:00	QQQ	ETF	288.63	288.64	288.1	288.14	22346.0
2023-01-31 06:00:00	QQQ	ETF	288.16	288.42	287.96	287.96	25553.0
2023-01-31 06:30:00	QQQ	ETF	287.95	288.82	287.84	288.79	69308.0
2023-01-31 07:00:00	QQQ	ETF	288.76	289.05	288.64	289.01	73549.0
2023-01-31 07:30:00	QQQ	ETF	289.05	289.44	288.85	289.25	68999.0
2023-01-31 08:00:00	QQQ	ETF	288.92	290.85	288.2504	289.24	253027.0
2023-01-31 08:30:00	QQQ	ETF	289.32	291.33	289.32	290.96	956754.0
2023-01-31 09:00:00	QQQ	ETF	290.99	291.27	290.26	290.3	345866.0
2023-01-31 09:30:00	QQQ	ETF	290.31	292.27	290.2	290.78	4831988.0
2023-01-31 10:00:00	QQQ	ETF	290.81	292.4	290.35	292.34	3548370.0
2023-01-31 10:30:00	QQQ	ETF	292.41	292.925	292.04	292.71	2569795.0
2023-01-31 11:00:00	QQQ	ETF	292.72	293.14	292.45	292.94	1852244.0
2023-01-31 11:30:00	QQQ	ETF	292.94	293.22	292.25	292.5211	1707382.0
2023-01-31 12:00:00	QQQ	ETF	292.54	293.072	291.928	292.73	1419885.0
2023-01-31 12:30:00	QQQ	ETF	292.73	293.1995	292.49	292.985	1053969.0

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

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