PREVIEW / etf_30min / 2022-07-05

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-07-05.parquet
  size:    676 KB
  rows:    27,064

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-07-05 04:00:00	SPY	ETF	381.44	382.01	379.81	379.98	30161.0
2022-07-05 04:30:00	SPY	ETF	379.9	380.23	378.85	379.0	55303.0
2022-07-05 05:00:00	SPY	ETF	379.03	379.37	378.62	378.76	33326.0
2022-07-05 05:30:00	SPY	ETF	378.76	379.39	378.47	379.33	13189.0
2022-07-05 06:00:00	SPY	ETF	379.25	379.84	379.24	379.31	39955.0
2022-07-05 06:30:00	SPY	ETF	379.43	379.87	379.23	379.45	20444.0
2022-07-05 07:00:00	SPY	ETF	379.51	379.63	378.81	379.2	119777.0
2022-07-05 07:30:00	SPY	ETF	379.2	379.2	377.81	377.91	179084.0
2022-07-05 08:00:00	SPY	ETF	377.9	383.3	376.59	377.2	367969.0
2022-07-05 08:30:00	SPY	ETF	377.07	377.21	375.94	376.16	501631.0
2022-07-05 09:00:00	SPY	ETF	376.03	376.55	375.83	375.89	615142.0
2022-07-05 09:30:00	SPY	ETF	375.85	376.33	373.28	373.89	9148431.0
2022-07-05 10:00:00	SPY	ETF	373.83	375.11	372.9	374.4399	5797043.0
2022-07-05 10:30:00	SPY	ETF	374.44	376.28	373.76	374.12	4496398.0
2022-07-05 11:00:00	SPY	ETF	374.13	374.2	373.06	373.77	3089335.0
2022-07-05 11:30:00	SPY	ETF	373.75	375.76	373.41	375.23	3455930.0
2022-07-05 12:00:00	SPY	ETF	375.25	377.1199	374.86	376.66	3656168.0
2022-07-05 12:30:00	SPY	ETF	376.67	376.95	375.21	375.4001	2186267.0
2022-07-05 13:00:00	SPY	ETF	375.44	377.4299	375.35	376.98	2997094.0
2022-07-05 13:30:00	SPY	ETF	376.99	378.06	376.69	377.475	3069696.0
2022-07-05 14:00:00	SPY	ETF	377.49	379.15	377.22	378.9301	3365186.0
2022-07-05 14:30:00	SPY	ETF	378.9519	380.48	378.5818	379.8899	4568257.0
2022-07-05 15:00:00	SPY	ETF	379.89	381.42	379.28	381.11	5730243.0
2022-07-05 15:30:00	SPY	ETF	381.11	381.98	380.61	381.95	8376509.0
2022-07-05 16:00:00	SPY	ETF	381.95	381.99	381.28	381.82	2438736.0
2022-07-05 16:30:00	SPY	ETF	381.76	381.86	381.69	381.78	187512.0
2022-07-05 17:00:00	SPY	ETF	381.74	381.86	381.74	381.78	11618.0
2022-07-05 17:30:00	SPY	ETF	381.8	381.9	381.74	381.9	49265.0
2022-07-05 18:00:00	SPY	ETF	381.9	382.6	381.88	382.14	209777.0
2022-07-05 18:30:00	SPY	ETF	382.07	382.24	381.7	381.86	47524.0
2022-07-05 19:00:00	SPY	ETF	381.87	382.07	381.59	381.59	44193.0
2022-07-05 19:30:00	SPY	ETF	381.56	381.56	380.83	380.95	77605.0
2022-07-05 04:00:00	QQQ	ETF	282.51	283.07	280.0	281.01	60177.0
2022-07-05 04:30:00	QQQ	ETF	280.9	281.18	280.0	280.07	44781.0
2022-07-05 05:00:00	QQQ	ETF	280.16	280.39	279.64	280.0	92657.0
2022-07-05 05:30:00	QQQ	ETF	279.92	280.37	279.64	280.36	26953.0
2022-07-05 06:00:00	QQQ	ETF	280.27	280.83	280.26	280.46	22133.0
2022-07-05 06:30:00	QQQ	ETF	280.44	280.86	280.32	280.4	21802.0
2022-07-05 07:00:00	QQQ	ETF	280.52	280.67	279.91	280.1	57366.0
2022-07-05 07:30:00	QQQ	ETF	280.16	280.18	279.02	279.08	252848.0
2022-07-05 08:00:00	QQQ	ETF	280.55	283.8	278.04	278.65	479811.0
2022-07-05 08:30:00	QQQ	ETF	278.56	278.85	277.82	278.0001	360975.0
2022-07-05 09:00:00	QQQ	ETF	277.97	278.64	277.88	278.33	414391.0
2022-07-05 09:30:00	QQQ	ETF	278.3	279.1	276.7501	278.25	7739287.0
2022-07-05 10:00:00	QQQ	ETF	278.19	279.92	277.17	279.51	4430099.0
2022-07-05 10:30:00	QQQ	ETF	279.5	282.11	279.0306	280.166	4225106.0
2022-07-05 11:00:00	QQQ	ETF	280.16	280.18	278.69	279.37	2483590.0
2022-07-05 11:30:00	QQQ	ETF	279.29	281.59	279.0	281.165	2463502.0
2022-07-05 12:00:00	QQQ	ETF	281.17	283.02	280.551	282.7	3022001.0
2022-07-05 12:30:00	QQQ	ETF	282.76	282.97	281.32	281.46	2081093.0

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

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