PREVIEW / stock_1min / 2013-12-23

all stock 1-min files

  file:    by_date/stock_1min/2013/2013-12-23.parquet
  size:    15.0 MB
  rows:    1,085,685
  symbols: 2,868

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
2013-12-23 04:00:00	AAPL	Stock	19.7861	20.3446	19.7861	20.2182	95200.0
2013-12-23 04:01:00	AAPL	Stock	20.2182	20.2182	20.1679	20.1679	44800.0
2013-12-23 04:02:00	AAPL	Stock	20.1961	20.1961	20.1246	20.1518	29400.0
2013-12-23 04:03:00	AAPL	Stock	20.1075	20.1075	20.0907	20.1075	28000.0
2013-12-23 04:05:00	AAPL	Stock	20.1404	20.1404	20.1089	20.1089	6524.0
2013-12-23 04:06:00	AAPL	Stock	20.14	20.14	20.14	20.14	5600.0
2013-12-23 04:07:00	AAPL	Stock	20.1404	20.1432	20.1404	20.1432	18144.0
2013-12-23 04:09:00	AAPL	Stock	20.1504	20.1504	20.1504	20.1504	2800.0
2013-12-23 04:10:00	AAPL	Stock	20.1746	20.1786	20.1746	20.1786	29960.0
2013-12-23 04:12:00	AAPL	Stock	20.1768	20.1768	20.1768	20.1768	3640.0
2013-12-23 04:19:00	AAPL	Stock	20.1854	20.1979	20.1854	20.1979	6300.0
2013-12-23 04:23:00	AAPL	Stock	20.2143	20.2143	20.2143	20.2143	2800.0
2013-12-23 04:24:00	AAPL	Stock	20.2143	20.2143	20.2136	20.2136	55160.0
2013-12-23 04:25:00	AAPL	Stock	20.2139	20.2139	20.1911	20.1968	16800.0
2013-12-23 04:27:00	AAPL	Stock	20.1786	20.1786	20.1786	20.1786	4200.0
2013-12-23 04:28:00	AAPL	Stock	20.1814	20.1814	20.1814	20.1814	2800.0
2013-12-23 04:29:00	AAPL	Stock	20.1964	20.1964	20.1964	20.1964	2800.0
2013-12-23 04:31:00	AAPL	Stock	20.2014	20.2014	20.1832	20.1868	11200.0
2013-12-23 04:33:00	AAPL	Stock	20.2011	20.2032	20.2011	20.2032	11200.0
2013-12-23 04:34:00	AAPL	Stock	20.1843	20.1843	20.1836	20.1843	58800.0
2013-12-23 04:35:00	AAPL	Stock	20.1818	20.1818	20.1818	20.1818	14000.0
2013-12-23 04:36:00	AAPL	Stock	20.2007	20.2011	20.1818	20.1821	36400.0
2013-12-23 04:37:00	AAPL	Stock	20.185	20.185	20.185	20.185	11200.0
2013-12-23 04:38:00	AAPL	Stock	20.185	20.185	20.1818	20.185	24780.0
2013-12-23 04:39:00	AAPL	Stock	20.1768	20.185	20.1768	20.1786	31892.0
2013-12-23 04:40:00	AAPL	Stock	20.1768	20.1786	20.1768	20.1786	36400.0
2013-12-23 04:41:00	AAPL	Stock	20.1786	20.1786	20.1786	20.1786	22400.0
2013-12-23 04:43:00	AAPL	Stock	20.1843	20.1843	20.1789	20.1789	5600.0
2013-12-23 04:44:00	AAPL	Stock	20.1786	20.1786	20.1786	20.1786	28000.0
2013-12-23 04:45:00	AAPL	Stock	20.1786	20.1786	20.1786	20.1786	14000.0
2013-12-23 04:46:00	AAPL	Stock	20.1786	20.1786	20.1786	20.1786	28000.0
2013-12-23 04:47:00	AAPL	Stock	20.1786	20.1786	20.1775	20.1775	19600.0
2013-12-23 04:54:00	AAPL	Stock	20.1782	20.1782	20.1782	20.1782	2800.0
2013-12-23 04:55:00	AAPL	Stock	20.1786	20.1786	20.1786	20.1786	28000.0
2013-12-23 04:56:00	AAPL	Stock	20.1804	20.1804	20.1804	20.1804	14000.0
2013-12-23 04:59:00	AAPL	Stock	20.1846	20.1846	20.1846	20.1846	6888.0
2013-12-23 05:06:00	AAPL	Stock	20.2118	20.2118	20.2118	20.2118	2800.0
2013-12-23 05:11:00	AAPL	Stock	20.2125	20.2232	20.2125	20.2232	19600.0
2013-12-23 05:12:00	AAPL	Stock	20.2143	20.2204	20.2143	20.215	8400.0
2013-12-23 05:13:00	AAPL	Stock	20.22	20.22	20.22	20.22	2800.0
2013-12-23 05:14:00	AAPL	Stock	20.25	20.2507	20.25	20.2507	5600.0
2013-12-23 05:15:00	AAPL	Stock	20.2607	20.2607	20.2607	20.2607	2800.0
2013-12-23 05:16:00	AAPL	Stock	20.2511	20.2511	20.2511	20.2511	5600.0
2013-12-23 05:19:00	AAPL	Stock	20.2521	20.2521	20.2511	20.2511	5600.0
2013-12-23 05:22:00	AAPL	Stock	20.2411	20.2411	20.2411	20.2411	2800.0
2013-12-23 05:26:00	AAPL	Stock	20.25	20.25	20.25	20.25	6972.0
2013-12-23 05:31:00	AAPL	Stock	20.2493	20.25	20.2493	20.25	9744.0
2013-12-23 05:32:00	AAPL	Stock	20.2675	20.2675	20.2675	20.2675	5600.0
2013-12-23 05:33:00	AAPL	Stock	20.2675	20.2811	20.2675	20.2811	28000.0
2013-12-23 05:34:00	AAPL	Stock	20.2943	20.2943	20.2943	20.2943	2800.0

> showing 50 of 1,085,685 rows — these rows as CSV

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