PREVIEW / stock_30min / 2010-07-12

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-07-12.parquet
  size:    1.3 MB
  rows:    71,695
  symbols: 3,468

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
2010-07-12 04:00:00	AAPL	Stock	9.2507	9.2507	9.2286	9.2286	8036.0
2010-07-12 07:00:00	AAPL	Stock	9.245	9.25	9.2429	9.25	33040.0
2010-07-12 07:30:00	AAPL	Stock	9.25	9.2571	9.25	9.2571	14000.0
2010-07-12 08:00:00	AAPL	Stock	9.2586	9.2643	9.245	9.2546	369068.0
2010-07-12 08:30:00	AAPL	Stock	9.2514	9.2818	9.2514	9.2679	416808.0
2010-07-12 09:00:00	AAPL	Stock	9.2668	9.2668	9.2232	9.2321	747964.0
2010-07-12 09:30:00	AAPL	Stock	9.2357	9.3486	9.2002	9.3268	75025972.0
2010-07-12 10:00:00	AAPL	Stock	9.3279	9.3518	9.2736	9.2768	54666388.0
2010-07-12 10:30:00	AAPL	Stock	9.2761	9.2769	9.2321	9.2704	38287424.0
2010-07-12 11:00:00	AAPL	Stock	9.2696	9.2697	9.2071	9.2071	35123396.0
2010-07-12 11:30:00	AAPL	Stock	9.2071	9.2232	9.1021	9.1144	81522140.0
2010-07-12 12:00:00	AAPL	Stock	9.115	9.1857	9.1149	9.1746	47688452.0
2010-07-12 12:30:00	AAPL	Stock	9.1756	9.2168	9.1643	9.1757	36377992.0
2010-07-12 13:00:00	AAPL	Stock	9.1764	9.2186	9.1679	9.2177	23313584.0
2010-07-12 13:30:00	AAPL	Stock	9.2171	9.2275	9.1975	9.2109	25431000.0
2010-07-12 14:00:00	AAPL	Stock	9.2123	9.2239	9.1846	9.2	18289600.0
2010-07-12 14:30:00	AAPL	Stock	9.2	9.2196	9.18	9.1968	22917412.0
2010-07-12 15:00:00	AAPL	Stock	9.1989	9.2036	9.1679	9.1853	37310672.0
2010-07-12 15:30:00	AAPL	Stock	9.1854	9.2136	9.1725	9.1892	56751744.0
2010-07-12 16:00:00	AAPL	Stock	9.1932	9.2406	9.1857	9.2089	5331844.0
2010-07-12 16:30:00	AAPL	Stock	9.2093	9.2107	9.2014	9.2104	498120.0
2010-07-12 17:00:00	AAPL	Stock	9.2104	9.2196	9.2104	9.2136	432432.0
2010-07-12 17:30:00	AAPL	Stock	9.2132	9.2186	9.2071	9.2179	209860.0
2010-07-12 18:00:00	AAPL	Stock	9.2179	9.2193	9.1889	9.2193	199024.0
2010-07-12 18:30:00	AAPL	Stock	9.2179	9.2214	9.215	9.2214	139552.0
2010-07-12 19:00:00	AAPL	Stock	9.2196	9.2357	9.2196	9.2321	272104.0
2010-07-12 19:30:00	AAPL	Stock	9.2357	9.2375	9.2279	9.2336	205156.0
2010-07-12 06:30:00	MSFT	Stock	24.26	24.29	24.26	24.29	1000.0
2010-07-12 07:00:00	MSFT	Stock	24.32	24.32	24.32	24.32	200.0
2010-07-12 07:30:00	MSFT	Stock	24.31	24.41	24.31	24.37	14975.0
2010-07-12 08:00:00	MSFT	Stock	24.36	24.42	24.32	24.32	28328.0
2010-07-12 08:30:00	MSFT	Stock	24.31	24.32	24.29	24.29	28081.0
2010-07-12 09:00:00	MSFT	Stock	24.28	24.49	24.28	24.44	160537.0
2010-07-12 09:30:00	MSFT	Stock	24.44	24.84	24.42	24.69	6607276.0
2010-07-12 10:00:00	MSFT	Stock	24.69	24.8	24.68	24.735	4810654.0
2010-07-12 10:30:00	MSFT	Stock	24.729	24.76	24.65	24.682	4034417.0
2010-07-12 11:00:00	MSFT	Stock	24.685	24.69	24.57	24.656	3562756.0
2010-07-12 11:30:00	MSFT	Stock	24.652	24.71	24.61	24.68	2253622.0
2010-07-12 12:00:00	MSFT	Stock	24.67	24.74	24.67	24.707	1697328.0
2010-07-12 12:30:00	MSFT	Stock	24.71	24.74	24.66	24.68	1318945.0
2010-07-12 13:00:00	MSFT	Stock	24.66	24.79	24.65	24.78	1917348.0
2010-07-12 13:30:00	MSFT	Stock	24.77	24.88	24.77	24.86	2838481.0
2010-07-12 14:00:00	MSFT	Stock	24.857	24.88	24.73	24.8	2766002.0
2010-07-12 14:30:00	MSFT	Stock	24.796	24.89	24.76	24.84	2938326.0
2010-07-12 15:00:00	MSFT	Stock	24.845	24.88	24.74	24.86	4107143.0
2010-07-12 15:30:00	MSFT	Stock	24.855	24.88	24.75	24.83	7846985.0
2010-07-12 16:00:00	MSFT	Stock	24.83	24.88	24.746	24.758	2250364.0
2010-07-12 16:30:00	MSFT	Stock	24.84	24.87	24.82	24.87	47897.0
2010-07-12 17:00:00	MSFT	Stock	24.9	24.99	24.89	24.89	14821.0
2010-07-12 17:30:00	MSFT	Stock	24.735	24.92	24.735	24.92	7600.0

> showing 50 of 71,695 rows — these rows as CSV

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