PREVIEW / stock_5min / 2011-02-23

all stock 5-min files

  file:    by_date/stock_5min/2011/2011-02-23.parquet
  size:    5.2 MB
  rows:    348,027
  symbols: 3,538

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-02-23 04:00:00	AAPL	Stock	12.0964	12.0964	12.0964	12.0964	28000.0
2011-02-23 05:10:00	AAPL	Stock	12.0986	12.0986	12.0986	12.0986	2800.0
2011-02-23 05:30:00	AAPL	Stock	12.1139	12.1139	12.1139	12.1139	2800.0
2011-02-23 05:40:00	AAPL	Stock	12.1082	12.1082	12.1082	12.1082	2800.0
2011-02-23 06:00:00	AAPL	Stock	12.1021	12.1021	12.1021	12.1021	8120.0
2011-02-23 06:10:00	AAPL	Stock	12.1054	12.1082	12.1054	12.1082	5600.0
2011-02-23 06:15:00	AAPL	Stock	12.1111	12.1111	12.1	12.1	11200.0
2011-02-23 06:20:00	AAPL	Stock	12.1068	12.1068	12.1068	12.1068	2800.0
2011-02-23 06:25:00	AAPL	Stock	12.1254	12.1254	12.1254	12.1254	2800.0
2011-02-23 06:30:00	AAPL	Stock	12.1418	12.1539	12.1418	12.1539	11200.0
2011-02-23 06:40:00	AAPL	Stock	12.1446	12.1496	12.1429	12.1496	11200.0
2011-02-23 06:50:00	AAPL	Stock	12.1604	12.1604	12.1604	12.1604	2800.0
2011-02-23 06:55:00	AAPL	Stock	12.1604	12.1604	12.1604	12.1604	5600.0
2011-02-23 07:00:00	AAPL	Stock	12.1696	12.2036	12.1696	12.1786	47348.0
2011-02-23 07:05:00	AAPL	Stock	12.1786	12.1786	12.1696	12.1786	109564.0
2011-02-23 07:10:00	AAPL	Stock	12.1786	12.1964	12.1786	12.1929	53200.0
2011-02-23 07:15:00	AAPL	Stock	12.1946	12.2	12.1914	12.1914	107828.0
2011-02-23 07:20:00	AAPL	Stock	12.1968	12.2125	12.1914	12.2104	103796.0
2011-02-23 07:25:00	AAPL	Stock	12.2043	12.2125	12.2043	12.2054	25004.0
2011-02-23 07:30:00	AAPL	Stock	12.2046	12.2307	12.2046	12.2143	183932.0
2011-02-23 07:35:00	AAPL	Stock	12.2104	12.2214	12.2018	12.2018	54712.0
2011-02-23 07:40:00	AAPL	Stock	12.2143	12.2143	12.2143	12.2143	36400.0
2011-02-23 07:45:00	AAPL	Stock	12.2143	12.2143	12.2029	12.2089	41720.0
2011-02-23 07:50:00	AAPL	Stock	12.2089	12.2089	12.2061	12.2061	37520.0
2011-02-23 07:55:00	AAPL	Stock	12.2014	12.2014	12.2014	12.2014	14000.0
2011-02-23 08:00:00	AAPL	Stock	12.2018	12.2096	12.1675	12.1937	841036.0
2011-02-23 08:05:00	AAPL	Stock	12.1789	12.1911	12.1589	12.1786	261324.0
2011-02-23 08:10:00	AAPL	Stock	12.1782	12.1786	12.1568	12.1607	305480.0
2011-02-23 08:15:00	AAPL	Stock	12.16	12.1736	12.1429	12.1586	625856.0
2011-02-23 08:20:00	AAPL	Stock	12.1571	12.1671	12.1543	12.1607	92820.0
2011-02-23 08:25:00	AAPL	Stock	12.1636	12.1689	12.1593	12.1661	156436.0
2011-02-23 08:30:00	AAPL	Stock	12.1636	12.1739	12.1636	12.1725	265804.0
2011-02-23 08:35:00	AAPL	Stock	12.1721	12.1721	12.1614	12.1711	185808.0
2011-02-23 08:40:00	AAPL	Stock	12.1711	12.1714	12.1664	12.1711	131684.0
2011-02-23 08:45:00	AAPL	Stock	12.1707	12.1786	12.1707	12.1739	314328.0
2011-02-23 08:50:00	AAPL	Stock	12.1739	12.1757	12.1643	12.1729	284872.0
2011-02-23 08:55:00	AAPL	Stock	12.1732	12.1864	12.1646	12.1786	328440.0
2011-02-23 09:00:00	AAPL	Stock	12.1793	12.1829	12.1732	12.175	238056.0
2011-02-23 09:05:00	AAPL	Stock	12.1729	12.1732	12.1539	12.1571	424060.0
2011-02-23 09:10:00	AAPL	Stock	12.1554	12.1621	12.1411	12.1468	497308.0
2011-02-23 09:15:00	AAPL	Stock	12.1454	12.1607	12.1411	12.1536	267092.0
2011-02-23 09:20:00	AAPL	Stock	12.1518	12.1557	12.1436	12.1457	202524.0
2011-02-23 09:25:00	AAPL	Stock	12.1461	12.1475	12.1018	12.1032	876932.0
2011-02-23 09:30:00	AAPL	Stock	12.0989	12.2232	12.0932	12.2172	23003596.0
2011-02-23 09:35:00	AAPL	Stock	12.2189	12.2475	12.2	12.2046	20544944.0
2011-02-23 09:40:00	AAPL	Stock	12.2071	12.2389	12.2	12.2221	12011748.0
2011-02-23 09:45:00	AAPL	Stock	12.2225	12.2289	12.2036	12.2168	12462856.0
2011-02-23 09:50:00	AAPL	Stock	12.2184	12.2268	12.1818	12.2029	13540408.0
2011-02-23 09:55:00	AAPL	Stock	12.2032	12.2036	12.145	12.1461	13749176.0
2011-02-23 10:00:00	AAPL	Stock	12.1461	12.1729	12.1375	12.1556	15514660.0

> showing 50 of 348,027 rows — these rows as CSV

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