PREVIEW / stock_1min / 2009-06-26

all stock 1-min files

  file:    by_date/stock_1min/2009/2009-06-26.parquet
  size:    14.6 MB
  rows:    1,100,155
  symbols: 2,704

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-06-26 07:08:00	AAPL	Stock	4.9907	4.9907	4.9907	4.9907	14000.0
2009-06-26 07:15:00	AAPL	Stock	4.9789	4.9789	4.9789	4.9789	5600.0
2009-06-26 07:17:00	AAPL	Stock	4.9789	4.9789	4.9789	4.9789	27580.0
2009-06-26 07:31:00	AAPL	Stock	4.9821	4.9821	4.9821	4.9821	5600.0
2009-06-26 07:48:00	AAPL	Stock	4.9821	4.9821	4.9821	4.9821	8400.0
2009-06-26 07:56:00	AAPL	Stock	4.9821	4.9821	4.9821	4.9821	18900.0
2009-06-26 08:04:00	AAPL	Stock	4.9861	4.9861	4.9857	4.9857	27440.0
2009-06-26 08:07:00	AAPL	Stock	4.9857	4.9857	4.9857	4.9857	3416.0
2009-06-26 08:11:00	AAPL	Stock	4.9893	4.9893	4.9893	4.9893	5600.0
2009-06-26 08:12:00	AAPL	Stock	4.9857	4.9857	4.9857	4.9857	2800.0
2009-06-26 08:13:00	AAPL	Stock	4.9821	4.9821	4.9821	4.9821	19936.0
2009-06-26 08:15:00	AAPL	Stock	4.9857	4.9857	4.9857	4.9857	2800.0
2009-06-26 08:18:00	AAPL	Stock	4.9857	4.9857	4.9857	4.9857	2800.0
2009-06-26 08:19:00	AAPL	Stock	4.9839	4.9857	4.9839	4.9839	8400.0
2009-06-26 08:20:00	AAPL	Stock	4.9821	4.9821	4.9821	4.9821	14000.0
2009-06-26 08:26:00	AAPL	Stock	4.9836	4.9839	4.9836	4.9836	27300.0
2009-06-26 08:29:00	AAPL	Stock	4.985	4.9893	4.985	4.9893	23800.0
2009-06-26 08:30:00	AAPL	Stock	4.9893	5.0	4.9893	4.9971	52024.0
2009-06-26 08:31:00	AAPL	Stock	5.0	5.0021	5.0	5.0018	107380.0
2009-06-26 08:32:00	AAPL	Stock	5.0018	5.0018	4.9996	5.0	235620.0
2009-06-26 08:33:00	AAPL	Stock	4.9929	4.9943	4.9929	4.9943	30800.0
2009-06-26 08:34:00	AAPL	Stock	4.9975	5.0071	4.9975	5.0036	138740.0
2009-06-26 08:36:00	AAPL	Stock	5.0036	5.0061	5.0036	5.0036	30800.0
2009-06-26 08:37:00	AAPL	Stock	5.0039	5.0061	5.0039	5.0059	8400.0
2009-06-26 08:38:00	AAPL	Stock	5.0068	5.0068	5.0032	5.0032	145068.0
2009-06-26 08:39:00	AAPL	Stock	5.0032	5.0032	5.0032	5.0032	70000.0
2009-06-26 08:40:00	AAPL	Stock	5.0021	5.0021	5.0021	5.0021	30800.0
2009-06-26 08:41:00	AAPL	Stock	5.0018	5.0018	5.0018	5.0018	5600.0
2009-06-26 08:43:00	AAPL	Stock	4.9989	4.9989	4.9982	4.9982	21280.0
2009-06-26 08:44:00	AAPL	Stock	4.9986	4.9986	4.9986	4.9986	19600.0
2009-06-26 08:45:00	AAPL	Stock	4.9982	5.0	4.9982	5.0	28980.0
2009-06-26 08:46:00	AAPL	Stock	4.9996	4.9996	4.9979	4.9979	62580.0
2009-06-26 08:49:00	AAPL	Stock	4.9996	4.9996	4.9964	4.9964	14784.0
2009-06-26 08:50:00	AAPL	Stock	4.9946	4.9946	4.9929	4.9929	17080.0
2009-06-26 08:52:00	AAPL	Stock	4.9925	4.9929	4.9925	4.9929	5600.0
2009-06-26 08:53:00	AAPL	Stock	4.9932	4.9932	4.9932	4.9932	2800.0
2009-06-26 08:54:00	AAPL	Stock	4.9982	4.9982	4.9982	4.9982	2800.0
2009-06-26 08:55:00	AAPL	Stock	4.9986	4.9986	4.9986	4.9986	19600.0
2009-06-26 08:56:00	AAPL	Stock	4.9979	4.9982	4.9979	4.9982	5600.0
2009-06-26 08:58:00	AAPL	Stock	4.9968	4.9968	4.9968	4.9968	2800.0
2009-06-26 08:59:00	AAPL	Stock	4.9932	4.9932	4.9932	4.9932	2800.0
2009-06-26 09:00:00	AAPL	Stock	4.9975	4.9975	4.9911	4.9932	22400.0
2009-06-26 09:04:00	AAPL	Stock	4.9929	4.9929	4.9929	4.9929	11200.0
2009-06-26 09:06:00	AAPL	Stock	4.9961	4.9961	4.9961	4.9961	16156.0
2009-06-26 09:08:00	AAPL	Stock	4.9961	4.9961	4.9961	4.9961	2800.0
2009-06-26 09:09:00	AAPL	Stock	4.9936	4.9936	4.9921	4.9921	34580.0
2009-06-26 09:12:00	AAPL	Stock	4.9961	4.9961	4.9961	4.9961	6496.0
2009-06-26 09:13:00	AAPL	Stock	4.9961	4.9964	4.9961	4.9964	5600.0
2009-06-26 09:14:00	AAPL	Stock	4.9993	4.9993	4.9993	4.9993	9800.0
2009-06-26 09:23:00	AAPL	Stock	4.9946	4.9946	4.9946	4.9946	2800.0

> showing 50 of 1,100,155 rows — these rows as CSV

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