PREVIEW / etf_30min / 2020-06-24

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-06-24.parquet
  size:    567 KB
  rows:    21,165

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
2020-06-24 04:00:00	SPY	ETF	310.71	310.81	308.74	309.38	102148.0
2020-06-24 04:30:00	SPY	ETF	309.43	309.94	309.29	309.81	26131.0
2020-06-24 05:00:00	SPY	ETF	309.84	310.13	308.18	308.75	122947.0
2020-06-24 05:30:00	SPY	ETF	308.73	309.15	308.59	308.98	28540.0
2020-06-24 06:00:00	SPY	ETF	309.05	309.42	308.76	309.02	57112.0
2020-06-24 06:30:00	SPY	ETF	309.15	309.61	309.1	309.5	33583.0
2020-06-24 07:00:00	SPY	ETF	309.6	310.01	309.55	309.65	86436.0
2020-06-24 07:30:00	SPY	ETF	309.71	309.91	309.38	309.7	95711.0
2020-06-24 08:00:00	SPY	ETF	309.65	312.5	309.0204	310.14	248238.0
2020-06-24 08:30:00	SPY	ETF	310.14	310.53	309.6	310.47	321654.0
2020-06-24 09:00:00	SPY	ETF	310.45	310.61	309.2	309.84	696548.0
2020-06-24 09:30:00	SPY	ETF	309.84	310.51	307.65	307.745	8571847.0
2020-06-24 10:00:00	SPY	ETF	307.75	308.3716	307.0	308.27	8065680.0
2020-06-24 10:30:00	SPY	ETF	308.26	308.265	306.15	306.48	7593039.0
2020-06-24 11:00:00	SPY	ETF	306.46	306.82	304.29	304.99	10857309.0
2020-06-24 11:30:00	SPY	ETF	304.96	305.12	302.1	303.46	15154989.0
2020-06-24 12:00:00	SPY	ETF	303.45	304.52	303.08	304.09	9146193.0
2020-06-24 12:30:00	SPY	ETF	304.08	305.33	303.63	305.24	5102840.0
2020-06-24 13:00:00	SPY	ETF	305.235	305.5	303.83	303.89	4905501.0
2020-06-24 13:30:00	SPY	ETF	303.89	303.91	303.03	303.8601	4553337.0
2020-06-24 14:00:00	SPY	ETF	303.86	304.66	302.78	304.55	5966518.0
2020-06-24 14:30:00	SPY	ETF	304.53	304.83	303.52	303.7001	5397886.0
2020-06-24 15:00:00	SPY	ETF	303.73	305.74	303.73	304.67	7665511.0
2020-06-24 15:30:00	SPY	ETF	304.665	305.68	303.63	304.12	21553037.0
2020-06-24 16:00:00	SPY	ETF	304.11	312.0536	303.9863	304.85	11320220.0
2020-06-24 16:30:00	SPY	ETF	304.85	312.0536	304.09	305.05	1873747.0
2020-06-24 17:00:00	SPY	ETF	305.07	305.07	304.92	304.96	77966.0
2020-06-24 17:30:00	SPY	ETF	304.99	305.0	304.72	304.72	84754.0
2020-06-24 18:00:00	SPY	ETF	304.8	305.26	304.3	304.92	358733.0
2020-06-24 18:30:00	SPY	ETF	304.82	304.93	304.14	304.35	107706.0
2020-06-24 19:00:00	SPY	ETF	304.34	304.42	303.82	304.09	84611.0
2020-06-24 19:30:00	SPY	ETF	304.09	304.43	303.81	303.81	194749.0
2020-06-24 04:00:00	QQQ	ETF	248.0	248.25	247.08	247.46	63579.0
2020-06-24 04:30:00	QQQ	ETF	247.3	247.86	247.27	247.86	9170.0
2020-06-24 05:00:00	QQQ	ETF	247.8	247.8	246.56	246.97	41072.0
2020-06-24 05:30:00	QQQ	ETF	247.11	247.45	247.11	247.3	7185.0
2020-06-24 06:00:00	QQQ	ETF	247.27	247.54	247.11	247.33	16755.0
2020-06-24 06:30:00	QQQ	ETF	247.46	247.73	247.46	247.51	13626.0
2020-06-24 07:00:00	QQQ	ETF	247.6	247.97	247.57	247.73	59771.0
2020-06-24 07:30:00	QQQ	ETF	247.75	247.95	247.54	247.72	40974.0
2020-06-24 08:00:00	QQQ	ETF	247.8	249.77	247.5504	248.18	150837.0
2020-06-24 08:30:00	QQQ	ETF	248.211	248.39	247.82	248.35	76895.0
2020-06-24 09:00:00	QQQ	ETF	248.31	248.38	247.65	248.03	330679.0
2020-06-24 09:30:00	QQQ	ETF	247.99	249.325	246.06	246.27	5134231.0
2020-06-24 10:00:00	QQQ	ETF	246.24	247.03	245.67	246.97	3651841.0
2020-06-24 10:30:00	QQQ	ETF	246.9385	246.96	245.31	245.71	2891243.0
2020-06-24 11:00:00	QQQ	ETF	245.69	245.94	243.71	244.46	3938084.0
2020-06-24 11:30:00	QQQ	ETF	244.48	244.61	242.16	243.21	3940915.0
2020-06-24 12:00:00	QQQ	ETF	243.2	243.9615	242.71	243.7599	2658097.0
2020-06-24 12:30:00	QQQ	ETF	243.77	244.66	243.3	244.608	1774932.0

> showing 50 of 21,165 rows — these rows as CSV

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