PREVIEW / etf_30min / 2022-11-09

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-11-09.parquet
  size:    674 KB
  rows:    27,207

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-11-09 04:00:00	SPY	ETF	382.12	382.23	381.05	381.5	94230.0
2022-11-09 04:30:00	SPY	ETF	381.29	381.36	380.07	380.2	37232.0
2022-11-09 05:00:00	SPY	ETF	380.37	380.48	379.75	380.15	32803.0
2022-11-09 05:30:00	SPY	ETF	380.31	381.34	380.31	381.15	19150.0
2022-11-09 06:00:00	SPY	ETF	381.28	382.02	381.11	381.86	31508.0
2022-11-09 06:30:00	SPY	ETF	381.8	382.02	381.27	381.46	44554.0
2022-11-09 07:00:00	SPY	ETF	381.53	381.57	380.51	380.6	151560.0
2022-11-09 07:30:00	SPY	ETF	380.73	381.86	380.7	381.76	129521.0
2022-11-09 08:00:00	SPY	ETF	381.18	382.44	379.82	380.07	386329.0
2022-11-09 08:30:00	SPY	ETF	380.08	381.01	379.64	379.97	468088.0
2022-11-09 09:00:00	SPY	ETF	379.91	380.66	379.43	379.85	276677.0
2022-11-09 09:30:00	SPY	ETF	379.85	380.09	378.15	378.715	6553544.0
2022-11-09 10:00:00	SPY	ETF	378.71	381.14	378.46	379.58	4993178.0
2022-11-09 10:30:00	SPY	ETF	379.5999	379.9899	377.5	378.2489	4298141.0
2022-11-09 11:00:00	SPY	ETF	378.25	379.67	378.1968	379.1401	2611281.0
2022-11-09 11:30:00	SPY	ETF	379.14	380.23	378.53	379.068	2505784.0
2022-11-09 12:00:00	SPY	ETF	379.05	379.2999	378.08	378.2801	1934338.0
2022-11-09 12:30:00	SPY	ETF	378.22	378.96	377.89	378.5299	1984230.0
2022-11-09 13:00:00	SPY	ETF	378.52	378.79	377.11	377.27	3017077.0
2022-11-09 13:30:00	SPY	ETF	377.24	377.25	375.46	376.14	4246567.0
2022-11-09 14:00:00	SPY	ETF	376.14	376.8399	375.73	376.34	3194042.0
2022-11-09 14:30:00	SPY	ETF	376.365	376.365	374.56	374.8395	4058638.0
2022-11-09 15:00:00	SPY	ETF	374.82	376.19	374.68	375.305	3832216.0
2022-11-09 15:30:00	SPY	ETF	375.32	375.38	373.61	374.15	10750208.0
2022-11-09 16:00:00	SPY	ETF	374.15	374.56	373.95	374.231	4737508.0
2022-11-09 16:30:00	SPY	ETF	374.23	374.53	373.99	374.2	243029.0
2022-11-09 17:00:00	SPY	ETF	374.2999	374.4	374.12	374.18	35143.0
2022-11-09 17:30:00	SPY	ETF	374.22	374.24	374.04	374.17	21077.0
2022-11-09 18:00:00	SPY	ETF	374.17	374.59	374.05	374.2	45115.0
2022-11-09 18:30:00	SPY	ETF	374.28	374.34	374.08	374.31	13637.0
2022-11-09 19:00:00	SPY	ETF	374.29	374.9	374.26	374.82	34235.0
2022-11-09 19:30:00	SPY	ETF	374.81	375.01	374.4	374.81	90176.0
2022-11-09 04:00:00	QQQ	ETF	270.05	270.05	269.03	269.49	174830.0
2022-11-09 04:30:00	QQQ	ETF	269.26	269.42	268.22	268.43	32384.0
2022-11-09 05:00:00	QQQ	ETF	268.52	268.52	267.88	268.16	36498.0
2022-11-09 05:30:00	QQQ	ETF	268.27	269.21	268.26	269.14	55373.0
2022-11-09 06:00:00	QQQ	ETF	269.06	269.86	269.06	269.72	27671.0
2022-11-09 06:30:00	QQQ	ETF	269.72	269.86	269.26	269.48	34066.0
2022-11-09 07:00:00	QQQ	ETF	269.44	269.501	268.48	268.68	135371.0
2022-11-09 07:30:00	QQQ	ETF	268.7	269.7	268.7	269.58	76153.0
2022-11-09 08:00:00	QQQ	ETF	269.416	270.49	267.59	267.88	406863.0
2022-11-09 08:30:00	QQQ	ETF	267.88	268.69	267.59	267.86	438182.0
2022-11-09 09:00:00	QQQ	ETF	267.8	268.59	267.49	267.75	429829.0
2022-11-09 09:30:00	QQQ	ETF	267.76	268.34	266.42	266.795	6423933.0
2022-11-09 10:00:00	QQQ	ETF	266.78	268.56	266.47	267.19	4962727.0
2022-11-09 10:30:00	QQQ	ETF	267.18	267.54	265.61	266.21	3037442.0
2022-11-09 11:00:00	QQQ	ETF	266.22	267.52	266.15	266.96	2270320.0
2022-11-09 11:30:00	QQQ	ETF	266.96	268.0601	266.38	266.9199	2051952.0
2022-11-09 12:00:00	QQQ	ETF	266.91	267.145	266.06	266.33	1719487.0
2022-11-09 12:30:00	QQQ	ETF	266.31	266.74	265.91	266.35	1466385.0

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

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