PREVIEW / etf_30min / 2023-07-13

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-07-13.parquet
  size:    729 KB
  rows:    28,716

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-07-13 04:00:00	SPY	ETF	447.32	447.61	447.27	447.49	41082.0
2023-07-13 04:30:00	SPY	ETF	447.48	447.7	447.46	447.58	7730.0
2023-07-13 05:00:00	SPY	ETF	447.63	447.88	447.63	447.7	139670.0
2023-07-13 05:30:00	SPY	ETF	447.69	447.69	447.33	447.4	93199.0
2023-07-13 06:00:00	SPY	ETF	447.44	447.51	447.16	447.39	10816.0
2023-07-13 06:30:00	SPY	ETF	447.39	447.62	447.39	447.56	13492.0
2023-07-13 07:00:00	SPY	ETF	447.51	447.56	447.28	447.4	62843.0
2023-07-13 07:30:00	SPY	ETF	447.43	447.71	447.43	447.71	173394.0
2023-07-13 08:00:00	SPY	ETF	447.73	447.8	447.1404	447.61	130483.0
2023-07-13 08:30:00	SPY	ETF	447.5	447.96	447.07	447.74	358501.0
2023-07-13 09:00:00	SPY	ETF	447.71	448.0	447.55	447.89	245274.0
2023-07-13 09:30:00	SPY	ETF	447.9	448.51	447.45	448.39	5958330.0
2023-07-13 10:00:00	SPY	ETF	448.39	448.46	447.815	447.88	3983736.0
2023-07-13 10:30:00	SPY	ETF	447.88	448.44	447.865	448.37	3261153.0
2023-07-13 11:00:00	SPY	ETF	448.38	448.51	447.94	448.08	2578007.0
2023-07-13 11:30:00	SPY	ETF	448.09	448.48	447.8821	448.46	1783566.0
2023-07-13 12:00:00	SPY	ETF	448.46	448.74	448.37	448.59	2298685.0
2023-07-13 12:30:00	SPY	ETF	448.58	448.91	448.405	448.62	2549987.0
2023-07-13 13:00:00	SPY	ETF	448.63	448.73	448.16	448.66	1940690.0
2023-07-13 13:30:00	SPY	ETF	448.67	448.845	448.62	448.69	1553214.0
2023-07-13 14:00:00	SPY	ETF	448.685	449.27	448.63	448.89	2737923.0
2023-07-13 14:30:00	SPY	ETF	448.89	449.28	448.75	449.28	1929630.0
2023-07-13 15:00:00	SPY	ETF	449.275	449.9	449.205	449.795	3910346.0
2023-07-13 15:30:00	SPY	ETF	449.79	450.38	449.53	449.53	10097044.0
2023-07-13 16:00:00	SPY	ETF	449.53	449.65	449.18	449.19	2866783.0
2023-07-13 16:30:00	SPY	ETF	449.2	449.6163	449.1	449.16	140523.0
2023-07-13 17:00:00	SPY	ETF	449.14	449.27	449.14	449.22	15209.0
2023-07-13 17:30:00	SPY	ETF	449.25	449.29	449.22	449.24	17346.0
2023-07-13 18:00:00	SPY	ETF	449.24	449.46	449.16	449.41	46994.0
2023-07-13 18:30:00	SPY	ETF	449.39	449.51	449.38	449.41	31682.0
2023-07-13 19:00:00	SPY	ETF	449.42	449.54	449.42	449.52	7453.0
2023-07-13 19:30:00	SPY	ETF	449.45	449.45	449.17	449.37	47372.0
2023-07-13 04:00:00	QQQ	ETF	374.81	375.3	373.57	375.12	29230.0
2023-07-13 04:30:00	QQQ	ETF	375.07	375.35	375.03	375.32	12165.0
2023-07-13 05:00:00	QQQ	ETF	375.33	375.59	375.29	375.42	18042.0
2023-07-13 05:30:00	QQQ	ETF	375.38	375.47	375.06	375.26	29329.0
2023-07-13 06:00:00	QQQ	ETF	375.28	375.49	375.11	375.45	16921.0
2023-07-13 06:30:00	QQQ	ETF	375.49	375.61	375.4	375.41	18608.0
2023-07-13 07:00:00	QQQ	ETF	375.41	375.46	375.07	375.1	77371.0
2023-07-13 07:30:00	QQQ	ETF	375.12	375.47	375.12	375.45	134606.0
2023-07-13 08:00:00	QQQ	ETF	375.3813	375.75	373.099	375.59	225371.0
2023-07-13 08:30:00	QQQ	ETF	375.49	376.1	374.91	375.6	389729.0
2023-07-13 09:00:00	QQQ	ETF	375.64	376.12	375.4	376.07	338166.0
2023-07-13 09:30:00	QQQ	ETF	376.05	377.0968	375.46	376.72	5519586.0
2023-07-13 10:00:00	QQQ	ETF	376.74	376.8895	375.6	375.66	3514399.0
2023-07-13 10:30:00	QQQ	ETF	375.65	376.86	375.62	376.81	2733561.0
2023-07-13 11:00:00	QQQ	ETF	376.82	377.1	376.18	376.5799	2058937.0
2023-07-13 11:30:00	QQQ	ETF	376.58	377.41	376.42	377.325	1615781.0
2023-07-13 12:00:00	QQQ	ETF	377.32	377.95	377.18	377.69	2130092.0
2023-07-13 12:30:00	QQQ	ETF	377.695	378.05	377.55	377.795	1904494.0

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

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