PREVIEW / stock_30min / 2009-05-12

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-05-12.parquet
  size:    1.3 MB
  rows:    72,956
  symbols: 3,343

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-12 05:00:00	AAPL	Stock	4.6425	4.6425	4.6425	4.6425	14000.0
2009-05-12 07:00:00	AAPL	Stock	4.6429	4.6429	4.6429	4.6429	14000.0
2009-05-12 07:30:00	AAPL	Stock	4.6429	4.6429	4.6429	4.6429	28000.0
2009-05-12 08:00:00	AAPL	Stock	4.6339	4.6504	4.6289	4.6471	158536.0
2009-05-12 08:30:00	AAPL	Stock	4.6482	4.655	4.6432	4.6511	182000.0
2009-05-12 09:00:00	AAPL	Stock	4.6457	4.6493	4.6275	4.6314	517776.0
2009-05-12 09:30:00	AAPL	Stock	4.6279	4.6325	4.5246	4.5464	89921636.0
2009-05-12 10:00:00	AAPL	Stock	4.5464	4.5771	4.5282	4.5482	52144932.0
2009-05-12 10:30:00	AAPL	Stock	4.5486	4.5532	4.4932	4.5073	58479932.0
2009-05-12 11:00:00	AAPL	Stock	4.5071	4.5214	4.4911	4.4957	35615916.0
2009-05-12 11:30:00	AAPL	Stock	4.4954	4.5096	4.4661	4.4679	36759688.0
2009-05-12 12:00:00	AAPL	Stock	4.4679	4.4696	4.4018	4.4418	52546088.0
2009-05-12 12:30:00	AAPL	Stock	4.4418	4.4521	4.4196	4.4221	26920460.0
2009-05-12 13:00:00	AAPL	Stock	4.4225	4.4504	4.4221	4.4457	22102444.0
2009-05-12 13:30:00	AAPL	Stock	4.4457	4.4689	4.4407	4.4557	26302360.0
2009-05-12 14:00:00	AAPL	Stock	4.4554	4.4714	4.4429	4.4482	27699784.0
2009-05-12 14:30:00	AAPL	Stock	4.4476	4.4836	4.4411	4.4671	36891764.0
2009-05-12 15:00:00	AAPL	Stock	4.4671	4.4996	4.4554	4.4893	52704932.0
2009-05-12 15:30:00	AAPL	Stock	4.49	4.5839	4.4375	4.445	70787276.0
2009-05-12 16:00:00	AAPL	Stock	4.4446	4.4931	4.4393	4.4718	11514216.0
2009-05-12 16:30:00	AAPL	Stock	4.4714	4.475	4.4436	4.4643	356888.0
2009-05-12 17:00:00	AAPL	Stock	4.4639	4.4732	4.4639	4.4714	285572.0
2009-05-12 17:30:00	AAPL	Stock	4.4686	4.4714	4.4568	4.4568	353640.0
2009-05-12 18:00:00	AAPL	Stock	4.46	4.4636	4.4436	4.4589	1877904.0
2009-05-12 18:30:00	AAPL	Stock	4.46	4.4636	4.46	4.4625	112784.0
2009-05-12 19:00:00	AAPL	Stock	4.4614	4.4632	4.4586	4.4632	126840.0
2009-05-12 19:30:00	AAPL	Stock	4.4632	4.4636	4.46	4.4625	86744.0
2009-05-12 08:00:00	MSFT	Stock	19.38	19.49	19.38	19.48	7570.0
2009-05-12 08:30:00	MSFT	Stock	19.48	19.57	19.46	19.55	18330.0
2009-05-12 09:00:00	MSFT	Stock	19.53	19.57	19.45	19.51	15515.0
2009-05-12 09:30:00	MSFT	Stock	19.51	19.7	19.47	19.59	7422815.0
2009-05-12 10:00:00	MSFT	Stock	19.59	19.82	19.57	19.75	7415477.0
2009-05-12 10:30:00	MSFT	Stock	19.75	19.755	19.61	19.72	3732143.0
2009-05-12 11:00:00	MSFT	Stock	19.71	19.775	19.68	19.71	3366725.0
2009-05-12 11:30:00	MSFT	Stock	19.72	19.79	19.7	19.74	3072246.0
2009-05-12 12:00:00	MSFT	Stock	19.74	19.77	19.66	19.695	3481425.0
2009-05-12 12:30:00	MSFT	Stock	19.7	19.77	19.7	19.76	3700417.0
2009-05-12 13:00:00	MSFT	Stock	19.76	19.8	19.73	19.795	2108833.0
2009-05-12 13:30:00	MSFT	Stock	19.79	19.83	19.73	19.79	3512791.0
2009-05-12 14:00:00	MSFT	Stock	19.79	19.87	19.78	19.81	3622790.0
2009-05-12 14:30:00	MSFT	Stock	19.81	19.87	19.75	19.86	8299781.0
2009-05-12 15:00:00	MSFT	Stock	19.86	20.06	19.85	20.01	6950696.0
2009-05-12 15:30:00	MSFT	Stock	20.02	20.06	19.87	19.89	11889747.0
2009-05-12 16:00:00	MSFT	Stock	19.9	20.04	19.7	20.04	2504249.0
2009-05-12 16:30:00	MSFT	Stock	20.04	20.05	19.89	20.0	45652.0
2009-05-12 17:00:00	MSFT	Stock	20.02	20.05	20.01	20.04	78179.0
2009-05-12 17:30:00	MSFT	Stock	20.04	20.05	20.04	20.05	3825.0
2009-05-12 18:00:00	MSFT	Stock	20.05	20.05	19.89	20.01	46809.0
2009-05-12 18:30:00	MSFT	Stock	20.01	20.02	20.0	20.02	1642.0
2009-05-12 19:00:00	MSFT	Stock	20.03	20.04	20.02	20.04	3687.0

> showing 50 of 72,956 rows — these rows as CSV

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