PREVIEW / etf_30min / 2017-12-28

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-12-28.parquet
  size:    442 KB
  rows:    15,499

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
2017-12-28 04:00:00	SPY	ETF	267.58	267.82	267.58	267.81	3529.0
2017-12-28 04:30:00	SPY	ETF	267.85	267.85	267.8	267.8	17150.0
2017-12-28 05:00:00	SPY	ETF	267.84	267.84	267.84	267.84	100.0
2017-12-28 05:30:00	SPY	ETF	267.85	267.85	267.83	267.83	5175.0
2017-12-28 06:00:00	SPY	ETF	267.85	267.9	267.82	267.9	3800.0
2017-12-28 07:00:00	SPY	ETF	267.86	267.9	267.83	267.85	13057.0
2017-12-28 07:30:00	SPY	ETF	267.85	267.88	267.8	267.84	43735.0
2017-12-28 08:00:00	SPY	ETF	267.84	267.84	267.64	267.82	48333.0
2017-12-28 08:30:00	SPY	ETF	267.8	267.88	267.75	267.88	43361.0
2017-12-28 09:00:00	SPY	ETF	267.88	267.88	267.78	267.85	64609.0
2017-12-28 09:30:00	SPY	ETF	267.89	267.9	267.49	267.585	4519027.0
2017-12-28 10:00:00	SPY	ETF	267.59	267.64	267.47	267.53	2657795.0
2017-12-28 10:30:00	SPY	ETF	267.52	267.7	267.465	267.66	2952493.0
2017-12-28 11:00:00	SPY	ETF	267.65	267.71	267.53	267.59	3141528.0
2017-12-28 11:30:00	SPY	ETF	267.58	267.74	267.51	267.685	3297243.0
2017-12-28 12:00:00	SPY	ETF	267.68	267.71	267.61	267.62	2015154.0
2017-12-28 12:30:00	SPY	ETF	267.625	267.65	267.57	267.61	2302762.0
2017-12-28 13:00:00	SPY	ETF	267.61	267.64	267.5135	267.52	2340346.0
2017-12-28 13:30:00	SPY	ETF	267.52	267.56	267.47	267.5401	1402900.0
2017-12-28 14:00:00	SPY	ETF	267.54	267.55	267.45	267.5052	1681983.0
2017-12-28 14:30:00	SPY	ETF	267.505	267.65	267.45	267.62	1475507.0
2017-12-28 15:00:00	SPY	ETF	267.62	267.65	267.57	267.59	2685716.0
2017-12-28 15:30:00	SPY	ETF	267.59	267.92	267.56	267.86	6892993.0
2017-12-28 16:00:00	SPY	ETF	267.87	267.9262	267.7	267.72	6044676.0
2017-12-28 16:30:00	SPY	ETF	267.73	267.76	267.69	267.75	110828.0
2017-12-28 17:00:00	SPY	ETF	267.76	267.76	267.62	267.68	47090.0
2017-12-28 17:30:00	SPY	ETF	267.68	267.87	267.65	267.65	266797.0
2017-12-28 18:00:00	SPY	ETF	267.68	267.86	267.68	267.85	33565.0
2017-12-28 18:30:00	SPY	ETF	267.86	267.88	267.78	267.78	12700.0
2017-12-28 19:00:00	SPY	ETF	267.78	267.9	267.78	267.9	17100.0
2017-12-28 19:30:00	SPY	ETF	267.87	267.9	267.86	267.9	8970.0
2017-12-28 04:00:00	QQQ	ETF	156.96	157.04	156.96	157.04	1200.0
2017-12-28 04:30:00	QQQ	ETF	157.05	157.05	157.0	157.0	5400.0
2017-12-28 06:00:00	QQQ	ETF	157.07	157.13	157.07	157.1	10750.0
2017-12-28 06:30:00	QQQ	ETF	157.09	157.15	157.09	157.15	1003.0
2017-12-28 07:00:00	QQQ	ETF	157.12	157.23	157.1	157.23	16991.0
2017-12-28 07:30:00	QQQ	ETF	157.2	157.2	157.13	157.18	11300.0
2017-12-28 08:00:00	QQQ	ETF	156.54	157.19	156.54	157.1	13339.0
2017-12-28 08:30:00	QQQ	ETF	157.09	157.14	157.04	157.12	28380.0
2017-12-28 09:00:00	QQQ	ETF	157.03	157.06	157.0	157.04	15351.0
2017-12-28 09:30:00	QQQ	ETF	157.05	157.0653	156.82	156.845	1454985.0
2017-12-28 10:00:00	QQQ	ETF	156.85	156.87	156.63	156.655	1026574.0
2017-12-28 10:30:00	QQQ	ETF	156.65	156.77	156.57	156.74	1032098.0
2017-12-28 11:00:00	QQQ	ETF	156.74	156.88	156.69	156.81	947289.0
2017-12-28 11:30:00	QQQ	ETF	156.81	156.88	156.7	156.82	685416.0
2017-12-28 12:00:00	QQQ	ETF	156.82	156.8552	156.78	156.8271	243455.0
2017-12-28 12:30:00	QQQ	ETF	156.825	156.87	156.7638	156.805	535844.0
2017-12-28 13:00:00	QQQ	ETF	156.8	156.81	156.69	156.691	550105.0
2017-12-28 13:30:00	QQQ	ETF	156.695	156.72	156.62	156.685	868694.0
2017-12-28 14:00:00	QQQ	ETF	156.6701	156.69	156.56	156.56	1109989.0

> showing 50 of 15,499 rows — these rows as CSV

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