PREVIEW / stock_30min / 2012-02-22

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-02-22.parquet
  size:    1.4 MB
  rows:    75,389
  symbols: 3,532

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-02-22 04:00:00	AAPL	Stock	18.4239	18.4239	18.3782	18.3786	25200.0
2012-02-22 04:30:00	AAPL	Stock	18.3982	18.3982	18.3982	18.3982	16800.0
2012-02-22 05:00:00	AAPL	Stock	18.3964	18.3964	18.3964	18.3964	2800.0
2012-02-22 05:30:00	AAPL	Stock	18.3982	18.3982	18.3982	18.3982	8820.0
2012-02-22 06:00:00	AAPL	Stock	18.3875	18.3875	18.3518	18.3661	47852.0
2012-02-22 06:30:00	AAPL	Stock	18.3693	18.3693	18.3493	18.3493	36344.0
2012-02-22 07:00:00	AAPL	Stock	18.3571	18.3846	18.345	18.3714	361312.0
2012-02-22 07:30:00	AAPL	Stock	18.375	18.385	18.3575	18.3639	473732.0
2012-02-22 08:00:00	AAPL	Stock	18.3607	18.3786	18.2736	18.2921	3105340.0
2012-02-22 08:30:00	AAPL	Stock	18.2932	18.3232	18.2689	18.3232	2052316.0
2012-02-22 09:00:00	AAPL	Stock	18.3239	18.3304	18.2768	18.3214	2557072.0
2012-02-22 09:30:00	AAPL	Stock	18.3243	18.3536	18.1811	18.2789	77080472.0
2012-02-22 10:00:00	AAPL	Stock	18.2814	18.3086	18.2229	18.2743	46724692.0
2012-02-22 10:30:00	AAPL	Stock	18.2746	18.3621	18.25	18.3618	42318304.0
2012-02-22 11:00:00	AAPL	Stock	18.3618	18.4104	18.3414	18.3768	49242984.0
2012-02-22 11:30:00	AAPL	Stock	18.3768	18.3918	18.2589	18.3054	35551852.0
2012-02-22 12:00:00	AAPL	Stock	18.3032	18.3439	18.2786	18.327	18727072.0
2012-02-22 12:30:00	AAPL	Stock	18.3268	18.345	18.3036	18.3268	14932792.0
2012-02-22 13:00:00	AAPL	Stock	18.3271	18.3779	18.3061	18.3681	20604220.0
2012-02-22 13:30:00	AAPL	Stock	18.3704	18.3907	18.3479	18.3829	21210476.0
2012-02-22 14:00:00	AAPL	Stock	18.3814	18.3907	18.3432	18.3611	21248584.0
2012-02-22 14:30:00	AAPL	Stock	18.3639	18.365	18.2586	18.2886	29847160.0
2012-02-22 15:00:00	AAPL	Stock	18.2846	18.3336	18.2825	18.3157	19277328.0
2012-02-22 15:30:00	AAPL	Stock	18.3168	18.3714	18.2971	18.3229	51664760.0
2012-02-22 16:00:00	AAPL	Stock	18.3229	18.3783	18.3145	18.3375	15039024.0
2012-02-22 16:30:00	AAPL	Stock	18.3375	18.3479	18.3179	18.3471	420504.0
2012-02-22 17:00:00	AAPL	Stock	18.3479	18.3496	18.3357	18.3475	283248.0
2012-02-22 17:30:00	AAPL	Stock	18.3461	18.3464	18.3418	18.3429	161392.0
2012-02-22 18:00:00	AAPL	Stock	18.34	18.3525	18.34	18.3421	356720.0
2012-02-22 18:30:00	AAPL	Stock	18.3429	18.3489	18.3357	18.3464	78540.0
2012-02-22 19:00:00	AAPL	Stock	18.3439	18.3439	18.3393	18.3393	18032.0
2012-02-22 19:30:00	AAPL	Stock	18.3393	18.3429	18.3357	18.3425	379372.0
2012-02-22 07:30:00	MSFT	Stock	31.37	31.37	31.37	31.37	100.0
2012-02-22 08:00:00	MSFT	Stock	31.37	31.44	31.35	31.4	6400.0
2012-02-22 08:30:00	MSFT	Stock	31.43	31.48	31.4	31.48	11400.0
2012-02-22 09:00:00	MSFT	Stock	31.48	31.49	31.43	31.445	57590.0
2012-02-22 09:30:00	MSFT	Stock	31.46	31.6	31.44	31.58	4607266.0
2012-02-22 10:00:00	MSFT	Stock	31.58	31.68	31.36	31.36	7438868.0
2012-02-22 10:30:00	MSFT	Stock	31.37	31.51	31.34	31.421	4627899.0
2012-02-22 11:00:00	MSFT	Stock	31.425	31.46	31.39	31.442	3046637.0
2012-02-22 11:30:00	MSFT	Stock	31.445	31.49	31.37	31.455	3581665.0
2012-02-22 12:00:00	MSFT	Stock	31.46	31.46	31.32	31.385	2854555.0
2012-02-22 12:30:00	MSFT	Stock	31.38	31.39	31.33	31.36	1262384.0
2012-02-22 13:00:00	MSFT	Stock	31.36	31.45	31.33	31.4	2123286.0
2012-02-22 13:30:00	MSFT	Stock	31.402	31.415	31.38	31.38	1834338.0
2012-02-22 14:00:00	MSFT	Stock	31.38	31.43	31.38	31.41	1714790.0
2012-02-22 14:30:00	MSFT	Stock	31.41	31.42	31.35	31.35	2317335.0
2012-02-22 15:00:00	MSFT	Stock	31.35	31.36	31.26	31.291	3092753.0
2012-02-22 15:30:00	MSFT	Stock	31.29	31.31	31.18	31.27	6936481.0
2012-02-22 16:00:00	MSFT	Stock	31.27	31.7	31.17	31.21	2209954.0

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

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