PREVIEW / stock_30min / 2011-09-02

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-09-02.parquet
  size:    1.4 MB
  rows:    75,359
  symbols: 3,475

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-09-02 04:00:00	AAPL	Stock	13.5714	13.5714	13.5621	13.5621	16800.0
2011-09-02 05:00:00	AAPL	Stock	13.5493	13.5493	13.5357	13.5357	5600.0
2011-09-02 05:30:00	AAPL	Stock	13.5393	13.5393	13.5071	13.5357	16100.0
2011-09-02 06:30:00	AAPL	Stock	13.5179	13.5357	13.5179	13.5357	79800.0
2011-09-02 07:00:00	AAPL	Stock	13.5357	13.5536	13.52	13.5536	120932.0
2011-09-02 07:30:00	AAPL	Stock	13.5525	13.5525	13.5268	13.5268	146636.0
2011-09-02 08:00:00	AAPL	Stock	13.5354	13.5625	13.5125	13.5625	708652.0
2011-09-02 08:30:00	AAPL	Stock	13.5657	13.5893	13.4018	13.4279	5051592.0
2011-09-02 09:00:00	AAPL	Stock	13.4243	13.43	13.375	13.385	4050144.0
2011-09-02 09:30:00	AAPL	Stock	13.3846	13.4325	13.3304	13.4261	76298320.0
2011-09-02 10:00:00	AAPL	Stock	13.4218	13.5	13.4157	13.4668	50835624.0
2011-09-02 10:30:00	AAPL	Stock	13.4664	13.4757	13.4325	13.4679	25685044.0
2011-09-02 11:00:00	AAPL	Stock	13.4718	13.4764	13.4532	13.4675	21291172.0
2011-09-02 11:30:00	AAPL	Stock	13.4632	13.4711	13.4146	13.4293	17474128.0
2011-09-02 12:00:00	AAPL	Stock	13.4293	13.4507	13.4215	13.4289	14404684.0
2011-09-02 12:30:00	AAPL	Stock	13.4304	13.4336	13.4018	13.4107	13582044.0
2011-09-02 13:00:00	AAPL	Stock	13.4107	13.4171	13.3679	13.3764	18911508.0
2011-09-02 13:30:00	AAPL	Stock	13.3781	13.3882	13.3571	13.3639	16506980.0
2011-09-02 14:00:00	AAPL	Stock	13.365	13.3689	13.3107	13.3182	32807432.0
2011-09-02 14:30:00	AAPL	Stock	13.3182	13.3279	13.2929	13.3061	30894164.0
2011-09-02 15:00:00	AAPL	Stock	13.3054	13.3409	13.2796	13.3311	35939904.0
2011-09-02 15:30:00	AAPL	Stock	13.3329	13.3768	13.3232	13.3589	53070248.0
2011-09-02 16:00:00	AAPL	Stock	13.3571	13.3953	13.3554	13.3661	18439400.0
2011-09-02 16:30:00	AAPL	Stock	13.3682	13.3821	13.3311	13.3786	592424.0
2011-09-02 17:00:00	AAPL	Stock	13.3807	13.3846	13.375	13.3768	129892.0
2011-09-02 17:30:00	AAPL	Stock	13.3782	13.3782	13.3646	13.3646	99540.0
2011-09-02 18:00:00	AAPL	Stock	13.3632	13.3696	13.3589	13.3643	92736.0
2011-09-02 18:30:00	AAPL	Stock	13.365	13.365	13.3607	13.3646	53480.0
2011-09-02 19:00:00	AAPL	Stock	13.3675	13.3693	13.3646	13.3668	51520.0
2011-09-02 19:30:00	AAPL	Stock	13.3664	13.3782	13.3661	13.3782	92148.0
2011-09-02 06:00:00	MSFT	Stock	26.06	26.06	26.06	26.06	200.0
2011-09-02 07:00:00	MSFT	Stock	26.0	26.0	26.0	26.0	1388.0
2011-09-02 07:30:00	MSFT	Stock	26.0	26.0	26.0	26.0	300.0
2011-09-02 08:00:00	MSFT	Stock	26.01	26.04	26.0	26.03	10226.0
2011-09-02 08:30:00	MSFT	Stock	26.03	26.03	25.78	26.0	64336.0
2011-09-02 09:00:00	MSFT	Stock	26.0	26.0	25.78	25.8	33216.0
2011-09-02 09:30:00	MSFT	Stock	25.81	26.0	25.76	25.91	5297125.0
2011-09-02 10:00:00	MSFT	Stock	25.91	25.95	25.82	25.882	4111465.0
2011-09-02 10:30:00	MSFT	Stock	25.88	25.885	25.76	25.81	3133730.0
2011-09-02 11:00:00	MSFT	Stock	25.815	25.85	25.78	25.82	3622301.0
2011-09-02 11:30:00	MSFT	Stock	25.82	25.87	25.79	25.829	2555587.0
2011-09-02 12:00:00	MSFT	Stock	25.822	25.94	25.822	25.909	1391204.0
2011-09-02 12:30:00	MSFT	Stock	25.9	25.94	25.88	25.939	1188686.0
2011-09-02 13:00:00	MSFT	Stock	25.93	25.95	25.85	25.875	1327996.0
2011-09-02 13:30:00	MSFT	Stock	25.87	25.92	25.84	25.865	1233951.0
2011-09-02 14:00:00	MSFT	Stock	25.87	25.89	25.74	25.81	2836002.0
2011-09-02 14:30:00	MSFT	Stock	25.81	25.83	25.7	25.74	3058653.0
2011-09-02 15:00:00	MSFT	Stock	25.735	25.8	25.66	25.75	2340405.0
2011-09-02 15:30:00	MSFT	Stock	25.759	25.95	25.73	25.8	7715092.0
2011-09-02 16:00:00	MSFT	Stock	25.8	25.86	25.775	25.775	2860853.0

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

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