PREVIEW / stock_1min / 2009-04-24

all stock 1-min files

  file:    by_date/stock_1min/2009/2009-04-24.parquet
  size:    12.5 MB
  rows:    952,346
  symbols: 2,712

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-24 07:02:00	AAPL	Stock	4.47	4.47	4.47	4.47	2800.0
2009-04-24 07:07:00	AAPL	Stock	4.4964	4.4964	4.4964	4.4964	2800.0
2009-04-24 07:08:00	AAPL	Stock	4.4964	4.5	4.4964	4.5	16800.0
2009-04-24 07:11:00	AAPL	Stock	4.5036	4.5036	4.5036	4.5036	5600.0
2009-04-24 07:16:00	AAPL	Stock	4.5036	4.5036	4.5	4.5036	18536.0
2009-04-24 07:17:00	AAPL	Stock	4.5036	4.5036	4.5036	4.5036	2800.0
2009-04-24 07:20:00	AAPL	Stock	4.5004	4.5004	4.5004	4.5004	2800.0
2009-04-24 07:30:00	AAPL	Stock	4.5007	4.5007	4.5	4.5	11200.0
2009-04-24 07:33:00	AAPL	Stock	4.5	4.5	4.5	4.5	5600.0
2009-04-24 07:34:00	AAPL	Stock	4.5	4.5	4.5	4.5	5600.0
2009-04-24 07:45:00	AAPL	Stock	4.5107	4.5107	4.5107	4.5107	5600.0
2009-04-24 07:46:00	AAPL	Stock	4.5	4.5	4.5	4.5	2800.0
2009-04-24 08:00:00	AAPL	Stock	4.5	4.5068	4.4821	4.4821	55580.0
2009-04-24 08:01:00	AAPL	Stock	4.4714	4.4714	4.4679	4.4711	28000.0
2009-04-24 08:02:00	AAPL	Stock	4.475	4.475	4.475	4.475	2800.0
2009-04-24 08:03:00	AAPL	Stock	4.5	4.5	4.5	4.5	4228.0
2009-04-24 08:04:00	AAPL	Stock	4.4782	4.4782	4.4782	4.4782	2800.0
2009-04-24 08:05:00	AAPL	Stock	4.4821	4.4821	4.4821	4.4821	26880.0
2009-04-24 08:06:00	AAPL	Stock	4.4868	4.4875	4.4868	4.4875	28000.0
2009-04-24 08:07:00	AAPL	Stock	4.4871	4.4871	4.4871	4.4871	2800.0
2009-04-24 08:08:00	AAPL	Stock	4.4821	4.4821	4.4821	4.4821	2800.0
2009-04-24 08:09:00	AAPL	Stock	4.4821	4.4821	4.4821	4.4821	15820.0
2009-04-24 08:10:00	AAPL	Stock	4.4821	4.4857	4.4821	4.4821	44716.0
2009-04-24 08:12:00	AAPL	Stock	4.4804	4.4804	4.4786	4.4786	38220.0
2009-04-24 08:13:00	AAPL	Stock	4.4789	4.4789	4.4786	4.4786	19600.0
2009-04-24 08:14:00	AAPL	Stock	4.4814	4.4821	4.4786	4.4821	43120.0
2009-04-24 08:15:00	AAPL	Stock	4.4821	4.4871	4.4821	4.4871	36624.0
2009-04-24 08:16:00	AAPL	Stock	4.49	4.49	4.49	4.49	2800.0
2009-04-24 08:17:00	AAPL	Stock	4.4893	4.4911	4.4893	4.4911	23576.0
2009-04-24 08:21:00	AAPL	Stock	4.4829	4.4829	4.4829	4.4829	4200.0
2009-04-24 08:22:00	AAPL	Stock	4.4821	4.4861	4.4821	4.4861	27440.0
2009-04-24 08:30:00	AAPL	Stock	4.4893	4.4893	4.4893	4.4893	14000.0
2009-04-24 08:31:00	AAPL	Stock	4.4893	4.4893	4.4893	4.4893	28000.0
2009-04-24 08:32:00	AAPL	Stock	4.4896	4.4896	4.4786	4.4786	36120.0
2009-04-24 08:33:00	AAPL	Stock	4.4768	4.4857	4.4768	4.4857	14000.0
2009-04-24 08:35:00	AAPL	Stock	4.4786	4.4857	4.4786	4.4821	38780.0
2009-04-24 08:36:00	AAPL	Stock	4.4829	4.4829	4.4829	4.4829	2800.0
2009-04-24 08:38:00	AAPL	Stock	4.4821	4.4839	4.4821	4.4839	65324.0
2009-04-24 08:39:00	AAPL	Stock	4.4829	4.4829	4.4829	4.4829	14000.0
2009-04-24 08:40:00	AAPL	Stock	4.4839	4.4839	4.4829	4.4829	14000.0
2009-04-24 08:41:00	AAPL	Stock	4.4786	4.4789	4.4786	4.4786	28000.0
2009-04-24 08:42:00	AAPL	Stock	4.4854	4.4854	4.4854	4.4854	22400.0
2009-04-24 08:43:00	AAPL	Stock	4.4818	4.4821	4.4818	4.4821	26880.0
2009-04-24 08:44:00	AAPL	Stock	4.4821	4.4839	4.4821	4.4821	53620.0
2009-04-24 08:45:00	AAPL	Stock	4.4786	4.4786	4.4786	4.4786	16800.0
2009-04-24 08:46:00	AAPL	Stock	4.4821	4.4821	4.4821	4.4821	3024.0
2009-04-24 08:47:00	AAPL	Stock	4.4793	4.4793	4.4793	4.4793	2800.0
2009-04-24 08:48:00	AAPL	Stock	4.4818	4.4839	4.4814	4.4839	20496.0
2009-04-24 08:49:00	AAPL	Stock	4.4857	4.4857	4.4857	4.4857	2800.0
2009-04-24 08:53:00	AAPL	Stock	4.4875	4.4875	4.4875	4.4875	19600.0

> showing 50 of 952,346 rows — these rows as CSV

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