PREVIEW / etf_30min / 2020-05-28

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-05-28.parquet
  size:    559 KB
  rows:    20,844

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-05-28 04:00:00	SPY	ETF	304.8	305.05	304.0	304.12	57880.0
2020-05-28 04:30:00	SPY	ETF	304.12	304.35	303.85	303.96	42775.0
2020-05-28 05:00:00	SPY	ETF	304.05	304.81	304.05	304.47	16186.0
2020-05-28 05:30:00	SPY	ETF	304.46	304.5	303.15	303.53	29535.0
2020-05-28 06:00:00	SPY	ETF	303.49	303.93	303.39	303.9	126112.0
2020-05-28 06:30:00	SPY	ETF	303.94	304.38	303.63	304.15	117151.0
2020-05-28 07:00:00	SPY	ETF	304.26	304.59	303.81	304.52	212200.0
2020-05-28 07:30:00	SPY	ETF	304.57	304.88	304.37	304.42	173551.0
2020-05-28 08:00:00	SPY	ETF	304.37	305.31	303.35	304.0	370682.0
2020-05-28 08:30:00	SPY	ETF	304.1	304.89	303.81	304.69	519207.0
2020-05-28 09:00:00	SPY	ETF	304.69	305.2	304.62	304.69	669512.0
2020-05-28 09:30:00	SPY	ETF	304.65	304.87	303.32	304.16	8829095.0
2020-05-28 10:00:00	SPY	ETF	304.15	304.925	303.67	304.45	4981950.0
2020-05-28 10:30:00	SPY	ETF	304.46	305.19	304.14	305.09	5020845.0
2020-05-28 11:00:00	SPY	ETF	305.095	305.37	304.5	305.2743	4599142.0
2020-05-28 11:30:00	SPY	ETF	305.27	305.58	304.57	305.5533	5009916.0
2020-05-28 12:00:00	SPY	ETF	305.56	305.77	305.22	305.44	3407200.0
2020-05-28 12:30:00	SPY	ETF	305.44	306.43	305.33	306.25	4868415.0
2020-05-28 13:00:00	SPY	ETF	306.2556	306.69	306.25	306.63	2729871.0
2020-05-28 13:30:00	SPY	ETF	306.64	306.84	306.24	306.4643	5295477.0
2020-05-28 14:00:00	SPY	ETF	306.465	306.65	305.86	306.0	3281303.0
2020-05-28 14:30:00	SPY	ETF	306.0	306.3	305.46	305.97	4104281.0
2020-05-28 15:00:00	SPY	ETF	305.97	306.455	304.36	304.43	7141819.0
2020-05-28 15:30:00	SPY	ETF	304.43	304.72	302.24	302.96	21187398.0
2020-05-28 16:00:00	SPY	ETF	302.96	304.17	302.9066	303.95	5286635.0
2020-05-28 16:30:00	SPY	ETF	303.97	304.24	303.77	304.04	646382.0
2020-05-28 17:00:00	SPY	ETF	304.05	304.15	302.97	303.97	185888.0
2020-05-28 17:30:00	SPY	ETF	303.97	304.03	302.97	303.8	70605.0
2020-05-28 18:00:00	SPY	ETF	303.8	304.11	303.3	303.95	239604.0
2020-05-28 18:30:00	SPY	ETF	303.95	304.07	303.56	303.57	49573.0
2020-05-28 19:00:00	SPY	ETF	303.67	303.95	303.2	303.4	55738.0
2020-05-28 19:30:00	SPY	ETF	303.36	303.5	302.77	302.86	186723.0
2020-05-28 04:00:00	QQQ	ETF	229.91	230.2	229.53	229.53	26709.0
2020-05-28 04:30:00	QQQ	ETF	229.53	229.78	229.31	229.51	9233.0
2020-05-28 05:00:00	QQQ	ETF	229.52	230.03	229.52	229.9	13020.0
2020-05-28 05:30:00	QQQ	ETF	229.86	229.86	228.63	228.92	17401.0
2020-05-28 06:00:00	QQQ	ETF	229.1	229.2	228.75	229.14	20794.0
2020-05-28 06:30:00	QQQ	ETF	229.25	229.76	228.97	229.48	154327.0
2020-05-28 07:00:00	QQQ	ETF	229.63	229.68	229.01	229.44	122180.0
2020-05-28 07:30:00	QQQ	ETF	229.48	229.64	228.99	229.02	63332.0
2020-05-28 08:00:00	QQQ	ETF	229.41	230.37	227.99	227.99	392791.0
2020-05-28 08:30:00	QQQ	ETF	228.15	228.65	227.55	228.08	417419.0
2020-05-28 09:00:00	QQQ	ETF	228.07	229.14	227.98	229.06	241737.0
2020-05-28 09:30:00	QQQ	ETF	229.02	230.96	229.02	230.12	5707237.0
2020-05-28 10:00:00	QQQ	ETF	230.19	231.32	229.68	231.2009	2948281.0
2020-05-28 10:30:00	QQQ	ETF	231.21	231.83	230.87	231.67	2207098.0
2020-05-28 11:00:00	QQQ	ETF	231.67	231.98	230.99	231.57	2024834.0
2020-05-28 11:30:00	QQQ	ETF	231.58	232.29	230.94	232.26	1561186.0
2020-05-28 12:00:00	QQQ	ETF	232.269	232.51	232.07	232.27	1319729.0
2020-05-28 12:30:00	QQQ	ETF	232.27	233.15	232.17	232.913	1642061.0

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

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