PREVIEW / stock_30min / 2012-11-01

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-11-01.parquet
  size:    1.4 MB
  rows:    75,644
  symbols: 3,479

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-11-01 05:30:00	AAPL	Stock	21.25	21.25	21.25	21.25	4144.0
2012-11-01 06:00:00	AAPL	Stock	21.2404	21.2411	21.2404	21.2411	5936.0
2012-11-01 07:00:00	AAPL	Stock	21.2854	21.3	21.2679	21.3	38892.0
2012-11-01 07:30:00	AAPL	Stock	21.3032	21.3304	21.3032	21.3207	38724.0
2012-11-01 08:00:00	AAPL	Stock	21.3161	21.3343	21.2686	21.3168	491624.0
2012-11-01 08:30:00	AAPL	Stock	21.3211	21.3571	21.2536	21.3571	806344.0
2012-11-01 09:00:00	AAPL	Stock	21.3579	21.4107	21.3579	21.3714	1187956.0
2012-11-01 09:30:00	AAPL	Stock	21.3618	21.4211	21.2204	21.2625	50745184.0
2012-11-01 10:00:00	AAPL	Stock	21.2714	21.4286	21.2582	21.3971	37142504.0
2012-11-01 10:30:00	AAPL	Stock	21.3911	21.5161	21.3429	21.4971	35840924.0
2012-11-01 11:00:00	AAPL	Stock	21.4975	21.5357	21.4321	21.4586	28559048.0
2012-11-01 11:30:00	AAPL	Stock	21.4536	21.5071	21.395	21.4268	19900832.0
2012-11-01 12:00:00	AAPL	Stock	21.4268	21.4286	21.3811	21.4232	12524904.0
2012-11-01 12:30:00	AAPL	Stock	21.4254	21.4286	21.3532	21.3554	13896372.0
2012-11-01 13:00:00	AAPL	Stock	21.3571	21.3618	21.2671	21.2725	22901284.0
2012-11-01 13:30:00	AAPL	Stock	21.2736	21.3171	21.25	21.2682	21109340.0
2012-11-01 14:00:00	AAPL	Stock	21.275	21.3696	21.2618	21.3525	19329492.0
2012-11-01 14:30:00	AAPL	Stock	21.3529	21.3925	21.3114	21.3172	19104596.0
2012-11-01 15:00:00	AAPL	Stock	21.3211	21.3411	21.2818	21.3046	18552268.0
2012-11-01 15:30:00	AAPL	Stock	21.3068	21.3321	21.2611	21.3043	29282372.0
2012-11-01 16:00:00	AAPL	Stock	21.3014	21.4336	21.2964	21.3071	17137372.0
2012-11-01 16:30:00	AAPL	Stock	21.3	21.3204	21.2971	21.3143	278292.0
2012-11-01 17:00:00	AAPL	Stock	21.3121	21.3196	21.3086	21.3196	43820.0
2012-11-01 17:30:00	AAPL	Stock	21.3179	21.325	21.3179	21.3214	75012.0
2012-11-01 18:00:00	AAPL	Stock	21.3211	21.3286	21.3125	21.3143	71288.0
2012-11-01 18:30:00	AAPL	Stock	21.3186	21.3214	21.3161	21.3161	57960.0
2012-11-01 19:00:00	AAPL	Stock	21.3207	21.3304	21.3207	21.3293	36624.0
2012-11-01 19:30:00	AAPL	Stock	21.325	21.3304	21.3236	21.3304	39508.0
2012-11-01 08:00:00	MSFT	Stock	28.7	28.7	28.62	28.64	3400.0
2012-11-01 08:30:00	MSFT	Stock	28.7	28.8	28.7	28.73	1000.0
2012-11-01 09:00:00	MSFT	Stock	28.7	28.89	28.68	28.84	35722.0
2012-11-01 09:30:00	MSFT	Stock	28.84	29.21	28.82	29.17	9656071.0
2012-11-01 10:00:00	MSFT	Stock	29.18	29.24	29.1	29.105	7119910.0
2012-11-01 10:30:00	MSFT	Stock	29.1	29.315	29.08	29.29	5049386.0
2012-11-01 11:00:00	MSFT	Stock	29.29	29.38	29.28	29.305	5554617.0
2012-11-01 11:30:00	MSFT	Stock	29.3	29.46	29.29	29.454	5198875.0
2012-11-01 12:00:00	MSFT	Stock	29.455	29.51	29.44	29.5	4583183.0
2012-11-01 12:30:00	MSFT	Stock	29.5	29.56	29.42	29.435	4263116.0
2012-11-01 13:00:00	MSFT	Stock	29.44	29.455	29.34	29.45	2368122.0
2012-11-01 13:30:00	MSFT	Stock	29.446	29.52	29.44	29.475	2634944.0
2012-11-01 14:00:00	MSFT	Stock	29.475	29.54	29.39	29.52	3709902.0
2012-11-01 14:30:00	MSFT	Stock	29.52	29.53	29.46	29.505	3661537.0
2012-11-01 15:00:00	MSFT	Stock	29.5	29.52	29.46	29.475	4098517.0
2012-11-01 15:30:00	MSFT	Stock	29.47	29.53	29.43	29.53	8995406.0
2012-11-01 16:00:00	MSFT	Stock	29.52	29.6	28.535	29.53	4526336.0
2012-11-01 16:30:00	MSFT	Stock	29.51	29.55	29.47	29.52	20092.0
2012-11-01 17:00:00	MSFT	Stock	29.51	29.66	29.51	29.6	18225.0
2012-11-01 17:30:00	MSFT	Stock	29.6	29.65	29.6	29.65	22047.0
2012-11-01 18:00:00	MSFT	Stock	29.64	29.65	29.62	29.63	2590.0
2012-11-01 18:30:00	MSFT	Stock	29.64	29.64	29.6	29.6	3195.0

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

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