PREVIEW / etf_30min / 2022-04-06

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-04-06.parquet
  size:    682 KB
  rows:    27,407

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-04-06 04:00:00	SPY	ETF	451.27	451.27	448.79	449.11	16723.0
2022-04-06 04:30:00	SPY	ETF	449.15	449.47	448.8	449.47	16475.0
2022-04-06 05:00:00	SPY	ETF	449.6	449.6	448.8	448.84	19591.0
2022-04-06 05:30:00	SPY	ETF	448.88	448.88	447.99	448.65	18010.0
2022-04-06 06:00:00	SPY	ETF	448.7	448.71	447.9	448.3	23080.0
2022-04-06 06:30:00	SPY	ETF	448.2	448.2	447.69	447.75	47513.0
2022-04-06 07:00:00	SPY	ETF	447.82	447.99	447.1	447.15	132250.0
2022-04-06 07:30:00	SPY	ETF	447.15	447.35	446.51	446.72	455221.0
2022-04-06 08:00:00	SPY	ETF	447.3199	451.55	446.43	447.18	281781.0
2022-04-06 08:30:00	SPY	ETF	447.14	447.21	446.6	447.07	221707.0
2022-04-06 09:00:00	SPY	ETF	447.01	447.37	446.87	446.88	413304.0
2022-04-06 09:30:00	SPY	ETF	446.89	447.59	445.44	445.59	9638997.0
2022-04-06 10:00:00	SPY	ETF	445.5801	445.81	444.5	444.98	7304666.0
2022-04-06 10:30:00	SPY	ETF	444.97	445.86	444.74	444.965	4021386.0
2022-04-06 11:00:00	SPY	ETF	444.97	445.72	444.6615	445.45	3877809.0
2022-04-06 11:30:00	SPY	ETF	445.455	446.4284	444.915	445.915	3323345.0
2022-04-06 12:00:00	SPY	ETF	445.9	446.1	444.62	444.89	2731706.0
2022-04-06 12:30:00	SPY	ETF	444.89	445.36	444.74	445.2782	2385663.0
2022-04-06 13:00:00	SPY	ETF	445.26	445.92	444.935	445.82	2242465.0
2022-04-06 13:30:00	SPY	ETF	445.815	446.88	445.65	446.06	3599922.0
2022-04-06 14:00:00	SPY	ETF	446.07	448.53	443.47	444.565	11746274.0
2022-04-06 14:30:00	SPY	ETF	444.56	448.04	444.455	447.975	7740453.0
2022-04-06 15:00:00	SPY	ETF	447.99	448.93	445.59	445.68	7194373.0
2022-04-06 15:30:00	SPY	ETF	445.67	448.0	445.3243	446.57	11854595.0
2022-04-06 16:00:00	SPY	ETF	446.56	446.75	446.12	446.44	2682487.0
2022-04-06 16:30:00	SPY	ETF	446.45	446.52	446.14	446.14	120491.0
2022-04-06 17:00:00	SPY	ETF	446.14	446.52	446.14	446.31	71251.0
2022-04-06 17:30:00	SPY	ETF	446.29	446.29	446.16	446.25	52881.0
2022-04-06 18:00:00	SPY	ETF	446.27	446.69	446.15	446.48	77174.0
2022-04-06 18:30:00	SPY	ETF	446.61	446.72	446.5	446.54	15449.0
2022-04-06 19:00:00	SPY	ETF	446.6	446.6	446.32	446.41	23528.0
2022-04-06 19:30:00	SPY	ETF	446.38	446.43	445.11	445.2	41953.0
2022-04-06 04:00:00	QQQ	ETF	359.46	359.46	358.2	358.59	59965.0
2022-04-06 04:30:00	QQQ	ETF	358.64	358.9	358.24	358.84	45716.0
2022-04-06 05:00:00	QQQ	ETF	359.06	359.08	358.38	358.57	26587.0
2022-04-06 05:30:00	QQQ	ETF	358.57	358.59	357.55	358.21	72973.0
2022-04-06 06:00:00	QQQ	ETF	358.2	358.24	357.26	357.61	49862.0
2022-04-06 06:30:00	QQQ	ETF	357.62	357.62	356.97	357.0	108275.0
2022-04-06 07:00:00	QQQ	ETF	357.01	357.21	355.8	355.84	212485.0
2022-04-06 07:30:00	QQQ	ETF	355.84	356.05	355.14	355.34	342408.0
2022-04-06 08:00:00	QQQ	ETF	356.112	361.37	355.13	355.63	527781.0
2022-04-06 08:30:00	QQQ	ETF	355.689	355.76	355.19	355.68	212009.0
2022-04-06 09:00:00	QQQ	ETF	355.56	355.97	355.45	355.61	416069.0
2022-04-06 09:30:00	QQQ	ETF	355.65	356.61	353.13	353.23	9345858.0
2022-04-06 10:00:00	QQQ	ETF	353.26	353.39	352.01	352.18	6366904.0
2022-04-06 10:30:00	QQQ	ETF	352.18	353.74	352.0	352.49	4634077.0
2022-04-06 11:00:00	QQQ	ETF	352.49	353.19	351.81	352.67	3233547.0
2022-04-06 11:30:00	QQQ	ETF	352.69	353.69	351.99	353.006	2574658.0
2022-04-06 12:00:00	QQQ	ETF	352.98	353.19	351.35	351.49	2199925.0
2022-04-06 12:30:00	QQQ	ETF	351.5	352.04	351.16	351.8	2386827.0

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

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