PREVIEW / etf_30min / 2022-11-21

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-11-21.parquet
  size:    671 KB
  rows:    26,840

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-21 04:00:00	SPY	ETF	394.36	394.45	393.7	393.76	30102.0
2022-11-21 04:30:00	SPY	ETF	393.87	394.29	393.78	394.12	10912.0
2022-11-21 05:00:00	SPY	ETF	394.12	394.45	393.83	393.83	17350.0
2022-11-21 05:30:00	SPY	ETF	393.96	394.24	393.78	394.04	17870.0
2022-11-21 06:00:00	SPY	ETF	394.03	394.32	394.0	394.02	34524.0
2022-11-21 06:30:00	SPY	ETF	394.02	394.34	393.72	393.93	27191.0
2022-11-21 07:00:00	SPY	ETF	393.94	394.15	393.64	394.0	50112.0
2022-11-21 07:30:00	SPY	ETF	394.09	394.33	394.05	394.2	67431.0
2022-11-21 08:00:00	SPY	ETF	394.06	395.06	393.7804	394.95	215516.0
2022-11-21 08:30:00	SPY	ETF	394.88	394.96	394.66	394.87	121517.0
2022-11-21 09:00:00	SPY	ETF	394.9	395.2	394.52	394.66	228286.0
2022-11-21 09:30:00	SPY	ETF	394.64	395.82	394.28	395.205	3784312.0
2022-11-21 10:00:00	SPY	ETF	395.21	395.538	393.5306	393.94	3054878.0
2022-11-21 10:30:00	SPY	ETF	393.93	394.26	393.23	393.88	2863537.0
2022-11-21 11:00:00	SPY	ETF	393.89	394.35	393.6016	393.7685	1984417.0
2022-11-21 11:30:00	SPY	ETF	393.7699	394.16	392.66	393.215	2214380.0
2022-11-21 12:00:00	SPY	ETF	393.215	394.16	393.12	393.685	1901055.0
2022-11-21 12:30:00	SPY	ETF	393.68	394.68	393.63	393.92	1915290.0
2022-11-21 13:00:00	SPY	ETF	393.92	395.23	393.9	394.98	2586987.0
2022-11-21 13:30:00	SPY	ETF	394.99	395.62	394.72	394.7401	2496100.0
2022-11-21 14:00:00	SPY	ETF	394.74	395.37	394.51	394.6699	2525017.0
2022-11-21 14:30:00	SPY	ETF	394.66	394.93	394.31	394.4801	2019354.0
2022-11-21 15:00:00	SPY	ETF	394.48	394.98	394.005	394.3017	2310724.0
2022-11-21 15:30:00	SPY	ETF	394.31	395.12	394.13	394.58	5661864.0
2022-11-21 16:00:00	SPY	ETF	394.58	400.0	394.5	394.65	1716559.0
2022-11-21 16:30:00	SPY	ETF	394.66	394.79	394.45	394.58	585157.0
2022-11-21 17:00:00	SPY	ETF	394.57	394.7	394.5	394.63	35776.0
2022-11-21 17:30:00	SPY	ETF	394.6	394.65	394.51	394.55	17422.0
2022-11-21 18:00:00	SPY	ETF	394.55	394.79	394.51	394.51	44391.0
2022-11-21 18:30:00	SPY	ETF	394.51	394.71	394.46	394.71	54026.0
2022-11-21 19:00:00	SPY	ETF	394.73	395.4	394.72	395.39	57207.0
2022-11-21 19:30:00	SPY	ETF	395.34	395.38	395.05	395.1	32746.0
2022-11-21 04:00:00	QQQ	ETF	283.94	283.94	282.63	282.63	36486.0
2022-11-21 04:30:00	QQQ	ETF	282.72	283.2	282.72	282.98	25985.0
2022-11-21 05:00:00	QQQ	ETF	283.03	283.22	282.48	282.5	16343.0
2022-11-21 05:30:00	QQQ	ETF	282.6	282.8	282.49	282.7	23540.0
2022-11-21 06:00:00	QQQ	ETF	282.57	282.77	282.56	282.56	7951.0
2022-11-21 06:30:00	QQQ	ETF	282.54	282.86	282.27	282.43	32388.0
2022-11-21 07:00:00	QQQ	ETF	282.45	282.61	282.1	282.5	58949.0
2022-11-21 07:30:00	QQQ	ETF	282.49	282.77	282.45	282.73	73289.0
2022-11-21 08:00:00	QQQ	ETF	282.55	285.033	282.1	283.45	247042.0
2022-11-21 08:30:00	QQQ	ETF	283.45	283.56	283.25	283.45	106954.0
2022-11-21 09:00:00	QQQ	ETF	283.5	283.9	283.16	283.37	437328.0
2022-11-21 09:30:00	QQQ	ETF	283.4	284.58	282.87	283.68	4239185.0
2022-11-21 10:00:00	QQQ	ETF	283.68	283.9799	281.88	282.325	3123650.0
2022-11-21 10:30:00	QQQ	ETF	282.285	282.55	281.5655	282.13	2147963.0
2022-11-21 11:00:00	QQQ	ETF	282.1	282.87	281.84	282.3148	1630375.0
2022-11-21 11:30:00	QQQ	ETF	282.3	282.49	281.32	281.64	1740003.0
2022-11-21 12:00:00	QQQ	ETF	281.65	282.1725	281.16	281.25	1888175.0
2022-11-21 12:30:00	QQQ	ETF	281.22	282.04	281.04	281.19	1786555.0

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

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