PREVIEW / stock_30min / 2008-10-23

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-10-23.parquet
  size:    1.2 MB
  rows:    69,632
  symbols: 3,312

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-23 04:00:00	AAPL	Stock	3.4643	3.5	3.4643	3.5	16800.0
2008-10-23 07:00:00	AAPL	Stock	3.4536	3.4643	3.4464	3.4464	75740.0
2008-10-23 07:30:00	AAPL	Stock	3.4286	3.4632	3.395	3.4125	148680.0
2008-10-23 08:00:00	AAPL	Stock	3.4107	3.4289	3.4	3.4289	998844.0
2008-10-23 08:30:00	AAPL	Stock	3.4289	3.4571	3.4211	3.4571	2100812.0
2008-10-23 09:00:00	AAPL	Stock	3.4586	3.4754	3.4414	3.4468	3397324.0
2008-10-23 09:30:00	AAPL	Stock	3.4468	3.5089	3.4011	3.4757	194677084.0
2008-10-23 10:00:00	AAPL	Stock	3.4771	3.4982	3.4446	3.4729	141811796.0
2008-10-23 10:30:00	AAPL	Stock	3.4739	3.5161	3.4618	3.5082	127766156.0
2008-10-23 11:00:00	AAPL	Stock	3.5082	3.5396	3.4893	3.5232	114626876.0
2008-10-23 11:30:00	AAPL	Stock	3.5232	3.5446	3.5	3.5161	91847952.0
2008-10-23 12:00:00	AAPL	Stock	3.515	3.5168	3.4386	3.45	80891524.0
2008-10-23 12:30:00	AAPL	Stock	3.4504	3.4696	3.4171	3.42	87195080.0
2008-10-23 13:00:00	AAPL	Stock	3.4196	3.4611	3.3982	3.42	89903436.0
2008-10-23 13:30:00	AAPL	Stock	3.4193	3.4625	3.3929	3.4046	93568020.0
2008-10-23 14:00:00	AAPL	Stock	3.4043	3.4054	3.2821	3.3254	150641624.0
2008-10-23 14:30:00	AAPL	Stock	3.3254	3.4057	3.3054	3.3639	136740688.0
2008-10-23 15:00:00	AAPL	Stock	3.3654	3.4582	3.345	3.4204	153653752.0
2008-10-23 15:30:00	AAPL	Stock	3.42	3.5246	3.3582	3.5079	172433884.0
2008-10-23 16:00:00	AAPL	Stock	3.5082	3.5429	3.4294	3.5193	20425468.0
2008-10-23 16:30:00	AAPL	Stock	3.5182	3.5243	3.5082	3.5196	2316020.0
2008-10-23 17:00:00	AAPL	Stock	3.5204	3.5204	3.4911	3.4964	516992.0
2008-10-23 17:30:00	AAPL	Stock	3.4886	3.4989	3.4886	3.4975	394912.0
2008-10-23 18:00:00	AAPL	Stock	3.4982	3.5036	3.4961	3.5	285068.0
2008-10-23 18:30:00	AAPL	Stock	3.4971	3.5057	3.4957	3.5043	334684.0
2008-10-23 19:00:00	AAPL	Stock	3.5029	3.5086	3.4964	3.4982	430220.0
2008-10-23 19:30:00	AAPL	Stock	3.4982	3.5064	3.4929	3.4929	240212.0
2008-10-23 04:30:00	MSFT	Stock	21.95	21.95	21.95	21.95	200.0
2008-10-23 07:00:00	MSFT	Stock	21.89	21.89	21.89	21.89	300.0
2008-10-23 07:30:00	MSFT	Stock	21.55	21.75	21.53	21.55	875.0
2008-10-23 08:00:00	MSFT	Stock	21.62	21.65	21.36	21.42	45173.0
2008-10-23 08:30:00	MSFT	Stock	21.41	21.65	21.3	21.65	50999.0
2008-10-23 09:00:00	MSFT	Stock	21.63	21.75	21.48	21.57	90128.0
2008-10-23 09:30:00	MSFT	Stock	21.57	22.2	21.01	21.44	13739114.0
2008-10-23 10:00:00	MSFT	Stock	21.45	21.75	21.31	21.73	12369614.0
2008-10-23 10:30:00	MSFT	Stock	21.73	22.21	21.65	22.06	10897353.0
2008-10-23 11:00:00	MSFT	Stock	22.06	22.22	21.7	21.74	9116074.0
2008-10-23 11:30:00	MSFT	Stock	21.73	22.0	21.71	21.96	6301355.0
2008-10-23 12:00:00	MSFT	Stock	21.96	21.962	21.32	21.42	6896903.0
2008-10-23 12:30:00	MSFT	Stock	21.43	21.61	21.27	21.35	5920757.0
2008-10-23 13:00:00	MSFT	Stock	21.35	21.5	21.15	21.15	6323329.0
2008-10-23 13:30:00	MSFT	Stock	21.15	21.28	21.03	21.13	7620579.0
2008-10-23 14:00:00	MSFT	Stock	21.12	21.12	20.89	21.01	10186479.0
2008-10-23 14:30:00	MSFT	Stock	21.01	21.32	20.91	21.1	8452452.0
2008-10-23 15:00:00	MSFT	Stock	21.11	21.75	21.0	21.5	14020631.0
2008-10-23 15:30:00	MSFT	Stock	21.5	22.59	21.15	22.33	24759330.0
2008-10-23 16:00:00	MSFT	Stock	22.39	23.7	21.57	22.89	11289340.0
2008-10-23 16:30:00	MSFT	Stock	22.88	22.89	21.05	22.73	1764753.0
2008-10-23 17:00:00	MSFT	Stock	22.73	22.73	21.557	22.33	1260703.0
2008-10-23 17:30:00	MSFT	Stock	22.33	22.56	22.31	22.42	288235.0

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

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