PREVIEW / etf_30min / 2020-12-14

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-12-14.parquet
  size:    595 KB
  rows:    22,335

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-14 04:00:00	SPY	ETF	368.0	368.21	368.0	368.12	16117.0
2020-12-14 04:30:00	SPY	ETF	368.03	368.44	368.03	368.32	25394.0
2020-12-14 05:00:00	SPY	ETF	368.25	368.4	368.25	368.25	4022.0
2020-12-14 05:30:00	SPY	ETF	368.2	368.55	368.2	368.53	66177.0
2020-12-14 06:00:00	SPY	ETF	368.39	368.73	368.39	368.73	10739.0
2020-12-14 06:30:00	SPY	ETF	368.86	369.03	368.82	369.03	36366.0
2020-12-14 07:00:00	SPY	ETF	368.96	369.04	368.8	368.9	39051.0
2020-12-14 07:30:00	SPY	ETF	368.96	369.19	368.94	369.16	55611.0
2020-12-14 08:00:00	SPY	ETF	368.85	369.21	368.01	368.79	200696.0
2020-12-14 08:30:00	SPY	ETF	368.81	368.81	368.52	368.76	79205.0
2020-12-14 09:00:00	SPY	ETF	368.77	368.84	368.56	368.62	106724.0
2020-12-14 09:30:00	SPY	ETF	368.64	369.6	368.37	369.52	5632224.0
2020-12-14 10:00:00	SPY	ETF	369.52	369.8	369.32	369.67	3749518.0
2020-12-14 10:30:00	SPY	ETF	369.67	369.8	368.02	368.03	5410019.0
2020-12-14 11:00:00	SPY	ETF	368.04	368.5	367.57	367.77	3649079.0
2020-12-14 11:30:00	SPY	ETF	367.78	368.0	367.12	367.7619	3285699.0
2020-12-14 12:00:00	SPY	ETF	367.79	367.88	367.16	367.48	2239340.0
2020-12-14 12:30:00	SPY	ETF	367.48	367.5034	366.61	366.86	1845048.0
2020-12-14 13:00:00	SPY	ETF	366.88	367.1999	366.3	366.615	2829844.0
2020-12-14 13:30:00	SPY	ETF	366.62	367.16	366.45	366.84	2532604.0
2020-12-14 14:00:00	SPY	ETF	366.87	367.05	366.32	366.525	1689616.0
2020-12-14 14:30:00	SPY	ETF	366.525	366.8	365.68	366.6462	3730078.0
2020-12-14 15:00:00	SPY	ETF	366.63	366.7	366.16	366.255	3422781.0
2020-12-14 15:30:00	SPY	ETF	366.25	366.27	364.47	364.61	14529221.0
2020-12-14 16:00:00	SPY	ETF	364.58	365.21	364.58	365.02	11205332.0
2020-12-14 16:30:00	SPY	ETF	365.03	365.17	364.9	365.14	299898.0
2020-12-14 17:00:00	SPY	ETF	365.29	365.29	364.95	365.09	57517.0
2020-12-14 17:30:00	SPY	ETF	365.09	365.12	364.9	365.07	408783.0
2020-12-14 18:00:00	SPY	ETF	365.08	365.5	364.91	365.4	133309.0
2020-12-14 18:30:00	SPY	ETF	365.44	365.64	365.1	365.37	47986.0
2020-12-14 19:00:00	SPY	ETF	365.45	365.56	365.21	365.4	21526.0
2020-12-14 19:30:00	SPY	ETF	365.4	365.65	365.35	365.61	57818.0
2020-12-14 04:00:00	QQQ	ETF	302.85	302.88	302.71	302.82	21141.0
2020-12-14 04:30:00	QQQ	ETF	302.79	302.99	302.69	302.98	17690.0
2020-12-14 05:00:00	QQQ	ETF	302.94	302.98	302.83	302.85	4145.0
2020-12-14 05:30:00	QQQ	ETF	302.83	303.12	302.83	303.01	10127.0
2020-12-14 06:00:00	QQQ	ETF	302.98	303.15	302.98	303.13	4670.0
2020-12-14 06:30:00	QQQ	ETF	303.14	303.77	303.14	303.62	18972.0
2020-12-14 07:00:00	QQQ	ETF	303.59	303.65	303.51	303.59	39205.0
2020-12-14 07:30:00	QQQ	ETF	303.58	303.78	303.52	303.77	56361.0
2020-12-14 08:00:00	QQQ	ETF	303.63	303.8	301.85	302.96	472188.0
2020-12-14 08:30:00	QQQ	ETF	302.93	303.21	302.71	303.15	100036.0
2020-12-14 09:00:00	QQQ	ETF	303.14	303.33	303.04	303.07	137481.0
2020-12-14 09:30:00	QQQ	ETF	303.06	305.4	303.01	305.39	3560454.0
2020-12-14 10:00:00	QQQ	ETF	305.4	305.96	305.01	305.77	1947539.0
2020-12-14 10:30:00	QQQ	ETF	305.76	305.9	304.99	305.0	1384179.0
2020-12-14 11:00:00	QQQ	ETF	304.99	306.05	304.825	305.5416	1815530.0
2020-12-14 11:30:00	QQQ	ETF	305.56	305.79	305.03	305.755	1186975.0
2020-12-14 12:00:00	QQQ	ETF	305.79	305.846	305.23	305.3419	800063.0
2020-12-14 12:30:00	QQQ	ETF	305.35	305.41	304.54	304.83	896153.0

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

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