PREVIEW / stock_30min / 2007-12-03

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-12-03.parquet
  size:    1.2 MB
  rows:    69,744
  symbols: 3,223

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-12-03 04:00:00	AAPL	Stock	6.4929	6.4929	6.4929	6.4929	12544.0
2007-12-03 06:00:00	AAPL	Stock	6.4696	6.4696	6.4696	6.4696	36400.0
2007-12-03 06:30:00	AAPL	Stock	6.4875	6.5	6.4718	6.4975	28000.0
2007-12-03 07:00:00	AAPL	Stock	6.5061	6.5161	6.5039	6.5039	99540.0
2007-12-03 07:30:00	AAPL	Stock	6.5004	6.5071	6.4732	6.5071	106120.0
2007-12-03 08:00:00	AAPL	Stock	6.4964	6.5464	6.4964	6.5096	2410072.0
2007-12-03 08:30:00	AAPL	Stock	6.5089	6.5179	6.475	6.4757	1772680.0
2007-12-03 09:00:00	AAPL	Stock	6.4786	6.5	6.4579	6.4921	3884972.0
2007-12-03 09:30:00	AAPL	Stock	6.495	6.4964	6.3882	6.3986	130244884.0
2007-12-03 10:00:00	AAPL	Stock	6.3989	6.4625	6.3846	6.4496	97764100.0
2007-12-03 10:30:00	AAPL	Stock	6.4504	6.5357	6.4407	6.5271	91731304.0
2007-12-03 11:00:00	AAPL	Stock	6.5275	6.5504	6.5004	6.5411	60784584.0
2007-12-03 11:30:00	AAPL	Stock	6.5411	6.5764	6.5168	6.5307	67206692.0
2007-12-03 12:00:00	AAPL	Stock	6.53	6.5339	6.485	6.5079	50498700.0
2007-12-03 12:30:00	AAPL	Stock	6.5075	6.5289	6.4757	6.4764	37548252.0
2007-12-03 13:00:00	AAPL	Stock	6.4761	6.4818	6.4414	6.4529	56035448.0
2007-12-03 13:30:00	AAPL	Stock	6.4521	6.4593	6.4232	6.4486	55766732.0
2007-12-03 14:00:00	AAPL	Stock	6.4486	6.4732	6.4464	6.4482	38494288.0
2007-12-03 14:30:00	AAPL	Stock	6.4479	6.4607	6.4157	6.4589	49431172.0
2007-12-03 15:00:00	AAPL	Stock	6.4582	6.4614	6.4	6.4239	78141980.0
2007-12-03 15:30:00	AAPL	Stock	6.4239	6.435	6.3464	6.3921	111859972.0
2007-12-03 16:00:00	AAPL	Stock	6.3921	6.547	6.3877	6.3929	18416944.0
2007-12-03 16:30:00	AAPL	Stock	6.395	6.3964	6.3879	6.3943	732032.0
2007-12-03 17:00:00	AAPL	Stock	6.3964	6.4607	6.3879	6.3979	7398776.0
2007-12-03 17:30:00	AAPL	Stock	6.3943	6.3964	6.3918	6.3946	244524.0
2007-12-03 18:00:00	AAPL	Stock	6.3971	6.4036	6.3929	6.4036	139832.0
2007-12-03 18:30:00	AAPL	Stock	6.4032	6.4071	6.3929	6.3929	209020.0
2007-12-03 19:00:00	AAPL	Stock	6.3929	6.3957	6.3918	6.3957	37800.0
2007-12-03 19:30:00	AAPL	Stock	6.3932	6.3982	6.3857	6.3982	456820.0
2007-12-03 08:00:00	MSFT	Stock	33.5	33.6	33.5	33.53	21696.0
2007-12-03 08:30:00	MSFT	Stock	33.53	33.69	33.53	33.55	13193.0
2007-12-03 09:00:00	MSFT	Stock	33.6	33.61	33.5	33.57	25922.0
2007-12-03 09:30:00	MSFT	Stock	33.5	33.64	33.36	33.49	5495892.0
2007-12-03 10:00:00	MSFT	Stock	33.5	33.54	33.22	33.22	4010811.0
2007-12-03 10:30:00	MSFT	Stock	33.23	33.51	33.22	33.4	4515787.0
2007-12-03 11:00:00	MSFT	Stock	33.402	33.45	33.33	33.45	2733158.0
2007-12-03 11:30:00	MSFT	Stock	33.442	33.5	33.39	33.43	3182904.0
2007-12-03 12:00:00	MSFT	Stock	33.43	33.47	33.39	33.47	1513894.0
2007-12-03 12:30:00	MSFT	Stock	33.47	33.49	33.4	33.4	1622346.0
2007-12-03 13:00:00	MSFT	Stock	33.4	33.41	33.14	33.17	3096968.0
2007-12-03 13:30:00	MSFT	Stock	33.17	33.17	32.9	32.96	6530271.0
2007-12-03 14:00:00	MSFT	Stock	32.95	33.08	32.9	32.91	2700715.0
2007-12-03 14:30:00	MSFT	Stock	32.9	32.91	32.68	32.83	7302846.0
2007-12-03 15:00:00	MSFT	Stock	32.84	32.95	32.75	32.92	5556071.0
2007-12-03 15:30:00	MSFT	Stock	32.93	32.99	32.78	32.94	8876847.0
2007-12-03 16:00:00	MSFT	Stock	32.93	33.135	32.876	33.124	3942380.0
2007-12-03 16:30:00	MSFT	Stock	32.93	33.37	32.92	32.92	543928.0
2007-12-03 17:00:00	MSFT	Stock	32.97	33.196	32.77	32.91	35105.0
2007-12-03 17:30:00	MSFT	Stock	32.84	32.87	32.83	32.87	672.0
2007-12-03 18:00:00	MSFT	Stock	32.9	32.9	32.9	32.9	1100.0

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

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