PREVIEW / stock_30min / 2011-05-04

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-05-04.parquet
  size:    1.4 MB
  rows:    75,614
  symbols: 3,550

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-05-04 04:30:00	AAPL	Stock	12.4393	12.4393	12.4393	12.4393	2800.0
2011-05-04 05:00:00	AAPL	Stock	12.4464	12.4464	12.4464	12.4464	2800.0
2011-05-04 06:00:00	AAPL	Stock	12.4579	12.4579	12.4579	12.4579	2800.0
2011-05-04 06:30:00	AAPL	Stock	12.4107	12.4107	12.4107	12.4107	2800.0
2011-05-04 07:00:00	AAPL	Stock	12.4214	12.4214	12.4214	12.4214	2800.0
2011-05-04 07:30:00	AAPL	Stock	12.425	12.4279	12.425	12.4279	5600.0
2011-05-04 08:00:00	AAPL	Stock	12.4214	12.4589	12.4214	12.4554	343280.0
2011-05-04 08:30:00	AAPL	Stock	12.45	12.4589	12.4339	12.4518	318612.0
2011-05-04 09:00:00	AAPL	Stock	12.4554	12.4589	12.4325	12.4429	432488.0
2011-05-04 09:30:00	AAPL	Stock	12.4379	12.5654	12.3886	12.4979	75671624.0
2011-05-04 10:00:00	AAPL	Stock	12.4975	12.5357	12.4464	12.5143	42411376.0
2011-05-04 10:30:00	AAPL	Stock	12.5143	12.5357	12.4589	12.4979	34703144.0
2011-05-04 11:00:00	AAPL	Stock	12.4993	12.5082	12.4143	12.4582	29747004.0
2011-05-04 11:30:00	AAPL	Stock	12.4579	12.4636	12.4161	12.4225	17252312.0
2011-05-04 12:00:00	AAPL	Stock	12.4248	12.4468	12.4061	12.4156	15221136.0
2011-05-04 12:30:00	AAPL	Stock	12.4168	12.4525	12.4	12.4179	17709272.0
2011-05-04 13:00:00	AAPL	Stock	12.4162	12.4464	12.4139	12.4236	14129024.0
2011-05-04 13:30:00	AAPL	Stock	12.4231	12.4789	12.4229	12.4746	17206420.0
2011-05-04 14:00:00	AAPL	Stock	12.4746	12.5057	12.4507	12.4911	23003176.0
2011-05-04 14:30:00	AAPL	Stock	12.4918	12.5171	12.4764	12.4868	20330184.0
2011-05-04 15:00:00	AAPL	Stock	12.4846	12.5179	12.4779	12.5148	20316996.0
2011-05-04 15:30:00	AAPL	Stock	12.5132	12.5204	12.4671	12.4971	39523428.0
2011-05-04 16:00:00	AAPL	Stock	12.4961	12.4961	12.4643	12.4718	11088868.0
2011-05-04 16:30:00	AAPL	Stock	12.48	12.5118	12.4771	12.4771	565684.0
2011-05-04 17:00:00	AAPL	Stock	12.4807	12.4961	12.4786	12.4836	175476.0
2011-05-04 17:30:00	AAPL	Stock	12.4836	12.4961	12.4836	12.4868	107688.0
2011-05-04 18:00:00	AAPL	Stock	12.4868	12.4925	12.4846	12.4904	146188.0
2011-05-04 18:30:00	AAPL	Stock	12.4861	12.4964	12.4861	12.4961	45388.0
2011-05-04 19:00:00	AAPL	Stock	12.4939	12.4939	12.4939	12.4939	2800.0
2011-05-04 19:30:00	AAPL	Stock	12.49	12.4946	12.485	12.4946	111944.0
2011-05-04 04:30:00	MSFT	Stock	25.94	25.94	25.94	25.94	800.0
2011-05-04 05:30:00	MSFT	Stock	25.94	25.94	25.94	25.94	300.0
2011-05-04 06:30:00	MSFT	Stock	25.9	25.9	25.9	25.9	300.0
2011-05-04 07:00:00	MSFT	Stock	25.79	25.82	25.76	25.82	3200.0
2011-05-04 07:30:00	MSFT	Stock	25.77	25.77	25.77	25.77	100.0
2011-05-04 08:00:00	MSFT	Stock	25.8	25.83	25.8	25.82	6936.0
2011-05-04 08:30:00	MSFT	Stock	25.83	25.84	25.81	25.82	36890.0
2011-05-04 09:00:00	MSFT	Stock	25.82	25.87	25.78	25.87	26713.0
2011-05-04 09:30:00	MSFT	Stock	25.87	25.95	25.79	25.9	6459166.0
2011-05-04 10:00:00	MSFT	Stock	25.89	25.94	25.83	25.92	6786974.0
2011-05-04 10:30:00	MSFT	Stock	25.92	25.99	25.9	25.988	4727796.0
2011-05-04 11:00:00	MSFT	Stock	25.985	26.07	25.92	26.065	8556352.0
2011-05-04 11:30:00	MSFT	Stock	26.06	26.12	26.01	26.11	4869689.0
2011-05-04 12:00:00	MSFT	Stock	26.105	26.11	26.03	26.042	4174462.0
2011-05-04 12:30:00	MSFT	Stock	26.045	26.06	25.95	26.04	5906589.0
2011-05-04 13:00:00	MSFT	Stock	26.04	26.12	26.03	26.08	4005041.0
2011-05-04 13:30:00	MSFT	Stock	26.09	26.12	26.07	26.1	2905309.0
2011-05-04 14:00:00	MSFT	Stock	26.09	26.25	26.08	26.22	4809961.0
2011-05-04 14:30:00	MSFT	Stock	26.22	26.24	26.16	26.19	3632190.0
2011-05-04 15:00:00	MSFT	Stock	26.181	26.2	26.07	26.165	3977907.0

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

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