PREVIEW / stock_30min / 2012-03-09

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-03-09.parquet
  size:    1.4 MB
  rows:    75,916
  symbols: 3,507

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
2012-03-09 04:00:00	AAPL	Stock	19.3929	19.4321	19.3929	19.4321	82040.0
2012-03-09 04:30:00	AAPL	Stock	19.4143	19.4143	19.4143	19.4143	5572.0
2012-03-09 05:00:00	AAPL	Stock	19.4243	19.4243	19.4196	19.4196	11200.0
2012-03-09 05:30:00	AAPL	Stock	19.4429	19.4429	19.4179	19.4196	50400.0
2012-03-09 06:00:00	AAPL	Stock	19.3964	19.3964	19.375	19.3929	71400.0
2012-03-09 06:30:00	AAPL	Stock	19.3929	19.3929	19.3929	19.3929	56000.0
2012-03-09 07:00:00	AAPL	Stock	19.4054	19.4054	19.3839	19.4029	237300.0
2012-03-09 07:30:00	AAPL	Stock	19.4014	19.4014	19.3589	19.3696	420980.0
2012-03-09 08:00:00	AAPL	Stock	19.3632	19.4014	19.34	19.3804	1735440.0
2012-03-09 08:30:00	AAPL	Stock	19.3782	19.4286	19.3632	19.4204	3940608.0
2012-03-09 09:00:00	AAPL	Stock	19.4221	19.4443	19.4107	19.4429	1874824.0
2012-03-09 09:30:00	AAPL	Stock	19.4361	19.5621	19.4018	19.4732	96401340.0
2012-03-09 10:00:00	AAPL	Stock	19.4668	19.5139	19.4536	19.4712	45757516.0
2012-03-09 10:30:00	AAPL	Stock	19.4721	19.4982	19.4439	19.4964	36175272.0
2012-03-09 11:00:00	AAPL	Stock	19.4964	19.5132	19.475	19.4814	22875020.0
2012-03-09 11:30:00	AAPL	Stock	19.4804	19.4986	19.4664	19.4786	15958964.0
2012-03-09 12:00:00	AAPL	Stock	19.4804	19.4904	19.4679	19.4779	14238224.0
2012-03-09 12:30:00	AAPL	Stock	19.4789	19.4875	19.4707	19.4747	8996596.0
2012-03-09 13:00:00	AAPL	Stock	19.4736	19.4875	19.4571	19.4661	17684632.0
2012-03-09 13:30:00	AAPL	Stock	19.4639	19.4768	19.4621	19.4714	10022320.0
2012-03-09 14:00:00	AAPL	Stock	19.4725	19.4907	19.4679	19.4725	16293340.0
2012-03-09 14:30:00	AAPL	Stock	19.4739	19.4814	19.42	19.4221	26868100.0
2012-03-09 15:00:00	AAPL	Stock	19.4221	19.4532	19.3968	19.42	32874800.0
2012-03-09 15:30:00	AAPL	Stock	19.4205	19.4696	19.41	19.465	44492728.0
2012-03-09 16:00:00	AAPL	Stock	19.4696	19.4989	19.3568	19.4704	15194564.0
2012-03-09 16:30:00	AAPL	Stock	19.4629	19.486	19.4629	19.4632	537012.0
2012-03-09 17:00:00	AAPL	Stock	19.4646	19.465	19.4571	19.46	76748.0
2012-03-09 17:30:00	AAPL	Stock	19.4604	19.4643	19.4571	19.4643	52220.0
2012-03-09 18:00:00	AAPL	Stock	19.4664	19.4679	19.4643	19.465	133812.0
2012-03-09 18:30:00	AAPL	Stock	19.4693	19.4693	19.465	19.4679	56840.0
2012-03-09 19:00:00	AAPL	Stock	19.4675	19.4679	19.4643	19.4675	87808.0
2012-03-09 19:30:00	AAPL	Stock	19.4679	19.4704	19.4596	19.4596	325080.0
2012-03-09 07:00:00	MSFT	Stock	32.05	32.05	32.05	32.05	200.0
2012-03-09 07:30:00	MSFT	Stock	32.1	32.1	32.1	32.1	300.0
2012-03-09 08:00:00	MSFT	Stock	32.05	32.05	32.02	32.05	4500.0
2012-03-09 08:30:00	MSFT	Stock	32.09	32.1	32.07	32.08	17239.0
2012-03-09 09:00:00	MSFT	Stock	32.08	32.14	32.08	32.11	20130.0
2012-03-09 09:30:00	MSFT	Stock	32.11	32.16	31.96	31.98	3165815.0
2012-03-09 10:00:00	MSFT	Stock	31.985	32.04	31.92	32.0	3237247.0
2012-03-09 10:30:00	MSFT	Stock	32.01	32.07	31.96	32.06	3868201.0
2012-03-09 11:00:00	MSFT	Stock	32.065	32.07	31.964	31.98	2193438.0
2012-03-09 11:30:00	MSFT	Stock	31.98	32.01	31.95	31.995	2050053.0
2012-03-09 12:00:00	MSFT	Stock	31.995	32.05	31.96	32.048	2344604.0
2012-03-09 12:30:00	MSFT	Stock	32.045	32.05	31.98	31.995	879081.0
2012-03-09 13:00:00	MSFT	Stock	31.99	32.019	31.98	32.0	1256791.0
2012-03-09 13:30:00	MSFT	Stock	31.995	32.05	31.98	32.04	1106352.0
2012-03-09 14:00:00	MSFT	Stock	32.04	32.045	32.0	32.025	1530530.0
2012-03-09 14:30:00	MSFT	Stock	32.025	32.04	31.97	31.995	1813052.0
2012-03-09 15:00:00	MSFT	Stock	32.0	32.05	31.98	32.0	1847941.0
2012-03-09 15:30:00	MSFT	Stock	31.995	32.01	31.96	32.0	5442496.0

> showing 50 of 75,916 rows — these rows as CSV

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