PREVIEW / stock_30min / 2010-06-29

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-06-29.parquet
  size:    1.4 MB
  rows:    74,636
  symbols: 3,460

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-06-29 04:00:00	AAPL	Stock	9.5396	9.5396	9.5039	9.5039	8400.0
2010-06-29 05:30:00	AAPL	Stock	9.5	9.5032	9.5	9.5032	11200.0
2010-06-29 06:00:00	AAPL	Stock	9.5171	9.5182	9.5171	9.5182	8400.0
2010-06-29 06:30:00	AAPL	Stock	9.5143	9.5143	9.5143	9.5143	11200.0
2010-06-29 07:00:00	AAPL	Stock	9.5143	9.5143	9.4839	9.4839	173600.0
2010-06-29 07:30:00	AAPL	Stock	9.4839	9.4957	9.4686	9.4854	319452.0
2010-06-29 08:00:00	AAPL	Stock	9.485	9.4964	9.4464	9.4529	2891028.0
2010-06-29 08:30:00	AAPL	Stock	9.4536	9.4618	9.425	9.4511	2475312.0
2010-06-29 09:00:00	AAPL	Stock	9.4518	9.4671	9.4329	9.4364	1926904.0
2010-06-29 09:30:00	AAPL	Stock	9.4364	9.4425	9.2146	9.2618	193714052.0
2010-06-29 10:00:00	AAPL	Stock	9.2611	9.2662	9.1268	9.1271	152452804.0
2010-06-29 10:30:00	AAPL	Stock	9.1315	9.1943	9.1157	9.1943	90988128.0
2010-06-29 11:00:00	AAPL	Stock	9.1943	9.2407	9.1743	9.2129	68413296.0
2010-06-29 11:30:00	AAPL	Stock	9.2139	9.2157	9.1718	9.1771	36889300.0
2010-06-29 12:00:00	AAPL	Stock	9.1782	9.2186	9.1586	9.1964	42838768.0
2010-06-29 12:30:00	AAPL	Stock	9.1957	9.1975	9.1604	9.1664	27273932.0
2010-06-29 13:00:00	AAPL	Stock	9.1711	9.1796	9.145	9.1561	34134744.0
2010-06-29 13:30:00	AAPL	Stock	9.1584	9.2004	9.1411	9.1868	41413316.0
2010-06-29 14:00:00	AAPL	Stock	9.1864	9.2189	9.1696	9.1914	44952040.0
2010-06-29 14:30:00	AAPL	Stock	9.1914	9.3043	9.1425	9.2089	123885384.0
2010-06-29 15:00:00	AAPL	Stock	9.2089	9.25	9.1182	9.1518	112494704.0
2010-06-29 15:30:00	AAPL	Stock	9.1529	9.1739	9.0821	9.1532	128556008.0
2010-06-29 16:00:00	AAPL	Stock	9.1514	9.43	9.1357	9.15	21570248.0
2010-06-29 16:30:00	AAPL	Stock	9.1496	9.1532	9.1286	9.145	616364.0
2010-06-29 17:00:00	AAPL	Stock	9.1443	9.1493	9.1357	9.1493	532252.0
2010-06-29 17:30:00	AAPL	Stock	9.1493	9.16	9.1443	9.1525	257628.0
2010-06-29 18:00:00	AAPL	Stock	9.1496	9.15	9.1443	9.1493	171864.0
2010-06-29 18:30:00	AAPL	Stock	9.1493	9.1518	9.1446	9.1518	165592.0
2010-06-29 19:00:00	AAPL	Stock	9.1518	9.1568	9.1464	9.1464	327236.0
2010-06-29 19:30:00	AAPL	Stock	9.1468	9.15	9.1386	9.1486	377944.0
2010-06-29 04:00:00	MSFT	Stock	24.03	24.03	24.0	24.0	500.0
2010-06-29 04:30:00	MSFT	Stock	24.0	24.0	24.0	24.0	100.0
2010-06-29 06:30:00	MSFT	Stock	24.0	24.08	24.0	24.08	1440.0
2010-06-29 07:00:00	MSFT	Stock	24.0	24.1	24.0	24.04	6500.0
2010-06-29 07:30:00	MSFT	Stock	24.01	24.09	24.01	24.09	6600.0
2010-06-29 08:00:00	MSFT	Stock	24.09	24.1	24.03	24.1	73940.0
2010-06-29 08:30:00	MSFT	Stock	24.1	24.12	24.05	24.1	95105.0
2010-06-29 09:00:00	MSFT	Stock	24.06	24.14	24.04	24.13	73627.0
2010-06-29 09:30:00	MSFT	Stock	24.13	24.2	23.85	23.96	9984926.0
2010-06-29 10:00:00	MSFT	Stock	23.96	23.99	23.68	23.69	11791813.0
2010-06-29 10:30:00	MSFT	Stock	23.69	23.85	23.68	23.84	7345883.0
2010-06-29 11:00:00	MSFT	Stock	23.84	23.89	23.71	23.738	6067967.0
2010-06-29 11:30:00	MSFT	Stock	23.74	23.74	23.62	23.65	5504509.0
2010-06-29 12:00:00	MSFT	Stock	23.647	23.66	23.54	23.59	4729159.0
2010-06-29 12:30:00	MSFT	Stock	23.59	23.59	23.34	23.35	9429339.0
2010-06-29 13:00:00	MSFT	Stock	23.35	23.47	23.34	23.465	9222811.0
2010-06-29 13:30:00	MSFT	Stock	23.465	23.52	23.39	23.42	8238616.0
2010-06-29 14:00:00	MSFT	Stock	23.418	23.49	23.38	23.448	5662897.0
2010-06-29 14:30:00	MSFT	Stock	23.44	23.44	23.28	23.34	7359450.0
2010-06-29 15:00:00	MSFT	Stock	23.345	23.48	23.25	23.29	10837409.0

> showing 50 of 74,636 rows — these rows as CSV

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