PREVIEW / etf_30min / 2023-08-07

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-08-07.parquet
  size:    689 KB
  rows:    27,631

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-08-07 04:00:00	SPY	ETF	448.94	449.08	448.45	448.52	52905.0
2023-08-07 04:30:00	SPY	ETF	448.5	448.54	447.76	448.14	4900.0
2023-08-07 05:00:00	SPY	ETF	448.14	448.22	447.91	448.13	9321.0
2023-08-07 05:30:00	SPY	ETF	448.17	448.45	448.17	448.4	3318.0
2023-08-07 06:00:00	SPY	ETF	448.38	448.38	447.68	447.7	10668.0
2023-08-07 06:30:00	SPY	ETF	447.5	447.93	447.47	447.78	32615.0
2023-08-07 07:00:00	SPY	ETF	447.82	448.06	447.73	447.81	94214.0
2023-08-07 07:30:00	SPY	ETF	447.81	448.0	447.72	447.88	31388.0
2023-08-07 08:00:00	SPY	ETF	447.94	448.76	447.44	447.51	143963.0
2023-08-07 08:30:00	SPY	ETF	447.58	448.72	447.51	448.72	280283.0
2023-08-07 09:00:00	SPY	ETF	448.69	448.81	448.45	448.72	335822.0
2023-08-07 09:30:00	SPY	ETF	448.71	449.65	448.2601	448.49	6199395.0
2023-08-07 10:00:00	SPY	ETF	448.49	449.77	447.99	449.63	5228483.0
2023-08-07 10:30:00	SPY	ETF	449.62	449.9	448.88	449.07	3535507.0
2023-08-07 11:00:00	SPY	ETF	449.09	449.3	448.35	448.69	2733473.0
2023-08-07 11:30:00	SPY	ETF	448.68	449.63	448.25	449.52	2641397.0
2023-08-07 12:00:00	SPY	ETF	449.52	449.68	449.1	449.57	1748852.0
2023-08-07 12:30:00	SPY	ETF	449.56	449.815	448.95	449.66	1593885.0
2023-08-07 13:00:00	SPY	ETF	449.66	449.97	449.53	449.64	1805128.0
2023-08-07 13:30:00	SPY	ETF	449.66	450.22	449.48	450.21	1763121.0
2023-08-07 14:00:00	SPY	ETF	450.22	450.5	449.475	449.62	2161354.0
2023-08-07 14:30:00	SPY	ETF	449.635	450.3	449.61	450.09	1776633.0
2023-08-07 15:00:00	SPY	ETF	450.1	450.395	449.69	449.75	1851312.0
2023-08-07 15:30:00	SPY	ETF	449.75	450.865	449.62	450.7	8108602.0
2023-08-07 16:00:00	SPY	ETF	450.7	451.05	450.57	450.97	3414909.0
2023-08-07 16:30:00	SPY	ETF	450.96	451.06	450.91	450.91	112930.0
2023-08-07 17:00:00	SPY	ETF	450.91	451.05	450.85	450.93	57836.0
2023-08-07 17:30:00	SPY	ETF	451.0	451.01	450.92	451.0	17260.0
2023-08-07 18:00:00	SPY	ETF	450.93	450.97	450.65	450.71	58596.0
2023-08-07 18:30:00	SPY	ETF	450.69	450.82	450.67	450.73	14937.0
2023-08-07 19:00:00	SPY	ETF	450.76	450.76	450.66	450.7	3552.0
2023-08-07 19:30:00	SPY	ETF	450.74	450.79	450.6898	450.75	16649.0
2023-08-07 04:00:00	QQQ	ETF	374.61	374.65	373.56	373.96	53586.0
2023-08-07 04:30:00	QQQ	ETF	374.05	374.05	373.29	373.65	37942.0
2023-08-07 05:00:00	QQQ	ETF	373.67	373.86	373.5	373.84	20960.0
2023-08-07 05:30:00	QQQ	ETF	373.87	374.12	373.87	374.0	7689.0
2023-08-07 06:00:00	QQQ	ETF	373.8	373.99	373.09	373.14	115541.0
2023-08-07 06:30:00	QQQ	ETF	373.03	373.62	373.0	373.53	33597.0
2023-08-07 07:00:00	QQQ	ETF	373.46	373.62	373.3	373.46	83569.0
2023-08-07 07:30:00	QQQ	ETF	373.5	373.63	373.31	373.53	53869.0
2023-08-07 08:00:00	QQQ	ETF	373.44	374.66	372.94	373.12	124158.0
2023-08-07 08:30:00	QQQ	ETF	373.12	374.12	373.05	374.08	188375.0
2023-08-07 09:00:00	QQQ	ETF	374.06	374.31	373.82	373.89	221351.0
2023-08-07 09:30:00	QQQ	ETF	373.89	374.85	372.45	372.78	4800795.0
2023-08-07 10:00:00	QQQ	ETF	372.72	374.04	372.05	373.7	2672308.0
2023-08-07 10:30:00	QQQ	ETF	373.67	374.14	372.73	372.94	1944564.0
2023-08-07 11:00:00	QQQ	ETF	372.945	373.0899	371.62	372.125	2489917.0
2023-08-07 11:30:00	QQQ	ETF	372.1	373.52	371.51	373.44	2124273.0
2023-08-07 12:00:00	QQQ	ETF	373.46	373.7273	372.9806	373.6296	1344959.0
2023-08-07 12:30:00	QQQ	ETF	373.608	373.77	372.8801	373.661	1100048.0

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

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