PREVIEW / stock_30min / 2007-10-11

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-10-11.parquet
  size:    1.3 MB
  rows:    71,912
  symbols: 3,146

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-11 06:00:00	AAPL	Stock	6.0007	6.0007	6.0007	6.0007	22400.0
2007-10-11 06:30:00	AAPL	Stock	6.0021	6.0021	6.0021	6.0021	2800.0
2007-10-11 07:00:00	AAPL	Stock	6.0282	6.0721	6.0282	6.0539	389256.0
2007-10-11 07:30:00	AAPL	Stock	6.0625	6.0625	6.0329	6.0357	1067220.0
2007-10-11 08:00:00	AAPL	Stock	6.0357	6.0621	6.0257	6.0507	6293056.0
2007-10-11 08:30:00	AAPL	Stock	6.05	6.0536	6.0357	6.0514	3364844.0
2007-10-11 09:00:00	AAPL	Stock	6.05	6.0661	6.0429	6.0518	5707436.0
2007-10-11 09:30:00	AAPL	Stock	6.0518	6.0671	6.0232	6.0668	139528984.0
2007-10-11 10:00:00	AAPL	Stock	6.067	6.0907	6.0539	6.0714	125429808.0
2007-10-11 10:30:00	AAPL	Stock	6.0707	6.0893	6.0629	6.0675	71345876.0
2007-10-11 11:00:00	AAPL	Stock	6.0675	6.0757	6.0582	6.0621	47412064.0
2007-10-11 11:30:00	AAPL	Stock	6.0621	6.0814	6.06	6.0707	47595128.0
2007-10-11 12:00:00	AAPL	Stock	6.0704	6.1386	6.0643	6.0811	36821232.0
2007-10-11 12:30:00	AAPL	Stock	6.0814	6.0846	6.0661	6.0789	39993492.0
2007-10-11 13:00:00	AAPL	Stock	6.0796	6.0804	6.0539	6.0646	41852020.0
2007-10-11 13:30:00	AAPL	Stock	6.0646	6.0679	5.9725	5.9725	94294564.0
2007-10-11 14:00:00	AAPL	Stock	5.9732	5.9786	5.4718	5.7461	376161660.0
2007-10-11 14:30:00	AAPL	Stock	5.7486	5.8843	5.6932	5.7914	212214604.0
2007-10-11 15:00:00	AAPL	Stock	5.7914	5.8239	5.6464	5.7257	195673380.0
2007-10-11 15:30:00	AAPL	Stock	5.7257	5.8389	5.6964	5.7939	161815948.0
2007-10-11 16:00:00	AAPL	Stock	5.7946	6.0429	5.7679	5.7939	21952532.0
2007-10-11 16:30:00	AAPL	Stock	5.7939	6.0532	5.7864	5.7929	2713900.0
2007-10-11 17:00:00	AAPL	Stock	5.7929	5.7954	5.7679	5.7714	903420.0
2007-10-11 17:30:00	AAPL	Stock	5.7718	6.0772	5.6786	5.7629	8406132.0
2007-10-11 18:00:00	AAPL	Stock	5.7571	5.8343	5.7543	5.7661	1829492.0
2007-10-11 18:30:00	AAPL	Stock	5.7632	5.7661	5.7482	5.7589	710052.0
2007-10-11 19:00:00	AAPL	Stock	5.7589	5.7654	5.7464	5.7536	498204.0
2007-10-11 19:30:00	AAPL	Stock	5.7518	5.7618	5.7386	5.7393	472108.0
2007-10-11 06:30:00	MSFT	Stock	30.33	30.33	30.33	30.33	1100.0
2007-10-11 07:00:00	MSFT	Stock	30.36	30.36	30.36	30.36	3970.0
2007-10-11 08:00:00	MSFT	Stock	30.28	30.4	30.28	30.4	6626.0
2007-10-11 08:30:00	MSFT	Stock	30.4	30.41	30.33	30.4	9865.0
2007-10-11 09:00:00	MSFT	Stock	30.39	30.4	30.3	30.38	73887.0
2007-10-11 09:30:00	MSFT	Stock	30.3	30.43	30.28	30.36	4412696.0
2007-10-11 10:00:00	MSFT	Stock	30.35	30.5	30.35	30.5	4163379.0
2007-10-11 10:30:00	MSFT	Stock	30.49	30.63	30.43	30.6	5437685.0
2007-10-11 11:00:00	MSFT	Stock	30.59	30.599	30.48	30.48	1771168.0
2007-10-11 11:30:00	MSFT	Stock	30.48	30.575	30.48	30.57	1966452.0
2007-10-11 12:00:00	MSFT	Stock	30.56	30.58	30.48	30.52	1283892.0
2007-10-11 12:30:00	MSFT	Stock	30.52	30.55	30.5	30.5	1093703.0
2007-10-11 13:00:00	MSFT	Stock	30.5	30.51	30.45	30.46	1134665.0
2007-10-11 13:30:00	MSFT	Stock	30.46	30.48	30.34	30.38	1814523.0
2007-10-11 14:00:00	MSFT	Stock	30.38	30.48	30.18	30.2	6974148.0
2007-10-11 14:30:00	MSFT	Stock	30.2	30.3	30.12	30.19	4727992.0
2007-10-11 15:00:00	MSFT	Stock	30.19	30.22	29.84	29.88	6084629.0
2007-10-11 15:30:00	MSFT	Stock	29.88	29.94	29.79	29.89	7150378.0
2007-10-11 16:00:00	MSFT	Stock	29.91	30.271	29.88	30.262	1761990.0
2007-10-11 16:30:00	MSFT	Stock	29.91	30.28	29.89	29.89	101171.0
2007-10-11 17:00:00	MSFT	Stock	29.89	29.93	29.81	29.93	9542.0
2007-10-11 17:30:00	MSFT	Stock	29.91	29.93	29.8	29.81	733396.0

> showing 50 of 71,912 rows — these rows as CSV

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