PREVIEW / etf_30min / 2015-07-09

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-07-09.parquet
  size:    397 KB
  rows:    13,448

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
2015-07-09 04:00:00	SPY	ETF	205.04	206.12	205.04	206.07	18589.0
2015-07-09 04:30:00	SPY	ETF	205.93	206.09	205.92	206.09	14716.0
2015-07-09 05:00:00	SPY	ETF	206.02	206.34	205.97	206.34	31204.0
2015-07-09 05:30:00	SPY	ETF	206.37	206.51	206.29	206.4	46611.0
2015-07-09 06:00:00	SPY	ETF	206.4	206.52	206.35	206.39	60528.0
2015-07-09 06:30:00	SPY	ETF	206.47	206.69	206.43	206.54	124147.0
2015-07-09 07:00:00	SPY	ETF	206.5	206.74	206.46	206.56	256909.0
2015-07-09 07:30:00	SPY	ETF	206.56	206.66	206.52	206.6	305900.0
2015-07-09 08:00:00	SPY	ETF	206.6	206.84	205.41	206.71	648745.0
2015-07-09 08:30:00	SPY	ETF	206.75	206.86	206.68	206.82	638451.0
2015-07-09 09:00:00	SPY	ETF	206.82	207.19	206.69	207.04	1436660.0
2015-07-09 09:30:00	SPY	ETF	207.04	207.35	206.57	206.81	20961229.0
2015-07-09 10:00:00	SPY	ETF	206.81	206.94	205.9301	205.975	13180561.0
2015-07-09 10:30:00	SPY	ETF	205.98	206.59	205.95	206.55	7996925.0
2015-07-09 11:00:00	SPY	ETF	206.55	206.79	206.29	206.32	8351099.0
2015-07-09 11:30:00	SPY	ETF	206.31	206.64	205.98	206.01	4390571.0
2015-07-09 12:00:00	SPY	ETF	205.99	206.18	205.78	205.84	5618885.0
2015-07-09 12:30:00	SPY	ETF	205.84	206.02	205.68	205.909	6300723.0
2015-07-09 13:00:00	SPY	ETF	205.9	205.97	205.34	205.43	6110035.0
2015-07-09 13:30:00	SPY	ETF	205.45	205.77	205.385	205.66	5833718.0
2015-07-09 14:00:00	SPY	ETF	205.66	205.69	204.98	205.158	8017068.0
2015-07-09 14:30:00	SPY	ETF	205.1599	205.65	204.89	205.535	14329298.0
2015-07-09 15:00:00	SPY	ETF	205.54	205.79	205.42	205.44	10589706.0
2015-07-09 15:30:00	SPY	ETF	205.44	206.529	204.88	204.89	17034651.0
2015-07-09 16:00:00	SPY	ETF	204.85	205.4071	204.49	204.62	5624247.0
2015-07-09 16:30:00	SPY	ETF	204.62	204.82	204.38	204.71	938711.0
2015-07-09 17:00:00	SPY	ETF	204.71	204.9	204.63	204.69	68779.0
2015-07-09 17:30:00	SPY	ETF	204.68	205.0	204.65	205.0	236992.0
2015-07-09 18:00:00	SPY	ETF	205.01	206.61	205.01	206.39	1249578.0
2015-07-09 18:30:00	SPY	ETF	206.33	206.7	206.0	206.67	1021959.0
2015-07-09 19:00:00	SPY	ETF	206.62	206.69	206.17	206.36	278086.0
2015-07-09 19:30:00	SPY	ETF	206.33	206.37	206.23	206.25	84248.0
2015-07-09 04:00:00	QQQ	ETF	106.76	107.08	106.76	106.88	1791.0
2015-07-09 05:30:00	QQQ	ETF	107.03	107.03	107.03	107.03	500.0
2015-07-09 06:00:00	QQQ	ETF	107.05	107.16	107.05	107.16	1450.0
2015-07-09 06:30:00	QQQ	ETF	107.22	107.37	107.17	107.37	16800.0
2015-07-09 07:00:00	QQQ	ETF	107.26	107.34	107.25	107.26	64733.0
2015-07-09 07:30:00	QQQ	ETF	107.29	107.34	107.29	107.32	18395.0
2015-07-09 08:00:00	QQQ	ETF	107.3	107.37	107.28	107.35	132741.0
2015-07-09 08:30:00	QQQ	ETF	107.323	107.39	107.31	107.35	51803.0
2015-07-09 09:00:00	QQQ	ETF	107.02	107.62	107.02	107.49	712485.0
2015-07-09 09:30:00	QQQ	ETF	107.5	107.5955	107.135	107.33	4256576.0
2015-07-09 10:00:00	QQQ	ETF	107.33	107.42	106.89	106.91	2345460.0
2015-07-09 10:30:00	QQQ	ETF	106.91	107.22	106.9	107.2	1546628.0
2015-07-09 11:00:00	QQQ	ETF	107.2	107.35	107.07	107.08	1459348.0
2015-07-09 11:30:00	QQQ	ETF	107.08	107.15	106.85	106.87	1027069.0
2015-07-09 12:00:00	QQQ	ETF	106.86	106.99	106.771	106.86	1119677.0
2015-07-09 12:30:00	QQQ	ETF	106.851	106.96	106.78	106.89	1139552.0
2015-07-09 13:00:00	QQQ	ETF	106.88	106.9166	106.54	106.58	1115266.0
2015-07-09 13:30:00	QQQ	ETF	106.6	106.74	106.49	106.61	1058014.0

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

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