PREVIEW / stock_30min / 2012-05-22

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-05-22.parquet
  size:    1.4 MB
  rows:    75,487
  symbols: 3,536

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-05-22 04:00:00	AAPL	Stock	20.1786	20.4286	20.1786	20.2589	103124.0
2012-05-22 04:30:00	AAPL	Stock	20.2586	20.2586	20.1786	20.1786	121436.0
2012-05-22 05:00:00	AAPL	Stock	20.1643	20.1643	20.1107	20.1393	35420.0
2012-05-22 05:30:00	AAPL	Stock	20.1593	20.1593	20.1593	20.1593	2800.0
2012-05-22 06:00:00	AAPL	Stock	20.1321	20.1321	20.1321	20.1321	14000.0
2012-05-22 06:30:00	AAPL	Stock	20.1111	20.1429	20.1111	20.1429	10920.0
2012-05-22 07:00:00	AAPL	Stock	20.1561	20.1964	20.0975	20.1821	599564.0
2012-05-22 07:30:00	AAPL	Stock	20.1875	20.2136	20.1664	20.2018	571340.0
2012-05-22 08:00:00	AAPL	Stock	20.2032	20.3464	20.1429	20.2729	5062932.0
2012-05-22 08:30:00	AAPL	Stock	20.2696	20.2696	20.1529	20.1925	3526488.0
2012-05-22 09:00:00	AAPL	Stock	20.1932	20.365	20.1825	20.3568	4933320.0
2012-05-22 09:30:00	AAPL	Stock	20.3525	20.4957	20.2757	20.3829	140015204.0
2012-05-22 10:00:00	AAPL	Stock	20.3807	20.4	20.1964	20.1996	76347712.0
2012-05-22 10:30:00	AAPL	Stock	20.2	20.3782	20.1964	20.2441	69385344.0
2012-05-22 11:00:00	AAPL	Stock	20.2421	20.3429	20.2325	20.2818	30195200.0
2012-05-22 11:30:00	AAPL	Stock	20.283	20.3103	20.1389	20.1514	26130916.0
2012-05-22 12:00:00	AAPL	Stock	20.155	20.2204	20.0357	20.1968	57501136.0
2012-05-22 12:30:00	AAPL	Stock	20.1964	20.23	20.1364	20.2037	22538516.0
2012-05-22 13:00:00	AAPL	Stock	20.2064	20.2406	20.0779	20.0786	27841352.0
2012-05-22 13:30:00	AAPL	Stock	20.0779	20.1378	20.0714	20.0941	20199788.0
2012-05-22 14:00:00	AAPL	Stock	20.0971	20.1786	20.0907	20.1629	21797384.0
2012-05-22 14:30:00	AAPL	Stock	20.1561	20.1904	20.0186	20.0296	31876824.0
2012-05-22 15:00:00	AAPL	Stock	20.03	20.0975	19.8404	19.8675	56706916.0
2012-05-22 15:30:00	AAPL	Stock	19.8675	19.9243	19.735	19.8896	75545876.0
2012-05-22 16:00:00	AAPL	Stock	19.8867	20.4238	19.7711	19.9211	11539920.0
2012-05-22 16:30:00	AAPL	Stock	19.9193	19.9229	19.8667	19.8836	452032.0
2012-05-22 17:00:00	AAPL	Stock	19.8661	19.8918	19.8571	19.8571	69132.0
2012-05-22 17:30:00	AAPL	Stock	19.8475	19.8504	19.8293	19.8482	88956.0
2012-05-22 18:00:00	AAPL	Stock	19.8393	19.8875	19.8386	19.8875	294308.0
2012-05-22 18:30:00	AAPL	Stock	19.8893	19.9036	19.8732	19.8836	238616.0
2012-05-22 19:00:00	AAPL	Stock	19.8875	19.8879	19.865	19.8675	122612.0
2012-05-22 19:30:00	AAPL	Stock	19.8643	19.8661	19.8214	19.8396	286188.0
2012-05-22 08:00:00	MSFT	Stock	29.88	29.88	29.75	29.8	10734.0
2012-05-22 08:30:00	MSFT	Stock	29.75	29.75	29.63	29.63	21250.0
2012-05-22 09:00:00	MSFT	Stock	29.69	29.76	29.67	29.72	39661.0
2012-05-22 09:30:00	MSFT	Stock	29.69	29.76	29.5	29.66	3710268.0
2012-05-22 10:00:00	MSFT	Stock	29.65	29.8	29.635	29.72	2764913.0
2012-05-22 10:30:00	MSFT	Stock	29.725	29.78	29.64	29.745	2424267.0
2012-05-22 11:00:00	MSFT	Stock	29.745	29.82	29.725	29.792	2049767.0
2012-05-22 11:30:00	MSFT	Stock	29.8	29.82	29.76	29.77	1262934.0
2012-05-22 12:00:00	MSFT	Stock	29.765	29.79	29.7	29.718	2814980.0
2012-05-22 12:30:00	MSFT	Stock	29.73	29.81	29.7	29.81	2030581.0
2012-05-22 13:00:00	MSFT	Stock	29.81	29.88	29.785	29.81	1436269.0
2012-05-22 13:30:00	MSFT	Stock	29.81	29.86	29.78	29.79	1410593.0
2012-05-22 14:00:00	MSFT	Stock	29.8	29.846	29.75	29.782	1236451.0
2012-05-22 14:30:00	MSFT	Stock	29.78	29.81	29.7	29.73	1937709.0
2012-05-22 15:00:00	MSFT	Stock	29.73	29.75	29.67	29.68	3925353.0
2012-05-22 15:30:00	MSFT	Stock	29.68	29.78	29.58	29.77	7551077.0
2012-05-22 16:00:00	MSFT	Stock	29.77	29.8	29.64	29.79	4037087.0
2012-05-22 16:30:00	MSFT	Stock	29.76	29.83	29.67	29.67	26145.0

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

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