PREVIEW / etf_30min / 2018-04-04

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-04-04.parquet
  size:    483 KB
  rows:    16,509

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-04-04 04:00:00	SPY	ETF	257.98	258.12	256.39	257.18	117846.0
2018-04-04 04:30:00	SPY	ETF	257.22	257.33	256.68	257.24	37717.0
2018-04-04 05:00:00	SPY	ETF	257.2	257.2	256.75	257.06	42243.0
2018-04-04 05:30:00	SPY	ETF	257.1	257.23	256.89	257.07	15022.0
2018-04-04 06:00:00	SPY	ETF	257.07	257.07	255.39	255.87	63428.0
2018-04-04 06:30:00	SPY	ETF	255.85	256.95	255.55	256.26	153779.0
2018-04-04 07:00:00	SPY	ETF	256.32	257.06	256.3	256.96	370752.0
2018-04-04 07:30:00	SPY	ETF	256.97	257.24	256.68	256.95	747892.0
2018-04-04 08:00:00	SPY	ETF	256.71	259.3	256.29	256.82	847082.0
2018-04-04 08:30:00	SPY	ETF	256.83	257.59	256.51	257.2	1439206.0
2018-04-04 09:00:00	SPY	ETF	257.29	257.32	256.67	256.72	1382972.0
2018-04-04 09:30:00	SPY	ETF	256.75	258.37	256.6	258.34	13495660.0
2018-04-04 10:00:00	SPY	ETF	258.33	258.96	257.6	258.15	9201463.0
2018-04-04 10:30:00	SPY	ETF	258.18	259.6	257.78	259.5	8467937.0
2018-04-04 11:00:00	SPY	ETF	259.5	260.19	258.78	259.88	7430991.0
2018-04-04 11:30:00	SPY	ETF	259.88	260.48	259.5	260.06	5281076.0
2018-04-04 12:00:00	SPY	ETF	260.0544	261.06	259.76	260.9	6089317.0
2018-04-04 12:30:00	SPY	ETF	260.9	261.41	260.59	260.88	4520370.0
2018-04-04 13:00:00	SPY	ETF	260.89	261.02	259.59	260.08	6946966.0
2018-04-04 13:30:00	SPY	ETF	260.06	260.64	259.8	260.39	3125405.0
2018-04-04 14:00:00	SPY	ETF	260.4	262.32	260.31	262.3	6715493.0
2018-04-04 14:30:00	SPY	ETF	262.3	262.79	261.63	262.67	6237239.0
2018-04-04 15:00:00	SPY	ETF	262.65	263.65	262.45	263.51	8198861.0
2018-04-04 15:30:00	SPY	ETF	263.5	264.355	263.4	263.83	17871178.0
2018-04-04 16:00:00	SPY	ETF	263.79	264.16	263.56	264.01	9243641.0
2018-04-04 16:30:00	SPY	ETF	264.06	264.15	263.79	263.88	2214822.0
2018-04-04 17:00:00	SPY	ETF	263.9	264.05	257.39	264.05	285730.0
2018-04-04 17:30:00	SPY	ETF	264.01	264.03	263.95	263.95	42494.0
2018-04-04 18:00:00	SPY	ETF	263.95	264.09	263.82	263.85	36830.0
2018-04-04 18:30:00	SPY	ETF	263.89	264.45	263.89	264.36	33601.0
2018-04-04 19:00:00	SPY	ETF	264.3	264.46	264.13	264.36	36395.0
2018-04-04 19:30:00	SPY	ETF	264.4	264.62	264.25	264.57	85521.0
2018-04-04 20:00:00	SPY	ETF	263.56	264.57	263.56	264.53	1540.0
2018-04-04 04:00:00	QQQ	ETF	155.13	155.26	153.75	154.45	97393.0
2018-04-04 04:30:00	QQQ	ETF	154.19	154.43	153.91	154.33	98976.0
2018-04-04 05:00:00	QQQ	ETF	154.33	154.34	153.97	154.17	57885.0
2018-04-04 05:30:00	QQQ	ETF	154.17	154.45	154.15	154.4	26843.0
2018-04-04 06:00:00	QQQ	ETF	154.34	154.37	153.37	153.86	41976.0
2018-04-04 06:30:00	QQQ	ETF	153.7	154.08	153.55	153.99	49272.0
2018-04-04 07:00:00	QQQ	ETF	154.0	154.5	154.0	154.47	142221.0
2018-04-04 07:30:00	QQQ	ETF	154.5	154.69	154.18	154.48	325820.0
2018-04-04 08:00:00	QQQ	ETF	154.57	154.8	153.95	154.3	402355.0
2018-04-04 08:30:00	QQQ	ETF	154.27	154.89	154.05	154.81	1068834.0
2018-04-04 09:00:00	QQQ	ETF	154.88	154.9	154.22	154.26	985823.0
2018-04-04 09:30:00	QQQ	ETF	154.27	155.6	154.04	155.415	6866573.0
2018-04-04 10:00:00	QQQ	ETF	155.4	155.86	154.81	155.25	4170261.0
2018-04-04 10:30:00	QQQ	ETF	155.26	156.3	154.73	156.25	3468027.0
2018-04-04 11:00:00	QQQ	ETF	156.24	156.999	155.67	156.7899	3178100.0
2018-04-04 11:30:00	QQQ	ETF	156.77	157.47	156.65	157.16	3753579.0
2018-04-04 12:00:00	QQQ	ETF	157.17	157.98	156.941	157.845	3242398.0

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

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