PREVIEW / etf_30min / 2016-08-08

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-08-08.parquet
  size:    388 KB
  rows:    13,270

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
2016-08-08 04:00:00	SPY	ETF	218.5	218.56	218.46	218.52	2143.0
2016-08-08 04:30:00	SPY	ETF	218.55	218.68	218.55	218.62	8230.0
2016-08-08 05:00:00	SPY	ETF	218.6	218.61	218.55	218.55	3802.0
2016-08-08 05:30:00	SPY	ETF	218.55	218.61	218.5	218.5	6100.0
2016-08-08 06:00:00	SPY	ETF	218.5	218.56	218.47	218.56	6531.0
2016-08-08 06:30:00	SPY	ETF	218.53	218.53	218.42	218.48	25400.0
2016-08-08 07:00:00	SPY	ETF	218.45	218.54	218.44	218.46	42305.0
2016-08-08 07:30:00	SPY	ETF	218.5	218.5	218.42	218.44	37250.0
2016-08-08 08:00:00	SPY	ETF	218.43	218.52	218.07	218.37	116117.0
2016-08-08 08:30:00	SPY	ETF	218.38	218.38	218.26	218.27	77807.0
2016-08-08 09:00:00	SPY	ETF	218.28	218.45	218.26	218.41	275449.0
2016-08-08 09:30:00	SPY	ETF	218.4	218.52	218.11	218.1607	6537128.0
2016-08-08 10:00:00	SPY	ETF	218.17	218.28	217.91	217.975	3640311.0
2016-08-08 10:30:00	SPY	ETF	217.98	218.14	217.95	218.075	2776181.0
2016-08-08 11:00:00	SPY	ETF	218.075	218.24	218.02	218.13	2124416.0
2016-08-08 11:30:00	SPY	ETF	218.13	218.23	218.07	218.09	1824270.0
2016-08-08 12:00:00	SPY	ETF	218.08	218.12	217.96	218.02	1566144.0
2016-08-08 12:30:00	SPY	ETF	218.02	218.11	217.91	218.04	1537706.0
2016-08-08 13:00:00	SPY	ETF	218.04	218.06	217.95	218.04	1554847.0
2016-08-08 13:30:00	SPY	ETF	218.04	218.07	217.97	218.06	1494159.0
2016-08-08 14:00:00	SPY	ETF	218.055	218.09	217.74	217.797	2543478.0
2016-08-08 14:30:00	SPY	ETF	217.795	217.905	217.76	217.81	1827335.0
2016-08-08 15:00:00	SPY	ETF	217.81	217.88	217.76	217.8689	3285408.0
2016-08-08 15:30:00	SPY	ETF	217.865	218.04	217.855	218.03	5250885.0
2016-08-08 16:00:00	SPY	ETF	218.04	218.05	217.93	217.99	2045962.0
2016-08-08 16:30:00	SPY	ETF	217.99	218.07	217.99	218.07	168740.0
2016-08-08 17:00:00	SPY	ETF	218.03	218.14	218.03	218.05	96592.0
2016-08-08 17:30:00	SPY	ETF	218.05	218.06	217.99	218.0	97427.0
2016-08-08 18:00:00	SPY	ETF	217.98	218.0	217.9	217.98	88379.0
2016-08-08 18:30:00	SPY	ETF	217.95	217.95	217.95	217.95	1000.0
2016-08-08 19:00:00	SPY	ETF	217.95	217.97	217.91	217.92	17340.0
2016-08-08 19:30:00	SPY	ETF	217.91	218.0603	217.9	217.95	30189.0
2016-08-08 04:00:00	QQQ	ETF	116.9	117.06	116.9	117.0	1455.0
2016-08-08 04:30:00	QQQ	ETF	117.06	117.06	117.06	117.06	500.0
2016-08-08 05:00:00	QQQ	ETF	117.03	117.1	117.03	117.09	50100.0
2016-08-08 05:30:00	QQQ	ETF	117.05	117.05	116.97	116.97	2800.0
2016-08-08 06:00:00	QQQ	ETF	116.98	116.98	116.98	116.98	600.0
2016-08-08 06:30:00	QQQ	ETF	116.99	116.99	116.98	116.98	25500.0
2016-08-08 07:00:00	QQQ	ETF	116.95	116.98	116.95	116.96	5396.0
2016-08-08 07:30:00	QQQ	ETF	116.97	116.98	116.93	116.94	9000.0
2016-08-08 08:00:00	QQQ	ETF	116.94	117.0	116.87	116.89	49370.0
2016-08-08 08:30:00	QQQ	ETF	116.88	116.88	116.79	116.79	25853.0
2016-08-08 09:00:00	QQQ	ETF	116.78	116.85	116.78	116.83	132017.0
2016-08-08 09:30:00	QQQ	ETF	116.82	116.87	116.56	116.6134	1723303.0
2016-08-08 10:00:00	QQQ	ETF	116.61	116.66	116.28	116.37	1435844.0
2016-08-08 10:30:00	QQQ	ETF	116.37	116.48	116.291	116.43	670973.0
2016-08-08 11:00:00	QQQ	ETF	116.44	116.5448	116.37	116.48	617442.0
2016-08-08 11:30:00	QQQ	ETF	116.48	116.56	116.47	116.4835	411806.0
2016-08-08 12:00:00	QQQ	ETF	116.49	116.53	116.43	116.48	352678.0
2016-08-08 12:30:00	QQQ	ETF	116.48	116.55	116.44	116.4965	303825.0

> showing 50 of 13,270 rows — these rows as CSV

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