PREVIEW / etf_30min / 2022-11-10

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-11-10.parquet
  size:    709 KB
  rows:    28,882

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-11-10 04:00:00	SPY	ETF	374.88	375.11	374.71	375.03	18212.0
2022-11-10 04:30:00	SPY	ETF	375.11	375.36	375.11	375.21	3732.0
2022-11-10 05:00:00	SPY	ETF	375.29	375.29	374.48	374.58	4300.0
2022-11-10 05:30:00	SPY	ETF	374.65	375.5	374.51	375.5	9078.0
2022-11-10 06:00:00	SPY	ETF	375.53	375.6	374.68	375.41	42185.0
2022-11-10 06:30:00	SPY	ETF	375.35	375.8	375.25	375.31	23582.0
2022-11-10 07:00:00	SPY	ETF	375.28	375.48	374.92	375.0	105446.0
2022-11-10 07:30:00	SPY	ETF	375.03	375.29	374.73	375.18	80118.0
2022-11-10 08:00:00	SPY	ETF	375.2	375.74	374.67	375.2	487974.0
2022-11-10 08:30:00	SPY	ETF	375.2	387.07	373.68	386.37	4386875.0
2022-11-10 09:00:00	SPY	ETF	386.37	388.11	385.62	388.04	1563424.0
2022-11-10 09:30:00	SPY	ETF	388.03	389.83	385.642	389.78	14366593.0
2022-11-10 10:00:00	SPY	ETF	389.78	390.47	388.83	389.755	8590637.0
2022-11-10 10:30:00	SPY	ETF	389.76	390.69	387.92	390.435	6134797.0
2022-11-10 11:00:00	SPY	ETF	390.44	390.85	389.43	390.8	5665856.0
2022-11-10 11:30:00	SPY	ETF	390.8	392.04	390.78	391.88	5120490.0
2022-11-10 12:00:00	SPY	ETF	391.87	391.875	390.52	390.65	4283742.0
2022-11-10 12:30:00	SPY	ETF	390.65	390.65	388.97	389.09	5357130.0
2022-11-10 13:00:00	SPY	ETF	389.1	390.89	389.095	390.6	4716163.0
2022-11-10 13:30:00	SPY	ETF	390.61	391.54	390.08	391.28	3424529.0
2022-11-10 14:00:00	SPY	ETF	391.275	391.845	390.94	391.635	3724337.0
2022-11-10 14:30:00	SPY	ETF	391.63	392.35	391.24	392.26	3771119.0
2022-11-10 15:00:00	SPY	ETF	392.27	393.5231	391.99	393.455	5677550.0
2022-11-10 15:30:00	SPY	ETF	393.4646	395.04	393.24	394.64	17603747.0
2022-11-10 16:00:00	SPY	ETF	394.65	395.67	394.41	395.5	13120512.0
2022-11-10 16:30:00	SPY	ETF	395.5	395.82	394.69	395.76	285253.0
2022-11-10 17:00:00	SPY	ETF	395.82	395.97	395.7	395.72	137325.0
2022-11-10 17:30:00	SPY	ETF	395.72	396.0	395.68	395.71	45597.0
2022-11-10 18:00:00	SPY	ETF	395.691	395.76	395.04	395.21	115799.0
2022-11-10 18:30:00	SPY	ETF	395.24	395.94	395.1	395.7	63204.0
2022-11-10 19:00:00	SPY	ETF	395.66	395.81	394.88	394.94	46654.0
2022-11-10 19:30:00	SPY	ETF	394.98	395.6	394.8	395.29	81583.0
2022-11-10 04:00:00	QQQ	ETF	264.06	264.16	263.78	264.14	32047.0
2022-11-10 04:30:00	QQQ	ETF	264.17	264.4	264.09	264.09	11738.0
2022-11-10 05:00:00	QQQ	ETF	264.1	264.13	263.6	263.85	28431.0
2022-11-10 05:30:00	QQQ	ETF	263.8	264.59	263.8	264.59	8682.0
2022-11-10 06:00:00	QQQ	ETF	264.56	264.92	264.0	264.64	25967.0
2022-11-10 06:30:00	QQQ	ETF	264.66	265.0	264.54	264.59	36077.0
2022-11-10 07:00:00	QQQ	ETF	264.61	264.69	264.35	264.4	86777.0
2022-11-10 07:30:00	QQQ	ETF	264.4	264.48	264.06	264.41	101580.0
2022-11-10 08:00:00	QQQ	ETF	264.5685	264.88	264.0496	264.47	454304.0
2022-11-10 08:30:00	QQQ	ETF	264.4	275.01	263.0	274.77	5971148.0
2022-11-10 09:00:00	QQQ	ETF	274.76	276.3	263.5	276.06	1871475.0
2022-11-10 09:30:00	QQQ	ETF	276.01	278.395	273.85	278.32	13212427.0
2022-11-10 10:00:00	QQQ	ETF	278.34	278.74	277.21	277.6584	7421477.0
2022-11-10 10:30:00	QQQ	ETF	277.66	278.44	276.05	278.2121	5198887.0
2022-11-10 11:00:00	QQQ	ETF	278.23	278.5897	277.26	278.4	3907593.0
2022-11-10 11:30:00	QQQ	ETF	278.4177	279.5	278.3801	279.3816	3448321.0
2022-11-10 12:00:00	QQQ	ETF	279.39	279.415	278.7	278.85	3125639.0
2022-11-10 12:30:00	QQQ	ETF	278.81	278.825	277.64	277.72	3528138.0

> showing 50 of 28,882 rows — these rows as CSV

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