PREVIEW / stock_1min / 2009-01-16

all stock 1-min files

  file:    by_date/stock_1min/2009/2009-01-16.parquet
  size:    12.2 MB
  rows:    939,951
  symbols: 2,696

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-01-16 05:07:00	AAPL	Stock	3.0336	3.0336	3.0336	3.0336	2800.0
2009-01-16 06:53:00	AAPL	Stock	3.0318	3.0318	3.0318	3.0318	5600.0
2009-01-16 06:54:00	AAPL	Stock	3.0336	3.0336	3.0336	3.0336	5600.0
2009-01-16 07:03:00	AAPL	Stock	3.0246	3.0246	3.0143	3.0143	8400.0
2009-01-16 07:04:00	AAPL	Stock	3.0143	3.0143	3.0143	3.0143	9800.0
2009-01-16 07:23:00	AAPL	Stock	3.0171	3.0171	3.0171	3.0171	2800.0
2009-01-16 07:27:00	AAPL	Stock	3.0179	3.0179	3.0179	3.0179	3108.0
2009-01-16 07:28:00	AAPL	Stock	3.0275	3.0275	3.0179	3.0179	10220.0
2009-01-16 07:30:00	AAPL	Stock	3.0214	3.0214	3.0214	3.0214	2800.0
2009-01-16 07:32:00	AAPL	Stock	3.025	3.025	3.025	3.025	14000.0
2009-01-16 07:33:00	AAPL	Stock	3.0143	3.0143	3.0143	3.0143	4200.0
2009-01-16 07:35:00	AAPL	Stock	3.0114	3.0114	3.0114	3.0114	8400.0
2009-01-16 07:47:00	AAPL	Stock	3.005	3.005	2.9993	3.0032	40600.0
2009-01-16 07:48:00	AAPL	Stock	3.0032	3.0032	3.0032	3.0032	8400.0
2009-01-16 07:49:00	AAPL	Stock	3.0032	3.0139	3.0032	3.0139	78400.0
2009-01-16 07:57:00	AAPL	Stock	3.0004	3.0004	3.0	3.0	5600.0
2009-01-16 08:00:00	AAPL	Stock	3.0	3.0082	3.0	3.0036	80528.0
2009-01-16 08:01:00	AAPL	Stock	3.0036	3.0036	3.0036	3.0036	2800.0
2009-01-16 08:02:00	AAPL	Stock	3.0054	3.0096	3.0054	3.0096	22400.0
2009-01-16 08:03:00	AAPL	Stock	3.01	3.01	3.0071	3.0071	19600.0
2009-01-16 08:04:00	AAPL	Stock	3.0071	3.0071	3.0	3.0	50792.0
2009-01-16 08:07:00	AAPL	Stock	3.0	3.0	3.0	3.0	13188.0
2009-01-16 08:08:00	AAPL	Stock	2.9982	2.9982	2.9939	2.9939	49280.0
2009-01-16 08:09:00	AAPL	Stock	2.9964	2.9964	2.9964	2.9964	28000.0
2009-01-16 08:10:00	AAPL	Stock	2.9964	2.9964	2.9939	2.9939	33600.0
2009-01-16 08:11:00	AAPL	Stock	2.9964	2.9964	2.9954	2.9954	14000.0
2009-01-16 08:12:00	AAPL	Stock	2.9964	2.9964	2.9954	2.9964	39200.0
2009-01-16 08:13:00	AAPL	Stock	2.9961	2.9961	2.9961	2.9961	2800.0
2009-01-16 08:14:00	AAPL	Stock	2.9954	2.9954	2.9954	2.9954	14000.0
2009-01-16 08:15:00	AAPL	Stock	2.9929	2.9943	2.9929	2.9943	16100.0
2009-01-16 08:17:00	AAPL	Stock	2.9961	2.9964	2.9961	2.9964	30100.0
2009-01-16 08:18:00	AAPL	Stock	2.9946	2.9946	2.9929	2.9929	27888.0
2009-01-16 08:19:00	AAPL	Stock	2.9946	2.9946	2.9946	2.9946	2800.0
2009-01-16 08:20:00	AAPL	Stock	2.9964	2.9964	2.9932	2.9932	30800.0
2009-01-16 08:21:00	AAPL	Stock	2.9929	2.9932	2.9929	2.9932	7280.0
2009-01-16 08:24:00	AAPL	Stock	2.9957	2.9957	2.9957	2.9957	2800.0
2009-01-16 08:25:00	AAPL	Stock	2.9964	2.9964	2.9961	2.9961	107324.0
2009-01-16 08:26:00	AAPL	Stock	2.9964	2.9964	2.9964	2.9964	46704.0
2009-01-16 08:27:00	AAPL	Stock	2.9982	2.9982	2.9975	2.9975	11200.0
2009-01-16 08:28:00	AAPL	Stock	2.9982	2.9982	2.9979	2.9979	8400.0
2009-01-16 08:29:00	AAPL	Stock	2.9979	2.9979	2.9979	2.9979	28000.0
2009-01-16 08:30:00	AAPL	Stock	2.9996	3.0036	2.9996	3.0007	39256.0
2009-01-16 08:31:00	AAPL	Stock	3.0	3.0	3.0	3.0	5600.0
2009-01-16 08:32:00	AAPL	Stock	3.0	3.0	2.9979	3.0	37100.0
2009-01-16 08:33:00	AAPL	Stock	3.0	3.0	3.0	3.0	30800.0
2009-01-16 08:34:00	AAPL	Stock	2.9996	3.0011	2.9996	3.0011	28000.0
2009-01-16 08:35:00	AAPL	Stock	3.0	3.0	3.0	3.0	8680.0
2009-01-16 08:36:00	AAPL	Stock	3.0	3.0	3.0	3.0	2800.0
2009-01-16 08:37:00	AAPL	Stock	2.9996	3.0	2.9996	3.0	15540.0
2009-01-16 08:38:00	AAPL	Stock	2.9996	3.0	2.9996	3.0	26600.0

> showing 50 of 939,951 rows — these rows as CSV

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