PREVIEW / etf_30min / 2022-07-22

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-07-22.parquet
  size:    640 KB
  rows:    25,476

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-07-22 04:00:00	SPY	ETF	397.24	397.5	396.67	397.41	6204.0
2022-07-22 04:30:00	SPY	ETF	397.55	397.8	397.4	397.4	1979.0
2022-07-22 05:00:00	SPY	ETF	397.7	398.05	397.6	397.61	9432.0
2022-07-22 05:30:00	SPY	ETF	397.57	397.8	397.44	397.45	12315.0
2022-07-22 06:00:00	SPY	ETF	397.44	397.95	397.43	397.51	5048.0
2022-07-22 06:30:00	SPY	ETF	397.61	398.21	397.61	397.77	49429.0
2022-07-22 07:00:00	SPY	ETF	397.82	397.86	397.49	397.77	98661.0
2022-07-22 07:30:00	SPY	ETF	397.82	398.38	397.54	398.32	96562.0
2022-07-22 08:00:00	SPY	ETF	398.31	398.51	397.07	398.22	149925.0
2022-07-22 08:30:00	SPY	ETF	398.23	398.46	398.1	398.3	215290.0
2022-07-22 09:00:00	SPY	ETF	398.29	398.98	398.23	398.9	180477.0
2022-07-22 09:30:00	SPY	ETF	398.92	400.18	397.91	397.96	7603781.0
2022-07-22 10:00:00	SPY	ETF	397.965	398.98	397.21	398.5	3861339.0
2022-07-22 10:30:00	SPY	ETF	398.5009	399.26	397.95	398.7	2505665.0
2022-07-22 11:00:00	SPY	ETF	398.715	398.81	396.69	396.7175	2671723.0
2022-07-22 11:30:00	SPY	ETF	396.72	396.9	395.32	396.2961	3627233.0
2022-07-22 12:00:00	SPY	ETF	396.27	396.63	394.94	395.55	2369432.0
2022-07-22 12:30:00	SPY	ETF	395.56	396.33	395.105	395.24	1824116.0
2022-07-22 13:00:00	SPY	ETF	395.25	395.25	393.94	394.23	2667829.0
2022-07-22 13:30:00	SPY	ETF	394.22	394.22	393.28	394.0212	3080430.0
2022-07-22 14:00:00	SPY	ETF	394.03	394.14	392.75	393.3496	2984908.0
2022-07-22 14:30:00	SPY	ETF	393.35	394.03	392.82	393.7078	2365390.0
2022-07-22 15:00:00	SPY	ETF	393.72	394.92	393.38	394.87	4213772.0
2022-07-22 15:30:00	SPY	ETF	394.89	395.2	393.68	395.12	7648790.0
2022-07-22 16:00:00	SPY	ETF	395.13	395.14	394.45	394.97	2632342.0
2022-07-22 16:30:00	SPY	ETF	394.97	394.99	394.64	394.99	135313.0
2022-07-22 17:00:00	SPY	ETF	394.9	395.07	394.89	394.99	53086.0
2022-07-22 17:30:00	SPY	ETF	394.94	394.97	394.55	394.8	32261.0
2022-07-22 18:00:00	SPY	ETF	394.83	394.85	394.48	394.65	19484.0
2022-07-22 18:30:00	SPY	ETF	394.62	394.65	394.28	394.42	16825.0
2022-07-22 19:00:00	SPY	ETF	394.42	394.42	394.27	394.28	15883.0
2022-07-22 19:30:00	SPY	ETF	394.28	394.5	394.25	394.4	17746.0
2022-07-22 04:00:00	QQQ	ETF	305.24	305.43	304.73	305.39	59649.0
2022-07-22 04:30:00	QQQ	ETF	305.49	305.72	305.26	305.5	22145.0
2022-07-22 05:00:00	QQQ	ETF	305.61	305.97	305.56	305.66	17665.0
2022-07-22 05:30:00	QQQ	ETF	305.71	305.85	305.52	305.6	35819.0
2022-07-22 06:00:00	QQQ	ETF	305.53	305.77	305.41	305.6	41849.0
2022-07-22 06:30:00	QQQ	ETF	305.6	306.3	305.54	305.94	165688.0
2022-07-22 07:00:00	QQQ	ETF	305.98	306.0	305.5	305.9	120279.0
2022-07-22 07:30:00	QQQ	ETF	305.95	306.7	305.81	306.65	299481.0
2022-07-22 08:00:00	QQQ	ETF	305.73	307.61	304.7	306.3	341075.0
2022-07-22 08:30:00	QQQ	ETF	306.31	306.46	306.1	306.24	243895.0
2022-07-22 09:00:00	QQQ	ETF	306.26	306.72	306.14	306.44	225727.0
2022-07-22 09:30:00	QQQ	ETF	306.43	308.55	305.46	305.74	7406634.0
2022-07-22 10:00:00	QQQ	ETF	305.75	306.48	304.86	305.9001	4117119.0
2022-07-22 10:30:00	QQQ	ETF	305.87	306.55	305.31	305.84	2319474.0
2022-07-22 11:00:00	QQQ	ETF	305.85	305.95	303.52	303.55	2940362.0
2022-07-22 11:30:00	QQQ	ETF	303.55	303.74	301.93	302.9292	3136316.0
2022-07-22 12:00:00	QQQ	ETF	302.92	303.24	301.57	302.13	2435479.0
2022-07-22 12:30:00	QQQ	ETF	302.14	302.8	301.93	302.0899	1613037.0

> showing 50 of 25,476 rows — these rows as CSV

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