PREVIEW / stock_30min / 2011-10-27

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-10-27.parquet
  size:    1.5 MB
  rows:    81,404
  symbols: 3,557

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-10-27 04:00:00	AAPL	Stock	14.3714	14.5	14.3714	14.4779	31388.0
2011-10-27 04:30:00	AAPL	Stock	14.4961	14.5161	14.4821	14.5161	35000.0
2011-10-27 05:00:00	AAPL	Stock	14.5179	14.5179	14.5179	14.5179	19516.0
2011-10-27 05:30:00	AAPL	Stock	14.5179	14.5179	14.5	14.5089	14924.0
2011-10-27 06:00:00	AAPL	Stock	14.5357	14.5357	14.5179	14.5357	33600.0
2011-10-27 06:30:00	AAPL	Stock	14.5357	14.5607	14.5357	14.5607	33320.0
2011-10-27 07:00:00	AAPL	Stock	14.5625	14.6032	14.5286	14.5811	924784.0
2011-10-27 07:30:00	AAPL	Stock	14.5875	14.5893	14.5429	14.5739	563892.0
2011-10-27 08:00:00	AAPL	Stock	14.5721	14.5829	14.5357	14.5464	2946832.0
2011-10-27 08:30:00	AAPL	Stock	14.5536	14.5761	14.5432	14.5575	1628368.0
2011-10-27 09:00:00	AAPL	Stock	14.5571	14.5893	14.5546	14.5586	2004352.0
2011-10-27 09:30:00	AAPL	Stock	14.5586	14.6071	14.4939	14.5036	73857616.0
2011-10-27 10:00:00	AAPL	Stock	14.5011	14.5121	14.3707	14.3993	54163200.0
2011-10-27 10:30:00	AAPL	Stock	14.4032	14.4739	14.3532	14.4321	43467172.0
2011-10-27 11:00:00	AAPL	Stock	14.4318	14.4607	14.3893	14.4068	21400176.0
2011-10-27 11:30:00	AAPL	Stock	14.41	14.4689	14.3821	14.4646	27026804.0
2011-10-27 12:00:00	AAPL	Stock	14.4678	14.5089	14.4656	14.4883	26607252.0
2011-10-27 12:30:00	AAPL	Stock	14.4882	14.5071	14.4589	14.4686	16607696.0
2011-10-27 13:00:00	AAPL	Stock	14.4714	14.5436	14.4682	14.5236	28197428.0
2011-10-27 13:30:00	AAPL	Stock	14.5264	14.5579	14.5236	14.5504	22367520.0
2011-10-27 14:00:00	AAPL	Stock	14.5504	14.5657	14.4868	14.5175	32699996.0
2011-10-27 14:30:00	AAPL	Stock	14.5175	14.5357	14.4821	14.4944	22124340.0
2011-10-27 15:00:00	AAPL	Stock	14.4937	14.5375	14.4904	14.5086	26716088.0
2011-10-27 15:30:00	AAPL	Stock	14.5107	14.5214	14.4179	14.4457	58202844.0
2011-10-27 16:00:00	AAPL	Stock	14.4422	14.5	14.4336	14.4643	22944992.0
2011-10-27 16:30:00	AAPL	Stock	14.4614	14.5636	14.4536	14.4696	280000.0
2011-10-27 17:00:00	AAPL	Stock	14.4707	14.4707	14.4532	14.4536	625856.0
2011-10-27 17:30:00	AAPL	Stock	14.4536	14.4571	14.4214	14.4339	406868.0
2011-10-27 18:00:00	AAPL	Stock	14.4289	14.4532	14.4286	14.4339	150640.0
2011-10-27 18:30:00	AAPL	Stock	14.4429	14.4461	14.4296	14.4418	21000.0
2011-10-27 19:00:00	AAPL	Stock	14.4461	14.4461	14.4425	14.4461	23016.0
2011-10-27 19:30:00	AAPL	Stock	14.4446	14.4768	14.4446	14.4643	152880.0
2011-10-27 04:00:00	MSFT	Stock	26.64	26.85	26.64	26.85	5499.0
2011-10-27 04:30:00	MSFT	Stock	26.85	26.85	26.85	26.85	3401.0
2011-10-27 05:30:00	MSFT	Stock	26.87	26.99	26.87	26.98	3201.0
2011-10-27 06:00:00	MSFT	Stock	26.98	26.98	26.98	26.98	100.0
2011-10-27 06:30:00	MSFT	Stock	26.98	27.14	26.98	27.14	1400.0
2011-10-27 07:00:00	MSFT	Stock	27.05	27.07	27.0	27.04	5595.0
2011-10-27 07:30:00	MSFT	Stock	27.02	27.06	27.0	27.05	20111.0
2011-10-27 08:00:00	MSFT	Stock	27.03	27.05	26.96	27.04	69142.0
2011-10-27 08:30:00	MSFT	Stock	27.04	27.1	27.0	27.04	32831.0
2011-10-27 09:00:00	MSFT	Stock	27.03	27.19	27.02	27.15	89315.0
2011-10-27 09:30:00	MSFT	Stock	27.15	27.18	26.65	27.02	12569352.0
2011-10-27 10:00:00	MSFT	Stock	27.02	27.05	26.81	26.93	4541955.0
2011-10-27 10:30:00	MSFT	Stock	26.925	27.04	26.83	27.035	3287367.0
2011-10-27 11:00:00	MSFT	Stock	27.035	27.07	26.91	26.94	2855484.0
2011-10-27 11:30:00	MSFT	Stock	26.94	27.03	26.91	26.991	2621066.0
2011-10-27 12:00:00	MSFT	Stock	26.995	27.135	26.995	27.11	2777451.0
2011-10-27 12:30:00	MSFT	Stock	27.105	27.15	27.06	27.08	1952625.0
2011-10-27 13:00:00	MSFT	Stock	27.075	27.17	27.07	27.152	2460711.0

> showing 50 of 81,404 rows — these rows as CSV

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