PREVIEW / stock_5min / 2012-09-28

all stock 5-min files

  file:    by_date/stock_5min/2012/2012-09-28.parquet
  size:    4.7 MB
  rows:    316,480
  symbols: 3,505

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-09-28 04:05:00	AAPL	Stock	24.4104	24.4104	24.4071	24.4071	25200.0
2012-09-28 04:20:00	AAPL	Stock	24.4	24.4	24.4	24.4	2800.0
2012-09-28 04:45:00	AAPL	Stock	24.4286	24.4286	24.4286	24.4286	2800.0
2012-09-28 04:50:00	AAPL	Stock	24.4196	24.4286	24.4196	24.4286	6552.0
2012-09-28 05:00:00	AAPL	Stock	24.4411	24.4411	24.4411	24.4411	5600.0
2012-09-28 05:35:00	AAPL	Stock	24.4286	24.4286	24.4286	24.4286	22400.0
2012-09-28 05:40:00	AAPL	Stock	24.4286	24.4286	24.4286	24.4286	5600.0
2012-09-28 05:45:00	AAPL	Stock	24.425	24.425	24.4232	24.4232	5600.0
2012-09-28 05:55:00	AAPL	Stock	24.4143	24.4143	24.4107	24.4107	36400.0
2012-09-28 06:00:00	AAPL	Stock	24.4107	24.4107	24.4054	24.4054	5740.0
2012-09-28 06:05:00	AAPL	Stock	24.4036	24.4036	24.375	24.375	47320.0
2012-09-28 06:20:00	AAPL	Stock	24.375	24.375	24.3571	24.3571	17332.0
2012-09-28 06:35:00	AAPL	Stock	24.3571	24.3571	24.3236	24.3236	7028.0
2012-09-28 06:40:00	AAPL	Stock	24.3521	24.3568	24.3521	24.3568	5600.0
2012-09-28 06:55:00	AAPL	Stock	24.3521	24.3521	24.3521	24.3521	11200.0
2012-09-28 07:00:00	AAPL	Stock	24.3521	24.3521	24.2575	24.2857	118860.0
2012-09-28 07:05:00	AAPL	Stock	24.2839	24.2857	24.25	24.25	147196.0
2012-09-28 07:10:00	AAPL	Stock	24.2746	24.2768	24.2607	24.2679	74200.0
2012-09-28 07:15:00	AAPL	Stock	24.25	24.2504	24.245	24.2504	28000.0
2012-09-28 07:20:00	AAPL	Stock	24.2654	24.2679	24.2514	24.2664	24416.0
2012-09-28 07:25:00	AAPL	Stock	24.2746	24.2768	24.2729	24.2768	12460.0
2012-09-28 07:30:00	AAPL	Stock	24.2857	24.2864	24.2814	24.2814	75824.0
2012-09-28 07:35:00	AAPL	Stock	24.2771	24.2771	24.2771	24.2771	9380.0
2012-09-28 07:40:00	AAPL	Stock	24.2771	24.2807	24.2771	24.2807	8400.0
2012-09-28 07:45:00	AAPL	Stock	24.2696	24.2789	24.2689	24.2789	10640.0
2012-09-28 07:50:00	AAPL	Stock	24.2793	24.2793	24.2793	24.2793	5600.0
2012-09-28 07:55:00	AAPL	Stock	24.2743	24.2946	24.25	24.2946	38360.0
2012-09-28 08:00:00	AAPL	Stock	24.2882	24.3214	24.2786	24.2957	385420.0
2012-09-28 08:05:00	AAPL	Stock	24.3036	24.3104	24.2536	24.2568	261296.0
2012-09-28 08:10:00	AAPL	Stock	24.2536	24.3214	24.245	24.2857	459284.0
2012-09-28 08:15:00	AAPL	Stock	24.2857	24.2857	24.2696	24.2714	37800.0
2012-09-28 08:20:00	AAPL	Stock	24.2693	24.2693	24.2561	24.2561	149772.0
2012-09-28 08:25:00	AAPL	Stock	24.2529	24.2529	24.2068	24.2068	584248.0
2012-09-28 08:30:00	AAPL	Stock	24.2239	24.2368	24.175	24.1961	680204.0
2012-09-28 08:35:00	AAPL	Stock	24.1914	24.2214	24.1914	24.1982	289268.0
2012-09-28 08:40:00	AAPL	Stock	24.1986	24.2143	24.1914	24.2143	245560.0
2012-09-28 08:45:00	AAPL	Stock	24.2118	24.2189	24.2046	24.2054	75544.0
2012-09-28 08:50:00	AAPL	Stock	24.2021	24.2143	24.1989	24.2143	247324.0
2012-09-28 08:55:00	AAPL	Stock	24.2143	24.2411	24.2143	24.2382	254072.0
2012-09-28 09:00:00	AAPL	Stock	24.2425	24.2571	24.2382	24.2389	251524.0
2012-09-28 09:05:00	AAPL	Stock	24.2421	24.2493	24.2154	24.2187	368144.0
2012-09-28 09:10:00	AAPL	Stock	24.2143	24.2214	24.2075	24.2107	234612.0
2012-09-28 09:15:00	AAPL	Stock	24.2068	24.2136	24.2018	24.2068	219324.0
2012-09-28 09:20:00	AAPL	Stock	24.2136	24.2196	24.2018	24.2143	225680.0
2012-09-28 09:25:00	AAPL	Stock	24.2107	24.2418	24.2018	24.2357	482552.0
2012-09-28 09:30:00	AAPL	Stock	24.2407	24.2518	24.165	24.22	20408416.0
2012-09-28 09:35:00	AAPL	Stock	24.2146	24.3061	24.2071	24.2868	14402724.0
2012-09-28 09:40:00	AAPL	Stock	24.2889	24.3254	24.2396	24.2421	13483988.0
2012-09-28 09:45:00	AAPL	Stock	24.2421	24.2614	24.1052	24.1821	18925228.0
2012-09-28 09:50:00	AAPL	Stock	24.1789	24.1814	24.12	24.1396	10390968.0

> showing 50 of 316,480 rows — these rows as CSV

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