PREVIEW / etf_30min / 2023-11-06

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-11-06.parquet
  size:    739 KB
  rows:    29,473

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-11-06 04:00:00	SPY	ETF	435.02	435.57	435.02	435.46	65506.0
2023-11-06 04:30:00	SPY	ETF	435.5	435.67	435.3	435.56	6195.0
2023-11-06 05:00:00	SPY	ETF	435.74	435.77	435.62	435.66	7556.0
2023-11-06 05:30:00	SPY	ETF	435.58	435.6	435.44	435.6	5071.0
2023-11-06 06:00:00	SPY	ETF	435.56	435.66	435.47	435.53	5510.0
2023-11-06 06:30:00	SPY	ETF	435.55	435.91	435.55	435.66	30997.0
2023-11-06 07:00:00	SPY	ETF	435.66	435.7	435.29	435.42	64799.0
2023-11-06 07:30:00	SPY	ETF	435.43	435.72	435.3	435.54	48330.0
2023-11-06 08:00:00	SPY	ETF	435.53	435.8596	434.96	435.2104	163583.0
2023-11-06 08:30:00	SPY	ETF	435.25	435.58	435.22	435.37	143863.0
2023-11-06 09:00:00	SPY	ETF	435.42	435.77	435.35	435.47	143309.0
2023-11-06 09:30:00	SPY	ETF	435.47	436.1498	435.01	435.45	5793053.0
2023-11-06 10:00:00	SPY	ETF	435.46	435.63	434.74	435.28	4197217.0
2023-11-06 10:30:00	SPY	ETF	435.28	435.8801	435.04	435.42	3373079.0
2023-11-06 11:00:00	SPY	ETF	435.43	435.81	435.33	435.45	2510233.0
2023-11-06 11:30:00	SPY	ETF	435.46	435.64	435.04	435.565	2425570.0
2023-11-06 12:00:00	SPY	ETF	435.57	435.64	434.9	435.04	1927793.0
2023-11-06 12:30:00	SPY	ETF	435.04	435.16	434.4796	434.98	2500098.0
2023-11-06 13:00:00	SPY	ETF	434.99	434.995	433.68	434.22	3661782.0
2023-11-06 13:30:00	SPY	ETF	434.2	434.54	433.95	434.2912	3039216.0
2023-11-06 14:00:00	SPY	ETF	434.3	434.45	433.71	434.2899	3108646.0
2023-11-06 14:30:00	SPY	ETF	434.28	435.17	434.19	435.09	3521039.0
2023-11-06 15:00:00	SPY	ETF	435.09	435.26	434.81	435.02	3285595.0
2023-11-06 15:30:00	SPY	ETF	435.03	435.74	434.7	435.65	9676081.0
2023-11-06 16:00:00	SPY	ETF	435.65	435.73	435.0	435.28	4047307.0
2023-11-06 16:30:00	SPY	ETF	435.28	435.36	435.27	435.27	188947.0
2023-11-06 17:00:00	SPY	ETF	435.33	435.45	435.26	435.39	22729.0
2023-11-06 17:30:00	SPY	ETF	435.3	435.38	435.27	435.27	10923.0
2023-11-06 18:00:00	SPY	ETF	435.27	435.27	434.79	434.89	71882.0
2023-11-06 18:30:00	SPY	ETF	434.91	434.92	434.78	434.9	10386.0
2023-11-06 19:00:00	SPY	ETF	434.89	434.92	434.8	434.9	7298.0
2023-11-06 19:30:00	SPY	ETF	434.81	434.84	434.74	434.75	45900.0
2023-11-06 04:00:00	QQQ	ETF	367.99	368.7	367.99	368.56	65226.0
2023-11-06 04:30:00	QQQ	ETF	368.39	368.8	368.39	368.74	11426.0
2023-11-06 05:00:00	QQQ	ETF	368.82	369.0	368.78	368.82	45907.0
2023-11-06 05:30:00	QQQ	ETF	368.82	368.9	368.6	368.83	57092.0
2023-11-06 06:00:00	QQQ	ETF	368.81	368.82	368.61	368.61	3854.0
2023-11-06 06:30:00	QQQ	ETF	368.58	368.91	368.58	368.74	9773.0
2023-11-06 07:00:00	QQQ	ETF	368.75	368.83	368.55	368.55	48175.0
2023-11-06 07:30:00	QQQ	ETF	368.56	368.78	368.36	368.59	60741.0
2023-11-06 08:00:00	QQQ	ETF	368.71	368.9796	367.87	368.33	158637.0
2023-11-06 08:30:00	QQQ	ETF	368.32	368.68	368.31	368.5	73993.0
2023-11-06 09:00:00	QQQ	ETF	368.53	368.78	368.37	368.45	223654.0
2023-11-06 09:30:00	QQQ	ETF	368.49	369.78	368.33	368.8	4298466.0
2023-11-06 10:00:00	QQQ	ETF	368.83	369.09	368.02	368.69	2841453.0
2023-11-06 10:30:00	QQQ	ETF	368.71	369.5	368.55	368.92	1833243.0
2023-11-06 11:00:00	QQQ	ETF	368.91	369.38	368.8	368.9	1889310.0
2023-11-06 11:30:00	QQQ	ETF	368.92	369.0895	368.25	368.97	1871370.0
2023-11-06 12:00:00	QQQ	ETF	368.97	369.0	368.19	368.48	1329357.0
2023-11-06 12:30:00	QQQ	ETF	368.47	368.62	367.95	368.54	1648544.0

> showing 50 of 29,473 rows — these rows as CSV

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