PREVIEW / stock_30min / 2012-04-09

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-04-09.parquet
  size:    1.4 MB
  rows:    76,133
  symbols: 3,527

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-09 04:00:00	AAPL	Stock	22.4286	22.4286	22.4286	22.4286	4480.0
2012-04-09 04:30:00	AAPL	Stock	22.4357	22.4357	22.4357	22.4357	8400.0
2012-04-09 05:00:00	AAPL	Stock	22.5	22.5104	22.5	22.5104	5600.0
2012-04-09 05:30:00	AAPL	Stock	22.5104	22.5104	22.5104	22.5104	4200.0
2012-04-09 06:00:00	AAPL	Stock	22.4714	22.4714	22.4286	22.4286	12040.0
2012-04-09 06:30:00	AAPL	Stock	22.4293	22.4293	22.2839	22.2857	260176.0
2012-04-09 07:00:00	AAPL	Stock	22.2839	22.3982	22.2696	22.3893	1055320.0
2012-04-09 07:30:00	AAPL	Stock	22.405	22.4054	22.3143	22.3357	1040004.0
2012-04-09 08:00:00	AAPL	Stock	22.3461	22.4104	22.2696	22.3389	3459456.0
2012-04-09 08:30:00	AAPL	Stock	22.3464	22.3732	22.3254	22.3571	1911560.0
2012-04-09 09:00:00	AAPL	Stock	22.3571	22.3679	22.3082	22.3661	4075904.0
2012-04-09 09:30:00	AAPL	Stock	22.3618	22.4939	22.3321	22.4018	92062264.0
2012-04-09 10:00:00	AAPL	Stock	22.4021	22.6	22.3968	22.5975	63143780.0
2012-04-09 10:30:00	AAPL	Stock	22.6	22.7643	22.5432	22.7636	68079592.0
2012-04-09 11:00:00	AAPL	Stock	22.7611	22.7679	22.5939	22.6384	63589736.0
2012-04-09 11:30:00	AAPL	Stock	22.6382	22.7196	22.6304	22.7006	34647900.0
2012-04-09 12:00:00	AAPL	Stock	22.6993	22.7089	22.654	22.6768	18047652.0
2012-04-09 12:30:00	AAPL	Stock	22.6821	22.7321	22.6721	22.7268	19461484.0
2012-04-09 13:00:00	AAPL	Stock	22.725	22.7339	22.6579	22.6929	19276488.0
2012-04-09 13:30:00	AAPL	Stock	22.6936	22.7564	22.6925	22.7536	20621244.0
2012-04-09 14:00:00	AAPL	Stock	22.7537	22.8046	22.725	22.7929	34807948.0
2012-04-09 14:30:00	AAPL	Stock	22.7914	22.8514	22.7732	22.8193	38710224.0
2012-04-09 15:00:00	AAPL	Stock	22.8206	22.84	22.7196	22.7243	44889684.0
2012-04-09 15:30:00	AAPL	Stock	22.7239	22.7818	22.7179	22.7229	53214700.0
2012-04-09 16:00:00	AAPL	Stock	22.7225	22.7332	22.6445	22.7004	8079708.0
2012-04-09 16:30:00	AAPL	Stock	22.7029	22.7446	22.6821	22.6964	497812.0
2012-04-09 17:00:00	AAPL	Stock	22.6911	22.7018	22.6846	22.6929	235368.0
2012-04-09 17:30:00	AAPL	Stock	22.6886	22.7225	22.6661	22.6682	630168.0
2012-04-09 18:00:00	AAPL	Stock	22.6764	22.7054	22.6757	22.7029	219576.0
2012-04-09 18:30:00	AAPL	Stock	22.6964	22.7029	22.6889	22.6893	96348.0
2012-04-09 19:00:00	AAPL	Stock	22.6875	22.6964	22.6836	22.6964	101052.0
2012-04-09 19:30:00	AAPL	Stock	22.6911	22.7061	22.6871	22.6971	252616.0
2012-04-09 07:00:00	MSFT	Stock	31.28	31.28	31.28	31.28	400.0
2012-04-09 07:30:00	MSFT	Stock	31.2	31.2	31.19	31.19	1700.0
2012-04-09 08:00:00	MSFT	Stock	31.2	31.3	31.01	31.26	10782.0
2012-04-09 08:30:00	MSFT	Stock	31.25	31.28	31.15	31.22	7717.0
2012-04-09 09:00:00	MSFT	Stock	31.22	31.28	31.18	31.28	17582.0
2012-04-09 09:30:00	MSFT	Stock	31.27	31.27	30.97	30.99	4524916.0
2012-04-09 10:00:00	MSFT	Stock	31.0	31.205	30.99	31.195	2821879.0
2012-04-09 10:30:00	MSFT	Stock	31.193	31.28	31.18	31.232	2003214.0
2012-04-09 11:00:00	MSFT	Stock	31.232	31.26	31.13	31.16	2296642.0
2012-04-09 11:30:00	MSFT	Stock	31.158	31.25	31.155	31.25	1515040.0
2012-04-09 12:00:00	MSFT	Stock	31.245	31.33	31.24	31.28	1743778.0
2012-04-09 12:30:00	MSFT	Stock	31.288	31.4	31.28	31.38	1092271.0
2012-04-09 13:00:00	MSFT	Stock	31.38	31.387	31.28	31.309	818426.0
2012-04-09 13:30:00	MSFT	Stock	31.305	31.32	31.27	31.307	1079516.0
2012-04-09 14:00:00	MSFT	Stock	31.305	31.327	31.24	31.278	1642445.0
2012-04-09 14:30:00	MSFT	Stock	31.27	31.33	31.245	31.29	1511988.0
2012-04-09 15:00:00	MSFT	Stock	31.29	31.3	31.2	31.21	2671855.0
2012-04-09 15:30:00	MSFT	Stock	31.21	31.23	31.1	31.1	4489828.0

> showing 50 of 76,133 rows — these rows as CSV

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