PREVIEW / etf_30min / 2023-09-20

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-09-20.parquet
  size:    707 KB
  rows:    27,874

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-09-20 04:00:00	SPY	ETF	442.98	443.25	442.65	443.15	18065.0
2023-09-20 04:30:00	SPY	ETF	443.16	443.44	443.16	443.39	16434.0
2023-09-20 05:00:00	SPY	ETF	443.45	443.56	443.24	443.34	22339.0
2023-09-20 05:30:00	SPY	ETF	443.4	443.68	443.38	443.6	6813.0
2023-09-20 06:00:00	SPY	ETF	443.53	443.67	443.45	443.46	16377.0
2023-09-20 06:30:00	SPY	ETF	443.46	443.63	443.33	443.63	16931.0
2023-09-20 07:00:00	SPY	ETF	443.59	443.79	443.5	443.51	61569.0
2023-09-20 07:30:00	SPY	ETF	443.55	443.8	443.51	443.69	62190.0
2023-09-20 08:00:00	SPY	ETF	443.5919	444.05	442.24	443.88	156092.0
2023-09-20 08:30:00	SPY	ETF	443.88	444.26	443.61	444.25	256436.0
2023-09-20 09:00:00	SPY	ETF	444.23	444.45	443.99	444.01	323746.0
2023-09-20 09:30:00	SPY	ETF	444.01	444.42	443.44	444.1	4235936.0
2023-09-20 10:00:00	SPY	ETF	444.11	444.435	443.4	443.7979	2863478.0
2023-09-20 10:30:00	SPY	ETF	443.8	443.99	443.49	443.63	1969753.0
2023-09-20 11:00:00	SPY	ETF	443.63	443.9469	443.25	443.29	1852720.0
2023-09-20 11:30:00	SPY	ETF	443.275	443.76	443.16	443.745	2068809.0
2023-09-20 12:00:00	SPY	ETF	443.74	443.86	443.48	443.841	1169887.0
2023-09-20 12:30:00	SPY	ETF	443.85	444.01	443.77	443.9703	1304621.0
2023-09-20 13:00:00	SPY	ETF	443.98	444.01	443.58	443.625	1357054.0
2023-09-20 13:30:00	SPY	ETF	443.63	443.71	443.07	443.575	1730822.0
2023-09-20 14:00:00	SPY	ETF	443.59	443.59	441.53	442.6	7680310.0
2023-09-20 14:30:00	SPY	ETF	442.57	443.75	441.47	441.81	7689462.0
2023-09-20 15:00:00	SPY	ETF	441.8	442.26	440.24	440.865	6395551.0
2023-09-20 15:30:00	SPY	ETF	440.88	440.93	438.43	438.58	14582258.0
2023-09-20 16:00:00	SPY	ETF	438.58	438.76	438.19	438.49	4470263.0
2023-09-20 16:30:00	SPY	ETF	438.5	438.59	438.19	438.24	186286.0
2023-09-20 17:00:00	SPY	ETF	438.24	438.37	438.18	438.3081	43947.0
2023-09-20 17:30:00	SPY	ETF	438.32	438.34	438.21	438.27	24070.0
2023-09-20 18:00:00	SPY	ETF	438.3	438.49	438.05	438.08	47063.0
2023-09-20 18:30:00	SPY	ETF	438.14	438.18	437.97	438.12	39710.0
2023-09-20 19:00:00	SPY	ETF	438.08	438.18	437.93	438.18	34630.0
2023-09-20 19:30:00	SPY	ETF	438.14	438.18	437.85	437.9	32859.0
2023-09-20 04:00:00	QQQ	ETF	370.05	370.3	369.67	370.21	23104.0
2023-09-20 04:30:00	QQQ	ETF	370.24	370.6	370.24	370.56	6780.0
2023-09-20 05:00:00	QQQ	ETF	370.6	370.68	370.37	370.4	14631.0
2023-09-20 05:30:00	QQQ	ETF	370.4	370.7	370.4	370.6	2872.0
2023-09-20 06:00:00	QQQ	ETF	370.51	370.63	370.4	370.4	74660.0
2023-09-20 06:30:00	QQQ	ETF	370.37	370.57	370.25	370.57	7459.0
2023-09-20 07:00:00	QQQ	ETF	370.55	370.75	370.33	370.34	25641.0
2023-09-20 07:30:00	QQQ	ETF	370.36	370.65	370.35	370.6	35868.0
2023-09-20 08:00:00	QQQ	ETF	369.24	370.87	369.11	370.72	111274.0
2023-09-20 08:30:00	QQQ	ETF	370.69	371.21	370.45	371.2	112617.0
2023-09-20 09:00:00	QQQ	ETF	371.2	371.33	370.85	370.85	264735.0
2023-09-20 09:30:00	QQQ	ETF	370.95	371.31	369.87	370.765	2462899.0
2023-09-20 10:00:00	QQQ	ETF	370.78	370.9692	369.5597	369.84	2007036.0
2023-09-20 10:30:00	QQQ	ETF	369.84	370.27	369.42	369.58	1547442.0
2023-09-20 11:00:00	QQQ	ETF	369.59	369.88	368.81	368.97	1560044.0
2023-09-20 11:30:00	QQQ	ETF	368.925	369.91	368.77	369.89	1163783.0
2023-09-20 12:00:00	QQQ	ETF	369.89	369.94	369.5	369.913	957353.0
2023-09-20 12:30:00	QQQ	ETF	369.92	370.11	369.73	370.05	857250.0

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

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