PREVIEW / etf_30min / 2022-09-02

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-09-02.parquet
  size:    640 KB
  rows:    25,739

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-09-02 04:00:00	SPY	ETF	395.88	396.81	395.81	396.81	14831.0
2022-09-02 04:30:00	SPY	ETF	396.82	397.12	396.61	397.0	18517.0
2022-09-02 05:00:00	SPY	ETF	396.75	396.86	396.51	396.77	2863.0
2022-09-02 05:30:00	SPY	ETF	396.51	396.7	396.36	396.7	4850.0
2022-09-02 06:00:00	SPY	ETF	396.8	396.92	396.06	396.06	25156.0
2022-09-02 06:30:00	SPY	ETF	396.01	396.26	395.8	396.25	31022.0
2022-09-02 07:00:00	SPY	ETF	396.28	396.42	395.74	395.9	49937.0
2022-09-02 07:30:00	SPY	ETF	395.92	396.73	395.85	396.48	61534.0
2022-09-02 08:00:00	SPY	ETF	395.8	397.16	395.5	396.9	382387.0
2022-09-02 08:30:00	SPY	ETF	397.12	399.88	396.2	399.23	2437874.0
2022-09-02 09:00:00	SPY	ETF	399.23	400.55	398.85	400.29	731236.0
2022-09-02 09:30:00	SPY	ETF	400.29	400.43	397.64	398.02	7547209.0
2022-09-02 10:00:00	SPY	ETF	398.03	400.35	397.0203	400.34	5155387.0
2022-09-02 10:30:00	SPY	ETF	400.355	401.555	399.84	400.38	4681614.0
2022-09-02 11:00:00	SPY	ETF	400.38	401.26	400.18	400.88	2709296.0
2022-09-02 11:30:00	SPY	ETF	400.9	401.3824	400.07	401.16	2173674.0
2022-09-02 12:00:00	SPY	ETF	401.17	401.4	398.48	398.5601	3156342.0
2022-09-02 12:30:00	SPY	ETF	398.56	398.72	395.81	396.5401	5070268.0
2022-09-02 13:00:00	SPY	ETF	396.56	396.56	393.25	393.49	6532953.0
2022-09-02 13:30:00	SPY	ETF	393.4984	394.435	392.22	392.37	5431249.0
2022-09-02 14:00:00	SPY	ETF	392.38	393.839	392.269	393.7407	3775659.0
2022-09-02 14:30:00	SPY	ETF	393.76	394.02	392.48	392.57	3364457.0
2022-09-02 15:00:00	SPY	ETF	392.57	394.03	392.05	392.63	4880865.0
2022-09-02 15:30:00	SPY	ETF	392.5927	392.5927	390.33	392.27	13295739.0
2022-09-02 16:00:00	SPY	ETF	392.27	392.88	391.93	392.82	3666055.0
2022-09-02 16:30:00	SPY	ETF	392.84	393.1	392.8	393.01	272580.0
2022-09-02 17:00:00	SPY	ETF	392.91	393.07	392.6	392.6	69883.0
2022-09-02 17:30:00	SPY	ETF	392.9	393.0	392.74	392.75	21406.0
2022-09-02 18:00:00	SPY	ETF	392.75	392.76	392.7	392.75	7254.0
2022-09-02 18:30:00	SPY	ETF	392.73	392.78	392.7	392.7	9839.0
2022-09-02 19:00:00	SPY	ETF	392.7	392.7	392.5	392.57	14716.0
2022-09-02 19:30:00	SPY	ETF	392.53	392.76	392.46	392.76	15178.0
2022-09-02 04:00:00	QQQ	ETF	299.22	300.0	299.13	299.77	63910.0
2022-09-02 04:30:00	QQQ	ETF	299.83	300.11	299.65	299.98	45384.0
2022-09-02 05:00:00	QQQ	ETF	299.83	300.0	299.39	299.58	63698.0
2022-09-02 05:30:00	QQQ	ETF	299.58	299.58	299.18	299.54	25952.0
2022-09-02 06:00:00	QQQ	ETF	299.52	299.6	298.7	298.7	36100.0
2022-09-02 06:30:00	QQQ	ETF	298.65	298.88	298.42	298.81	55621.0
2022-09-02 07:00:00	QQQ	ETF	298.87	299.0	298.38	298.68	149579.0
2022-09-02 07:30:00	QQQ	ETF	298.69	299.46	298.69	299.18	85761.0
2022-09-02 08:00:00	QQQ	ETF	298.93	299.72	298.45	299.51	212052.0
2022-09-02 08:30:00	QQQ	ETF	299.31	302.31	298.68	301.38	1927398.0
2022-09-02 09:00:00	QQQ	ETF	301.24	302.71	299.3822	302.33	877563.0
2022-09-02 09:30:00	QQQ	ETF	302.34	302.61	299.6	300.0	5437835.0
2022-09-02 10:00:00	QQQ	ETF	300.02	302.44	299.14	302.4177	3938736.0
2022-09-02 10:30:00	QQQ	ETF	302.43	303.75	301.51	302.19	3740469.0
2022-09-02 11:00:00	QQQ	ETF	302.2	302.94	302.01	302.61	2073888.0
2022-09-02 11:30:00	QQQ	ETF	302.69	303.11	301.77	302.7	1592094.0
2022-09-02 12:00:00	QQQ	ETF	302.72	302.86	299.925	300.0811	2191400.0
2022-09-02 12:30:00	QQQ	ETF	300.1	300.4	297.37	298.26	4044386.0

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

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