PREVIEW / etf_30min / 2022-10-06

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-10-06.parquet
  size:    652 KB
  rows:    26,577

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-10-06 04:00:00	SPY	ETF	377.06	377.48	375.74	375.8	37950.0
2022-10-06 04:30:00	SPY	ETF	376.03	376.19	375.43	375.5	26988.0
2022-10-06 05:00:00	SPY	ETF	375.54	375.79	375.14	375.55	19506.0
2022-10-06 05:30:00	SPY	ETF	375.5	375.53	374.5	374.5	43752.0
2022-10-06 06:00:00	SPY	ETF	374.55	374.55	374.0	374.32	40406.0
2022-10-06 06:30:00	SPY	ETF	374.26	374.68	374.23	374.4	32431.0
2022-10-06 07:00:00	SPY	ETF	374.45	375.25	374.45	374.89	217947.0
2022-10-06 07:30:00	SPY	ETF	374.89	375.49	374.89	375.17	86520.0
2022-10-06 08:00:00	SPY	ETF	375.13	379.4	374.0596	375.7	311349.0
2022-10-06 08:30:00	SPY	ETF	375.69	377.36	375.69	376.34	502634.0
2022-10-06 09:00:00	SPY	ETF	376.35	376.35	375.33	375.66	517155.0
2022-10-06 09:30:00	SPY	ETF	375.62	378.72	375.34	376.23	7528449.0
2022-10-06 10:00:00	SPY	ETF	376.24	376.26	373.61	373.66	7343086.0
2022-10-06 10:30:00	SPY	ETF	373.6601	376.49	373.41	376.42	4580311.0
2022-10-06 11:00:00	SPY	ETF	376.43	376.825	374.91	376.51	4899507.0
2022-10-06 11:30:00	SPY	ETF	376.52	376.94	374.5809	374.68	4165891.0
2022-10-06 12:00:00	SPY	ETF	374.68	375.39	373.98	375.31	3120463.0
2022-10-06 12:30:00	SPY	ETF	375.31	376.31	374.74	375.46	2910215.0
2022-10-06 13:00:00	SPY	ETF	375.47	375.9524	374.72	375.79	2743768.0
2022-10-06 13:30:00	SPY	ETF	375.79	375.79	374.7	375.41	2231679.0
2022-10-06 14:00:00	SPY	ETF	375.41	375.45	374.04	374.39	3237871.0
2022-10-06 14:30:00	SPY	ETF	374.42	374.94	372.74	373.46	3887157.0
2022-10-06 15:00:00	SPY	ETF	373.4445	374.47	372.68	374.46	4148617.0
2022-10-06 15:30:00	SPY	ETF	374.46	374.5929	372.92	373.22	8849339.0
2022-10-06 16:00:00	SPY	ETF	373.21	373.65	372.59	372.67	3440264.0
2022-10-06 16:30:00	SPY	ETF	372.77	372.94	372.6	372.71	206957.0
2022-10-06 17:00:00	SPY	ETF	372.67	372.76	372.52	372.62	36553.0
2022-10-06 17:30:00	SPY	ETF	372.62	373.2	372.42	372.65	40825.0
2022-10-06 18:00:00	SPY	ETF	372.57	372.7	371.81	372.38	85417.0
2022-10-06 18:30:00	SPY	ETF	372.5	372.69	372.18	372.18	22167.0
2022-10-06 19:00:00	SPY	ETF	372.15	372.94	372.15	372.85	23623.0
2022-10-06 19:30:00	SPY	ETF	372.91	372.93	372.01	372.19	47427.0
2022-10-06 04:00:00	QQQ	ETF	282.46	282.46	280.8	280.85	51871.0
2022-10-06 04:30:00	QQQ	ETF	281.0	281.07	280.46	280.65	20201.0
2022-10-06 05:00:00	QQQ	ETF	280.78	281.0	280.46	280.69	25908.0
2022-10-06 05:30:00	QQQ	ETF	280.79	280.8	279.83	279.87	38420.0
2022-10-06 06:00:00	QQQ	ETF	279.83	279.93	279.38	279.6	70576.0
2022-10-06 06:30:00	QQQ	ETF	279.69	280.04	279.56	279.84	50775.0
2022-10-06 07:00:00	QQQ	ETF	279.92	280.66	279.85	280.36	240369.0
2022-10-06 07:30:00	QQQ	ETF	280.36	280.93	280.35	280.74	106430.0
2022-10-06 08:00:00	QQQ	ETF	280.45	283.7	279.7604	280.95	290474.0
2022-10-06 08:30:00	QQQ	ETF	281.08	282.72	280.95	281.71	643759.0
2022-10-06 09:00:00	QQQ	ETF	281.71	281.71	280.63	280.94	580459.0
2022-10-06 09:30:00	QQQ	ETF	280.97	284.18	280.95	282.13	6399193.0
2022-10-06 10:00:00	QQQ	ETF	282.14	282.15	279.45	279.5	6312254.0
2022-10-06 10:30:00	QQQ	ETF	279.51	282.29	279.43	282.2104	3541085.0
2022-10-06 11:00:00	QQQ	ETF	282.2301	282.65	280.79	282.39	3317284.0
2022-10-06 11:30:00	QQQ	ETF	282.4	282.88	280.75	280.83	2828448.0
2022-10-06 12:00:00	QQQ	ETF	280.81	281.35	280.27	281.26	2117392.0
2022-10-06 12:30:00	QQQ	ETF	281.25	282.24	280.69	281.57	1924253.0

> showing 50 of 26,577 rows — these rows as CSV

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