PREVIEW / etf_30min / 2022-07-21

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-07-21.parquet
  size:    635 KB
  rows:    25,936

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-21 04:00:00	SPY	ETF	394.0	394.16	393.25	393.48	27504.0
2022-07-21 04:30:00	SPY	ETF	393.5	393.97	393.29	393.97	13131.0
2022-07-21 05:00:00	SPY	ETF	393.9	394.17	393.68	394.0	25133.0
2022-07-21 05:30:00	SPY	ETF	393.93	394.45	393.75	394.41	9110.0
2022-07-21 06:00:00	SPY	ETF	394.28	394.95	394.27	394.79	35101.0
2022-07-21 06:30:00	SPY	ETF	394.76	394.85	393.95	394.14	48998.0
2022-07-21 07:00:00	SPY	ETF	394.28	394.5	393.99	394.11	78652.0
2022-07-21 07:30:00	SPY	ETF	394.11	394.3	393.63	394.1	100638.0
2022-07-21 08:00:00	SPY	ETF	396.35	396.6	393.3696	394.63	816736.0
2022-07-21 08:30:00	SPY	ETF	394.74	396.48	394.31	395.74	443009.0
2022-07-21 09:00:00	SPY	ETF	395.7501	396.71	393.9	394.1	512036.0
2022-07-21 09:30:00	SPY	ETF	394.16	395.5	392.77	394.92	5179982.0
2022-07-21 10:00:00	SPY	ETF	394.96	395.76	391.63	392.07	4820915.0
2022-07-21 10:30:00	SPY	ETF	392.1	394.52	391.85	394.405	3407552.0
2022-07-21 11:00:00	SPY	ETF	394.41	394.98	393.93	394.805	2768948.0
2022-07-21 11:30:00	SPY	ETF	394.83	395.96	394.5	395.475	2459140.0
2022-07-21 12:00:00	SPY	ETF	395.46	397.43	395.38	397.35	3061072.0
2022-07-21 12:30:00	SPY	ETF	397.35	397.66	396.9	397.325	1891014.0
2022-07-21 13:00:00	SPY	ETF	397.34	397.59	396.26	396.59	2198166.0
2022-07-21 13:30:00	SPY	ETF	396.58	396.91	395.65	396.4799	3146732.0
2022-07-21 14:00:00	SPY	ETF	396.49	397.405	396.25	397.265	2017160.0
2022-07-21 14:30:00	SPY	ETF	397.265	397.265	396.33	396.9526	2399902.0
2022-07-21 15:00:00	SPY	ETF	396.96	397.97	396.9	397.53	2649108.0
2022-07-21 15:30:00	SPY	ETF	397.53	398.84	397.31	398.8	8878105.0
2022-07-21 16:00:00	SPY	ETF	398.82	399.03	397.05	397.54	3077712.0
2022-07-21 16:30:00	SPY	ETF	397.52	397.81	397.44	397.72	220323.0
2022-07-21 17:00:00	SPY	ETF	397.63	397.79	397.51	397.52	109164.0
2022-07-21 17:30:00	SPY	ETF	397.55	397.73	397.43	397.49	54052.0
2022-07-21 18:00:00	SPY	ETF	397.48	397.54	396.88	397.41	132895.0
2022-07-21 18:30:00	SPY	ETF	397.35	397.51	397.15	397.21	20724.0
2022-07-21 19:00:00	SPY	ETF	397.11	397.25	397.0	397.25	15245.0
2022-07-21 19:30:00	SPY	ETF	397.2	397.34	396.96	397.01	53977.0
2022-07-21 04:00:00	QQQ	ETF	302.43	302.5	301.62	301.8	19384.0
2022-07-21 04:30:00	QQQ	ETF	301.66	302.32	301.66	302.3	10576.0
2022-07-21 05:00:00	QQQ	ETF	302.28	302.74	302.19	302.55	10208.0
2022-07-21 05:30:00	QQQ	ETF	302.5	303.12	302.48	303.05	18446.0
2022-07-21 06:00:00	QQQ	ETF	303.12	303.81	303.1	303.71	35050.0
2022-07-21 06:30:00	QQQ	ETF	303.73	303.75	302.98	303.15	39021.0
2022-07-21 07:00:00	QQQ	ETF	303.1	303.29	302.71	302.92	65172.0
2022-07-21 07:30:00	QQQ	ETF	302.96	303.29	302.74	303.13	69530.0
2022-07-21 08:00:00	QQQ	ETF	303.04	304.38	301.9096	303.42	620270.0
2022-07-21 08:30:00	QQQ	ETF	303.6	305.25	303.42	304.51	741049.0
2022-07-21 09:00:00	QQQ	ETF	304.56	304.59	303.42	303.45	586503.0
2022-07-21 09:30:00	QQQ	ETF	303.5	304.3	301.7	303.8	6264769.0
2022-07-21 10:00:00	QQQ	ETF	303.82	304.88	300.78	301.36	5079035.0
2022-07-21 10:30:00	QQQ	ETF	301.33	303.43	300.9703	303.3	2637690.0
2022-07-21 11:00:00	QQQ	ETF	303.29	304.09	303.015	304.03	2256015.0
2022-07-21 11:30:00	QQQ	ETF	304.05	304.93	303.65	304.55	2043195.0
2022-07-21 12:00:00	QQQ	ETF	304.53	306.51	304.47	306.4401	2446244.0
2022-07-21 12:30:00	QQQ	ETF	306.44	306.78	306.11	306.44	1733540.0

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

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