PREVIEW / etf_30min / 2023-01-17

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-01-17.parquet
  size:    702 KB
  rows:    28,276

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-17 04:00:00	SPY	ETF	397.95	397.95	396.88	397.13	43217.0
2023-01-17 04:30:00	SPY	ETF	397.14	397.69	397.14	397.31	15354.0
2023-01-17 05:00:00	SPY	ETF	397.33	397.52	397.09	397.39	19300.0
2023-01-17 05:30:00	SPY	ETF	397.54	397.8	397.39	397.69	7597.0
2023-01-17 06:00:00	SPY	ETF	397.56	397.57	397.39	397.44	16569.0
2023-01-17 06:30:00	SPY	ETF	397.49	397.82	397.38	397.75	11957.0
2023-01-17 07:00:00	SPY	ETF	397.79	398.09	397.56	398.0	69392.0
2023-01-17 07:30:00	SPY	ETF	398.08	398.08	397.23	397.39	95471.0
2023-01-17 08:00:00	SPY	ETF	397.64	398.06	397.03	397.67	221756.0
2023-01-17 08:30:00	SPY	ETF	397.73	398.11	397.3	397.45	122320.0
2023-01-17 09:00:00	SPY	ETF	397.56	398.85	397.55	398.48	413252.0
2023-01-17 09:30:00	SPY	ETF	398.48	399.1	397.62	398.55	4888579.0
2023-01-17 10:00:00	SPY	ETF	398.56	400.23	398.56	399.73	4827324.0
2023-01-17 10:30:00	SPY	ETF	399.71	399.83	397.83	398.23	3560086.0
2023-01-17 11:00:00	SPY	ETF	398.23	398.46	397.06	397.695	4001320.0
2023-01-17 11:30:00	SPY	ETF	397.695	398.37	397.5989	398.2186	2436184.0
2023-01-17 12:00:00	SPY	ETF	398.23	398.64	397.49	397.61	2364803.0
2023-01-17 12:30:00	SPY	ETF	397.6093	398.35	397.53	398.11	1566416.0
2023-01-17 13:00:00	SPY	ETF	398.12	398.4	397.9012	398.16	1992167.0
2023-01-17 13:30:00	SPY	ETF	398.15	398.8	398.0401	398.655	1899162.0
2023-01-17 14:00:00	SPY	ETF	398.66	398.84	397.59	397.84	2832688.0
2023-01-17 14:30:00	SPY	ETF	397.845	398.7	397.84	398.1	2483314.0
2023-01-17 15:00:00	SPY	ETF	398.1176	398.56	397.78	397.96	2736112.0
2023-01-17 15:30:00	SPY	ETF	397.94	398.19	397.155	397.76	8080788.0
2023-01-17 16:00:00	SPY	ETF	397.76	398.04	397.63	397.65	5871262.0
2023-01-17 16:30:00	SPY	ETF	397.66	397.77	397.65	397.66	144027.0
2023-01-17 17:00:00	SPY	ETF	397.61	397.82	397.5	397.59	10968.0
2023-01-17 17:30:00	SPY	ETF	397.5796	397.5796	397.51	397.54	16567.0
2023-01-17 18:00:00	SPY	ETF	397.58	397.58	397.0	397.09	44502.0
2023-01-17 18:30:00	SPY	ETF	397.1	397.1	396.5	396.81	91424.0
2023-01-17 19:00:00	SPY	ETF	396.82	396.86	396.44	396.63	54589.0
2023-01-17 19:30:00	SPY	ETF	396.64	396.85	396.58	396.72	64884.0
2023-01-17 04:00:00	QQQ	ETF	279.88	280.41	279.35	279.46	37794.0
2023-01-17 04:30:00	QQQ	ETF	279.63	280.0	279.63	279.7	16320.0
2023-01-17 05:00:00	QQQ	ETF	279.73	279.96	279.54	279.92	16495.0
2023-01-17 05:30:00	QQQ	ETF	279.95	280.26	279.85	280.07	24136.0
2023-01-17 06:00:00	QQQ	ETF	280.08	280.11	279.82	279.9	4060.0
2023-01-17 06:30:00	QQQ	ETF	279.99	280.09	279.79	280.08	18341.0
2023-01-17 07:00:00	QQQ	ETF	280.11	280.5	279.89	280.49	63554.0
2023-01-17 07:30:00	QQQ	ETF	280.48	280.53	279.64	279.82	136743.0
2023-01-17 08:00:00	QQQ	ETF	280.13	280.5	279.4	279.97	294192.0
2023-01-17 08:30:00	QQQ	ETF	279.97	280.42	279.76	279.9	319772.0
2023-01-17 09:00:00	QQQ	ETF	279.96	280.86	279.94	280.72	502618.0
2023-01-17 09:30:00	QQQ	ETF	280.77	281.455	279.581	281.16	4108318.0
2023-01-17 10:00:00	QQQ	ETF	281.15	282.85	281.15	282.2	3113292.0
2023-01-17 10:30:00	QQQ	ETF	282.2	282.325	280.44	281.03	2366357.0
2023-01-17 11:00:00	QQQ	ETF	281.03	281.23	279.7	280.35	1994562.0
2023-01-17 11:30:00	QQQ	ETF	280.38	281.46	280.32	281.2294	1220147.0
2023-01-17 12:00:00	QQQ	ETF	281.26	281.5575	280.52	280.72	1046613.0
2023-01-17 12:30:00	QQQ	ETF	280.72	281.64	280.64	281.45	1306866.0

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

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