PREVIEW / etf_30min / 2017-01-04

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-01-04.parquet
  size:    443 KB
  rows:    15,188

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-01-04 04:00:00	SPY	ETF	225.43	225.5	225.41	225.5	1651.0
2017-01-04 04:30:00	SPY	ETF	225.5	225.59	225.5	225.59	4107.0
2017-01-04 05:00:00	SPY	ETF	225.64	225.65	225.58	225.62	4037.0
2017-01-04 05:30:00	SPY	ETF	225.62	225.67	225.61	225.61	2303.0
2017-01-04 06:00:00	SPY	ETF	225.4	225.6	225.4	225.6	2464.0
2017-01-04 06:30:00	SPY	ETF	225.59	225.59	225.57	225.59	35901.0
2017-01-04 07:00:00	SPY	ETF	225.55	225.59	225.54	225.59	95446.0
2017-01-04 07:30:00	SPY	ETF	225.59	225.67	225.58	225.67	50448.0
2017-01-04 08:00:00	SPY	ETF	225.65	225.79	225.56	225.77	397775.0
2017-01-04 08:30:00	SPY	ETF	225.73	225.77	225.65	225.67	171957.0
2017-01-04 09:00:00	SPY	ETF	225.65	225.66	225.56	225.62	593374.0
2017-01-04 09:30:00	SPY	ETF	225.62	226.35	225.61	226.03	8580819.0
2017-01-04 10:00:00	SPY	ETF	226.04	226.24	225.76	225.77	4647392.0
2017-01-04 10:30:00	SPY	ETF	225.7803	226.14	225.76	226.09	3414783.0
2017-01-04 11:00:00	SPY	ETF	226.09	226.25	226.06	226.21	5029790.0
2017-01-04 11:30:00	SPY	ETF	226.215	226.45	226.215	226.4	3920673.0
2017-01-04 12:00:00	SPY	ETF	226.39	226.5	226.3	226.35	4312612.0
2017-01-04 12:30:00	SPY	ETF	226.345	226.42	226.31	226.37	2394190.0
2017-01-04 13:00:00	SPY	ETF	226.37	226.3875	226.28	226.36	1732421.0
2017-01-04 13:30:00	SPY	ETF	226.36	226.43	226.32	226.35	2476498.0
2017-01-04 14:00:00	SPY	ETF	226.355	226.695	226.29	226.56	5782274.0
2017-01-04 14:30:00	SPY	ETF	226.56	226.65	226.4	226.49	3798213.0
2017-01-04 15:00:00	SPY	ETF	226.49	226.62	226.45	226.57	5587284.0
2017-01-04 15:30:00	SPY	ETF	226.57	226.75	226.36	226.53	15712873.0
2017-01-04 16:00:00	SPY	ETF	226.53	226.6303	226.39	226.49	6765197.0
2017-01-04 16:30:00	SPY	ETF	226.5	226.58	226.47	226.47	1295507.0
2017-01-04 17:00:00	SPY	ETF	226.48	226.52	226.47	226.52	105727.0
2017-01-04 17:30:00	SPY	ETF	226.51	226.52	226.49	226.51	44600.0
2017-01-04 18:00:00	SPY	ETF	226.5	226.6	226.5	226.55	91256.0
2017-01-04 18:30:00	SPY	ETF	226.59	226.6	226.52	226.52	40254.0
2017-01-04 19:00:00	SPY	ETF	226.51	226.52	226.28	226.36	106263.0
2017-01-04 19:30:00	SPY	ETF	226.35	226.41	226.33	226.33	25377.0
2017-01-04 04:00:00	QQQ	ETF	119.65	119.69	119.65	119.69	410.0
2017-01-04 04:30:00	QQQ	ETF	119.72	119.72	119.72	119.72	300.0
2017-01-04 05:00:00	QQQ	ETF	119.73	119.73	119.73	119.73	330.0
2017-01-04 06:30:00	QQQ	ETF	119.68	119.68	119.68	119.68	10700.0
2017-01-04 07:00:00	QQQ	ETF	119.66	119.68	119.66	119.68	1599.0
2017-01-04 07:30:00	QQQ	ETF	119.68	119.69	119.68	119.69	898.0
2017-01-04 08:00:00	QQQ	ETF	119.69	119.79	119.69	119.78	38847.0
2017-01-04 08:30:00	QQQ	ETF	119.77	119.78	119.7	119.7	60077.0
2017-01-04 09:00:00	QQQ	ETF	119.69	119.69	119.64	119.65	38843.0
2017-01-04 09:30:00	QQQ	ETF	119.67	120.18	119.6561	119.94	2194670.0
2017-01-04 10:00:00	QQQ	ETF	119.95	120.11	119.79	119.791	897551.0
2017-01-04 10:30:00	QQQ	ETF	119.79	120.08	119.79	120.02	919669.0
2017-01-04 11:00:00	QQQ	ETF	120.02	120.11	119.9	120.02	560585.0
2017-01-04 11:30:00	QQQ	ETF	120.03	120.23	120.03	120.185	1265673.0
2017-01-04 12:00:00	QQQ	ETF	120.19	120.25	120.095	120.11	771659.0
2017-01-04 12:30:00	QQQ	ETF	120.105	120.225	120.09	120.145	428662.0
2017-01-04 13:00:00	QQQ	ETF	120.14	120.19	120.075	120.19	520056.0
2017-01-04 13:30:00	QQQ	ETF	120.19	120.22	120.14	120.16	619557.0

> showing 50 of 15,188 rows — these rows as CSV

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