PREVIEW / etf_30min / 2022-12-16

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-12-16.parquet
  size:    701 KB
  rows:    27,934

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-12-16 04:00:00	SPY	ETF	383.94	387.85	383.2	383.69	95812.0
2022-12-16 04:30:00	SPY	ETF	383.68	384.06	383.3	383.99	24192.0
2022-12-16 05:00:00	SPY	ETF	383.76	384.05	382.7	382.91	115938.0
2022-12-16 05:30:00	SPY	ETF	382.85	383.31	382.5	382.98	46346.0
2022-12-16 06:00:00	SPY	ETF	382.76	383.99	382.64	383.89	63207.0
2022-12-16 06:30:00	SPY	ETF	383.77	384.1	383.43	383.68	50224.0
2022-12-16 07:00:00	SPY	ETF	383.7	384.6	383.58	383.75	169364.0
2022-12-16 07:30:00	SPY	ETF	383.72	385.05	383.42	385.05	262977.0
2022-12-16 08:00:00	SPY	ETF	384.2387	387.9	382.6	384.38	381565.0
2022-12-16 08:30:00	SPY	ETF	384.24	384.4	383.7	384.2	287878.0
2022-12-16 09:00:00	SPY	ETF	384.19	385.19	383.3	385.11	958885.0
2022-12-16 09:30:00	SPY	ETF	385.19	386.575	384.53	385.87	6800619.0
2022-12-16 10:00:00	SPY	ETF	385.87	385.88	382.61	382.64	6802043.0
2022-12-16 10:30:00	SPY	ETF	382.64	383.19	381.85	383.07	5209317.0
2022-12-16 11:00:00	SPY	ETF	383.05	383.5289	381.95	382.44	3542421.0
2022-12-16 11:30:00	SPY	ETF	382.465	383.1	381.36	381.54	3100726.0
2022-12-16 12:00:00	SPY	ETF	381.56	382.21	381.455	382.13	2604799.0
2022-12-16 12:30:00	SPY	ETF	382.12	382.889	381.04	381.175	3248572.0
2022-12-16 13:00:00	SPY	ETF	381.17	381.847	381.07	381.16	2417621.0
2022-12-16 13:30:00	SPY	ETF	381.17	382.06	381.08	381.725	3019443.0
2022-12-16 14:00:00	SPY	ETF	381.7	382.77	381.58	381.725	3941117.0
2022-12-16 14:30:00	SPY	ETF	381.74	383.27	381.2	382.93	3798851.0
2022-12-16 15:00:00	SPY	ETF	382.93	384.22	382.375	384.08	6589974.0
2022-12-16 15:30:00	SPY	ETF	384.09	384.96	383.28	383.3	16742000.0
2022-12-16 16:00:00	SPY	ETF	383.29	384.26	382.42	382.85	6503222.0
2022-12-16 16:30:00	SPY	ETF	382.73	383.27	382.48	382.73	257586.0
2022-12-16 17:00:00	SPY	ETF	382.74	382.9	382.46	382.46	119353.0
2022-12-16 17:30:00	SPY	ETF	382.46	382.69	382.4	382.64	97934.0
2022-12-16 18:00:00	SPY	ETF	383.27	383.27	382.4	382.59	836768.0
2022-12-16 18:30:00	SPY	ETF	382.58	382.64	382.51	382.61	13443.0
2022-12-16 19:00:00	SPY	ETF	382.57	382.57	382.45	382.45	6133.0
2022-12-16 19:30:00	SPY	ETF	382.45	382.54	382.2	382.5	43643.0
2022-12-16 04:00:00	QQQ	ETF	273.85	276.23	273.39	273.79	82384.0
2022-12-16 04:30:00	QQQ	ETF	273.85	274.28	273.61	274.27	31858.0
2022-12-16 05:00:00	QQQ	ETF	274.2	274.54	273.7	273.94	52882.0
2022-12-16 05:30:00	QQQ	ETF	273.82	274.22	273.69	274.13	24986.0
2022-12-16 06:00:00	QQQ	ETF	274.19	274.95	273.93	274.95	39760.0
2022-12-16 06:30:00	QQQ	ETF	274.82	275.1	274.58	274.75	64938.0
2022-12-16 07:00:00	QQQ	ETF	274.81	275.4	274.79	274.94	101704.0
2022-12-16 07:30:00	QQQ	ETF	274.85	276.0	274.72	276.0	220857.0
2022-12-16 08:00:00	QQQ	ETF	275.13	277.097	273.6696	275.58	322552.0
2022-12-16 08:30:00	QQQ	ETF	275.48	275.58	274.97	275.47	243025.0
2022-12-16 09:00:00	QQQ	ETF	275.48	276.29	274.68	276.15	771398.0
2022-12-16 09:30:00	QQQ	ETF	276.2	277.77	275.7	276.9001	4876083.0
2022-12-16 10:00:00	QQQ	ETF	276.9	276.9	274.07	274.0899	3880674.0
2022-12-16 10:30:00	QQQ	ETF	274.095	274.69	273.46	274.51	3621283.0
2022-12-16 11:00:00	QQQ	ETF	274.5111	274.6395	273.3101	273.55	2587355.0
2022-12-16 11:30:00	QQQ	ETF	273.55	274.28	273.05	273.2299	2252424.0
2022-12-16 12:00:00	QQQ	ETF	273.235	273.76	273.0	273.71	1654081.0
2022-12-16 12:30:00	QQQ	ETF	273.71	274.435	272.84	272.9805	2070874.0

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

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