PREVIEW / stock_30min / 2012-03-22

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-03-22.parquet
  size:    1.4 MB
  rows:    75,346
  symbols: 3,497

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-03-22 04:00:00	AAPL	Stock	21.5714	21.5718	21.5357	21.5661	117600.0
2012-03-22 04:30:00	AAPL	Stock	21.5214	21.5304	21.4579	21.4929	85960.0
2012-03-22 05:00:00	AAPL	Stock	21.4986	21.5	21.4286	21.4446	130900.0
2012-03-22 05:30:00	AAPL	Stock	21.4279	21.4279	21.3929	21.3929	89572.0
2012-03-22 06:00:00	AAPL	Stock	21.3768	21.3929	21.375	21.3832	147280.0
2012-03-22 06:30:00	AAPL	Stock	21.3821	21.3821	21.365	21.365	62104.0
2012-03-22 07:00:00	AAPL	Stock	21.3821	21.4107	21.3586	21.3854	531524.0
2012-03-22 07:30:00	AAPL	Stock	21.3889	21.3925	21.3439	21.3504	449428.0
2012-03-22 08:00:00	AAPL	Stock	21.3464	21.3929	21.3464	21.3618	2585464.0
2012-03-22 08:30:00	AAPL	Stock	21.3686	21.3929	21.3664	21.3793	2816828.0
2012-03-22 09:00:00	AAPL	Stock	21.38	21.3836	21.3393	21.3554	3056536.0
2012-03-22 09:30:00	AAPL	Stock	21.3568	21.5143	21.2689	21.4855	115311980.0
2012-03-22 10:00:00	AAPL	Stock	21.4857	21.5893	21.4482	21.4689	67756136.0
2012-03-22 10:30:00	AAPL	Stock	21.4711	21.5486	21.4446	21.4732	50131900.0
2012-03-22 11:00:00	AAPL	Stock	21.4782	21.5293	21.4446	21.5054	32537596.0
2012-03-22 11:30:00	AAPL	Stock	21.5061	21.5271	21.4696	21.4943	19414696.0
2012-03-22 12:00:00	AAPL	Stock	21.4939	21.5393	21.4932	21.5314	18361000.0
2012-03-22 12:30:00	AAPL	Stock	21.5314	21.5364	21.4993	21.5307	15915172.0
2012-03-22 13:00:00	AAPL	Stock	21.5293	21.5336	21.4486	21.4732	18389672.0
2012-03-22 13:30:00	AAPL	Stock	21.4754	21.4932	21.3889	21.4318	31529120.0
2012-03-22 14:00:00	AAPL	Stock	21.4275	21.4311	21.37	21.4102	41023164.0
2012-03-22 14:30:00	AAPL	Stock	21.4076	21.4106	21.3571	21.3707	31163804.0
2012-03-22 15:00:00	AAPL	Stock	21.3718	21.3718	21.2704	21.3636	73497508.0
2012-03-22 15:30:00	AAPL	Stock	21.3636	21.4186	21.3471	21.4071	75881456.0
2012-03-22 16:00:00	AAPL	Stock	21.4032	21.4269	21.3961	21.415	14832188.0
2012-03-22 16:30:00	AAPL	Stock	21.415	21.4214	21.362	21.4071	658000.0
2012-03-22 17:00:00	AAPL	Stock	21.4139	21.4157	21.4036	21.4036	527296.0
2012-03-22 17:30:00	AAPL	Stock	21.4054	21.4054	21.3825	21.3825	211372.0
2012-03-22 18:00:00	AAPL	Stock	21.3857	21.3993	21.3825	21.3993	134820.0
2012-03-22 18:30:00	AAPL	Stock	21.4011	21.4046	21.3864	21.3929	81088.0
2012-03-22 19:00:00	AAPL	Stock	21.3921	21.3929	21.3821	21.3839	32200.0
2012-03-22 19:30:00	AAPL	Stock	21.39	21.39	21.3679	21.3696	192584.0
2012-03-22 05:30:00	MSFT	Stock	31.8	31.8	31.8	31.8	100.0
2012-03-22 06:30:00	MSFT	Stock	31.81	31.81	31.81	31.81	100.0
2012-03-22 07:00:00	MSFT	Stock	31.78	31.78	31.78	31.78	1500.0
2012-03-22 07:30:00	MSFT	Stock	31.81	31.81	31.76	31.76	5499.0
2012-03-22 08:00:00	MSFT	Stock	31.81	31.81	31.79	31.79	1421.0
2012-03-22 08:30:00	MSFT	Stock	31.79	31.9	31.76	31.8	10328.0
2012-03-22 09:00:00	MSFT	Stock	31.87	31.88	31.79	31.81	34680.0
2012-03-22 09:30:00	MSFT	Stock	31.81	32.09	31.79	31.835	5855821.0
2012-03-22 10:00:00	MSFT	Stock	31.83	31.93	31.8	31.9	2027763.0
2012-03-22 10:30:00	MSFT	Stock	31.9	31.91	31.82	31.885	2208422.0
2012-03-22 11:00:00	MSFT	Stock	31.88	31.89	31.81	31.845	2135948.0
2012-03-22 11:30:00	MSFT	Stock	31.84	31.935	31.84	31.915	2014529.0
2012-03-22 12:00:00	MSFT	Stock	31.915	32.02	31.91	31.975	1704444.0
2012-03-22 12:30:00	MSFT	Stock	31.975	32.04	31.93	32.04	898095.0
2012-03-22 13:00:00	MSFT	Stock	32.03	32.04	31.97	32.006	994966.0
2012-03-22 13:30:00	MSFT	Stock	32.001	32.03	31.97	32.0	1130728.0
2012-03-22 14:00:00	MSFT	Stock	32.0	32.027	31.94	32.01	1334747.0
2012-03-22 14:30:00	MSFT	Stock	32.018	32.02	31.93	31.94	1691243.0

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

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