PREVIEW / etf_30min / 2015-11-27

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-11-27.parquet
  size:    214 KB
  rows:    7,024

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-11-27 04:00:00	SPY	ETF	209.29	209.29	209.09	209.17	3841.0
2015-11-27 04:30:00	SPY	ETF	209.27	209.39	209.27	209.39	800.0
2015-11-27 05:00:00	SPY	ETF	209.26	209.64	209.23	209.53	6590.0
2015-11-27 05:30:00	SPY	ETF	209.57	209.74	209.57	209.74	1965.0
2015-11-27 06:00:00	SPY	ETF	209.79	209.82	209.5	209.64	3810.0
2015-11-27 06:30:00	SPY	ETF	209.65	209.72	209.59	209.61	13500.0
2015-11-27 07:00:00	SPY	ETF	209.74	209.74	209.5	209.56	19367.0
2015-11-27 07:30:00	SPY	ETF	209.6	209.78	209.56	209.75	95370.0
2015-11-27 08:00:00	SPY	ETF	210.31	210.31	209.54	209.63	318712.0
2015-11-27 08:30:00	SPY	ETF	209.63	209.64	209.43	209.49	100713.0
2015-11-27 09:00:00	SPY	ETF	209.5	209.57	209.38	209.41	320748.0
2015-11-27 09:30:00	SPY	ETF	209.43	209.54	209.06	209.21	7348099.0
2015-11-27 10:00:00	SPY	ETF	209.21	209.41	208.86	209.34	4770795.0
2015-11-27 10:30:00	SPY	ETF	209.33	209.46	209.2	209.405	3517073.0
2015-11-27 11:00:00	SPY	ETF	209.41	209.71	209.4	209.63	3093435.0
2015-11-27 11:30:00	SPY	ETF	209.635	209.8	209.47	209.54	3278805.0
2015-11-27 12:00:00	SPY	ETF	209.53	209.685	209.46	209.67	2780251.0
2015-11-27 12:30:00	SPY	ETF	209.68	209.74	209.47	209.53	5609772.0
2015-11-27 13:00:00	SPY	ETF	209.54	209.71	209.4657	209.55	1904112.0
2015-11-27 13:30:00	SPY	ETF	209.54	209.62	209.48	209.5999	629462.0
2015-11-27 14:00:00	SPY	ETF	209.56	209.58	209.42	209.42	191708.0
2015-11-27 14:30:00	SPY	ETF	209.42	209.49	209.38	209.38	29950.0
2015-11-27 15:00:00	SPY	ETF	209.44	209.47	209.44	209.47	820.0
2015-11-27 15:30:00	SPY	ETF	209.45	209.51	209.45	209.51	9882.0
2015-11-27 16:00:00	SPY	ETF	209.51	209.51	209.41	209.43	7479.0
2015-11-27 16:30:00	SPY	ETF	209.43	209.45	209.42	209.42	15202.0
2015-11-27 04:00:00	QQQ	ETF	114.19	114.19	114.19	114.19	100.0
2015-11-27 04:30:00	QQQ	ETF	114.28	114.28	114.28	114.28	100.0
2015-11-27 05:00:00	QQQ	ETF	114.29	114.29	114.29	114.29	1000.0
2015-11-27 06:00:00	QQQ	ETF	114.47	114.47	114.47	114.47	610.0
2015-11-27 06:30:00	QQQ	ETF	114.56	114.56	114.56	114.56	6350.0
2015-11-27 07:00:00	QQQ	ETF	114.58	114.58	114.54	114.55	2500.0
2015-11-27 07:30:00	QQQ	ETF	114.54	114.62	114.54	114.62	7300.0
2015-11-27 08:00:00	QQQ	ETF	114.52	114.63	114.51	114.51	42502.0
2015-11-27 08:30:00	QQQ	ETF	114.51	114.52	114.44	114.46	23470.0
2015-11-27 09:00:00	QQQ	ETF	114.47	114.48	114.27	114.39	159242.0
2015-11-27 09:30:00	QQQ	ETF	114.395	114.44	114.105	114.18	2197896.0
2015-11-27 10:00:00	QQQ	ETF	114.17	114.2485	113.92	114.2	1406938.0
2015-11-27 10:30:00	QQQ	ETF	114.19	114.23	114.075	114.17	557008.0
2015-11-27 11:00:00	QQQ	ETF	114.17	114.5	114.17	114.45	1331226.0
2015-11-27 11:30:00	QQQ	ETF	114.46	114.541	114.365	114.37	578887.0
2015-11-27 12:00:00	QQQ	ETF	114.38	114.48	114.3401	114.465	456804.0
2015-11-27 12:30:00	QQQ	ETF	114.475	114.5	114.29	114.31	1117999.0
2015-11-27 13:00:00	QQQ	ETF	114.32	114.38	114.2	114.26	130075.0
2015-11-27 13:30:00	QQQ	ETF	114.35	114.35	114.2	114.25	6634.0
2015-11-27 14:00:00	QQQ	ETF	114.22	114.28	114.22	114.28	400800.0
2015-11-27 14:30:00	QQQ	ETF	114.27	114.27	114.09	114.09	14067.0
2015-11-27 15:00:00	QQQ	ETF	114.2	114.2	114.2	114.2	100.0
2015-11-27 15:30:00	QQQ	ETF	114.13	114.2	114.12	114.13	3000.0
2015-11-27 16:00:00	QQQ	ETF	114.21	114.22	114.21	114.22	1139.0

> showing 50 of 7,024 rows — these rows as CSV

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