PREVIEW / stock_5min / 2013-07-19

all stock 5-min files

  file:    by_date/stock_5min/2013/2013-07-19.parquet
  size:    4.9 MB
  rows:    330,002
  symbols: 3,476

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
2013-07-19 05:25:00	AAPL	Stock	15.3514	15.3514	15.3514	15.3514	11200.0
2013-07-19 05:50:00	AAPL	Stock	15.3568	15.3568	15.3568	15.3568	2800.0
2013-07-19 06:45:00	AAPL	Stock	15.3857	15.3857	15.3857	15.3857	2800.0
2013-07-19 06:50:00	AAPL	Stock	15.3961	15.3961	15.3961	15.3961	2800.0
2013-07-19 07:00:00	AAPL	Stock	15.3839	15.3839	15.3839	15.3839	13300.0
2013-07-19 07:05:00	AAPL	Stock	15.3929	15.3929	15.3929	15.3929	5600.0
2013-07-19 07:25:00	AAPL	Stock	15.3929	15.4004	15.3929	15.4004	11200.0
2013-07-19 08:00:00	AAPL	Stock	15.4086	15.4268	15.3839	15.4129	116284.0
2013-07-19 08:05:00	AAPL	Stock	15.4129	15.4129	15.4129	15.4129	14000.0
2013-07-19 08:10:00	AAPL	Stock	15.42	15.4282	15.42	15.4282	7000.0
2013-07-19 08:15:00	AAPL	Stock	15.4414	15.4561	15.4218	15.4218	98000.0
2013-07-19 08:20:00	AAPL	Stock	15.4264	15.45	15.4111	15.4164	95004.0
2013-07-19 08:25:00	AAPL	Stock	15.425	15.4286	15.425	15.4286	8400.0
2013-07-19 08:35:00	AAPL	Stock	15.4425	15.4464	15.44	15.44	19600.0
2013-07-19 08:40:00	AAPL	Stock	15.4464	15.4554	15.4464	15.4554	61852.0
2013-07-19 08:45:00	AAPL	Stock	15.4554	15.4732	15.4464	15.4643	120680.0
2013-07-19 08:50:00	AAPL	Stock	15.4607	15.4679	15.4607	15.4643	34048.0
2013-07-19 08:55:00	AAPL	Stock	15.4636	15.4643	15.4518	15.4643	210672.0
2013-07-19 09:00:00	AAPL	Stock	15.4536	15.4779	15.4536	15.4711	175924.0
2013-07-19 09:05:00	AAPL	Stock	15.4732	15.4746	15.4625	15.4625	114520.0
2013-07-19 09:10:00	AAPL	Stock	15.4618	15.4618	15.4464	15.4468	75600.0
2013-07-19 09:15:00	AAPL	Stock	15.4468	15.4489	15.4446	15.4464	92400.0
2013-07-19 09:20:00	AAPL	Stock	15.4464	15.4543	15.4446	15.4543	154840.0
2013-07-19 09:25:00	AAPL	Stock	15.4543	15.5218	15.4461	15.4764	1230432.0
2013-07-19 09:30:00	AAPL	Stock	15.4679	15.4993	15.4382	15.4411	30120132.0
2013-07-19 09:35:00	AAPL	Stock	15.4425	15.4436	15.4161	15.4186	4872504.0
2013-07-19 09:40:00	AAPL	Stock	15.4171	15.4211	15.2839	15.3321	11834396.0
2013-07-19 09:45:00	AAPL	Stock	15.3282	15.3561	15.3071	15.3175	4382812.0
2013-07-19 09:50:00	AAPL	Stock	15.3175	15.3329	15.3079	15.3196	3261216.0
2013-07-19 09:55:00	AAPL	Stock	15.3175	15.3543	15.3139	15.3411	3462144.0
2013-07-19 10:00:00	AAPL	Stock	15.3414	15.3414	15.2754	15.2821	8736868.0
2013-07-19 10:05:00	AAPL	Stock	15.2825	15.29	15.2589	15.2643	6261976.0
2013-07-19 10:10:00	AAPL	Stock	15.2646	15.29	15.2504	15.29	7203532.0
2013-07-19 10:15:00	AAPL	Stock	15.2875	15.2914	15.2686	15.2721	2888900.0
2013-07-19 10:20:00	AAPL	Stock	15.2739	15.2761	15.2543	15.2566	2927092.0
2013-07-19 10:25:00	AAPL	Stock	15.2546	15.2643	15.2357	15.2509	5692876.0
2013-07-19 10:30:00	AAPL	Stock	15.2454	15.2968	15.2411	15.2907	5742324.0
2013-07-19 10:35:00	AAPL	Stock	15.2921	15.3107	15.2814	15.2875	3716608.0
2013-07-19 10:40:00	AAPL	Stock	15.2875	15.2896	15.2643	15.265	2476628.0
2013-07-19 10:45:00	AAPL	Stock	15.2677	15.27	15.2236	15.2283	4318048.0
2013-07-19 10:50:00	AAPL	Stock	15.2293	15.2432	15.2232	15.2404	3009664.0
2013-07-19 10:55:00	AAPL	Stock	15.24	15.2443	15.1979	15.2168	4961208.0
2013-07-19 11:00:00	AAPL	Stock	15.2171	15.2736	15.2143	15.2361	5893440.0
2013-07-19 11:05:00	AAPL	Stock	15.2343	15.2732	15.2293	15.2639	2960692.0
2013-07-19 11:10:00	AAPL	Stock	15.27	15.2725	15.2557	15.2586	2439640.0
2013-07-19 11:15:00	AAPL	Stock	15.2593	15.2929	15.2582	15.2714	3827516.0
2013-07-19 11:20:00	AAPL	Stock	15.27	15.2857	15.2679	15.2725	1760248.0
2013-07-19 11:25:00	AAPL	Stock	15.2714	15.2718	15.2543	15.2629	2036804.0
2013-07-19 11:30:00	AAPL	Stock	15.2626	15.2632	15.2321	15.2426	3470376.0
2013-07-19 11:35:00	AAPL	Stock	15.2468	15.2582	15.2293	15.2332	2177000.0

> showing 50 of 330,002 rows — these rows as CSV

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