PREVIEW / etf_30min / 2022-06-22

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-06-22.parquet
  size:    673 KB
  rows:    27,218

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-06-22 04:00:00	SPY	ETF	368.07	368.63	367.65	367.97	117851.0
2022-06-22 04:30:00	SPY	ETF	368.12	368.92	368.07	368.7	58023.0
2022-06-22 05:00:00	SPY	ETF	368.65	369.37	368.55	369.25	45035.0
2022-06-22 05:30:00	SPY	ETF	369.0	369.45	368.88	369.39	39465.0
2022-06-22 06:00:00	SPY	ETF	369.37	370.03	369.2	369.95	33556.0
2022-06-22 06:30:00	SPY	ETF	369.97	370.07	369.37	369.69	132365.0
2022-06-22 07:00:00	SPY	ETF	369.67	370.61	369.67	370.6	201384.0
2022-06-22 07:30:00	SPY	ETF	370.63	370.68	369.74	369.74	293838.0
2022-06-22 08:00:00	SPY	ETF	369.66	372.78	367.8396	369.28	641609.0
2022-06-22 08:30:00	SPY	ETF	369.17	369.92	368.63	369.87	421277.0
2022-06-22 09:00:00	SPY	ETF	369.89	370.93	368.98	370.62	531063.0
2022-06-22 09:30:00	SPY	ETF	370.65	374.51	370.18	373.54	7965198.0
2022-06-22 10:00:00	SPY	ETF	373.53	377.02	372.775	376.81	5719247.0
2022-06-22 10:30:00	SPY	ETF	376.84	377.96	376.31	376.79	4451974.0
2022-06-22 11:00:00	SPY	ETF	376.81	377.0	375.4424	376.705	3442307.0
2022-06-22 11:30:00	SPY	ETF	376.71	377.69	374.59	374.7	4270931.0
2022-06-22 12:00:00	SPY	ETF	374.67	375.89	374.11	375.52	3346962.0
2022-06-22 12:30:00	SPY	ETF	375.515	376.53	375.42	376.44	1793369.0
2022-06-22 13:00:00	SPY	ETF	376.46	377.38	375.51	377.07	2075850.0
2022-06-22 13:30:00	SPY	ETF	377.08	377.45	376.28	377.11	2446899.0
2022-06-22 14:00:00	SPY	ETF	377.11	378.72	376.97	377.33	4328851.0
2022-06-22 14:30:00	SPY	ETF	377.34	377.6	376.49	377.25	3055841.0
2022-06-22 15:00:00	SPY	ETF	377.26	377.6	375.49	375.76	4431002.0
2022-06-22 15:30:00	SPY	ETF	375.76	376.09	374.23	374.39	11132454.0
2022-06-22 16:00:00	SPY	ETF	374.37	375.0	374.3	374.5	4190674.0
2022-06-22 16:30:00	SPY	ETF	374.55	374.59	374.14	374.25	274755.0
2022-06-22 17:00:00	SPY	ETF	374.18	374.35	374.15	374.15	32171.0
2022-06-22 17:30:00	SPY	ETF	374.2	374.25	374.13	374.25	58292.0
2022-06-22 18:00:00	SPY	ETF	374.3	374.5	373.68	373.73	157190.0
2022-06-22 18:30:00	SPY	ETF	373.83	374.0	373.72	373.92	18606.0
2022-06-22 19:00:00	SPY	ETF	373.92	373.92	372.72	372.8	102399.0
2022-06-22 19:30:00	SPY	ETF	372.79	372.79	372.07	372.67	102925.0
2022-06-22 04:00:00	QQQ	ETF	275.43	276.96	274.93	275.29	95869.0
2022-06-22 04:30:00	QQQ	ETF	275.3	275.92	275.3	275.69	74863.0
2022-06-22 05:00:00	QQQ	ETF	275.74	276.35	275.65	276.25	73590.0
2022-06-22 05:30:00	QQQ	ETF	276.08	276.36	276.02	276.33	36984.0
2022-06-22 06:00:00	QQQ	ETF	276.25	276.74	276.18	276.65	42588.0
2022-06-22 06:30:00	QQQ	ETF	276.72	276.76	276.25	276.5	37671.0
2022-06-22 07:00:00	QQQ	ETF	276.4	277.38	276.4	277.38	255232.0
2022-06-22 07:30:00	QQQ	ETF	277.39	277.49	276.77	276.8	242229.0
2022-06-22 08:00:00	QQQ	ETF	276.7	281.29	275.0996	276.56	744666.0
2022-06-22 08:30:00	QQQ	ETF	276.54	277.21	276.0	277.18	642483.0
2022-06-22 09:00:00	QQQ	ETF	277.21	278.9	276.55	278.5	964699.0
2022-06-22 09:30:00	QQQ	ETF	278.52	282.11	277.91	281.43	7638925.0
2022-06-22 10:00:00	QQQ	ETF	281.45	284.45	280.64	284.26	4842645.0
2022-06-22 10:30:00	QQQ	ETF	284.27	285.18	283.3	284.0	3801328.0
2022-06-22 11:00:00	QQQ	ETF	284.02	284.09	282.745	283.505	3007317.0
2022-06-22 11:30:00	QQQ	ETF	283.51	284.43	281.23	281.34	3608374.0
2022-06-22 12:00:00	QQQ	ETF	281.32	282.31	280.83	281.9701	3141291.0
2022-06-22 12:30:00	QQQ	ETF	281.975	283.02	281.89	282.9578	2008510.0

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

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