PREVIEW / etf_30min / 2023-03-07

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-03-07.parquet
  size:    682 KB
  rows:    27,054

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
2023-03-07 04:00:00	SPY	ETF	405.33	405.73	405.33	405.48	7223.0
2023-03-07 04:30:00	SPY	ETF	405.47	405.53	405.1	405.1	6760.0
2023-03-07 05:00:00	SPY	ETF	405.11	405.36	405.09	405.21	6419.0
2023-03-07 05:30:00	SPY	ETF	405.23	405.38	405.16	405.35	4115.0
2023-03-07 06:00:00	SPY	ETF	405.42	405.53	405.07	405.12	20102.0
2023-03-07 06:30:00	SPY	ETF	405.16	405.31	404.97	405.03	15994.0
2023-03-07 07:00:00	SPY	ETF	405.0	405.07	404.75	404.75	65639.0
2023-03-07 07:30:00	SPY	ETF	404.76	405.05	404.75	404.97	47378.0
2023-03-07 08:00:00	SPY	ETF	404.9813	405.6296	404.77	404.99	130943.0
2023-03-07 08:30:00	SPY	ETF	404.95	405.26	404.88	404.88	94629.0
2023-03-07 09:00:00	SPY	ETF	404.87	404.89	404.37	404.41	227189.0
2023-03-07 09:30:00	SPY	ETF	404.42	404.67	404.08	404.3572	4645372.0
2023-03-07 10:00:00	SPY	ETF	404.31	404.3199	400.51	401.68	12786730.0
2023-03-07 10:30:00	SPY	ETF	401.69	403.235	400.35	400.42	7724743.0
2023-03-07 11:00:00	SPY	ETF	400.44	401.32	400.02	400.0799	5051157.0
2023-03-07 11:30:00	SPY	ETF	400.08	401.08	399.78	399.89	4946381.0
2023-03-07 12:00:00	SPY	ETF	399.87	402.02	399.78	401.03	4832579.0
2023-03-07 12:30:00	SPY	ETF	401.04	401.34	400.27	400.34	3444598.0
2023-03-07 13:00:00	SPY	ETF	400.335	400.39	399.29	399.53	3846218.0
2023-03-07 13:30:00	SPY	ETF	399.53	399.835	398.16	398.3866	4787979.0
2023-03-07 14:00:00	SPY	ETF	398.38	398.94	398.2	398.26	4617798.0
2023-03-07 14:30:00	SPY	ETF	398.26	398.47	397.625	397.745	4491753.0
2023-03-07 15:00:00	SPY	ETF	397.745	398.78	397.69	398.25	5272599.0
2023-03-07 15:30:00	SPY	ETF	398.25	399.17	398.1	398.26	13020068.0
2023-03-07 16:00:00	SPY	ETF	398.28	398.55	398.11	398.49	4554243.0
2023-03-07 16:30:00	SPY	ETF	398.5	398.56	398.17	398.3	276926.0
2023-03-07 17:00:00	SPY	ETF	398.28	398.4	398.27	398.27	33299.0
2023-03-07 17:30:00	SPY	ETF	398.29	398.33	398.21	398.31	22918.0
2023-03-07 18:00:00	SPY	ETF	398.32	398.6	398.31	398.47	31496.0
2023-03-07 18:30:00	SPY	ETF	398.49	398.57	398.37	398.47	15843.0
2023-03-07 19:00:00	SPY	ETF	398.47	398.53	397.4	398.22	88388.0
2023-03-07 19:30:00	SPY	ETF	398.24	398.3	398.08	398.24	100006.0
2023-03-07 04:00:00	QQQ	ETF	300.58	301.41	300.58	301.09	32964.0
2023-03-07 04:30:00	QQQ	ETF	301.16	301.19	300.66	300.74	4960.0
2023-03-07 05:00:00	QQQ	ETF	300.8	300.97	300.79	300.84	2400.0
2023-03-07 05:30:00	QQQ	ETF	300.97	301.11	300.9	301.05	5902.0
2023-03-07 06:00:00	QQQ	ETF	301.05	301.22	300.8	300.91	22642.0
2023-03-07 06:30:00	QQQ	ETF	300.8	300.92	300.68	300.76	15018.0
2023-03-07 07:00:00	QQQ	ETF	300.75	300.86	300.5	300.57	24563.0
2023-03-07 07:30:00	QQQ	ETF	300.59	300.84	300.58	300.66	29513.0
2023-03-07 08:00:00	QQQ	ETF	300.79	301.1904	300.245	300.75	120229.0
2023-03-07 08:30:00	QQQ	ETF	300.73	301.04	300.59	300.6	86175.0
2023-03-07 09:00:00	QQQ	ETF	300.59	300.63	300.02	300.05	268021.0
2023-03-07 09:30:00	QQQ	ETF	300.07	301.01	299.82	300.292	3686045.0
2023-03-07 10:00:00	QQQ	ETF	300.29	300.29	296.64	298.02	9513943.0
2023-03-07 10:30:00	QQQ	ETF	298.02	299.96	297.41	297.45	6017983.0
2023-03-07 11:00:00	QQQ	ETF	297.47	298.5	297.3	297.47	3703542.0
2023-03-07 11:30:00	QQQ	ETF	297.47	298.64	297.35	297.6599	3365769.0
2023-03-07 12:00:00	QQQ	ETF	297.66	299.77	297.55	299.052	3262907.0
2023-03-07 12:30:00	QQQ	ETF	299.04	299.41	298.47	298.55	2377641.0

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

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