PREVIEW / etf_30min / 2023-03-22

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-03-22.parquet
  size:    698 KB
  rows:    27,861

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-03-22 04:00:00	SPY	ETF	397.94	398.09	397.47	397.66	47759.0
2023-03-22 04:30:00	SPY	ETF	397.67	398.19	397.67	397.85	9393.0
2023-03-22 05:00:00	SPY	ETF	397.88	398.46	397.76	398.46	25625.0
2023-03-22 05:30:00	SPY	ETF	398.4	398.56	398.27	398.37	14208.0
2023-03-22 06:00:00	SPY	ETF	398.3	398.57	398.08	398.48	10701.0
2023-03-22 06:30:00	SPY	ETF	398.37	399.06	398.34	398.92	19077.0
2023-03-22 07:00:00	SPY	ETF	398.9	399.34	398.86	399.11	43362.0
2023-03-22 07:30:00	SPY	ETF	399.07	399.1	398.52	398.67	67191.0
2023-03-22 08:00:00	SPY	ETF	398.86	399.32	397.78	398.4699	114734.0
2023-03-22 08:30:00	SPY	ETF	398.47	398.78	398.3699	398.76	108908.0
2023-03-22 09:00:00	SPY	ETF	398.72	399.06	398.7	398.74	370397.0
2023-03-22 09:30:00	SPY	ETF	398.73	398.875	398.08	398.57	4870400.0
2023-03-22 10:00:00	SPY	ETF	398.58	399.86	398.31	399.7416	3432082.0
2023-03-22 10:30:00	SPY	ETF	399.74	399.88	399.13	399.25	2948412.0
2023-03-22 11:00:00	SPY	ETF	399.24	399.39	398.39	398.89	2721050.0
2023-03-22 11:30:00	SPY	ETF	398.9025	399.16	398.73	398.915	1904564.0
2023-03-22 12:00:00	SPY	ETF	398.91	398.98	398.05	398.2675	2658425.0
2023-03-22 12:30:00	SPY	ETF	398.285	398.41	397.84	397.93	2028568.0
2023-03-22 13:00:00	SPY	ETF	397.94	398.275	397.37	398.216	2430086.0
2023-03-22 13:30:00	SPY	ETF	398.23	398.77	398.13	398.54	2506761.0
2023-03-22 14:00:00	SPY	ETF	398.58	401.7	398.43	399.935	11094998.0
2023-03-22 14:30:00	SPY	ETF	399.92	402.49	397.4	398.56	14806886.0
2023-03-22 15:00:00	SPY	ETF	398.56	399.89	395.67	398.95	12012361.0
2023-03-22 15:30:00	SPY	ETF	398.89	399.18	392.07	392.14	17438401.0
2023-03-22 16:00:00	SPY	ETF	392.16	392.84	391.87	392.57	5504377.0
2023-03-22 16:30:00	SPY	ETF	392.57	392.99	392.11	392.35	979342.0
2023-03-22 17:00:00	SPY	ETF	392.41	392.65	392.22	392.62	88204.0
2023-03-22 17:30:00	SPY	ETF	392.59	392.59	392.37	392.4	33035.0
2023-03-22 18:00:00	SPY	ETF	392.57	393.0	392.51	392.679	104888.0
2023-03-22 18:30:00	SPY	ETF	392.73	393.0	392.73	392.9	56093.0
2023-03-22 19:00:00	SPY	ETF	392.88	392.89	392.54	392.75	25675.0
2023-03-22 19:30:00	SPY	ETF	392.8	392.9	392.58	392.76	29584.0
2023-03-22 04:00:00	QQQ	ETF	309.28	309.34	308.75	308.83	39886.0
2023-03-22 04:30:00	QQQ	ETF	308.86	309.1	308.81	308.93	10828.0
2023-03-22 05:00:00	QQQ	ETF	308.82	309.5	308.81	309.5	16132.0
2023-03-22 05:30:00	QQQ	ETF	309.46	309.64	309.39	309.39	10501.0
2023-03-22 06:00:00	QQQ	ETF	309.48	309.7	309.32	309.61	27695.0
2023-03-22 06:30:00	QQQ	ETF	309.54	309.89	309.46	309.83	13792.0
2023-03-22 07:00:00	QQQ	ETF	309.78	310.14	309.76	310.1	37183.0
2023-03-22 07:30:00	QQQ	ETF	310.05	310.06	309.59	309.75	63177.0
2023-03-22 08:00:00	QQQ	ETF	309.7614	310.572	308.8296	309.48	103083.0
2023-03-22 08:30:00	QQQ	ETF	309.49	309.89	309.44	309.85	65274.0
2023-03-22 09:00:00	QQQ	ETF	309.78	310.34	309.76	310.26	147640.0
2023-03-22 09:30:00	QQQ	ETF	310.27	310.82	309.74	310.51	2784620.0
2023-03-22 10:00:00	QQQ	ETF	310.5	311.85	310.035	311.6905	3268110.0
2023-03-22 10:30:00	QQQ	ETF	311.69	311.8	310.94	311.215	1780307.0
2023-03-22 11:00:00	QQQ	ETF	311.21	311.5	310.59	311.36	1151652.0
2023-03-22 11:30:00	QQQ	ETF	311.36	311.978	311.36	311.66	1642793.0
2023-03-22 12:00:00	QQQ	ETF	311.67	311.67	310.29	310.49	1576257.0
2023-03-22 12:30:00	QQQ	ETF	310.49	310.82	310.34	310.7	990039.0

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

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