PREVIEW / stock_30min / 2008-10-20

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-10-20.parquet
  size:    1.2 MB
  rows:    69,056
  symbols: 3,342

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-20 05:00:00	AAPL	Stock	3.555	3.5796	3.555	3.5796	11480.0
2008-10-20 05:30:00	AAPL	Stock	3.5939	3.5939	3.5939	3.5939	8372.0
2008-10-20 06:00:00	AAPL	Stock	3.6068	3.6068	3.6068	3.6068	2800.0
2008-10-20 06:30:00	AAPL	Stock	3.5929	3.5929	3.5614	3.5714	46200.0
2008-10-20 07:00:00	AAPL	Stock	3.5793	3.6071	3.5593	3.5679	189840.0
2008-10-20 07:30:00	AAPL	Stock	3.5539	3.5786	3.5375	3.5464	251020.0
2008-10-20 08:00:00	AAPL	Stock	3.5568	3.5689	3.5368	3.5482	2333912.0
2008-10-20 08:30:00	AAPL	Stock	3.5482	3.5675	3.5482	3.5571	1011360.0
2008-10-20 09:00:00	AAPL	Stock	3.5579	3.5714	3.54	3.5643	3484404.0
2008-10-20 09:30:00	AAPL	Stock	3.5632	3.5725	3.4643	3.475	205594284.0
2008-10-20 10:00:00	AAPL	Stock	3.475	3.5121	3.3964	3.4025	194492228.0
2008-10-20 10:30:00	AAPL	Stock	3.4036	3.4375	3.3864	3.4054	122115308.0
2008-10-20 11:00:00	AAPL	Stock	3.4054	3.4068	3.3443	3.4054	116201764.0
2008-10-20 11:30:00	AAPL	Stock	3.4054	3.4843	3.3982	3.4611	115992268.0
2008-10-20 12:00:00	AAPL	Stock	3.4614	3.5104	3.4411	3.5054	104755000.0
2008-10-20 12:30:00	AAPL	Stock	3.5046	3.5171	3.4589	3.4632	89363848.0
2008-10-20 13:00:00	AAPL	Stock	3.4629	3.4836	3.4261	3.4779	90008996.0
2008-10-20 13:30:00	AAPL	Stock	3.4786	3.5036	3.4489	3.4861	78815940.0
2008-10-20 14:00:00	AAPL	Stock	3.4857	3.5196	3.4643	3.4796	81331236.0
2008-10-20 14:30:00	AAPL	Stock	3.4796	3.5146	3.4589	3.4904	73027864.0
2008-10-20 15:00:00	AAPL	Stock	3.49	3.5054	3.4575	3.4707	96612124.0
2008-10-20 15:30:00	AAPL	Stock	3.4707	3.5143	3.4554	3.5143	142243752.0
2008-10-20 16:00:00	AAPL	Stock	3.5154	3.5311	3.4661	3.5286	16754052.0
2008-10-20 16:30:00	AAPL	Stock	3.52	3.52	3.5	3.5025	1292368.0
2008-10-20 17:00:00	AAPL	Stock	3.5082	3.5221	3.4964	3.5157	1113000.0
2008-10-20 17:30:00	AAPL	Stock	3.5157	3.5214	3.5107	3.5179	971012.0
2008-10-20 18:00:00	AAPL	Stock	3.5189	3.5268	3.5164	3.5268	598668.0
2008-10-20 18:30:00	AAPL	Stock	3.525	3.5275	3.5125	3.5125	922432.0
2008-10-20 19:00:00	AAPL	Stock	3.5136	3.5143	3.5046	3.5143	68320.0
2008-10-20 19:30:00	AAPL	Stock	3.5168	3.5175	3.5096	3.5143	159656.0
2008-10-20 08:00:00	MSFT	Stock	24.17	24.46	24.17	24.26	9163.0
2008-10-20 08:30:00	MSFT	Stock	24.28	24.37	24.27	24.35	4607.0
2008-10-20 09:00:00	MSFT	Stock	24.34	24.35	24.16	24.2	54931.0
2008-10-20 09:30:00	MSFT	Stock	24.2	24.235	23.6	23.9	10624430.0
2008-10-20 10:00:00	MSFT	Stock	23.9	23.95	23.36	23.49	8677715.0
2008-10-20 10:30:00	MSFT	Stock	23.49	23.53	23.15	23.31	6827615.0
2008-10-20 11:00:00	MSFT	Stock	23.3	23.42	23.01	23.39	6260767.0
2008-10-20 11:30:00	MSFT	Stock	23.39	23.72	23.35	23.66	7020074.0
2008-10-20 12:00:00	MSFT	Stock	23.66	23.9	23.59	23.84	3737007.0
2008-10-20 12:30:00	MSFT	Stock	23.84	23.93	23.67	23.69	4900262.0
2008-10-20 13:00:00	MSFT	Stock	23.69	23.94	23.61	23.93	3855406.0
2008-10-20 13:30:00	MSFT	Stock	23.94	24.12	23.87	24.04	4499962.0
2008-10-20 14:00:00	MSFT	Stock	24.04	24.32	23.99	24.07	5182289.0
2008-10-20 14:30:00	MSFT	Stock	24.07	24.25	23.94	24.2	5546844.0
2008-10-20 15:00:00	MSFT	Stock	24.19	24.35	24.12	24.21	7792210.0
2008-10-20 15:30:00	MSFT	Stock	24.21	24.75	24.12	24.73	13702293.0
2008-10-20 16:00:00	MSFT	Stock	24.72	24.74	23.879	24.65	3891622.0
2008-10-20 16:30:00	MSFT	Stock	24.64	24.65	24.6	24.6	12198.0
2008-10-20 17:00:00	MSFT	Stock	24.62	24.62	24.51	24.55	37230.0
2008-10-20 17:30:00	MSFT	Stock	24.56	24.59	24.53	24.59	1030.0

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

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