PREVIEW / stock_1min / 2009-05-14

all stock 1-min files

  file:    by_date/stock_1min/2009/2009-05-14.parquet
  size:    12.6 MB
  rows:    966,409
  symbols: 2,690

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-05-14 07:14:00	AAPL	Stock	4.2532	4.2532	4.2532	4.2532	2800.0
2009-05-14 07:17:00	AAPL	Stock	4.25	4.25	4.25	4.25	9800.0
2009-05-14 07:19:00	AAPL	Stock	4.25	4.25	4.25	4.25	7420.0
2009-05-14 07:20:00	AAPL	Stock	4.25	4.2532	4.25	4.2532	13580.0
2009-05-14 07:28:00	AAPL	Stock	4.2496	4.2496	4.2496	4.2496	2800.0
2009-05-14 07:31:00	AAPL	Stock	4.2496	4.2496	4.2496	4.2496	5600.0
2009-05-14 07:37:00	AAPL	Stock	4.2496	4.25	4.2496	4.25	46900.0
2009-05-14 07:49:00	AAPL	Stock	4.2746	4.2746	4.2746	4.2746	2800.0
2009-05-14 07:50:00	AAPL	Stock	4.2746	4.2746	4.2746	4.2746	2800.0
2009-05-14 07:52:00	AAPL	Stock	4.2689	4.2782	4.2689	4.2782	30800.0
2009-05-14 07:53:00	AAPL	Stock	4.2836	4.2836	4.2818	4.2818	5600.0
2009-05-14 07:55:00	AAPL	Stock	4.275	4.275	4.275	4.275	2800.0
2009-05-14 07:57:00	AAPL	Stock	4.2818	4.2836	4.2818	4.2836	22400.0
2009-05-14 07:58:00	AAPL	Stock	4.2836	4.2857	4.2836	4.2857	22400.0
2009-05-14 08:00:00	AAPL	Stock	4.2707	4.2768	4.2707	4.2768	14000.0
2009-05-14 08:01:00	AAPL	Stock	4.275	4.275	4.275	4.275	11200.0
2009-05-14 08:03:00	AAPL	Stock	4.275	4.275	4.2714	4.2714	7588.0
2009-05-14 08:05:00	AAPL	Stock	4.2714	4.2714	4.2682	4.2682	157388.0
2009-05-14 08:06:00	AAPL	Stock	4.2682	4.27	4.2679	4.27	36148.0
2009-05-14 08:07:00	AAPL	Stock	4.2696	4.2696	4.2643	4.2643	7112.0
2009-05-14 08:08:00	AAPL	Stock	4.2643	4.2643	4.2607	4.2607	16800.0
2009-05-14 08:09:00	AAPL	Stock	4.2643	4.2643	4.2625	4.2625	27720.0
2009-05-14 08:11:00	AAPL	Stock	4.2643	4.2643	4.2643	4.2643	3360.0
2009-05-14 08:12:00	AAPL	Stock	4.2607	4.2607	4.2593	4.2593	11200.0
2009-05-14 08:13:00	AAPL	Stock	4.2593	4.2604	4.2593	4.2604	26012.0
2009-05-14 08:14:00	AAPL	Stock	4.2625	4.2625	4.2625	4.2625	5600.0
2009-05-14 08:18:00	AAPL	Stock	4.2589	4.2625	4.2589	4.2625	11788.0
2009-05-14 08:19:00	AAPL	Stock	4.2604	4.2604	4.2604	4.2604	11200.0
2009-05-14 08:20:00	AAPL	Stock	4.2625	4.2625	4.2625	4.2625	2800.0
2009-05-14 08:22:00	AAPL	Stock	4.2625	4.2625	4.2625	4.2625	2800.0
2009-05-14 08:23:00	AAPL	Stock	4.2629	4.2629	4.2629	4.2629	5600.0
2009-05-14 08:24:00	AAPL	Stock	4.2629	4.2629	4.2618	4.2618	11200.0
2009-05-14 08:25:00	AAPL	Stock	4.2639	4.2643	4.2639	4.2643	22400.0
2009-05-14 08:26:00	AAPL	Stock	4.2611	4.2643	4.2611	4.2611	39312.0
2009-05-14 08:28:00	AAPL	Stock	4.2607	4.2607	4.2607	4.2607	16212.0
2009-05-14 08:30:00	AAPL	Stock	4.2636	4.2636	4.2575	4.2575	203980.0
2009-05-14 08:31:00	AAPL	Stock	4.2575	4.2575	4.2543	4.2543	116060.0
2009-05-14 08:32:00	AAPL	Stock	4.2546	4.2546	4.25	4.25	163324.0
2009-05-14 08:33:00	AAPL	Stock	4.2525	4.2604	4.2525	4.2604	203000.0
2009-05-14 08:34:00	AAPL	Stock	4.2589	4.2625	4.2589	4.2625	29400.0
2009-05-14 08:35:00	AAPL	Stock	4.2636	4.2696	4.2636	4.2689	247240.0
2009-05-14 08:36:00	AAPL	Stock	4.2679	4.2714	4.2679	4.2682	109200.0
2009-05-14 08:37:00	AAPL	Stock	4.2686	4.2686	4.2686	4.2686	8400.0
2009-05-14 08:38:00	AAPL	Stock	4.2689	4.2689	4.2679	4.2679	14000.0
2009-05-14 08:39:00	AAPL	Stock	4.2686	4.2686	4.2679	4.2679	22904.0
2009-05-14 08:40:00	AAPL	Stock	4.2679	4.2721	4.2679	4.2721	14000.0
2009-05-14 08:42:00	AAPL	Stock	4.2686	4.2686	4.2686	4.2686	2800.0
2009-05-14 08:43:00	AAPL	Stock	4.2686	4.2707	4.2679	4.2707	27300.0
2009-05-14 08:44:00	AAPL	Stock	4.2729	4.2732	4.2729	4.2732	16800.0
2009-05-14 08:45:00	AAPL	Stock	4.27	4.27	4.27	4.27	5600.0

> showing 50 of 966,409 rows — these rows as CSV

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