PREVIEW / etf_30min / 2021-09-20

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-09-20.parquet
  size:    689 KB
  rows:    26,898

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
2021-09-20 04:00:00	SPY	ETF	436.91	439.49	436.03	436.44	215173.0
2021-09-20 04:30:00	SPY	ETF	436.44	436.9	436.16	436.37	103142.0
2021-09-20 05:00:00	SPY	ETF	436.42	436.5	435.55	435.9	216721.0
2021-09-20 05:30:00	SPY	ETF	435.94	435.95	435.15	435.52	225671.0
2021-09-20 06:00:00	SPY	ETF	435.48	436.15	435.48	436.01	67867.0
2021-09-20 06:30:00	SPY	ETF	436.03	436.07	435.5	435.52	66775.0
2021-09-20 07:00:00	SPY	ETF	435.54	435.96	435.05	435.27	246842.0
2021-09-20 07:30:00	SPY	ETF	435.26	435.26	434.5	434.54	819159.0
2021-09-20 08:00:00	SPY	ETF	434.53	438.6	433.62	433.7296	802286.0
2021-09-20 08:30:00	SPY	ETF	433.62	434.48	433.48	434.15	605046.0
2021-09-20 09:00:00	SPY	ETF	434.23	435.44	433.79	434.89	837802.0
2021-09-20 09:30:00	SPY	ETF	434.88	436.56	433.92	435.72	16145652.0
2021-09-20 10:00:00	SPY	ETF	435.75	435.84	433.88	434.835	12152814.0
2021-09-20 10:30:00	SPY	ETF	434.83	435.43	433.97	434.17	7811541.0
2021-09-20 11:00:00	SPY	ETF	434.15	435.22	433.6346	434.8517	6213485.0
2021-09-20 11:30:00	SPY	ETF	434.87	434.94	432.85	432.8868	5747848.0
2021-09-20 12:00:00	SPY	ETF	432.885	433.02	431.805	432.495	6919487.0
2021-09-20 12:30:00	SPY	ETF	432.49	432.69	431.59	431.62	4339351.0
2021-09-20 13:00:00	SPY	ETF	431.615	432.0	430.69	431.96	6134282.0
2021-09-20 13:30:00	SPY	ETF	431.97	432.4	431.575	431.99	4440255.0
2021-09-20 14:00:00	SPY	ETF	432.01	432.35	430.0	430.14	8200201.0
2021-09-20 14:30:00	SPY	ETF	430.14	430.385	429.17	429.71	9393679.0
2021-09-20 15:00:00	SPY	ETF	429.695	430.92	428.86	430.9001	10695786.0
2021-09-20 15:30:00	SPY	ETF	430.91	434.42	430.73	434.06	23931871.0
2021-09-20 16:00:00	SPY	ETF	434.07	434.34	432.96	433.53	6397566.0
2021-09-20 16:30:00	SPY	ETF	433.54	434.04	433.4	433.69	654149.0
2021-09-20 17:00:00	SPY	ETF	433.83	434.02	433.66	433.85	188465.0
2021-09-20 17:30:00	SPY	ETF	433.85	433.89	433.67	433.79	41195.0
2021-09-20 18:00:00	SPY	ETF	433.71	434.4	433.71	434.23	347346.0
2021-09-20 18:30:00	SPY	ETF	434.04	434.4	433.7439	434.17	82990.0
2021-09-20 19:00:00	SPY	ETF	434.14	434.33	433.63	433.74	32779.0
2021-09-20 19:30:00	SPY	ETF	433.82	435.05	433.61	435.05	119009.0
2021-09-20 04:00:00	QQQ	ETF	372.48	372.48	369.43	369.73	114522.0
2021-09-20 04:30:00	QQQ	ETF	369.65	370.31	369.63	369.8	49462.0
2021-09-20 05:00:00	QQQ	ETF	369.72	369.88	369.29	369.66	37263.0
2021-09-20 05:30:00	QQQ	ETF	369.61	369.67	368.9	369.34	33791.0
2021-09-20 06:00:00	QQQ	ETF	369.36	369.84	369.35	369.79	39620.0
2021-09-20 06:30:00	QQQ	ETF	369.75	369.94	369.19	369.44	57140.0
2021-09-20 07:00:00	QQQ	ETF	369.45	369.67	368.48	368.71	178631.0
2021-09-20 07:30:00	QQQ	ETF	368.64	368.64	367.8	368.001	545609.0
2021-09-20 08:00:00	QQQ	ETF	368.0	375.1625	367.11	367.12	698932.0
2021-09-20 08:30:00	QQQ	ETF	367.13	367.53	366.84	367.34	482081.0
2021-09-20 09:00:00	QQQ	ETF	367.33	368.03	366.96	367.52	635529.0
2021-09-20 09:30:00	QQQ	ETF	367.49	369.25	366.49	368.17	7220758.0
2021-09-20 10:00:00	QQQ	ETF	368.17	368.26	365.8804	366.5121	5086977.0
2021-09-20 10:30:00	QQQ	ETF	366.515	366.86	365.32	365.53	4656018.0
2021-09-20 11:00:00	QQQ	ETF	365.465	366.61	365.08	366.54	2746400.0
2021-09-20 11:30:00	QQQ	ETF	366.54	366.66	364.51	364.57	2347638.0
2021-09-20 12:00:00	QQQ	ETF	364.55	364.67	363.4	364.14	2751974.0
2021-09-20 12:30:00	QQQ	ETF	364.12	364.31	363.53	363.6	2170007.0

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

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