PREVIEW / etf_30min / 2022-03-16

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-03-16.parquet
  size:    703 KB
  rows:    28,004

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-03-16 04:00:00	SPY	ETF	429.17	430.24	426.9	430.0	55436.0
2022-03-16 04:30:00	SPY	ETF	430.0	430.74	429.75	430.16	43121.0
2022-03-16 05:00:00	SPY	ETF	430.27	430.86	430.25	430.86	57873.0
2022-03-16 05:30:00	SPY	ETF	430.84	431.04	430.25	430.28	24326.0
2022-03-16 06:00:00	SPY	ETF	430.25	431.8	430.2	431.23	90490.0
2022-03-16 06:30:00	SPY	ETF	431.3	431.58	430.82	431.16	91802.0
2022-03-16 07:00:00	SPY	ETF	431.29	431.29	430.56	430.99	178809.0
2022-03-16 07:30:00	SPY	ETF	431.0	431.52	430.92	431.45	245627.0
2022-03-16 08:00:00	SPY	ETF	431.28	431.75	425.5	431.35	463009.0
2022-03-16 08:30:00	SPY	ETF	431.35	431.35	429.97	430.15	288539.0
2022-03-16 09:00:00	SPY	ETF	430.1	430.53	429.52	429.91	288914.0
2022-03-16 09:30:00	SPY	ETF	429.89	432.67	429.8	431.93	9834241.0
2022-03-16 10:00:00	SPY	ETF	431.93	434.55	430.734	433.45	11191031.0
2022-03-16 10:30:00	SPY	ETF	433.46	434.285	432.13	433.31	6238176.0
2022-03-16 11:00:00	SPY	ETF	433.31	433.48	432.18	432.86	4282899.0
2022-03-16 11:30:00	SPY	ETF	432.87	433.174	432.23	433.03	2919951.0
2022-03-16 12:00:00	SPY	ETF	433.05	433.58	432.52	433.0	2443550.0
2022-03-16 12:30:00	SPY	ETF	432.9701	433.12	431.15	431.665	3388309.0
2022-03-16 13:00:00	SPY	ETF	431.6608	431.9	430.02	430.63	4217197.0
2022-03-16 13:30:00	SPY	ETF	430.64	431.59	430.45	431.3465	3489057.0
2022-03-16 14:00:00	SPY	ETF	430.99	431.32	426.29	426.4	11768714.0
2022-03-16 14:30:00	SPY	ETF	426.39	431.46	424.8	429.95	12618378.0
2022-03-16 15:00:00	SPY	ETF	429.93	433.29	429.39	432.995	9427333.0
2022-03-16 15:30:00	SPY	ETF	432.99	435.68	431.87	435.61	16716480.0
2022-03-16 16:00:00	SPY	ETF	435.6	436.67	435.0	436.62	5824176.0
2022-03-16 16:30:00	SPY	ETF	436.6	437.2	436.48	436.75	302256.0
2022-03-16 17:00:00	SPY	ETF	436.8	436.8	435.62	436.49	248308.0
2022-03-16 17:30:00	SPY	ETF	436.5	436.73	435.62	436.65	76861.0
2022-03-16 18:00:00	SPY	ETF	436.61	436.61	435.6	435.69	115101.0
2022-03-16 18:30:00	SPY	ETF	435.87	435.94	435.53	435.89	34905.0
2022-03-16 19:00:00	SPY	ETF	435.83	436.14	435.43	435.8	36285.0
2022-03-16 19:30:00	SPY	ETF	435.83	436.3	435.64	436.25	67824.0
2022-03-16 04:00:00	QQQ	ETF	330.06	333.15	330.06	332.78	86871.0
2022-03-16 04:30:00	QQQ	ETF	332.81	333.57	332.61	333.2	64484.0
2022-03-16 05:00:00	QQQ	ETF	333.27	333.95	333.22	333.93	22247.0
2022-03-16 05:30:00	QQQ	ETF	334.0	334.17	333.42	333.52	69762.0
2022-03-16 06:00:00	QQQ	ETF	333.48	335.0	333.47	334.0	79791.0
2022-03-16 06:30:00	QQQ	ETF	334.01	334.38	333.64	334.1	61568.0
2022-03-16 07:00:00	QQQ	ETF	334.06	334.09	333.33	333.82	156075.0
2022-03-16 07:30:00	QQQ	ETF	333.94	334.26	333.71	334.14	128512.0
2022-03-16 08:00:00	QQQ	ETF	334.16	334.51	328.0	333.78	474702.0
2022-03-16 08:30:00	QQQ	ETF	333.95	334.16	332.71	332.89	416419.0
2022-03-16 09:00:00	QQQ	ETF	332.89	333.05	332.07	332.13	449948.0
2022-03-16 09:30:00	QQQ	ETF	332.17	335.27	332.01	334.63	7193920.0
2022-03-16 10:00:00	QQQ	ETF	334.64	337.46	333.89	337.11	6476882.0
2022-03-16 10:30:00	QQQ	ETF	337.12	338.16	336.33	337.372	5380778.0
2022-03-16 11:00:00	QQQ	ETF	337.35	337.63	336.51	337.06	2514419.0
2022-03-16 11:30:00	QQQ	ETF	337.08	337.44	336.33	336.94	1561367.0
2022-03-16 12:00:00	QQQ	ETF	336.95	337.3	336.12	336.43	1773020.0
2022-03-16 12:30:00	QQQ	ETF	336.43	336.54	334.4	334.79	2837856.0

> showing 50 of 28,004 rows — these rows as CSV

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