PREVIEW / stock_30min / 2010-04-05

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-04-05.parquet
  size:    1.4 MB
  rows:    73,783
  symbols: 3,491

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-04-05 04:00:00	AAPL	Stock	8.5	8.5	8.4107	8.4693	19600.0
2010-04-05 04:30:00	AAPL	Stock	8.4804	8.5114	8.4804	8.5043	50400.0
2010-04-05 06:00:00	AAPL	Stock	8.4964	8.4996	8.4964	8.4996	92400.0
2010-04-05 06:30:00	AAPL	Stock	8.4964	8.4964	8.4571	8.4571	66668.0
2010-04-05 07:00:00	AAPL	Stock	8.4504	8.4504	8.3875	8.4004	436856.0
2010-04-05 07:30:00	AAPL	Stock	8.4071	8.475	8.4071	8.4696	590268.0
2010-04-05 08:00:00	AAPL	Stock	8.4707	8.4936	8.4643	8.475	4484760.0
2010-04-05 08:30:00	AAPL	Stock	8.4761	8.4761	8.3143	8.4357	23286760.0
2010-04-05 09:00:00	AAPL	Stock	8.4354	8.4464	8.3664	8.3925	13262200.0
2010-04-05 09:30:00	AAPL	Stock	8.3921	8.5089	8.3846	8.4418	177484608.0
2010-04-05 10:00:00	AAPL	Stock	8.4404	8.4596	8.4018	8.4264	90601140.0
2010-04-05 10:30:00	AAPL	Stock	8.4264	8.4821	8.4246	8.4693	45645068.0
2010-04-05 11:00:00	AAPL	Stock	8.4682	8.4854	8.4571	8.4706	32079936.0
2010-04-05 11:30:00	AAPL	Stock	8.4711	8.4796	8.4575	8.469	23490908.0
2010-04-05 12:00:00	AAPL	Stock	8.4689	8.4811	8.4625	8.4797	23419032.0
2010-04-05 12:30:00	AAPL	Stock	8.4795	8.5025	8.4761	8.4844	36864128.0
2010-04-05 13:00:00	AAPL	Stock	8.4846	8.4943	8.475	8.4897	21861112.0
2010-04-05 13:30:00	AAPL	Stock	8.4907	8.4961	8.4771	8.4786	19814088.0
2010-04-05 14:00:00	AAPL	Stock	8.4789	8.4907	8.4696	8.4886	19877816.0
2010-04-05 14:30:00	AAPL	Stock	8.4886	8.5071	8.4825	8.4957	38510332.0
2010-04-05 15:00:00	AAPL	Stock	8.4968	8.5071	8.485	8.4936	33845196.0
2010-04-05 15:30:00	AAPL	Stock	8.4936	8.5179	8.4825	8.5179	65489760.0
2010-04-05 16:00:00	AAPL	Stock	8.5179	8.5214	8.4647	8.5214	7089376.0
2010-04-05 16:30:00	AAPL	Stock	8.4911	8.5268	8.4911	8.5268	521500.0
2010-04-05 17:00:00	AAPL	Stock	8.5257	8.5393	8.4651	8.5304	551488.0
2010-04-05 17:30:00	AAPL	Stock	8.5314	8.5361	8.5286	8.5336	300916.0
2010-04-05 18:00:00	AAPL	Stock	8.5332	8.5357	8.5175	8.5354	124236.0
2010-04-05 18:30:00	AAPL	Stock	8.5339	8.5454	8.5	8.5079	1744092.0
2010-04-05 19:00:00	AAPL	Stock	8.5125	8.5243	8.5064	8.5239	462980.0
2010-04-05 19:30:00	AAPL	Stock	8.5214	8.53	8.52	8.53	409500.0
2010-04-05 07:00:00	MSFT	Stock	29.19	29.25	29.19	29.25	500.0
2010-04-05 07:30:00	MSFT	Stock	29.25	29.27	29.25	29.26	900.0
2010-04-05 08:00:00	MSFT	Stock	29.24	29.26	29.18	29.25	11834.0
2010-04-05 08:30:00	MSFT	Stock	29.26	29.26	29.1	29.13	7984.0
2010-04-05 09:00:00	MSFT	Stock	29.13	29.26	29.1	29.14	46775.0
2010-04-05 09:30:00	MSFT	Stock	29.15	29.35	29.03	29.23	5463351.0
2010-04-05 10:00:00	MSFT	Stock	29.23	29.32	29.2	29.29	2923361.0
2010-04-05 10:30:00	MSFT	Stock	29.28	29.425	29.28	29.34	2655860.0
2010-04-05 11:00:00	MSFT	Stock	29.34	29.38	29.28	29.31	2157341.0
2010-04-05 11:30:00	MSFT	Stock	29.31	29.35	29.28	29.34	1367364.0
2010-04-05 12:00:00	MSFT	Stock	29.34	29.37	29.31	29.345	940556.0
2010-04-05 12:30:00	MSFT	Stock	29.35	29.36	29.26	29.29	1392350.0
2010-04-05 13:00:00	MSFT	Stock	29.288	29.315	29.19	29.211	1968713.0
2010-04-05 13:30:00	MSFT	Stock	29.21	29.27	29.17	29.245	1816708.0
2010-04-05 14:00:00	MSFT	Stock	29.25	29.3	29.23	29.27	1317102.0
2010-04-05 14:30:00	MSFT	Stock	29.271	29.34	29.26	29.3	1960406.0
2010-04-05 15:00:00	MSFT	Stock	29.305	29.32	29.28	29.3	2012978.0
2010-04-05 15:30:00	MSFT	Stock	29.3	29.32	29.23	29.28	5586949.0
2010-04-05 16:00:00	MSFT	Stock	29.27	29.3	29.23	29.3	2098784.0
2010-04-05 16:30:00	MSFT	Stock	29.298	30.0	29.0	29.24	14800.0

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

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