PREVIEW / stock_5min / 2010-07-23

all stock 5-min files

  file:    by_date/stock_5min/2010/2010-07-23.parquet
  size:    4.7 MB
  rows:    322,903
  symbols: 3,457

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-23 04:00:00	AAPL	Stock	9.2482	9.2482	9.2482	9.2482	14000.0
2010-07-23 04:05:00	AAPL	Stock	9.2782	9.2854	9.2782	9.2854	9716.0
2010-07-23 04:30:00	AAPL	Stock	9.2921	9.2921	9.2921	9.2921	2800.0
2010-07-23 05:15:00	AAPL	Stock	9.2957	9.2957	9.2957	9.2957	2800.0
2010-07-23 05:20:00	AAPL	Stock	9.3193	9.3193	9.3193	9.3193	2800.0
2010-07-23 05:25:00	AAPL	Stock	9.3175	9.3175	9.3175	9.3175	2800.0
2010-07-23 06:15:00	AAPL	Stock	9.3143	9.3143	9.3143	9.3143	2800.0
2010-07-23 06:50:00	AAPL	Stock	9.3157	9.3161	9.3157	9.3161	9548.0
2010-07-23 06:55:00	AAPL	Stock	9.2964	9.2964	9.2964	9.2964	2800.0
2010-07-23 07:00:00	AAPL	Stock	9.2961	9.3036	9.2929	9.3029	62916.0
2010-07-23 07:05:00	AAPL	Stock	9.3114	9.3143	9.3	9.3036	66976.0
2010-07-23 07:15:00	AAPL	Stock	9.3114	9.3179	9.3114	9.3179	82600.0
2010-07-23 07:20:00	AAPL	Stock	9.3179	9.3179	9.3057	9.3057	32480.0
2010-07-23 07:25:00	AAPL	Stock	9.3036	9.3104	9.3036	9.3104	15400.0
2010-07-23 07:30:00	AAPL	Stock	9.2996	9.3068	9.2993	9.3068	8400.0
2010-07-23 07:35:00	AAPL	Stock	9.3068	9.3068	9.3068	9.3068	2800.0
2010-07-23 07:40:00	AAPL	Stock	9.3036	9.3039	9.3036	9.3036	14000.0
2010-07-23 07:45:00	AAPL	Stock	9.3068	9.3161	9.2954	9.2954	128520.0
2010-07-23 07:50:00	AAPL	Stock	9.295	9.3036	9.2946	9.2946	47460.0
2010-07-23 07:55:00	AAPL	Stock	9.2954	9.3007	9.2954	9.3	28924.0
2010-07-23 08:00:00	AAPL	Stock	9.2986	9.2986	9.2625	9.2811	304332.0
2010-07-23 08:05:00	AAPL	Stock	9.275	9.275	9.2632	9.2639	71260.0
2010-07-23 08:10:00	AAPL	Stock	9.2625	9.2643	9.255	9.255	114240.0
2010-07-23 08:15:00	AAPL	Stock	9.2521	9.2693	9.2386	9.2671	159740.0
2010-07-23 08:20:00	AAPL	Stock	9.2679	9.2679	9.2571	9.2607	129192.0
2010-07-23 08:25:00	AAPL	Stock	9.265	9.2704	9.2607	9.2661	90328.0
2010-07-23 08:30:00	AAPL	Stock	9.2607	9.2679	9.1582	9.1821	1455608.0
2010-07-23 08:35:00	AAPL	Stock	9.1821	9.2311	9.1754	9.2107	599004.0
2010-07-23 08:40:00	AAPL	Stock	9.2107	9.225	9.2089	9.2143	237720.0
2010-07-23 08:45:00	AAPL	Stock	9.2143	9.2182	9.2143	9.2171	176260.0
2010-07-23 08:50:00	AAPL	Stock	9.2175	9.2179	9.2054	9.2068	297444.0
2010-07-23 08:55:00	AAPL	Stock	9.2089	9.2121	9.2068	9.2107	256480.0
2010-07-23 09:00:00	AAPL	Stock	9.2104	9.2157	9.2089	9.2107	247912.0
2010-07-23 09:05:00	AAPL	Stock	9.2121	9.2164	9.2096	9.2132	615692.0
2010-07-23 09:10:00	AAPL	Stock	9.2157	9.2232	9.2096	9.2096	434112.0
2010-07-23 09:15:00	AAPL	Stock	9.2161	9.2171	9.2075	9.2168	329560.0
2010-07-23 09:20:00	AAPL	Stock	9.2136	9.2143	9.1804	9.1857	375536.0
2010-07-23 09:25:00	AAPL	Stock	9.1857	9.2046	9.1789	9.1804	384160.0
2010-07-23 09:30:00	AAPL	Stock	9.1814	9.2286	9.1743	9.2066	12033224.0
2010-07-23 09:35:00	AAPL	Stock	9.2077	9.2236	9.1857	9.2236	10649632.0
2010-07-23 09:40:00	AAPL	Stock	9.2232	9.2643	9.2143	9.2529	12186076.0
2010-07-23 09:45:00	AAPL	Stock	9.2525	9.2554	9.2125	9.2185	7582792.0
2010-07-23 09:50:00	AAPL	Stock	9.2186	9.2236	9.1914	9.1929	12216008.0
2010-07-23 09:55:00	AAPL	Stock	9.1921	9.2014	9.1607	9.1618	13927312.0
2010-07-23 10:00:00	AAPL	Stock	9.1636	9.18	9.1529	9.1757	13247276.0
2010-07-23 10:05:00	AAPL	Stock	9.1739	9.1957	9.1719	9.1857	8256276.0
2010-07-23 10:10:00	AAPL	Stock	9.1859	9.2	9.1789	9.1964	6088096.0
2010-07-23 10:15:00	AAPL	Stock	9.1954	9.205	9.1861	9.2007	5412372.0
2010-07-23 10:20:00	AAPL	Stock	9.2007	9.2036	9.1814	9.192	4885944.0
2010-07-23 10:25:00	AAPL	Stock	9.192	9.2221	9.1893	9.22	8486716.0

> showing 50 of 322,903 rows — these rows as CSV

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