PREVIEW / stock_30min / 2016-02-18

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-02-18.parquet
  size:    1.5 MB
  rows:    80,705
  symbols: 3,338

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-02-18 04:00:00	AAPL	Stock	24.5	24.535	24.475	24.535	5200.0
2016-02-18 04:30:00	AAPL	Stock	24.565	24.5875	24.5625	24.575	21080.0
2016-02-18 05:00:00	AAPL	Stock	24.585	24.62	24.585	24.62	16436.0
2016-02-18 05:30:00	AAPL	Stock	24.62	24.675	24.62	24.65	21192.0
2016-02-18 06:00:00	AAPL	Stock	24.65	24.715	24.625	24.715	9288.0
2016-02-18 06:30:00	AAPL	Stock	24.695	24.775	24.675	24.75	39328.0
2016-02-18 07:00:00	AAPL	Stock	24.75	24.75	24.6675	24.6675	42528.0
2016-02-18 07:30:00	AAPL	Stock	24.6675	24.675	24.645	24.6625	65280.0
2016-02-18 08:00:00	AAPL	Stock	24.6675	24.775	24.6325	24.6375	156236.0
2016-02-18 08:30:00	AAPL	Stock	24.6425	24.6625	24.605	24.6625	138096.0
2016-02-18 09:00:00	AAPL	Stock	24.6675	24.715	24.62	24.7125	264416.0
2016-02-18 09:30:00	AAPL	Stock	24.71	24.7225	24.4	24.4025	18065876.0
2016-02-18 10:00:00	AAPL	Stock	24.405	24.4125	24.2675	24.365	14006408.0
2016-02-18 10:30:00	AAPL	Stock	24.3655	24.4175	24.2375	24.255	11048832.0
2016-02-18 11:00:00	AAPL	Stock	24.255	24.2875	24.2	24.2675	8502356.0
2016-02-18 11:30:00	AAPL	Stock	24.27	24.28	24.2325	24.275	6483216.0
2016-02-18 12:00:00	AAPL	Stock	24.274	24.2875	24.2175	24.2525	5592248.0
2016-02-18 12:30:00	AAPL	Stock	24.2525	24.2725	24.115	24.19	9170188.0
2016-02-18 13:00:00	AAPL	Stock	24.192	24.25	24.165	24.205	5589392.0
2016-02-18 13:30:00	AAPL	Stock	24.2038	24.22	24.1025	24.17	6693564.0
2016-02-18 14:00:00	AAPL	Stock	24.1725	24.2375	24.1475	24.2275	5236928.0
2016-02-18 14:30:00	AAPL	Stock	24.2275	24.25	24.1875	24.205	5268432.0
2016-02-18 15:00:00	AAPL	Stock	24.2075	24.21	24.055	24.0925	11307352.0
2016-02-18 15:30:00	AAPL	Stock	24.093	24.12	24.0227	24.065	15184092.0
2016-02-18 16:00:00	AAPL	Stock	24.065	24.075	24.0275	24.075	8318792.0
2016-02-18 16:30:00	AAPL	Stock	24.09	24.09	24.0625	24.0675	33360.0
2016-02-18 17:00:00	AAPL	Stock	24.0725	24.075	24.05	24.0625	158984.0
2016-02-18 17:30:00	AAPL	Stock	24.0525	24.105	24.0525	24.0925	40268.0
2016-02-18 18:00:00	AAPL	Stock	24.0975	24.0975	24.07	24.07	20800.0
2016-02-18 18:30:00	AAPL	Stock	24.07	24.075	24.0625	24.075	70480.0
2016-02-18 19:00:00	AAPL	Stock	24.0825	24.0975	24.0825	24.095	30352.0
2016-02-18 19:30:00	AAPL	Stock	24.0925	24.0925	24.055	24.055	62008.0
2016-02-18 06:30:00	MSFT	Stock	52.68	52.68	52.68	52.68	1000.0
2016-02-18 07:00:00	MSFT	Stock	52.6	52.71	52.56	52.65	29625.0
2016-02-18 07:30:00	MSFT	Stock	52.64	52.64	52.6	52.6	200.0
2016-02-18 08:00:00	MSFT	Stock	52.74	52.74	52.65	52.65	1400.0
2016-02-18 08:30:00	MSFT	Stock	52.6	52.62	52.58	52.62	668.0
2016-02-18 09:00:00	MSFT	Stock	52.62	52.64	52.32	52.33	30449.0
2016-02-18 09:30:00	MSFT	Stock	52.32	52.83	52.26	52.695	3574865.0
2016-02-18 10:00:00	MSFT	Stock	52.69	52.95	52.51	52.815	1730445.0
2016-02-18 10:30:00	MSFT	Stock	52.815	52.82	52.47	52.58	1429598.0
2016-02-18 11:00:00	MSFT	Stock	52.58	52.59	52.35	52.55	1482249.0
2016-02-18 11:30:00	MSFT	Stock	52.55	52.62	52.46	52.61	1055965.0
2016-02-18 12:00:00	MSFT	Stock	52.61	52.659	52.51	52.513	1202254.0
2016-02-18 12:30:00	MSFT	Stock	52.515	52.53	52.4	52.465	1372523.0
2016-02-18 13:00:00	MSFT	Stock	52.465	52.6	52.34	52.435	1255328.0
2016-02-18 13:30:00	MSFT	Stock	52.435	52.47	52.16	52.2	1452224.0
2016-02-18 14:00:00	MSFT	Stock	52.2	52.41	52.2	52.375	1482537.0
2016-02-18 14:30:00	MSFT	Stock	52.37	52.56	52.365	52.445	1736200.0
2016-02-18 15:00:00	MSFT	Stock	52.445	52.475	52.14	52.225	1660647.0

> showing 50 of 80,705 rows — these rows as CSV

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