PREVIEW / etf_30min / 2024-06-18

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-06-18.parquet
  size:    814 KB
  rows:    32,533

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
2024-06-18 04:00:00	SPY	ETF	546.88	547.05	546.61	546.61	8845.0
2024-06-18 04:30:00	SPY	ETF	546.91	547.22	546.81	547.17	13028.0
2024-06-18 05:00:00	SPY	ETF	547.32	547.49	547.1	547.11	4261.0
2024-06-18 05:30:00	SPY	ETF	547.12	547.39	547.05	547.2	2143.0
2024-06-18 06:00:00	SPY	ETF	547.13	547.26	547.01	547.26	1311.0
2024-06-18 06:30:00	SPY	ETF	547.37	547.5	547.04	547.04	5797.0
2024-06-18 07:00:00	SPY	ETF	547.07	547.1	546.94	547.05	25375.0
2024-06-18 07:30:00	SPY	ETF	547.03	547.11	546.95	547.0	21854.0
2024-06-18 08:00:00	SPY	ETF	547.0686	547.38	546.85	547.29	52169.0
2024-06-18 08:30:00	SPY	ETF	547.38	547.75	546.75	546.94	204797.0
2024-06-18 09:00:00	SPY	ETF	546.95	547.28	546.66	547.2	96213.0
2024-06-18 09:30:00	SPY	ETF	547.16	548.22	547.11	547.53	2572000.0
2024-06-18 10:00:00	SPY	ETF	547.54	547.91	547.18	547.41	1284579.0
2024-06-18 10:30:00	SPY	ETF	547.415	547.96	546.9696	547.1	1128500.0
2024-06-18 11:00:00	SPY	ETF	547.1112	547.37	546.73	547.08	837030.0
2024-06-18 11:30:00	SPY	ETF	547.06	547.8202	546.97	547.805	1088995.0
2024-06-18 12:00:00	SPY	ETF	547.8001	548.07	547.3501	547.37	1109443.0
2024-06-18 12:30:00	SPY	ETF	547.37	547.96	547.23	547.85	884880.0
2024-06-18 13:00:00	SPY	ETF	547.84	548.17	547.46	548.07	1046427.0
2024-06-18 13:30:00	SPY	ETF	548.07	548.62	547.8701	548.12	1120142.0
2024-06-18 14:00:00	SPY	ETF	548.11	548.15	547.09	547.7438	1985296.0
2024-06-18 14:30:00	SPY	ETF	547.74	548.03	547.559	548.03	1242434.0
2024-06-18 15:00:00	SPY	ETF	548.04	548.07	547.4105	547.885	1448737.0
2024-06-18 15:30:00	SPY	ETF	547.9	548.5	547.69	548.49	5777630.0
2024-06-18 16:00:00	SPY	ETF	548.48	548.64	548.11	548.5	2766818.0
2024-06-18 16:30:00	SPY	ETF	548.52	548.55	548.44	548.49	113014.0
2024-06-18 17:00:00	SPY	ETF	548.48	548.55	548.43	548.43	24594.0
2024-06-18 17:30:00	SPY	ETF	548.44	548.5	548.4	548.47	24943.0
2024-06-18 18:00:00	SPY	ETF	548.49	548.68	548.41	548.6	28439.0
2024-06-18 18:30:00	SPY	ETF	548.67	548.979	548.67	548.9	10577.0
2024-06-18 19:00:00	SPY	ETF	548.87	548.89	548.73	548.73	6684.0
2024-06-18 19:30:00	SPY	ETF	548.73	548.81	548.68	548.8	5457.0
2024-06-18 04:00:00	QQQ	ETF	485.38	485.89	485.38	485.61	30975.0
2024-06-18 04:30:00	QQQ	ETF	485.6	486.05	485.56	485.85	13470.0
2024-06-18 05:00:00	QQQ	ETF	486.06	486.5	485.84	485.9	19560.0
2024-06-18 05:30:00	QQQ	ETF	485.91	486.21	485.86	486.05	6098.0
2024-06-18 06:00:00	QQQ	ETF	486.11	486.31	485.72	486.31	10769.0
2024-06-18 06:30:00	QQQ	ETF	486.25	486.25	485.87	485.87	10327.0
2024-06-18 07:00:00	QQQ	ETF	485.91	486.07	485.591	485.76	103278.0
2024-06-18 07:30:00	QQQ	ETF	485.77	485.86	485.55	485.83	23921.0
2024-06-18 08:00:00	QQQ	ETF	485.74	486.4196	484.69	486.08	63546.0
2024-06-18 08:30:00	QQQ	ETF	486.09	486.88	485.08	485.46	300449.0
2024-06-18 09:00:00	QQQ	ETF	485.46	485.46	484.8785	485.051	138431.0
2024-06-18 09:30:00	QQQ	ETF	485.0	485.68	484.38	484.71	2959613.0
2024-06-18 10:00:00	QQQ	ETF	484.72	485.54	484.46	484.74	1322265.0
2024-06-18 10:30:00	QQQ	ETF	484.74	485.2608	484.135	484.26	1065968.0
2024-06-18 11:00:00	QQQ	ETF	484.275	484.6723	483.43	484.15	1326923.0
2024-06-18 11:30:00	QQQ	ETF	484.135	484.92	484.04	484.885	871144.0
2024-06-18 12:00:00	QQQ	ETF	484.88	485.13	484.47	484.62	802650.0
2024-06-18 12:30:00	QQQ	ETF	484.61	485.44	484.45	485.33	570967.0

> showing 50 of 32,533 rows — these rows as CSV

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