PREVIEW / etf_30min / 2020-12-21

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-12-21.parquet
  size:    629 KB
  rows:    24,043

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-21 04:00:00	SPY	ETF	369.18	369.18	367.54	367.6	53399.0
2020-12-21 04:30:00	SPY	ETF	367.56	368.0	365.38	365.7	47308.0
2020-12-21 05:00:00	SPY	ETF	365.45	365.45	361.85	361.89	216303.0
2020-12-21 05:30:00	SPY	ETF	361.79	362.74	358.0	360.1	419799.0
2020-12-21 06:00:00	SPY	ETF	360.0	362.44	359.9	361.99	294940.0
2020-12-21 06:30:00	SPY	ETF	362.05	363.98	361.89	363.1	251384.0
2020-12-21 07:00:00	SPY	ETF	363.31	364.47	362.5	363.27	694823.0
2020-12-21 07:30:00	SPY	ETF	363.26	364.06	362.8	363.63	352330.0
2020-12-21 08:00:00	SPY	ETF	363.63	370.15	361.35	363.38	715361.0
2020-12-21 08:30:00	SPY	ETF	363.35	364.35	363.1	364.2	705675.0
2020-12-21 09:00:00	SPY	ETF	364.25	365.05	363.85	364.97	602556.0
2020-12-21 09:30:00	SPY	ETF	364.97	366.47	364.55	364.86	8647196.0
2020-12-21 10:00:00	SPY	ETF	364.86	365.0	362.03	362.83	10532585.0
2020-12-21 10:30:00	SPY	ETF	362.82	363.68	362.26	363.4	6204122.0
2020-12-21 11:00:00	SPY	ETF	363.385	364.83	363.28	364.605	5569965.0
2020-12-21 11:30:00	SPY	ETF	364.6	365.67	364.6	365.32	2904819.0
2020-12-21 12:00:00	SPY	ETF	365.32	366.61	365.32	366.6	2755754.0
2020-12-21 12:30:00	SPY	ETF	366.595	367.5	366.54	367.29	3799239.0
2020-12-21 13:00:00	SPY	ETF	367.31	378.46	367.129	367.67	5881411.0
2020-12-21 13:30:00	SPY	ETF	367.68	368.45	367.64	368.07	3253048.0
2020-12-21 14:00:00	SPY	ETF	368.08	368.46	367.63	368.355	4283888.0
2020-12-21 14:30:00	SPY	ETF	368.35	368.805	367.95	368.0399	3076638.0
2020-12-21 15:00:00	SPY	ETF	368.04	368.27	367.37	367.73	4074053.0
2020-12-21 15:30:00	SPY	ETF	367.72	368.16	366.6	367.93	12847890.0
2020-12-21 16:00:00	SPY	ETF	367.93	368.03	367.25	367.65	11366111.0
2020-12-21 16:30:00	SPY	ETF	367.65	367.9698	367.4	367.8	2884552.0
2020-12-21 17:00:00	SPY	ETF	367.63	367.89	367.61	367.89	45666.0
2020-12-21 17:30:00	SPY	ETF	367.82	367.98	367.71	367.9	831193.0
2020-12-21 18:00:00	SPY	ETF	367.9	368.22	367.77	367.92	96083.0
2020-12-21 18:30:00	SPY	ETF	367.81	367.81	367.51	367.65	92649.0
2020-12-21 19:00:00	SPY	ETF	367.85	368.02	367.51	367.57	89096.0
2020-12-21 19:30:00	SPY	ETF	367.6	367.71	366.97	367.12	106840.0
2020-12-21 04:00:00	QQQ	ETF	310.06	310.06	309.25	309.33	20839.0
2020-12-21 04:30:00	QQQ	ETF	309.22	309.25	307.89	308.12	21301.0
2020-12-21 05:00:00	QQQ	ETF	307.88	307.88	304.9	305.05	62960.0
2020-12-21 05:30:00	QQQ	ETF	305.1	305.53	303.68	304.67	72743.0
2020-12-21 06:00:00	QQQ	ETF	304.58	306.0	304.51	305.35	92603.0
2020-12-21 06:30:00	QQQ	ETF	305.56	306.36	305.3	306.11	64758.0
2020-12-21 07:00:00	QQQ	ETF	306.07	306.76	305.75	306.28	197575.0
2020-12-21 07:30:00	QQQ	ETF	306.2	306.81	306.05	306.41	294137.0
2020-12-21 08:00:00	QQQ	ETF	306.42	310.96	305.3504	306.1899	196899.0
2020-12-21 08:30:00	QQQ	ETF	306.11	306.64	306.1	306.46	99749.0
2020-12-21 09:00:00	QQQ	ETF	306.56	306.77	306.17	306.57	106918.0
2020-12-21 09:30:00	QQQ	ETF	306.49	308.14	306.07	306.4928	4058636.0
2020-12-21 10:00:00	QQQ	ETF	306.43	306.78	304.03	304.68	2718201.0
2020-12-21 10:30:00	QQQ	ETF	304.67	304.85	303.6	304.39	2676827.0
2020-12-21 11:00:00	QQQ	ETF	304.41	305.6799	304.32	305.63	1905266.0
2020-12-21 11:30:00	QQQ	ETF	305.63	306.95	305.62	306.5432	1469959.0
2020-12-21 12:00:00	QQQ	ETF	306.54	307.61	306.54	307.58	783692.0
2020-12-21 12:30:00	QQQ	ETF	307.575	308.37	307.57	308.17	1278830.0

> showing 50 of 24,043 rows — these rows as CSV

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