PREVIEW / etf_30min / 2022-06-14

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-06-14.parquet
  size:    691 KB
  rows:    27,845

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-06-14 04:00:00	SPY	ETF	379.29	379.6	378.35	378.69	28597.0
2022-06-14 04:30:00	SPY	ETF	379.0	379.08	377.04	377.11	26427.0
2022-06-14 05:00:00	SPY	ETF	377.26	377.55	376.64	376.85	26247.0
2022-06-14 05:30:00	SPY	ETF	376.96	377.5	376.82	376.97	16008.0
2022-06-14 06:00:00	SPY	ETF	376.65	376.65	375.64	375.77	29304.0
2022-06-14 06:30:00	SPY	ETF	375.69	377.3	375.61	376.82	92494.0
2022-06-14 07:00:00	SPY	ETF	376.77	376.9	376.0	376.58	215514.0
2022-06-14 07:30:00	SPY	ETF	376.49	376.72	375.4	375.49	202119.0
2022-06-14 08:00:00	SPY	ETF	376.8674	380.3	375.4201	376.18	309426.0
2022-06-14 08:30:00	SPY	ETF	376.43	378.54	376.43	377.05	711706.0
2022-06-14 09:00:00	SPY	ETF	377.02	378.0899	376.2	376.84	357815.0
2022-06-14 09:30:00	SPY	ETF	376.85	377.63	374.5	377.42	8725803.0
2022-06-14 10:00:00	SPY	ETF	377.44	377.94	374.07	374.1302	5732725.0
2022-06-14 10:30:00	SPY	ETF	374.16	376.12	373.1	375.16	5267616.0
2022-06-14 11:00:00	SPY	ETF	375.17	375.96	373.14	374.13	4454039.0
2022-06-14 11:30:00	SPY	ETF	374.14	375.34	373.4628	374.9599	4101561.0
2022-06-14 12:00:00	SPY	ETF	374.95	375.0	373.0	373.58	3576726.0
2022-06-14 12:30:00	SPY	ETF	373.59	374.07	372.6	374.0	3181377.0
2022-06-14 13:00:00	SPY	ETF	374.0	376.45	373.5506	374.84	3931154.0
2022-06-14 13:30:00	SPY	ETF	374.83	374.984	372.68	373.17	4302980.0
2022-06-14 14:00:00	SPY	ETF	373.18	374.43	373.05	373.59	3426173.0
2022-06-14 14:30:00	SPY	ETF	373.59	373.95	372.01	372.18	3697195.0
2022-06-14 15:00:00	SPY	ETF	372.19	372.58	370.59	372.415	5913445.0
2022-06-14 15:30:00	SPY	ETF	372.42	375.04	372.35	373.82	13253638.0
2022-06-14 16:00:00	SPY	ETF	373.82	374.08	373.02	373.11	3207858.0
2022-06-14 16:30:00	SPY	ETF	373.1	373.93	373.07	373.87	180771.0
2022-06-14 17:00:00	SPY	ETF	373.85	373.99	373.66	373.73	112645.0
2022-06-14 17:30:00	SPY	ETF	373.77	374.0	373.74	373.9	35369.0
2022-06-14 18:00:00	SPY	ETF	373.9	374.59	373.9	374.47	108538.0
2022-06-14 18:30:00	SPY	ETF	374.5	375.07	374.5	374.51	52565.0
2022-06-14 19:00:00	SPY	ETF	374.44	374.8	374.01	374.64	38537.0
2022-06-14 19:30:00	SPY	ETF	374.7	376.0	374.52	375.66	39698.0
2022-06-14 04:00:00	QQQ	ETF	279.29	279.45	278.2	279.17	162736.0
2022-06-14 04:30:00	QQQ	ETF	278.9	279.22	277.6	277.75	72816.0
2022-06-14 05:00:00	QQQ	ETF	277.75	278.18	277.42	277.5	40185.0
2022-06-14 05:30:00	QQQ	ETF	277.66	278.05	277.41	277.74	44690.0
2022-06-14 06:00:00	QQQ	ETF	277.67	277.67	276.62	276.9	49490.0
2022-06-14 06:30:00	QQQ	ETF	276.79	278.25	276.79	277.8	80253.0
2022-06-14 07:00:00	QQQ	ETF	277.79	277.86	276.94	277.38	175687.0
2022-06-14 07:30:00	QQQ	ETF	277.38	277.59	276.3	276.43	286297.0
2022-06-14 08:00:00	QQQ	ETF	277.85	280.25	275.616	276.9	545259.0
2022-06-14 08:30:00	QQQ	ETF	276.6	279.16	276.6	277.77	991805.0
2022-06-14 09:00:00	QQQ	ETF	277.77	278.6799	277.4499	277.72	402594.0
2022-06-14 09:30:00	QQQ	ETF	277.68	278.37	274.76	277.49	6870052.0
2022-06-14 10:00:00	QQQ	ETF	277.48	278.22	274.71	274.94	4982330.0
2022-06-14 10:30:00	QQQ	ETF	274.95	276.93	274.18	275.98	3704377.0
2022-06-14 11:00:00	QQQ	ETF	276.0	276.5165	274.5502	275.57	2783775.0
2022-06-14 11:30:00	QQQ	ETF	275.58	277.15	275.1	276.84	3140045.0
2022-06-14 12:00:00	QQQ	ETF	276.86	276.9	275.24	275.851	2636997.0
2022-06-14 12:30:00	QQQ	ETF	275.875	276.36	275.07	276.28	2399048.0

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

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