PREVIEW / stock_5min / 2012-05-22

all stock 5-min files

  file:    by_date/stock_5min/2012/2012-05-22.parquet
  size:    4.9 MB
  rows:    331,263
  symbols: 3,536

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
2012-05-22 04:00:00	AAPL	Stock	20.1786	20.4286	20.1786	20.4286	80696.0
2012-05-22 04:10:00	AAPL	Stock	20.2589	20.2589	20.2589	20.2589	2800.0
2012-05-22 04:15:00	AAPL	Stock	20.2286	20.2364	20.2286	20.2364	14028.0
2012-05-22 04:25:00	AAPL	Stock	20.2589	20.2589	20.2589	20.2589	5600.0
2012-05-22 04:30:00	AAPL	Stock	20.2586	20.2586	20.2586	20.2586	2800.0
2012-05-22 04:40:00	AAPL	Stock	20.2314	20.2314	20.2268	20.2268	11200.0
2012-05-22 04:50:00	AAPL	Stock	20.1821	20.2036	20.1821	20.1964	25200.0
2012-05-22 04:55:00	AAPL	Stock	20.1904	20.1904	20.1786	20.1786	82236.0
2012-05-22 05:05:00	AAPL	Stock	20.1643	20.1643	20.1393	20.1393	11200.0
2012-05-22 05:10:00	AAPL	Stock	20.1261	20.1261	20.1261	20.1261	14140.0
2012-05-22 05:15:00	AAPL	Stock	20.1111	20.1393	20.1107	20.1393	10080.0
2012-05-22 05:35:00	AAPL	Stock	20.1593	20.1593	20.1593	20.1593	2800.0
2012-05-22 06:00:00	AAPL	Stock	20.1321	20.1321	20.1321	20.1321	14000.0
2012-05-22 06:30:00	AAPL	Stock	20.1111	20.1111	20.1111	20.1111	2800.0
2012-05-22 06:45:00	AAPL	Stock	20.125	20.125	20.125	20.125	5320.0
2012-05-22 06:50:00	AAPL	Stock	20.1429	20.1429	20.1429	20.1429	2800.0
2012-05-22 07:00:00	AAPL	Stock	20.1561	20.16	20.0975	20.0975	206332.0
2012-05-22 07:05:00	AAPL	Stock	20.125	20.1368	20.125	20.1368	11200.0
2012-05-22 07:10:00	AAPL	Stock	20.1429	20.1739	20.1368	20.1725	98056.0
2012-05-22 07:15:00	AAPL	Stock	20.1621	20.1714	20.1607	20.1714	14000.0
2012-05-22 07:20:00	AAPL	Stock	20.1729	20.1964	20.1729	20.1868	216776.0
2012-05-22 07:25:00	AAPL	Stock	20.1904	20.1904	20.1821	20.1821	53200.0
2012-05-22 07:30:00	AAPL	Stock	20.1875	20.1907	20.1664	20.1696	72800.0
2012-05-22 07:35:00	AAPL	Stock	20.1714	20.1821	20.1714	20.1821	72800.0
2012-05-22 07:40:00	AAPL	Stock	20.1875	20.1875	20.1696	20.1786	86744.0
2012-05-22 07:45:00	AAPL	Stock	20.185	20.2071	20.185	20.2071	69440.0
2012-05-22 07:50:00	AAPL	Stock	20.2071	20.2136	20.2046	20.2114	55692.0
2012-05-22 07:55:00	AAPL	Stock	20.2036	20.2136	20.1786	20.2018	213864.0
2012-05-22 08:00:00	AAPL	Stock	20.2032	20.2611	20.1429	20.2321	991620.0
2012-05-22 08:05:00	AAPL	Stock	20.2321	20.2857	20.2254	20.2857	468020.0
2012-05-22 08:10:00	AAPL	Stock	20.2907	20.325	20.2857	20.325	1365028.0
2012-05-22 08:15:00	AAPL	Stock	20.325	20.3464	20.2857	20.2864	1104880.0
2012-05-22 08:20:00	AAPL	Stock	20.2896	20.2961	20.2689	20.2786	430528.0
2012-05-22 08:25:00	AAPL	Stock	20.2839	20.2839	20.2507	20.2729	702856.0
2012-05-22 08:30:00	AAPL	Stock	20.2696	20.2696	20.2393	20.2411	494256.0
2012-05-22 08:35:00	AAPL	Stock	20.2393	20.25	20.225	20.2321	495880.0
2012-05-22 08:40:00	AAPL	Stock	20.2321	20.2321	20.2025	20.2171	564620.0
2012-05-22 08:45:00	AAPL	Stock	20.2186	20.2318	20.1925	20.1979	772436.0
2012-05-22 08:50:00	AAPL	Stock	20.1982	20.1982	20.1664	20.1764	729792.0
2012-05-22 08:55:00	AAPL	Stock	20.1782	20.2032	20.1529	20.1925	469504.0
2012-05-22 09:00:00	AAPL	Stock	20.1932	20.2321	20.1825	20.2182	434308.0
2012-05-22 09:05:00	AAPL	Stock	20.22	20.2321	20.2143	20.22	170660.0
2012-05-22 09:10:00	AAPL	Stock	20.225	20.2304	20.2179	20.2275	227696.0
2012-05-22 09:15:00	AAPL	Stock	20.2271	20.2664	20.2236	20.2393	257964.0
2012-05-22 09:20:00	AAPL	Stock	20.2489	20.2643	20.2379	20.2643	272020.0
2012-05-22 09:25:00	AAPL	Stock	20.2593	20.365	20.2561	20.3568	3570672.0
2012-05-22 09:30:00	AAPL	Stock	20.3525	20.4554	20.2757	20.4258	35926436.0
2012-05-22 09:35:00	AAPL	Stock	20.4264	20.4957	20.2914	20.3004	41249768.0
2012-05-22 09:40:00	AAPL	Stock	20.3007	20.4286	20.2889	20.4129	23741564.0
2012-05-22 09:45:00	AAPL	Stock	20.4129	20.4214	20.3364	20.3482	16612288.0

> showing 50 of 331,263 rows — these rows as CSV

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