PREVIEW / stock_30min / 2007-11-27

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-11-27.parquet
  size:    1.2 MB
  rows:    69,876
  symbols: 3,225

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
2007-11-27 04:00:00	AAPL	Stock	6.2125	6.2125	6.2125	6.2125	5600.0
2007-11-27 04:30:00	AAPL	Stock	6.245	6.245	6.245	6.245	16800.0
2007-11-27 05:30:00	AAPL	Stock	6.25	6.2557	6.25	6.2557	77000.0
2007-11-27 06:30:00	AAPL	Stock	6.25	6.2568	6.25	6.2568	25116.0
2007-11-27 07:00:00	AAPL	Stock	6.2289	6.2618	6.2289	6.25	406140.0
2007-11-27 07:30:00	AAPL	Stock	6.25	6.2518	6.2289	6.2321	836248.0
2007-11-27 08:00:00	AAPL	Stock	6.2289	6.2411	6.1622	6.2214	4732168.0
2007-11-27 08:30:00	AAPL	Stock	6.2196	6.25	6.2143	6.2482	2701300.0
2007-11-27 09:00:00	AAPL	Stock	6.2486	6.2668	6.2286	6.2575	6775524.0
2007-11-27 09:30:00	AAPL	Stock	6.2579	6.2782	6.225	6.2617	150277064.0
2007-11-27 10:00:00	AAPL	Stock	6.26	6.2657	6.0718	6.1871	212741340.0
2007-11-27 10:30:00	AAPL	Stock	6.1868	6.2714	6.1796	6.2526	135565668.0
2007-11-27 11:00:00	AAPL	Stock	6.2532	6.2611	6.2179	6.2325	80245116.0
2007-11-27 11:30:00	AAPL	Stock	6.2329	6.2561	6.1911	6.1964	76506052.0
2007-11-27 12:00:00	AAPL	Stock	6.1964	6.2179	6.1904	6.2125	60407004.0
2007-11-27 12:30:00	AAPL	Stock	6.2125	6.2582	6.2114	6.2261	53933292.0
2007-11-27 13:00:00	AAPL	Stock	6.2257	6.2429	6.2082	6.2118	57332688.0
2007-11-27 13:30:00	AAPL	Stock	6.2129	6.2171	6.1521	6.1725	65995412.0
2007-11-27 14:00:00	AAPL	Stock	6.1718	6.1939	6.1396	6.1704	71499484.0
2007-11-27 14:30:00	AAPL	Stock	6.1707	6.1857	6.1164	6.1607	93037252.0
2007-11-27 15:00:00	AAPL	Stock	6.1618	6.2207	6.1521	6.1729	100457896.0
2007-11-27 15:30:00	AAPL	Stock	6.1743	6.2429	6.1411	6.2428	125523076.0
2007-11-27 16:00:00	AAPL	Stock	6.2414	6.2432	6.1859	6.2321	15110536.0
2007-11-27 16:30:00	AAPL	Stock	6.2304	6.2432	6.1942	6.2225	1147664.0
2007-11-27 17:00:00	AAPL	Stock	6.2232	6.2311	6.2232	6.2282	276024.0
2007-11-27 17:30:00	AAPL	Stock	6.225	6.2304	6.2232	6.2232	166516.0
2007-11-27 18:00:00	AAPL	Stock	6.2296	6.2321	6.2232	6.2286	359100.0
2007-11-27 18:30:00	AAPL	Stock	6.2236	6.2304	6.2236	6.23	193900.0
2007-11-27 19:00:00	AAPL	Stock	6.225	6.235	6.225	6.2321	279384.0
2007-11-27 19:30:00	AAPL	Stock	6.2321	6.2432	6.2321	6.235	431928.0
2007-11-27 07:30:00	MSFT	Stock	33.28	33.28	33.2	33.2	2000.0
2007-11-27 08:00:00	MSFT	Stock	33.25	33.27	32.97	33.15	22118.0
2007-11-27 08:30:00	MSFT	Stock	33.15	33.23	33.13	33.2	8145.0
2007-11-27 09:00:00	MSFT	Stock	33.2	33.29	33.15	33.27	49528.0
2007-11-27 09:30:00	MSFT	Stock	33.26	33.5	33.25	33.32	7311996.0
2007-11-27 10:00:00	MSFT	Stock	33.32	33.35	33.04	33.23	7936675.0
2007-11-27 10:30:00	MSFT	Stock	33.23	33.6	33.22	33.5	7082810.0
2007-11-27 11:00:00	MSFT	Stock	33.5	33.55	33.38	33.45	3927030.0
2007-11-27 11:30:00	MSFT	Stock	33.44	33.52	33.31	33.32	3460412.0
2007-11-27 12:00:00	MSFT	Stock	33.32	33.33	33.25	33.27	3546800.0
2007-11-27 12:30:00	MSFT	Stock	33.27	33.48	33.25	33.35	3637814.0
2007-11-27 13:00:00	MSFT	Stock	33.36	33.41	33.3	33.39	2936968.0
2007-11-27 13:30:00	MSFT	Stock	33.4	33.4	33.14	33.25	3972072.0
2007-11-27 14:00:00	MSFT	Stock	33.25	33.26	32.89	32.94	5913417.0
2007-11-27 14:30:00	MSFT	Stock	32.95	32.99	32.68	32.9	7240163.0
2007-11-27 15:00:00	MSFT	Stock	32.9	33.16	32.78	32.959	10060047.0
2007-11-27 15:30:00	MSFT	Stock	32.96	33.28	32.82	33.04	13466808.0
2007-11-27 16:00:00	MSFT	Stock	33.0	33.19	32.99	33.02	3125198.0
2007-11-27 16:30:00	MSFT	Stock	33.03	33.201	32.8	33.201	344957.0
2007-11-27 17:00:00	MSFT	Stock	33.05	33.05	32.96	32.96	4411.0

> showing 50 of 69,876 rows — these rows as CSV

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