PREVIEW / etf_30min / 2020-08-19

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-08-19.parquet
  size:    553 KB
  rows:    20,175

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-08-19 04:00:00	SPY	ETF	339.13	339.29	339.03	339.29	33521.0
2020-08-19 04:30:00	SPY	ETF	339.28	339.28	339.04	339.05	10356.0
2020-08-19 05:00:00	SPY	ETF	339.15	339.3	339.15	339.28	18810.0
2020-08-19 05:30:00	SPY	ETF	339.26	339.35	339.26	339.32	4734.0
2020-08-19 06:00:00	SPY	ETF	339.33	339.33	339.13	339.16	13215.0
2020-08-19 06:30:00	SPY	ETF	339.16	339.33	339.15	339.31	59297.0
2020-08-19 07:00:00	SPY	ETF	339.34	339.37	339.05	339.06	18681.0
2020-08-19 07:30:00	SPY	ETF	339.05	339.16	339.0	339.12	20782.0
2020-08-19 08:00:00	SPY	ETF	339.3596	339.4	338.67	338.72	76118.0
2020-08-19 08:30:00	SPY	ETF	338.74	338.93	338.67	338.9	121556.0
2020-08-19 09:00:00	SPY	ETF	338.86	339.18	338.81	339.07	109926.0
2020-08-19 09:30:00	SPY	ETF	339.05	339.197	338.62	338.7763	3380740.0
2020-08-19 10:00:00	SPY	ETF	338.78	339.15	338.73	339.14	1781221.0
2020-08-19 10:30:00	SPY	ETF	339.14	339.33	339.06	339.235	2805779.0
2020-08-19 11:00:00	SPY	ETF	339.24	339.38	339.0	339.305	3911333.0
2020-08-19 11:30:00	SPY	ETF	339.31	339.61	339.26	339.5015	2130070.0
2020-08-19 12:00:00	SPY	ETF	339.51	339.52	339.29	339.41	3526247.0
2020-08-19 12:30:00	SPY	ETF	339.405	339.4277	339.04	339.18	1072715.0
2020-08-19 13:00:00	SPY	ETF	339.18	339.32	339.11	339.185	1019885.0
2020-08-19 13:30:00	SPY	ETF	339.18	339.43	339.18	339.37	1452299.0
2020-08-19 14:00:00	SPY	ETF	339.37	339.59	337.8	338.1621	7529344.0
2020-08-19 14:30:00	SPY	ETF	338.15	338.8	337.93	338.635	5225337.0
2020-08-19 15:00:00	SPY	ETF	338.64	338.79	337.695	337.9	7125852.0
2020-08-19 15:30:00	SPY	ETF	337.885	338.06	336.62	337.22	17428631.0
2020-08-19 16:00:00	SPY	ETF	337.22	337.52	336.86	337.3	8072167.0
2020-08-19 16:30:00	SPY	ETF	337.27	337.27	336.9	337.01	182672.0
2020-08-19 17:00:00	SPY	ETF	337.03	337.23	336.91	337.03	96840.0
2020-08-19 17:30:00	SPY	ETF	336.95	337.15	336.92	337.1	29938.0
2020-08-19 18:00:00	SPY	ETF	337.01	337.1	336.85	337.0	138433.0
2020-08-19 18:30:00	SPY	ETF	337.04	337.06	336.85	336.86	17136.0
2020-08-19 19:00:00	SPY	ETF	336.87	336.94	336.67	336.7	41217.0
2020-08-19 19:30:00	SPY	ETF	336.68	336.68	336.21	336.27	75045.0
2020-08-19 04:00:00	QQQ	ETF	278.65	278.78	278.51	278.78	8190.0
2020-08-19 04:30:00	QQQ	ETF	278.72	278.72	278.51	278.58	2650.0
2020-08-19 05:00:00	QQQ	ETF	278.54	278.78	278.54	278.75	1300.0
2020-08-19 05:30:00	QQQ	ETF	278.77	278.79	278.67	278.74	4605.0
2020-08-19 06:00:00	QQQ	ETF	278.66	278.74	278.57	278.57	4850.0
2020-08-19 06:30:00	QQQ	ETF	278.59	278.75	278.59	278.7	9079.0
2020-08-19 07:00:00	QQQ	ETF	278.7	278.75	278.08	278.09	69534.0
2020-08-19 07:30:00	QQQ	ETF	278.03	278.18	278.01	278.12	80944.0
2020-08-19 08:00:00	QQQ	ETF	278.74	278.74	277.46	277.631	180583.0
2020-08-19 08:30:00	QQQ	ETF	277.69	277.79	277.55	277.65	78175.0
2020-08-19 09:00:00	QQQ	ETF	277.66	277.97	277.55	277.94	150960.0
2020-08-19 09:30:00	QQQ	ETF	277.94	278.46	276.45	276.96	3816619.0
2020-08-19 10:00:00	QQQ	ETF	276.95	278.16	276.8	278.1201	1892265.0
2020-08-19 10:30:00	QQQ	ETF	278.13	278.4001	277.81	278.27	1432499.0
2020-08-19 11:00:00	QQQ	ETF	278.27	278.52	277.78	278.286	1243630.0
2020-08-19 11:30:00	QQQ	ETF	278.29	278.88	278.24	278.85	937731.0
2020-08-19 12:00:00	QQQ	ETF	278.86	279.02	278.54	278.61	960850.0
2020-08-19 12:30:00	QQQ	ETF	278.64	278.69	278.31	278.65	666172.0

> showing 50 of 20,175 rows — these rows as CSV

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