PREVIEW / etf_30min / 2015-09-08

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-09-08.parquet
  size:    386 KB
  rows:    13,079

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-09-08 04:00:00	SPY	ETF	196.09	196.4	195.38	196.24	17898.0
2015-09-08 04:30:00	SPY	ETF	196.29	196.41	196.17	196.36	71500.0
2015-09-08 05:00:00	SPY	ETF	196.45	196.73	196.41	196.53	21225.0
2015-09-08 05:30:00	SPY	ETF	196.54	196.85	196.53	196.73	27235.0
2015-09-08 06:00:00	SPY	ETF	196.73	196.86	196.6	196.78	95790.0
2015-09-08 06:30:00	SPY	ETF	196.82	196.86	196.63	196.68	134757.0
2015-09-08 07:00:00	SPY	ETF	196.68	196.68	196.23	196.25	192930.0
2015-09-08 07:30:00	SPY	ETF	196.23	196.44	196.01	196.19	466272.0
2015-09-08 08:00:00	SPY	ETF	196.18	196.66	195.79	196.07	843810.0
2015-09-08 08:30:00	SPY	ETF	196.09	196.36	196.09	196.11	796816.0
2015-09-08 09:00:00	SPY	ETF	196.09	196.28	195.92	195.93	912795.0
2015-09-08 09:30:00	SPY	ETF	195.94	196.67	195.85	195.9499	14406590.0
2015-09-08 10:00:00	SPY	ETF	195.945	196.02	195.43	195.8	8841006.0
2015-09-08 10:30:00	SPY	ETF	195.81	195.97	195.17	195.7	7142113.0
2015-09-08 11:00:00	SPY	ETF	195.69	195.88	195.32	195.73	5490772.0
2015-09-08 11:30:00	SPY	ETF	195.73	195.76	195.32	195.44	3713183.0
2015-09-08 12:00:00	SPY	ETF	195.44	196.29	195.32	196.28	4696040.0
2015-09-08 12:30:00	SPY	ETF	196.29	196.36	195.78	195.8164	3575102.0
2015-09-08 13:00:00	SPY	ETF	195.82	195.92	195.52	195.71	3297009.0
2015-09-08 13:30:00	SPY	ETF	195.71	196.34	195.51	196.32	3559759.0
2015-09-08 14:00:00	SPY	ETF	196.33	196.71	196.21	196.6697	6172067.0
2015-09-08 14:30:00	SPY	ETF	196.67	197.14	196.62	196.9499	8271108.0
2015-09-08 15:00:00	SPY	ETF	196.95	197.12	196.72	197.07	8369011.0
2015-09-08 15:30:00	SPY	ETF	197.08	197.61	196.97	197.51	22376235.0
2015-09-08 16:00:00	SPY	ETF	197.49	197.55	195.581	197.3	4469059.0
2015-09-08 16:30:00	SPY	ETF	197.29	197.44	197.28	197.29	2954928.0
2015-09-08 17:00:00	SPY	ETF	197.29	197.39	197.27	197.39	536588.0
2015-09-08 17:30:00	SPY	ETF	197.37	197.45	197.31	197.38	50268.0
2015-09-08 18:00:00	SPY	ETF	197.37	197.4	197.18	197.22	61522.0
2015-09-08 18:30:00	SPY	ETF	197.21	197.27	197.18	197.21	9220.0
2015-09-08 19:00:00	SPY	ETF	197.24	197.36	197.18	197.32	14049.0
2015-09-08 19:30:00	SPY	ETF	197.33	197.52	197.2	197.52	96058.0
2015-09-08 04:00:00	QQQ	ETF	104.03	104.25	104.0	104.1	20062.0
2015-09-08 04:30:00	QQQ	ETF	104.19	104.19	104.19	104.19	100.0
2015-09-08 05:00:00	QQQ	ETF	104.36	104.44	104.33	104.33	6750.0
2015-09-08 05:30:00	QQQ	ETF	104.38	104.48	104.38	104.48	12975.0
2015-09-08 06:00:00	QQQ	ETF	104.46	104.46	104.35	104.4	6877.0
2015-09-08 06:30:00	QQQ	ETF	104.4	104.5	104.4	104.4	12791.0
2015-09-08 07:00:00	QQQ	ETF	104.43	104.43	104.18	104.18	32600.0
2015-09-08 07:30:00	QQQ	ETF	104.21	104.28	104.08	104.1	20460.0
2015-09-08 08:00:00	QQQ	ETF	104.16	104.4	103.94	104.05	69810.0
2015-09-08 08:30:00	QQQ	ETF	104.06	104.2	104.04	104.04	49374.0
2015-09-08 09:00:00	QQQ	ETF	104.06	104.28	104.06	104.11	289483.0
2015-09-08 09:30:00	QQQ	ETF	104.12	104.83	104.1	104.47	6018096.0
2015-09-08 10:00:00	QQQ	ETF	104.47	104.5285	104.05	104.31	3965253.0
2015-09-08 10:30:00	QQQ	ETF	104.31	104.41	103.855	104.18	3267432.0
2015-09-08 11:00:00	QQQ	ETF	104.185	104.27	103.93	104.21	2205742.0
2015-09-08 11:30:00	QQQ	ETF	104.2	104.25	103.895	103.94	1455290.0
2015-09-08 12:00:00	QQQ	ETF	103.93	104.38	103.84	104.37	1828810.0
2015-09-08 12:30:00	QQQ	ETF	104.37	104.42	104.03	104.05	1642421.0

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

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