PREVIEW / stock_30min / 2010-08-12

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-08-12.parquet
  size:    1.4 MB
  rows:    75,479
  symbols: 3,466

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
2010-08-12 05:00:00	AAPL	Stock	8.8161	8.8357	8.8161	8.8211	70000.0
2010-08-12 06:00:00	AAPL	Stock	8.8375	8.8393	8.8143	8.8179	17640.0
2010-08-12 06:30:00	AAPL	Stock	8.8411	8.8879	8.8411	8.8732	67060.0
2010-08-12 07:00:00	AAPL	Stock	8.8732	8.8929	8.8714	8.8732	129920.0
2010-08-12 07:30:00	AAPL	Stock	8.8732	8.8814	8.8571	8.8643	52892.0
2010-08-12 08:00:00	AAPL	Stock	8.8661	8.9	8.8571	8.8921	1576596.0
2010-08-12 08:30:00	AAPL	Stock	8.8918	8.8964	8.8164	8.8286	4409748.0
2010-08-12 09:00:00	AAPL	Stock	8.8304	8.835	8.8014	8.8104	2189208.0
2010-08-12 09:30:00	AAPL	Stock	8.8089	8.9278	8.79	8.9125	110430404.0
2010-08-12 10:00:00	AAPL	Stock	8.9127	8.9964	8.9079	8.9671	79755060.0
2010-08-12 10:30:00	AAPL	Stock	8.9646	9.0343	8.9607	9.0143	59431344.0
2010-08-12 11:00:00	AAPL	Stock	9.0144	9.0393	9.0089	9.015	36180928.0
2010-08-12 11:30:00	AAPL	Stock	9.0137	9.0311	8.9871	9.0014	27396544.0
2010-08-12 12:00:00	AAPL	Stock	9.0025	9.0157	8.9864	9.0057	16826264.0
2010-08-12 12:30:00	AAPL	Stock	9.0057	9.0207	8.9875	9.0168	19188792.0
2010-08-12 13:00:00	AAPL	Stock	9.0175	9.0286	8.9875	8.9882	19253724.0
2010-08-12 13:30:00	AAPL	Stock	8.9875	8.9946	8.9482	8.9618	24711428.0
2010-08-12 14:00:00	AAPL	Stock	8.9614	8.975	8.9525	8.9711	18558008.0
2010-08-12 14:30:00	AAPL	Stock	8.9711	8.9929	8.9446	8.9793	25068064.0
2010-08-12 15:00:00	AAPL	Stock	8.9793	9.015	8.9786	8.9914	30681280.0
2010-08-12 15:30:00	AAPL	Stock	8.9914	9.0118	8.9661	8.9925	41669124.0
2010-08-12 16:00:00	AAPL	Stock	8.9907	9.0096	8.8048	8.9925	8745352.0
2010-08-12 16:30:00	AAPL	Stock	8.9893	8.9964	8.9622	8.9946	105504.0
2010-08-12 17:00:00	AAPL	Stock	8.9311	9.0	8.9311	9.0	51520.0
2010-08-12 17:30:00	AAPL	Stock	9.0061	9.0089	9.0	9.0086	101080.0
2010-08-12 18:00:00	AAPL	Stock	9.0054	9.0089	8.9925	9.0089	127372.0
2010-08-12 18:30:00	AAPL	Stock	9.0086	9.0118	9.0086	9.0118	12740.0
2010-08-12 19:00:00	AAPL	Stock	9.0107	9.0179	9.0107	9.0125	82432.0
2010-08-12 19:30:00	AAPL	Stock	9.0171	9.0232	9.0143	9.0225	385392.0
2010-08-12 07:30:00	MSFT	Stock	24.68	24.68	24.68	24.68	200.0
2010-08-12 08:00:00	MSFT	Stock	24.66	24.66	24.5	24.55	4520.0
2010-08-12 08:30:00	MSFT	Stock	24.52	24.6	24.51	24.53	19549.0
2010-08-12 09:00:00	MSFT	Stock	24.51	24.86	24.41	24.43	261189.0
2010-08-12 09:30:00	MSFT	Stock	24.42	24.682	24.36	24.61	8427875.0
2010-08-12 10:00:00	MSFT	Stock	24.61	24.62	24.4	24.43	6559770.0
2010-08-12 10:30:00	MSFT	Stock	24.435	24.575	24.42	24.505	4472391.0
2010-08-12 11:00:00	MSFT	Stock	24.493	24.55	24.431	24.5	4846001.0
2010-08-12 11:30:00	MSFT	Stock	24.49	24.56	24.46	24.5	2987737.0
2010-08-12 12:00:00	MSFT	Stock	24.5	24.505	24.45	24.467	1771396.0
2010-08-12 12:30:00	MSFT	Stock	24.46	24.58	24.46	24.56	2902931.0
2010-08-12 13:00:00	MSFT	Stock	24.56	24.57	24.47	24.488	4890043.0
2010-08-12 13:30:00	MSFT	Stock	24.48	24.5	24.39	24.456	5568686.0
2010-08-12 14:00:00	MSFT	Stock	24.458	24.51	24.45	24.48	4056913.0
2010-08-12 14:30:00	MSFT	Stock	24.48	24.5	24.44	24.482	5231858.0
2010-08-12 15:00:00	MSFT	Stock	24.48	24.55	24.47	24.505	6018732.0
2010-08-12 15:30:00	MSFT	Stock	24.5	24.56	24.47	24.51	7905803.0
2010-08-12 16:00:00	MSFT	Stock	24.49	24.53	24.48	24.51	2210478.0
2010-08-12 16:30:00	MSFT	Stock	24.5	24.55	24.46	24.52	16860.0
2010-08-12 17:00:00	MSFT	Stock	24.58	24.58	24.5	24.57	32032.0
2010-08-12 17:30:00	MSFT	Stock	24.54	24.56	24.52	24.55	3200.0

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

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