PREVIEW / stock_5min / 2013-07-31

all stock 5-min files

  file:    by_date/stock_5min/2013/2013-07-31.parquet
  size:    5.2 MB
  rows:    343,593
  symbols: 3,515

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-31 04:00:00	AAPL	Stock	16.2096	16.2121	16.2096	16.2121	5600.0
2013-07-31 05:00:00	AAPL	Stock	16.2404	16.2454	16.2404	16.2454	12320.0
2013-07-31 05:20:00	AAPL	Stock	16.2518	16.2518	16.2518	16.2518	11200.0
2013-07-31 06:20:00	AAPL	Stock	16.2571	16.2571	16.2571	16.2571	30800.0
2013-07-31 07:00:00	AAPL	Stock	16.25	16.25	16.2286	16.2479	16800.0
2013-07-31 07:05:00	AAPL	Stock	16.25	16.25	16.25	16.25	15792.0
2013-07-31 07:10:00	AAPL	Stock	16.2589	16.2589	16.2589	16.2589	4760.0
2013-07-31 07:20:00	AAPL	Stock	16.2618	16.2882	16.2618	16.2882	14000.0
2013-07-31 07:25:00	AAPL	Stock	16.295	16.3036	16.2854	16.2857	193200.0
2013-07-31 07:30:00	AAPL	Stock	16.2857	16.2857	16.275	16.2796	28000.0
2013-07-31 07:35:00	AAPL	Stock	16.275	16.275	16.2729	16.2729	9800.0
2013-07-31 07:40:00	AAPL	Stock	16.2679	16.2679	16.2679	16.2679	5600.0
2013-07-31 07:45:00	AAPL	Stock	16.2721	16.2729	16.2721	16.2729	9800.0
2013-07-31 07:50:00	AAPL	Stock	16.2686	16.2686	16.2686	16.2686	2800.0
2013-07-31 07:55:00	AAPL	Stock	16.2757	16.2764	16.2757	16.2764	14000.0
2013-07-31 08:00:00	AAPL	Stock	16.2754	16.2796	16.1071	16.1071	258944.0
2013-07-31 08:05:00	AAPL	Stock	16.2679	16.2786	16.2607	16.2679	145964.0
2013-07-31 08:10:00	AAPL	Stock	16.2768	16.2821	16.2768	16.2768	40600.0
2013-07-31 08:15:00	AAPL	Stock	16.2786	16.2786	16.2636	16.2729	324856.0
2013-07-31 08:20:00	AAPL	Stock	16.2704	16.2754	16.2464	16.25	178248.0
2013-07-31 08:25:00	AAPL	Stock	16.2482	16.2536	16.2361	16.2493	185584.0
2013-07-31 08:30:00	AAPL	Stock	16.2432	16.25	16.1979	16.2411	330456.0
2013-07-31 08:35:00	AAPL	Stock	16.2411	16.2446	16.23	16.2446	82796.0
2013-07-31 08:40:00	AAPL	Stock	16.2411	16.2464	16.2411	16.2464	25200.0
2013-07-31 08:45:00	AAPL	Stock	16.2504	16.2589	16.2504	16.2554	65072.0
2013-07-31 08:50:00	AAPL	Stock	16.2546	16.2554	16.245	16.2518	93156.0
2013-07-31 08:55:00	AAPL	Stock	16.25	16.2525	16.2479	16.2496	198996.0
2013-07-31 09:00:00	AAPL	Stock	16.2496	16.2536	16.2446	16.2446	40600.0
2013-07-31 09:05:00	AAPL	Stock	16.2496	16.2496	16.2464	16.2464	33600.0
2013-07-31 09:10:00	AAPL	Stock	16.25	16.2546	16.25	16.2546	49980.0
2013-07-31 09:15:00	AAPL	Stock	16.2546	16.2546	16.2343	16.2343	129668.0
2013-07-31 09:20:00	AAPL	Stock	16.2382	16.2429	16.2286	16.2293	193760.0
2013-07-31 09:25:00	AAPL	Stock	16.2296	16.2546	16.2143	16.2514	208600.0
2013-07-31 09:30:00	AAPL	Stock	16.25	16.3204	16.2261	16.3136	13385512.0
2013-07-31 09:35:00	AAPL	Stock	16.3107	16.3336	16.2964	16.3082	8769376.0
2013-07-31 09:40:00	AAPL	Stock	16.3071	16.3246	16.3041	16.3068	3435684.0
2013-07-31 09:45:00	AAPL	Stock	16.3061	16.3132	16.2836	16.3	4826752.0
2013-07-31 09:50:00	AAPL	Stock	16.305	16.3139	16.29	16.2929	4090660.0
2013-07-31 09:55:00	AAPL	Stock	16.2929	16.305	16.2757	16.2941	5097876.0
2013-07-31 10:00:00	AAPL	Stock	16.2946	16.2986	16.2539	16.2582	6311396.0
2013-07-31 10:05:00	AAPL	Stock	16.2592	16.2592	16.1871	16.1982	10291344.0
2013-07-31 10:10:00	AAPL	Stock	16.1964	16.1993	16.1568	16.1868	9798264.0
2013-07-31 10:15:00	AAPL	Stock	16.1846	16.2	16.1671	16.1754	5075196.0
2013-07-31 10:20:00	AAPL	Stock	16.1736	16.175	16.1143	16.1239	8615488.0
2013-07-31 10:25:00	AAPL	Stock	16.1204	16.1551	16.1204	16.1379	6192004.0
2013-07-31 10:30:00	AAPL	Stock	16.14	16.1429	16.0786	16.0921	9300984.0
2013-07-31 10:35:00	AAPL	Stock	16.0921	16.1021	16.0511	16.0632	7959280.0
2013-07-31 10:40:00	AAPL	Stock	16.0632	16.0889	16.0532	16.0875	5161408.0
2013-07-31 10:45:00	AAPL	Stock	16.0893	16.1239	16.0843	16.1179	4935756.0
2013-07-31 10:50:00	AAPL	Stock	16.1165	16.1171	16.0814	16.0996	3397688.0

> showing 50 of 343,593 rows — these rows as CSV

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