PREVIEW / stock_30min / 2013-04-01

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-04-01.parquet
  size:    1.5 MB
  rows:    78,796
  symbols: 3,471

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
2013-04-01 07:30:00	AAPL	Stock	15.7657	15.7857	15.7657	15.7857	64456.0
2013-04-01 08:00:00	AAPL	Stock	15.7682	15.8489	15.7679	15.8429	718592.0
2013-04-01 08:30:00	AAPL	Stock	15.8429	15.8482	15.8304	15.8375	519204.0
2013-04-01 09:00:00	AAPL	Stock	15.8357	15.8357	15.7818	15.7818	696304.0
2013-04-01 09:30:00	AAPL	Stock	15.7857	15.8464	15.5775	15.5943	74705260.0
2013-04-01 10:00:00	AAPL	Stock	15.5971	15.6061	15.4818	15.5411	53936932.0
2013-04-01 10:30:00	AAPL	Stock	15.5407	15.5775	15.475	15.5379	32531856.0
2013-04-01 11:00:00	AAPL	Stock	15.5396	15.5875	15.5154	15.5504	20651344.0
2013-04-01 11:30:00	AAPL	Stock	15.5493	15.5625	15.5189	15.5389	9571548.0
2013-04-01 12:00:00	AAPL	Stock	15.5364	15.5406	15.4821	15.5034	12242412.0
2013-04-01 12:30:00	AAPL	Stock	15.5018	15.5161	15.4739	15.5049	13404524.0
2013-04-01 13:00:00	AAPL	Stock	15.5046	15.5436	15.5032	15.5364	12755260.0
2013-04-01 13:30:00	AAPL	Stock	15.5368	15.5443	15.5046	15.5105	8171828.0
2013-04-01 14:00:00	AAPL	Stock	15.5114	15.5411	15.4829	15.4917	9329684.0
2013-04-01 14:30:00	AAPL	Stock	15.4918	15.5055	15.4561	15.4639	17829252.0
2013-04-01 15:00:00	AAPL	Stock	15.4611	15.4718	15.3668	15.3693	32217304.0
2013-04-01 15:30:00	AAPL	Stock	15.3704	15.3789	15.2764	15.3182	69234844.0
2013-04-01 16:00:00	AAPL	Stock	15.3168	15.5406	15.3039	15.3125	11605748.0
2013-04-01 16:30:00	AAPL	Stock	15.3071	15.3703	15.3043	15.3075	417536.0
2013-04-01 17:00:00	AAPL	Stock	15.31	15.3182	15.2946	15.3	1129772.0
2013-04-01 17:30:00	AAPL	Stock	15.3004	15.3161	15.3	15.315	181664.0
2013-04-01 18:00:00	AAPL	Stock	15.3125	15.3143	15.3036	15.3089	102424.0
2013-04-01 18:30:00	AAPL	Stock	15.3089	15.3179	15.3071	15.3125	147672.0
2013-04-01 19:00:00	AAPL	Stock	15.3161	15.3321	15.3125	15.3321	154224.0
2013-04-01 19:30:00	AAPL	Stock	15.3286	15.3407	15.3286	15.3407	147952.0
2013-04-01 04:00:00	MSFT	Stock	28.75	28.75	28.0	28.0	500.0
2013-04-01 08:00:00	MSFT	Stock	28.55	28.6	28.55	28.55	10570.0
2013-04-01 08:30:00	MSFT	Stock	28.6	28.6	28.56	28.6	2004.0
2013-04-01 09:00:00	MSFT	Stock	28.59	28.64	28.58	28.63	12542.0
2013-04-01 09:30:00	MSFT	Stock	28.63	28.66	28.53	28.599	3361454.0
2013-04-01 10:00:00	MSFT	Stock	28.6	28.605	28.36	28.513	3183114.0
2013-04-01 10:30:00	MSFT	Stock	28.51	28.53	28.47	28.48	3823747.0
2013-04-01 11:00:00	MSFT	Stock	28.48	28.55	28.43	28.55	1555886.0
2013-04-01 11:30:00	MSFT	Stock	28.545	28.59	28.53	28.545	1300277.0
2013-04-01 12:00:00	MSFT	Stock	28.552	28.56	28.5	28.52	907301.0
2013-04-01 12:30:00	MSFT	Stock	28.53	28.55	28.495	28.535	1785877.0
2013-04-01 13:00:00	MSFT	Stock	28.53	28.56	28.52	28.542	841246.0
2013-04-01 13:30:00	MSFT	Stock	28.535	28.55	28.5	28.512	833471.0
2013-04-01 14:00:00	MSFT	Stock	28.515	28.535	28.5	28.514	1019871.0
2013-04-01 14:30:00	MSFT	Stock	28.515	28.53	28.5	28.505	1417073.0
2013-04-01 15:00:00	MSFT	Stock	28.505	28.52	28.49	28.51	2159462.0
2013-04-01 15:30:00	MSFT	Stock	28.505	28.615	28.5	28.6	4294536.0
2013-04-01 16:00:00	MSFT	Stock	28.61	28.611	28.509	28.61	1564336.0
2013-04-01 16:30:00	MSFT	Stock	28.5	28.59	28.5	28.59	2500.0
2013-04-01 17:00:00	MSFT	Stock	28.61	28.61	28.58	28.58	260697.0
2013-04-01 18:00:00	MSFT	Stock	28.6	28.6	28.56	28.6	1900.0
2013-04-01 19:00:00	MSFT	Stock	28.6	28.6	28.6	28.6	800.0
2013-04-01 19:30:00	MSFT	Stock	28.58	28.58	28.58	28.58	1307.0
2013-04-01 08:00:00	NVDA	Stock	0.3213	0.3213	0.3213	0.3213	4000.0
2013-04-01 09:00:00	NVDA	Stock	0.32	0.3203	0.32	0.3203	68000.0

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

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