PREVIEW / stock_30min / 2011-07-05

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-07-05.parquet
  size:    1.4 MB
  rows:    75,154
  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
2011-07-05 04:00:00	AAPL	Stock	12.2196	12.2196	12.2196	12.2196	2800.0
2011-07-05 05:30:00	AAPL	Stock	12.2196	12.2196	12.2196	12.2196	30800.0
2011-07-05 06:30:00	AAPL	Stock	12.225	12.225	12.2196	12.2196	11200.0
2011-07-05 07:00:00	AAPL	Stock	12.2289	12.2532	12.2189	12.2329	158704.0
2011-07-05 07:30:00	AAPL	Stock	12.2446	12.2464	12.2311	12.2404	52780.0
2011-07-05 08:00:00	AAPL	Stock	12.2496	12.2539	12.2414	12.25	460040.0
2011-07-05 08:30:00	AAPL	Stock	12.2482	12.25	12.2357	12.2429	112868.0
2011-07-05 09:00:00	AAPL	Stock	12.2396	12.25	12.2375	12.2496	489692.0
2011-07-05 09:30:00	AAPL	Stock	12.2464	12.4296	12.2321	12.4109	63088816.0
2011-07-05 10:00:00	AAPL	Stock	12.4107	12.4643	12.3796	12.3861	46472048.0
2011-07-05 10:30:00	AAPL	Stock	12.3861	12.4518	12.3835	12.4225	27702276.0
2011-07-05 11:00:00	AAPL	Stock	12.4225	12.4621	12.4096	12.4619	19504072.0
2011-07-05 11:30:00	AAPL	Stock	12.4618	12.4639	12.4264	12.4346	12450340.0
2011-07-05 12:00:00	AAPL	Stock	12.4341	12.4407	12.4139	12.4325	11513012.0
2011-07-05 12:30:00	AAPL	Stock	12.4332	12.45	12.4311	12.44	11536252.0
2011-07-05 13:00:00	AAPL	Stock	12.4404	12.4607	12.4396	12.4571	11586484.0
2011-07-05 13:30:00	AAPL	Stock	12.4571	12.4711	12.4486	12.4559	16078412.0
2011-07-05 14:00:00	AAPL	Stock	12.4557	12.4625	12.4232	12.435	23645300.0
2011-07-05 14:30:00	AAPL	Stock	12.435	12.4457	12.4179	12.4429	16032268.0
2011-07-05 15:00:00	AAPL	Stock	12.4429	12.485	12.4314	12.48	23777740.0
2011-07-05 15:30:00	AAPL	Stock	12.4793	12.4939	12.4657	12.4754	39781728.0
2011-07-05 16:00:00	AAPL	Stock	12.4754	12.4822	12.4247	12.4764	16831892.0
2011-07-05 16:30:00	AAPL	Stock	12.4786	12.4821	12.4689	12.4786	261128.0
2011-07-05 17:00:00	AAPL	Stock	12.4775	12.4779	12.4479	12.4718	162232.0
2011-07-05 17:30:00	AAPL	Stock	12.4721	12.475	12.4704	12.4739	45052.0
2011-07-05 18:00:00	AAPL	Stock	12.4725	12.48	12.4718	12.48	299264.0
2011-07-05 18:30:00	AAPL	Stock	12.4764	12.4857	12.4764	12.4836	90860.0
2011-07-05 19:00:00	AAPL	Stock	12.4786	12.4786	12.4786	12.4786	41608.0
2011-07-05 19:30:00	AAPL	Stock	12.4796	12.4821	12.475	12.4768	90216.0
2011-07-05 06:00:00	MSFT	Stock	26.16	26.16	26.15	26.15	5000.0
2011-07-05 06:30:00	MSFT	Stock	26.14	26.15	26.14	26.15	400.0
2011-07-05 07:00:00	MSFT	Stock	26.15	26.15	26.15	26.15	4185.0
2011-07-05 07:30:00	MSFT	Stock	26.15	26.15	26.15	26.15	1900.0
2011-07-05 08:00:00	MSFT	Stock	26.16	26.17	26.11	26.13	9150.0
2011-07-05 08:30:00	MSFT	Stock	26.12	26.16	26.12	26.15	14879.0
2011-07-05 09:00:00	MSFT	Stock	26.15	26.2	26.06	26.14	94107.0
2011-07-05 09:30:00	MSFT	Stock	26.13	26.15	25.92	25.996	4684017.0
2011-07-05 10:00:00	MSFT	Stock	26.0	26.0	25.91	25.941	2935900.0
2011-07-05 10:30:00	MSFT	Stock	25.945	26.01	25.94	25.975	1979779.0
2011-07-05 11:00:00	MSFT	Stock	25.975	26.04	25.93	26.04	1814955.0
2011-07-05 11:30:00	MSFT	Stock	26.031	26.1	26.03	26.061	2147078.0
2011-07-05 12:00:00	MSFT	Stock	26.065	26.08	26.02	26.05	1905471.0
2011-07-05 12:30:00	MSFT	Stock	26.05	26.07	26.04	26.06	1038072.0
2011-07-05 13:00:00	MSFT	Stock	26.054	26.08	26.03	26.03	1128949.0
2011-07-05 13:30:00	MSFT	Stock	26.04	26.04	25.95	25.955	2438290.0
2011-07-05 14:00:00	MSFT	Stock	25.96	25.98	25.9	25.93	2784430.0
2011-07-05 14:30:00	MSFT	Stock	25.935	25.98	25.92	25.965	1430447.0
2011-07-05 15:00:00	MSFT	Stock	25.965	26.05	25.96	26.04	2180205.0
2011-07-05 15:30:00	MSFT	Stock	26.04	26.08	25.99	26.05	6948774.0
2011-07-05 16:00:00	MSFT	Stock	26.06	26.08	26.001	26.03	2508019.0

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

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