PREVIEW / stock_30min / 2008-06-11

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-06-11.parquet
  size:    1.2 MB
  rows:    68,196
  symbols: 3,314

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-06-11 04:00:00	AAPL	Stock	6.6239	6.6239	6.6239	6.6239	2800.0
2008-06-11 05:00:00	AAPL	Stock	6.6568	6.6568	6.6568	6.6568	2800.0
2008-06-11 06:00:00	AAPL	Stock	6.6429	6.6429	6.6429	6.6429	8400.0
2008-06-11 07:00:00	AAPL	Stock	6.6618	6.6621	6.6432	6.6607	177800.0
2008-06-11 07:30:00	AAPL	Stock	6.6643	6.6657	6.6507	6.6654	82600.0
2008-06-11 08:00:00	AAPL	Stock	6.6625	6.6661	6.6179	6.6336	2950276.0
2008-06-11 08:30:00	AAPL	Stock	6.6357	6.6357	6.6221	6.6314	1191652.0
2008-06-11 09:00:00	AAPL	Stock	6.6314	6.6321	6.5621	6.5829	7508956.0
2008-06-11 09:30:00	AAPL	Stock	6.5829	6.6429	6.5511	6.5658	121545452.0
2008-06-11 10:00:00	AAPL	Stock	6.5654	6.5661	6.4743	6.5125	136548384.0
2008-06-11 10:30:00	AAPL	Stock	6.5126	6.5571	6.5068	6.5482	64138480.0
2008-06-11 11:00:00	AAPL	Stock	6.5475	6.5804	6.4946	6.5011	77904932.0
2008-06-11 11:30:00	AAPL	Stock	6.5021	6.5279	6.4729	6.5279	69403460.0
2008-06-11 12:00:00	AAPL	Stock	6.5275	6.5282	6.4736	6.4825	41200992.0
2008-06-11 12:30:00	AAPL	Stock	6.4836	6.505	6.4554	6.475	47197556.0
2008-06-11 13:00:00	AAPL	Stock	6.4754	6.5104	6.4661	6.4918	39978904.0
2008-06-11 13:30:00	AAPL	Stock	6.4921	6.5089	6.4757	6.4893	36496320.0
2008-06-11 14:00:00	AAPL	Stock	6.4879	6.5321	6.4768	6.5146	50922928.0
2008-06-11 14:30:00	AAPL	Stock	6.5143	6.5179	6.485	6.4857	34338556.0
2008-06-11 15:00:00	AAPL	Stock	6.485	6.4954	6.4329	6.4479	58192204.0
2008-06-11 15:30:00	AAPL	Stock	6.4489	6.4643	6.4139	6.4625	113890196.0
2008-06-11 16:00:00	AAPL	Stock	6.4634	6.5077	6.4446	6.4575	15081108.0
2008-06-11 16:30:00	AAPL	Stock	6.4493	6.4575	6.4446	6.45	810180.0
2008-06-11 17:00:00	AAPL	Stock	6.45	6.4575	6.4496	6.4546	297080.0
2008-06-11 17:30:00	AAPL	Stock	6.4518	6.4521	6.4486	6.4514	150612.0
2008-06-11 18:00:00	AAPL	Stock	6.4518	6.4568	6.4482	6.4482	195468.0
2008-06-11 18:30:00	AAPL	Stock	6.45	6.4536	6.4468	6.4482	65128.0
2008-06-11 19:00:00	AAPL	Stock	6.4482	6.4536	6.4482	6.4532	169764.0
2008-06-11 19:30:00	AAPL	Stock	6.4532	6.4536	6.4468	6.4482	211932.0
2008-06-11 08:00:00	MSFT	Stock	27.95	27.98	27.95	27.98	1500.0
2008-06-11 08:30:00	MSFT	Stock	27.95	27.97	27.95	27.95	4933.0
2008-06-11 09:00:00	MSFT	Stock	27.97	27.97	27.87	27.88	74302.0
2008-06-11 09:30:00	MSFT	Stock	27.9	27.94	27.56	27.6	4387727.0
2008-06-11 10:00:00	MSFT	Stock	27.6	27.69	27.48	27.5	4586583.0
2008-06-11 10:30:00	MSFT	Stock	27.5	27.65	27.48	27.59	5535512.0
2008-06-11 11:00:00	MSFT	Stock	27.59	27.63	27.36	27.39	3417905.0
2008-06-11 11:30:00	MSFT	Stock	27.38	27.48	27.32	27.44	4272563.0
2008-06-11 12:00:00	MSFT	Stock	27.43	27.46	27.31	27.32	2452244.0
2008-06-11 12:30:00	MSFT	Stock	27.31	27.36	27.25	27.32	3339191.0
2008-06-11 13:00:00	MSFT	Stock	27.31	27.37	27.27	27.335	2638760.0
2008-06-11 13:30:00	MSFT	Stock	27.33	27.37	27.29	27.37	2659039.0
2008-06-11 14:00:00	MSFT	Stock	27.36	27.45	27.3	27.39	4267950.0
2008-06-11 14:30:00	MSFT	Stock	27.39	27.39	27.25	27.265	2669622.0
2008-06-11 15:00:00	MSFT	Stock	27.26	27.33	27.2	27.25	4419397.0
2008-06-11 15:30:00	MSFT	Stock	27.24	27.25	27.11	27.13	8547777.0
2008-06-11 16:00:00	MSFT	Stock	27.12	27.398	27.0	27.12	2944292.0
2008-06-11 16:30:00	MSFT	Stock	27.15	27.19	27.12	27.16	8665.0
2008-06-11 17:00:00	MSFT	Stock	27.18	27.19	27.12	27.19	7489.0
2008-06-11 17:30:00	MSFT	Stock	27.19	27.19	27.16	27.19	9800.0
2008-06-11 18:00:00	MSFT	Stock	27.19	27.2	27.19	27.2	6736.0

> showing 50 of 68,196 rows — these rows as CSV

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