PREVIEW / etf_30min / 2016-06-17

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-06-17.parquet
  size:    381 KB
  rows:    12,994

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-06-17 04:00:00	SPY	ETF	207.49	207.73	206.94	206.99	18848.0
2016-06-17 04:30:00	SPY	ETF	207.03	207.31	207.01	207.26	19789.0
2016-06-17 05:00:00	SPY	ETF	207.26	207.38	207.2	207.38	26953.0
2016-06-17 05:30:00	SPY	ETF	207.36	207.42	207.12	207.16	65124.0
2016-06-17 06:00:00	SPY	ETF	207.16	207.19	207.02	207.18	122876.0
2016-06-17 06:30:00	SPY	ETF	207.17	207.17	207.0	207.04	109969.0
2016-06-17 07:00:00	SPY	ETF	207.0	207.05	206.85	206.91	205337.0
2016-06-17 07:30:00	SPY	ETF	206.88	207.17	206.84	207.15	205189.0
2016-06-17 08:00:00	SPY	ETF	207.09	207.451	206.85	207.28	815683.0
2016-06-17 08:30:00	SPY	ETF	207.29	207.38	207.1	207.25	585034.0
2016-06-17 09:00:00	SPY	ETF	207.25	207.26	206.98	207.17	1296505.0
2016-06-17 09:30:00	SPY	ETF	207.17	207.2	206.56	206.91	15488115.0
2016-06-17 10:00:00	SPY	ETF	206.91	207.1	206.47	206.47	17739737.0
2016-06-17 10:30:00	SPY	ETF	206.465	206.58	206.09	206.31	8234365.0
2016-06-17 11:00:00	SPY	ETF	206.31	206.345	205.81	205.82	7675618.0
2016-06-17 11:30:00	SPY	ETF	205.81	206.25	205.75	206.13	5746915.0
2016-06-17 12:00:00	SPY	ETF	206.13	206.66	206.12	206.535	5501895.0
2016-06-17 12:30:00	SPY	ETF	206.54	206.54	206.19	206.29	4172064.0
2016-06-17 13:00:00	SPY	ETF	206.281	206.63	206.035	206.46	4271519.0
2016-06-17 13:30:00	SPY	ETF	206.4501	206.72	206.3701	206.58	3219298.0
2016-06-17 14:00:00	SPY	ETF	206.5762	206.76	206.34	206.725	7809308.0
2016-06-17 14:30:00	SPY	ETF	206.73	207.02	206.65	206.86	7406767.0
2016-06-17 15:00:00	SPY	ETF	206.86	206.92	206.55	206.67	4518709.0
2016-06-17 15:30:00	SPY	ETF	206.67	206.74	206.42	206.58	13521821.0
2016-06-17 16:00:00	SPY	ETF	206.58	206.66	206.17	206.31	5243861.0
2016-06-17 16:30:00	SPY	ETF	206.3	206.52	206.3	206.42	474707.0
2016-06-17 17:00:00	SPY	ETF	206.42	206.54	206.36	206.52	284485.0
2016-06-17 17:30:00	SPY	ETF	206.54	206.72	206.53	206.64	392492.0
2016-06-17 18:00:00	SPY	ETF	206.64	206.68	206.5	206.5	54765.0
2016-06-17 18:30:00	SPY	ETF	206.6	206.6	206.4	206.41	84096.0
2016-06-17 19:00:00	SPY	ETF	206.42	206.5	206.41	206.5	8451.0
2016-06-17 19:30:00	SPY	ETF	206.44	206.44	206.27	206.27	32366.0
2016-06-17 04:00:00	QQQ	ETF	107.75	107.75	107.61	107.63	5623.0
2016-06-17 05:00:00	QQQ	ETF	107.76	107.76	107.76	107.76	100.0
2016-06-17 06:00:00	QQQ	ETF	107.7	107.7	107.64	107.64	1700.0
2016-06-17 06:30:00	QQQ	ETF	107.69	107.69	107.63	107.63	25400.0
2016-06-17 07:00:00	QQQ	ETF	107.62	107.66	107.55	107.59	7725.0
2016-06-17 07:30:00	QQQ	ETF	107.59	107.71	107.59	107.71	83399.0
2016-06-17 08:00:00	QQQ	ETF	107.58	107.77	107.55	107.74	26737.0
2016-06-17 08:30:00	QQQ	ETF	107.75	107.76	107.65	107.65	96854.0
2016-06-17 09:00:00	QQQ	ETF	107.62	107.62	107.4	107.55	532154.0
2016-06-17 09:30:00	QQQ	ETF	107.55	107.56	106.77	106.91	4861259.0
2016-06-17 10:00:00	QQQ	ETF	106.91	106.959	106.58	106.59	2036950.0
2016-06-17 10:30:00	QQQ	ETF	106.58	106.59	106.36	106.44	2131214.0
2016-06-17 11:00:00	QQQ	ETF	106.43	106.49	106.25	106.29	1764908.0
2016-06-17 11:30:00	QQQ	ETF	106.28	106.5	106.24	106.37	1514053.0
2016-06-17 12:00:00	QQQ	ETF	106.38	106.68	106.38	106.63	992772.0
2016-06-17 12:30:00	QQQ	ETF	106.64	106.64	106.45	106.51	1098327.0
2016-06-17 13:00:00	QQQ	ETF	106.51	106.76	106.38	106.67	1585197.0
2016-06-17 13:30:00	QQQ	ETF	106.67	106.81	106.615	106.69	684599.0

> showing 50 of 12,994 rows — these rows as CSV

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