PREVIEW / stock_30min / 2011-07-19

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-07-19.parquet
  size:    1.4 MB
  rows:    76,691
  symbols: 3,530

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-07-19 04:00:00	AAPL	Stock	13.4404	13.4643	13.4404	13.4554	8400.0
2011-07-19 04:30:00	AAPL	Stock	13.4643	13.4696	13.4643	13.4646	23408.0
2011-07-19 05:00:00	AAPL	Stock	13.4646	13.4646	13.4646	13.4646	2800.0
2011-07-19 05:30:00	AAPL	Stock	13.465	13.4757	13.4536	13.4536	49392.0
2011-07-19 06:00:00	AAPL	Stock	13.4643	13.4643	13.4639	13.4639	8400.0
2011-07-19 06:30:00	AAPL	Stock	13.4643	13.4643	13.4082	13.4329	64400.0
2011-07-19 07:00:00	AAPL	Stock	13.4143	13.4821	13.4129	13.4464	502908.0
2011-07-19 07:30:00	AAPL	Stock	13.4464	13.4643	13.4321	13.4557	472612.0
2011-07-19 08:00:00	AAPL	Stock	13.4557	13.5154	13.4518	13.5054	4959248.0
2011-07-19 08:30:00	AAPL	Stock	13.5111	13.5625	13.5082	13.5193	4025420.0
2011-07-19 09:00:00	AAPL	Stock	13.5186	13.5254	13.4875	13.5	3085348.0
2011-07-19 09:30:00	AAPL	Stock	13.4996	13.5082	13.4107	13.4654	105594440.0
2011-07-19 10:00:00	AAPL	Stock	13.4675	13.5232	13.4589	13.4864	47006540.0
2011-07-19 10:30:00	AAPL	Stock	13.4886	13.5054	13.4614	13.4643	37249016.0
2011-07-19 11:00:00	AAPL	Stock	13.4622	13.4764	13.4362	13.4375	29204532.0
2011-07-19 11:30:00	AAPL	Stock	13.4371	13.4375	13.3329	13.4196	73971716.0
2011-07-19 12:00:00	AAPL	Stock	13.4214	13.4229	13.3714	13.3761	32167884.0
2011-07-19 12:30:00	AAPL	Stock	13.3771	13.4143	13.3643	13.4068	26184788.0
2011-07-19 13:00:00	AAPL	Stock	13.4066	13.4161	13.3821	13.4054	36297576.0
2011-07-19 13:30:00	AAPL	Stock	13.4039	13.4214	13.38	13.4131	40497632.0
2011-07-19 14:00:00	AAPL	Stock	13.4132	13.4718	13.4082	13.4395	44218608.0
2011-07-19 14:30:00	AAPL	Stock	13.4407	13.4639	13.4196	13.4434	31052448.0
2011-07-19 15:00:00	AAPL	Stock	13.4454	13.4561	13.3968	13.4264	72522184.0
2011-07-19 15:30:00	AAPL	Stock	13.4262	13.4589	13.4236	13.4589	77325164.0
2011-07-19 16:00:00	AAPL	Stock	13.4419	13.4879	13.375	13.4389	10169292.0
2011-07-19 16:30:00	AAPL	Stock	14.2857	14.4643	13.4292	14.1893	68664848.0
2011-07-19 17:00:00	AAPL	Stock	14.1889	14.2679	14.1314	14.1839	38107916.0
2011-07-19 17:30:00	AAPL	Stock	14.1821	14.2111	13.4589	14.1714	10919328.0
2011-07-19 18:00:00	AAPL	Stock	14.1711	14.1964	13.4589	14.0968	4462892.0
2011-07-19 18:30:00	AAPL	Stock	14.1	14.1029	14.0268	14.0296	3228260.0
2011-07-19 19:00:00	AAPL	Stock	14.0307	14.0679	14.0114	14.0446	1585136.0
2011-07-19 19:30:00	AAPL	Stock	14.0475	14.0893	14.0379	14.0714	1225504.0
2011-07-19 05:30:00	MSFT	Stock	26.75	26.86	26.75	26.86	200.0
2011-07-19 07:00:00	MSFT	Stock	26.75	26.75	26.75	26.75	100.0
2011-07-19 07:30:00	MSFT	Stock	26.78	26.79	26.72	26.72	1400.0
2011-07-19 08:00:00	MSFT	Stock	26.7	26.71	26.68	26.7	4255.0
2011-07-19 08:30:00	MSFT	Stock	26.75	26.77	26.72	26.74	8570.0
2011-07-19 09:00:00	MSFT	Stock	26.75	26.84	26.72	26.8	50408.0
2011-07-19 09:30:00	MSFT	Stock	26.81	27.09	26.78	26.985	8684646.0
2011-07-19 10:00:00	MSFT	Stock	26.99	27.14	26.965	27.14	4547179.0
2011-07-19 10:30:00	MSFT	Stock	27.14	27.218	27.02	27.17	6743338.0
2011-07-19 11:00:00	MSFT	Stock	27.17	27.25	27.15	27.205	4452225.0
2011-07-19 11:30:00	MSFT	Stock	27.2	27.25	27.18	27.22	3793283.0
2011-07-19 12:00:00	MSFT	Stock	27.23	27.27	27.18	27.255	3563305.0
2011-07-19 12:30:00	MSFT	Stock	27.26	27.43	27.255	27.353	5339757.0
2011-07-19 13:00:00	MSFT	Stock	27.36	27.43	27.32	27.425	3560992.0
2011-07-19 13:30:00	MSFT	Stock	27.425	27.58	27.4	27.536	8066723.0
2011-07-19 14:00:00	MSFT	Stock	27.532	27.555	27.38	27.48	7994078.0
2011-07-19 14:30:00	MSFT	Stock	27.49	27.53	27.45	27.49	4283162.0
2011-07-19 15:00:00	MSFT	Stock	27.481	27.64	27.48	27.59	6500724.0

> showing 50 of 76,691 rows — these rows as CSV

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