PREVIEW / stock_5min / 2010-08-02

all stock 5-min files

  file:    by_date/stock_5min/2010/2010-08-02.parquet
  size:    4.8 MB
  rows:    329,847
  symbols: 3,500

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
2010-08-02 04:00:00	AAPL	Stock	9.2339	9.2504	9.2339	9.2504	8400.0
2010-08-02 04:20:00	AAPL	Stock	9.2643	9.2643	9.2643	9.2643	2800.0
2010-08-02 06:05:00	AAPL	Stock	9.2764	9.2764	9.2764	9.2764	2884.0
2010-08-02 06:55:00	AAPL	Stock	9.2611	9.2611	9.2611	9.2611	2800.0
2010-08-02 07:00:00	AAPL	Stock	9.2607	9.2607	9.25	9.2607	15456.0
2010-08-02 07:15:00	AAPL	Stock	9.2571	9.2593	9.2525	9.2525	81200.0
2010-08-02 07:20:00	AAPL	Stock	9.255	9.255	9.2393	9.2393	43176.0
2010-08-02 07:25:00	AAPL	Stock	9.2457	9.2464	9.2457	9.2464	8400.0
2010-08-02 07:30:00	AAPL	Stock	9.2496	9.2532	9.2496	9.2532	5600.0
2010-08-02 07:35:00	AAPL	Stock	9.2536	9.2536	9.2418	9.2418	33096.0
2010-08-02 07:45:00	AAPL	Stock	9.25	9.25	9.2432	9.2432	16800.0
2010-08-02 07:50:00	AAPL	Stock	9.2496	9.2496	9.2432	9.2432	28000.0
2010-08-02 07:55:00	AAPL	Stock	9.2446	9.2525	9.2446	9.2525	81200.0
2010-08-02 08:00:00	AAPL	Stock	9.2521	9.2729	9.2464	9.2646	582512.0
2010-08-02 08:05:00	AAPL	Stock	9.2636	9.2668	9.2554	9.2561	120904.0
2010-08-02 08:10:00	AAPL	Stock	9.2589	9.2643	9.2579	9.2625	243264.0
2010-08-02 08:15:00	AAPL	Stock	9.2636	9.265	9.2593	9.2643	114996.0
2010-08-02 08:20:00	AAPL	Stock	9.2643	9.2643	9.2639	9.2639	85400.0
2010-08-02 08:25:00	AAPL	Stock	9.2604	9.2707	9.2579	9.2679	182504.0
2010-08-02 08:30:00	AAPL	Stock	9.2679	9.2679	9.2589	9.2625	252336.0
2010-08-02 08:35:00	AAPL	Stock	9.2611	9.2632	9.2589	9.2607	58884.0
2010-08-02 08:40:00	AAPL	Stock	9.2632	9.2643	9.2589	9.26	126532.0
2010-08-02 08:45:00	AAPL	Stock	9.2589	9.26	9.2564	9.2582	70644.0
2010-08-02 08:50:00	AAPL	Stock	9.2582	9.265	9.1875	9.1875	147840.0
2010-08-02 08:55:00	AAPL	Stock	9.2639	9.2714	9.2639	9.2668	103600.0
2010-08-02 09:00:00	AAPL	Stock	9.2711	9.2782	9.2686	9.2743	175252.0
2010-08-02 09:05:00	AAPL	Stock	9.275	9.2911	9.2718	9.2843	884632.0
2010-08-02 09:10:00	AAPL	Stock	9.2814	9.2875	9.275	9.2832	466144.0
2010-08-02 09:15:00	AAPL	Stock	9.2839	9.2911	9.2829	9.2904	382200.0
2010-08-02 09:20:00	AAPL	Stock	9.2904	9.3	9.2896	9.2946	565404.0
2010-08-02 09:25:00	AAPL	Stock	9.2925	9.2979	9.2879	9.2971	330932.0
2010-08-02 09:30:00	AAPL	Stock	9.2993	9.3339	9.275	9.2854	21131320.0
2010-08-02 09:35:00	AAPL	Stock	9.2868	9.3004	9.285	9.2884	9305156.0
2010-08-02 09:40:00	AAPL	Stock	9.2882	9.3021	9.2775	9.2954	9122484.0
2010-08-02 09:45:00	AAPL	Stock	9.2934	9.2996	9.2721	9.2957	8496712.0
2010-08-02 09:50:00	AAPL	Stock	9.2954	9.2979	9.2775	9.2914	6206928.0
2010-08-02 09:55:00	AAPL	Stock	9.2904	9.2964	9.2793	9.2854	5380284.0
2010-08-02 10:00:00	AAPL	Stock	9.2854	9.3529	9.2839	9.3471	25588892.0
2010-08-02 10:05:00	AAPL	Stock	9.3479	9.3546	9.3282	9.3339	11836776.0
2010-08-02 10:10:00	AAPL	Stock	9.335	9.3554	9.3293	9.355	8433208.0
2010-08-02 10:15:00	AAPL	Stock	9.3536	9.3736	9.35	9.3593	12301884.0
2010-08-02 10:20:00	AAPL	Stock	9.3589	9.3689	9.3511	9.3532	6814332.0
2010-08-02 10:25:00	AAPL	Stock	9.3536	9.3661	9.3529	9.3593	5594288.0
2010-08-02 10:30:00	AAPL	Stock	9.3614	9.3639	9.3509	9.3579	5489372.0
2010-08-02 10:35:00	AAPL	Stock	9.3585	9.3668	9.35	9.3504	8169140.0
2010-08-02 10:40:00	AAPL	Stock	9.3521	9.3561	9.3429	9.3554	8937572.0
2010-08-02 10:45:00	AAPL	Stock	9.3554	9.3643	9.35	9.3571	5700408.0
2010-08-02 10:50:00	AAPL	Stock	9.3575	9.3782	9.3571	9.3734	10694152.0
2010-08-02 10:55:00	AAPL	Stock	9.3739	9.375	9.3682	9.3703	5421892.0
2010-08-02 11:00:00	AAPL	Stock	9.3721	9.3764	9.3625	9.3761	4780944.0

> showing 50 of 329,847 rows — these rows as CSV

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