PREVIEW / stock_1min / 2007-09-17

all stock 1-min files

  file:    by_date/stock_1min/2007/2007-09-17.parquet
  size:    10.6 MB
  rows:    870,725
  symbols: 2,539

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
2007-09-17 09:30:00	AAPL	Stock	4.9639	4.9704	4.9586	4.9632	8969576.0
2007-09-17 09:31:00	AAPL	Stock	4.9639	4.9875	4.9632	4.9843	7681968.0
2007-09-17 09:32:00	AAPL	Stock	4.985	4.9929	4.9814	4.9829	7252896.0
2007-09-17 09:33:00	AAPL	Stock	4.9829	4.9846	4.9693	4.9761	4391184.0
2007-09-17 09:34:00	AAPL	Stock	4.9757	4.9818	4.9736	4.9807	3487064.0
2007-09-17 09:35:00	AAPL	Stock	4.9807	4.9893	4.976	4.9825	4332468.0
2007-09-17 09:36:00	AAPL	Stock	4.9829	4.9961	4.9825	4.9932	5202820.0
2007-09-17 09:37:00	AAPL	Stock	4.9932	5.0	4.9929	5.0	9105964.0
2007-09-17 09:38:00	AAPL	Stock	5.0	5.0039	4.99	4.9929	9411220.0
2007-09-17 09:39:00	AAPL	Stock	4.9946	5.0171	4.9932	5.015	7961520.0
2007-09-17 09:40:00	AAPL	Stock	5.015	5.0171	5.0054	5.01	4614904.0
2007-09-17 09:41:00	AAPL	Stock	5.01	5.0211	5.0075	5.0143	6819176.0
2007-09-17 09:42:00	AAPL	Stock	5.0143	5.0154	5.0025	5.0032	4923184.0
2007-09-17 09:43:00	AAPL	Stock	5.0032	5.0118	5.0021	5.0068	4746644.0
2007-09-17 09:44:00	AAPL	Stock	5.0068	5.0125	5.0043	5.0096	3810856.0
2007-09-17 09:45:00	AAPL	Stock	5.01	5.0104	5.0054	5.0084	3204152.0
2007-09-17 09:46:00	AAPL	Stock	5.0074	5.0118	5.0021	5.0104	4472888.0
2007-09-17 09:47:00	AAPL	Stock	5.0104	5.0125	5.0079	5.0079	3396848.0
2007-09-17 09:48:00	AAPL	Stock	5.0079	5.0079	5.0007	5.0043	3303132.0
2007-09-17 09:49:00	AAPL	Stock	5.0039	5.0111	5.0031	5.0071	3627232.0
2007-09-17 09:50:00	AAPL	Stock	5.0064	5.0079	4.9932	5.0011	5731852.0
2007-09-17 09:51:00	AAPL	Stock	5.0004	5.0004	4.9932	4.9961	4101160.0
2007-09-17 09:52:00	AAPL	Stock	4.9961	5.0014	4.9861	4.9896	4073580.0
2007-09-17 09:53:00	AAPL	Stock	4.9893	5.0	4.9893	4.9954	3638348.0
2007-09-17 09:54:00	AAPL	Stock	4.9943	4.9975	4.9896	4.9968	3035396.0
2007-09-17 09:55:00	AAPL	Stock	4.9971	4.9989	4.995	4.9954	1886360.0
2007-09-17 09:56:00	AAPL	Stock	4.9954	5.0061	4.9954	5.0018	3974124.0
2007-09-17 09:57:00	AAPL	Stock	5.0015	5.0046	4.9986	5.0001	2388764.0
2007-09-17 09:58:00	AAPL	Stock	5.0007	5.0007	4.9946	4.9962	2469488.0
2007-09-17 09:59:00	AAPL	Stock	4.9966	4.9982	4.9925	4.9968	2809156.0
2007-09-17 10:00:00	AAPL	Stock	4.9968	5.0	4.995	4.995	1952104.0
2007-09-17 10:01:00	AAPL	Stock	4.995	5.0014	4.9946	4.9981	3224620.0
2007-09-17 10:02:00	AAPL	Stock	4.9975	4.9982	4.9857	4.9896	4523624.0
2007-09-17 10:03:00	AAPL	Stock	4.9893	4.99	4.9811	4.9825	4788280.0
2007-09-17 10:04:00	AAPL	Stock	4.9831	4.9861	4.975	4.9789	4132996.0
2007-09-17 10:05:00	AAPL	Stock	4.9786	4.9911	4.9775	4.9886	3607884.0
2007-09-17 10:06:00	AAPL	Stock	4.9882	4.9914	4.985	4.9864	3152744.0
2007-09-17 10:07:00	AAPL	Stock	4.9864	4.9879	4.9761	4.9843	4895352.0
2007-09-17 10:08:00	AAPL	Stock	4.9836	4.9861	4.9814	4.9825	2121672.0
2007-09-17 10:09:00	AAPL	Stock	4.9821	4.9911	4.9821	4.9889	2422868.0
2007-09-17 10:10:00	AAPL	Stock	4.9889	4.9979	4.9889	4.9957	2845836.0
2007-09-17 10:11:00	AAPL	Stock	4.9954	5.0032	4.9946	5.0032	4317208.0
2007-09-17 10:12:00	AAPL	Stock	5.0036	5.0036	4.9971	5.0029	3266256.0
2007-09-17 10:13:00	AAPL	Stock	5.003	5.0036	4.9957	4.9971	2193380.0
2007-09-17 10:14:00	AAPL	Stock	4.9968	5.0018	4.9957	5.0007	1912596.0
2007-09-17 10:15:00	AAPL	Stock	5.0002	5.0075	5.0002	5.0064	3454528.0
2007-09-17 10:16:00	AAPL	Stock	5.0061	5.0089	5.0025	5.0036	2693824.0
2007-09-17 10:17:00	AAPL	Stock	5.0039	5.0061	4.9954	4.9954	2796388.0
2007-09-17 10:18:00	AAPL	Stock	4.9961	4.9982	4.9929	4.9929	3987788.0
2007-09-17 10:19:00	AAPL	Stock	4.9925	4.9968	4.9904	4.9946	2400412.0

> showing 50 of 870,725 rows — these rows as CSV

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