PREVIEW / etf_30min / 2021-11-22

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-11-22.parquet
  size:    660 KB
  rows:    25,782

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
2021-11-22 04:00:00	SPY	ETF	470.03	470.72	470.03	470.71	7784.0
2021-11-22 04:30:00	SPY	ETF	470.71	470.71	470.36	470.48	4459.0
2021-11-22 05:00:00	SPY	ETF	470.56	470.82	470.56	470.6	2717.0
2021-11-22 05:30:00	SPY	ETF	470.63	470.63	470.42	470.55	4968.0
2021-11-22 06:00:00	SPY	ETF	470.66	470.87	470.66	470.78	8897.0
2021-11-22 06:30:00	SPY	ETF	470.69	471.16	470.32	470.44	49690.0
2021-11-22 07:00:00	SPY	ETF	470.33	470.61	470.12	470.26	45882.0
2021-11-22 07:30:00	SPY	ETF	470.23	470.48	470.17	470.27	91191.0
2021-11-22 08:00:00	SPY	ETF	470.27	470.7296	469.241	470.03	134062.0
2021-11-22 08:30:00	SPY	ETF	470.06	470.65	470.06	470.53	102036.0
2021-11-22 09:00:00	SPY	ETF	470.52	471.68	470.38	470.82	712217.0
2021-11-22 09:30:00	SPY	ETF	470.81	472.82	470.77	472.69	6450783.0
2021-11-22 10:00:00	SPY	ETF	472.71	473.54	472.7	473.21	4558135.0
2021-11-22 10:30:00	SPY	ETF	473.22	473.47	472.65	472.79	2546842.0
2021-11-22 11:00:00	SPY	ETF	472.78	472.885	472.04	472.185	3014699.0
2021-11-22 11:30:00	SPY	ETF	472.19	472.47	469.25	470.09	4998752.0
2021-11-22 12:00:00	SPY	ETF	470.09	470.71	469.64	470.3	4610302.0
2021-11-22 12:30:00	SPY	ETF	470.3	471.17	470.19	470.685	2514443.0
2021-11-22 13:00:00	SPY	ETF	470.695	471.14	470.33	470.98	1745794.0
2021-11-22 13:30:00	SPY	ETF	470.99	471.19	470.65	470.72	1494071.0
2021-11-22 14:00:00	SPY	ETF	470.725	471.3	470.58	471.03	2239180.0
2021-11-22 14:30:00	SPY	ETF	471.03	471.88	470.97	471.7727	1985244.0
2021-11-22 15:00:00	SPY	ETF	471.79	472.4	471.315	471.34	2761820.0
2021-11-22 15:30:00	SPY	ETF	471.34	471.4	467.35	467.52	13652937.0
2021-11-22 16:00:00	SPY	ETF	467.52	470.4101	466.95	467.57	4102403.0
2021-11-22 16:30:00	SPY	ETF	467.58	467.95	467.28	467.94	429283.0
2021-11-22 17:00:00	SPY	ETF	467.96	468.02	467.9	467.9	63329.0
2021-11-22 17:30:00	SPY	ETF	467.9	467.94	467.86	467.94	39420.0
2021-11-22 18:00:00	SPY	ETF	467.95	468.27	467.95	468.15	107069.0
2021-11-22 18:30:00	SPY	ETF	467.57	468.15	467.57	468.05	18301.0
2021-11-22 19:00:00	SPY	ETF	468.0	468.35	467.8	468.35	26992.0
2021-11-22 19:30:00	SPY	ETF	468.36	468.36	468.08	468.11	31397.0
2021-11-22 04:00:00	QQQ	ETF	404.75	405.82	404.75	405.77	50658.0
2021-11-22 04:30:00	QQQ	ETF	405.77	405.77	405.55	405.69	19753.0
2021-11-22 05:00:00	QQQ	ETF	405.62	405.73	405.48	405.51	16422.0
2021-11-22 05:30:00	QQQ	ETF	405.54	405.62	405.31	405.46	29020.0
2021-11-22 06:00:00	QQQ	ETF	405.38	405.63	405.38	405.46	14815.0
2021-11-22 06:30:00	QQQ	ETF	405.42	405.78	405.42	405.68	46047.0
2021-11-22 07:00:00	QQQ	ETF	405.64	405.8	405.34	405.5	124743.0
2021-11-22 07:30:00	QQQ	ETF	405.48	405.7	405.48	405.48	64501.0
2021-11-22 08:00:00	QQQ	ETF	405.48	405.79	404.292	405.64	87749.0
2021-11-22 08:30:00	QQQ	ETF	405.61	405.96	405.6	405.89	87421.0
2021-11-22 09:00:00	QQQ	ETF	405.91	406.84	405.46	405.57	526304.0
2021-11-22 09:30:00	QQQ	ETF	405.57	408.0	405.57	407.59	5060489.0
2021-11-22 10:00:00	QQQ	ETF	407.6	408.71	407.6	408.12	3245416.0
2021-11-22 10:30:00	QQQ	ETF	408.12	408.28	406.82	407.05	2486684.0
2021-11-22 11:00:00	QQQ	ETF	407.04	407.1998	404.735	404.9449	3971800.0
2021-11-22 11:30:00	QQQ	ETF	404.96	405.51	401.12	402.321	6585848.0
2021-11-22 12:00:00	QQQ	ETF	402.32	403.0	401.34	402.37	4701268.0
2021-11-22 12:30:00	QQQ	ETF	402.37	403.68	402.3	402.9	2644235.0

> showing 50 of 25,782 rows — these rows as CSV

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