PREVIEW / stock_30min / 2009-05-29

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-05-29.parquet
  size:    1.3 MB
  rows:    74,202
  symbols: 3,375

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
2009-05-29 06:30:00	AAPL	Stock	4.8782	4.8782	4.8782	4.8782	2800.0
2009-05-29 07:00:00	AAPL	Stock	4.8743	4.8746	4.8743	4.8746	22680.0
2009-05-29 07:30:00	AAPL	Stock	4.875	4.875	4.8729	4.875	29960.0
2009-05-29 08:00:00	AAPL	Stock	4.8525	4.8679	4.8482	4.8536	777532.0
2009-05-29 08:30:00	AAPL	Stock	4.8536	4.8539	4.8414	4.8414	524888.0
2009-05-29 09:00:00	AAPL	Stock	4.8446	4.8582	4.8286	4.8336	1385188.0
2009-05-29 09:30:00	AAPL	Stock	4.8343	4.8375	4.7832	4.8125	81643100.0
2009-05-29 10:00:00	AAPL	Stock	4.8125	4.8293	4.8	4.8279	35408296.0
2009-05-29 10:30:00	AAPL	Stock	4.8275	4.8411	4.8232	4.8296	41469876.0
2009-05-29 11:00:00	AAPL	Stock	4.8296	4.8343	4.7971	4.8004	29093736.0
2009-05-29 11:30:00	AAPL	Stock	4.8	4.8043	4.7804	4.7982	28028476.0
2009-05-29 12:00:00	AAPL	Stock	4.7982	4.825	4.7975	4.8193	19692820.0
2009-05-29 12:30:00	AAPL	Stock	4.8189	4.8229	4.8022	4.8039	14406028.0
2009-05-29 13:00:00	AAPL	Stock	4.8043	4.8179	4.8036	4.8137	10084648.0
2009-05-29 13:30:00	AAPL	Stock	4.8136	4.8225	4.8104	4.8186	14138796.0
2009-05-29 14:00:00	AAPL	Stock	4.8189	4.8207	4.8054	4.8071	11451440.0
2009-05-29 14:30:00	AAPL	Stock	4.8068	4.8114	4.7857	4.7968	20247052.0
2009-05-29 15:00:00	AAPL	Stock	4.7975	4.8196	4.7911	4.8082	32328520.0
2009-05-29 15:30:00	AAPL	Stock	4.8086	4.8536	4.805	4.8507	57071560.0
2009-05-29 16:00:00	AAPL	Stock	4.8511	4.8925	4.8144	4.8529	39162704.0
2009-05-29 16:30:00	AAPL	Stock	4.8504	4.8529	4.8474	4.8507	1298388.0
2009-05-29 17:00:00	AAPL	Stock	4.8507	4.8528	4.8479	4.8504	475636.0
2009-05-29 17:30:00	AAPL	Stock	4.85	4.8532	4.8457	4.8532	207984.0
2009-05-29 18:00:00	AAPL	Stock	4.8518	4.8543	4.8457	4.8457	593152.0
2009-05-29 18:30:00	AAPL	Stock	4.8457	4.8507	4.8457	4.8507	30044.0
2009-05-29 19:00:00	AAPL	Stock	4.85	4.8507	4.8479	4.8479	12180.0
2009-05-29 19:30:00	AAPL	Stock	4.8504	4.8532	4.8396	4.8464	79800.0
2009-05-29 05:30:00	MSFT	Stock	20.6	20.6	20.6	20.6	100.0
2009-05-29 06:30:00	MSFT	Stock	20.73	20.73	20.62	20.62	2000.0
2009-05-29 07:00:00	MSFT	Stock	20.62	20.62	20.62	20.62	400.0
2009-05-29 07:30:00	MSFT	Stock	20.65	20.65	20.65	20.65	200.0
2009-05-29 08:00:00	MSFT	Stock	20.62	20.64	20.58	20.63	13075.0
2009-05-29 08:30:00	MSFT	Stock	20.63	20.69	20.6	20.65	27065.0
2009-05-29 09:00:00	MSFT	Stock	20.65	20.67	20.53	20.56	21566.0
2009-05-29 09:30:00	MSFT	Stock	20.56	20.64	20.3	20.38	5636640.0
2009-05-29 10:00:00	MSFT	Stock	20.388	20.5	20.34	20.48	2481354.0
2009-05-29 10:30:00	MSFT	Stock	20.49	20.6	20.46	20.518	2171824.0
2009-05-29 11:00:00	MSFT	Stock	20.51	20.55	20.4	20.4	1817656.0
2009-05-29 11:30:00	MSFT	Stock	20.4	20.47	20.37	20.388	1890597.0
2009-05-29 12:00:00	MSFT	Stock	20.38	20.45	20.38	20.43	842655.0
2009-05-29 12:30:00	MSFT	Stock	20.43	20.435	20.305	20.355	1411644.0
2009-05-29 13:00:00	MSFT	Stock	20.36	20.45	20.35	20.43	1129331.0
2009-05-29 13:30:00	MSFT	Stock	20.43	20.47	20.4	20.41	1342673.0
2009-05-29 14:00:00	MSFT	Stock	20.41	20.48	20.39	20.463	1145794.0
2009-05-29 14:30:00	MSFT	Stock	20.46	20.47	20.36	20.42	2186045.0
2009-05-29 15:00:00	MSFT	Stock	20.43	20.53	20.39	20.52	3268243.0
2009-05-29 15:30:00	MSFT	Stock	20.522	20.94	20.49	20.84	11565344.0
2009-05-29 16:00:00	MSFT	Stock	20.9	20.98	20.408	20.85	6778279.0
2009-05-29 16:30:00	MSFT	Stock	20.89	20.898	20.81	20.898	373262.0
2009-05-29 17:00:00	MSFT	Stock	20.83	20.9	20.82	20.89	201419.0

> showing 50 of 74,202 rows — these rows as CSV

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