PREVIEW / stock_30min / 2011-10-10

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-10-10.parquet
  size:    1.4 MB
  rows:    74,746
  symbols: 3,474

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-10 04:00:00	AAPL	Stock	13.3557	13.3557	13.3286	13.3357	47040.0
2011-10-10 04:30:00	AAPL	Stock	13.3557	13.3557	13.3557	13.3557	8400.0
2011-10-10 05:30:00	AAPL	Stock	13.3571	13.3571	13.3571	13.3571	8400.0
2011-10-10 06:00:00	AAPL	Stock	13.375	13.3925	13.375	13.3925	8400.0
2011-10-10 06:30:00	AAPL	Stock	13.3857	13.3925	13.375	13.375	134848.0
2011-10-10 07:00:00	AAPL	Stock	13.3921	13.4286	13.375	13.4286	301644.0
2011-10-10 07:30:00	AAPL	Stock	13.4239	13.4239	13.3946	13.4086	237160.0
2011-10-10 08:00:00	AAPL	Stock	13.4014	13.4054	13.3571	13.3871	1582700.0
2011-10-10 08:30:00	AAPL	Stock	13.3875	13.5475	13.3875	13.5357	5153456.0
2011-10-10 09:00:00	AAPL	Stock	13.5357	13.5536	13.5189	13.5393	2941764.0
2011-10-10 09:30:00	AAPL	Stock	13.5389	13.6385	13.5075	13.638	77315672.0
2011-10-10 10:00:00	AAPL	Stock	13.6371	13.7411	13.6129	13.6868	59578736.0
2011-10-10 10:30:00	AAPL	Stock	13.6843	13.7286	13.6568	13.6729	31372908.0
2011-10-10 11:00:00	AAPL	Stock	13.6737	13.7	13.6393	13.6962	25482184.0
2011-10-10 11:30:00	AAPL	Stock	13.6966	13.7354	13.6893	13.735	19439056.0
2011-10-10 12:00:00	AAPL	Stock	13.7345	13.7536	13.7204	13.7382	22080884.0
2011-10-10 12:30:00	AAPL	Stock	13.7357	13.7446	13.6946	13.7125	17393180.0
2011-10-10 13:00:00	AAPL	Stock	13.7125	13.7429	13.6943	13.73	12597368.0
2011-10-10 13:30:00	AAPL	Stock	13.7306	13.7414	13.7189	13.7329	11757648.0
2011-10-10 14:00:00	AAPL	Stock	13.7363	13.7475	13.7039	13.7446	15040816.0
2011-10-10 14:30:00	AAPL	Stock	13.7461	13.7814	13.735	13.735	26798492.0
2011-10-10 15:00:00	AAPL	Stock	13.735	13.75	13.7039	13.7175	27660864.0
2011-10-10 15:30:00	AAPL	Stock	13.7171	13.8861	13.7071	13.8861	67688208.0
2011-10-10 16:00:00	AAPL	Stock	13.885	13.9107	13.7006	13.8964	9468816.0
2011-10-10 16:30:00	AAPL	Stock	13.8964	13.9357	13.6805	13.9289	920024.0
2011-10-10 17:00:00	AAPL	Stock	13.9325	13.9629	13.8861	13.9557	1137640.0
2011-10-10 17:30:00	AAPL	Stock	13.9482	13.9561	13.9339	13.9536	312844.0
2011-10-10 18:00:00	AAPL	Stock	13.955	13.9796	13.9504	13.9571	516152.0
2011-10-10 18:30:00	AAPL	Stock	13.9571	13.9571	13.9446	13.9464	189756.0
2011-10-10 19:00:00	AAPL	Stock	13.95	13.9589	13.9321	13.9336	342552.0
2011-10-10 19:30:00	AAPL	Stock	13.9343	13.9536	13.9293	13.9375	308700.0
2011-10-10 04:00:00	MSFT	Stock	26.55	26.55	26.55	26.55	100.0
2011-10-10 05:30:00	MSFT	Stock	26.53	26.53	26.53	26.53	200.0
2011-10-10 06:30:00	MSFT	Stock	26.66	26.66	26.66	26.66	200.0
2011-10-10 07:00:00	MSFT	Stock	26.6	26.64	26.6	26.64	2500.0
2011-10-10 07:30:00	MSFT	Stock	26.63	26.64	26.59	26.63	1900.0
2011-10-10 08:00:00	MSFT	Stock	26.58	26.63	26.5	26.63	22812.0
2011-10-10 08:30:00	MSFT	Stock	26.64	26.69	26.58	26.6	9350.0
2011-10-10 09:00:00	MSFT	Stock	26.6	26.68	26.5	26.58	159329.0
2011-10-10 09:30:00	MSFT	Stock	26.57	26.67	26.47	26.61	4329896.0
2011-10-10 10:00:00	MSFT	Stock	26.61	26.73	26.59	26.725	4049004.0
2011-10-10 10:30:00	MSFT	Stock	26.72	26.8	26.64	26.73	3735794.0
2011-10-10 11:00:00	MSFT	Stock	26.73	26.78	26.71	26.779	2009382.0
2011-10-10 11:30:00	MSFT	Stock	26.778	26.835	26.76	26.812	1482458.0
2011-10-10 12:00:00	MSFT	Stock	26.82	26.82	26.76	26.79	1445443.0
2011-10-10 12:30:00	MSFT	Stock	26.79	26.82	26.73	26.78	1677230.0
2011-10-10 13:00:00	MSFT	Stock	26.78	26.84	26.77	26.815	1927977.0
2011-10-10 13:30:00	MSFT	Stock	26.81	26.85	26.795	26.804	1419824.0
2011-10-10 14:00:00	MSFT	Stock	26.8	26.83	26.74	26.81	1812382.0
2011-10-10 14:30:00	MSFT	Stock	26.82	26.835	26.732	26.75	1791557.0

> showing 50 of 74,746 rows — these rows as CSV

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