PREVIEW / etf_30min / 2022-12-30

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-12-30.parquet
  size:    722 KB
  rows:    29,114

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-30 04:00:00	SPY	ETF	381.12	381.94	381.1	381.58	23461.0
2022-12-30 04:30:00	SPY	ETF	381.6	381.73	381.4	381.73	5925.0
2022-12-30 05:00:00	SPY	ETF	381.85	382.09	381.7	382.09	19229.0
2022-12-30 05:30:00	SPY	ETF	382.07	382.54	382.07	382.12	7570.0
2022-12-30 06:00:00	SPY	ETF	382.36	382.36	381.92	382.05	6715.0
2022-12-30 06:30:00	SPY	ETF	382.05	382.54	381.76	381.8	11079.0
2022-12-30 07:00:00	SPY	ETF	381.8	382.0	381.41	381.41	63657.0
2022-12-30 07:30:00	SPY	ETF	381.45	381.57	380.98	381.09	149727.0
2022-12-30 08:00:00	SPY	ETF	381.77	383.12	380.6	380.66	291564.0
2022-12-30 08:30:00	SPY	ETF	380.67	381.0108	380.56	381.0	126535.0
2022-12-30 09:00:00	SPY	ETF	380.9996	381.01	380.5	380.62	159534.0
2022-12-30 09:30:00	SPY	ETF	380.64	381.62	379.02	380.4301	4999786.0
2022-12-30 10:00:00	SPY	ETF	380.46	381.33	379.57	380.79	3620937.0
2022-12-30 10:30:00	SPY	ETF	380.81	381.55	380.19	380.37	2750073.0
2022-12-30 11:00:00	SPY	ETF	380.37	380.71	379.65	379.85	1808982.0
2022-12-30 11:30:00	SPY	ETF	379.8	380.86	379.625	380.74	1630210.0
2022-12-30 12:00:00	SPY	ETF	380.74	380.96	380.375	380.7576	1328135.0
2022-12-30 12:30:00	SPY	ETF	380.775	381.08	380.38	380.96	1192917.0
2022-12-30 13:00:00	SPY	ETF	380.99	381.0	378.43	379.345	3134614.0
2022-12-30 13:30:00	SPY	ETF	379.36	380.05	379.23	379.32	3009560.0
2022-12-30 14:00:00	SPY	ETF	379.32	379.52	378.59	379.12	3011414.0
2022-12-30 14:30:00	SPY	ETF	379.14	379.435	378.6914	379.085	2633123.0
2022-12-30 15:00:00	SPY	ETF	379.09	381.02	379.035	380.305	4725988.0
2022-12-30 15:30:00	SPY	ETF	380.32	382.58	380.195	382.44	17226267.0
2022-12-30 16:00:00	SPY	ETF	382.44	383.13	382.31	382.99	6443572.0
2022-12-30 16:30:00	SPY	ETF	382.99	383.06	382.43	383.04	372030.0
2022-12-30 17:00:00	SPY	ETF	383.04	383.089	382.95	383.08	88364.0
2022-12-30 17:30:00	SPY	ETF	383.07	383.15	383.01	383.1	14273.0
2022-12-30 18:00:00	SPY	ETF	383.1	383.14	382.99	383.08	17625.0
2022-12-30 18:30:00	SPY	ETF	383.03	383.08	383.0	383.04	4313.0
2022-12-30 19:00:00	SPY	ETF	383.09	383.09	383.0	383.02	3203.0
2022-12-30 19:30:00	SPY	ETF	383.08	383.29	382.72	383.23	25394.0
2022-12-30 04:00:00	QQQ	ETF	264.56	265.38	264.4	264.94	39311.0
2022-12-30 04:30:00	QQQ	ETF	265.0	265.53	264.94	265.53	10350.0
2022-12-30 05:00:00	QQQ	ETF	265.55	265.65	265.36	265.62	9538.0
2022-12-30 05:30:00	QQQ	ETF	265.65	266.0	265.65	265.83	8092.0
2022-12-30 06:00:00	QQQ	ETF	265.8	265.8	265.43	265.5	11821.0
2022-12-30 06:30:00	QQQ	ETF	265.5	265.75	265.34	265.35	16256.0
2022-12-30 07:00:00	QQQ	ETF	265.41	265.47	264.56	264.57	48092.0
2022-12-30 07:30:00	QQQ	ETF	264.57	264.59	263.98	264.07	150013.0
2022-12-30 08:00:00	QQQ	ETF	263.93	266.35	263.46	263.54	268661.0
2022-12-30 08:30:00	QQQ	ETF	263.51	263.94	263.4	263.92	157839.0
2022-12-30 09:00:00	QQQ	ETF	263.9	263.94	263.48	263.64	226588.0
2022-12-30 09:30:00	QQQ	ETF	263.62	264.49	262.29	263.7039	4568588.0
2022-12-30 10:00:00	QQQ	ETF	263.71	264.45	262.93	263.93	2366535.0
2022-12-30 10:30:00	QQQ	ETF	263.94	265.04	263.445	264.06	1948343.0
2022-12-30 11:00:00	QQQ	ETF	264.07	264.48	263.3	263.599	1465556.0
2022-12-30 11:30:00	QQQ	ETF	263.58	264.56	263.47	264.43	1368913.0
2022-12-30 12:00:00	QQQ	ETF	264.45	264.625	264.03	264.38	875036.0
2022-12-30 12:30:00	QQQ	ETF	264.37	264.6854	264.06	264.62	955242.0

> showing 50 of 29,114 rows — these rows as CSV

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