PREVIEW / stock_30min / 2012-03-26

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-03-26.parquet
  size:    1.5 MB
  rows:    78,051
  symbols: 3,556

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-03-26 04:00:00	AAPL	Stock	21.3571	21.3571	21.3571	21.3571	2800.0
2012-03-26 04:30:00	AAPL	Stock	21.3514	21.3514	21.3514	21.3514	8400.0
2012-03-26 05:00:00	AAPL	Stock	21.3071	21.3071	21.3071	21.3071	2800.0
2012-03-26 05:30:00	AAPL	Stock	21.3214	21.3214	21.3214	21.3214	23912.0
2012-03-26 06:00:00	AAPL	Stock	21.3446	21.3571	21.3446	21.3571	375452.0
2012-03-26 06:30:00	AAPL	Stock	21.3625	21.3625	21.3486	21.3611	16884.0
2012-03-26 07:00:00	AAPL	Stock	21.3611	21.4107	21.3493	21.3786	361088.0
2012-03-26 07:30:00	AAPL	Stock	21.3839	21.4018	21.375	21.3821	267204.0
2012-03-26 08:00:00	AAPL	Stock	21.3832	21.4721	21.345	21.4536	3019296.0
2012-03-26 08:30:00	AAPL	Stock	21.4561	21.4568	21.4196	21.4254	1677032.0
2012-03-26 09:00:00	AAPL	Stock	21.4282	21.4286	21.4018	21.4254	2489088.0
2012-03-26 09:30:00	AAPL	Stock	21.4211	21.4282	21.3239	21.3789	76442856.0
2012-03-26 10:00:00	AAPL	Stock	21.3721	21.38	21.265	21.3004	50298472.0
2012-03-26 10:30:00	AAPL	Stock	21.3032	21.3379	21.2593	21.3246	31737468.0
2012-03-26 11:00:00	AAPL	Stock	21.3264	21.3571	21.3036	21.3425	21574588.0
2012-03-26 11:30:00	AAPL	Stock	21.3429	21.3496	21.3111	21.3233	17479980.0
2012-03-26 12:00:00	AAPL	Stock	21.3214	21.3293	21.3036	21.3136	10359804.0
2012-03-26 12:30:00	AAPL	Stock	21.3154	21.3564	21.3089	21.3268	15583260.0
2012-03-26 13:00:00	AAPL	Stock	21.3268	21.3757	21.3146	21.3664	16465736.0
2012-03-26 13:30:00	AAPL	Stock	21.3661	21.5275	21.3571	21.5054	56993748.0
2012-03-26 14:00:00	AAPL	Stock	21.505	21.6686	21.5032	21.6354	86467892.0
2012-03-26 14:30:00	AAPL	Stock	21.6386	21.6496	21.5886	21.6343	43272684.0
2012-03-26 15:00:00	AAPL	Stock	21.6332	21.6639	21.6111	21.6518	44784824.0
2012-03-26 15:30:00	AAPL	Stock	21.6525	21.6839	21.6121	21.6743	83225996.0
2012-03-26 16:00:00	AAPL	Stock	21.6746	21.6857	21.2789	21.6814	27706560.0
2012-03-26 16:30:00	AAPL	Stock	21.68	21.6825	21.6454	21.6454	943236.0
2012-03-26 17:00:00	AAPL	Stock	21.346	21.6782	21.346	21.6775	484932.0
2012-03-26 17:30:00	AAPL	Stock	21.6714	21.675	21.6679	21.6686	106428.0
2012-03-26 18:00:00	AAPL	Stock	21.6714	21.6796	21.6679	21.6796	280840.0
2012-03-26 18:30:00	AAPL	Stock	21.6793	21.6821	21.6779	21.6779	105224.0
2012-03-26 19:00:00	AAPL	Stock	21.6796	21.6796	21.6679	21.6743	136248.0
2012-03-26 19:30:00	AAPL	Stock	21.6696	21.6696	21.6518	21.6607	218204.0
2012-03-26 06:00:00	MSFT	Stock	31.95	31.95	31.95	31.95	185.0
2012-03-26 08:00:00	MSFT	Stock	32.11	32.25	32.06	32.25	25890.0
2012-03-26 08:30:00	MSFT	Stock	32.2	32.23	32.12	32.12	10450.0
2012-03-26 09:00:00	MSFT	Stock	32.17	32.21	32.13	32.19	46430.0
2012-03-26 09:30:00	MSFT	Stock	32.19	32.4	32.155	32.37	4332461.0
2012-03-26 10:00:00	MSFT	Stock	32.36	32.52	32.355	32.496	3330605.0
2012-03-26 10:30:00	MSFT	Stock	32.5	32.5	32.39	32.41	2412852.0
2012-03-26 11:00:00	MSFT	Stock	32.405	32.46	32.39	32.46	1766169.0
2012-03-26 11:30:00	MSFT	Stock	32.455	32.5	32.45	32.475	1696902.0
2012-03-26 12:00:00	MSFT	Stock	32.475	32.5	32.45	32.475	1934176.0
2012-03-26 12:30:00	MSFT	Stock	32.47	32.52	32.44	32.51	1563093.0
2012-03-26 13:00:00	MSFT	Stock	32.505	32.56	32.5	32.56	1517805.0
2012-03-26 13:30:00	MSFT	Stock	32.558	32.57	32.51	32.514	1296487.0
2012-03-26 14:00:00	MSFT	Stock	32.51	32.58	32.51	32.52	2013643.0
2012-03-26 14:30:00	MSFT	Stock	32.526	32.55	32.45	32.505	2337130.0
2012-03-26 15:00:00	MSFT	Stock	32.505	32.61	32.48	32.549	3047366.0
2012-03-26 15:30:00	MSFT	Stock	32.543	32.59	32.46	32.59	6264199.0
2012-03-26 16:00:00	MSFT	Stock	32.58	32.65	31.97	31.97	2505419.0

> showing 50 of 78,051 rows — these rows as CSV

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