PREVIEW / stock_30min / 2013-07-18

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-07-18.parquet
  size:    1.5 MB
  rows:    78,099
  symbols: 3,491

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
2013-07-18 08:00:00	AAPL	Stock	15.375	15.3946	15.3214	15.3775	312340.0
2013-07-18 08:30:00	AAPL	Stock	15.3818	15.4914	15.3818	15.4911	1802892.0
2013-07-18 09:00:00	AAPL	Stock	15.4893	15.5057	15.4589	15.4689	1198064.0
2013-07-18 09:30:00	AAPL	Stock	15.4725	15.5311	15.4429	15.4818	43400588.0
2013-07-18 10:00:00	AAPL	Stock	15.4854	15.5054	15.4471	15.4882	20717564.0
2013-07-18 10:30:00	AAPL	Stock	15.4879	15.5154	15.4732	15.5036	13290760.0
2013-07-18 11:00:00	AAPL	Stock	15.5068	15.5139	15.4529	15.4636	13741000.0
2013-07-18 11:30:00	AAPL	Stock	15.4607	15.4854	15.4179	15.4471	13334468.0
2013-07-18 12:00:00	AAPL	Stock	15.4471	15.4621	15.3975	15.4059	11566660.0
2013-07-18 12:30:00	AAPL	Stock	15.4068	15.4257	15.3789	15.4168	10148964.0
2013-07-18 13:00:00	AAPL	Stock	15.4193	15.4321	15.3818	15.4043	10653272.0
2013-07-18 13:30:00	AAPL	Stock	15.4021	15.44	15.3964	15.4375	7851144.0
2013-07-18 14:00:00	AAPL	Stock	15.4389	15.4625	15.4329	15.4443	8606920.0
2013-07-18 14:30:00	AAPL	Stock	15.4432	15.465	15.4314	15.435	7254100.0
2013-07-18 15:00:00	AAPL	Stock	15.4343	15.4486	15.425	15.4421	6770064.0
2013-07-18 15:30:00	AAPL	Stock	15.4421	15.4454	15.4107	15.4175	13407408.0
2013-07-18 16:00:00	AAPL	Stock	15.4175	15.4385	15.3321	15.3571	26742352.0
2013-07-18 16:30:00	AAPL	Stock	15.3482	15.3929	15.3482	15.3929	243320.0
2013-07-18 17:00:00	AAPL	Stock	15.4597	15.4597	15.3661	15.3807	246176.0
2013-07-18 17:30:00	AAPL	Stock	15.42	15.42	15.375	15.375	151424.0
2013-07-18 18:00:00	AAPL	Stock	15.375	15.3829	15.3664	15.375	56420.0
2013-07-18 18:30:00	AAPL	Stock	15.3821	15.3832	15.3696	15.3796	67984.0
2013-07-18 19:00:00	AAPL	Stock	15.3804	15.3814	15.3782	15.3782	38500.0
2013-07-18 19:30:00	AAPL	Stock	15.3804	15.3839	15.3786	15.3804	96320.0
2013-07-18 08:00:00	MSFT	Stock	35.66	35.81	35.66	35.75	4060.0
2013-07-18 08:30:00	MSFT	Stock	35.8	35.8	35.78	35.8	3419.0
2013-07-18 09:00:00	MSFT	Stock	35.81	35.89	35.66	35.68	188614.0
2013-07-18 09:30:00	MSFT	Stock	35.72	35.76	35.46	35.665	5232567.0
2013-07-18 10:00:00	MSFT	Stock	35.67	35.885	35.62	35.875	3510144.0
2013-07-18 10:30:00	MSFT	Stock	35.88	35.89	35.76	35.81	2208907.0
2013-07-18 11:00:00	MSFT	Stock	35.805	35.86	35.785	35.79	3063590.0
2013-07-18 11:30:00	MSFT	Stock	35.78	35.805	35.59	35.62	2041223.0
2013-07-18 12:00:00	MSFT	Stock	35.614	35.65	35.55	35.62	2934744.0
2013-07-18 12:30:00	MSFT	Stock	35.623	35.64	35.46	35.525	1563382.0
2013-07-18 13:00:00	MSFT	Stock	35.525	35.56	35.34	35.38	2016131.0
2013-07-18 13:30:00	MSFT	Stock	35.37	35.455	35.37	35.447	1765833.0
2013-07-18 14:00:00	MSFT	Stock	35.45	35.45	35.315	35.352	3061957.0
2013-07-18 14:30:00	MSFT	Stock	35.36	35.38	35.22	35.275	3570578.0
2013-07-18 15:00:00	MSFT	Stock	35.28	35.42	35.26	35.4	2442166.0
2013-07-18 15:30:00	MSFT	Stock	35.395	35.47	35.31	35.43	6381605.0
2013-07-18 16:00:00	MSFT	Stock	35.44	35.64	33.47	33.84	6361360.0
2013-07-18 16:30:00	MSFT	Stock	33.82	35.372	33.57	33.85	1033165.0
2013-07-18 17:00:00	MSFT	Stock	33.83	35.822	33.26	33.27	1094829.0
2013-07-18 17:30:00	MSFT	Stock	33.27	35.44	33.18	33.25	490906.0
2013-07-18 18:00:00	MSFT	Stock	33.25	33.29	33.16	33.2	160730.0
2013-07-18 18:30:00	MSFT	Stock	33.2	33.23	33.07	33.07	103288.0
2013-07-18 19:00:00	MSFT	Stock	33.1	33.16	33.0	33.1	109361.0
2013-07-18 19:30:00	MSFT	Stock	33.1	33.22	33.04	33.21	55085.0
2013-07-18 09:30:00	NVDA	Stock	0.3648	0.366	0.359	0.362	40941000.0
2013-07-18 10:00:00	NVDA	Stock	0.362	0.3625	0.3608	0.3624	27201680.0

> showing 50 of 78,099 rows — these rows as CSV

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