PREVIEW / stock_30min / 2009-09-08

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-09-08.parquet
  size:    1.3 MB
  rows:    71,807
  symbols: 3,353

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
2009-09-08 04:00:00	AAPL	Stock	6.1357	6.1357	6.1357	6.1357	5600.0
2009-09-08 04:30:00	AAPL	Stock	6.2139	6.2139	6.2139	6.2139	2800.0
2009-09-08 05:00:00	AAPL	Stock	6.1357	6.1782	6.1357	6.1782	17640.0
2009-09-08 05:30:00	AAPL	Stock	6.1782	6.1782	6.1782	6.1782	2800.0
2009-09-08 06:30:00	AAPL	Stock	6.1293	6.1293	6.1293	6.1293	11200.0
2009-09-08 07:00:00	AAPL	Stock	6.1293	6.1779	6.1293	6.1661	95760.0
2009-09-08 07:30:00	AAPL	Stock	6.1775	6.1775	6.1661	6.1714	136360.0
2009-09-08 08:00:00	AAPL	Stock	6.1704	6.1854	6.1661	6.1707	1061452.0
2009-09-08 08:30:00	AAPL	Stock	6.1707	6.1743	6.1661	6.1707	533428.0
2009-09-08 09:00:00	AAPL	Stock	6.17	6.18	6.1579	6.1621	1756916.0
2009-09-08 09:30:00	AAPL	Stock	6.1643	6.1836	6.1454	6.1607	70321412.0
2009-09-08 10:00:00	AAPL	Stock	6.1618	6.1775	6.1529	6.1646	34764072.0
2009-09-08 10:30:00	AAPL	Stock	6.1654	6.1786	6.1593	6.1757	23078048.0
2009-09-08 11:00:00	AAPL	Stock	6.1757	6.1782	6.1607	6.1746	17480652.0
2009-09-08 11:30:00	AAPL	Stock	6.1742	6.1746	6.1514	6.1614	17815952.0
2009-09-08 12:00:00	AAPL	Stock	6.1618	6.1625	6.15	6.1529	12643764.0
2009-09-08 12:30:00	AAPL	Stock	6.1529	6.1621	6.1518	6.161	8281168.0
2009-09-08 13:00:00	AAPL	Stock	6.1611	6.1643	6.1511	6.1603	10265640.0
2009-09-08 13:30:00	AAPL	Stock	6.1607	6.1618	6.1429	6.1521	14729596.0
2009-09-08 14:00:00	AAPL	Stock	6.1521	6.1607	6.1432	6.1564	15699152.0
2009-09-08 14:30:00	AAPL	Stock	6.1571	6.1675	6.1568	6.1582	17038448.0
2009-09-08 15:00:00	AAPL	Stock	6.1582	6.1643	6.1536	6.1618	15286180.0
2009-09-08 15:30:00	AAPL	Stock	6.16	6.1757	6.16	6.1757	34716248.0
2009-09-08 16:00:00	AAPL	Stock	6.1761	6.1761	6.1629	6.1761	10043824.0
2009-09-08 16:30:00	AAPL	Stock	6.1696	6.1761	6.1679	6.1693	158088.0
2009-09-08 17:00:00	AAPL	Stock	6.1686	6.1714	6.1671	6.1682	159852.0
2009-09-08 17:30:00	AAPL	Stock	6.1707	6.175	6.1682	6.175	274764.0
2009-09-08 18:00:00	AAPL	Stock	6.1732	6.1771	6.1696	6.1757	433440.0
2009-09-08 18:30:00	AAPL	Stock	6.175	6.1771	6.175	6.1771	33236.0
2009-09-08 19:00:00	AAPL	Stock	6.1771	6.1771	6.1739	6.1739	35896.0
2009-09-08 19:30:00	AAPL	Stock	6.175	6.175	6.1696	6.1743	160804.0
2009-09-08 04:00:00	MSFT	Stock	24.83	24.83	24.83	24.83	105.0
2009-09-08 06:00:00	MSFT	Stock	24.88	24.93	24.88	24.93	900.0
2009-09-08 06:30:00	MSFT	Stock	24.84	24.84	24.75	24.75	3000.0
2009-09-08 07:30:00	MSFT	Stock	24.93	24.93	24.82	24.82	1700.0
2009-09-08 08:00:00	MSFT	Stock	24.79	24.82	24.71	24.75	30039.0
2009-09-08 08:30:00	MSFT	Stock	24.79	24.8	24.79	24.8	15646.0
2009-09-08 09:00:00	MSFT	Stock	24.8	24.81	24.42	24.61	225113.0
2009-09-08 09:30:00	MSFT	Stock	24.63	24.68	24.46	24.53	7202538.0
2009-09-08 10:00:00	MSFT	Stock	24.53	24.56	24.45	24.48	6085035.0
2009-09-08 10:30:00	MSFT	Stock	24.49	24.55	24.46	24.5	3531748.0
2009-09-08 11:00:00	MSFT	Stock	24.49	24.53	24.44	24.47	2531506.0
2009-09-08 11:30:00	MSFT	Stock	24.471	24.55	24.41	24.53	4472766.0
2009-09-08 12:00:00	MSFT	Stock	24.52	24.7	24.51	24.69	4196978.0
2009-09-08 12:30:00	MSFT	Stock	24.7	24.7	24.65	24.66	1203912.0
2009-09-08 13:00:00	MSFT	Stock	24.66	24.75	24.65	24.725	2683233.0
2009-09-08 13:30:00	MSFT	Stock	24.72	24.78	24.68	24.73	2113790.0
2009-09-08 14:00:00	MSFT	Stock	24.725	24.75	24.68	24.717	1573379.0
2009-09-08 14:30:00	MSFT	Stock	24.72	24.8	24.71	24.78	2849792.0
2009-09-08 15:00:00	MSFT	Stock	24.772	24.8	24.71	24.745	3097158.0

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

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