PREVIEW / stock_1min / 2009-04-14

all stock 1-min files

  file:    by_date/stock_1min/2009/2009-04-14.parquet
  size:    12.6 MB
  rows:    962,672
  symbols: 2,699

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-14 04:13:00	AAPL	Stock	4.2696	4.2696	4.2696	4.2696	14000.0
2009-04-14 05:55:00	AAPL	Stock	4.3011	4.3011	4.3011	4.3011	2800.0
2009-04-14 06:23:00	AAPL	Stock	4.3129	4.3129	4.3129	4.3129	2800.0
2009-04-14 06:31:00	AAPL	Stock	4.2896	4.2896	4.2896	4.2896	2800.0
2009-04-14 07:26:00	AAPL	Stock	4.2936	4.2936	4.2929	4.2929	11200.0
2009-04-14 07:46:00	AAPL	Stock	4.2857	4.2857	4.2857	4.2857	8400.0
2009-04-14 08:00:00	AAPL	Stock	4.2929	4.2929	4.2857	4.2857	47320.0
2009-04-14 08:03:00	AAPL	Stock	4.2918	4.2918	4.2918	4.2918	2800.0
2009-04-14 08:07:00	AAPL	Stock	4.2961	4.2961	4.2957	4.2957	18760.0
2009-04-14 08:08:00	AAPL	Stock	4.2961	4.2964	4.2961	4.2964	16100.0
2009-04-14 08:09:00	AAPL	Stock	4.2961	4.2961	4.2961	4.2961	7840.0
2009-04-14 08:10:00	AAPL	Stock	4.3025	4.3025	4.3025	4.3025	9100.0
2009-04-14 08:12:00	AAPL	Stock	4.305	4.3054	4.305	4.3054	8400.0
2009-04-14 08:14:00	AAPL	Stock	4.3029	4.3029	4.3025	4.3025	16100.0
2009-04-14 08:15:00	AAPL	Stock	4.3011	4.3054	4.3011	4.3054	92456.0
2009-04-14 08:17:00	AAPL	Stock	4.3071	4.3071	4.3064	4.3064	18480.0
2009-04-14 08:19:00	AAPL	Stock	4.3143	4.3143	4.3143	4.3143	4620.0
2009-04-14 08:20:00	AAPL	Stock	4.3107	4.3143	4.3107	4.3143	40264.0
2009-04-14 08:21:00	AAPL	Stock	4.3143	4.3143	4.3143	4.3143	48272.0
2009-04-14 08:22:00	AAPL	Stock	4.3132	4.3132	4.3132	4.3132	11200.0
2009-04-14 08:23:00	AAPL	Stock	4.3129	4.3129	4.3032	4.3071	164080.0
2009-04-14 08:24:00	AAPL	Stock	4.3089	4.3089	4.3071	4.3071	16800.0
2009-04-14 08:27:00	AAPL	Stock	4.3071	4.3071	4.3071	4.3071	19600.0
2009-04-14 08:29:00	AAPL	Stock	4.3107	4.3107	4.3107	4.3107	13356.0
2009-04-14 08:30:00	AAPL	Stock	4.3061	4.3061	4.3018	4.3018	96320.0
2009-04-14 08:31:00	AAPL	Stock	4.2986	4.2986	4.2964	4.2964	45500.0
2009-04-14 08:32:00	AAPL	Stock	4.2946	4.2946	4.2946	4.2946	7840.0
2009-04-14 08:33:00	AAPL	Stock	4.2961	4.2961	4.2961	4.2961	6944.0
2009-04-14 08:34:00	AAPL	Stock	4.2946	4.2946	4.2861	4.2861	59556.0
2009-04-14 08:35:00	AAPL	Stock	4.2875	4.2875	4.28	4.28	30800.0
2009-04-14 08:36:00	AAPL	Stock	4.28	4.2804	4.28	4.28	14000.0
2009-04-14 08:37:00	AAPL	Stock	4.28	4.2804	4.28	4.2804	8400.0
2009-04-14 08:39:00	AAPL	Stock	4.2821	4.2821	4.28	4.28	47320.0
2009-04-14 08:40:00	AAPL	Stock	4.2804	4.2821	4.2804	4.2807	28280.0
2009-04-14 08:42:00	AAPL	Stock	4.2821	4.2821	4.2821	4.2821	8400.0
2009-04-14 08:43:00	AAPL	Stock	4.2821	4.2821	4.2804	4.2804	10052.0
2009-04-14 08:44:00	AAPL	Stock	4.2804	4.2804	4.2768	4.2768	59080.0
2009-04-14 08:45:00	AAPL	Stock	4.27	4.27	4.2696	4.2696	14000.0
2009-04-14 08:50:00	AAPL	Stock	4.2711	4.2711	4.2704	4.2704	72156.0
2009-04-14 08:51:00	AAPL	Stock	4.2704	4.2704	4.2682	4.2696	91532.0
2009-04-14 08:52:00	AAPL	Stock	4.2679	4.2679	4.2668	4.2668	9380.0
2009-04-14 08:54:00	AAPL	Stock	4.2614	4.2614	4.2614	4.2614	19600.0
2009-04-14 08:55:00	AAPL	Stock	4.2614	4.2704	4.2593	4.2614	44800.0
2009-04-14 08:56:00	AAPL	Stock	4.2614	4.2614	4.2614	4.2614	14000.0
2009-04-14 08:57:00	AAPL	Stock	4.2679	4.2679	4.2661	4.2661	22400.0
2009-04-14 08:58:00	AAPL	Stock	4.2661	4.2661	4.2661	4.2661	2800.0
2009-04-14 08:59:00	AAPL	Stock	4.2657	4.2661	4.2657	4.2661	7000.0
2009-04-14 09:00:00	AAPL	Stock	4.2657	4.2661	4.2607	4.2607	42000.0
2009-04-14 09:01:00	AAPL	Stock	4.2657	4.2679	4.2657	4.2679	17080.0
2009-04-14 09:02:00	AAPL	Stock	4.2664	4.2664	4.2661	4.2661	5600.0

> showing 50 of 962,672 rows — these rows as CSV

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