PREVIEW / etf_30min / 2021-12-17

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-12-17.parquet
  size:    653 KB
  rows:    25,470

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
2021-12-17 04:00:00	SPY	ETF	464.91	464.91	462.5	464.02	76773.0
2021-12-17 04:30:00	SPY	ETF	464.07	464.14	463.04	464.08	12271.0
2021-12-17 05:00:00	SPY	ETF	464.21	464.31	463.28	463.39	36595.0
2021-12-17 05:30:00	SPY	ETF	463.3	463.61	462.8	463.32	19855.0
2021-12-17 06:00:00	SPY	ETF	463.33	463.8	463.04	463.8	14300.0
2021-12-17 06:30:00	SPY	ETF	463.76	463.84	463.34	463.79	25829.0
2021-12-17 07:00:00	SPY	ETF	463.81	463.92	462.78	462.85	197824.0
2021-12-17 07:30:00	SPY	ETF	463.031	463.031	461.46	461.98	288533.0
2021-12-17 08:00:00	SPY	ETF	463.83	465.05	461.5	462.11	287863.0
2021-12-17 08:30:00	SPY	ETF	462.08	462.37	461.74	462.34	237328.0
2021-12-17 09:00:00	SPY	ETF	462.35	462.47	461.12	461.44	533460.0
2021-12-17 09:30:00	SPY	ETF	461.52	462.37	459.31	460.43	11578447.0
2021-12-17 10:00:00	SPY	ETF	460.45	460.45	458.06	459.42	7754522.0
2021-12-17 10:30:00	SPY	ETF	459.41	463.96	458.96	463.25	7968516.0
2021-12-17 11:00:00	SPY	ETF	463.29	464.74	462.68	464.05	5410109.0
2021-12-17 11:30:00	SPY	ETF	464.05	464.219	460.32	461.38	6612289.0
2021-12-17 12:00:00	SPY	ETF	461.37	461.9	459.83	461.57	4138958.0
2021-12-17 12:30:00	SPY	ETF	461.57	462.65	461.05	461.76	3310726.0
2021-12-17 13:00:00	SPY	ETF	461.74	463.02	461.03	462.93	2931429.0
2021-12-17 13:30:00	SPY	ETF	462.94	463.72	462.2101	463.59	2856637.0
2021-12-17 14:00:00	SPY	ETF	463.6	463.69	461.98	462.26	3144608.0
2021-12-17 14:30:00	SPY	ETF	462.26	463.26	461.77	462.2701	3578697.0
2021-12-17 15:00:00	SPY	ETF	462.28	463.26	461.37	461.77	5357483.0
2021-12-17 15:30:00	SPY	ETF	461.78	461.979	459.52	459.9	14930505.0
2021-12-17 16:00:00	SPY	ETF	459.9	461.2	459.72	460.99	6294465.0
2021-12-17 16:30:00	SPY	ETF	461.0	461.05	460.91	460.96	180279.0
2021-12-17 17:00:00	SPY	ETF	460.99	461.17	459.87	461.05	368246.0
2021-12-17 17:30:00	SPY	ETF	461.12	461.29	459.87	461.2	242962.0
2021-12-17 18:00:00	SPY	ETF	461.21	461.4	461.13	461.22	11684.0
2021-12-17 18:30:00	SPY	ETF	461.21	461.57	461.05	461.55	69242.0
2021-12-17 19:00:00	SPY	ETF	461.55	461.56	461.2401	461.31	19313.0
2021-12-17 19:30:00	SPY	ETF	461.3	461.56	461.2	461.56	14059.0
2021-12-17 04:00:00	QQQ	ETF	385.41	385.41	382.41	384.18	105748.0
2021-12-17 04:30:00	QQQ	ETF	383.96	384.66	383.02	384.53	34221.0
2021-12-17 05:00:00	QQQ	ETF	384.61	384.62	383.32	383.4	51271.0
2021-12-17 05:30:00	QQQ	ETF	383.65	383.92	383.04	383.5	34524.0
2021-12-17 06:00:00	QQQ	ETF	383.5	384.4	383.5	384.4	60939.0
2021-12-17 06:30:00	QQQ	ETF	384.35	384.52	384.0	384.41	129131.0
2021-12-17 07:00:00	QQQ	ETF	384.5	384.55	383.16	383.25	78004.0
2021-12-17 07:30:00	QQQ	ETF	383.32	383.55	382.06	382.74	227438.0
2021-12-17 08:00:00	QQQ	ETF	384.48	387.13	382.11	382.85	497379.0
2021-12-17 08:30:00	QQQ	ETF	382.95	383.68	382.68	383.66	421173.0
2021-12-17 09:00:00	QQQ	ETF	383.66	383.9	382.91	383.35	437802.0
2021-12-17 09:30:00	QQQ	ETF	383.33	386.39	381.88	384.93	9774015.0
2021-12-17 10:00:00	QQQ	ETF	384.9	385.3024	381.77	383.83	6960080.0
2021-12-17 10:30:00	QQQ	ETF	383.79	388.19	383.27	387.74	5791877.0
2021-12-17 11:00:00	QQQ	ETF	387.75	389.19	386.74	388.32	3221635.0
2021-12-17 11:30:00	QQQ	ETF	388.29	388.56	384.42	385.795	4283033.0
2021-12-17 12:00:00	QQQ	ETF	385.75	386.47	383.99	385.73	3016415.0
2021-12-17 12:30:00	QQQ	ETF	385.72	386.9	384.87	385.7687	2035196.0

> showing 50 of 25,470 rows — these rows as CSV

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