PREVIEW / stock_30min / 2012-04-03

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-04-03.parquet
  size:    1.4 MB
  rows:    75,969
  symbols: 3,526

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-03 04:00:00	AAPL	Stock	22.1418	22.1857	22.1418	22.1786	264992.0
2012-04-03 04:30:00	AAPL	Stock	22.1821	22.25	22.1786	22.2214	108752.0
2012-04-03 05:00:00	AAPL	Stock	22.2321	22.25	22.215	22.215	158340.0
2012-04-03 05:30:00	AAPL	Stock	22.2411	22.2411	22.2157	22.2157	39956.0
2012-04-03 06:00:00	AAPL	Stock	22.2268	22.2682	22.2171	22.2682	205688.0
2012-04-03 06:30:00	AAPL	Stock	22.2489	22.2893	22.2489	22.2861	288064.0
2012-04-03 07:00:00	AAPL	Stock	22.2879	22.2996	22.2332	22.2332	1102444.0
2012-04-03 07:30:00	AAPL	Stock	22.2432	22.2679	22.1436	22.2411	1918980.0
2012-04-03 08:00:00	AAPL	Stock	22.2425	22.3482	22.2321	22.3443	5313868.0
2012-04-03 08:30:00	AAPL	Stock	22.3432	22.4268	22.3329	22.4243	6685196.0
2012-04-03 09:00:00	AAPL	Stock	22.4214	22.4607	22.3825	22.4061	7851564.0
2012-04-03 09:30:00	AAPL	Stock	22.4046	22.5461	22.3468	22.4589	185341632.0
2012-04-03 10:00:00	AAPL	Stock	22.4589	22.4911	22.3911	22.4546	68144216.0
2012-04-03 10:30:00	AAPL	Stock	22.4546	22.5714	22.4461	22.5714	54999868.0
2012-04-03 11:00:00	AAPL	Stock	22.5714	22.5789	22.4539	22.4597	67730096.0
2012-04-03 11:30:00	AAPL	Stock	22.4639	22.4779	22.4082	22.4353	47870956.0
2012-04-03 12:00:00	AAPL	Stock	22.4354	22.4443	22.2325	22.4143	83414576.0
2012-04-03 12:30:00	AAPL	Stock	22.4133	22.4461	22.3654	22.4371	29390704.0
2012-04-03 13:00:00	AAPL	Stock	22.4364	22.4589	22.4129	22.4504	22625316.0
2012-04-03 13:30:00	AAPL	Stock	22.4507	22.4986	22.4396	22.4964	23677892.0
2012-04-03 14:00:00	AAPL	Stock	22.4943	22.4964	22.4011	22.4532	50088332.0
2012-04-03 14:30:00	AAPL	Stock	22.4546	22.4661	22.3679	22.4186	41043940.0
2012-04-03 15:00:00	AAPL	Stock	22.4229	22.4761	22.3968	22.4034	40589332.0
2012-04-03 15:30:00	AAPL	Stock	22.4015	22.5104	22.378	22.4754	75464312.0
2012-04-03 16:00:00	AAPL	Stock	22.4706	22.4911	22.4459	22.4893	10544604.0
2012-04-03 16:30:00	AAPL	Stock	22.4839	22.4893	22.3933	22.4525	607852.0
2012-04-03 17:00:00	AAPL	Stock	22.4525	22.4757	22.4411	22.4536	355992.0
2012-04-03 17:30:00	AAPL	Stock	22.4604	22.4679	22.4593	22.4643	67704.0
2012-04-03 18:00:00	AAPL	Stock	22.4671	22.4821	22.4589	22.4807	546280.0
2012-04-03 18:30:00	AAPL	Stock	22.4793	22.4911	22.4693	22.4893	404824.0
2012-04-03 19:00:00	AAPL	Stock	22.4936	22.495	22.47	22.475	207956.0
2012-04-03 19:30:00	AAPL	Stock	22.4714	22.4911	22.4554	22.4911	846832.0
2012-04-03 06:30:00	MSFT	Stock	32.28	32.28	32.28	32.28	100.0
2012-04-03 07:00:00	MSFT	Stock	32.28	32.28	32.28	32.28	200.0
2012-04-03 07:30:00	MSFT	Stock	32.42	32.42	32.42	32.42	100.0
2012-04-03 08:00:00	MSFT	Stock	32.28	32.3	32.21	32.29	2196.0
2012-04-03 08:30:00	MSFT	Stock	32.26	32.26	32.23	32.23	2804.0
2012-04-03 09:00:00	MSFT	Stock	32.22	32.22	32.14	32.15	117731.0
2012-04-03 09:30:00	MSFT	Stock	32.16	32.19	31.96	32.04	4262130.0
2012-04-03 10:00:00	MSFT	Stock	32.03	32.06	31.93	32.0	3124882.0
2012-04-03 10:30:00	MSFT	Stock	32.0	32.08	31.95	32.055	3339740.0
2012-04-03 11:00:00	MSFT	Stock	32.055	32.08	31.89	31.9	2942012.0
2012-04-03 11:30:00	MSFT	Stock	31.895	31.95	31.831	31.855	2625983.0
2012-04-03 12:00:00	MSFT	Stock	31.85	31.88	31.8	31.86	2378093.0
2012-04-03 12:30:00	MSFT	Stock	31.86	31.895	31.8	31.89	1412660.0
2012-04-03 13:00:00	MSFT	Stock	31.885	31.92	31.85	31.86	2238285.0
2012-04-03 13:30:00	MSFT	Stock	31.86	31.9	31.82	31.875	1507672.0
2012-04-03 14:00:00	MSFT	Stock	31.87	31.88	31.7	31.79	3823931.0
2012-04-03 14:30:00	MSFT	Stock	31.79	31.8	31.66	31.75	2660806.0
2012-04-03 15:00:00	MSFT	Stock	31.752	31.87	31.7	31.7	2967228.0

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

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