PREVIEW / stock_30min / 2012-04-17

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-04-17.parquet
  size:    1.4 MB
  rows:    75,776
  symbols: 3,546

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
2012-04-17 04:00:00	AAPL	Stock	20.6679	20.6679	20.2679	20.4464	505400.0
2012-04-17 04:30:00	AAPL	Stock	20.4639	20.5311	20.4361	20.5179	108948.0
2012-04-17 05:00:00	AAPL	Stock	20.5143	20.6214	20.5143	20.6071	147168.0
2012-04-17 05:30:00	AAPL	Stock	20.6071	20.6739	20.6071	20.6729	240660.0
2012-04-17 06:00:00	AAPL	Stock	20.6675	20.6786	20.6321	20.6786	287868.0
2012-04-17 06:30:00	AAPL	Stock	20.6786	20.75	20.6707	20.75	219352.0
2012-04-17 07:00:00	AAPL	Stock	20.7321	20.7321	20.5446	20.6664	1720936.0
2012-04-17 07:30:00	AAPL	Stock	20.6789	20.6893	20.6214	20.6761	746228.0
2012-04-17 08:00:00	AAPL	Stock	20.6654	20.8836	20.5821	20.8464	4589816.0
2012-04-17 08:30:00	AAPL	Stock	20.8457	20.8511	20.7757	20.7889	2923620.0
2012-04-17 09:00:00	AAPL	Stock	20.7929	20.8254	20.6429	20.6714	5782840.0
2012-04-17 09:30:00	AAPL	Stock	20.6764	21.0325	20.4254	20.9957	206686508.0
2012-04-17 10:00:00	AAPL	Stock	20.9914	21.2746	20.9375	21.21	137418904.0
2012-04-17 10:30:00	AAPL	Stock	21.2093	21.3003	21.1179	21.2857	76871900.0
2012-04-17 11:00:00	AAPL	Stock	21.2875	21.4	21.285	21.3259	76986280.0
2012-04-17 11:30:00	AAPL	Stock	21.3239	21.4107	21.2964	21.3774	41749344.0
2012-04-17 12:00:00	AAPL	Stock	21.378	21.4554	21.3657	21.4247	45803744.0
2012-04-17 12:30:00	AAPL	Stock	21.4275	21.5871	21.4114	21.5643	69320300.0
2012-04-17 13:00:00	AAPL	Stock	21.5643	21.5993	21.4768	21.5716	51588852.0
2012-04-17 13:30:00	AAPL	Stock	21.5743	21.651	21.5611	21.6075	47466552.0
2012-04-17 14:00:00	AAPL	Stock	21.6086	21.6357	21.5625	21.609	35548268.0
2012-04-17 14:30:00	AAPL	Stock	21.6102	21.6418	21.5821	21.6379	29674568.0
2012-04-17 15:00:00	AAPL	Stock	21.6368	21.7564	21.6261	21.752	57741152.0
2012-04-17 15:30:00	AAPL	Stock	21.7512	21.7857	21.6468	21.7607	96455072.0
2012-04-17 16:00:00	AAPL	Stock	21.7717	21.7794	20.7386	21.6943	11658836.0
2012-04-17 16:30:00	AAPL	Stock	21.6879	21.775	20.6813	21.7143	1330336.0
2012-04-17 17:00:00	AAPL	Stock	21.73	21.775	21.7036	21.7064	2261616.0
2012-04-17 17:30:00	AAPL	Stock	21.7125	21.775	21.7036	21.7157	2981916.0
2012-04-17 18:00:00	AAPL	Stock	21.7214	21.7504	21.7136	21.75	489916.0
2012-04-17 18:30:00	AAPL	Stock	21.7568	21.7746	21.7321	21.75	343000.0
2012-04-17 19:00:00	AAPL	Stock	21.7589	21.7589	21.735	21.7393	108892.0
2012-04-17 19:30:00	AAPL	Stock	21.7414	21.7589	21.7393	21.75	229572.0
2012-04-17 20:00:00	AAPL	Stock	21.7586	21.7586	21.7586	21.7586	2800.0
2012-04-17 07:30:00	MSFT	Stock	31.25	31.25	31.2	31.25	822.0
2012-04-17 08:00:00	MSFT	Stock	31.22	31.24	31.16	31.21	3397.0
2012-04-17 08:30:00	MSFT	Stock	31.2	31.25	31.2	31.25	1882.0
2012-04-17 09:00:00	MSFT	Stock	31.24	31.29	31.2	31.21	4075.0
2012-04-17 09:30:00	MSFT	Stock	31.27	31.36	31.2	31.295	3788781.0
2012-04-17 10:00:00	MSFT	Stock	31.305	31.38	31.23	31.35	2916159.0
2012-04-17 10:30:00	MSFT	Stock	31.36	31.46	31.32	31.38	2053280.0
2012-04-17 11:00:00	MSFT	Stock	31.38	31.5	31.38	31.45	2199718.0
2012-04-17 11:30:00	MSFT	Stock	31.45	31.53	31.43	31.48	1889793.0
2012-04-17 12:00:00	MSFT	Stock	31.48	31.52	31.46	31.495	1820413.0
2012-04-17 12:30:00	MSFT	Stock	31.49	31.58	31.49	31.565	1383815.0
2012-04-17 13:00:00	MSFT	Stock	31.56	31.61	31.56	31.575	1587681.0
2012-04-17 13:30:00	MSFT	Stock	31.575	31.6	31.54	31.578	1832163.0
2012-04-17 14:00:00	MSFT	Stock	31.57	31.6	31.54	31.58	1853846.0
2012-04-17 14:30:00	MSFT	Stock	31.58	31.59	31.52	31.55	1773990.0
2012-04-17 15:00:00	MSFT	Stock	31.55	31.6	31.51	31.6	1444761.0
2012-04-17 15:30:00	MSFT	Stock	31.591	31.6	31.44	31.44	4306368.0

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

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