PREVIEW / etf_30min / 2016-04-08

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-04-08.parquet
  size:    391 KB
  rows:    13,246

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-04-08 04:00:00	SPY	ETF	205.01	205.31	205.0	205.17	114905.0
2016-04-08 04:30:00	SPY	ETF	205.15	205.2	205.05	205.1	6743.0
2016-04-08 05:00:00	SPY	ETF	205.15	205.17	204.83	204.83	67244.0
2016-04-08 05:30:00	SPY	ETF	204.86	205.15	204.84	205.15	12905.0
2016-04-08 06:00:00	SPY	ETF	205.1	205.3	205.1	205.22	40058.0
2016-04-08 06:30:00	SPY	ETF	205.22	205.24	204.99	205.1	36431.0
2016-04-08 07:00:00	SPY	ETF	205.14	205.16	204.94	204.96	70806.0
2016-04-08 07:30:00	SPY	ETF	204.99	205.23	204.99	205.03	157024.0
2016-04-08 08:00:00	SPY	ETF	205.03	205.39	204.64	205.3	637220.0
2016-04-08 08:30:00	SPY	ETF	205.3	205.7	205.28	205.6	1431312.0
2016-04-08 09:00:00	SPY	ETF	205.6	205.68	205.29	205.34	1026560.0
2016-04-08 09:30:00	SPY	ETF	205.34	205.6	205.05	205.57	11270386.0
2016-04-08 10:00:00	SPY	ETF	205.57	205.85	205.42	205.5415	11466646.0
2016-04-08 10:30:00	SPY	ETF	205.54	205.66	205.22	205.24	6737421.0
2016-04-08 11:00:00	SPY	ETF	205.24	205.49	205.015	205.125	6626608.0
2016-04-08 11:30:00	SPY	ETF	205.13	205.19	204.44	204.75	7440196.0
2016-04-08 12:00:00	SPY	ETF	204.74	204.86	204.45	204.47	3899275.0
2016-04-08 12:30:00	SPY	ETF	204.45	204.82	204.31	204.731	3608638.0
2016-04-08 13:00:00	SPY	ETF	204.73	204.73	204.27	204.38	2893448.0
2016-04-08 13:30:00	SPY	ETF	204.38	204.89	204.3	204.8899	2628637.0
2016-04-08 14:00:00	SPY	ETF	204.88	205.07	204.66	204.9299	4288445.0
2016-04-08 14:30:00	SPY	ETF	204.92	204.93	204.28	204.44	3402883.0
2016-04-08 15:00:00	SPY	ETF	204.44	204.505	204.0	204.1	5891438.0
2016-04-08 15:30:00	SPY	ETF	204.11	204.53	203.87	204.53	11298474.0
2016-04-08 16:00:00	SPY	ETF	204.53	204.57	204.353	204.51	3939670.0
2016-04-08 16:30:00	SPY	ETF	204.51	204.62	204.51	204.61	302793.0
2016-04-08 17:00:00	SPY	ETF	204.6	204.68	204.59	204.67	62118.0
2016-04-08 17:30:00	SPY	ETF	204.65	204.68	204.62	204.66	38112.0
2016-04-08 18:00:00	SPY	ETF	204.66	204.68	204.55	204.6	46979.0
2016-04-08 18:30:00	SPY	ETF	204.58	204.63	204.58	204.63	1800.0
2016-04-08 19:00:00	SPY	ETF	204.61	204.63	204.61	204.63	3062.0
2016-04-08 19:30:00	SPY	ETF	204.63	204.67	204.6	204.63	32047.0
2016-04-08 04:00:00	QQQ	ETF	109.82	109.86	109.73	109.76	1286.0
2016-04-08 06:00:00	QQQ	ETF	109.8	109.82	109.77	109.82	1280.0
2016-04-08 06:30:00	QQQ	ETF	109.8	109.8	109.67	109.7	500.0
2016-04-08 07:00:00	QQQ	ETF	109.73	109.74	109.65	109.65	9697.0
2016-04-08 07:30:00	QQQ	ETF	109.67	109.78	109.67	109.73	6307.0
2016-04-08 08:00:00	QQQ	ETF	109.67	109.84	109.64	109.79	57829.0
2016-04-08 08:30:00	QQQ	ETF	109.8	109.98	109.79	109.96	95714.0
2016-04-08 09:00:00	QQQ	ETF	109.95	109.99	109.77	109.79	106440.0
2016-04-08 09:30:00	QQQ	ETF	109.78	109.86	109.42	109.845	2865345.0
2016-04-08 10:00:00	QQQ	ETF	109.84	110.02	109.7	109.755	1940658.0
2016-04-08 10:30:00	QQQ	ETF	109.76	109.81	109.401	109.415	1800067.0
2016-04-08 11:00:00	QQQ	ETF	109.42	109.625	109.26	109.3	962950.0
2016-04-08 11:30:00	QQQ	ETF	109.3	109.33	108.83	109.08	2463979.0
2016-04-08 12:00:00	QQQ	ETF	109.07	109.13	108.68	108.69	1269895.0
2016-04-08 12:30:00	QQQ	ETF	108.68	109.03	108.615	108.99	1149079.0
2016-04-08 13:00:00	QQQ	ETF	109.0	109.0	108.68	108.75	680520.0
2016-04-08 13:30:00	QQQ	ETF	108.74	109.12	108.695	109.12	813217.0
2016-04-08 14:00:00	QQQ	ETF	109.12	109.33	108.99	109.23	1117578.0

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

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