PREVIEW / stock_30min / 2007-10-04

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-10-04.parquet
  size:    1.2 MB
  rows:    66,484
  symbols: 3,128

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
2007-10-04 05:30:00	AAPL	Stock	5.6425	5.6464	5.6425	5.6429	28000.0
2007-10-04 06:00:00	AAPL	Stock	5.6429	5.6429	5.6429	5.6429	10360.0
2007-10-04 06:30:00	AAPL	Stock	5.6429	5.6429	5.6429	5.6429	25200.0
2007-10-04 07:00:00	AAPL	Stock	5.6489	5.6504	5.6446	5.6446	117600.0
2007-10-04 07:30:00	AAPL	Stock	5.6429	5.6446	5.6361	5.6446	128352.0
2007-10-04 08:00:00	AAPL	Stock	5.6429	5.6554	5.6343	5.6357	2813972.0
2007-10-04 08:30:00	AAPL	Stock	5.6354	5.6479	5.6339	5.6479	846916.0
2007-10-04 09:00:00	AAPL	Stock	5.6475	5.6539	5.6371	5.6429	1164268.0
2007-10-04 09:30:00	AAPL	Stock	5.6429	5.6457	5.4821	5.5454	173397532.0
2007-10-04 10:00:00	AAPL	Stock	5.5457	5.5604	5.5243	5.5414	81078788.0
2007-10-04 10:30:00	AAPL	Stock	5.5414	5.5946	5.5389	5.5879	65205252.0
2007-10-04 11:00:00	AAPL	Stock	5.5882	5.6029	5.5786	5.5914	39313708.0
2007-10-04 11:30:00	AAPL	Stock	5.5914	5.5979	5.5729	5.5822	31063452.0
2007-10-04 12:00:00	AAPL	Stock	5.5821	5.5839	5.5636	5.578	30483516.0
2007-10-04 12:30:00	AAPL	Stock	5.578	5.5893	5.575	5.5807	16282672.0
2007-10-04 13:00:00	AAPL	Stock	5.5807	5.5846	5.5571	5.5711	23501968.0
2007-10-04 13:30:00	AAPL	Stock	5.5711	5.5782	5.566	5.5693	23187276.0
2007-10-04 14:00:00	AAPL	Stock	5.5693	5.5761	5.5607	5.5664	21807212.0
2007-10-04 14:30:00	AAPL	Stock	5.5668	5.5714	5.5414	5.555	35684404.0
2007-10-04 15:00:00	AAPL	Stock	5.555	5.5804	5.5546	5.5725	42642152.0
2007-10-04 15:30:00	AAPL	Stock	5.5725	5.5893	5.5714	5.5832	50304044.0
2007-10-04 16:00:00	AAPL	Stock	5.5807	5.5882	5.525	5.5611	11032980.0
2007-10-04 16:30:00	AAPL	Stock	5.5675	5.5839	5.5571	5.5575	4888352.0
2007-10-04 17:00:00	AAPL	Stock	5.5596	5.5836	5.5589	5.5639	392784.0
2007-10-04 17:30:00	AAPL	Stock	5.5607	5.5693	5.5607	5.5661	203812.0
2007-10-04 18:00:00	AAPL	Stock	5.5704	5.58	5.5571	5.58	901796.0
2007-10-04 18:30:00	AAPL	Stock	5.5604	5.5604	5.5543	5.5543	165956.0
2007-10-04 19:00:00	AAPL	Stock	5.5571	5.5604	5.5539	5.5604	311948.0
2007-10-04 19:30:00	AAPL	Stock	5.5557	5.5711	5.5554	5.5711	260596.0
2007-10-04 08:00:00	MSFT	Stock	29.4	29.45	29.37	29.43	6700.0
2007-10-04 08:30:00	MSFT	Stock	29.43	29.45	29.41	29.45	2773.0
2007-10-04 09:00:00	MSFT	Stock	29.44	29.6	29.44	29.59	105902.0
2007-10-04 09:30:00	MSFT	Stock	29.57	29.58	29.44	29.46	3501383.0
2007-10-04 10:00:00	MSFT	Stock	29.46	29.68	29.46	29.541	4575747.0
2007-10-04 10:30:00	MSFT	Stock	29.54	29.7	29.53	29.69	4204245.0
2007-10-04 11:00:00	MSFT	Stock	29.68	29.75	29.67	29.7	2452730.0
2007-10-04 11:30:00	MSFT	Stock	29.7	29.71	29.61	29.619	2231040.0
2007-10-04 12:00:00	MSFT	Stock	29.619	29.65	29.59	29.61	1168262.0
2007-10-04 12:30:00	MSFT	Stock	29.61	29.65	29.58	29.59	1445039.0
2007-10-04 13:00:00	MSFT	Stock	29.59	29.6	29.53	29.562	1764776.0
2007-10-04 13:30:00	MSFT	Stock	29.569	29.6	29.54	29.541	1211845.0
2007-10-04 14:00:00	MSFT	Stock	29.541	29.6	29.54	29.598	1394311.0
2007-10-04 14:30:00	MSFT	Stock	29.6	29.6	29.53	29.54	2118464.0
2007-10-04 15:00:00	MSFT	Stock	29.54	29.63	29.53	29.62	2619125.0
2007-10-04 15:30:00	MSFT	Stock	29.63	29.77	29.62	29.73	6901614.0
2007-10-04 16:00:00	MSFT	Stock	29.73	29.79	29.6	29.71	1573558.0
2007-10-04 16:30:00	MSFT	Stock	29.71	29.71	29.66	29.7	472446.0
2007-10-04 17:00:00	MSFT	Stock	29.69	29.73	29.69	29.72	48100.0
2007-10-04 17:30:00	MSFT	Stock	29.606	29.72	29.606	29.72	55000.0
2007-10-04 18:00:00	MSFT	Stock	29.71	29.71	29.69	29.69	16663.0

> showing 50 of 66,484 rows — these rows as CSV

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