PREVIEW / stock_5min / 2012-07-03

all stock 5-min files

  file:    by_date/stock_5min/2012/2012-07-03.parquet
  size:    2.9 MB
  rows:    188,488
  symbols: 3,440

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-07-03 04:05:00	AAPL	Stock	21.1789	21.1789	21.1789	21.1789	8400.0
2012-07-03 04:10:00	AAPL	Stock	21.1789	21.1964	21.1789	21.1964	11200.0
2012-07-03 04:15:00	AAPL	Stock	21.1964	21.1964	21.1964	21.1964	2800.0
2012-07-03 04:20:00	AAPL	Stock	21.2071	21.2143	21.2071	21.2071	15400.0
2012-07-03 04:35:00	AAPL	Stock	21.2054	21.2054	21.2054	21.2054	2800.0
2012-07-03 04:40:00	AAPL	Stock	21.2143	21.2143	21.2143	21.2143	2800.0
2012-07-03 04:45:00	AAPL	Stock	21.2196	21.2196	21.2196	21.2196	25200.0
2012-07-03 04:50:00	AAPL	Stock	21.2379	21.2379	21.2143	21.2143	16800.0
2012-07-03 04:55:00	AAPL	Stock	21.2143	21.2143	21.2143	21.2143	11200.0
2012-07-03 05:05:00	AAPL	Stock	21.2111	21.2357	21.2111	21.2357	5600.0
2012-07-03 05:10:00	AAPL	Stock	21.2357	21.2357	21.2357	21.2357	5600.0
2012-07-03 05:35:00	AAPL	Stock	21.2071	21.2071	21.2071	21.2071	2800.0
2012-07-03 06:00:00	AAPL	Stock	21.2214	21.2214	21.2214	21.2214	5600.0
2012-07-03 06:05:00	AAPL	Stock	21.2089	21.2089	21.2089	21.2089	2800.0
2012-07-03 06:30:00	AAPL	Stock	21.2143	21.2143	21.2107	21.2107	36820.0
2012-07-03 06:35:00	AAPL	Stock	21.2089	21.2089	21.2089	21.2089	2800.0
2012-07-03 06:50:00	AAPL	Stock	21.2143	21.2143	21.2143	21.2143	2800.0
2012-07-03 07:00:00	AAPL	Stock	21.2143	21.2143	21.2143	21.2143	2800.0
2012-07-03 07:05:00	AAPL	Stock	21.2161	21.2214	21.2114	21.2114	14000.0
2012-07-03 07:10:00	AAPL	Stock	21.2193	21.2232	21.2179	21.2179	30800.0
2012-07-03 07:15:00	AAPL	Stock	21.2179	21.2179	21.2179	21.2179	2800.0
2012-07-03 07:20:00	AAPL	Stock	21.2179	21.2179	21.21	21.2118	15400.0
2012-07-03 07:25:00	AAPL	Stock	21.2061	21.2071	21.2054	21.2071	18200.0
2012-07-03 07:30:00	AAPL	Stock	21.2004	21.2036	21.1857	21.2036	48608.0
2012-07-03 07:45:00	AAPL	Stock	21.2071	21.2168	21.2071	21.2139	40124.0
2012-07-03 07:50:00	AAPL	Stock	21.2225	21.2321	21.215	21.2321	61600.0
2012-07-03 07:55:00	AAPL	Stock	21.2321	21.2486	21.2321	21.2446	209972.0
2012-07-03 08:00:00	AAPL	Stock	21.2321	21.2446	21.1857	21.2375	135464.0
2012-07-03 08:05:00	AAPL	Stock	21.2389	21.2539	21.2329	21.2329	274568.0
2012-07-03 08:10:00	AAPL	Stock	21.2332	21.2343	21.2143	21.2321	349104.0
2012-07-03 08:15:00	AAPL	Stock	21.2339	21.2457	21.2321	21.2443	112140.0
2012-07-03 08:20:00	AAPL	Stock	21.2379	21.2411	21.2329	21.2411	79100.0
2012-07-03 08:25:00	AAPL	Stock	21.2354	21.2446	21.2346	21.24	103432.0
2012-07-03 08:30:00	AAPL	Stock	21.2457	21.2536	21.2371	21.245	167944.0
2012-07-03 08:35:00	AAPL	Stock	21.2529	21.2529	21.2393	21.24	151620.0
2012-07-03 08:40:00	AAPL	Stock	21.2446	21.25	21.2446	21.25	118076.0
2012-07-03 08:45:00	AAPL	Stock	21.2468	21.2468	21.2418	21.245	111860.0
2012-07-03 08:50:00	AAPL	Stock	21.2464	21.2604	21.2457	21.26	200564.0
2012-07-03 08:55:00	AAPL	Stock	21.2568	21.2607	21.2429	21.2429	464380.0
2012-07-03 09:00:00	AAPL	Stock	21.2464	21.2496	21.2439	21.2454	134400.0
2012-07-03 09:05:00	AAPL	Stock	21.2461	21.2589	21.2461	21.255	259336.0
2012-07-03 09:10:00	AAPL	Stock	21.2546	21.2571	21.25	21.2514	245056.0
2012-07-03 09:15:00	AAPL	Stock	21.2536	21.2571	21.25	21.2525	183036.0
2012-07-03 09:20:00	AAPL	Stock	21.2568	21.2629	21.2554	21.2589	171164.0
2012-07-03 09:25:00	AAPL	Stock	21.2582	21.2582	21.2418	21.2461	390824.0
2012-07-03 09:30:00	AAPL	Stock	21.2457	21.2939	21.2143	21.2675	20004096.0
2012-07-03 09:35:00	AAPL	Stock	21.2641	21.2857	21.2332	21.2785	9959264.0
2012-07-03 09:40:00	AAPL	Stock	21.2789	21.2927	21.2554	21.2668	7843528.0
2012-07-03 09:45:00	AAPL	Stock	21.2675	21.2889	21.2614	21.2775	5216540.0
2012-07-03 09:50:00	AAPL	Stock	21.2786	21.2929	21.2557	21.2898	7220920.0

> showing 50 of 188,488 rows — these rows as CSV

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