PREVIEW / stock_30min / 2008-10-22

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-10-22.parquet
  size:    1.2 MB
  rows:    70,203
  symbols: 3,319

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
2008-10-22 04:00:00	AAPL	Stock	3.5711	3.6071	3.5711	3.5929	11200.0
2008-10-22 04:30:00	AAPL	Stock	3.5929	3.5929	3.5893	3.5893	42000.0
2008-10-22 05:00:00	AAPL	Stock	3.5832	3.5832	3.5714	3.5714	54040.0
2008-10-22 05:30:00	AAPL	Stock	3.5779	3.5786	3.56	3.5786	18480.0
2008-10-22 06:00:00	AAPL	Stock	3.5725	3.6214	3.5725	3.6018	300440.0
2008-10-22 06:30:00	AAPL	Stock	3.6007	3.6007	3.5607	3.5714	1184008.0
2008-10-22 07:00:00	AAPL	Stock	3.5714	3.575	3.475	3.5179	4137588.0
2008-10-22 07:30:00	AAPL	Stock	3.5125	3.5607	3.5018	3.5296	7826336.0
2008-10-22 08:00:00	AAPL	Stock	3.5893	3.6286	3.4946	3.5832	26051200.0
2008-10-22 08:30:00	AAPL	Stock	3.5829	3.5954	3.5232	3.5236	21138964.0
2008-10-22 09:00:00	AAPL	Stock	3.5239	3.5593	3.45	3.4782	37111368.0
2008-10-22 09:30:00	AAPL	Stock	3.4825	3.6161	3.4386	3.5489	482838664.0
2008-10-22 10:00:00	AAPL	Stock	3.5479	3.5632	3.4625	3.4779	245345520.0
2008-10-22 10:30:00	AAPL	Stock	3.4779	3.5586	3.4643	3.5414	178924200.0
2008-10-22 11:00:00	AAPL	Stock	3.5414	3.5414	3.4804	3.4911	119450940.0
2008-10-22 11:30:00	AAPL	Stock	3.4911	3.56	3.4811	3.5321	113223292.0
2008-10-22 12:00:00	AAPL	Stock	3.5304	3.5661	3.5161	3.5443	78510768.0
2008-10-22 12:30:00	AAPL	Stock	3.5443	3.5536	3.5271	3.5364	68474672.0
2008-10-22 13:00:00	AAPL	Stock	3.535	3.5357	3.4736	3.4886	99457372.0
2008-10-22 13:30:00	AAPL	Stock	3.4889	3.4996	3.4643	3.4893	87111752.0
2008-10-22 14:00:00	AAPL	Stock	3.4893	3.4986	3.4643	3.4857	90640032.0
2008-10-22 14:30:00	AAPL	Stock	3.4844	3.4875	3.4061	3.4393	154161364.0
2008-10-22 15:00:00	AAPL	Stock	3.4379	3.4536	3.3761	3.3861	135756768.0
2008-10-22 15:30:00	AAPL	Stock	3.3857	3.4643	3.3189	3.4539	240366084.0
2008-10-22 16:00:00	AAPL	Stock	3.4561	3.544	3.3876	3.4511	34578768.0
2008-10-22 16:30:00	AAPL	Stock	3.4511	3.471	3.4109	3.4393	1244404.0
2008-10-22 17:00:00	AAPL	Stock	3.4379	3.4414	3.4143	3.4321	1006236.0
2008-10-22 17:30:00	AAPL	Stock	3.4286	3.4339	3.4223	3.4321	272216.0
2008-10-22 18:00:00	AAPL	Stock	3.4293	3.4418	3.4232	3.4375	347592.0
2008-10-22 18:30:00	AAPL	Stock	3.4375	3.4464	3.4339	3.4464	204932.0
2008-10-22 19:00:00	AAPL	Stock	3.44	3.4464	3.4286	3.4329	211400.0
2008-10-22 19:30:00	AAPL	Stock	3.4375	3.4464	3.4282	3.4368	627620.0
2008-10-22 20:00:00	AAPL	Stock	3.4996	3.4996	3.4996	3.4996	470400.0
2008-10-22 04:30:00	MSFT	Stock	23.55	23.55	23.55	23.55	200.0
2008-10-22 05:30:00	MSFT	Stock	23.37	23.37	23.37	23.37	100.0
2008-10-22 06:30:00	MSFT	Stock	23.37	23.37	23.37	23.37	100.0
2008-10-22 07:00:00	MSFT	Stock	23.4	23.4	23.23	23.23	4938.0
2008-10-22 07:30:00	MSFT	Stock	23.19	23.4	23.19	23.4	10802.0
2008-10-22 08:00:00	MSFT	Stock	23.4	23.65	23.4	23.6	27915.0
2008-10-22 08:30:00	MSFT	Stock	23.6	23.65	23.21	23.26	103790.0
2008-10-22 09:00:00	MSFT	Stock	23.25	23.26	23.03	23.05	152309.0
2008-10-22 09:30:00	MSFT	Stock	23.03	23.06	22.42	22.49	13483652.0
2008-10-22 10:00:00	MSFT	Stock	22.48	22.64	22.2	22.43	11490911.0
2008-10-22 10:30:00	MSFT	Stock	22.42	22.59	22.3	22.5	8776075.0
2008-10-22 11:00:00	MSFT	Stock	22.49	22.5	22.07	22.16	6428022.0
2008-10-22 11:30:00	MSFT	Stock	22.16	22.35	22.13	22.32	6402016.0
2008-10-22 12:00:00	MSFT	Stock	22.308	22.55	22.25	22.39	7147092.0
2008-10-22 12:30:00	MSFT	Stock	22.39	22.52	22.3	22.488	4477853.0
2008-10-22 13:00:00	MSFT	Stock	22.48	22.482	22.03	22.11	5085291.0
2008-10-22 13:30:00	MSFT	Stock	22.108	22.15	22.0	22.098	7013570.0

> showing 50 of 70,203 rows — these rows as CSV

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