PREVIEW / etf_30min / 2017-05-30

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-05-30.parquet
  size:    414 KB
  rows:    14,493

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
2017-05-30 04:00:00	SPY	ETF	241.53	241.57	241.5	241.5	2420.0
2017-05-30 04:30:00	SPY	ETF	241.56	241.66	241.56	241.66	500.0
2017-05-30 05:00:00	SPY	ETF	241.6	241.66	241.56	241.56	5260.0
2017-05-30 05:30:00	SPY	ETF	241.56	241.56	241.45	241.45	800.0
2017-05-30 06:00:00	SPY	ETF	241.51	241.51	241.45	241.48	31225.0
2017-05-30 06:30:00	SPY	ETF	241.46	241.49	241.39	241.39	80582.0
2017-05-30 07:00:00	SPY	ETF	241.4	241.4	241.26	241.29	41059.0
2017-05-30 07:30:00	SPY	ETF	241.29	241.32	241.18	241.18	49734.0
2017-05-30 08:00:00	SPY	ETF	241.17	241.39	241.17	241.31	191209.0
2017-05-30 08:30:00	SPY	ETF	241.31	241.47	241.29	241.44	104443.0
2017-05-30 09:00:00	SPY	ETF	241.41	241.45	241.31	241.33	184538.0
2017-05-30 09:30:00	SPY	ETF	241.34	241.7	241.23	241.495	5129058.0
2017-05-30 10:00:00	SPY	ETF	241.495	241.58	241.16	241.31	4688138.0
2017-05-30 10:30:00	SPY	ETF	241.32	241.62	241.31	241.51	2513348.0
2017-05-30 11:00:00	SPY	ETF	241.5	241.64	241.46	241.47	1736649.0
2017-05-30 11:30:00	SPY	ETF	241.48	241.6	241.46	241.52	1601151.0
2017-05-30 12:00:00	SPY	ETF	241.52	241.73	241.52	241.71	1373857.0
2017-05-30 12:30:00	SPY	ETF	241.71	241.79	241.66	241.71	1209901.0
2017-05-30 13:00:00	SPY	ETF	241.71	241.77	241.6	241.6153	1330802.0
2017-05-30 13:30:00	SPY	ETF	241.62	241.71	241.59	241.64	1115145.0
2017-05-30 14:00:00	SPY	ETF	241.63	241.7	241.59	241.6	1215168.0
2017-05-30 14:30:00	SPY	ETF	241.6	241.65	241.53	241.645	1399662.0
2017-05-30 15:00:00	SPY	ETF	241.65	241.78	241.6	241.63	1584804.0
2017-05-30 15:30:00	SPY	ETF	241.625	241.72	241.52	241.52	5363275.0
2017-05-30 16:00:00	SPY	ETF	241.53	241.57	241.4	241.5	3527596.0
2017-05-30 16:30:00	SPY	ETF	241.47	241.51	241.45	241.5	176356.0
2017-05-30 17:00:00	SPY	ETF	241.47	241.47	241.44	241.45	11519.0
2017-05-30 17:30:00	SPY	ETF	241.47	241.47	241.45	241.45	5662.0
2017-05-30 18:00:00	SPY	ETF	241.44	241.47	241.43	241.47	7301.0
2017-05-30 18:30:00	SPY	ETF	241.47	241.53	241.46	241.5	25546.0
2017-05-30 19:00:00	SPY	ETF	241.51	241.51	241.5	241.5	5700.0
2017-05-30 19:30:00	SPY	ETF	241.5	241.5	241.45	241.5	13267.0
2017-05-30 04:00:00	QQQ	ETF	141.15	141.15	141.15	141.15	5000.0
2017-05-30 04:30:00	QQQ	ETF	141.26	141.29	141.26	141.29	2200.0
2017-05-30 05:00:00	QQQ	ETF	141.26	141.26	141.26	141.26	467.0
2017-05-30 05:30:00	QQQ	ETF	141.21	141.21	141.21	141.21	300.0
2017-05-30 06:00:00	QQQ	ETF	141.23	141.24	141.2	141.2	6200.0
2017-05-30 06:30:00	QQQ	ETF	141.21	141.21	141.19	141.19	1100.0
2017-05-30 07:00:00	QQQ	ETF	141.15	141.15	141.06	141.06	2700.0
2017-05-30 07:30:00	QQQ	ETF	141.09	141.09	140.94	140.94	27896.0
2017-05-30 08:00:00	QQQ	ETF	140.94	141.09	140.92	141.07	11005.0
2017-05-30 08:30:00	QQQ	ETF	141.08	141.19	141.07	141.19	14215.0
2017-05-30 09:00:00	QQQ	ETF	141.17	141.18	141.12	141.12	53181.0
2017-05-30 09:30:00	QQQ	ETF	141.13	141.5	141.06	141.41	1748511.0
2017-05-30 10:00:00	QQQ	ETF	141.42	141.46	141.23	141.32	1708138.0
2017-05-30 10:30:00	QQQ	ETF	141.31	141.48	141.31	141.37	2326267.0
2017-05-30 11:00:00	QQQ	ETF	141.36	141.44	141.31	141.32	539297.0
2017-05-30 11:30:00	QQQ	ETF	141.33	141.45	141.32	141.3552	780009.0
2017-05-30 12:00:00	QQQ	ETF	141.36	141.45	141.33	141.44	378610.0
2017-05-30 12:30:00	QQQ	ETF	141.45	141.505	141.36	141.45	1461177.0

> showing 50 of 14,493 rows — these rows as CSV

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