PREVIEW / etf_30min / 2022-10-14

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-10-14.parquet
  size:    664 KB
  rows:    27,068

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
2022-10-14 04:00:00	SPY	ETF	366.81	366.93	365.13	365.25	40055.0
2022-10-14 04:30:00	SPY	ETF	365.24	365.5	364.38	364.56	12928.0
2022-10-14 05:00:00	SPY	ETF	364.41	365.05	364.33	364.39	22267.0
2022-10-14 05:30:00	SPY	ETF	364.41	365.32	364.0	365.27	26017.0
2022-10-14 06:00:00	SPY	ETF	365.25	368.04	365.21	367.23	165868.0
2022-10-14 06:30:00	SPY	ETF	367.3	367.66	366.48	367.58	74185.0
2022-10-14 07:00:00	SPY	ETF	367.6	368.03	367.1	367.32	238752.0
2022-10-14 07:30:00	SPY	ETF	367.25	367.25	365.08	365.15	238705.0
2022-10-14 08:00:00	SPY	ETF	368.125	369.1671	365.05	366.3	1951494.0
2022-10-14 08:30:00	SPY	ETF	366.71	371.2	365.33	370.12	1757474.0
2022-10-14 09:00:00	SPY	ETF	370.14	370.4	368.27	368.53	1151244.0
2022-10-14 09:30:00	SPY	ETF	368.53	370.26	365.99	366.6	10542408.0
2022-10-14 10:00:00	SPY	ETF	366.61	366.62	360.62	361.9501	12139503.0
2022-10-14 10:30:00	SPY	ETF	361.9628	362.86	360.32	362.0602	6019308.0
2022-10-14 11:00:00	SPY	ETF	362.07	363.53	360.63	362.17	4790016.0
2022-10-14 11:30:00	SPY	ETF	362.16	362.19	359.31	359.745	5221498.0
2022-10-14 12:00:00	SPY	ETF	359.72	361.0682	358.45	359.69	6085145.0
2022-10-14 12:30:00	SPY	ETF	359.67	360.79	359.11	359.33	3782999.0
2022-10-14 13:00:00	SPY	ETF	359.34	360.23	358.51	359.411	3706280.0
2022-10-14 13:30:00	SPY	ETF	359.42	360.17	359.16	360.12	3373215.0
2022-10-14 14:00:00	SPY	ETF	360.135	360.15	357.8	358.38	3368878.0
2022-10-14 14:30:00	SPY	ETF	358.365	358.52	357.56	358.4683	3535312.0
2022-10-14 15:00:00	SPY	ETF	358.46	359.38	357.38	358.705	5927451.0
2022-10-14 15:30:00	SPY	ETF	358.7	359.43	356.96	357.68	15391849.0
2022-10-14 16:00:00	SPY	ETF	357.67	358.0	357.0	357.63	5546130.0
2022-10-14 16:30:00	SPY	ETF	357.58	357.85	357.5	357.5	212324.0
2022-10-14 17:00:00	SPY	ETF	357.48	357.61	357.12	357.22	162228.0
2022-10-14 17:30:00	SPY	ETF	357.22	357.5	357.2	357.2	24380.0
2022-10-14 18:00:00	SPY	ETF	357.23	357.35	357.05	357.07	27612.0
2022-10-14 18:30:00	SPY	ETF	357.05	357.1	356.97	356.97	15311.0
2022-10-14 19:00:00	SPY	ETF	356.96	357.0	356.76	356.76	10477.0
2022-10-14 19:30:00	SPY	ETF	356.85	356.89	356.5	356.6	51150.0
2022-10-14 04:00:00	QQQ	ETF	269.39	269.4	267.63	267.82	51796.0
2022-10-14 04:30:00	QQQ	ETF	267.97	268.03	266.98	267.1	28047.0
2022-10-14 05:00:00	QQQ	ETF	267.03	267.52	266.8	266.96	53644.0
2022-10-14 05:30:00	QQQ	ETF	266.92	267.9	266.66	267.7	68209.0
2022-10-14 06:00:00	QQQ	ETF	267.85	269.75	267.67	269.21	89269.0
2022-10-14 06:30:00	QQQ	ETF	269.33	269.62	268.75	269.48	79057.0
2022-10-14 07:00:00	QQQ	ETF	269.43	269.76	268.96	269.24	251235.0
2022-10-14 07:30:00	QQQ	ETF	269.2	269.2	267.42	267.44	193807.0
2022-10-14 08:00:00	QQQ	ETF	269.0699	270.99	266.8996	268.5	335249.0
2022-10-14 08:30:00	QQQ	ETF	268.9	272.88	267.75	272.06	1234778.0
2022-10-14 09:00:00	QQQ	ETF	272.11	272.24	270.7	271.16	928274.0
2022-10-14 09:30:00	QQQ	ETF	271.18	271.81	267.5	268.0548	8775549.0
2022-10-14 10:00:00	QQQ	ETF	268.0	268.0	263.41	264.84	9170178.0
2022-10-14 10:30:00	QQQ	ETF	264.81	265.51	263.23	264.73	4485742.0
2022-10-14 11:00:00	QQQ	ETF	264.78	266.08	263.462	264.87	4044901.0
2022-10-14 11:30:00	QQQ	ETF	264.86	264.885	262.49	262.78	3720984.0
2022-10-14 12:00:00	QQQ	ETF	262.775	263.8	261.58	262.7901	3835984.0
2022-10-14 12:30:00	QQQ	ETF	262.77	263.515	262.16	262.4249	2223081.0

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

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