PREVIEW / stock_30min / 2010-01-14

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-01-14.parquet
  size:    1.3 MB
  rows:    71,873
  symbols: 3,439

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
2010-01-14 04:30:00	AAPL	Stock	7.5411	7.5411	7.5411	7.5411	2800.0
2010-01-14 06:00:00	AAPL	Stock	7.5439	7.5439	7.5439	7.5439	8400.0
2010-01-14 06:30:00	AAPL	Stock	7.5357	7.5357	7.5357	7.5357	2800.0
2010-01-14 07:00:00	AAPL	Stock	7.5529	7.5529	7.5529	7.5529	5600.0
2010-01-14 07:30:00	AAPL	Stock	7.5364	7.5364	7.5193	7.5321	175084.0
2010-01-14 08:00:00	AAPL	Stock	7.5261	7.5464	7.5193	7.525	1026004.0
2010-01-14 08:30:00	AAPL	Stock	7.5229	7.5289	7.5029	7.5079	1151052.0
2010-01-14 09:00:00	AAPL	Stock	7.5082	7.5179	7.5	7.5014	1045716.0
2010-01-14 09:30:00	AAPL	Stock	7.5039	7.5164	7.465	7.4771	79319408.0
2010-01-14 10:00:00	AAPL	Stock	7.4771	7.5121	7.4721	7.4975	52868452.0
2010-01-14 10:30:00	AAPL	Stock	7.4979	7.5079	7.4689	7.4776	34391140.0
2010-01-14 11:00:00	AAPL	Stock	7.4768	7.4911	7.4664	7.4889	30012640.0
2010-01-14 11:30:00	AAPL	Stock	7.4886	7.4936	7.4729	7.4768	27909140.0
2010-01-14 12:00:00	AAPL	Stock	7.4775	7.4986	7.476	7.4946	21195076.0
2010-01-14 12:30:00	AAPL	Stock	7.4945	7.4993	7.4836	7.4889	12516812.0
2010-01-14 13:00:00	AAPL	Stock	7.4882	7.4911	7.4696	7.4711	17258304.0
2010-01-14 13:30:00	AAPL	Stock	7.4706	7.4857	7.4706	7.4793	13274240.0
2010-01-14 14:00:00	AAPL	Stock	7.4793	7.4886	7.4793	7.4843	9170728.0
2010-01-14 14:30:00	AAPL	Stock	7.485	7.5104	7.4789	7.4989	27511820.0
2010-01-14 15:00:00	AAPL	Stock	7.4982	7.5118	7.4893	7.4989	27426112.0
2010-01-14 15:30:00	AAPL	Stock	7.4993	7.5029	7.4725	7.4793	40570432.0
2010-01-14 16:00:00	AAPL	Stock	7.4889	7.5268	7.473	7.5071	8852200.0
2010-01-14 16:30:00	AAPL	Stock	7.5071	7.5121	7.4964	7.5	1042496.0
2010-01-14 17:00:00	AAPL	Stock	7.4745	7.505	7.4745	7.4982	342580.0
2010-01-14 17:30:00	AAPL	Stock	7.495	7.4986	7.4879	7.4986	179200.0
2010-01-14 18:00:00	AAPL	Stock	7.4982	7.4986	7.4796	7.4979	289324.0
2010-01-14 18:30:00	AAPL	Stock	7.4936	7.4968	7.4929	7.4957	50456.0
2010-01-14 19:00:00	AAPL	Stock	7.4971	7.5029	7.4929	7.5029	74872.0
2010-01-14 19:30:00	AAPL	Stock	7.5	7.5036	7.5	7.5	89124.0
2010-01-14 07:30:00	MSFT	Stock	30.43	30.46	30.43	30.46	6200.0
2010-01-14 08:00:00	MSFT	Stock	30.45	30.48	30.4	30.43	8940.0
2010-01-14 08:30:00	MSFT	Stock	30.43	30.47	30.36	30.36	12673.0
2010-01-14 09:00:00	MSFT	Stock	30.36	30.41	30.28	30.28	40440.0
2010-01-14 09:30:00	MSFT	Stock	30.31	30.765	30.26	30.64	7273662.0
2010-01-14 10:00:00	MSFT	Stock	30.64	30.77	30.61	30.728	3526678.0
2010-01-14 10:30:00	MSFT	Stock	30.72	30.745	30.63	30.63	4118984.0
2010-01-14 11:00:00	MSFT	Stock	30.64	30.75	30.59	30.72	3648132.0
2010-01-14 11:30:00	MSFT	Stock	30.711	30.74	30.55	30.55	4412820.0
2010-01-14 12:00:00	MSFT	Stock	30.56	30.75	30.55	30.75	3129159.0
2010-01-14 12:30:00	MSFT	Stock	30.74	30.83	30.72	30.823	3322141.0
2010-01-14 13:00:00	MSFT	Stock	30.82	30.96	30.82	30.94	3783938.0
2010-01-14 13:30:00	MSFT	Stock	30.94	31.09	30.94	31.0	5748722.0
2010-01-14 14:00:00	MSFT	Stock	31.01	31.07	30.99	31.01	2893910.0
2010-01-14 14:30:00	MSFT	Stock	31.02	31.09	31.0	31.06	3053228.0
2010-01-14 15:00:00	MSFT	Stock	31.07	31.1	31.05	31.062	3504205.0
2010-01-14 15:30:00	MSFT	Stock	31.06	31.09	30.96	30.97	8629685.0
2010-01-14 16:00:00	MSFT	Stock	30.97	31.29	30.331	31.18	4092506.0
2010-01-14 16:30:00	MSFT	Stock	31.052	31.26	31.052	31.17	237452.0
2010-01-14 17:00:00	MSFT	Stock	30.35	31.27	30.35	31.19	84045.0
2010-01-14 17:30:00	MSFT	Stock	31.2	31.2	31.12	31.18	13920.0

> showing 50 of 71,873 rows — these rows as CSV

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