PREVIEW / etf_30min / 2020-12-01

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-12-01.parquet
  size:    602 KB
  rows:    22,566

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-12-01 04:00:00	SPY	ETF	365.25	366.16	365.25	366.11	81473.0
2020-12-01 04:30:00	SPY	ETF	366.12	366.14	365.64	365.7	35738.0
2020-12-01 05:00:00	SPY	ETF	365.73	365.97	365.6	365.9	18170.0
2020-12-01 05:30:00	SPY	ETF	365.9	366.17	365.64	366.15	9436.0
2020-12-01 06:00:00	SPY	ETF	366.17	366.27	366.09	366.13	23936.0
2020-12-01 06:30:00	SPY	ETF	366.17	366.27	366.01	366.04	13669.0
2020-12-01 07:00:00	SPY	ETF	366.01	366.05	365.73	365.77	147264.0
2020-12-01 07:30:00	SPY	ETF	365.75	366.02	365.73	366.01	133993.0
2020-12-01 08:00:00	SPY	ETF	366.0	366.08	364.9	365.51	350768.0
2020-12-01 08:30:00	SPY	ETF	365.5	365.84	365.34	365.84	245949.0
2020-12-01 09:00:00	SPY	ETF	365.85	365.85	365.45	365.58	293079.0
2020-12-01 09:30:00	SPY	ETF	365.57	366.39	364.93	366.17	6890603.0
2020-12-01 10:00:00	SPY	ETF	366.165	367.44	365.96	366.9756	6265899.0
2020-12-01 10:30:00	SPY	ETF	366.98	367.09	365.84	366.29	5527647.0
2020-12-01 11:00:00	SPY	ETF	366.31	367.05	366.3	366.65	4046535.0
2020-12-01 11:30:00	SPY	ETF	366.64	366.98	366.04	366.2699	6789816.0
2020-12-01 12:00:00	SPY	ETF	366.25	366.805	366.15	366.6562	4120415.0
2020-12-01 12:30:00	SPY	ETF	366.66	366.91	366.23	366.4	1960946.0
2020-12-01 13:00:00	SPY	ETF	366.41	367.02	366.405	366.97	1685460.0
2020-12-01 13:30:00	SPY	ETF	366.98	367.23	366.87	367.115	1993888.0
2020-12-01 14:00:00	SPY	ETF	367.12	367.68	367.03	367.245	2675430.0
2020-12-01 14:30:00	SPY	ETF	367.25	367.6	366.67	366.775	3310108.0
2020-12-01 15:00:00	SPY	ETF	366.77	366.8116	365.46	366.2001	7039089.0
2020-12-01 15:30:00	SPY	ETF	366.21	366.44	365.57	365.97	10549905.0
2020-12-01 16:00:00	SPY	ETF	365.99	366.07	365.56	365.86	5926963.0
2020-12-01 16:30:00	SPY	ETF	365.9	366.12	361.936	365.83	605436.0
2020-12-01 17:00:00	SPY	ETF	365.98	366.06	365.82	366.05	398200.0
2020-12-01 17:30:00	SPY	ETF	366.0199	366.07	365.95	365.98	32682.0
2020-12-01 18:00:00	SPY	ETF	365.98	366.46	365.37	365.4	226046.0
2020-12-01 18:30:00	SPY	ETF	365.45	365.81	365.15	365.74	120326.0
2020-12-01 19:00:00	SPY	ETF	365.65	365.65	365.14	365.29	63089.0
2020-12-01 19:30:00	SPY	ETF	365.27	365.45	365.17	365.22	23977.0
2020-12-01 04:00:00	QQQ	ETF	301.55	301.88	301.48	301.84	44447.0
2020-12-01 04:30:00	QQQ	ETF	301.87	301.87	301.47	301.63	24373.0
2020-12-01 05:00:00	QQQ	ETF	301.6	301.78	301.44	301.76	11041.0
2020-12-01 05:30:00	QQQ	ETF	301.82	302.22	301.64	302.2	28507.0
2020-12-01 06:00:00	QQQ	ETF	302.09	302.36	302.09	302.11	14423.0
2020-12-01 06:30:00	QQQ	ETF	302.12	302.23	301.99	302.07	38731.0
2020-12-01 07:00:00	QQQ	ETF	302.04	302.23	301.99	302.11	61473.0
2020-12-01 07:30:00	QQQ	ETF	302.1	302.34	301.99	302.28	43968.0
2020-12-01 08:00:00	QQQ	ETF	302.05	302.37	299.62	301.97	79800.0
2020-12-01 08:30:00	QQQ	ETF	301.96	301.96	301.51	301.92	110387.0
2020-12-01 09:00:00	QQQ	ETF	301.95	302.1	301.7	301.89	291754.0
2020-12-01 09:30:00	QQQ	ETF	301.87	302.3	300.83	302.23	3048693.0
2020-12-01 10:00:00	QQQ	ETF	302.23	303.21	302.05	302.5399	2146143.0
2020-12-01 10:30:00	QQQ	ETF	302.55	302.62	301.22	302.3	1965249.0
2020-12-01 11:00:00	QQQ	ETF	302.35	303.3	302.31	303.16	1407241.0
2020-12-01 11:30:00	QQQ	ETF	303.16	303.68	302.67	303.591	1698388.0
2020-12-01 12:00:00	QQQ	ETF	303.6	304.51	303.51	304.29	1441506.0
2020-12-01 12:30:00	QQQ	ETF	304.29	304.56	303.77	303.8578	1256475.0

> showing 50 of 22,566 rows — these rows as CSV

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