PREVIEW / etf_30min / 2023-06-07

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-06-07.parquet
  size:    709 KB
  rows:    28,237

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-06-07 04:00:00	SPY	ETF	427.71	427.71	427.4	427.52	18468.0
2023-06-07 04:30:00	SPY	ETF	427.62	427.75	427.53	427.69	5335.0
2023-06-07 05:00:00	SPY	ETF	427.72	427.86	427.56	427.84	4253.0
2023-06-07 05:30:00	SPY	ETF	427.9	427.91	427.7	427.76	4488.0
2023-06-07 06:00:00	SPY	ETF	427.81	428.19	427.81	428.18	8643.0
2023-06-07 06:30:00	SPY	ETF	428.1	428.38	428.1	428.35	3123.0
2023-06-07 07:00:00	SPY	ETF	428.32	428.46	428.25	428.27	52200.0
2023-06-07 07:30:00	SPY	ETF	428.26	428.83	428.26	428.83	64420.0
2023-06-07 08:00:00	SPY	ETF	428.3499	428.83	427.5604	428.51	265118.0
2023-06-07 08:30:00	SPY	ETF	428.51	428.59	428.35	428.46	74511.0
2023-06-07 09:00:00	SPY	ETF	428.5	428.7	428.39	428.45	114002.0
2023-06-07 09:30:00	SPY	ETF	428.44	429.62	428.34	429.29	5989745.0
2023-06-07 10:00:00	SPY	ETF	429.295	429.4	427.96	428.385	5688982.0
2023-06-07 10:30:00	SPY	ETF	428.38	428.658	427.03	427.67	5430899.0
2023-06-07 11:00:00	SPY	ETF	427.67	427.93	427.27	427.7491	3183187.0
2023-06-07 11:30:00	SPY	ETF	427.76	428.2	426.8	426.895	3374186.0
2023-06-07 12:00:00	SPY	ETF	426.91	427.43	426.655	426.86	3106836.0
2023-06-07 12:30:00	SPY	ETF	426.87	427.55	426.65	426.88	2355411.0
2023-06-07 13:00:00	SPY	ETF	426.89	427.2001	426.14	426.56	3485309.0
2023-06-07 13:30:00	SPY	ETF	426.565	426.85	426.11	426.715	3491846.0
2023-06-07 14:00:00	SPY	ETF	426.71	427.395	426.58	427.0082	2860879.0
2023-06-07 14:30:00	SPY	ETF	427.005	427.055	426.28	426.97	2678066.0
2023-06-07 15:00:00	SPY	ETF	426.96	427.25	426.4	426.91	3146149.0
2023-06-07 15:30:00	SPY	ETF	426.905	427.15	426.115	426.6	14173146.0
2023-06-07 16:00:00	SPY	ETF	426.59	426.71	426.43	426.6578	2925629.0
2023-06-07 16:30:00	SPY	ETF	426.66	426.67	426.5	426.52	237683.0
2023-06-07 17:00:00	SPY	ETF	426.55	426.62	426.28	426.59	79604.0
2023-06-07 17:30:00	SPY	ETF	426.59	426.6	426.55	426.55	58092.0
2023-06-07 18:00:00	SPY	ETF	426.56	426.84	426.54	426.7099	91021.0
2023-06-07 18:30:00	SPY	ETF	426.68	426.68	426.44	426.48	41228.0
2023-06-07 19:00:00	SPY	ETF	426.45	426.5699	426.45	426.49	10727.0
2023-06-07 19:30:00	SPY	ETF	426.47	426.65	426.47	426.62	27131.0
2023-06-07 04:00:00	QQQ	ETF	354.08	354.16	353.9	354.11	21812.0
2023-06-07 04:30:00	QQQ	ETF	354.13	354.28	354.06	354.22	11787.0
2023-06-07 05:00:00	QQQ	ETF	354.28	354.47	354.1	354.44	7984.0
2023-06-07 05:30:00	QQQ	ETF	354.54	354.54	354.33	354.39	2526.0
2023-06-07 06:00:00	QQQ	ETF	354.45	354.89	354.45	354.81	16844.0
2023-06-07 06:30:00	QQQ	ETF	354.83	354.98	354.75	354.9	21140.0
2023-06-07 07:00:00	QQQ	ETF	354.95	355.21	354.921	355.02	117776.0
2023-06-07 07:30:00	QQQ	ETF	354.98	355.64	354.98	355.63	69537.0
2023-06-07 08:00:00	QQQ	ETF	354.9685	355.65	354.1604	355.32	148607.0
2023-06-07 08:30:00	QQQ	ETF	355.33	355.46	355.09	355.26	134432.0
2023-06-07 09:00:00	QQQ	ETF	355.26	355.47	355.09	355.09	143756.0
2023-06-07 09:30:00	QQQ	ETF	355.13	357.12	355.13	356.0687	5568019.0
2023-06-07 10:00:00	QQQ	ETF	356.05	356.25	353.67	354.08	4547474.0
2023-06-07 10:30:00	QQQ	ETF	354.075	354.39	351.63	352.2462	4571370.0
2023-06-07 11:00:00	QQQ	ETF	352.265	352.79	351.7	352.57	2669942.0
2023-06-07 11:30:00	QQQ	ETF	352.565	353.11	351.07	351.2	3718114.0
2023-06-07 12:00:00	QQQ	ETF	351.21	351.84	349.82	350.17	3455421.0
2023-06-07 12:30:00	QQQ	ETF	350.19	351.13	350.04	350.22	3334306.0

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

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