PREVIEW / etf_30min / 2018-09-21

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-09-21.parquet
  size:    471 KB
  rows:    16,356

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
2018-09-21 04:00:00	SPY	ETF	293.1	293.13	292.96	293.03	10480.0
2018-09-21 04:30:00	SPY	ETF	293.0	293.02	292.85	292.85	55969.0
2018-09-21 05:00:00	SPY	ETF	292.85	292.92	292.75	292.75	5550.0
2018-09-21 05:30:00	SPY	ETF	292.77	292.8	292.65	292.7	7205.0
2018-09-21 06:00:00	SPY	ETF	292.72	292.74	292.64	292.68	32565.0
2018-09-21 06:30:00	SPY	ETF	292.65	292.7	292.55	292.56	61477.0
2018-09-21 07:00:00	SPY	ETF	292.56	292.56	292.3	292.39	87218.0
2018-09-21 07:30:00	SPY	ETF	292.4	292.55	292.4	292.55	64183.0
2018-09-21 08:00:00	SPY	ETF	292.48	293.0	292.35	292.45	131287.0
2018-09-21 08:30:00	SPY	ETF	292.49	292.95	292.49	292.84	529475.0
2018-09-21 09:00:00	SPY	ETF	292.84	293.29	292.64	293.11	1148513.0
2018-09-21 09:30:00	SPY	ETF	293.09	293.22	292.8299	292.89	8900566.0
2018-09-21 10:00:00	SPY	ETF	292.8901	293.06	292.53	292.59	4555548.0
2018-09-21 10:30:00	SPY	ETF	292.59	292.745	292.45	292.55	23077376.0
2018-09-21 11:00:00	SPY	ETF	292.55	292.74	292.4	292.73	8062599.0
2018-09-21 11:30:00	SPY	ETF	292.73	292.9	292.61	292.84	2003277.0
2018-09-21 12:00:00	SPY	ETF	292.84	292.97	292.67	292.7	2668595.0
2018-09-21 12:30:00	SPY	ETF	292.69	292.74	292.46	292.605	2372722.0
2018-09-21 13:00:00	SPY	ETF	292.62	292.669	292.48	292.53	1455409.0
2018-09-21 13:30:00	SPY	ETF	292.53	292.58	292.32	292.57	2231346.0
2018-09-21 14:00:00	SPY	ETF	292.575	292.58	292.23	292.445	2289866.0
2018-09-21 14:30:00	SPY	ETF	292.45	292.52	292.15	292.19	4965747.0
2018-09-21 15:00:00	SPY	ETF	292.2	292.5917	292.16	292.195	7673732.0
2018-09-21 15:30:00	SPY	ETF	292.2	292.27	291.81	292.01	15099494.0
2018-09-21 16:00:00	SPY	ETF	292.02	292.3813	291.9	292.02	14352087.0
2018-09-21 16:30:00	SPY	ETF	292.03	292.08	291.81	291.82	2086577.0
2018-09-21 17:00:00	SPY	ETF	291.89	291.95	291.53	291.72	251545.0
2018-09-21 17:30:00	SPY	ETF	291.74	291.74	291.52	291.55	67607.0
2018-09-21 18:00:00	SPY	ETF	291.61	291.69	291.51	291.64	14700.0
2018-09-21 18:30:00	SPY	ETF	291.6	291.7	291.54	291.7	7583.0
2018-09-21 19:00:00	SPY	ETF	291.6	291.68	291.52	291.6	3900.0
2018-09-21 19:30:00	SPY	ETF	291.61	291.69	291.6	291.69	1990.0
2018-09-21 04:00:00	QQQ	ETF	185.23	185.56	185.23	185.45	9309.0
2018-09-21 04:30:00	QQQ	ETF	185.31	185.35	185.25	185.25	7600.0
2018-09-21 05:00:00	QQQ	ETF	185.26	185.26	185.08	185.08	2108.0
2018-09-21 05:30:00	QQQ	ETF	185.09	185.09	185.07	185.07	800.0
2018-09-21 06:00:00	QQQ	ETF	185.03	185.05	184.97	185.02	1970.0
2018-09-21 06:30:00	QQQ	ETF	185.0	185.02	184.91	184.91	4620.0
2018-09-21 07:00:00	QQQ	ETF	184.88	184.88	184.72	184.77	31878.0
2018-09-21 07:30:00	QQQ	ETF	184.77	184.89	184.75	184.89	18200.0
2018-09-21 08:00:00	QQQ	ETF	184.8	185.37	184.78	184.91	29992.0
2018-09-21 08:30:00	QQQ	ETF	184.93	185.24	184.93	185.17	84651.0
2018-09-21 09:00:00	QQQ	ETF	185.11	185.49	185.07	185.28	366021.0
2018-09-21 09:30:00	QQQ	ETF	185.27	185.48	184.0	184.945	3865368.0
2018-09-21 10:00:00	QQQ	ETF	184.94	185.09	184.32	184.33	2835174.0
2018-09-21 10:30:00	QQQ	ETF	184.34	184.48	184.19	184.33	1995796.0
2018-09-21 11:00:00	QQQ	ETF	184.32	184.71	184.06	184.7	1742839.0
2018-09-21 11:30:00	QQQ	ETF	184.71	184.78	184.51	184.68	1181738.0
2018-09-21 12:00:00	QQQ	ETF	184.68	184.89	184.56	184.5799	1402647.0
2018-09-21 12:30:00	QQQ	ETF	184.59	184.62	184.37	184.5	872642.0

> showing 50 of 16,356 rows — these rows as CSV

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