PREVIEW / etf_30min / 2020-11-24

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-11-24.parquet
  size:    609 KB
  rows:    22,933

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-11-24 04:00:00	SPY	ETF	359.86	360.28	359.82	359.92	18111.0
2020-11-24 04:30:00	SPY	ETF	359.95	360.34	359.95	360.34	12597.0
2020-11-24 05:00:00	SPY	ETF	360.16	360.44	360.07	360.24	12861.0
2020-11-24 05:30:00	SPY	ETF	360.32	360.39	360.17	360.39	5280.0
2020-11-24 06:00:00	SPY	ETF	360.4	360.7	360.39	360.47	20616.0
2020-11-24 06:30:00	SPY	ETF	360.4	360.48	360.21	360.21	10733.0
2020-11-24 07:00:00	SPY	ETF	360.09	360.29	359.59	359.69	197683.0
2020-11-24 07:30:00	SPY	ETF	359.69	360.3	359.69	360.29	75456.0
2020-11-24 08:00:00	SPY	ETF	360.3	360.69	359.64	360.36	100898.0
2020-11-24 08:30:00	SPY	ETF	360.37	360.58	360.26	360.28	73678.0
2020-11-24 09:00:00	SPY	ETF	360.282	360.34	360.09	360.25	167012.0
2020-11-24 09:30:00	SPY	ETF	360.21	360.39	359.29	360.32	5118140.0
2020-11-24 10:00:00	SPY	ETF	360.3311	361.02	360.15	360.78	4521779.0
2020-11-24 10:30:00	SPY	ETF	360.77	361.77	360.47	361.51	5898613.0
2020-11-24 11:00:00	SPY	ETF	361.51	362.46	361.5	362.415	3803231.0
2020-11-24 11:30:00	SPY	ETF	362.42	363.49	362.18	362.97	4251771.0
2020-11-24 12:00:00	SPY	ETF	362.97	363.12	362.6	362.74	1890729.0
2020-11-24 12:30:00	SPY	ETF	362.74	363.17	362.7	362.9801	1859156.0
2020-11-24 13:00:00	SPY	ETF	362.99	363.39	362.61	362.78	2501750.0
2020-11-24 13:30:00	SPY	ETF	362.775	363.81	362.775	363.08	3435569.0
2020-11-24 14:00:00	SPY	ETF	363.08	363.4	362.55	362.575	3417658.0
2020-11-24 14:30:00	SPY	ETF	362.58	363.19	362.32	363.07	3024923.0
2020-11-24 15:00:00	SPY	ETF	363.07	363.45	362.59	363.255	4454395.0
2020-11-24 15:30:00	SPY	ETF	363.255	363.445	362.77	363.19	11039239.0
2020-11-24 16:00:00	SPY	ETF	363.17	363.58	363.1	363.26	4036958.0
2020-11-24 16:30:00	SPY	ETF	363.26	363.94	363.21	363.79	726895.0
2020-11-24 17:00:00	SPY	ETF	363.75	363.79	363.59	363.7	20463.0
2020-11-24 17:30:00	SPY	ETF	363.74	363.77	363.5	363.5	29004.0
2020-11-24 18:00:00	SPY	ETF	363.59	364.07	363.41	363.78	197016.0
2020-11-24 18:30:00	SPY	ETF	363.78	364.23	363.72	364.11	40485.0
2020-11-24 19:00:00	SPY	ETF	364.1	365.31	363.86	364.76	171749.0
2020-11-24 19:30:00	SPY	ETF	364.75	365.0	364.64	364.78	68695.0
2020-11-24 04:00:00	QQQ	ETF	291.18	291.43	291.09	291.18	12765.0
2020-11-24 04:30:00	QQQ	ETF	291.2	291.54	291.2	291.49	9612.0
2020-11-24 05:00:00	QQQ	ETF	291.54	291.54	291.3	291.35	10749.0
2020-11-24 05:30:00	QQQ	ETF	291.37	291.42	291.17	291.28	15781.0
2020-11-24 06:00:00	QQQ	ETF	291.21	291.5	291.17	291.43	26216.0
2020-11-24 06:30:00	QQQ	ETF	291.39	291.59	291.3	291.36	37985.0
2020-11-24 07:00:00	QQQ	ETF	291.3	291.43	290.92	291.01	92451.0
2020-11-24 07:30:00	QQQ	ETF	291.02	291.24	290.97	291.24	51245.0
2020-11-24 08:00:00	QQQ	ETF	291.3901	292.14	290.95	291.43	101509.0
2020-11-24 08:30:00	QQQ	ETF	291.46	291.74	291.41	291.58	40909.0
2020-11-24 09:00:00	QQQ	ETF	291.598	291.77	291.45	291.58	68763.0
2020-11-24 09:30:00	QQQ	ETF	291.5	291.64	289.63	290.8617	2681185.0
2020-11-24 10:00:00	QQQ	ETF	290.8694	291.18	290.34	290.59	1716999.0
2020-11-24 10:30:00	QQQ	ETF	290.555	292.41	290.47	292.4	1589558.0
2020-11-24 11:00:00	QQQ	ETF	292.41	293.34	292.39	293.098	1759657.0
2020-11-24 11:30:00	QQQ	ETF	293.09	293.58	292.77	293.13	1568740.0
2020-11-24 12:00:00	QQQ	ETF	293.14	293.4	292.855	293.36	728291.0
2020-11-24 12:30:00	QQQ	ETF	293.39	294.05	293.31	293.79	972881.0

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

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