PREVIEW / stock_1min / 2009-04-21

all stock 1-min files

  file:    by_date/stock_1min/2009/2009-04-21.parquet
  size:    12.7 MB
  rows:    958,253
  symbols: 2,689

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
2009-04-21 07:56:00	AAPL	Stock	4.3036	4.3036	4.3036	4.3036	2800.0
2009-04-21 08:00:00	AAPL	Stock	4.3025	4.3061	4.3025	4.3061	21000.0
2009-04-21 08:02:00	AAPL	Stock	4.3043	4.3043	4.2896	4.2896	8400.0
2009-04-21 08:03:00	AAPL	Stock	4.2929	4.2929	4.2918	4.2918	8400.0
2009-04-21 08:05:00	AAPL	Stock	4.2943	4.3018	4.2914	4.3018	19600.0
2009-04-21 08:08:00	AAPL	Stock	4.2914	4.2914	4.2875	4.2875	18200.0
2009-04-21 08:10:00	AAPL	Stock	4.2875	4.2875	4.2875	4.2875	9800.0
2009-04-21 08:11:00	AAPL	Stock	4.2875	4.2886	4.2875	4.2886	28980.0
2009-04-21 08:12:00	AAPL	Stock	4.2886	4.2886	4.2879	4.2879	11200.0
2009-04-21 08:13:00	AAPL	Stock	4.2804	4.2804	4.2804	4.2804	9380.0
2009-04-21 08:14:00	AAPL	Stock	4.2804	4.2804	4.2804	4.2804	6440.0
2009-04-21 08:15:00	AAPL	Stock	4.2804	4.2804	4.2804	4.2804	4648.0
2009-04-21 08:19:00	AAPL	Stock	4.2804	4.2804	4.2804	4.2804	27048.0
2009-04-21 08:20:00	AAPL	Stock	4.2857	4.2857	4.2857	4.2857	3640.0
2009-04-21 08:21:00	AAPL	Stock	4.2786	4.2786	4.2786	4.2786	2800.0
2009-04-21 08:23:00	AAPL	Stock	4.2796	4.2796	4.2786	4.2786	27804.0
2009-04-21 08:31:00	AAPL	Stock	4.28	4.28	4.2786	4.2786	5600.0
2009-04-21 08:32:00	AAPL	Stock	4.2821	4.2821	4.2821	4.2821	5600.0
2009-04-21 08:33:00	AAPL	Stock	4.2821	4.2821	4.2821	4.2821	5600.0
2009-04-21 08:35:00	AAPL	Stock	4.2807	4.2807	4.275	4.275	139244.0
2009-04-21 08:36:00	AAPL	Stock	4.275	4.275	4.275	4.275	49000.0
2009-04-21 08:37:00	AAPL	Stock	4.275	4.275	4.2682	4.2682	28280.0
2009-04-21 08:38:00	AAPL	Stock	4.2714	4.2714	4.2714	4.2714	18200.0
2009-04-21 08:39:00	AAPL	Stock	4.2714	4.2714	4.2679	4.2679	32200.0
2009-04-21 08:40:00	AAPL	Stock	4.2696	4.2696	4.2696	4.2696	14000.0
2009-04-21 08:41:00	AAPL	Stock	4.2714	4.2714	4.2714	4.2714	9100.0
2009-04-21 08:42:00	AAPL	Stock	4.2714	4.2725	4.2714	4.2714	65436.0
2009-04-21 08:44:00	AAPL	Stock	4.2696	4.2696	4.2696	4.2696	10360.0
2009-04-21 08:45:00	AAPL	Stock	4.2686	4.2686	4.2682	4.2682	18900.0
2009-04-21 08:46:00	AAPL	Stock	4.2682	4.2682	4.2682	4.2682	7700.0
2009-04-21 08:47:00	AAPL	Stock	4.2679	4.2679	4.2679	4.2679	29848.0
2009-04-21 08:49:00	AAPL	Stock	4.2675	4.2679	4.2675	4.2679	41048.0
2009-04-21 08:50:00	AAPL	Stock	4.2675	4.2675	4.2675	4.2675	2800.0
2009-04-21 08:52:00	AAPL	Stock	4.265	4.265	4.2625	4.2625	44856.0
2009-04-21 08:53:00	AAPL	Stock	4.2639	4.2639	4.2625	4.2625	5600.0
2009-04-21 08:54:00	AAPL	Stock	4.2625	4.2625	4.2618	4.2618	16800.0
2009-04-21 08:55:00	AAPL	Stock	4.2614	4.2614	4.2604	4.2607	53200.0
2009-04-21 08:56:00	AAPL	Stock	4.2639	4.2643	4.2589	4.2607	16800.0
2009-04-21 08:57:00	AAPL	Stock	4.2621	4.2621	4.2607	4.2607	14000.0
2009-04-21 08:59:00	AAPL	Stock	4.2607	4.2607	4.2607	4.2607	2800.0
2009-04-21 09:00:00	AAPL	Stock	4.2618	4.2618	4.2611	4.2618	36400.0
2009-04-21 09:01:00	AAPL	Stock	4.2629	4.2629	4.2629	4.2629	5600.0
2009-04-21 09:03:00	AAPL	Stock	4.2629	4.2629	4.2607	4.2607	81200.0
2009-04-21 09:04:00	AAPL	Stock	4.2596	4.2596	4.2589	4.2589	8400.0
2009-04-21 09:05:00	AAPL	Stock	4.2579	4.2607	4.2571	4.2607	126168.0
2009-04-21 09:06:00	AAPL	Stock	4.2575	4.2575	4.2571	4.2571	5600.0
2009-04-21 09:07:00	AAPL	Stock	4.2571	4.2571	4.2546	4.2546	49840.0
2009-04-21 09:08:00	AAPL	Stock	4.2564	4.2564	4.2543	4.2543	58800.0
2009-04-21 09:09:00	AAPL	Stock	4.2543	4.2543	4.2539	4.2539	11200.0
2009-04-21 09:10:00	AAPL	Stock	4.2518	4.2518	4.2511	4.2511	51156.0

> showing 50 of 958,253 rows — these rows as CSV

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