PREVIEW / etf_30min / 2022-12-02

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-12-02.parquet
  size:    688 KB
  rows:    27,510

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-12-02 04:00:00	SPY	ETF	407.15	407.35	406.85	407.16	18205.0
2022-12-02 04:30:00	SPY	ETF	407.14	407.44	406.9	407.44	12184.0
2022-12-02 05:00:00	SPY	ETF	407.49	407.69	407.34	407.35	23082.0
2022-12-02 05:30:00	SPY	ETF	407.26	407.59	407.24	407.5	6099.0
2022-12-02 06:00:00	SPY	ETF	407.36	407.37	406.86	407.05	16439.0
2022-12-02 06:30:00	SPY	ETF	407.0	407.19	406.97	407.0	19033.0
2022-12-02 07:00:00	SPY	ETF	407.03	407.3	406.6	407.3	75969.0
2022-12-02 07:30:00	SPY	ETF	407.28	407.4	407.17	407.38	71506.0
2022-12-02 08:00:00	SPY	ETF	406.75	407.74	406.63	406.72	389343.0
2022-12-02 08:30:00	SPY	ETF	406.72	406.72	400.01	402.05	4216525.0
2022-12-02 09:00:00	SPY	ETF	402.02	402.29	400.57	402.2	1834931.0
2022-12-02 09:30:00	SPY	ETF	402.24	404.1	402.14	403.08	8085584.0
2022-12-02 10:00:00	SPY	ETF	403.08	404.7	402.635	403.67	5656823.0
2022-12-02 10:30:00	SPY	ETF	403.67	405.15	403.25	404.07	4215332.0
2022-12-02 11:00:00	SPY	ETF	404.03	404.85	403.58	404.75	3027615.0
2022-12-02 11:30:00	SPY	ETF	404.74	406.19	404.48	405.42	5663880.0
2022-12-02 12:00:00	SPY	ETF	405.42	406.3	405.27	405.495	2479137.0
2022-12-02 12:30:00	SPY	ETF	405.49	405.67	404.67	404.77	1804576.0
2022-12-02 13:00:00	SPY	ETF	404.74	405.07	404.33	404.9668	1771927.0
2022-12-02 13:30:00	SPY	ETF	404.97	405.45	404.7501	405.22	1657797.0
2022-12-02 14:00:00	SPY	ETF	405.225	405.34	404.48	405.17	2052878.0
2022-12-02 14:30:00	SPY	ETF	405.1726	406.66	404.94	406.54	2556740.0
2022-12-02 15:00:00	SPY	ETF	406.54	407.86	406.405	406.84	4506080.0
2022-12-02 15:30:00	SPY	ETF	406.83	407.08	405.8	406.87	8113119.0
2022-12-02 16:00:00	SPY	ETF	406.87	407.0	406.0	406.25	2281669.0
2022-12-02 16:30:00	SPY	ETF	406.25	406.3	405.93	405.96	325075.0
2022-12-02 17:00:00	SPY	ETF	406.14	406.16	405.96	406.08	81592.0
2022-12-02 17:30:00	SPY	ETF	406.01	406.2	406.0	406.15	14668.0
2022-12-02 18:00:00	SPY	ETF	406.15	406.15	405.97	405.97	16869.0
2022-12-02 18:30:00	SPY	ETF	405.92	406.0	405.86	406.0	14413.0
2022-12-02 19:00:00	SPY	ETF	406.03	406.03	405.86	405.92	7855.0
2022-12-02 19:30:00	SPY	ETF	406.0	406.0	405.0	405.93	23253.0
2022-12-02 04:00:00	QQQ	ETF	293.43	293.52	293.07	293.29	31036.0
2022-12-02 04:30:00	QQQ	ETF	293.29	293.66	293.14	293.64	20347.0
2022-12-02 05:00:00	QQQ	ETF	293.6	293.78	293.49	293.49	16223.0
2022-12-02 05:30:00	QQQ	ETF	293.5	293.69	293.48	293.59	10171.0
2022-12-02 06:00:00	QQQ	ETF	293.61	293.61	293.13	293.35	11264.0
2022-12-02 06:30:00	QQQ	ETF	293.36	293.38	293.19	293.24	8210.0
2022-12-02 07:00:00	QQQ	ETF	293.3	293.46	292.88	293.42	104611.0
2022-12-02 07:30:00	QQQ	ETF	293.44	293.62	293.43	293.62	69185.0
2022-12-02 08:00:00	QQQ	ETF	293.62	293.94	292.88	293.32	322683.0
2022-12-02 08:30:00	QQQ	ETF	293.06	293.06	286.0	288.17	3299450.0
2022-12-02 09:00:00	QQQ	ETF	288.02	288.58	287.21	288.551	961988.0
2022-12-02 09:30:00	QQQ	ETF	288.54	290.23	288.36	289.26	6444366.0
2022-12-02 10:00:00	QQQ	ETF	289.26	291.1582	288.73	290.07	4794397.0
2022-12-02 10:30:00	QQQ	ETF	290.06	291.0399	289.66	289.965	2906673.0
2022-12-02 11:00:00	QQQ	ETF	289.97	290.74	289.37	290.63	2086963.0
2022-12-02 11:30:00	QQQ	ETF	290.625	291.78	290.33	290.93	2560846.0
2022-12-02 12:00:00	QQQ	ETF	290.92	291.8	290.7194	290.88	1806143.0
2022-12-02 12:30:00	QQQ	ETF	290.89	291.03	290.2501	290.42	1619260.0

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

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