PREVIEW / stock_5min / 2009-09-08

all stock 5-min files

  file:    by_date/stock_5min/2009/2009-09-08.parquet
  size:    4.6 MB
  rows:    319,930
  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:15:00	AAPL	Stock	6.1357	6.1357	6.1357	6.1357	5600.0
2009-09-08 04:45:00	AAPL	Stock	6.2139	6.2139	6.2139	6.2139	2800.0
2009-09-08 05:20:00	AAPL	Stock	6.1357	6.1357	6.1357	6.1357	5600.0
2009-09-08 05:25:00	AAPL	Stock	6.1782	6.1782	6.1782	6.1782	12040.0
2009-09-08 05:45: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:05:00	AAPL	Stock	6.1293	6.165	6.1293	6.165	12600.0
2009-09-08 07:10:00	AAPL	Stock	6.1643	6.1643	6.1643	6.1643	2800.0
2009-09-08 07:15:00	AAPL	Stock	6.1636	6.1729	6.1636	6.1729	36064.0
2009-09-08 07:20:00	AAPL	Stock	6.1779	6.1779	6.1661	6.1661	26600.0
2009-09-08 07:25:00	AAPL	Stock	6.1696	6.1696	6.1661	6.1661	17696.0
2009-09-08 07:30:00	AAPL	Stock	6.1775	6.1775	6.1775	6.1775	2800.0
2009-09-08 07:40:00	AAPL	Stock	6.1664	6.1761	6.1661	6.1746	95200.0
2009-09-08 07:45:00	AAPL	Stock	6.1714	6.1714	6.1714	6.1714	8400.0
2009-09-08 07:50:00	AAPL	Stock	6.1714	6.1714	6.1714	6.1714	5600.0
2009-09-08 07:55:00	AAPL	Stock	6.1746	6.1746	6.1714	6.1714	24360.0
2009-09-08 08:00:00	AAPL	Stock	6.1704	6.1786	6.1661	6.1786	396844.0
2009-09-08 08:05:00	AAPL	Stock	6.1754	6.1854	6.175	6.1786	186228.0
2009-09-08 08:10:00	AAPL	Stock	6.1804	6.1821	6.1689	6.1689	123704.0
2009-09-08 08:15:00	AAPL	Stock	6.1704	6.1707	6.1679	6.1696	99540.0
2009-09-08 08:20:00	AAPL	Stock	6.1704	6.1743	6.17	6.1714	70000.0
2009-09-08 08:25:00	AAPL	Stock	6.1714	6.1732	6.1707	6.1707	185136.0
2009-09-08 08:30:00	AAPL	Stock	6.1707	6.1714	6.1696	6.1696	52892.0
2009-09-08 08:35:00	AAPL	Stock	6.1696	6.1743	6.1696	6.1714	67200.0
2009-09-08 08:40:00	AAPL	Stock	6.17	6.1732	6.1661	6.1729	188216.0
2009-09-08 08:45:00	AAPL	Stock	6.1711	6.1711	6.1664	6.1707	98000.0
2009-09-08 08:50:00	AAPL	Stock	6.1704	6.1718	6.1671	6.1707	93520.0
2009-09-08 08:55:00	AAPL	Stock	6.1675	6.1707	6.1675	6.1707	33600.0
2009-09-08 09:00:00	AAPL	Stock	6.17	6.1721	6.17	6.1721	59304.0
2009-09-08 09:05:00	AAPL	Stock	6.1729	6.1782	6.1729	6.1757	356020.0
2009-09-08 09:10:00	AAPL	Stock	6.1782	6.18	6.1768	6.18	283388.0
2009-09-08 09:15:00	AAPL	Stock	6.1786	6.1786	6.1757	6.1768	114772.0
2009-09-08 09:20:00	AAPL	Stock	6.1771	6.1771	6.175	6.175	169820.0
2009-09-08 09:25:00	AAPL	Stock	6.1754	6.1761	6.1579	6.1621	773612.0
2009-09-08 09:30:00	AAPL	Stock	6.1643	6.1821	6.1511	6.1729	22998612.0
2009-09-08 09:35:00	AAPL	Stock	6.1721	6.1836	6.165	6.1729	11491760.0
2009-09-08 09:40:00	AAPL	Stock	6.1729	6.1746	6.1554	6.1632	9697044.0
2009-09-08 09:45:00	AAPL	Stock	6.1639	6.1696	6.1454	6.155	11562992.0
2009-09-08 09:50:00	AAPL	Stock	6.1554	6.1661	6.1507	6.165	7663348.0
2009-09-08 09:55:00	AAPL	Stock	6.1654	6.1696	6.1518	6.1607	6907656.0
2009-09-08 10:00:00	AAPL	Stock	6.1618	6.1693	6.1529	6.1614	7407288.0
2009-09-08 10:05:00	AAPL	Stock	6.1604	6.1614	6.1529	6.1582	5665380.0
2009-09-08 10:10:00	AAPL	Stock	6.1582	6.1768	6.1571	6.1764	6483708.0
2009-09-08 10:15:00	AAPL	Stock	6.1764	6.1775	6.16	6.1614	6116404.0
2009-09-08 10:20:00	AAPL	Stock	6.1614	6.1686	6.1571	6.1675	5720344.0
2009-09-08 10:25:00	AAPL	Stock	6.1679	6.1711	6.1632	6.1646	3370948.0
2009-09-08 10:30:00	AAPL	Stock	6.1654	6.1739	6.1654	6.1668	4250540.0
2009-09-08 10:35:00	AAPL	Stock	6.1668	6.1721	6.1643	6.1673	3351880.0
2009-09-08 10:40:00	AAPL	Stock	6.1688	6.17	6.1593	6.1625	3891272.0
2009-09-08 10:45:00	AAPL	Stock	6.1618	6.1696	6.1607	6.1693	2710316.0

> showing 50 of 319,930 rows — these rows as CSV

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