PREVIEW / stock_30min / 2010-03-03

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-03-03.parquet
  size:    1.4 MB
  rows:    73,117
  symbols: 3,470

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
2010-03-03 04:30:00	AAPL	Stock	7.445	7.445	7.445	7.445	2800.0
2010-03-03 05:00:00	AAPL	Stock	7.4436	7.4436	7.4436	7.4436	5600.0
2010-03-03 07:00:00	AAPL	Stock	7.4589	7.4589	7.4589	7.4589	2800.0
2010-03-03 07:30:00	AAPL	Stock	7.4464	7.4464	7.4339	7.4339	103600.0
2010-03-03 08:00:00	AAPL	Stock	7.4421	7.4568	7.4321	7.4568	654556.0
2010-03-03 08:30:00	AAPL	Stock	7.4571	7.4782	7.4536	7.4709	1006040.0
2010-03-03 09:00:00	AAPL	Stock	7.4661	7.4714	7.4421	7.4689	691740.0
2010-03-03 09:30:00	AAPL	Stock	7.4621	7.4821	7.4264	7.4761	57285116.0
2010-03-03 10:00:00	AAPL	Stock	7.4761	7.4889	7.4479	7.4686	47722640.0
2010-03-03 10:30:00	AAPL	Stock	7.4686	7.4954	7.4629	7.4868	28863660.0
2010-03-03 11:00:00	AAPL	Stock	7.4879	7.4911	7.4714	7.4904	27398896.0
2010-03-03 11:30:00	AAPL	Stock	7.4906	7.4946	7.4832	7.4889	19643764.0
2010-03-03 12:00:00	AAPL	Stock	7.4886	7.4889	7.4736	7.4807	16444568.0
2010-03-03 12:30:00	AAPL	Stock	7.4811	7.4846	7.4732	7.4826	13282808.0
2010-03-03 13:00:00	AAPL	Stock	7.4831	7.4954	7.4757	7.4777	18636072.0
2010-03-03 13:30:00	AAPL	Stock	7.4775	7.4839	7.475	7.4829	9839592.0
2010-03-03 14:00:00	AAPL	Stock	7.4834	7.4911	7.4661	7.4754	22988112.0
2010-03-03 14:30:00	AAPL	Stock	7.475	7.4818	7.4432	7.4525	33251736.0
2010-03-03 15:00:00	AAPL	Stock	7.4522	7.4732	7.4436	7.4575	26383784.0
2010-03-03 15:30:00	AAPL	Stock	7.4579	7.4839	7.4564	7.4761	35530348.0
2010-03-03 16:00:00	AAPL	Stock	7.4732	7.4893	7.4714	7.4761	8319892.0
2010-03-03 16:30:00	AAPL	Stock	7.4755	7.4764	7.4714	7.4714	170044.0
2010-03-03 17:00:00	AAPL	Stock	7.4714	7.4757	7.4714	7.4732	112000.0
2010-03-03 17:30:00	AAPL	Stock	7.4732	7.4732	7.4714	7.4732	148624.0
2010-03-03 18:00:00	AAPL	Stock	7.4721	7.4754	7.4721	7.4736	25284.0
2010-03-03 18:30:00	AAPL	Stock	7.4732	7.4739	7.4732	7.4739	43400.0
2010-03-03 19:00:00	AAPL	Stock	7.4739	7.4739	7.4729	7.4729	62076.0
2010-03-03 19:30:00	AAPL	Stock	7.4729	7.4729	7.4711	7.4721	75404.0
2010-03-03 05:30:00	MSFT	Stock	28.5	28.5	28.5	28.5	400.0
2010-03-03 07:00:00	MSFT	Stock	28.57	28.57	28.54	28.54	1759.0
2010-03-03 07:30:00	MSFT	Stock	28.52	28.54	28.52	28.54	352.0
2010-03-03 08:00:00	MSFT	Stock	28.51	28.56	28.48	28.52	8776.0
2010-03-03 08:30:00	MSFT	Stock	28.58	28.59	28.48	28.52	14506.0
2010-03-03 09:00:00	MSFT	Stock	28.52	28.55	28.5	28.55	24504.0
2010-03-03 09:30:00	MSFT	Stock	28.52	28.61	28.35	28.45	6406304.0
2010-03-03 10:00:00	MSFT	Stock	28.45	28.58	28.41	28.49	5608757.0
2010-03-03 10:30:00	MSFT	Stock	28.49	28.59	28.45	28.58	3483941.0
2010-03-03 11:00:00	MSFT	Stock	28.57	28.58	28.51	28.55	3315932.0
2010-03-03 11:30:00	MSFT	Stock	28.548	28.55	28.46	28.49	3257864.0
2010-03-03 12:00:00	MSFT	Stock	28.48	28.5	28.42	28.48	2745129.0
2010-03-03 12:30:00	MSFT	Stock	28.49	28.49	28.4	28.431	2742306.0
2010-03-03 13:00:00	MSFT	Stock	28.43	28.51	28.43	28.465	2035082.0
2010-03-03 13:30:00	MSFT	Stock	28.465	28.52	28.44	28.51	1735725.0
2010-03-03 14:00:00	MSFT	Stock	28.51	28.55	28.45	28.5	2927629.0
2010-03-03 14:30:00	MSFT	Stock	28.49	28.52	28.37	28.43	4331403.0
2010-03-03 15:00:00	MSFT	Stock	28.43	28.52	28.39	28.49	2534559.0
2010-03-03 15:30:00	MSFT	Stock	28.495	28.56	28.46	28.46	4222327.0
2010-03-03 16:00:00	MSFT	Stock	28.46	28.5	28.45	28.47	2128360.0
2010-03-03 16:30:00	MSFT	Stock	28.515	28.515	28.483	28.483	52400.0
2010-03-03 17:00:00	MSFT	Stock	28.5	28.5	28.46	28.46	285300.0

> showing 50 of 73,117 rows — these rows as CSV

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