PREVIEW / etf_30min / 2022-10-07

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-10-07.parquet
  size:    669 KB
  rows:    26,980

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-07 04:00:00	SPY	ETF	372.2	372.6	371.78	372.29	19229.0
2022-10-07 04:30:00	SPY	ETF	372.44	372.8	372.15	372.79	12513.0
2022-10-07 05:00:00	SPY	ETF	372.73	373.37	372.73	373.31	18082.0
2022-10-07 05:30:00	SPY	ETF	373.42	373.65	373.29	373.41	8419.0
2022-10-07 06:00:00	SPY	ETF	373.47	373.47	372.67	372.69	20035.0
2022-10-07 06:30:00	SPY	ETF	372.75	373.24	372.75	373.11	33334.0
2022-10-07 07:00:00	SPY	ETF	373.08	373.55	373.0	373.14	68337.0
2022-10-07 07:30:00	SPY	ETF	373.22	373.49	372.87	373.1	57255.0
2022-10-07 08:00:00	SPY	ETF	373.11	374.24	371.7	373.8	710734.0
2022-10-07 08:30:00	SPY	ETF	373.39	374.47	367.7	369.0813	4027820.0
2022-10-07 09:00:00	SPY	ETF	369.1	369.88	368.36	368.95	1119742.0
2022-10-07 09:30:00	SPY	ETF	368.97	369.37	365.36	365.53	8461569.0
2022-10-07 10:00:00	SPY	ETF	365.54	366.93	364.77	366.22	6740813.0
2022-10-07 10:30:00	SPY	ETF	366.24	367.14	365.57	366.46	4097808.0
2022-10-07 11:00:00	SPY	ETF	366.4507	367.12	365.12	365.8311	3550608.0
2022-10-07 11:30:00	SPY	ETF	365.84	366.12	364.87	365.29	3269114.0
2022-10-07 12:00:00	SPY	ETF	365.29	365.82	364.2	364.31	3595461.0
2022-10-07 12:30:00	SPY	ETF	364.31	364.33	363.44	363.81	3897826.0
2022-10-07 13:00:00	SPY	ETF	363.8101	364.2299	363.11	363.84	3242080.0
2022-10-07 13:30:00	SPY	ETF	363.83	364.37	363.25	363.43	2912599.0
2022-10-07 14:00:00	SPY	ETF	363.43	363.82	362.63	362.68	4174680.0
2022-10-07 14:30:00	SPY	ETF	362.66	363.1	362.28	362.78	3506831.0
2022-10-07 15:00:00	SPY	ETF	362.77	363.5	361.29	361.62	5292006.0
2022-10-07 15:30:00	SPY	ETF	361.62	363.26	360.94	362.8	17919588.0
2022-10-07 16:00:00	SPY	ETF	362.8	363.0	362.33	362.52	6001802.0
2022-10-07 16:30:00	SPY	ETF	362.52	362.79	362.46	362.77	227271.0
2022-10-07 17:00:00	SPY	ETF	362.79	362.79	362.45	362.5	79391.0
2022-10-07 17:30:00	SPY	ETF	362.6	362.69	362.37	362.37	37754.0
2022-10-07 18:00:00	SPY	ETF	362.35	362.37	362.14	362.18	65541.0
2022-10-07 18:30:00	SPY	ETF	362.18	362.29	362.16	362.29	13372.0
2022-10-07 19:00:00	SPY	ETF	362.25	362.25	362.0	362.0	23483.0
2022-10-07 19:30:00	SPY	ETF	362.0	362.1	361.95	361.95	22087.0
2022-10-07 04:00:00	QQQ	ETF	278.44	278.77	278.02	278.62	28212.0
2022-10-07 04:30:00	QQQ	ETF	278.48	278.87	278.46	278.81	16097.0
2022-10-07 05:00:00	QQQ	ETF	278.77	279.38	278.76	279.16	25136.0
2022-10-07 05:30:00	QQQ	ETF	279.15	279.46	279.05	279.17	18429.0
2022-10-07 06:00:00	QQQ	ETF	279.02	279.03	278.5	278.52	24867.0
2022-10-07 06:30:00	QQQ	ETF	278.52	278.98	278.4	278.65	27196.0
2022-10-07 07:00:00	QQQ	ETF	278.87	279.2	278.75	278.9	26832.0
2022-10-07 07:30:00	QQQ	ETF	278.92	279.17	278.66	278.88	48378.0
2022-10-07 08:00:00	QQQ	ETF	278.99	279.969	278.35	279.75	378198.0
2022-10-07 08:30:00	QQQ	ETF	279.36	279.99	274.0	275.23	3689300.0
2022-10-07 09:00:00	QQQ	ETF	275.2	275.78	274.46	275.04	942486.0
2022-10-07 09:30:00	QQQ	ETF	275.02	275.15	271.96	272.175	7865546.0
2022-10-07 10:00:00	QQQ	ETF	272.18	273.38	271.67	272.63	5285056.0
2022-10-07 10:30:00	QQQ	ETF	272.65	273.05	271.76	272.41	3048223.0
2022-10-07 11:00:00	QQQ	ETF	272.42	272.91	271.17	271.8287	2898962.0
2022-10-07 11:30:00	QQQ	ETF	271.77	272.08	270.76	271.26	2367658.0
2022-10-07 12:00:00	QQQ	ETF	271.21	271.62	270.22	270.31	2171691.0
2022-10-07 12:30:00	QQQ	ETF	270.3	270.32	269.68	270.03	2469115.0

> showing 50 of 26,980 rows — these rows as CSV

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