PREVIEW / stock_5min / 2010-07-22

all stock 5-min files

  file:    by_date/stock_5min/2010/2010-07-22.parquet
  size:    4.7 MB
  rows:    323,467
  symbols: 3,464

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-22 04:00:00	AAPL	Stock	9.1075	9.1075	9.1075	9.1075	5600.0
2010-07-22 04:40:00	AAPL	Stock	9.1607	9.1607	9.1607	9.1607	2800.0
2010-07-22 04:45:00	AAPL	Stock	9.1782	9.1782	9.1782	9.1782	2800.0
2010-07-22 04:50:00	AAPL	Stock	9.1782	9.1782	9.1782	9.1782	14000.0
2010-07-22 05:15:00	AAPL	Stock	9.1957	9.1957	9.1846	9.1846	16800.0
2010-07-22 05:40:00	AAPL	Stock	9.1786	9.1786	9.1786	9.1786	5600.0
2010-07-22 05:55:00	AAPL	Stock	9.1786	9.1786	9.1786	9.1786	2800.0
2010-07-22 06:00:00	AAPL	Stock	9.1711	9.1711	9.1711	9.1711	5544.0
2010-07-22 06:05:00	AAPL	Stock	9.1786	9.1786	9.1786	9.1786	5768.0
2010-07-22 06:10:00	AAPL	Stock	9.1754	9.1754	9.1711	9.1711	14056.0
2010-07-22 06:20:00	AAPL	Stock	9.1714	9.1714	9.1714	9.1714	8400.0
2010-07-22 06:25:00	AAPL	Stock	9.1714	9.1714	9.1714	9.1714	16800.0
2010-07-22 06:30:00	AAPL	Stock	9.1754	9.1754	9.1754	9.1754	9436.0
2010-07-22 06:40:00	AAPL	Stock	9.1754	9.1868	9.1754	9.1864	64764.0
2010-07-22 06:45:00	AAPL	Stock	9.1914	9.1939	9.1914	9.1939	19600.0
2010-07-22 06:50:00	AAPL	Stock	9.1925	9.1925	9.1818	9.1818	41300.0
2010-07-22 06:55:00	AAPL	Stock	9.1839	9.1839	9.1839	9.1839	8400.0
2010-07-22 07:00:00	AAPL	Stock	9.1864	9.1864	9.1607	9.1725	58800.0
2010-07-22 07:05:00	AAPL	Stock	9.1696	9.1732	9.1696	9.1732	17108.0
2010-07-22 07:10:00	AAPL	Stock	9.1611	9.1696	9.1611	9.1632	26600.0
2010-07-22 07:15:00	AAPL	Stock	9.1629	9.1679	9.155	9.155	127540.0
2010-07-22 07:20:00	AAPL	Stock	9.155	9.155	9.1425	9.1425	22400.0
2010-07-22 07:30:00	AAPL	Stock	9.1529	9.1789	9.1518	9.1757	156828.0
2010-07-22 07:35:00	AAPL	Stock	9.1757	9.1864	9.1718	9.1864	139048.0
2010-07-22 07:40:00	AAPL	Stock	9.1875	9.1889	9.1786	9.1786	64344.0
2010-07-22 07:45:00	AAPL	Stock	9.1786	9.1829	9.1757	9.1786	39200.0
2010-07-22 07:50:00	AAPL	Stock	9.1786	9.1786	9.1714	9.1786	169792.0
2010-07-22 07:55:00	AAPL	Stock	9.1786	9.1875	9.1786	9.1875	140672.0
2010-07-22 08:00:00	AAPL	Stock	9.1836	9.1893	9.1714	9.1821	883036.0
2010-07-22 08:05:00	AAPL	Stock	9.1804	9.1882	9.1804	9.1864	568848.0
2010-07-22 08:10:00	AAPL	Stock	9.1882	9.1882	9.1821	9.1821	548128.0
2010-07-22 08:15:00	AAPL	Stock	9.1821	9.1836	9.1736	9.175	206108.0
2010-07-22 08:20:00	AAPL	Stock	9.1793	9.1793	9.1554	9.1611	319200.0
2010-07-22 08:25:00	AAPL	Stock	9.1611	9.1682	9.1571	9.1679	164556.0
2010-07-22 08:30:00	AAPL	Stock	9.1657	9.1736	9.1454	9.1611	977144.0
2010-07-22 08:35:00	AAPL	Stock	9.1625	9.1721	9.1536	9.1629	418124.0
2010-07-22 08:40:00	AAPL	Stock	9.1664	9.1714	9.1618	9.1625	186200.0
2010-07-22 08:45:00	AAPL	Stock	9.1639	9.1729	9.1514	9.1682	399280.0
2010-07-22 08:50:00	AAPL	Stock	9.1679	9.1793	9.1679	9.1793	189728.0
2010-07-22 08:55:00	AAPL	Stock	9.1818	9.1861	9.1764	9.1861	295008.0
2010-07-22 09:00:00	AAPL	Stock	9.1857	9.2029	9.1857	9.2014	560392.0
2010-07-22 09:05:00	AAPL	Stock	9.1996	9.2125	9.1964	9.2071	725984.0
2010-07-22 09:10:00	AAPL	Stock	9.2054	9.2071	9.1946	9.1954	224784.0
2010-07-22 09:15:00	AAPL	Stock	9.1929	9.1961	9.19	9.1932	88200.0
2010-07-22 09:20:00	AAPL	Stock	9.195	9.1954	9.1925	9.195	46760.0
2010-07-22 09:25:00	AAPL	Stock	9.1932	9.2054	9.1904	9.1996	695716.0
2010-07-22 09:30:00	AAPL	Stock	9.1993	9.2143	9.1436	9.1457	22321656.0
2010-07-22 09:35:00	AAPL	Stock	9.1457	9.1661	9.1357	9.143	18334428.0
2010-07-22 09:40:00	AAPL	Stock	9.1429	9.1661	9.1214	9.1639	21882532.0
2010-07-22 09:45:00	AAPL	Stock	9.165	9.1782	9.135	9.1496	14872928.0

> showing 50 of 323,467 rows — these rows as CSV

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