PREVIEW / stock_5min / 2011-10-21

all stock 5-min files

  file:    by_date/stock_5min/2011/2011-10-21.parquet
  size:    4.7 MB
  rows:    315,339
  symbols: 3,492

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
2011-10-21 04:55:00	AAPL	Stock	14.1429	14.1429	14.1429	14.1429	2800.0
2011-10-21 05:25:00	AAPL	Stock	14.1786	14.1786	14.1786	14.1786	2800.0
2011-10-21 06:00:00	AAPL	Stock	14.1786	14.1786	14.1786	14.1786	2800.0
2011-10-21 06:15:00	AAPL	Stock	14.1807	14.1807	14.1807	14.1807	2800.0
2011-10-21 06:50:00	AAPL	Stock	14.1664	14.1664	14.1664	14.1664	2800.0
2011-10-21 07:00:00	AAPL	Stock	14.1457	14.1679	14.1457	14.1679	11200.0
2011-10-21 07:05:00	AAPL	Stock	14.1596	14.1821	14.1504	14.1821	8400.0
2011-10-21 07:15:00	AAPL	Stock	14.1714	14.1968	14.1714	14.1968	8400.0
2011-10-21 07:20:00	AAPL	Stock	14.2032	14.2032	14.2032	14.2032	3360.0
2011-10-21 07:25:00	AAPL	Stock	14.2086	14.2143	14.2082	14.2143	74928.0
2011-10-21 07:30:00	AAPL	Stock	14.2143	14.2143	14.19	14.1964	23800.0
2011-10-21 07:35:00	AAPL	Stock	14.1875	14.1875	14.1875	14.1875	30800.0
2011-10-21 07:40:00	AAPL	Stock	14.1786	14.1786	14.1611	14.1611	14000.0
2011-10-21 07:45:00	AAPL	Stock	14.1743	14.1796	14.1675	14.1714	56000.0
2011-10-21 07:50:00	AAPL	Stock	14.1718	14.1718	14.1718	14.1718	2800.0
2011-10-21 07:55:00	AAPL	Stock	14.1793	14.1964	14.1607	14.1607	101472.0
2011-10-21 08:00:00	AAPL	Stock	14.1639	14.1875	14.1589	14.1732	693868.0
2011-10-21 08:05:00	AAPL	Stock	14.1764	14.1868	14.175	14.1768	117936.0
2011-10-21 08:10:00	AAPL	Stock	14.1786	14.1811	14.175	14.175	205520.0
2011-10-21 08:15:00	AAPL	Stock	14.1736	14.1868	14.1625	14.1807	501928.0
2011-10-21 08:20:00	AAPL	Stock	14.1814	14.1964	14.1786	14.1789	643944.0
2011-10-21 08:25:00	AAPL	Stock	14.1804	14.2046	14.1761	14.2014	349776.0
2011-10-21 08:30:00	AAPL	Stock	14.1954	14.1954	14.1821	14.1821	112140.0
2011-10-21 08:35:00	AAPL	Stock	14.1821	14.1875	14.1804	14.1804	174300.0
2011-10-21 08:40:00	AAPL	Stock	14.1832	14.1889	14.1786	14.1786	197260.0
2011-10-21 08:45:00	AAPL	Stock	14.1729	14.1786	14.1689	14.1696	193816.0
2011-10-21 08:50:00	AAPL	Stock	14.1743	14.175	14.1654	14.175	90300.0
2011-10-21 08:55:00	AAPL	Stock	14.1757	14.1914	14.1754	14.1861	252420.0
2011-10-21 09:00:00	AAPL	Stock	14.1846	14.1936	14.1846	14.1893	179368.0
2011-10-21 09:05:00	AAPL	Stock	14.1925	14.1957	14.1875	14.1882	257880.0
2011-10-21 09:10:00	AAPL	Stock	14.19	14.1939	14.1832	14.1846	358344.0
2011-10-21 09:15:00	AAPL	Stock	14.1893	14.1893	14.1807	14.1807	88760.0
2011-10-21 09:20:00	AAPL	Stock	14.1811	14.2075	14.1804	14.1929	611884.0
2011-10-21 09:25:00	AAPL	Stock	14.1996	14.2325	14.1904	14.2214	2043160.0
2011-10-21 09:30:00	AAPL	Stock	14.2214	14.2314	14.1643	14.1889	48570956.0
2011-10-21 09:35:00	AAPL	Stock	14.1891	14.2218	14.1811	14.1989	12840352.0
2011-10-21 09:40:00	AAPL	Stock	14.1968	14.2068	14.1454	14.1646	11717944.0
2011-10-21 09:45:00	AAPL	Stock	14.165	14.2132	14.1504	14.1843	13794368.0
2011-10-21 09:50:00	AAPL	Stock	14.1832	14.2071	14.1814	14.1929	7171668.0
2011-10-21 09:55:00	AAPL	Stock	14.1929	14.2021	14.1639	14.179	8079540.0
2011-10-21 10:00:00	AAPL	Stock	14.1814	14.2079	14.1796	14.1929	8095276.0
2011-10-21 10:05:00	AAPL	Stock	14.1904	14.2293	14.1902	14.2293	11843048.0
2011-10-21 10:10:00	AAPL	Stock	14.2293	14.25	14.2236	14.2316	13920396.0
2011-10-21 10:15:00	AAPL	Stock	14.2325	14.2525	14.2161	14.25	10564120.0
2011-10-21 10:20:00	AAPL	Stock	14.25	14.255	14.2182	14.2264	7693784.0
2011-10-21 10:25:00	AAPL	Stock	14.2268	14.2364	14.2061	14.2346	7601356.0
2011-10-21 10:30:00	AAPL	Stock	14.2357	14.2482	14.2143	14.2221	7281456.0
2011-10-21 10:35:00	AAPL	Stock	14.2189	14.2382	14.2154	14.2193	5829124.0
2011-10-21 10:40:00	AAPL	Stock	14.2193	14.2379	14.2193	14.2299	5644884.0
2011-10-21 10:45:00	AAPL	Stock	14.2286	14.2375	14.2246	14.2307	4571924.0

> showing 50 of 315,339 rows — these rows as CSV

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