PREVIEW / etf_30min / 2021-12-07

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-12-07.parquet
  size:    660 KB
  rows:    25,652

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-07 04:00:00	SPY	ETF	460.11	464.32	459.75	464.09	181571.0
2021-12-07 04:30:00	SPY	ETF	464.08	464.1	463.5	463.88	37264.0
2021-12-07 05:00:00	SPY	ETF	463.91	464.48	463.89	464.48	18731.0
2021-12-07 05:30:00	SPY	ETF	464.41	465.23	464.27	464.85	47226.0
2021-12-07 06:00:00	SPY	ETF	464.83	464.91	464.5	464.65	27588.0
2021-12-07 06:30:00	SPY	ETF	464.64	465.02	464.63	464.8	55112.0
2021-12-07 07:00:00	SPY	ETF	464.8	464.92	464.23	464.59	244056.0
2021-12-07 07:30:00	SPY	ETF	464.55	464.71	464.43	464.64	130996.0
2021-12-07 08:00:00	SPY	ETF	464.6401	464.91	460.5	464.76	279725.0
2021-12-07 08:30:00	SPY	ETF	464.79	465.0	464.3	464.31	398177.0
2021-12-07 09:00:00	SPY	ETF	464.34	464.49	463.89	464.4	274939.0
2021-12-07 09:30:00	SPY	ETF	464.41	467.26	464.345	467.24	9304061.0
2021-12-07 10:00:00	SPY	ETF	467.24	468.15	466.9632	467.51	7779984.0
2021-12-07 10:30:00	SPY	ETF	467.525	468.77	467.52	468.466	5296717.0
2021-12-07 11:00:00	SPY	ETF	468.46	468.88	468.04	468.295	4258926.0
2021-12-07 11:30:00	SPY	ETF	468.29	468.6	468.02	468.12	2788498.0
2021-12-07 12:00:00	SPY	ETF	468.12	468.41	467.93	468.1	2161370.0
2021-12-07 12:30:00	SPY	ETF	468.1	468.6417	468.09	468.6168	1923210.0
2021-12-07 13:00:00	SPY	ETF	468.61	468.61	467.78	468.19	2075710.0
2021-12-07 13:30:00	SPY	ETF	468.2	468.79	468.08	468.46	1805888.0
2021-12-07 14:00:00	SPY	ETF	468.47	468.53	468.085	468.31	1798099.0
2021-12-07 14:30:00	SPY	ETF	468.32	468.44	467.82	468.18	2394713.0
2021-12-07 15:00:00	SPY	ETF	468.17	468.53	467.27	467.27	4860778.0
2021-12-07 15:30:00	SPY	ETF	467.27	468.29	466.24	468.24	17622869.0
2021-12-07 16:00:00	SPY	ETF	468.24	469.29	467.489	469.09	8147301.0
2021-12-07 16:30:00	SPY	ETF	469.07	469.31	468.28	469.14	248925.0
2021-12-07 17:00:00	SPY	ETF	469.18	469.39	468.28	469.2	50778.0
2021-12-07 17:30:00	SPY	ETF	469.21	469.32	469.15	469.22	137128.0
2021-12-07 18:00:00	SPY	ETF	469.22	469.25	468.28	468.51	684587.0
2021-12-07 18:30:00	SPY	ETF	468.28	468.8	468.28	468.55	33886.0
2021-12-07 19:00:00	SPY	ETF	468.59	468.59	468.02	468.38	53455.0
2021-12-07 19:30:00	SPY	ETF	468.43	469.63	468.43	469.58	198709.0
2021-12-07 04:00:00	QQQ	ETF	390.0	393.33	390.0	393.1	94590.0
2021-12-07 04:30:00	QQQ	ETF	393.02	393.05	392.47	392.75	32976.0
2021-12-07 05:00:00	QQQ	ETF	392.73	393.07	392.67	393.03	19390.0
2021-12-07 05:30:00	QQQ	ETF	392.9	394.13	392.84	393.66	36375.0
2021-12-07 06:00:00	QQQ	ETF	393.6	393.66	392.94	393.11	39294.0
2021-12-07 06:30:00	QQQ	ETF	393.11	393.7	393.11	393.39	38547.0
2021-12-07 07:00:00	QQQ	ETF	393.36	393.53	392.82	393.34	165536.0
2021-12-07 07:30:00	QQQ	ETF	393.28	393.41	393.02	393.29	114621.0
2021-12-07 08:00:00	QQQ	ETF	392.8799	393.8004	386.489	393.29	187812.0
2021-12-07 08:30:00	QQQ	ETF	393.36	393.8	392.98	393.01	185445.0
2021-12-07 09:00:00	QQQ	ETF	393.0	393.15	392.48	392.97	364020.0
2021-12-07 09:30:00	QQQ	ETF	392.98	395.67	392.98	395.65	7542678.0
2021-12-07 10:00:00	QQQ	ETF	395.66	396.62	395.27	395.7881	4456341.0
2021-12-07 10:30:00	QQQ	ETF	395.82	397.48	395.78	396.71	3240362.0
2021-12-07 11:00:00	QQQ	ETF	396.71	397.35	396.515	396.885	2597567.0
2021-12-07 11:30:00	QQQ	ETF	396.87	397.74	396.72	397.24	2272323.0
2021-12-07 12:00:00	QQQ	ETF	397.26	397.87	397.15	397.6217	1844454.0
2021-12-07 12:30:00	QQQ	ETF	397.63	398.28	397.56	398.1481	1573634.0

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

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