PREVIEW / etf_30min / 2022-12-05

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-12-05.parquet
  size:    696 KB
  rows:    27,907

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
2022-12-05 04:00:00	SPY	ETF	406.91	406.91	404.8	405.67	39814.0
2022-12-05 04:30:00	SPY	ETF	405.56	405.73	405.36	405.5	62753.0
2022-12-05 05:00:00	SPY	ETF	405.46	405.72	405.17	405.26	19359.0
2022-12-05 05:30:00	SPY	ETF	405.13	405.27	404.89	405.05	73614.0
2022-12-05 06:00:00	SPY	ETF	405.17	405.45	405.0	405.25	52148.0
2022-12-05 06:30:00	SPY	ETF	405.22	405.75	405.13	405.65	25774.0
2022-12-05 07:00:00	SPY	ETF	405.71	405.72	404.95	404.95	284410.0
2022-12-05 07:30:00	SPY	ETF	404.97	405.04	404.64	404.95	165197.0
2022-12-05 08:00:00	SPY	ETF	404.96	406.2	404.47	405.059	235837.0
2022-12-05 08:30:00	SPY	ETF	405.09	405.14	403.82	404.0	410624.0
2022-12-05 09:00:00	SPY	ETF	404.0101	404.28	403.87	403.92	254428.0
2022-12-05 09:30:00	SPY	ETF	403.95	404.93	403.28	403.32	4899148.0
2022-12-05 10:00:00	SPY	ETF	403.28	403.46	401.59	402.75	5977751.0
2022-12-05 10:30:00	SPY	ETF	402.75	403.66	402.31	403.35	2641222.0
2022-12-05 11:00:00	SPY	ETF	403.35	403.9781	402.25	402.505	3502347.0
2022-12-05 11:30:00	SPY	ETF	402.51	402.55	400.88	400.95	3334630.0
2022-12-05 12:00:00	SPY	ETF	400.94	401.83	400.68	401.38	2911839.0
2022-12-05 12:30:00	SPY	ETF	401.37	401.51	400.24	400.36	2362692.0
2022-12-05 13:00:00	SPY	ETF	400.36	400.93	400.03	400.4	2532590.0
2022-12-05 13:30:00	SPY	ETF	400.41	400.9	399.12	399.1901	2728517.0
2022-12-05 14:00:00	SPY	ETF	399.17	399.7	398.67	398.86	3208328.0
2022-12-05 14:30:00	SPY	ETF	398.82	399.05	398.17	398.9354	3622117.0
2022-12-05 15:00:00	SPY	ETF	398.92	399.49	398.62	398.69	3405210.0
2022-12-05 15:30:00	SPY	ETF	398.7	399.95	398.67	399.61	9009293.0
2022-12-05 16:00:00	SPY	ETF	399.62	399.96	399.52	399.77	5715170.0
2022-12-05 16:30:00	SPY	ETF	399.76	400.04	399.59	400.0	200776.0
2022-12-05 17:00:00	SPY	ETF	400.02	400.06	399.94	400.05	38011.0
2022-12-05 17:30:00	SPY	ETF	399.99	400.15	399.91	400.01	18809.0
2022-12-05 18:00:00	SPY	ETF	400.01	400.43	399.8	400.34	129768.0
2022-12-05 18:30:00	SPY	ETF	400.27	400.41	400.22	400.23	15876.0
2022-12-05 19:00:00	SPY	ETF	400.3	400.56	399.57	400.53	104200.0
2022-12-05 19:30:00	SPY	ETF	400.54	400.56	400.19	400.41	50768.0
2022-12-05 04:00:00	QQQ	ETF	292.08	292.15	291.24	291.95	23362.0
2022-12-05 04:30:00	QQQ	ETF	292.01	292.01	291.74	291.8	57568.0
2022-12-05 05:00:00	QQQ	ETF	291.85	292.0	291.53	291.69	26686.0
2022-12-05 05:30:00	QQQ	ETF	291.56	291.8	291.44	291.77	9420.0
2022-12-05 06:00:00	QQQ	ETF	291.7	291.95	291.59	291.85	11055.0
2022-12-05 06:30:00	QQQ	ETF	291.85	292.23	291.81	292.23	29964.0
2022-12-05 07:00:00	QQQ	ETF	292.22	292.26	291.4	291.4	62411.0
2022-12-05 07:30:00	QQQ	ETF	291.36	291.46	291.15	291.39	60304.0
2022-12-05 08:00:00	QQQ	ETF	292.08	292.769	290.95	291.43	153566.0
2022-12-05 08:30:00	QQQ	ETF	291.45	291.57	290.41	290.54	238998.0
2022-12-05 09:00:00	QQQ	ETF	290.57	290.82	290.39	290.42	346164.0
2022-12-05 09:30:00	QQQ	ETF	290.38	291.68	290.19	290.69	3376296.0
2022-12-05 10:00:00	QQQ	ETF	290.68	290.68	289.01	289.56	3763816.0
2022-12-05 10:30:00	QQQ	ETF	289.52	290.7	289.0	290.46	1870205.0
2022-12-05 11:00:00	QQQ	ETF	290.47	291.16	289.5241	289.69	1588660.0
2022-12-05 11:30:00	QQQ	ETF	289.7	289.7301	288.52	288.641	2071562.0
2022-12-05 12:00:00	QQQ	ETF	288.6	289.25	288.34	288.915	1686955.0
2022-12-05 12:30:00	QQQ	ETF	288.91	289.03	287.87	287.956	1644603.0

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

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