PREVIEW / etf_30min / 2021-01-04

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-01-04.parquet
  size:    648 KB
  rows:    24,487

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-01-04 04:00:00	SPY	ETF	375.64	376.42	375.64	376.39	72363.0
2021-01-04 04:30:00	SPY	ETF	376.36	376.74	376.36	376.48	18596.0
2021-01-04 05:00:00	SPY	ETF	376.51	376.61	376.15	376.15	12962.0
2021-01-04 05:30:00	SPY	ETF	376.25	376.38	376.17	376.18	13417.0
2021-01-04 06:00:00	SPY	ETF	376.23	376.44	376.23	376.24	13802.0
2021-01-04 06:30:00	SPY	ETF	376.35	376.46	376.19	376.19	12560.0
2021-01-04 07:00:00	SPY	ETF	376.14	376.2	375.88	376.14	34934.0
2021-01-04 07:30:00	SPY	ETF	376.1	376.19	375.74	376.18	31994.0
2021-01-04 08:00:00	SPY	ETF	376.11	376.18	374.1	375.76	179521.0
2021-01-04 08:30:00	SPY	ETF	375.73	375.91	375.55	375.58	113674.0
2021-01-04 09:00:00	SPY	ETF	375.69	375.79	375.31	375.34	205108.0
2021-01-04 09:30:00	SPY	ETF	375.31	375.45	373.11	373.51	6574679.0
2021-01-04 10:00:00	SPY	ETF	373.53	373.74	372.14	372.49	4857807.0
2021-01-04 10:30:00	SPY	ETF	372.48	372.5999	369.82	369.98	7944588.0
2021-01-04 11:00:00	SPY	ETF	369.995	370.45	367.6522	368.9881	8455463.0
2021-01-04 11:30:00	SPY	ETF	368.98	368.987	366.69	366.96	6518710.0
2021-01-04 12:00:00	SPY	ETF	366.95	367.25	364.82	366.463	8315492.0
2021-01-04 12:30:00	SPY	ETF	366.4599	366.4599	365.01	366.2701	6144086.0
2021-01-04 13:00:00	SPY	ETF	366.27	368.25	366.07	367.96	4885973.0
2021-01-04 13:30:00	SPY	ETF	367.95	368.64	367.39	368.595	4485448.0
2021-01-04 14:00:00	SPY	ETF	368.59	368.62	367.24	367.8	3755440.0
2021-01-04 14:30:00	SPY	ETF	367.795	368.13	366.6	367.98	5716777.0
2021-01-04 15:00:00	SPY	ETF	367.97	368.17	367.05	367.61	6042746.0
2021-01-04 15:30:00	SPY	ETF	367.61	369.55	367.21	368.85	19247392.0
2021-01-04 16:00:00	SPY	ETF	368.84	369.37	368.37	368.62	11239774.0
2021-01-04 16:30:00	SPY	ETF	368.62	369.16	368.61	369.1	648288.0
2021-01-04 17:00:00	SPY	ETF	369.08	369.08	368.6842	368.98	2951253.0
2021-01-04 17:30:00	SPY	ETF	368.97	369.12	368.91	368.98	38304.0
2021-01-04 18:00:00	SPY	ETF	369.02	369.02	368.23	368.35	141193.0
2021-01-04 18:30:00	SPY	ETF	368.58	368.84	368.5	368.8	46175.0
2021-01-04 19:00:00	SPY	ETF	368.88	369.3	368.79	369.19	50888.0
2021-01-04 19:30:00	SPY	ETF	369.21	369.44	369.0	369.34	76878.0
2021-01-04 04:00:00	QQQ	ETF	315.06	315.66	315.06	315.54	33312.0
2021-01-04 04:30:00	QQQ	ETF	315.64	315.75	315.5	315.52	25847.0
2021-01-04 05:00:00	QQQ	ETF	315.53	315.61	315.14	315.27	22922.0
2021-01-04 05:30:00	QQQ	ETF	315.27	315.48	315.26	315.3	33481.0
2021-01-04 06:00:00	QQQ	ETF	315.3	315.48	315.28	315.33	16801.0
2021-01-04 06:30:00	QQQ	ETF	315.37	315.53	315.33	315.38	41079.0
2021-01-04 07:00:00	QQQ	ETF	315.32	315.36	315.2	315.31	140317.0
2021-01-04 07:30:00	QQQ	ETF	315.31	315.6	315.26	315.6	64224.0
2021-01-04 08:00:00	QQQ	ETF	315.6	315.62	313.16	315.34	234115.0
2021-01-04 08:30:00	QQQ	ETF	315.34	315.55	315.22	315.3	82085.0
2021-01-04 09:00:00	QQQ	ETF	315.301	315.301	313.74	315.14	145732.0
2021-01-04 09:30:00	QQQ	ETF	315.11	315.29	313.29	313.81	3978299.0
2021-01-04 10:00:00	QQQ	ETF	313.82	314.08	313.0146	313.8192	2362009.0
2021-01-04 10:30:00	QQQ	ETF	313.81	314.01	310.9502	310.9558	2769619.0
2021-01-04 11:00:00	QQQ	ETF	310.98	311.47	308.98	310.0	3604779.0
2021-01-04 11:30:00	QQQ	ETF	309.97	310.0418	307.94	307.9401	2525898.0
2021-01-04 12:00:00	QQQ	ETF	307.96	308.28	305.18	307.04	4325515.0
2021-01-04 12:30:00	QQQ	ETF	306.9712	307.21	305.66	307.0125	2108672.0

> showing 50 of 24,487 rows — these rows as CSV

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