PREVIEW / etf_30min / 2022-09-07

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-09-07.parquet
  size:    648 KB
  rows:    25,771

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-09-07 04:00:00	SPY	ETF	391.01	391.96	390.94	391.19	41386.0
2022-09-07 04:30:00	SPY	ETF	391.13	391.68	390.88	391.63	15296.0
2022-09-07 05:00:00	SPY	ETF	391.62	391.65	391.01	391.21	12470.0
2022-09-07 05:30:00	SPY	ETF	391.2	391.52	391.0	391.51	130007.0
2022-09-07 06:00:00	SPY	ETF	391.6	391.65	390.98	391.46	34989.0
2022-09-07 06:30:00	SPY	ETF	391.42	391.6	391.03	391.33	9529.0
2022-09-07 07:00:00	SPY	ETF	391.3	391.53	391.11	391.47	79339.0
2022-09-07 07:30:00	SPY	ETF	391.47	391.47	389.93	390.44	266687.0
2022-09-07 08:00:00	SPY	ETF	391.29	391.51	389.0	389.53	328394.0
2022-09-07 08:30:00	SPY	ETF	389.54	390.42	389.48	390.12	174591.0
2022-09-07 09:00:00	SPY	ETF	390.06	390.7	389.85	390.41	227700.0
2022-09-07 09:30:00	SPY	ETF	390.43	392.75	390.2	391.73	5610542.0
2022-09-07 10:00:00	SPY	ETF	391.73	392.45	390.8	392.37	3860254.0
2022-09-07 10:30:00	SPY	ETF	392.38	393.39	392.14	392.79	3493258.0
2022-09-07 11:00:00	SPY	ETF	392.78	394.5	392.35	393.895	3429152.0
2022-09-07 11:30:00	SPY	ETF	393.9	394.46	393.43	393.97	2395399.0
2022-09-07 12:00:00	SPY	ETF	393.99	394.2843	392.85	393.49	2236974.0
2022-09-07 12:30:00	SPY	ETF	393.49	395.15	393.09	394.72	2967727.0
2022-09-07 13:00:00	SPY	ETF	394.69	395.4	394.55	394.665	2135637.0
2022-09-07 13:30:00	SPY	ETF	394.69	396.58	394.615	396.45	3186227.0
2022-09-07 14:00:00	SPY	ETF	396.45	397.56	396.17	397.15	5060835.0
2022-09-07 14:30:00	SPY	ETF	397.17	397.8899	396.88	397.78	3361153.0
2022-09-07 15:00:00	SPY	ETF	397.8	398.59	397.51	398.5301	4171007.0
2022-09-07 15:30:00	SPY	ETF	398.53	398.56	397.43	397.77	9477788.0
2022-09-07 16:00:00	SPY	ETF	397.77	397.89	397.32	397.78	5279198.0
2022-09-07 16:30:00	SPY	ETF	397.81	397.84	397.56	397.56	224681.0
2022-09-07 17:00:00	SPY	ETF	397.56	397.85	397.5301	397.85	43620.0
2022-09-07 17:30:00	SPY	ETF	397.8003	397.85	397.72	397.8	14572.0
2022-09-07 18:00:00	SPY	ETF	397.8	398.21	397.8	398.0	41796.0
2022-09-07 18:30:00	SPY	ETF	398.0	398.0	397.66	397.88	15375.0
2022-09-07 19:00:00	SPY	ETF	397.86	398.0	397.61	397.61	27931.0
2022-09-07 19:30:00	SPY	ETF	397.61	397.65	397.31	397.46	46512.0
2022-09-07 04:00:00	QQQ	ETF	293.5	294.4	293.47	293.64	51470.0
2022-09-07 04:30:00	QQQ	ETF	293.67	294.1	293.33	294.06	16690.0
2022-09-07 05:00:00	QQQ	ETF	293.62	293.95	293.4	293.77	16484.0
2022-09-07 05:30:00	QQQ	ETF	293.72	293.98	293.51	293.89	10427.0
2022-09-07 06:00:00	QQQ	ETF	293.96	294.0	293.45	293.8	13810.0
2022-09-07 06:30:00	QQQ	ETF	293.66	293.87	293.46	293.53	81595.0
2022-09-07 07:00:00	QQQ	ETF	293.54	293.66	293.17	293.59	127856.0
2022-09-07 07:30:00	QQQ	ETF	293.6	293.68	292.07	292.75	234217.0
2022-09-07 08:00:00	QQQ	ETF	293.57	293.6996	291.84	292.2	294045.0
2022-09-07 08:30:00	QQQ	ETF	292.33	293.09	292.33	292.85	197525.0
2022-09-07 09:00:00	QQQ	ETF	292.82	293.6	292.72	293.54	374584.0
2022-09-07 09:30:00	QQQ	ETF	293.54	295.66	293.42	294.48	5703401.0
2022-09-07 10:00:00	QQQ	ETF	294.46	294.9136	293.27	294.305	3404970.0
2022-09-07 10:30:00	QQQ	ETF	294.32	295.24	293.73	294.39	2737404.0
2022-09-07 11:00:00	QQQ	ETF	294.3995	296.28	294.0	295.635	2302408.0
2022-09-07 11:30:00	QQQ	ETF	295.64	296.47	295.26	296.0716	1732982.0
2022-09-07 12:00:00	QQQ	ETF	296.0699	296.33	295.01	295.44	1481860.0
2022-09-07 12:30:00	QQQ	ETF	295.42	296.76	295.05	296.39	1962127.0

> showing 50 of 25,771 rows — these rows as CSV

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