PREVIEW / stock_30min / 2009-04-27

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-04-27.parquet
  size:    1.3 MB
  rows:    70,968
  symbols: 3,329

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-04-27 04:00:00	AAPL	Stock	4.4107	4.4107	4.3961	4.3961	10080.0
2009-04-27 06:00:00	AAPL	Stock	4.3921	4.3921	4.3921	4.3921	28000.0
2009-04-27 06:30:00	AAPL	Stock	4.365	4.365	4.365	4.365	2800.0
2009-04-27 07:00:00	AAPL	Stock	4.37	4.3718	4.37	4.3718	16800.0
2009-04-27 07:30:00	AAPL	Stock	4.3857	4.3857	4.3857	4.3857	3332.0
2009-04-27 08:00:00	AAPL	Stock	4.3779	4.4214	4.375	4.3861	301700.0
2009-04-27 08:30:00	AAPL	Stock	4.39	4.3996	4.3836	4.3943	255976.0
2009-04-27 09:00:00	AAPL	Stock	4.3929	4.3989	4.3739	4.3846	1364412.0
2009-04-27 09:30:00	AAPL	Stock	4.3857	4.4321	4.3807	4.3982	67902744.0
2009-04-27 10:00:00	AAPL	Stock	4.3989	4.4511	4.3857	4.4354	50269016.0
2009-04-27 10:30:00	AAPL	Stock	4.4357	4.4643	4.4111	4.4604	35509460.0
2009-04-27 11:00:00	AAPL	Stock	4.4614	4.4643	4.4325	4.4486	27727392.0
2009-04-27 11:30:00	AAPL	Stock	4.4486	4.4625	4.4364	4.4475	20136088.0
2009-04-27 12:00:00	AAPL	Stock	4.4475	4.4546	4.4404	4.4521	19118064.0
2009-04-27 12:30:00	AAPL	Stock	4.4521	4.4525	4.4364	4.4435	15593424.0
2009-04-27 13:00:00	AAPL	Stock	4.4439	4.4507	4.4357	4.4389	17274208.0
2009-04-27 13:30:00	AAPL	Stock	4.4389	4.4446	4.43	4.4407	20690012.0
2009-04-27 14:00:00	AAPL	Stock	4.4397	4.4518	4.43	4.4411	25210416.0
2009-04-27 14:30:00	AAPL	Stock	4.4425	4.4517	4.4389	4.4454	19475848.0
2009-04-27 15:00:00	AAPL	Stock	4.4454	4.4546	4.4375	4.451	32592308.0
2009-04-27 15:30:00	AAPL	Stock	4.4507	4.4643	4.4464	4.4546	66877636.0
2009-04-27 16:00:00	AAPL	Stock	4.4579	4.4589	4.4363	4.4554	16057552.0
2009-04-27 16:30:00	AAPL	Stock	4.4536	4.457	4.4461	4.4461	134652.0
2009-04-27 17:00:00	AAPL	Stock	4.4501	4.4568	4.4461	4.4493	56196.0
2009-04-27 17:30:00	AAPL	Stock	4.4493	4.4493	4.4493	4.4493	2800.0
2009-04-27 18:00:00	AAPL	Stock	4.4479	4.4546	4.4475	4.4475	231588.0
2009-04-27 18:30:00	AAPL	Stock	4.4475	4.4475	4.4468	4.4468	29820.0
2009-04-27 19:00:00	AAPL	Stock	4.4486	4.4486	4.4461	4.4461	23240.0
2009-04-27 19:30:00	AAPL	Stock	4.4464	4.4496	4.4464	4.4471	21672.0
2009-04-27 20:00:00	AAPL	Stock	4.4468	4.4468	4.4468	4.4468	20580.0
2009-04-27 06:00:00	MSFT	Stock	20.25	20.25	20.25	20.25	100.0
2009-04-27 06:30:00	MSFT	Stock	20.2	20.3	20.2	20.2	5100.0
2009-04-27 07:00:00	MSFT	Stock	20.27	20.45	20.26	20.45	800.0
2009-04-27 07:30:00	MSFT	Stock	20.5	20.55	20.46	20.51	19874.0
2009-04-27 08:00:00	MSFT	Stock	20.47	20.75	20.47	20.66	38756.0
2009-04-27 08:30:00	MSFT	Stock	20.7	20.75	20.65	20.66	45026.0
2009-04-27 09:00:00	MSFT	Stock	20.69	20.84	20.51	20.55	127920.0
2009-04-27 09:30:00	MSFT	Stock	20.55	20.71	20.44	20.53	9775003.0
2009-04-27 10:00:00	MSFT	Stock	20.52	20.73	20.45	20.63	6607217.0
2009-04-27 10:30:00	MSFT	Stock	20.63	20.79	20.59	20.79	4085537.0
2009-04-27 11:00:00	MSFT	Stock	20.789	20.82	20.62	20.66	3245836.0
2009-04-27 11:30:00	MSFT	Stock	20.66	20.68	20.6	20.62	2058159.0
2009-04-27 12:00:00	MSFT	Stock	20.62	20.71	20.6	20.62	2136919.0
2009-04-27 12:30:00	MSFT	Stock	20.62	20.65	20.5	20.561	2424132.0
2009-04-27 13:00:00	MSFT	Stock	20.56	20.59	20.41	20.41	2686524.0
2009-04-27 13:30:00	MSFT	Stock	20.41	20.45	20.28	20.35	4591441.0
2009-04-27 14:00:00	MSFT	Stock	20.35	20.48	20.3	20.45	4076646.0
2009-04-27 14:30:00	MSFT	Stock	20.44	20.54	20.4	20.41	3099109.0
2009-04-27 15:00:00	MSFT	Stock	20.41	20.44	20.31	20.37	3732067.0
2009-04-27 15:30:00	MSFT	Stock	20.37	20.5	20.35	20.37	8420900.0

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

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