PREVIEW / etf_30min / 2023-12-12

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-12-12.parquet
  size:    772 KB
  rows:    30,310

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-12-12 04:00:00	SPY	ETF	462.98	462.98	462.24	462.53	11225.0
2023-12-12 04:30:00	SPY	ETF	462.45	462.8	462.36	462.8	22570.0
2023-12-12 05:00:00	SPY	ETF	462.72	462.72	462.4	462.49	13330.0
2023-12-12 05:30:00	SPY	ETF	462.48	462.48	462.2	462.29	13699.0
2023-12-12 06:00:00	SPY	ETF	462.21	462.39	462.2	462.32	4300.0
2023-12-12 06:30:00	SPY	ETF	462.26	462.29	462.11	462.16	90370.0
2023-12-12 07:00:00	SPY	ETF	462.17	462.63	462.14	462.54	75742.0
2023-12-12 07:30:00	SPY	ETF	462.57	462.81	462.48	462.68	99375.0
2023-12-12 08:00:00	SPY	ETF	462.27	463.4	461.99	463.28	439075.0
2023-12-12 08:30:00	SPY	ETF	462.98	463.93	461.63	461.74	1057124.0
2023-12-12 09:00:00	SPY	ETF	461.76	462.19	461.39	461.63	392623.0
2023-12-12 09:30:00	SPY	ETF	461.64	461.7	460.6	461.495	5232929.0
2023-12-12 10:00:00	SPY	ETF	461.5	462.37	461.315	462.03	3596828.0
2023-12-12 10:30:00	SPY	ETF	462.03	462.6866	461.94	462.66	2911850.0
2023-12-12 11:00:00	SPY	ETF	462.66	462.835	462.385	462.5	2761240.0
2023-12-12 11:30:00	SPY	ETF	462.51	462.82	462.44	462.59	2105431.0
2023-12-12 12:00:00	SPY	ETF	462.59	462.89	462.24	462.83	2110338.0
2023-12-12 12:30:00	SPY	ETF	462.8328	463.12	462.5	462.62	2549618.0
2023-12-12 13:00:00	SPY	ETF	462.62	463.0681	462.51	462.88	2020061.0
2023-12-12 13:30:00	SPY	ETF	462.88	463.28	462.8101	463.21	1829467.0
2023-12-12 14:00:00	SPY	ETF	463.21	463.29	463.04	463.25	1849652.0
2023-12-12 14:30:00	SPY	ETF	463.26	463.61	463.2502	463.565	2012806.0
2023-12-12 15:00:00	SPY	ETF	463.57	464.12	463.51	464.09	3789257.0
2023-12-12 15:30:00	SPY	ETF	464.0901	464.2	463.59	464.16	8625004.0
2023-12-12 16:00:00	SPY	ETF	464.17	464.47	462.7076	464.45	3408612.0
2023-12-12 16:30:00	SPY	ETF	464.44	464.48	464.37	464.41	118112.0
2023-12-12 17:00:00	SPY	ETF	464.46	464.46	464.36	464.36	29745.0
2023-12-12 17:30:00	SPY	ETF	464.33	464.42	464.1363	464.38	92160.0
2023-12-12 18:00:00	SPY	ETF	464.38	464.77	464.37	464.55	158141.0
2023-12-12 18:30:00	SPY	ETF	464.59	464.66	464.57	464.66	8050.0
2023-12-12 19:00:00	SPY	ETF	464.66	464.74	464.64	464.7	13039.0
2023-12-12 19:30:00	SPY	ETF	464.69	464.72	464.56	464.72	36494.0
2023-12-12 04:00:00	QQQ	ETF	396.2	396.41	396.14	396.24	21653.0
2023-12-12 04:30:00	QQQ	ETF	396.22	396.46	396.05	396.46	19354.0
2023-12-12 05:00:00	QQQ	ETF	396.4	396.4	396.27	396.27	4200.0
2023-12-12 05:30:00	QQQ	ETF	396.2	396.2	396.12	396.12	4126.0
2023-12-12 06:00:00	QQQ	ETF	396.11	396.32	396.1	396.25	9638.0
2023-12-12 06:30:00	QQQ	ETF	396.16	396.22	396.06	396.12	5485.0
2023-12-12 07:00:00	QQQ	ETF	396.15	396.61	396.09	396.59	62567.0
2023-12-12 07:30:00	QQQ	ETF	396.54	396.82	396.45	396.72	87241.0
2023-12-12 08:00:00	QQQ	ETF	396.46	397.5	395.816	397.5	317248.0
2023-12-12 08:30:00	QQQ	ETF	397.61	398.06	395.56	395.76	1093126.0
2023-12-12 09:00:00	QQQ	ETF	395.79	396.17	395.49	395.5	425122.0
2023-12-12 09:30:00	QQQ	ETF	395.56	396.115	394.41	396.11	4059345.0
2023-12-12 10:00:00	QQQ	ETF	396.12	396.69	395.81	396.11	2078722.0
2023-12-12 10:30:00	QQQ	ETF	396.1301	396.88	395.9399	396.85	1671924.0
2023-12-12 11:00:00	QQQ	ETF	396.845	397.32	396.64	396.83	1763937.0
2023-12-12 11:30:00	QQQ	ETF	396.83	397.13	396.4793	396.59	1225058.0
2023-12-12 12:00:00	QQQ	ETF	396.6	396.76	396.09	396.6901	1147514.0
2023-12-12 12:30:00	QQQ	ETF	396.7078	397.015	396.55	396.85	1154876.0

> showing 50 of 30,310 rows — these rows as CSV

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