PREVIEW / stock_30min / 2007-11-12

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-11-12.parquet
  size:    1.2 MB
  rows:    69,075
  symbols: 3,175

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
2007-11-12 04:30:00	AAPL	Stock	5.9282	5.9282	5.9282	5.9282	16800.0
2007-11-12 05:00:00	AAPL	Stock	5.9329	5.9329	5.9329	5.9329	11200.0
2007-11-12 05:30:00	AAPL	Stock	5.9332	5.9332	5.9332	5.9332	3640.0
2007-11-12 06:00:00	AAPL	Stock	5.9464	5.9464	5.9107	5.9279	142044.0
2007-11-12 07:00:00	AAPL	Stock	5.9279	5.9429	5.9039	5.9261	368676.0
2007-11-12 07:30:00	AAPL	Stock	5.9268	5.9375	5.8982	5.9089	414876.0
2007-11-12 08:00:00	AAPL	Stock	5.9089	5.9393	5.8318	5.8846	4292148.0
2007-11-12 08:30:00	AAPL	Stock	5.8857	5.9789	5.8796	5.9682	8241968.0
2007-11-12 09:00:00	AAPL	Stock	5.9707	5.9707	5.8911	5.9007	5545568.0
2007-11-12 09:30:00	AAPL	Stock	5.9036	5.9893	5.7704	5.9007	218063608.0
2007-11-12 10:00:00	AAPL	Stock	5.8989	5.9008	5.7396	5.82	139470436.0
2007-11-12 10:30:00	AAPL	Stock	5.8179	5.9107	5.8036	5.8679	102756388.0
2007-11-12 11:00:00	AAPL	Stock	5.87	5.9107	5.8429	5.8914	93108148.0
2007-11-12 11:30:00	AAPL	Stock	5.8929	5.9114	5.8429	5.8564	70698712.0
2007-11-12 12:00:00	AAPL	Stock	5.8554	5.8761	5.835	5.8571	57231188.0
2007-11-12 12:30:00	AAPL	Stock	5.8579	5.8686	5.7575	5.7696	61423040.0
2007-11-12 13:00:00	AAPL	Stock	5.7714	5.8005	5.7089	5.7957	96527116.0
2007-11-12 13:30:00	AAPL	Stock	5.7961	5.7968	5.5889	5.6143	154828380.0
2007-11-12 14:00:00	AAPL	Stock	5.615	5.6307	5.5079	5.5986	180019196.0
2007-11-12 14:30:00	AAPL	Stock	5.5971	5.6818	5.5929	5.635	142537696.0
2007-11-12 15:00:00	AAPL	Stock	5.6357	5.6464	5.5254	5.5382	148154216.0
2007-11-12 15:30:00	AAPL	Stock	5.5382	5.5936	5.3796	5.4875	246744176.0
2007-11-12 16:00:00	AAPL	Stock	5.4875	5.9625	5.4788	5.5036	31182760.0
2007-11-12 16:30:00	AAPL	Stock	5.5107	5.5179	5.4714	5.48	2113020.0
2007-11-12 17:00:00	AAPL	Stock	5.6634	5.6634	5.4504	5.4643	1366708.0
2007-11-12 17:30:00	AAPL	Stock	5.4643	5.7106	5.425	5.4393	920640.0
2007-11-12 18:00:00	AAPL	Stock	5.45	5.4536	5.3932	5.4107	811244.0
2007-11-12 18:30:00	AAPL	Stock	5.4107	5.4143	5.3929	5.4004	761488.0
2007-11-12 19:00:00	AAPL	Stock	5.4018	5.4143	5.3929	5.4089	473396.0
2007-11-12 19:30:00	AAPL	Stock	5.4057	5.4457	5.4057	5.4411	865396.0
2007-11-12 05:30:00	MSFT	Stock	33.73	33.73	33.73	33.73	100.0
2007-11-12 06:00:00	MSFT	Stock	33.73	33.73	33.73	33.73	100.0
2007-11-12 06:30:00	MSFT	Stock	34.0	34.0	34.0	34.0	100.0
2007-11-12 07:00:00	MSFT	Stock	33.8	33.8	33.35	33.45	82581.0
2007-11-12 07:30:00	MSFT	Stock	33.45	33.51	33.4	33.4	43900.0
2007-11-12 08:00:00	MSFT	Stock	33.4	33.73	33.31	33.45	1721481.0
2007-11-12 08:30:00	MSFT	Stock	33.45	33.56	33.4	33.55	65857.0
2007-11-12 09:00:00	MSFT	Stock	33.54	33.54	33.28	33.35	150542.0
2007-11-12 09:30:00	MSFT	Stock	33.32	33.55	33.02	33.43	11619043.0
2007-11-12 10:00:00	MSFT	Stock	33.43	33.53	33.28	33.52	5675832.0
2007-11-12 10:30:00	MSFT	Stock	33.51	33.55	33.23	33.519	5175892.0
2007-11-12 11:00:00	MSFT	Stock	33.511	33.7	33.49	33.69	5040126.0
2007-11-12 11:30:00	MSFT	Stock	33.7	33.71	33.42	33.49	3832297.0
2007-11-12 12:00:00	MSFT	Stock	33.48	33.6	33.48	33.53	3170522.0
2007-11-12 12:30:00	MSFT	Stock	33.54	33.67	33.38	33.41	4781297.0
2007-11-12 13:00:00	MSFT	Stock	33.4	33.55	33.38	33.44	4412117.0
2007-11-12 13:30:00	MSFT	Stock	33.43	33.5	33.36	33.39	5752257.0
2007-11-12 14:00:00	MSFT	Stock	33.39	33.53	33.35	33.5	4804561.0
2007-11-12 14:30:00	MSFT	Stock	33.5	33.7	33.45	33.63	5773786.0
2007-11-12 15:00:00	MSFT	Stock	33.63	33.639	33.38	33.5	5760054.0

> showing 50 of 69,075 rows — these rows as CSV

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