PREVIEW / etf_30min / 2020-09-16

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-09-16.parquet
  size:    554 KB
  rows:    20,329

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-09-16 04:00:00	SPY	ETF	341.36	342.21	341.25	342.15	12586.0
2020-09-16 04:30:00	SPY	ETF	342.09	342.16	342.04	342.06	2793.0
2020-09-16 05:00:00	SPY	ETF	342.16	342.42	342.0	342.42	7088.0
2020-09-16 05:30:00	SPY	ETF	342.33	342.48	342.26	342.48	6770.0
2020-09-16 06:00:00	SPY	ETF	342.4	342.41	342.05	342.05	9638.0
2020-09-16 06:30:00	SPY	ETF	342.0	342.92	341.97	342.73	49230.0
2020-09-16 07:00:00	SPY	ETF	342.68	342.76	341.96	341.96	112895.0
2020-09-16 07:30:00	SPY	ETF	341.89	342.38	341.89	342.36	128605.0
2020-09-16 08:00:00	SPY	ETF	342.4999	342.81	341.05	342.46	176663.0
2020-09-16 08:30:00	SPY	ETF	342.43	342.43	341.73	342.07	255286.0
2020-09-16 09:00:00	SPY	ETF	342.06	342.1	341.52	341.52	112176.0
2020-09-16 09:30:00	SPY	ETF	341.51	341.72	340.7202	341.419	3854997.0
2020-09-16 10:00:00	SPY	ETF	341.41	341.785	340.9	341.1	3085126.0
2020-09-16 10:30:00	SPY	ETF	341.1	341.25	340.31	341.056	3176341.0
2020-09-16 11:00:00	SPY	ETF	341.06	342.36	341.01	342.18	4322886.0
2020-09-16 11:30:00	SPY	ETF	342.19	342.3	341.67	341.67	4565553.0
2020-09-16 12:00:00	SPY	ETF	341.68	341.95	341.33	341.57	5116496.0
2020-09-16 12:30:00	SPY	ETF	341.575	341.575	341.01	341.195	3445313.0
2020-09-16 13:00:00	SPY	ETF	341.2	341.405	340.62	340.75	2151573.0
2020-09-16 13:30:00	SPY	ETF	340.749	341.39	340.41	341.15	2241924.0
2020-09-16 14:00:00	SPY	ETF	341.14	342.6672	340.85	342.34	6949186.0
2020-09-16 14:30:00	SPY	ETF	342.34	343.06	341.12	341.5589	8837472.0
2020-09-16 15:00:00	SPY	ETF	341.555	341.9278	339.26	339.62	9416148.0
2020-09-16 15:30:00	SPY	ETF	339.62	340.6	338.52	338.81	14468687.0
2020-09-16 16:00:00	SPY	ETF	338.8	339.35	338.55	338.99	7909091.0
2020-09-16 16:30:00	SPY	ETF	339.0	339.47	338.8	339.24	544510.0
2020-09-16 17:00:00	SPY	ETF	339.25	339.45	338.82	339.41	188621.0
2020-09-16 17:30:00	SPY	ETF	339.36	339.38	339.05	339.2	52582.0
2020-09-16 18:00:00	SPY	ETF	339.2	339.73	338.91	339.64	84139.0
2020-09-16 18:30:00	SPY	ETF	339.6	339.72	339.41	339.42	27991.0
2020-09-16 19:00:00	SPY	ETF	339.48	339.62	339.41	339.44	19760.0
2020-09-16 19:30:00	SPY	ETF	339.42	339.45	339.06	339.22	51771.0
2020-09-16 04:00:00	QQQ	ETF	280.54	281.59	280.43	281.44	37962.0
2020-09-16 04:30:00	QQQ	ETF	281.4	281.54	281.31	281.43	7012.0
2020-09-16 05:00:00	QQQ	ETF	281.55	281.61	281.09	281.37	17726.0
2020-09-16 05:30:00	QQQ	ETF	281.32	281.39	281.0	281.06	37452.0
2020-09-16 06:00:00	QQQ	ETF	281.06	281.06	280.76	280.85	22777.0
2020-09-16 06:30:00	QQQ	ETF	280.84	281.72	280.79	281.54	22124.0
2020-09-16 07:00:00	QQQ	ETF	281.46	281.46	280.07	280.07	171193.0
2020-09-16 07:30:00	QQQ	ETF	280.09	280.63	279.84	280.63	143568.0
2020-09-16 08:00:00	QQQ	ETF	280.6	281.7296	279.21	280.55	160250.0
2020-09-16 08:30:00	QQQ	ETF	280.54	280.56	280.02	280.29	119976.0
2020-09-16 09:00:00	QQQ	ETF	280.2	280.23	279.51	279.76	229594.0
2020-09-16 09:30:00	QQQ	ETF	279.76	280.36	278.38	279.59	3076933.0
2020-09-16 10:00:00	QQQ	ETF	279.57	279.79	278.13	278.8	2092425.0
2020-09-16 10:30:00	QQQ	ETF	278.77	278.9	276.9101	277.775	2799169.0
2020-09-16 11:00:00	QQQ	ETF	277.785	279.15	277.71	278.845	2033533.0
2020-09-16 11:30:00	QQQ	ETF	278.86	279.27	278.07	278.08	1366349.0
2020-09-16 12:00:00	QQQ	ETF	278.09	278.589	277.47	277.88	1499300.0
2020-09-16 12:30:00	QQQ	ETF	277.89	277.9	277.05	277.46	1210804.0

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

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