PREVIEW / stock_5min / 2011-10-20

all stock 5-min files

  file:    by_date/stock_5min/2011/2011-10-20.parquet
  size:    4.7 MB
  rows:    314,605
  symbols: 3,479

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-20 04:15:00	AAPL	Stock	14.2586	14.2586	14.25	14.25	14000.0
2011-10-20 04:20:00	AAPL	Stock	14.2679	14.2679	14.2679	14.2679	5600.0
2011-10-20 04:30:00	AAPL	Stock	14.3093	14.3093	14.3093	14.3093	2800.0
2011-10-20 04:35:00	AAPL	Stock	14.3193	14.3307	14.3193	14.3307	33600.0
2011-10-20 05:30:00	AAPL	Stock	14.3561	14.3561	14.3561	14.3561	72800.0
2011-10-20 05:35:00	AAPL	Stock	14.3561	14.3561	14.3457	14.3457	28000.0
2011-10-20 05:40:00	AAPL	Stock	14.3457	14.3457	14.3457	14.3457	2800.0
2011-10-20 05:45:00	AAPL	Stock	14.3432	14.3482	14.3246	14.3246	8400.0
2011-10-20 05:50:00	AAPL	Stock	14.3521	14.3521	14.3214	14.3214	11200.0
2011-10-20 05:55:00	AAPL	Stock	14.3214	14.3214	14.3143	14.3143	16800.0
2011-10-20 06:00:00	AAPL	Stock	14.3214	14.3214	14.3214	14.3214	8400.0
2011-10-20 06:05:00	AAPL	Stock	14.3214	14.3214	14.3143	14.3179	14000.0
2011-10-20 06:55:00	AAPL	Stock	14.3107	14.3118	14.3107	14.3118	14000.0
2011-10-20 07:00:00	AAPL	Stock	14.3036	14.3036	14.3036	14.3036	2800.0
2011-10-20 07:05:00	AAPL	Stock	14.2857	14.2857	14.2821	14.2821	17080.0
2011-10-20 07:10:00	AAPL	Stock	14.2746	14.2993	14.2746	14.2857	21028.0
2011-10-20 07:15:00	AAPL	Stock	14.2679	14.2964	14.2679	14.285	35196.0
2011-10-20 07:20:00	AAPL	Stock	14.2589	14.2682	14.2579	14.2682	11200.0
2011-10-20 07:30:00	AAPL	Stock	14.2857	14.3107	14.2857	14.3107	22400.0
2011-10-20 07:35:00	AAPL	Stock	14.3039	14.3179	14.3029	14.3029	39200.0
2011-10-20 07:40:00	AAPL	Stock	14.2929	14.2993	14.2929	14.2993	8400.0
2011-10-20 07:45:00	AAPL	Stock	14.2964	14.3036	14.29	14.3036	22400.0
2011-10-20 07:50:00	AAPL	Stock	14.3029	14.3029	14.2982	14.2982	8400.0
2011-10-20 07:55:00	AAPL	Stock	14.2911	14.2911	14.2693	14.2693	80192.0
2011-10-20 08:00:00	AAPL	Stock	14.2846	14.2982	14.2679	14.2964	366464.0
2011-10-20 08:05:00	AAPL	Stock	14.3014	14.3036	14.2893	14.2929	182000.0
2011-10-20 08:10:00	AAPL	Stock	14.2946	14.2954	14.2786	14.2836	168784.0
2011-10-20 08:15:00	AAPL	Stock	14.2839	14.3036	14.2839	14.2946	301308.0
2011-10-20 08:20:00	AAPL	Stock	14.295	14.295	14.2839	14.2857	182112.0
2011-10-20 08:25:00	AAPL	Stock	14.2857	14.2857	14.25	14.2675	97132.0
2011-10-20 08:30:00	AAPL	Stock	14.2675	14.2679	14.2271	14.25	397964.0
2011-10-20 08:35:00	AAPL	Stock	14.25	14.2714	14.2429	14.2679	196056.0
2011-10-20 08:40:00	AAPL	Stock	14.2554	14.2936	14.2554	14.28	197512.0
2011-10-20 08:45:00	AAPL	Stock	14.2857	14.2946	14.2786	14.2857	235900.0
2011-10-20 08:50:00	AAPL	Stock	14.2857	14.2996	14.2857	14.2936	151088.0
2011-10-20 08:55:00	AAPL	Stock	14.2896	14.295	14.2839	14.2839	255192.0
2011-10-20 09:00:00	AAPL	Stock	14.2857	14.2921	14.2821	14.2821	198940.0
2011-10-20 09:05:00	AAPL	Stock	14.2804	14.2804	14.2464	14.2561	407876.0
2011-10-20 09:10:00	AAPL	Stock	14.2618	14.2618	14.2411	14.2607	433664.0
2011-10-20 09:15:00	AAPL	Stock	14.25	14.255	14.2396	14.2432	307972.0
2011-10-20 09:20:00	AAPL	Stock	14.2475	14.2557	14.2418	14.2439	259000.0
2011-10-20 09:25:00	AAPL	Stock	14.2439	14.2857	14.2439	14.2857	614236.0
2011-10-20 09:30:00	AAPL	Stock	14.2857	14.2982	14.2196	14.2275	18228168.0
2011-10-20 09:35:00	AAPL	Stock	14.2264	14.2269	14.1321	14.1604	27244000.0
2011-10-20 09:40:00	AAPL	Stock	14.1586	14.17	14.1111	14.1696	18873344.0
2011-10-20 09:45:00	AAPL	Stock	14.1718	14.2489	14.1607	14.2143	16072728.0
2011-10-20 09:50:00	AAPL	Stock	14.2125	14.2186	14.1679	14.1771	9877140.0
2011-10-20 09:55:00	AAPL	Stock	14.1761	14.2089	14.1657	14.1889	6487684.0
2011-10-20 10:00:00	AAPL	Stock	14.1893	14.2529	14.1818	14.1845	13026160.0
2011-10-20 10:05:00	AAPL	Stock	14.1875	14.2271	14.1565	14.1996	10836868.0

> showing 50 of 314,605 rows — these rows as CSV

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