PREVIEW / stock_30min / 2011-03-10

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-03-10.parquet
  size:    1.5 MB
  rows:    79,485
  symbols: 3,519

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
2011-03-10 04:00:00	AAPL	Stock	12.5354	12.5354	12.5354	12.5354	7000.0
2011-03-10 04:30:00	AAPL	Stock	12.5118	12.5204	12.5118	12.5204	30800.0
2011-03-10 05:30:00	AAPL	Stock	12.4839	12.4839	12.4839	12.4839	8792.0
2011-03-10 06:00:00	AAPL	Stock	12.515	12.5154	12.4907	12.4907	36120.0
2011-03-10 07:00:00	AAPL	Stock	12.49	12.5193	12.4714	12.5071	162876.0
2011-03-10 07:30:00	AAPL	Stock	12.5089	12.5089	12.4889	12.4964	265944.0
2011-03-10 08:00:00	AAPL	Stock	12.5	12.5311	12.4893	12.4939	1317680.0
2011-03-10 08:30:00	AAPL	Stock	12.4886	12.5036	12.4411	12.4496	2607500.0
2011-03-10 09:00:00	AAPL	Stock	12.4507	12.48	12.4286	12.48	3280060.0
2011-03-10 09:30:00	AAPL	Stock	12.4804	12.4957	12.3629	12.3971	83550068.0
2011-03-10 10:00:00	AAPL	Stock	12.3969	12.4	12.3179	12.3729	68568276.0
2011-03-10 10:30:00	AAPL	Stock	12.3729	12.4018	12.3396	12.3962	40099472.0
2011-03-10 11:00:00	AAPL	Stock	12.3959	12.4004	12.3704	12.3728	27240556.0
2011-03-10 11:30:00	AAPL	Stock	12.3725	12.3857	12.3411	12.3779	28474180.0
2011-03-10 12:00:00	AAPL	Stock	12.3768	12.3836	12.3439	12.3589	22643712.0
2011-03-10 12:30:00	AAPL	Stock	12.3586	12.4146	12.3446	12.4079	22225476.0
2011-03-10 13:00:00	AAPL	Stock	12.4098	12.4364	12.3732	12.376	33943224.0
2011-03-10 13:30:00	AAPL	Stock	12.3754	12.4029	12.3436	12.3804	40280940.0
2011-03-10 14:00:00	AAPL	Stock	12.3804	12.4286	12.3721	12.3964	24480344.0
2011-03-10 14:30:00	AAPL	Stock	12.3961	12.4275	12.3929	12.4077	21064764.0
2011-03-10 15:00:00	AAPL	Stock	12.4093	12.4168	12.3586	12.3721	23065672.0
2011-03-10 15:30:00	AAPL	Stock	12.3732	12.4193	12.3593	12.3825	46666256.0
2011-03-10 16:00:00	AAPL	Stock	12.3796	12.3889	12.3704	12.3836	10058608.0
2011-03-10 16:30:00	AAPL	Stock	12.3796	12.4018	12.3727	12.3982	1213632.0
2011-03-10 17:00:00	AAPL	Stock	12.3964	12.4129	12.3796	12.3896	915796.0
2011-03-10 17:30:00	AAPL	Stock	12.4011	12.4196	12.3957	12.4193	413476.0
2011-03-10 18:00:00	AAPL	Stock	12.4196	12.4196	12.3971	12.4025	123676.0
2011-03-10 18:30:00	AAPL	Stock	12.4107	12.425	12.3811	12.4196	333984.0
2011-03-10 19:00:00	AAPL	Stock	12.4111	12.4214	12.4111	12.4214	95340.0
2011-03-10 19:30:00	AAPL	Stock	12.4214	12.4225	12.4036	12.4071	197708.0
2011-03-10 04:00:00	MSFT	Stock	25.67	25.69	25.67	25.69	1700.0
2011-03-10 05:30:00	MSFT	Stock	25.7	25.7	25.7	25.7	2000.0
2011-03-10 06:00:00	MSFT	Stock	25.7	25.7	25.67	25.67	1500.0
2011-03-10 06:30:00	MSFT	Stock	25.7	25.7	25.7	25.7	2000.0
2011-03-10 07:00:00	MSFT	Stock	25.7	25.74	25.7	25.74	2300.0
2011-03-10 07:30:00	MSFT	Stock	25.74	25.75	25.71	25.71	1400.0
2011-03-10 08:00:00	MSFT	Stock	25.72	25.82	25.72	25.8	30196.0
2011-03-10 08:30:00	MSFT	Stock	25.75	25.79	25.7	25.71	21320.0
2011-03-10 09:00:00	MSFT	Stock	25.7	25.72	25.62	25.62	63309.0
2011-03-10 09:30:00	MSFT	Stock	25.62	25.67	25.46	25.54	8758218.0
2011-03-10 10:00:00	MSFT	Stock	25.535	25.6	25.42	25.52	7468575.0
2011-03-10 10:30:00	MSFT	Stock	25.51	25.55	25.46	25.527	4506443.0
2011-03-10 11:00:00	MSFT	Stock	25.525	25.61	25.52	25.6	2679686.0
2011-03-10 11:30:00	MSFT	Stock	25.6	25.67	25.58	25.637	3654589.0
2011-03-10 12:00:00	MSFT	Stock	25.63	25.67	25.52	25.55	2399527.0
2011-03-10 12:30:00	MSFT	Stock	25.551	25.67	25.53	25.67	2298919.0
2011-03-10 13:00:00	MSFT	Stock	25.67	25.71	25.58	25.6	3981710.0
2011-03-10 13:30:00	MSFT	Stock	25.6	25.61	25.455	25.551	5077331.0
2011-03-10 14:00:00	MSFT	Stock	25.559	25.57	25.5	25.5	3143180.0
2011-03-10 14:30:00	MSFT	Stock	25.5	25.575	25.5	25.539	3255402.0

> showing 50 of 79,485 rows — these rows as CSV

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