PREVIEW / stock_30min / 2009-07-09

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-07-09.parquet
  size:    1.2 MB
  rows:    68,540
  symbols: 3,328

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
2009-07-09 07:30:00	AAPL	Stock	4.9286	4.9318	4.9286	4.9286	15400.0
2009-07-09 08:00:00	AAPL	Stock	4.9089	4.9286	4.9089	4.9268	410480.0
2009-07-09 08:30:00	AAPL	Stock	4.9286	4.9464	4.925	4.9404	1312360.0
2009-07-09 09:00:00	AAPL	Stock	4.9446	4.9446	4.9143	4.9211	747992.0
2009-07-09 09:30:00	AAPL	Stock	4.9225	4.9282	4.8679	4.8979	78130220.0
2009-07-09 10:00:00	AAPL	Stock	4.8968	4.9071	4.8661	4.8786	37965788.0
2009-07-09 10:30:00	AAPL	Stock	4.8779	4.8875	4.8625	4.8804	27510868.0
2009-07-09 11:00:00	AAPL	Stock	4.8804	4.8868	4.8679	4.8804	17881948.0
2009-07-09 11:30:00	AAPL	Stock	4.8802	4.905	4.8721	4.8939	20607664.0
2009-07-09 12:00:00	AAPL	Stock	4.8939	4.9036	4.8864	4.8907	14198072.0
2009-07-09 12:30:00	AAPL	Stock	4.8911	4.8989	4.8775	4.8982	14320544.0
2009-07-09 13:00:00	AAPL	Stock	4.8982	4.9096	4.8825	4.9041	19720092.0
2009-07-09 13:30:00	AAPL	Stock	4.9043	4.9086	4.8886	4.8949	14762608.0
2009-07-09 14:00:00	AAPL	Stock	4.8954	4.9046	4.8871	4.895	17435768.0
2009-07-09 14:30:00	AAPL	Stock	4.8946	4.9029	4.8886	4.8957	13382460.0
2009-07-09 15:00:00	AAPL	Stock	4.8946	4.8954	4.8804	4.8867	16016560.0
2009-07-09 15:30:00	AAPL	Stock	4.8868	4.8917	4.8546	4.8686	38721172.0
2009-07-09 16:00:00	AAPL	Stock	4.8679	4.8893	4.8546	4.889	8303960.0
2009-07-09 16:30:00	AAPL	Stock	4.8689	4.8725	4.8679	4.8682	64428.0
2009-07-09 17:00:00	AAPL	Stock	4.87	4.87	4.87	4.87	19600.0
2009-07-09 17:30:00	AAPL	Stock	4.8679	4.8696	4.8679	4.8696	15400.0
2009-07-09 18:00:00	AAPL	Stock	4.8679	4.87	4.8679	4.87	165900.0
2009-07-09 18:30:00	AAPL	Stock	4.8696	4.8707	4.8696	4.87	55720.0
2009-07-09 19:00:00	AAPL	Stock	4.8707	4.8707	4.8707	4.8707	19488.0
2009-07-09 19:30:00	AAPL	Stock	4.8707	4.8707	4.8682	4.8707	43064.0
2009-07-09 08:00:00	MSFT	Stock	22.52	22.65	22.43	22.65	1900.0
2009-07-09 08:30:00	MSFT	Stock	22.65	22.75	22.65	22.75	80211.0
2009-07-09 09:00:00	MSFT	Stock	22.74	22.75	22.64	22.64	35256.0
2009-07-09 09:30:00	MSFT	Stock	22.65	22.81	22.535	22.55	7089941.0
2009-07-09 10:00:00	MSFT	Stock	22.54	22.6	22.45	22.55	4163053.0
2009-07-09 10:30:00	MSFT	Stock	22.56	22.605	22.49	22.577	3012782.0
2009-07-09 11:00:00	MSFT	Stock	22.58	22.58	22.45	22.51	3439864.0
2009-07-09 11:30:00	MSFT	Stock	22.51	22.66	22.5	22.541	2780962.0
2009-07-09 12:00:00	MSFT	Stock	22.54	22.57	22.5	22.5	1381605.0
2009-07-09 12:30:00	MSFT	Stock	22.51	22.51	22.43	22.48	2099674.0
2009-07-09 13:00:00	MSFT	Stock	22.47	22.58	22.41	22.54	2088654.0
2009-07-09 13:30:00	MSFT	Stock	22.55	22.55	22.43	22.438	2109066.0
2009-07-09 14:00:00	MSFT	Stock	22.43	22.55	22.41	22.53	3603476.0
2009-07-09 14:30:00	MSFT	Stock	22.53	22.59	22.48	22.54	3367639.0
2009-07-09 15:00:00	MSFT	Stock	22.545	22.55	22.43	22.453	2476711.0
2009-07-09 15:30:00	MSFT	Stock	22.45	22.52	22.37	22.44	6168696.0
2009-07-09 16:00:00	MSFT	Stock	22.44	22.556	22.42	22.529	2117250.0
2009-07-09 16:30:00	MSFT	Stock	22.46	22.46	22.39	22.4	27435.0
2009-07-09 17:00:00	MSFT	Stock	22.39	22.39	22.3	22.36	33536.0
2009-07-09 17:30:00	MSFT	Stock	22.35	22.35	22.34	22.34	1100.0
2009-07-09 18:00:00	MSFT	Stock	22.36	22.44	22.33	22.34	5313.0
2009-07-09 18:30:00	MSFT	Stock	22.34	22.34	22.34	22.34	6150.0
2009-07-09 19:00:00	MSFT	Stock	22.35	22.36	22.35	22.36	1040.0
2009-07-09 19:30:00	MSFT	Stock	22.36	22.36	22.34	22.34	3789.0
2009-07-09 08:00:00	NVDA	Stock	0.255	0.255	0.255	0.255	20000.0

> showing 50 of 68,540 rows — these rows as CSV

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