PREVIEW / stock_30min / 2018-01-09

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-01-09.parquet
  size:    1.7 MB
  rows:    84,638
  symbols: 2,909

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
2018-01-09 04:30:00	AAPL	Stock	43.6975	43.6975	43.6275	43.6275	2044.0
2018-01-09 05:30:00	AAPL	Stock	43.625	43.625	43.625	43.625	400.0
2018-01-09 06:00:00	AAPL	Stock	43.6	43.6625	43.5875	43.6	37800.0
2018-01-09 06:30:00	AAPL	Stock	43.65	43.65	43.6325	43.6325	1600.0
2018-01-09 07:00:00	AAPL	Stock	43.625	43.675	43.625	43.6575	34912.0
2018-01-09 07:30:00	AAPL	Stock	43.6525	43.6675	43.595	43.635	104856.0
2018-01-09 08:00:00	AAPL	Stock	43.675	43.68	43.6	43.675	82480.0
2018-01-09 08:30:00	AAPL	Stock	43.665	43.7225	43.65	43.68	131192.0
2018-01-09 09:00:00	AAPL	Stock	43.68	43.695	43.6275	43.64	151964.0
2018-01-09 09:30:00	AAPL	Stock	43.6375	43.7125	43.3525	43.405	14692096.0
2018-01-09 10:00:00	AAPL	Stock	43.4075	43.5462	43.3525	43.45	7438300.0
2018-01-09 10:30:00	AAPL	Stock	43.4525	43.515	43.3875	43.5025	4995160.0
2018-01-09 11:00:00	AAPL	Stock	43.505	43.6075	43.495	43.5475	4881340.0
2018-01-09 11:30:00	AAPL	Stock	43.545	43.6525	43.4812	43.635	3885880.0
2018-01-09 12:00:00	AAPL	Stock	43.6375	43.7275	43.5875	43.687	4355396.0
2018-01-09 12:30:00	AAPL	Stock	43.6862	43.72	43.6625	43.695	3030208.0
2018-01-09 13:00:00	AAPL	Stock	43.695	43.765	43.675	43.735	3692316.0
2018-01-09 13:30:00	AAPL	Stock	43.7375	43.75	43.68	43.6875	3098060.0
2018-01-09 14:00:00	AAPL	Stock	43.69	43.6925	43.61	43.63	3154364.0
2018-01-09 14:30:00	AAPL	Stock	43.6292	43.6975	43.6175	43.6975	2855132.0
2018-01-09 15:00:00	AAPL	Stock	43.6962	43.7025	43.5625	43.566	3299244.0
2018-01-09 15:30:00	AAPL	Stock	43.565	43.625	43.55	43.5825	9683700.0
2018-01-09 16:00:00	AAPL	Stock	43.5825	43.5875	43.4775	43.53	5815948.0
2018-01-09 16:30:00	AAPL	Stock	43.51	43.5175	43.4825	43.5175	47476.0
2018-01-09 17:00:00	AAPL	Stock	43.5125	43.525	43.5	43.5175	27404.0
2018-01-09 17:30:00	AAPL	Stock	43.5175	43.5225	43.5	43.5	11748.0
2018-01-09 18:00:00	AAPL	Stock	43.49	43.5225	43.4875	43.5175	27356.0
2018-01-09 18:30:00	AAPL	Stock	43.5175	43.525	43.5125	43.5125	17176.0
2018-01-09 19:00:00	AAPL	Stock	43.51	43.52	43.51	43.52	2160.0
2018-01-09 19:30:00	AAPL	Stock	43.5175	43.52	43.5	43.5	16964.0
2018-01-09 06:00:00	MSFT	Stock	88.28	88.28	88.28	88.28	500.0
2018-01-09 07:00:00	MSFT	Stock	88.37	88.52	88.35	88.5	7935.0
2018-01-09 07:30:00	MSFT	Stock	88.57	88.57	88.57	88.57	173.0
2018-01-09 08:00:00	MSFT	Stock	88.59	88.59	88.51	88.54	2864.0
2018-01-09 08:30:00	MSFT	Stock	88.55	88.55	88.53	88.55	7753.0
2018-01-09 09:00:00	MSFT	Stock	88.51	88.75	88.39	88.66	29620.0
2018-01-09 09:30:00	MSFT	Stock	88.65	88.66	87.86	87.98	3298076.0
2018-01-09 10:00:00	MSFT	Stock	87.98	88.34	87.95	88.32	1079270.0
2018-01-09 10:30:00	MSFT	Stock	88.32	88.485	88.15	88.48	1174354.0
2018-01-09 11:00:00	MSFT	Stock	88.48	88.7	88.471	88.645	1016949.0
2018-01-09 11:30:00	MSFT	Stock	88.64	88.64	88.39	88.415	742979.0
2018-01-09 12:00:00	MSFT	Stock	88.416	88.5	88.21	88.45	980163.0
2018-01-09 12:30:00	MSFT	Stock	88.45	88.56	88.44	88.56	549762.0
2018-01-09 13:00:00	MSFT	Stock	88.56	88.72	88.56	88.72	639351.0
2018-01-09 13:30:00	MSFT	Stock	88.727	88.727	88.46	88.49	841290.0
2018-01-09 14:00:00	MSFT	Stock	88.49	88.51	88.35	88.37	644469.0
2018-01-09 14:30:00	MSFT	Stock	88.365	88.39	88.31	88.32	852852.0
2018-01-09 15:00:00	MSFT	Stock	88.32	88.35	88.21	88.21	950482.0
2018-01-09 15:30:00	MSFT	Stock	88.215	88.27	88.04	88.23	2783467.0
2018-01-09 16:00:00	MSFT	Stock	88.22	88.28	88.12	88.12	2309714.0

> showing 50 of 84,638 rows — these rows as CSV

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