PREVIEW / etf_30min / 2023-06-27

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-06-27.parquet
  size:    697 KB
  rows:    27,430

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-06-27 04:00:00	SPY	ETF	432.45	432.72	432.37	432.48	21334.0
2023-06-27 04:30:00	SPY	ETF	432.41	432.41	432.09	432.22	15990.0
2023-06-27 05:00:00	SPY	ETF	432.15	432.33	432.1	432.33	6093.0
2023-06-27 05:30:00	SPY	ETF	432.29	432.29	432.15	432.18	2636.0
2023-06-27 06:00:00	SPY	ETF	432.32	432.32	432.11	432.23	7131.0
2023-06-27 06:30:00	SPY	ETF	432.39	432.5	432.28	432.47	9472.0
2023-06-27 07:00:00	SPY	ETF	432.49	432.5	432.03	432.06	56962.0
2023-06-27 07:30:00	SPY	ETF	432.08	432.08	431.68	431.74	57546.0
2023-06-27 08:00:00	SPY	ETF	432.3301	432.94	431.59	431.92	103180.0
2023-06-27 08:30:00	SPY	ETF	431.86	432.53	431.83	432.15	135499.0
2023-06-27 09:00:00	SPY	ETF	432.1	432.43	432.02	432.35	118083.0
2023-06-27 09:30:00	SPY	ETF	432.35	433.3	432.23	432.73	5003714.0
2023-06-27 10:00:00	SPY	ETF	432.72	433.11	431.88	432.8	4499120.0
2023-06-27 10:30:00	SPY	ETF	432.81	433.43	432.6	433.35	3628701.0
2023-06-27 11:00:00	SPY	ETF	433.35	433.93	432.54	433.83	3700647.0
2023-06-27 11:30:00	SPY	ETF	433.825	434.32	433.7636	434.2099	3139531.0
2023-06-27 12:00:00	SPY	ETF	434.21	434.72	434.1	434.64	2265395.0
2023-06-27 12:30:00	SPY	ETF	434.64	435.35	434.495	435.0799	2727741.0
2023-06-27 13:00:00	SPY	ETF	435.07	435.69	434.78	435.53	2415447.0
2023-06-27 13:30:00	SPY	ETF	435.54	436.28	435.54	436.225	2877140.0
2023-06-27 14:00:00	SPY	ETF	436.23	436.59	436.095	436.485	3234431.0
2023-06-27 14:30:00	SPY	ETF	436.49	436.63	436.09	436.135	3200612.0
2023-06-27 15:00:00	SPY	ETF	436.15	436.769	436.145	436.74	3029703.0
2023-06-27 15:30:00	SPY	ETF	436.74	436.81	436.08	436.14	10179030.0
2023-06-27 16:00:00	SPY	ETF	436.13	436.1974	435.68	435.82	3488552.0
2023-06-27 16:30:00	SPY	ETF	435.83	435.85	435.7	435.81	321052.0
2023-06-27 17:00:00	SPY	ETF	435.85	436.17	435.72	435.83	547151.0
2023-06-27 17:30:00	SPY	ETF	435.83	435.85	435.72	435.81	20847.0
2023-06-27 18:00:00	SPY	ETF	435.75	435.83	435.58	435.63	62268.0
2023-06-27 18:30:00	SPY	ETF	435.6	435.64	435.43	435.49	68783.0
2023-06-27 19:00:00	SPY	ETF	435.4899	435.5	435.3	435.4	16376.0
2023-06-27 19:30:00	SPY	ETF	435.4	435.54	435.38	435.45	38618.0
2023-06-27 04:00:00	QQQ	ETF	358.9	359.38	358.86	359.19	30977.0
2023-06-27 04:30:00	QQQ	ETF	359.14	359.14	358.74	358.97	9186.0
2023-06-27 05:00:00	QQQ	ETF	358.98	359.28	358.88	359.28	5242.0
2023-06-27 05:30:00	QQQ	ETF	359.11	359.25	359.07	359.21	6406.0
2023-06-27 06:00:00	QQQ	ETF	359.27	359.35	359.17	359.19	14428.0
2023-06-27 06:30:00	QQQ	ETF	359.18	359.66	359.18	359.55	44247.0
2023-06-27 07:00:00	QQQ	ETF	359.52	359.55	359.11	359.21	56363.0
2023-06-27 07:30:00	QQQ	ETF	359.1	359.19	358.8	358.89	56389.0
2023-06-27 08:00:00	QQQ	ETF	359.5406	359.5406	357.948	359.01	158221.0
2023-06-27 08:30:00	QQQ	ETF	358.88	359.68	358.88	359.13	177930.0
2023-06-27 09:00:00	QQQ	ETF	359.13	359.48	358.89	359.36	225462.0
2023-06-27 09:30:00	QQQ	ETF	359.25	360.51	358.77	360.25	4421135.0
2023-06-27 10:00:00	QQQ	ETF	360.18	361.67	358.51	359.57	3324035.0
2023-06-27 10:30:00	QQQ	ETF	359.56	359.9168	358.95	359.64	2046938.0
2023-06-27 11:00:00	QQQ	ETF	359.67	360.77	358.551	360.76	2140177.0
2023-06-27 11:30:00	QQQ	ETF	360.765	361.51	360.5709	361.41	2318595.0
2023-06-27 12:00:00	QQQ	ETF	361.42	361.895	361.25	361.875	1549091.0
2023-06-27 12:30:00	QQQ	ETF	361.89	362.82	361.72	362.47	2579283.0

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

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