PREVIEW / etf_30min / 2020-04-23

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-04-23.parquet
  size:    564 KB
  rows:    20,553

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-04-23 04:00:00	SPY	ETF	278.25	279.1	278.0	279.07	48987.0
2020-04-23 04:30:00	SPY	ETF	279.05	279.14	278.58	278.72	19637.0
2020-04-23 05:00:00	SPY	ETF	278.58	279.56	278.58	279.5	33135.0
2020-04-23 05:30:00	SPY	ETF	279.55	279.97	279.53	279.86	23759.0
2020-04-23 06:00:00	SPY	ETF	279.91	279.92	279.09	279.42	17038.0
2020-04-23 06:30:00	SPY	ETF	279.24	279.24	278.69	278.69	48053.0
2020-04-23 07:00:00	SPY	ETF	278.7	279.48	278.7	279.12	52928.0
2020-04-23 07:30:00	SPY	ETF	279.2	279.41	278.9	279.2	168301.0
2020-04-23 08:00:00	SPY	ETF	279.1801	280.41	278.12	279.57	549557.0
2020-04-23 08:30:00	SPY	ETF	279.69	280.94	279.4	280.84	1241737.0
2020-04-23 09:00:00	SPY	ETF	280.8	280.95	280.42	280.49	437084.0
2020-04-23 09:30:00	SPY	ETF	280.49	282.38	280.15	281.52	9473483.0
2020-04-23 10:00:00	SPY	ETF	281.5	282.61	281.02	282.44	6703883.0
2020-04-23 10:30:00	SPY	ETF	282.44	283.94	282.4	283.2801	6888406.0
2020-04-23 11:00:00	SPY	ETF	283.29	283.4	282.664	283.25	4736537.0
2020-04-23 11:30:00	SPY	ETF	283.27	283.31	281.8	282.29	5572421.0
2020-04-23 12:00:00	SPY	ETF	282.31	283.12	282.08	283.03	3699146.0
2020-04-23 12:30:00	SPY	ETF	283.04	283.115	278.88	281.01	17279309.0
2020-04-23 13:00:00	SPY	ETF	281.03	282.01	279.67	280.3	8686241.0
2020-04-23 13:30:00	SPY	ETF	280.3	281.03	279.06	279.8801	7163912.0
2020-04-23 14:00:00	SPY	ETF	279.88	280.79	278.75	280.59	6485641.0
2020-04-23 14:30:00	SPY	ETF	280.58	281.53	280.2101	281.3304	4011341.0
2020-04-23 15:00:00	SPY	ETF	281.32	281.42	279.25	279.9499	5075375.0
2020-04-23 15:30:00	SPY	ETF	279.94	280.69	279.03	279.06	11385969.0
2020-04-23 16:00:00	SPY	ETF	279.03	279.175	278.19	278.47	2942555.0
2020-04-23 16:30:00	SPY	ETF	278.46	279.08	278.23	278.49	391519.0
2020-04-23 17:00:00	SPY	ETF	278.5	278.58	278.25	278.29	72958.0
2020-04-23 17:30:00	SPY	ETF	278.29	279.08	278.03	278.07	75265.0
2020-04-23 18:00:00	SPY	ETF	278.1	278.46	277.39	277.7	369024.0
2020-04-23 18:30:00	SPY	ETF	277.68	278.08	276.74	277.33	285688.0
2020-04-23 19:00:00	SPY	ETF	277.27	277.49	276.9	277.39	157274.0
2020-04-23 19:30:00	SPY	ETF	277.47	277.56	277.0	277.37	210308.0
2020-04-23 04:00:00	QQQ	ETF	210.12	210.55	209.8	210.45	10767.0
2020-04-23 04:30:00	QQQ	ETF	210.48	210.48	210.3	210.3	5200.0
2020-04-23 05:00:00	QQQ	ETF	210.23	210.89	210.23	210.85	10770.0
2020-04-23 05:30:00	QQQ	ETF	211.13	211.35	210.98	211.35	13440.0
2020-04-23 06:00:00	QQQ	ETF	211.19	211.23	210.66	210.88	18886.0
2020-04-23 06:30:00	QQQ	ETF	210.69	210.69	210.34	210.41	77892.0
2020-04-23 07:00:00	QQQ	ETF	210.5	211.1	210.5	210.97	39266.0
2020-04-23 07:30:00	QQQ	ETF	210.92	211.1	210.75	210.97	100809.0
2020-04-23 08:00:00	QQQ	ETF	210.99	211.29	209.94	211.25	101007.0
2020-04-23 08:30:00	QQQ	ETF	211.34	212.25	211.12	212.18	262099.0
2020-04-23 09:00:00	QQQ	ETF	212.25	212.26	211.79	211.83	151044.0
2020-04-23 09:30:00	QQQ	ETF	211.78	213.41	211.4293	212.9219	5008864.0
2020-04-23 10:00:00	QQQ	ETF	212.91	213.72	212.6	213.64	3196994.0
2020-04-23 10:30:00	QQQ	ETF	213.67	214.435	213.6299	214.01	2674203.0
2020-04-23 11:00:00	QQQ	ETF	214.01	214.04	213.41	213.95	1575485.0
2020-04-23 11:30:00	QQQ	ETF	213.98	213.99	212.77	213.04	2270781.0
2020-04-23 12:00:00	QQQ	ETF	213.035	213.83	212.88	213.81	1301492.0
2020-04-23 12:30:00	QQQ	ETF	213.81	213.89	210.2	212.3999	6454702.0

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

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