PREVIEW / etf_30min / 2021-05-25

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-05-25.parquet
  size:    582 KB
  rows:    23,323

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-05-25 04:00:00	SPY	ETF	420.26	420.39	420.1	420.2	5962.0
2021-05-25 04:30:00	SPY	ETF	420.38	420.44	420.29	420.39	2896.0
2021-05-25 05:00:00	SPY	ETF	420.39	420.5	420.37	420.45	16099.0
2021-05-25 05:30:00	SPY	ETF	420.47	420.5	420.37	420.47	5259.0
2021-05-25 06:00:00	SPY	ETF	420.51	420.64	420.11	420.24	6908.0
2021-05-25 06:30:00	SPY	ETF	420.2	420.22	420.05	420.12	12879.0
2021-05-25 07:00:00	SPY	ETF	420.12	420.45	420.03	420.43	51537.0
2021-05-25 07:30:00	SPY	ETF	420.42	420.59	420.4	420.5	26410.0
2021-05-25 08:00:00	SPY	ETF	420.03	420.56	419.9	420.4	83572.0
2021-05-25 08:30:00	SPY	ETF	420.4	420.5	420.13	420.24	106760.0
2021-05-25 09:00:00	SPY	ETF	420.28	420.41	420.15	420.31	184189.0
2021-05-25 09:30:00	SPY	ETF	420.33	420.71	419.24	419.3	6130190.0
2021-05-25 10:00:00	SPY	ETF	419.29	419.66	419.18	419.465	3335720.0
2021-05-25 10:30:00	SPY	ETF	419.46	419.6	418.9401	419.44	2416399.0
2021-05-25 11:00:00	SPY	ETF	419.435	419.5	418.421	418.535	3065891.0
2021-05-25 11:30:00	SPY	ETF	418.535	418.86	417.94	418.85	3091072.0
2021-05-25 12:00:00	SPY	ETF	418.86	419.43	418.71	419.275	2099375.0
2021-05-25 12:30:00	SPY	ETF	419.28	419.44	419.01	419.1119	1353059.0
2021-05-25 13:00:00	SPY	ETF	419.1	419.22	418.38	419.095	2193844.0
2021-05-25 13:30:00	SPY	ETF	419.1	419.2	418.65	418.76	1517126.0
2021-05-25 14:00:00	SPY	ETF	418.76	418.83	418.22	418.33	2302041.0
2021-05-25 14:30:00	SPY	ETF	418.33	418.76	418.2	418.359	2284872.0
2021-05-25 15:00:00	SPY	ETF	418.35	418.73	417.7969	418.45	3512271.0
2021-05-25 15:30:00	SPY	ETF	418.45	418.49	417.62	418.25	7795886.0
2021-05-25 16:00:00	SPY	ETF	418.26	418.37	418.16	418.27	1669698.0
2021-05-25 16:30:00	SPY	ETF	418.3	418.57	418.27	418.51	151379.0
2021-05-25 17:00:00	SPY	ETF	418.52	418.52	418.45	418.48	53577.0
2021-05-25 17:30:00	SPY	ETF	418.48	418.57	418.4	418.54	28800.0
2021-05-25 18:00:00	SPY	ETF	418.49	418.8	418.48	418.8	55547.0
2021-05-25 18:30:00	SPY	ETF	418.24	419.14	418.24	419.06	26684.0
2021-05-25 19:00:00	SPY	ETF	419.09	419.09	418.93	418.95	9009.0
2021-05-25 19:30:00	SPY	ETF	418.94	419.11	418.91	419.11	31826.0
2021-05-25 04:00:00	QQQ	ETF	334.06	334.51	333.95	334.2	41406.0
2021-05-25 04:30:00	QQQ	ETF	334.2	334.29	334.11	334.26	9697.0
2021-05-25 05:00:00	QQQ	ETF	334.26	334.28	334.09	334.28	18249.0
2021-05-25 05:30:00	QQQ	ETF	334.25	334.48	334.2	334.46	12366.0
2021-05-25 06:00:00	QQQ	ETF	334.44	334.59	333.89	333.93	35758.0
2021-05-25 06:30:00	QQQ	ETF	333.93	333.95	333.66	333.78	36605.0
2021-05-25 07:00:00	QQQ	ETF	333.73	334.23	333.47	334.23	77078.0
2021-05-25 07:30:00	QQQ	ETF	334.19	334.47	334.11	334.33	46100.0
2021-05-25 08:00:00	QQQ	ETF	333.51	334.98	333.3	334.3	154346.0
2021-05-25 08:30:00	QQQ	ETF	334.3	334.43	333.94	334.08	91214.0
2021-05-25 09:00:00	QQQ	ETF	334.08	334.23	333.881	334.07	196115.0
2021-05-25 09:30:00	QQQ	ETF	334.07	334.81	332.85	332.86	4518518.0
2021-05-25 10:00:00	QQQ	ETF	332.86	333.5	332.68	333.31	2983790.0
2021-05-25 10:30:00	QQQ	ETF	333.34	333.7	332.47	333.5398	1973108.0
2021-05-25 11:00:00	QQQ	ETF	333.5398	333.61	332.18	332.3895	1997047.0
2021-05-25 11:30:00	QQQ	ETF	332.39	332.66	331.755	332.64	2208962.0
2021-05-25 12:00:00	QQQ	ETF	332.645	332.86	332.39	332.6	1101882.0
2021-05-25 12:30:00	QQQ	ETF	332.62	332.9801	332.31	332.55	1092208.0

> showing 50 of 23,323 rows — these rows as CSV

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