PREVIEW / etf_30min / 2022-04-07

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-04-07.parquet
  size:    667 KB
  rows:    26,027

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-07 04:00:00	SPY	ETF	445.74	446.74	445.61	446.72	29672.0
2022-04-07 04:30:00	SPY	ETF	446.59	447.5	446.39	447.5	5755.0
2022-04-07 05:00:00	SPY	ETF	447.41	447.56	447.1	447.27	19551.0
2022-04-07 05:30:00	SPY	ETF	447.35	447.9	447.35	447.9	21770.0
2022-04-07 06:00:00	SPY	ETF	447.88	447.99	447.77	447.89	10015.0
2022-04-07 06:30:00	SPY	ETF	447.84	447.9	447.55	447.57	20648.0
2022-04-07 07:00:00	SPY	ETF	447.54	448.65	447.1	447.27	164439.0
2022-04-07 07:30:00	SPY	ETF	447.17	447.5	446.91	447.34	103549.0
2022-04-07 08:00:00	SPY	ETF	448.4801	448.5	444.95	446.43	434725.0
2022-04-07 08:30:00	SPY	ETF	446.28	446.69	445.76	445.9001	178822.0
2022-04-07 09:00:00	SPY	ETF	445.98	446.07	445.31	445.55	300762.0
2022-04-07 09:30:00	SPY	ETF	445.61	447.655	445.29	447.0	5987476.0
2022-04-07 10:00:00	SPY	ETF	447.0	447.75	445.57	445.7	4645202.0
2022-04-07 10:30:00	SPY	ETF	445.6964	446.6301	444.31	445.24	4160480.0
2022-04-07 11:00:00	SPY	ETF	445.2352	446.09	444.17	444.47	3193395.0
2022-04-07 11:30:00	SPY	ETF	444.51	444.94	443.86	444.32	3202626.0
2022-04-07 12:00:00	SPY	ETF	444.31	445.18	444.1399	444.3247	2515272.0
2022-04-07 12:30:00	SPY	ETF	444.339	444.66	443.53	444.2715	2750767.0
2022-04-07 13:00:00	SPY	ETF	444.27	446.78	444.16	446.55	4543328.0
2022-04-07 13:30:00	SPY	ETF	446.56	447.685	445.911	447.49	2902957.0
2022-04-07 14:00:00	SPY	ETF	447.46	448.23	446.88	447.23	3785916.0
2022-04-07 14:30:00	SPY	ETF	447.23	449.47	446.97	449.24	3956472.0
2022-04-07 15:00:00	SPY	ETF	449.25	450.52	449.0831	449.29	6444156.0
2022-04-07 15:30:00	SPY	ETF	449.3	450.69	448.44	448.74	10921240.0
2022-04-07 16:00:00	SPY	ETF	448.74	448.95	448.21	448.3	2736086.0
2022-04-07 16:30:00	SPY	ETF	448.36	448.77	448.29	448.56	194818.0
2022-04-07 17:00:00	SPY	ETF	448.5	448.63	448.29	448.5	42341.0
2022-04-07 17:30:00	SPY	ETF	448.45	448.56	448.4	448.51	28005.0
2022-04-07 18:00:00	SPY	ETF	448.5	448.85	448.48	448.6896	41221.0
2022-04-07 18:30:00	SPY	ETF	448.6996	448.75	448.57	448.64	29120.0
2022-04-07 19:00:00	SPY	ETF	448.7	449.0	448.61	448.95	10430.0
2022-04-07 19:30:00	SPY	ETF	448.98	449.32	448.91	449.24	14460.0
2022-04-07 04:00:00	QQQ	ETF	353.49	354.3	353.38	354.1	84608.0
2022-04-07 04:30:00	QQQ	ETF	354.05	354.98	353.78	354.93	31274.0
2022-04-07 05:00:00	QQQ	ETF	354.84	354.91	354.49	354.69	36629.0
2022-04-07 05:30:00	QQQ	ETF	354.72	355.11	354.72	355.08	29993.0
2022-04-07 06:00:00	QQQ	ETF	355.0	355.22	355.0	355.06	18367.0
2022-04-07 06:30:00	QQQ	ETF	355.01	355.04	354.54	354.54	63203.0
2022-04-07 07:00:00	QQQ	ETF	354.59	355.56	354.12	354.33	193352.0
2022-04-07 07:30:00	QQQ	ETF	354.34	354.6	353.94	354.36	158193.0
2022-04-07 08:00:00	QQQ	ETF	354.24	355.53	351.75	353.3	305964.0
2022-04-07 08:30:00	QQQ	ETF	353.25	353.62	352.49	352.65	250351.0
2022-04-07 09:00:00	QQQ	ETF	352.72	352.87	351.93	352.23	338043.0
2022-04-07 09:30:00	QQQ	ETF	352.24	355.0	352.09	354.6	7294396.0
2022-04-07 10:00:00	QQQ	ETF	354.57	355.73	352.98	353.51	5154430.0
2022-04-07 10:30:00	QQQ	ETF	353.49	354.5	351.32	352.4	4210255.0
2022-04-07 11:00:00	QQQ	ETF	352.4	353.3	350.8	351.06	3340665.0
2022-04-07 11:30:00	QQQ	ETF	351.08	351.15	349.58	350.12	2915831.0
2022-04-07 12:00:00	QQQ	ETF	350.11	351.11	349.882	350.18	2352014.0
2022-04-07 12:30:00	QQQ	ETF	350.1897	350.35	348.69	349.6881	2527689.0

> showing 50 of 26,027 rows — these rows as CSV

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